A finished Amazon to Xero setup produces one thing. Every Amazon deposit that hits your bank feed matches, to the cent, a group of Xero transactions that break that deposit into gross sales, refunds, referral fees, fulfillment fees, storage, advertising, subscription charges, and sales tax. If your Xero file records the deposit as a single revenue line, the setup is wrong, and no amount of later cleanup fixes the reporting you lost. Everything below is the sequence for getting there.
Most bad Amazon books in Xero were bad on day one because someone connected a feed to an empty chart of accounts and started coding transactions wherever they fit. Build the accounts first.
You need product sales separated from shipping income and from promotional rebates. Amazon reports shipping credits and promo rebates as separate line types in the settlement, and if you net them into one sales figure you cannot compute a real gross margin later. Three revenue accounts is the working minimum: Amazon Product Sales, Amazon Shipping Income, Amazon Promotions and Discounts, the last one carrying a negative balance.
Referral fees, FBA fulfillment fees, and inbound placement charges belong above the gross profit line, because they scale with units sold. Storage fees, long term storage fees, and removal fees are closer to overhead but still deserve their own accounts. Advertising is its own beast and should never sit inside a lump "Amazon fees" account, because it is the one cost you control weekly.
Two accounts do the heavy lifting: an Amazon Settlement Clearing account and a Sales Tax Payable account. A third, Amazon Reserve, holds funds Amazon has withheld and not yet released.
Here is a two week settlement for a mid sized seller, with the numbers rounded for readability.
The referral fee figure above is 15 percent of gross sales plus shipping. Amazon's published pricing page lists 15 percent as the referral rate for Home and Kitchen, Office Products, Toys and Games, Sports and Outdoors, Lawn and Garden, and several other categories, with a minimum referral fee of 30 cents per item and a $39.99 monthly Professional selling plan charge. Clothing runs on a tiered schedule instead, at 5 percent under $15, 10 percent from $15.01 to $20, and 17 percent above $20. Check your own category rather than assuming 15 percent, and check it again after any Amazon fee announcement.
Now look at what happens if this settlement gets booked as one revenue line. Reported revenue becomes 72,148.01 instead of 130,540.00, understating the top line by 58,391.99. Every cost inside the settlement disappears. Gross margin, ad efficiency, and fee ratios are all unrecoverable from that entry.
That third step is where the discipline lives. A clearing account that returns to zero after every settlement is a running proof that your Amazon books are complete. Automating that loop is the entire reason the Amazon and Xero integration exists inside ConnectBooks, and the same clearing logic applies whether the mapping is automated or hand built.
Amazon calculates, collects, and remits sales tax on your behalf in states with marketplace facilitator laws. In your books, the tax collected and the tax withheld should offset each other. Post the collection as a credit to Sales Tax Payable and the withholding as a debit to the same account. The balance nets to zero for facilitator states, which is the correct result: you did not keep that money and you do not owe it.
Two things trip people up. First, tax on refunds flows back the same way and needs the same treatment. Second, states where Amazon does not collect on your behalf leave a real liability sitting in that account, and that balance is yours to file. Talk to a CPA about your specific state registrations rather than reading a balance off a screen and assuming it is settled.
Amazon holds funds in reserve for new accounts, for delivery date based reserve policies, and around performance events. The settlement report shows this as an unavailable balance. If you ignore reserves, your clearing account will not zero out, and you will spend an afternoon hunting for a difference that was never an error.
Month end is the other pinch point. Settlements do not respect calendar boundaries. A settlement that opens on 26 August and closes on 9 September contains revenue belonging to two months. Under accrual accounting you split it. The cleanest approach is to record activity by order date rather than settlement date, which is what a settlement level sync should do for you, and to keep the deposit reconciliation separate from the revenue recognition.
Xero tracks inventory items and calculates cost of goods sold using an average cost method. That works for a single channel business with a modest catalog. Xero's own inventory page states the practical ceiling plainly: you can manage up to 4,000 items. A seller running Amazon plus a Shopify store plus a Walmart listing set, with bundles and multipacks and a container of inbound stock in transit, runs past that model quickly.
What breaks first is not the item count. It is cost accuracy. Amazon's settlement tells you what you sold and what you were charged. It says nothing about what those units cost you, what the freight and duty allocation was, or which warehouse they shipped from. FIFO based cost of goods sold at the SKU level, with landed cost allocated across a shipment, is the layer that has to sit alongside Xero rather than inside it. That is the gap ConnectBooks fills for Amazon sellers running on Xero.
Run these four before you trust the file.
If all four pass, the connection is doing its job. If any fail, fix the mapping before another settlement lands on top of it. You can see how the pieces fit together on the Xero integration overview, compare plans on the pricing page, or walk the settlement flow with someone on a demo.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
