How to Reconcile an Amazon Payout to Your Bank in Zoho Books

Amazon's deposit lands in your bank. It appears in your Zoho Books banking feed as an uncategorised transaction — say AED 18,432.17 — and there is nothing in your books it will match against. So it sits there, week after week, while the "Uncategorised" count climbs.

The fix isn't to find a matching invoice. There isn't one. The fix is to stop trying to match the deposit to your sales at all, and instead route everything through a clearing account. Once that's in place, every payout reconciles to the cent, and the bank feed matches in one click.

This guide walks through the method. If you haven't yet recorded the settlement itself, start with how to record Amazon settlements in Zoho Books — this post picks up where that one ends.

Why the payout never matches on its own

The number Amazon deposits is a net figure. Before it reaches your bank, Amazon has already subtracted referral fees, FBA fulfilment fees, storage, advertising, refunds, and a held-back reserve — and in VAT jurisdictions, VAT sits inside several of those lines.

So your gross sales for the period might be AED 31,000 while the deposit is AED 18,432.17. Nothing in your chart of accounts equals AED 18,432.17, because that figure is an arithmetic result, not a transaction. We go into the full breakdown in why your Amazon payout never matches your bank.

What "reconciled" actually means here

Reconciliation is not "the deposit is categorised". It's a stronger test:

After you've posted the settlement and the payout, the Amazon Clearing account balance returns to zero (or to exactly the reserve Amazon is still holding).

If the clearing account nets to zero, every line in that settlement has been accounted for. If it doesn't, something is missing or double-counted — and the difference tells you how much. That is the whole point of the method: it gives you a self-checking figure instead of a feeling.

Step 1: Create an Amazon Clearing account

In Zoho Books, go to Accountant → Chart of Accounts → + New.

• Account Type: Other Current Asset (or Bank, if you prefer it to appear in the Banking module — both work; Other Current Asset keeps the Banking screen cleaner)
• Account Name: Amazon Clearing — US (create a separate one per marketplace, e.g. Amazon Clearing — UAE)
• Currency: the settlement currency, not your base currency. A US settlement is USD even if your books are in AED.

Do this once per marketplace. Mixing marketplaces in one clearing account is the single fastest way to lose the ability to reconcile.

While you're in the chart of accounts, make sure you also have expense accounts for the fee groups you'll be posting — referral/commission, fulfilment, storage, advertising — plus an income account for sales and a contra-income account for refunds.

Step 2: Post the settlement to the clearing account

Download the settlement flat file from Seller Central → Payments → Reports → Repository, summarise it by transaction type, and post a journal entry (Accountant → Manual Journals → + New) for the settlement period.

The shape of it:

Account	Debit	Credit
Amazon Clearing	net payout amount
Referral fees (expense)	x
FBA fulfilment fees (expense)	x
Storage fees (expense)	x
Advertising (expense)	x
Refunds (contra-income)	x
Reserve held (asset)	x
Product sales (income)		gross sales
VAT payable / input VAT	as applicable	as applicable

The debits and credits must balance — Zoho Books won't save the journal otherwise, which is a useful first check. The Amazon Clearing debit should equal the payout Amazon says it is sending you.

For the UAE VAT treatment specifically — output VAT on your sales and input VAT on Amazon's fees — see Amazon FBA VAT in the UAE.

Step 3: Record the payout as a transfer, not as income

This is where most sellers go wrong.

When the deposit arrives, go to Banking, find the uncategorised transaction, and categorise it as a Transfer From your Amazon Clearing account to your bank account. Not "Sales". Not "Other Income". A transfer.

Why it matters: the revenue was already recognised in Step 2, at the point of the settlement. Booking the deposit as income again would double-count your sales and inflate your revenue by the net amount. Moving money from clearing to bank is exactly what the deposit is — a transfer between two accounts you already own.

If your clearing account is in USD and your bank account is in AED, Zoho Books will apply an exchange rate on the transfer. Use the rate on the date the money actually hit your bank, and post any difference to a realised FX gain/loss account.

Step 4: Check the clearing account

Go to Reports → Account Transactions, select Amazon Clearing, and set the date range to cover the settlement period.

The balance should be:

• Zero, if Amazon released everything, or
• Exactly the reserve amount Amazon is still holding

Anything else is a discrepancy, and the amount points at the cause.

When the clearing account doesn't go to zero

The usual culprits, in rough order of frequency:

1. A fee type you didn't map. Amazon has 40+ transaction type codes and adds new ones. If your summary only covers the ones you knew about last quarter, the remainder lands nowhere. Reconcile by transaction type, not by memory.
2. Reserve movement. Amazon released a reserve from a previous period inside this settlement. That release is a credit to your Reserve asset account, not new income.
3. A settlement that straddles month-end. Amazon's cycle doesn't respect your accounting month. Post the settlement on its own dates and let it fall where it falls — don't split it to make a month look tidy.
4. Chargebacks and reimbursements posted as sales instead of as their own lines.
5. Rounding on multi-currency conversion. Small, but it will stop you reaching exactly zero. Post the remainder to FX gain/loss.
6. Two marketplaces sharing one clearing account. As above — separate them.

Common mistakes to avoid

• Categorising the deposit as "Sales". Double-counts revenue and hides every fee.
• Booking fees only when you notice them. They belong in the same journal as the sales they relate to, in the same period.
• Using your base currency for the clearing account. You'll chase FX differences forever.
• Reconciling monthly instead of per settlement. Settlement is the natural unit. Monthly aggregation destroys your ability to trace a difference back to a line.

FAQ

Should the Amazon Clearing account be a Bank account or an Other Current Asset? Either works. Bank type makes it appear in the Banking module and lets you use Zoho's matching tools; Other Current Asset keeps Banking uncluttered. Pick one and stay consistent.

Do I need a separate clearing account per marketplace? Yes. amazon.com settles in USD and amazon.ae settles in AED, on different cycles with different fee structures and different VAT treatment. One account per marketplace is what makes the zero-balance check meaningful.

What about the reserve Amazon holds back? Treat it as an asset — it's your money, held by someone else. Debit a Reserve account when it's withheld, credit it when Amazon releases it in a later settlement.

How often should I do this? Every settlement, roughly fortnightly. Letting three or four settlements pile up makes a discrepancy far harder to trace, because you can no longer tell which cycle it came from.

My bank deposit is a few cents off the settlement total. Is that a problem? If your books are multi-currency, it's usually FX rounding — post it to realised FX gain/loss. If you're single-currency and it's off, something is genuinely missing; don't force it with a balancing entry.

Does Zoho Books have a native Amazon integration for this? Zoho Inventory connects to Amazon for orders and stock, but it doesn't reconcile settlement payouts into Zoho Books at the fee-line level. That gap is why most sellers end up doing the journal entry by hand.

---

The faster way

Doing this properly takes an hour or two per settlement once you know the method — and it has to be done every fortnight, for every marketplace, forever.

LinkSpring does it in one click. Upload the settlement report and it maps every line to your Zoho Books accounts, handles the reserve and the VAT, and shows you Matches ✓ — Difference 0.00 before anything is written to your books. If it doesn't reconcile to the cent, it doesn't post.

Works on Amazon US and UAE marketplaces. Flat $19/mo, 14-day free trial, no card.

LinkSpring is a bookkeeping helper, not a tax advisor — confirm the treatment of your own accounts with your accountant.