How to connect Amazon to Xero: complete 2026 workflow

Instead of manually separating every Amazon payout into sales, fees and refunds, connect Amazon to Xero through an Amazon-compatible accounting connector that imports those components and reconciles them against your bank receipts. This 2026 workflow covers access, account mapping, a controlled first import and the checks you need before enabling ongoing posting.

Why this matters

Amazon deducts charges and makes adjustments before paying money into your bank. Recording that deposit as sales loses the breakdown needed to understand turnover, selling costs and refunds.

Your bank feed confirms money received; your Amazon records explain how that amount arose. You need both, with a clearing account connecting them rather than a second sales entry.

For ongoing support, Gowin Accountants Ltd provides fixed-fee accounting and Xero-based services to UK businesses. Agree the dedicated accountant arrangement, settlement-checking responsibilities and included work in writing so you know what would create an additional charge.

Before you start

• Access: Have access to your Amazon seller account, the correct Xero organisation and an Amazon-compatible connector. You need permission to authorise connections and create or approve accounting entries.
• Records: Gather a completed Amazon settlement report, its supporting transaction detail and the corresponding bank receipt. Confirm your business entity, VAT registration status and currencies before mapping anything.
• The gotcha: Check whether another connector, manual journal or bookkeeping process already records Amazon activity. Set a cutover date before importing history; otherwise, two processes can record the same sales.

Do not connect a live business account to a demonstration organisation. Check the legal business name in both systems, especially if you manage several companies.

Choose your posting method

For your 2026 setup, decide whether the accounting entry should summarise each settlement or record individual orders. That decision affects the connector you choose, the transaction volume in Xero and how you investigate differences.

Use settlement summaries when your priority is reconciling payouts, unless your accounting process requires individual orders. Neither method removes the need to check VAT, stock accounting or reporting-period boundaries.

Amazon supplies the marketplace transaction evidence; it does not replace your accounting ledger. Xero holds the accounting records and bank reconciliation, but a bank feed alone does not explain Amazon deductions. The connector transfers and categorises information; incorrect mapping still produces incorrect accounts.

Before choosing, confirm that the connector supports your marketplaces, currencies, intended posting method and refund handling. Check its current documentation rather than assuming every Amazon integration works the same way.

Amazon and Xero connection

Authorise the correct accounts

1. Open your chosen connector and begin its Amazon authorisation process. Select the seller account and marketplace that belong to the business you are recording.
2. Complete Amazon's permission request using an authorised account. Read the requested permissions before approving access.
3. Start the connector's Xero authorisation process. Select the correct Xero organisation and approve the connection using an account with sufficient permissions.
4. Record the connected marketplaces, organisation and proposed import start date in your bookkeeping handover notes.

Authorisation labels differ between connectors, so follow the selected provider's current setup instructions. Do not substitute an unrelated automation that moves order totals without the settlement breakdown your bookkeeping needs.

Expected result: The connector identifies the intended Amazon seller account and Xero organisation. Confirm both before fetching historical transactions.

Set the import boundary

1. Identify the last settlement already recorded correctly in Xero.
2. Choose the next unrecorded settlement as your starting point. Keep its report as evidence of the cutover.
3. Restrict the initial import to that completed settlement where the connector allows it.
4. Leave automatic posting disabled until you have checked the imported result.

Expected result: You have a clear boundary between existing bookkeeping and new connector entries, without overlapping imports.

If you are changing providers at the same time, agree who owns the final old-system entries and the first new-system entries. A connection date is not automatically the correct accounting cutover date.

Account and VAT mapping

Create the settlement clearing account

1. In Xero, open Chart of accounts and review the accounts already used for Amazon activity.
2. Create or identify an Amazon clearing account with your accountant. Use it to track amounts moving between Amazon settlement entries and bank payouts.
3. Map the connector's settlement balance to that clearing account using its documented posting method.
4. Keep unrelated owner transfers, loan receipts and non-Amazon sales outside this workflow.

Expected result: Settlement postings and the related bank receipts meet in the clearing account instead of creating duplicate turnover.

The clearing account is a control, not a miscellaneous difference account. Its balance needs an explanation, such as unsettled activity, withheld amounts or a payout still in transit.

Map transaction categories

1. Map sales to the appropriate sales accounts, keeping categories separate where your reporting or tax treatment requires it.
2. Map Amazon fees to expense accounts that reflect their nature. Preserve enough detail to review the supporting charges.
3. Map refunds consistently with the original sales treatment, rather than treating every negative amount as a general expense.
4. Identify reserves, reimbursements and other adjustments separately. Establish what each represents before assigning an account.
5. Review tax-code mapping with your accountant before posting the test settlement.

Expected result: Every imported category has a deliberate accounting treatment, with unresolved items held for investigation rather than forced into sales.

For the wider monthly process, see the guide to Xero accounting for e-commerce sellers.

Check VAT separately

A connector's suggested tax code is not evidence that the underlying transaction has that treatment. Customer location, marketplace arrangements, stock location and the nature of a charge can affect the analysis.

