Amazon India settlement reconciliation
“match the amazon seller central india transactions to our tally sales register by order id, show invoice vs product sales, amazon-kept fees and taxes, and status as Paid, Short paid, Unpaid, or Not in sales register”
Match the Amazon Seller Central India transaction report to our Tally sales register by order id, show invoice vs product sales, amazon-kept fees and taxes, and status as Paid, Short paid, Unpaid, or Not in sales register, with Paid comparing gross: invoice vs product sales.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileAmazon Seller Central India transaction reportCSV export · 28 rows
- FileTally sales registerCSV export · 30 rows
- StepMake Amazon match keyStep 1
- StepMake Tally match keyStep 2
- JoinMatch the Tally register27 of 28 paired
- StepSet payment statusStep 4
- ResultAmazon Sales Match31 rows · 6 flagged
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 31 rows.
- Download Amazon Seller Central India transaction report sample (28 rows)Amazon Seller Central India: Payments > Date Range Transaction Report > Export
- Download Tally sales register sample (30 rows)Tally: Reports > Sales Register > Export
What you get back
The result of that run, the rows to look at first.
| Order ID | Invoice value | Product sales | Amazon-kept fees | Amazon taxes withheld | Status | Voucher number | Invoice date | Amazon date | Amazon transactions line # | Tally register line # |
|---|---|---|---|---|---|---|---|---|---|---|
| 403-1234567-1099 | · | 1,180 | 100 | 6 | Not in sales register | · | · | 2026-10-27 | 28 | · |
| 403-1234567-1007 | 1,180 | 944 | 115 | 4.80 | Short paid | SR-0007 | 2026-10-04 | 2026-10-04 | 7 | 7 |
| 403-1234567-1024 | 1,770 | 1,652 | 80 | 8.40 | Short paid | SR-0024 | 2026-10-20 | 2026-10-20 | 22 | 24 |
| 403-1234567-1012 | 590 | · | · | · | Unpaid | SR-0012 | 2026-10-08 | · | · | 12 |
| 403-1234567-1021 | 1,298 | · | · | · | Unpaid | SR-0021 | 2026-10-17 | · | · | 21 |
| 403-1234567-1028 | 2,124 | · | · | · | Unpaid | SR-0028 | 2026-10-24 | · | · | 28 |
| 403-1234567-1001 | 590 | 590 | 65 | 3 | Paid | SR-0001 | 2026-10-01 | 2026-10-01 | 1 | 1 |
| 403-1234567-1002 | 708 | 708 | 80 | 3.60 | Paid | SR-0002 | 2026-10-01 | 2026-10-01 | 2 | 2 |
| 403-1234567-1003 | 826 | 826 | 100 | 4.20 | Paid | SR-0003 | 2026-10-02 | 2026-10-02 | 3 | 3 |
| 403-1234567-1004 | 944 | 944 | 115 | 4.80 | Paid | SR-0004 | 2026-10-03 | 2026-10-03 | 4 | 4 |
| 403-1234567-1005 | 1,062 | 1,062 | 135 | 5.40 | Paid | SR-0005 | 2026-10-03 | 2026-10-03 | 5 | 5 |
| 403-1234567-1006 | 1,180 | 1,180 | 65 | 6 | Paid | SR-0006 | 2026-10-04 | 2026-10-04 | 6 | 6 |
How it works
How to use the Amazon Sales Match workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Amazon Sales Match: questions
How do you reconcile Amazon settlements against your Tally sales register?
Which export should you use from Amazon Seller Central?
What happens to rows that do not match by order ID?
How do you change the matching rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Bank to ledger, payouts to deposits, returns to books. Every row comes back matched, or flagged with the reason.
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Match customer payments to open invoicesMatch bank payments to QuickBooks open invoices by customer and amount, and see what is still unapplied.See the workflow Built by the agent
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.See the workflow Built by the agent