Ecommerce + Zoho
How to Reconcile Amazon Settlements in Zoho Books
Amazon settlement reports are notoriously messy. They bundle product sales, refunds, FBA fees, advertising costs, and reimbursements into a single biweekly deposit. If you're using Zoho Books as your accounting system, reconciling that lump sum against individual transactions is the single most important thing you can get right. Here's exactly how to do it.
Why Amazon Reconciliation Breaks Most Accounting Setups
Amazon doesn't deposit money per order. It batches everything into a settlement, typically every 14 days. That settlement includes gross sales, marketplace facilitator tax collected (and remitted by Amazon), FBA storage and fulfillment fees, referral fees, advertising spend, refund amounts, and various adjustments.
Most ecommerce businesses do one of two things: they either record the net deposit as "Amazon Revenue" (which massively understates gross revenue and hides fee visibility), or they try to manually match each line — which is unsustainable past a few hundred orders per month.
The goal is a clean middle ground: automatically break each settlement into its component parts inside Zoho Books so your P&L actually reflects gross revenue, COGS, fees, and net margin.
Step 1: Download Your Amazon Settlement Report
In Amazon Seller Central, go to Reports → Payments → All Statements. Select the settlement period you want to reconcile. Download the V2 flat file (TSV format) — it contains every transaction-level line item in the settlement.
Key columns you'll need:
- transaction-type — Order, Refund, Service Fee, Adjustment, Transfer
- amount-type — ItemPrice, ItemFees, Promotion, etc.
- amount — the actual dollar (or local currency) figure
- order-id — for matching to specific sales orders
You'll also see your settlement total at the bottom. This is the number that should match the bank deposit in Zoho Books.
Step 2: Set Up Your Zoho Books Chart of Accounts
Before importing anything, make sure your chart of accounts can handle the granularity. At minimum, create these accounts:
- Amazon Gross Revenue (Income account) — total product sales before fees
- Amazon Refunds (Income contra account or Expense) — returned order amounts
- Amazon FBA Fees (Expense) — fulfillment, storage, removal fees
- Amazon Referral Fees (Expense) — the marketplace commission
- Amazon Advertising Fees (Expense) — Sponsored Products, Brands, Display
- Amazon Other Adjustments (Expense or Income) — reimbursements, miscellaneous
- Amazon Settlement Clearing (Other Current Asset) — the reconciliation hub
The clearing account is the key. Every settlement line item gets booked against it, and the net balance should equal the bank deposit. When you match the deposit in bank reconciliation, the clearing account zeroes out.
Step 3: Book the Settlement in Zoho Books
For each settlement, create a journal entry (or a set of invoices/bills — more on that below) that breaks down the components:
- Debit Amazon Settlement Clearing for gross product sales
- Credit Amazon Gross Revenue for the same amount
- Credit Amazon Settlement Clearing for each fee category (referral, FBA, advertising)
- Debit the corresponding expense accounts
- Handle refunds as a credit to Amazon Settlement Clearing and debit to Amazon Refunds
When you're done, the net balance in the clearing account for that settlement period should exactly match the deposit amount in your bank feed. Match them during bank reconciliation, and you're clean.
The Manual Method vs. Journal Entries
Some accountants prefer creating actual sales invoices per order in Zoho Books (one invoice per Amazon order) and then marking them as paid from the clearing account. This gives you order-level detail in your receivables. It's more work, but it's gold for SKU-level profitability analysis — especially when combined with Zoho Analytics reporting.
Step 4: Automate With SyncTools.ai
Doing this manually works for low-volume sellers, but once you're processing hundreds of orders per settlement, you need automation. SyncTools.ai connects Amazon Seller Central to Zoho Books and handles the heavy lifting:
- Automatically imports settlement data and creates itemized journal entries in Zoho Books
- Maps each Amazon fee type to the correct expense account
- Handles multi-currency settlements (critical if you sell on Amazon UK, EU, or UAE marketplaces)
- Reconciles the clearing account balance against the bank deposit
Other tools like A2X and Synder offer similar functionality. A2X is popular in the bookkeeper community and creates summary invoices per settlement. Synder takes a per-transaction approach. SyncTools.ai is purpose-built for the Zoho ecosystem, so it maps natively to Zoho Books entities without needing middleware.
Common Pitfalls
Marketplace Facilitator Tax
In many US states and international jurisdictions, Amazon collects and remits sales tax on your behalf. This money never hits your bank account. Do not record it as revenue or as a tax liability — it flows through Amazon's books, not yours. Make sure your import process excludes these amounts or journals them to a pass-through account.
FBA Reimbursements
Amazon occasionally reimburses you for lost or damaged inventory. These show up as positive amounts in your settlement but aren't sales revenue. Book them to an "Other Income" or "Reimbursement" account.
Currency Conversion
If you sell on multiple Amazon marketplaces, settlements arrive in different currencies. Zoho Books handles multi-currency natively — enable it in Settings → Currencies, and make sure your clearing account and bank account are set to the correct currency for each marketplace.
The Payoff
Once you have clean Amazon reconciliation in Zoho Books, you get real visibility: actual gross margins, fee ratios by category, refund rates, and advertising spend as a percentage of revenue. This is foundational data for any ecommerce business running on Zoho. Without it, your P&L is fiction.