For your 2026 configuration, check the applicable treatment against current HMRC guidance on online marketplace VAT and the relevant supporting invoices. Cross-border sales and overseas stock need particular attention; do not apply one UK sales code to every marketplace transaction.

Gowin Accountants Ltd provides VAT and bookkeeping services, but agree whether your ongoing engagement includes connector mapping and settlement reviews. This guide explains the workflow, not the VAT treatment of your individual transactions.

First settlement and bank reconciliation

Post a controlled test

1. Import 1 completed settlement using the agreed mappings. Keep automatic posting off while checking the result.
2. Compare the imported sales, refunds, fees and adjustments with the settlement's supporting transaction detail.
3. Check 2 dates: the reporting period covered by the activity and the date the payout reaches your bank. They serve different purposes.
4. Review the posting date with your accountant, particularly when the settlement spans a month-end or year-end.
5. Approve or post the entry only after resolving unexplained differences.

Expected result: The Xero entry reflects the settlement evidence and its accounting period, not merely the cash deposit.

Keep the review trail simple: retain 3 records together—the settlement report, the Xero posting reference and the corresponding bank receipt. They let someone else follow the reconciliation without reconstructing your setup.

Match the payout

Use this control sequence for the test settlement:

1. Settlement report: Confirm the payout amount and currency shown by Amazon.
2. Account mapping: Check that the categories behind that payout received the intended treatment.
3. Xero posting: Confirm that the settlement entry reached the intended clearing account.
4. Bank receipt: In Xero's Bank accounts, open Reconcile for the receiving account and reconcile the receipt against the clearing-account movement using the agreed method.
5. Clearing review: Investigate any balance remaining after allowing for timing, reserves and other documented items.

Do not code the bank receipt to sales when the connector has already recorded those sales. That records turnover twice.

Expected result: The bank receipt agrees with the payout evidence, and the clearing balance has a documented explanation.

Post each new settlement automatically

Once the test passes, use the connector's documented automatic-posting settings to process subsequent completed settlements. This is the adjacent workflow: the first setup establishes the rules; recurring posting applies them.

1. Enable the intended marketplace and posting method only.
2. Keep the approved mappings and cutover boundary recorded.
3. Assign responsibility for checking failed imports, new transaction categories and unmatched payouts.
4. Review the next completed settlement before treating the process as routine.

For 2026 monthly bookkeeping, include settlement exceptions in your normal month-end review. Automation removes repeated entry, not responsibility for the accounts.

Best for established mappings: Automatic settlement posting reduces manual handling. Its limitation: A wrong rule repeats until someone changes it. Retain approval before posting where categories or tax treatment remain unresolved.

Do not assume edits to Amazon orders will rewrite previously posted accounting entries. Check how your connector handles later refunds, adjustments and corrected settlements before changing posted records.

Troubleshooting

The bank receipt is smaller than reported sales

Compare the full settlement breakdown, not sales alone. Fees, refunds and other settlement movements explain why gross sales and cash received differ. Investigate the remaining difference rather than adding a balancing expense.

Sales appear twice

Look for overlapping connector imports, existing manual journals and bank receipts coded directly to sales. Identify the duplicate source before correcting anything. Have your accountant check entries already included in a VAT return or closed reporting period.

The clearing account does not return to zero

Separate timing differences from errors. Check for pending payouts, reserves, missing settlements and entries posted to the wrong account. Do not force the balance to zero while Amazon still holds a documented amount.

VAT looks wrong despite a successful import

Check transaction detail, marketplace, supporting invoices and tax-code mapping. Pause automatic posting while you correct the rule. Assess affected entries with your accountant before changing records connected to a submitted return.

The connector stops importing

Check its connection status, authorisation permissions and marketplace selection. Reauthorise through the provider's documented process where required, then inspect the last successful import before restarting. Reconnecting must not trigger a second import of already-recorded settlements.

Customise your workflow

Expand only after the basic settlement-to-bank process works. Add another marketplace, currency or sales channel separately so you can identify which change caused an exception.

Assign named responsibilities for collecting evidence, reviewing new mappings, reconciling payouts and approving corrections. Also decide who reviews stock and cost-of-sales records: settlement bookkeeping alone does not establish your inventory position.

Gowin Accountants Ltd offers fixed-fee accounting support; ask for the Amazon and Xero responsibilities to be listed in your engagement. Confirm what your dedicated accountant handles and how additional work is agreed, rather than assuming software configuration is included.

FAQ

One last thing

A clearing account at zero is not proof that your VAT or profit is correct. It confirms that the recorded movements balance; it does not validate the categories used.

Before relying on your 2026 reports, check both the reconciliation and the accounting treatment. A perfectly matched bank receipt can still sit behind incorrectly classified sales or fees.

Related guides

• What records your VAT accountant needs each quarter
• How to hand over bookkeeping services to a new accountant
• What a fixed-fee small business accountant should include