Amazon settlement bookkeeping for Zoho Books

What an Amazon settlement report actually is

Amazon closes your account on a settlement cycle — roughly every 14 days — and produces a settlement report for that period. You download it from Seller Central under Payments → Reports → Repository as a flat file, and it is the source of truth for your bookkeeping.

It is not a summary. A single fortnight can run to thousands of rows across dozens of transaction types: principal, shipping and gift-wrap charges, promotional rebates, referral fees, FBA fulfilment and storage fees, advertising, refunds, reimbursements and reserve movements. The net of every one of those lines is the figure that reaches your bank.

That structure is why a settlement cannot be booked as a single sales entry — doing so understates your revenue and hides your costs entirely. How to record Amazon settlements in Zoho Books covers summarising the report by category and posting it as one balanced journal.

Why your payout never matches your bank

The deposit Amazon sends is a net figure: gross sales, minus fees, minus refunds, minus any reserve Amazon is holding back, plus any reserve it has released from an earlier cycle. Your sales for a period and your payout for that period are therefore almost never the same number — and they are not supposed to be.

Reserves are the part that catches people out. Money withheld this cycle shows up in your sales but not your bank; when it is released weeks later it shows up in your bank but not your sales. Treating the reserve as an asset, rather than ignoring it, is what lets a settlement tie.

Why your Amazon payout never matches your bank breaks down what is actually inside that number, and how to reconcile an Amazon payout to your bank in Zoho Books gives the clearing-account method that makes it reconcile to the cent.

What belongs in a Zoho Books chart of accounts

You need surprisingly few accounts, but you need the right ones. At minimum: an income account for Amazon sales; separate expense accounts for referral fees, FBA fees, storage fees and advertising, so you can see which one is eating your margin; an account for refunds and returns; an asset account for the reserve; and — the one that does the real work — an Amazon Clearing account.

Clearing is what turns an unmatched deposit into a reconciliation. You post the whole settlement through it: sales credited, fees and refunds debited, the net landing in clearing. When Amazon’s deposit arrives, you transfer that amount from clearing to your bank. If clearing does not return to zero, something is miscategorised — and that zero-balance check is the entire point. Run one clearing account per marketplace, since amazon.com and amazon.ae settle in different currencies on different cycles.

How VAT differs between amazon.com and amazon.ae

The two marketplaces are not the same accounting problem. On amazon.com there is no VAT to record at all: Amazon acts as the marketplace facilitator, collecting and remitting US sales tax itself, so your books deal only with sales, fees and refunds.

On amazon.ae, a VAT-registered seller has to account for the UAE’s 5%. Amazon’s prices and fees there are VAT-inclusive, so the tax is extracted rather than added — VAT = amount × 5 ÷ 105 — and it runs both ways: output VAT on your sales, input VAT on Amazon’s fees, with the difference going on your FTA VAT-201 return. Get the base wrong and the return is wrong. Amazon FBA VAT in the UAE covers registration thresholds, the extraction maths and what to file.