Amazon Marketplace Reconciliation: A Practical Guide for Growing Brands

For most D2C and e-commerce brands, Amazon is more than a sales channel — it is its own mini accounting system, complete with settlement cycles, fee schedules and reserves that rarely line up neatly with the rest of the books. Marketplace reconciliation is the process of matching what Amazon reports against what actually lands in the bank and what sits on the shelves, and getting it wrong quietly erodes margins that look fine on paper.

What's actually inside a settlement report

Amazon pays out on a settlement cycle rather than per order, and each settlement bundles together several very different line items: product sales, customer refunds and returns, FBA pick-and-pack and storage fees, referral commissions, advertising spend, and in some cases long-term storage or reserve holdbacks. Treating the settlement deposit as a single "Amazon sales" figure is the single most common source of messy books, because it blends revenue with cost of sale and marketing spend into one number.

Where the mismatches usually show up

A few patterns come up again and again when we reconcile marketplace accounts:

• Orders dispatched in one month are often settled and paid in the next, so revenue booked on order date won't match the cash that arrives.
• Refunds and return-related fees are netted against future settlements rather than reversed immediately, which can understate receivables.
• Advertising spend is deducted directly from settlements, so it needs to be reclassified as a marketing expense rather than left buried inside "Amazon fees."
• Reserve balances held back by Amazon are real assets that are easy to lose track of if they aren't tracked on the balance sheet separately.

A simple reconciliation workflow that works

The brands that stay clean month over month tend to follow the same basic sequence: pull the settlement report and the transaction-level report for the period, split every line item into its correct ledger head (sales, returns, referral fees, FBA fees, advertising, reserves), match the net settlement amount to the actual bank deposit, and flag anything that doesn't tie out for review before closing the month. Doing this consistently, rather than only when something looks off, is what keeps GST and TDS filings accurate and MIS reporting trustworthy.

Why automation changes the picture

Doing this by hand in a spreadsheet works for a while, but it breaks down as order volume grows. Connecting the storefront and marketplace data feeds directly into the ledger means every settlement is split and categorised automatically, exceptions are flagged instead of buried, and the monthly close happens in hours instead of days. That's the same approach we use for the e-commerce and D2C brands we work with — automation handles the repetitive matching, and an accountant reviews the judgement calls.

If marketplace reconciliation is eating up your team's time or your numbers never quite tie out, we're happy to take a look at your settlement reports and show you where the gaps are.

Talk to us on WhatsApp ← Back to all posts