The files you need
- Payouts
- Columns
Payout,Amount - Orders with fees
- Columns
Payout,Amount,Fee
Other columns can stay in the file. Only the ones above are checked, so an extra column never stops a run.
How the rows are matched
A row matches when payouts “Payout” equals orders with fees “Payout”. Several orders with fees rows can add up to one payouts row: their “Amount” is summed and the “Fee” is taken off. Amounts in “Amount” may differ by up to 0.01 and still match.
Every row ends in one class: Matched, Values differ, Only in the payouts file, Only in the orders with fees file, Ambiguous, or Duplicate in file.
Steps
- Export both files for the same period, as CSV or Excel.
- Open the tp-03 template in the app and drop the payouts on the left, the orders with fees on the right.
- Clean anything the preview shows: stray spaces, mixed date formats, a renamed header. Each fix becomes a step.
- Save the recipe and press Run. Read the rows that are not Matched first.
- Next month, drop the new exports and press Run again. Last month's open rows come back with their age.
Common problems
- A key has spaces or a different case. “SO-1003” and “ SO-1003” are different strings. Add a Trim step, and an Upper-case step if one system lowers its codes.
- The export renamed a column. The run stops and names the missing column. Rename it back in the export, or add a Rename step.
- A row appears twice in one file. It is marked Duplicate in file rather than matched twice.
Transcript
The short video for this guide is being recorded. Its full transcript will be published here with it.
Next guide: How to reconcile an Amazon settlement with orders
