6 Xero Accounts Amazon Sellers Must Set Up Before Using Bank Rules
Bank rules alone are not a safe way to book Amazon payouts. The single deposit hitting your bank account is a net figure, and coding it straight to Sales through a rule hides your real revenue and expenses. Before writing a single rule, set up a holding or clearing account in Xero and either post summarized settlement journals to it or connect an Amazon-to-Xero integration. Keep reading for the exact setup.
TL;DR:
- Using a dedicated clearing account in Xero prevents misclassification of Amazon payouts and ensures accurate tracking of revenue, expenses, and refunds.
- Manual settlement journals or automated integrations are recommended once transaction volume, multiple marketplaces, or multi-currency handling increase beyond a simple setup.
- Bank rules should match deposit payees and include stable references like settlement IDs, with precise rule order to avoid misclassification.
- Regular reconciliation of the clearing account with detailed settlement reports reduces errors and minimizes month-end adjustments.
- Automated solutions like BeanHawk streamline data entry, recover owed reimbursements, and save significant time, especially at scale.
Table of Contents
- Why Xero bank rules alone often fail for Amazon settlements
- Set up Xero accounts and a holding account for Amazon
- Create practical Xero bank rules that reduce noise but preserve auditability
- When to use bank rules vs an Amazon-to-Xero integration or automation
- Practical troubleshooting checklist and reconciliation tips
- How automated settlement posting changes reconciliation
- How BeanHawk automates settlement posting to Xero and recovers FBA reimbursements
- Sources
- FAQ
Why Xero bank rules alone often fail for Amazon settlements
An Amazon deposit is never just a sale. A single payout can bundle gross sales, sales tax collected on the buyer’s behalf, shipping charges, advertising reimbursements, customer refunds, and a reserve adjustment Amazon is holding back for a later date. A bank rule sees one number arriving in your account and has no way to unpack what is actually inside it.
That matters for tax reporting. The IRS guidance on Form 1099-K treats gross payment volume as the figure sellers need to reconcile against their books, so coding a net payout straight to “Sales” understates both gross revenue and the expenses that got netted out along the way. Come tax time, your books and your 1099-K tell two different stories, and reconciling them after the fact is far more work than doing it right the first time.
The operational side is just as brittle. Amazon’s fee structure shifts by category, promotion, and fulfillment method, refunds land on their own schedule, and any seller with international listings adds multi-currency conversion into the mix. A rule built to match last month’s deposit pattern often misfires on this month’s, quietly misclassifying transactions instead of throwing an error you’d notice.
The downstream effects show up in the ledger:
- Revenue gets misstated because tax and shipping collected from buyers get lumped into sales.
- Cost of goods sold drifts out of sync with actual unit economics.
- Tracking categories and product-level profitability break down because nothing maps to an order.
- Reconciled-looking bank feeds hide errors that only surface during a tax review or audit.
Set up Xero accounts and a holding account for Amazon
The fix is structural: never let a bank rule touch revenue recognition directly. Instead, route Amazon payouts into a clearing account first, then post the detail behind them separately.
A holding or clearing account works like a waypoint. Amazon’s deposit lands there, matched by a simple rule, and a summarized settlement journal (posted manually or through an integration) fills in what that deposit actually represents; sales, fees, tax, refunds, each to its own account. When the clearing account balance hits zero after the journal is posted, you know the deposit and the detail agree.
Before you touch bank rules, prepare a chart of accounts that can hold that detail:
- Gross sales, separate from any tax or shipping collected.
- Sales tax collected, tracked as a liability rather than income.
- Shipping income, if you charge for it separately from bundled pricing.
- Advertising expense, for Sponsored Products and other ad spend.
- Amazon fees, ideally split by referral fees, FBA fees, and storage.
- Cost of goods sold, tied to your inventory costing method.
For the clearing account itself, a virtual bank account in Xero is usually sufficient. It behaves like a real account for reconciliation purposes without requiring an actual bank product, and it keeps Amazon activity isolated from your operating cash. Sellers running multiple marketplaces sometimes prefer one clearing account per marketplace, which makes multi-currency handling cleaner.
To post the detail, pull the relevant settlement and transaction reports from Seller Central, which break payouts down into orders, fees, refunds, and reserves. That line-level detail is what turns a single deposit figure into a proper journal entry, and it is the same detail an automated integration reads to do the job for you.
Pro Tip: Name your clearing account something specific, like “Amazon Clearing,” so anyone reviewing the books later can tell at a glance it’s not an operating bank account.
Create practical Xero bank rules that reduce noise but preserve auditability
Once deposits route through a clearing account, bank rules become a matching tool instead of a revenue-recognition shortcut, and that distinction is what keeps them safe.
Stick to receive money rules for Amazon deposits, built in Xero’s Bank Rules screen under bank account settings. A workable rule construction looks like this:
- Match on a payee text pattern that Amazon consistently uses for settlement deposits, not the amount.
- Add a reference fragment condition where Amazon includes a settlement ID, since that is more stable than any dollar figure.
- Set the destination account to your clearing account, never directly to Sales.
- Avoid any rule that tries to match a net amount and label it “Sales”: that pattern is exactly what creates the tax and audit problems described above.
Order matters once you have more than one rule running. Xero applies rules in the sequence you set, so put the most specific conditions first (an exact reference match) and broader ones last (a generic payee match that could catch several transaction types). Test new rules against a few weeks of recent statement lines before trusting them on a live feed.
Some automations are genuinely low-risk: a recurring reimbursement from Amazon that always uses the same reference format is a good candidate for a rule. Fee allocations and advertising spend are not. Those numbers shift too often to trust to static logic and are better handled through the journal you post to the clearing account, or through an integration built for the purpose. According to reviews of Xero’s app marketplace, direct integrations exist precisely because bank rules struggle with Amazon’s variable fee structures, often producing transactions that look correctly coded but are not.
One more detail worth knowing before you start editing rules freely: according to Xero Central’s documentation, editing or deleting a bank rule does not change transactions that were already reconciled using it. Past reconciliations stay put, which means a rule mistake gets fixed going forward but any damage already done needs a manual adjustment.
When to use bank rules vs an Amazon-to-Xero integration or automation
Bank rules can carry a small, simple Amazon operation. They start to break down as volume, marketplaces, or fee complexity increase, and knowing where that line sits saves a lot of after-the-fact cleanup.
Bank rules paired with a clearing account tend to hold up when you sell on a single marketplace, process a modest number of orders a month, and deal with only a handful of fee types. In that setup, a seller or bookkeeper can post a settlement journal by hand without it eating into the week.
An integration becomes worth the cost once any of the following show up:
- You sell across multiple Amazon marketplaces or multiple sales channels.
- Settlement reports run to dozens of fee categories rather than a handful.
- Transactions involve more than one currency.
- Manual journal posting is eating more than an hour or two each month.
Tools listed in the Xero App Store’s Amazon integration collection are built to post pre-mapped, summarized journals keyed to settlement totals, so the bank feed matches automatically and nobody has to reconstruct fee detail by hand. That is a real trade-off worth weighing: an integration costs a subscription fee, but it buys back the hours a bookkeeper would otherwise spend decoding settlement reports every month, and it scales without extra manual work as order volume grows. Piloting one integration against a single month of manual reconciliation is usually enough to tell whether the switch pays for itself.
Practical troubleshooting checklist and reconciliation tips
When a deposit does not match what you expected in the clearing account, work the problem in order rather than guessing at an adjustment.
- Download the relevant settlement report from Seller Central for the deposit date range in question.
- Compare it line by line against the journal already posted to the clearing account.
- Check for reserves or deferred transactions, since Amazon’s settlement reports can hold back part of a balance for a later payout.
- Confirm the clearing account nets to zero once the correct journal is posted.
Most mismatches resolve with an adjusting journal entry, either a reserve adjustment or a reclassification between fee accounts. If the discrepancy affects reported income at tax time, it is worth checking whether a corrected 1099-K is needed before filing.
A two-week check on the clearing account, followed by a full reconciliation at month-end close, catches problems while the settlement report is still easy to pull. Waiting until year-end makes every mismatch harder to trace back to its source.
Pro Tip: Keep the last three months of settlement reports downloaded locally. Seller Central’s reporting window makes older data slower to retrieve, and having them on hand speeds up any reconciliation question.
How automated settlement posting changes reconciliation
Sellers who move from manual journal entries to automated settlement posting tend to see the clearing account close out with far fewer manual adjustments each month, since the summarized journal already matches the settlement report line for line. Continuous monitoring of FBA ledger events also tends to surface reimbursement claims that a manual monthly review would miss entirely, since those events often post outside the regular settlement cycle. For one seller moving from spreadsheet reconciliation to automated posting, a process that used to take a full day of matching line items dropped to a quick review of a handful of flagged discrepancies.
, Tim
How BeanHawk automates settlement posting to Xero and recovers FBA reimbursements
The setup above works, but somebody still has to run it every month: pull the report, build the journal, post it, check the clearing account. An automated solution can map every Amazon settlement into a summarized journal in Xero so the clearing account reconciles itself, while continuously monitoring FBA ledger events for lost, damaged, or under-reimbursed inventory that may be owed.
That combination means less time spent decoding settlement reports and a cleaner audit trail when tax season arrives, since gross sales, fees, and reimbursements are already broken out correctly.
| What you get | Detail |
|---|---|
| Automated Xero posting | Summarized settlement journals mapped to your chart of accounts |
| Reimbursement recovery | Continuous monitoring of FBA ledger events for owed funds |
| Pricing | Free, Starter at $19/month, Growth at $49/month, Scale at $99/month |
Start with the free FBA reimbursement audit to see what Amazon may already owe you before deciding on a plan.
Sources
Bookmark Xero’s bank rules guide, Amazon’s settlement report help, and the IRS Form 1099-K page for month-end close and tax prep. For deeper 1099 filing questions, this filing requirements overview is a useful companion.
This article is general information, not a substitute for advice from a qualified financial advisor. Consult a qualified financial professional about your own circumstances before acting on anything here.
- A2X Xero Integration Reviews & Features , Xero App Store US
- Understanding your Form 1099-K
- Obtaining transaction and settlement reports on Seller Central
- Edit or delete a bank rule , Xero Central
FAQ
What are bank rules in Xero?
Bank rules in Xero are automated instructions that match incoming or outgoing bank transactions to specific accounts, contacts, or tracking categories based on criteria you set. For Amazon sellers, they work best when matching deposits into a clearing account rather than coding net payouts straight to sales.
What are the downsides of using Xero?
Xero on its own has no built-in way to break apart a bundled Amazon settlement into sales, fees, tax, and refunds, so sellers need a clearing account, manual journals, or an integration to fill that gap. Without one of those, bank rules alone can misstate revenue and complicate tax reporting.
Which banks are compatible with Xero?
Xero connects with a wide range of banks through direct bank feeds or file import, and compatibility depends on your specific bank and country rather than a fixed list. Check your bank’s connection status directly in Xero’s bank feed setup before relying on automatic feeds.
How do I edit bank rules in Xero?
You can edit or delete a bank rule from the Bank Rules screen in Xero’s bank account settings, adjusting the match criteria, destination account, or rule order at any time. According to Xero Central, changing or removing a rule does not affect transactions that were already reconciled using it.