How to Record Amazon Settlements in Zoho Books (Step by Step)

If you sell on Amazon and keep your books in Zoho Books, you know the fortnightly headache: Amazon drops one lump sum into your bank, but that number matches almost nothing in your accounts. Behind that single payout sit hundreds of transactions — sales, dozens of fee types, refunds, reserves, and (if you're VAT-registered) VAT. Recording it correctly is what keeps your financials accurate, your VAT return right, and your accountant happy.

This guide covers exactly what's in an Amazon settlement, how to record it in Zoho Books by hand, and how to reconcile it to your actual payout — plus the mistakes that trip up most sellers.

What is an Amazon settlement report?

Amazon pays you on a settlement cycle — roughly every 14 days. At the end of each cycle it produces a settlement report, which you download from Seller Central → Payments → Reports → Repository (the flat file). That report is the source of truth for your bookkeeping. It lists every transaction in the period, grouped into types such as:

• Product sales (Principal) — the item price your customer paid
• Shipping and gift-wrap charges
• Promotional rebates — discounts you funded
• Amazon fees — referral/commission, FBA fulfilment fees, storage fees, and more
• Refunds — returned orders, plus any refunded fees
• Advertising costs, when deducted here
• Reserves — amounts Amazon holds back and releases later
• VAT baked into the above (in VAT jurisdictions like the UAE)

The net of all of these is your payout — the one figure that hits your bank.

Why you can't just book the payout as "sales"

It's tempting to record the bank deposit as a single sales entry. Don't. If you book the net payout as revenue, you've:

• Understated your true revenue — your gross sales were much higher before fees and refunds
• Hidden your fees — referral, FBA, storage and ads (often 25–40% of revenue) never appear as expenses
• Mangled your VAT — output VAT on sales and input VAT on fees are lost
• Broken your margin and profit reporting

Accurate books require splitting that one payout back into its parts.

How to record an Amazon settlement in Zoho Books (manual method)

The cleanest manual approach is a journal entry per settlement. Here's the workflow.

1. Set up your accounts once

In your Zoho Books Chart of Accounts, create the accounts you'll post to:

• Income: Amazon Sales
• Expenses: Amazon Referral Fees, FBA Fees, Storage Fees, Advertising, Refunds/Returns
• Bank/Clearing: an "Amazon Clearing" holding account the payout clears through, plus your actual bank account
• (VAT-registered only): your Output VAT and Input VAT accounts

2. Summarise the settlement by category

Open the settlement report and total each transaction type — total product sales, total referral fees, total FBA fees, total refunds, and so on. A pivot table in a spreadsheet is the usual way.

3. Post the journal entry

Create a journal dated to the settlement's deposit date:

• Credit Amazon Sales for total (net) sales
• Debit each fee expense account for its total
• Debit Refunds for returned amounts
• (VAT-registered): Credit Output VAT on sales, Debit Input VAT on fees
• Debit your Amazon Clearing account for the net payout

The entry must balance, and the Clearing figure should equal the payout Amazon quoted.

4. Match the payout to your bank

When Amazon's deposit lands, record a transfer from Amazon Clearing to your bank for the payout amount. Your clearing account now nets to zero and the deposit is reconciled.

The hard part: reconciling to the cent

The whole point is that your entry ties to the exact payout. If your journal's clearing figure is even a few cents off the deposit, something is miscategorised — a fee type you missed, a reserve, or a rounding difference. Chasing that gap by hand, every fortnight, across dozens of line-item types, is where sellers lose hours and where errors slip in.

VAT: the UAE wrinkle

If you're a VAT-registered seller on amazon.ae, there's an extra step. Amazon's prices and fees are VAT-inclusive, and Amazon does not provide a per-transaction VAT report in the region — so you have to extract the 5% yourself: output VAT on your sales, input VAT on Amazon's fees. Get this wrong and your FTA VAT-201 return is wrong.

US sellers can skip this — Amazon collects and remits US sales tax as the marketplace facilitator, so there's no VAT to record.

Common mistakes to avoid

• Booking the payout as revenue — the number-one error.
• Ignoring reserves — an unreleased reserve makes your payout smaller than your sales; account for it or your clearing won't tie.
• Forgetting refunded fees — when an order is refunded, Amazon often refunds part of the fee too.
• Missing a settlement — skip one cycle and your books have a gap that's painful to find later.
• Mis-extracting VAT — applying it to the wrong base, or forgetting input VAT on fees.

The faster way: automate it

Doing this by hand is possible — but it's the same tedious, error-prone hour every two weeks, forever. This is exactly the job LinkSpring was built for: upload the settlement file Amazon gives you, and it posts every line to the right Zoho Books accounts — sales, fees, refunds and VAT — reconciled to the cent against your actual payout before anything is written. If it doesn't balance, it's flagged, not posted. For VAT-registered sellers it extracts the 5% automatically and hands you the exact VAT-return figures.

You get the clean, accurate books above — without the fortnightly spreadsheet.

FAQ

Where do I find my Amazon settlement report? Seller Central → Payments → Reports → Repository → download the settlement flat file for the period.

Should I use invoices or journal entries in Zoho Books? Summary journal entries are simplest and enough for most sellers. Per-product invoices are only worth it if you track inventory and COGS inside Zoho and keep every SKU as an item there.

Do US Amazon sellers need to record VAT? No. Amazon collects and remits US sales tax as the marketplace facilitator, so there's no VAT to record — just sales, fees and refunds.

How often should I record settlements? Every cycle (about every two weeks), so your books never fall behind and each payout reconciles cleanly.

---

Ready to stop doing this by hand? Start a free 14-day trial of LinkSpring — no credit card required.