Amazon Payout Reconciliation – Step-by-Step

Last updated: March 2026

Amazon payouts do not equal revenue. Each deposit is a net settlement made up of gross sales, referral fees, fulfilment charges, VAT on fees, refunds, reserves, and adjustments.

Without structured reconciliation, UK Amazon sellers risk misstated turnover, incorrect VAT reporting, and clearing account imbalances. This guide explains how to break down settlement reports, map transactions correctly in Xero, and reconcile payouts with confidence.

Contents

⏱️ ~65–75 min read · Updated February 2026

Use this contents menu to jump directly to the section you need.

• Why Amazon Payout Reconciliation Matters
• Understanding Amazon Payout Cycles
• Breaking Down the Amazon Settlement Report
• Creating Your Amazon Clearing Account
• Mapping Amazon Transactions in Xero
• Reconciling Amazon Payouts Against Your Bank Feed
• Multi-Marketplace and Multi-Currency Considerations
• Stripe and PayPal Accounting for Amazon Sellers
• Common Amazon Reconciliation Errors
• Month-End Review Checklist
• Action Plan and Download the Reconciliation Template

1. Why Amazon Payout Reconciliation Matters

Amazon payouts look simple on the surface. Money often arrives in your bank account on a roughly two-week cycle and appears to reflect sales performance. In reality, the payout is the final result of a complex process that includes gross sales, multiple fee categories, VAT adjustments, refunds, chargebacks, reserves, reimbursements, and sometimes currency conversion.

Without reconciliation, UK Amazon sellers can record distorted figures that affect margins, VAT reporting, cash flow and year-end accounts. This guide explains what reconciliation involves, why it matters, how Amazon’s payout model differs from traditional e-commerce platforms, and what you will achieve by following the steps that follow. For wider context on setting up your bookkeeping correctly, see our Amazon Seller Accounting – Complete Guide.

What is Amazon payout reconciliation

Amazon payout reconciliation is the process of taking a single net deposit and breaking it back down into its underlying financial components. The net deposit does not usually reflect your gross revenue.

It is the amount remaining after Amazon deducts referral fees, fulfilment costs, storage charges, advertising spend, VAT on fees, refunds, chargebacks, and any reserve amounts held back for future risks.

A proper reconciliation identifies gross sales, separates each fee type, identifies reclaimable VAT where applicable, records reserve movements, and allocates transactions to the correct accounting period.

This process relies on several reports inside Seller Central. These include the Settlement Report, the VAT Transactions Report, the Transaction View, and the Payouts dashboard.

Each contains unique information used in UK accounting, such as shipment dates that help determine VAT tax points and any VAT charged on Amazon fees since August 2024. Reconciliation ensures these figures are recorded accurately in your accounting software through an Amazon clearing account, which is essential for correct bank matching.

Why reconciliation matters for UK Amazon sellers

For UK sellers, reconciliation is a key control for HMRC compliance and for maintaining accurate financial statements. Recording bank deposits as revenue understates gross sales and output VAT. A £6,000 payout can represent materially higher gross sales once fees, refunds, and VAT are taken into account.

This can create a turnover discrepancy that may be visible through platform reporting regimes such as DAC7, under which digital platforms report seller income data to tax authorities across the EU. Even small mismatches between Amazon’s gross sales and the turnover filed in your VAT return or CT600 can increase the likelihood of a query.

Reconciliation also prevents common VAT errors. Some Amazon fees may attract UK VAT at 20 percent, depending on how Amazon has invoiced the service and the seller’s VAT circumstances. This VAT is typically reclaimable for VAT-registered sellers where the invoice supports it, and separating the VAT from the fee amount helps ensure it is captured correctly. Without reconciliation, sellers can miss significant amounts of input VAT over time.

Refunds and chargebacks also affect output VAT and should generally be reflected in the VAT return for the period in which the VAT adjustment arises under the relevant tax point rules, as outlined in HMRC’s primary VAT guidance (VAT Notice 700). If sellers rely on payout dates instead of tax points, VAT may be allocated to the wrong period, which can create avoidable compliance issues.

Accurate reconciliation also sharpens financial analysis. It helps identify real return rates, the impact of reimbursements, inventory performance, and the true cost of fulfilment. Amazon deducts fees at source, so poor visibility can lead to incorrect pricing, stock purchasing decisions, and cash flow forecasting.

Amazon’s 14-day settlement cycle and reserve holds also make working capital planning difficult unless sellers understand how much cash will actually arrive and when. Reconciliation makes these patterns clearer and more predictable.

How Amazon’s payout model differs from traditional e-commerce

Traditional payment processors such as Stripe or PayPal often provide near-gross payouts. They usually deduct one small processing fee and release funds within a few days. Their reports show clear itemised fees, and the bank deposits closely match the underlying sales.

Amazon’s model is fundamentally different. The platform deducts multiple categories of fees, VAT on those fees, adjustments for refunds, advertising charges, reserve holds and sometimes currency changes, all inside a single settlement. Payouts can arrive days or weeks after the sale and may be reduced materially by fees, refunds, reserves, and other adjustments before the seller receives funds.

Amazon also applies marketplace facilitator rules to certain transactions. In some cases Amazon collects VAT on the seller’s behalf. These amounts may need to be included in turnover, but the VAT treatment depends on whether Amazon is the deemed supplier for the transaction. This layer of VAT complexity does not exist with Stripe or PayPal.

Amazon also operates separate dashboards for settlements, VAT, payments, and dispute management, which requires sellers to pull several data sources together before posting entries into Xero or other accounting systems. These structural differences explain why Amazon reconciliation is significantly more involved than reconciling Stripe or PayPal and why specialist tools are often used to automate the process.

What this guide will help you achieve

The purpose of this guide is to give UK Amazon sellers a clear, reliable method for reconciling Amazon payouts and recording accurate financial data each month. It explains how to understand the settlement cycle, interpret each section of the Amazon Settlement Report, extract VAT on fees, and map every transaction correctly in Xero using a clearing account.

You will learn how to identify timing differences, how to handle multi-currency settlements and how to ensure refunds and reimbursements are allocated to the correct period.

The guide also highlights the most common reconciliation mistakes that lead to VAT errors, misleading profit figures and HMRC queries. By following the steps in this guide, your accounting records should align more closely with Amazon’s data, your VAT returns will reflect accurate tax points, and your financial reporting will provide a reliable foundation for planning, forecasting and scaling your Amazon business.

2. Understanding Amazon Payout Cycles

Amazon’s payout cycle is one of the most misunderstood areas of Amazon accounting, particularly for UK sellers who are used to faster, simpler payment processors. While Amazon often settles seller accounts on a 14-day cycle, the reality is more complex.

Payout timing can be influenced by settlement periods, account level reserves, account status, refunds, chargebacks, seasonal risk controls, and verification checks.

Understanding how these elements interact is essential for accurate bookkeeping, VAT compliance, and cash flow planning.

This section explains how Amazon’s payout cycle works in practice, how to interpret payout signals inside Seller Central, and why payouts often arrive later or in smaller amounts than expected.

Amazon’s 14-day settlement cycle explained

Amazon generally aims to settle professional seller accounts on a 14-day cycle, although settlement frequency can vary by region, seller type, and account status.

Each settlement period captures the transactions posted to your seller account during that window, based on Amazon’s internal posting logic, including sales, fees, refunds, chargebacks, and adjustments, even when those transactions relate to customer orders from an earlier date.

During a settlement period, Amazon records customer orders, allocates Amazon fees, processes refunds and chargebacks, and reflects any tax amounts Amazon has calculated or collected in situations where Amazon is responsible for collecting tax under marketplace rules. Once the settlement period closes, Amazon prepares a settlement report and schedules a payout.

A typical pattern many UK sellers experience looks like this:

• Orders are placed and fulfilled during a 14-day settlement period
• The settlement period closes
• Amazon generates the settlement report
• Amazon initiates the payout
• Funds clear into the seller’s UK bank account several business days later

In practice, this means there can often be a two to four week gap between a sale being dispatched and the cash arriving in the seller’s bank account. For example, a product shipped on 2 December may not result in funds being received until around 22 December, depending on settlement timing and bank clearance.

Under UK VAT principles, revenue and VAT are ordinarily recognised at the tax point, which for physical goods is most often when they are dispatched or delivered, subject to the specific facts of the transaction.

UK businesses are generally required to recognise sales and output VAT when orders are dispatched or delivered, even though Amazon pays out later. Treating the payout date as the revenue date is a common cause of VAT and profit misstatements in practice.

What the “Next Scheduled Deposit” actually means

Inside Seller Central, Amazon displays a field labelled “Next Scheduled Deposit”.

This is often misunderstood as a guaranteed payment date, which it is not. In reality, it represents Amazon’s current estimate of when it expects to initiate the payout, not when the funds will arrive in your bank account.

This date is calculated after Amazon considers factors such as:

• The most recent settlement period close date
• Any account level reserve being applied
• Current account performance metrics
• Verification or compliance reviews
• Seasonal risk controls, particularly during Q4

Even when the date shows as scheduled, funds may still take several business days to clear into a UK bank account, depending on the bank and the day the payout is initiated.

For cash flow planning, this distinction matters. If VAT is due on 7 January and the “Next Scheduled Deposit” shows 6 January, there is still a material risk that the funds will not clear in time to meet the VAT deadline. Conservative forecasting generally benefits from allowing a buffer beyond the displayed date.

Understanding the Account Level Reserve

The Account Level Reserve is one of the main reasons Amazon payouts can be lower than sellers expect. A reserve is not a fee. It is a portion of the seller’s balance that Amazon temporarily withholds to protect itself against refunds, chargebacks, and disputes.

Amazon does not publish fixed reserve percentages that apply consistently across all sellers. Instead, reserve amounts vary based on risk and account behaviour. In practice, reserves are often linked to unresolved transactions and, for some accounts, a minimum rolling amount based on recent processed payments, rather than a single fixed percentage applied to every seller.

In broad terms:

• New sellers may see a significantly higher proportion of their balance held in reserve for an extended period while Amazon assesses risk, sometimes for several months
• Established sellers with strong performance often see reserves limited to unresolved transactions or a small rolling percentage of recent payments
• Sellers with high return rates, chargebacks, or policy issues can face much larger reserve amounts, and in some cases Amazon may withhold most or all funds until issues are resolved
• Reserve requirements can tighten during peak seasons such as Q4, particularly for higher-risk accounts, although Amazon does not publish fixed seasonal percentages

For example, a new seller generating £5,000 of gross sales in a settlement period might only receive a portion of that amount in cash if a substantial reserve is applied, with the remainder released later once Amazon’s risk criteria are satisfied.

From an accounting perspective, reserves should generally be tracked separately from fees. They represent money potentially owed to the seller rather than an expense. From a cash flow perspective, however, they materially reduce the funds available for inventory purchases, advertising spend, and VAT payments.

Delayed payouts: new accounts, chargebacks, and reserves

In addition to reserves, other factors can delay payouts altogether. New Amazon UK accounts may have payouts held for several weeks, sometimes 30 days or more, while Amazon completes identity checks, bank verification, and risk assessments. During Q4, these reviews can take longer due to increased transaction volumes.

Chargebacks also affect payout timing. When a customer disputes a transaction with their card provider, Amazon may deduct the disputed amount immediately and extend payout holds while the dispute is investigated. Even if the seller ultimately wins the chargeback, cash flow can be disrupted for weeks.

Policy issues, intellectual property complaints, and bank account errors can result in payouts being frozen. In these situations, Seller Central may show the payout status as “On Hold” or display no scheduled deposit date, which can create serious cash flow pressure if tax payments are approaching.

Where to find payout information in Seller Central

All payout-related information is accessed through the Payments section in Seller Central. The most important areas to review are:

• The Payments dashboard for current balances and the next scheduled deposit
• Statement View for settlement periods, balances, and reserves
• Settlement Reports for transaction-level detail used in reconciliation
• Seller Central messages for notifications about holds, reviews, or compliance checks

Best practice is to review the Payments dashboard regularly and download settlement reports monthly. This forms part of a wider monthly bookkeeping routine, and helps prevent surprises when payouts are delayed or reduced.

Understanding Amazon’s payout cycle is not just an operational concern. It underpins accurate revenue recognition, VAT reporting, and cash flow forecasting. Without a clear grasp of how settlement periods, reserves, and delays interact, reconciliation becomes guesswork rather than a controlled accounting process.

3. Breaking Down the Amazon Settlement Report

The Amazon Settlement Report is a core financial document that underpins accurate Amazon accounting. Every payout, fee deduction, refund, and adjustment that affects a seller’s cash flow can ultimately be traced back to this report.

For UK sellers, it is also a primary source document used to support revenue recognition, VAT reporting, and reconciliation between Amazon and accounting software.

At first glance, the settlement report can appear overwhelming. It contains dozens of columns and hundreds or thousands of transaction rows, often spanning multiple settlement periods. However, when broken down correctly, the report follows a consistent structure.

Each line item represents a specific economic event, and each has an accounting and VAT treatment under UK principles, which can vary depending on the nature of the transaction and the seller’s circumstances.

This section explains how to interpret the settlement report properly, what each category means in practice, and how the data should be mapped into UK accounting records.

Understanding gross sales (product charges, shipping, wrapping)

Gross sales in the Amazon settlement report are not always shown as a single headline figure. Instead, they can usually be built up from several separate revenue components that appear as individual columns or line items within the transaction detail section of the CSV export.

The main revenue components are:

• Product charges
• Shipping charges
• Gift wrap charges
• Promotional rebates and discounts

Product charges generally represent the base selling price of the item itself. For accounting purposes, this is typically treated as sales revenue, recorded net of VAT.

The applicable VAT rate depends on the nature of the goods being sold, commonly 20 percent for standard-rated items in the UK, 0 percent for certain zero-rated goods such as books, or 5 percent for specific reduced-rate goods, depending on the nature and jurisdiction of the supply.

Shipping charges can be a frequent source of VAT errors in practice. For UK VAT purposes, delivery and shipping normally follow the VAT liability of the goods when they form part of a single supply, subject to the specific facts. If the goods are zero-rated, the associated shipping can also be zero-rated. Where the goods are standard-rated, shipping is usually subject to VAT at 20 percent.

In practice, Amazon does not consistently separate shipping VAT cleanly by product VAT category within settlement data. This means sellers should review shipping income carefully when preparing VAT returns, rather than relying solely on Amazon’s aggregated figures.

Gift wrap charges are generally treated differently. In practice, optional extras such as gift wrap are commonly standard-rated, but whether the charge follows the goods can depend on whether it is truly ancillary to a single supply and how it is priced and presented. Gift wrap income should therefore be recorded separately or clearly identified so that output VAT is correctly reported.

Promotional rebates typically appear as negative revenue lines in the settlement report. These represent discounts funded by the seller, such as percentage-off promotions or vouchers. From an accounting perspective, they typically reduce gross revenue and may correspondingly reduce output VAT in many cases. They are generally best treated as contra-revenue rather than as marketing expenses, as they directly reduce the consideration received from the customer.

The key principle for UK accounting is that gross revenue reflects what the customer was charged for goods and services, excluding VAT. VAT itself is recorded separately as an output tax liability rather than as part of turnover.

Refunds and chargebacks: timing and impact

Refunds and chargebacks introduce timing complexity into Amazon accounting because they rarely align neatly with the original sale or the settlement period in which that sale appeared.

Refunds are included in the settlement report based on when Amazon issues the refund to the customer, not when the original order was placed or dispatched. A sale may appear in one settlement period, while the related refund appears in a later settlement period, sometimes weeks after the original transaction.

A typical refund sequence looks like this:

• The customer initiates a return
• The item is shipped back and inspected
• Amazon approves and issues the refund
• The refund appears in the settlement report for the period in which it was issued
• The cash impact is reflected in a later payout

For UK businesses using accrual accounting, the refund is typically recognised when the refund obligation arises, which in practice is often when the refund is issued, subject to the seller’s accounting policies and facts. This may require accruals at month-end where refunds have been authorised but not yet reflected in a bank payout.

Chargebacks create even longer timing gaps. A chargeback may be initiated months after the original sale and may not be resolved until well after the period in which the revenue was recognised.

When Amazon processes a chargeback decision, it reverses the original transaction in the settlement report and applies an additional chargeback fee. Both the reversal and the fee appear in the settlement period in which the dispute is resolved, not when it was initiated.

These timing differences explain why settlement reports, bank deposits, and monthly profit figures often fail to align unless accrual accounting and a clearing account structure are used.

Amazon fee structure: referral, FBA, storage, ads

Amazon deducts multiple categories of fees from seller balances, all of which appear in the settlement report.

Referral fees are charged as a percentage of the total sale value, including the item price, shipping charged to the customer, and gift wrap. The percentage varies by product category.

Referral fees are operating expenses for UK accounting purposes in most cases. From 1 August 2024, Amazon began charging UK VAT at 20 percent on many referral fees invoiced by its UK entities. If the seller is VAT-registered and holds a valid VAT invoice from Amazon, the VAT charged on referral fees can usually be reclaimed.

FBA fulfilment fees cover Amazon’s picking, packing, and delivery of individual customer orders. From an accounting perspective, these fees are often presented as part of cost of sales where they are directly attributable to fulfilling specific transactions, although presentation may vary depending on the seller’s accounting policy under FRS 102.

For a deeper explanation of how fulfilment, storage, reimbursements, and purchase costs interact within inventory and margin calculations, see our Inventory & Cost of Goods Accounting for Amazon guide.

Storage fees also need monitoring. Amazon applies higher peak-season storage rates during the Q4 period, typically October to December. For sellers holding significant inventory volumes, this can materially affect margins and cash flow if stock levels and sell-through rates are not monitored carefully.

Advertising fees, such as Sponsored Products or Sponsored Brands, appear separately from sales and fulfilment charges. These are marketing expenses and should not be netted against revenue. Amazon UK advertising fees often include UK VAT at 20 percent, depending on how they are invoiced by the relevant Amazon entity.

VAT-registered sellers may generally reclaim this VAT as input tax, provided the normal conditions for input tax recovery are met, including holding a valid VAT invoice and making taxable supplies.

Adjustments: reimbursements, disposal fees, currency effects

Settlement reports also include a range of adjustment entries that do not relate directly to customer sales.

Inventory reimbursements occur when Amazon compensates sellers for lost or damaged stock held in fulfilment centres. These amounts are typically recorded either as reductions to cost of goods sold or as other income, depending on how the original inventory loss was treated in the accounts.

Disposal and removal fees arise when inventory is destroyed, liquidated, or returned from Amazon fulfilment centres. For UK accounting purposes, these costs are typically treated as operating expenses, although their classification should be consistent with the seller’s inventory and cost-of-sales policy under FRS 102.

The VAT treatment depends on the invoicing entity. From 1 August 2024, many Amazon UK fulfilment-related services, including removal and disposal fees, have been invoiced with UK VAT at 20 percent where supplied by a UK Amazon entity. VAT-registered sellers may generally recover input VAT on these charges where the normal recovery conditions are met.

Overcharge corrections appear when Amazon reverses fees that were incorrectly applied. These should be posted as reductions to the relevant expense category rather than treated as revenue, as they represent refunds of previously charged costs.

For sellers operating across multiple marketplaces, settlement reports are produced in local currencies, while payouts may be converted to GBP at Amazon’s internal exchange rate. Differences between the accounting exchange rate and the actual payout rate typically give rise to foreign exchange gains or losses, which are generally recognised separately in the accounts in accordance with the applicable accounting framework.

Net payout calculation (formula and examples)

The net payout shown at the top of the settlement report is the result of a layered calculation:

• Gross sales
• Less refunds and chargebacks
• Less Amazon fees
• Plus reimbursements and credits
• Less other adjustments
• Less any account-level reserve

The final figure represents the amount Amazon expects to deposit into the seller’s bank account. From an accounting standpoint, this net payout is generally not treated as revenue. It is a cash movement that clears the Amazon clearing account, not a measure of sales or profit.

Sellers who attempt to post settlement reports directly to their bank account without using a clearing account often encounter reconciliation errors, VAT discrepancies, and distorted profit figures. In practice, many accountants find it useful to break the settlement report into component parts and route them through a clearing account to maintain accurate, compliant records.

Breaking down the Amazon settlement report properly transforms it from a confusing payout statement into a reliable accounting control document. Once sellers understand what each line item represents and how it should be treated under UK accounting and VAT rules, reconciliation becomes systematic rather than reactive, and financial reporting becomes far more robust.

4. Creating Your Amazon Clearing Account

Amazon payouts do not behave like normal customer receipts. Each payout represents a net figure made up of sales, fees, refunds, reserves, tax adjustments, currency movements, and sometimes corrections relating to earlier periods.

For UK Amazon sellers, this complexity often leads practitioners to use a dedicated clearing account as a practical control. Without one, bank reconciliation often becomes unreliable in practice, VAT reporting is harder to control, and accounts are more likely to fall out of alignment with UK GAAP and HMRC expectations.

In practice, a clearing account is not just a workaround. It is the structure many accountants rely on to reconcile Amazon settlement data, accrual-based accounting, and actual bank cash in a controlled and auditable way.

What is a clearing account and why Amazon needs one

A clearing account is a temporary holding or control account used to collect settlement activity before cash reaches the bank. In Amazon accounting, it typically represents amounts due from Amazon at a point in time and is therefore generally presented as a current asset, provided the balance reflects funds owed to the business rather than unreconciled differences.

Amazon settlement reports contain dozens, and often hundreds, of line items. These include gross product sales, referral fees, FBA fulfilment fees, storage charges, advertising deductions, refunds, chargebacks, reserve holds, and currency adjustments. However, the bank statement only ever shows one figure, the net payout.

If settlement journals are posted directly to revenue and expense accounts, the accounting system has no practical way to match that single bank deposit to the underlying activity without extensive manual intervention.

Over time, unmatched entries accumulate, refunds appear in later periods than the original sale, reserve balances are difficult to track, and VAT calculations become inconsistent across reports.

A clearing account addresses this by acting as a buffer. All settlement activity is posted into the clearing account first. When Amazon pays out, the bank deposit is matched against the clearing balance. If everything is recorded correctly, the clearing account returns to zero for that settlement.

From many accounting perspectives, a clearing account is often presented as money owed to the business by Amazon but not yet paid. That means it is typically treated as a current asset. It is generally not treated as revenue or as a liability.

How to create an Amazon Clearing Account in Xero

In Xero, an Amazon clearing account should be set up carefully to ensure it behaves correctly during reconciliation.

For most UK sellers, the recommended configuration is:

• Account type: Current Asset
• Account name: Amazon Clearing Account (or Amazon Settlement Clearing)
• Currency: GBP, where payouts are received in sterling
• Tax setting: No VAT
• Payments enabled: Yes
• Bank feed: No

Enabling payments allows the account to be used during bank reconciliation. It does not make the account behave like a real bank account, and it does not require a bank feed.

A common mistake is creating the clearing account as a bank account in Xero. While Xero allows this, it treats the account as if it were a real bank and encourages bank-feed reconciliation, which Amazon does not support. Xero’s own guidance for bulk payment platforms recommends using a current-asset clearing account instead.

Creating the account as a liability is also inappropriate in most cases, as it implies money owed to Amazon rather than money owed to the business.

For sellers operating multiple marketplaces, separate clearing accounts may be used by currency or region, but the underlying logic remains the same.

Why your bank feed won’t match without it

Amazon settlements compress complex activity into a single payout. Without a clearing account, this commonly leads to persistent reconciliation mismatches over time.

For example, a typical settlement might include £15,000 of gross sales, £2,700 of combined fees and refunds, and a £12,300 payout. If sales and fees are posted directly to income and expense accounts, the bank feed still only shows £12,300. There is nothing in the ledger for the bank deposit to match against.

Refunds and chargebacks add further complexity. These often relate to orders from earlier months but appear in later settlements. Without a clearing account holding both the original sale and the later reversal, timing differences spill across reporting periods and distort profit and VAT figures.

Reserve holds create another common issue. When Amazon withholds funds under an account-level reserve, that balance should remain visible as an asset on the balance sheet until it is released. Posting net figures directly to the bank often results in these balances being overlooked or inconsistently tracked.

Multi-currency clearing accounts for EU and US payouts

Amazon typically converts foreign currency at settlement time, not at the point of sale, where sellers use Amazon’s currency conversion service. This timing difference is a common source of FX gains and losses.

Where all payouts arrive in GBP, a single GBP clearing account is usually sufficient. FX differences are embedded in the settlement figures and are usually mapped automatically by accounting integrations.

Where payouts arrive in EUR or USD, many practitioners create separate clearing accounts for each currency. These balances are monetary assets and are generally revalued at the period end in accordance with UK accounting requirements, with unrealised exchange gains or losses recognised in the profit and loss account, subject to the entity’s accounting policies and materiality assessment.

Trying to reconcile foreign-currency settlements directly to a GBP bank account without a clearing structure commonly results in unexplained variances and reconciliation delays.

How A2X and Link My Books automate clearing

Manual clearing-account workflows are possible, but they are time-consuming and prone to error. Many UK Amazon sellers, particularly those working with an accountant or operating at scale, use specialist tools to automate the process.

Tools such as A2X and Link My Books extract settlement data directly from Amazon, summarise it into accounting entries, and post those entries into the clearing account. Sales, fees, refunds, reserves, VAT on fees, and adjustments are mapped consistently every period.

When the payout reaches the bank, the tools either create or guide the creation of a matching transfer from the clearing account to the bank account. Reconciliation can become a more controlled, repeatable process rather than a forensic exercise.

If you are evaluating tools, our guide to Best Accounting Software for Amazon Sellers explains how different platforms handle clearing, VAT, and multi-currency automation in practice.

Why this matters for UK compliance

UK accounting standards generally require accrual-based reporting. Under UK GAAP, revenue is typically recognised when risks and rewards transfer, which for physical goods is most often when they are delivered, not when Amazon pays out.

HMRC’s Making Tax Digital rules also require digital records that can be traced back to source data and reconciled to cash movements.

A clearing account allows both requirements to be met in practice at the same time. Settlement activity is recorded accurately, VAT is reported consistently, and the bank account reconciles cleanly to the general ledger.

For Amazon sellers, a properly configured clearing account forms the foundation that everything else relies on. Without it, even the best software is far more likely to produce accounts that are difficult to reconcile, review, and defend.

5. Mapping Amazon Transactions in Xero

Amazon settlement reports compress thousands of underlying orders, fees, refunds, and adjustments into summary figures that are paid out every 14 days. While this makes cash flow easy to follow, it creates accounting risk.

Xero requires transactions to be mapped to specific accounts and VAT tax codes. If the chart of accounts and mappings are not designed with UK VAT rules in mind, the numbers can reconcile to the bank while still being wrong for HMRC compliance.

For UK Amazon sellers, correct mapping is not about mirroring the payout total. It is about translating Amazon’s operational data into a structure that supports accurate VAT returns, clear profitability analysis, and defensible records if HMRC ever queries the figures.

Many sellers rely on specialist integration tools to do this consistently, which is why choosing the right software for Amazon sellers matters when setting up Xero mappings.

Mapping gross sales to the right revenue account

Many UK e-commerce accountants do not post all Amazon sales into a single generic “Amazon Sales” account. Instead, revenue is segmented by marketplace and VAT treatment so that VAT returns can be reconciled cleanly and turnover can be analysed meaningfully.

A common structure separates:

• UK standard-rated sales
• UK zero-rated sales such as books
• Marketplace Facilitator VAT sales where Amazon is the deemed supplier
• EU or rest-of-world sales that are usually zero-rated for UK VAT purposes

This structure matters because UK VAT returns work on classification, not totals. Standard-rated UK sales create output VAT that flows into Box 1 and Box 6. Zero-rated sales still flow into Box 6 but do not generate VAT.

Marketplace Facilitator sales do not generally create output VAT for the seller in situations where Amazon is treated as the supplier for VAT purposes, depending on the facts of the transaction.

For example, if a seller has £70,000 of standard-rated UK sales and £15,000 of Marketplace Facilitator sales but posts all £85,000 into one standard-rated revenue account, Xero will calculate output VAT on the full amount by default. The result is an overstated VAT liability and a reconciliation gap that HMRC is increasingly likely to question, particularly given the data it now receives directly from Amazon.

Mapping Amazon fees (referral, FBA, storage, advertising)

Amazon fees are typically mapped as operating expenses, not cost of goods sold. Referral fees, fulfilment fees, storage charges, advertising costs, and subscription fees are all services provided by Amazon, not costs of acquiring or manufacturing inventory.

Most UK sellers benefit from splitting these fees into separate accounts so that VAT treatment and cost analysis remain clear. Referral fees, FBA fulfilment fees, storage fees, advertising charges, and professional subscription fees each have different operational drivers and, in some cases, different VAT outcomes.

Since 1 August 2024, Amazon began charging UK VAT at 20 percent on many UK-facing fees. Where these fees relate to taxable supplies and the seller satisfies the normal input tax recovery conditions, the VAT can be recoverable. This change alone makes correct fee mapping essential, because sellers who continue to use old reverse-charge or no-VAT codes often miss legitimate VAT reclaims.

EU-related fees can be subject to the reverse charge mechanism in certain circumstances under VAT rules, but since August 2024 many UK sellers see UK VAT charged on EU-marketplace fees depending on how Amazon invoices the service. For this reason, the VAT shown on the invoice will generally determine the tax code used in Xero, rather than assumptions based on marketplace alone.

If all fees are posted to a single expense account with one tax code, sellers commonly either overclaim VAT on fees that should not carry UK VAT, or fail to reclaim VAT that is clearly shown on Amazon invoices. Both outcomes create unnecessary risk.

Handling reimbursements and other income

Amazon reimbursements are not sales for accounting purposes. They are compensation payments for lost inventory, damaged stock, or billing errors, and they usually fall outside the scope of VAT.

Pre-sale reimbursements, such as compensation for inventory lost in an Amazon fulfilment centre before sale, are best mapped to a dedicated Amazon reimbursements account classified as other income with a no-VAT tax code. This keeps sales figures clean and avoids incorrectly charging VAT on compensation.

Post-sale reimbursements linked to customer returns require different handling. In these cases, the reimbursement is economically linked to a sale that has already occurred. Mapping these amounts to a contra-revenue account ensures the original sale and its VAT are reversed together, preserving the integrity of both revenue and VAT reporting.

Automation tools such as A2X and Link My Books can usually distinguish between these reimbursement types automatically, provided the accounts and tax codes are set up correctly in advance.

Mapping refunds and chargebacks correctly

Refunds and chargebacks are generally not posted to cost of goods sold under typical accounting treatments. They are reversals of revenue, not new expenses.

In Xero, refunds are best mapped to a contra-revenue account using the same VAT tax code as the original sale. This helps ensure that when a refund is posted, the output VAT originally declared is automatically reversed. If refunds are coded with a no-VAT tax code instead, VAT remains overstated on the VAT return even though the customer has been refunded in full.

Chargebacks require a split treatment. The disputed sale amount should be reversed through contra-revenue, while any chargeback or dispute fees charged by Amazon or the card provider should be posted separately as operating expenses. This preserves clarity between lost revenue and the cost of payment disputes.

Timing also matters. Under UK accrual accounting principles set out in FRS 102, revenue and related reversals are recognised in the period in which the underlying obligation arises, not when the cash movement occurs. A properly used Amazon clearing account allows this timing difference to be handled without distorting monthly or quarterly results.

VAT treatment for Amazon revenue and fees

In Xero, VAT is driven by tax codes attached to transactions, not by descriptions in Amazon reports. Correct mapping ensures VAT flows to the right boxes on the VAT return.

In practice, UK standard-rated sales use a standard VAT code and feed Boxes 1 and 6. Zero-rated UK sales and exports feed Box 6 only. Marketplace Facilitator sales may not create output VAT for the seller in cases where Amazon is treated as the deemed supplier for VAT purposes, depending on the transaction details.

Many UK Amazon fees now include UK VAT at 20 percent and, where supported by valid invoices and the seller meets input tax recovery conditions, the VAT may be recoverable. EU-related fees require careful review of the invoice, as VAT treatment depends on how Amazon has billed the service. Reimbursements normally use no-VAT codes because they are compensation rather than consideration for a supply.

For the VAT logic behind Amazon sales, including FBA and deemed supplier rules, see: FBA VAT for Amazon Sellers – What You Need to Know.

UK accountants specialising in Amazon rarely rely on default mappings alone. They typically customise the chart of accounts and automation rules so that sales, fees, refunds, and VAT treatment can be reconciled cleanly and explained confidently if HMRC ever raises a query.

6. Reconciling Amazon Payouts Against Your Bank Feed

Reconciling Amazon payouts is the point where Amazon’s internal accounting meets your own books. While settlement reports explain how Amazon calculated a payout, your bank feed confirms what you actually received. The reconciliation process exists to bridge those two views and demonstrate that amounts Amazon says it paid have been correctly recorded, classified, and cleared in Xero.

For a broader monthly framework, this reconciliation process should be completed as part of your Amazon Seller Bookkeeping Checklist process, where clearing account reviews and payout matching are handled as a standard month-end control.

At a practical level, reconciliation is not about checking that cash arrived. It is about confirming that the settlement journal, the clearing account, and the bank transaction all agree, and that any differences are explained by timing, reserves, currency conversion, or separately billed charges.

Posting the Amazon settlement journal

The reconciliation process starts with posting the Amazon settlement journal. This journal summarises the activity for a settlement period and establishes the expected net payout.

Whether the journal is created manually or imported using a connector, it should include separate lines for gross sales, refunds, Amazon fees, reimbursements, reserves, and any VAT charged on fees. These lines should mathematically net to the amount Amazon intends to pay out, before any timing differences or later deductions.

In Xero, the settlement journal is typically posted to an Amazon clearing account rather than directly to the bank account. The clearing account acts as a temporary holding account that represents cash due from Amazon but not yet received. This design is deliberate. It allows revenue and expenses to be recognised on an accrual basis, while the cash movement is dealt with separately when the payout lands.

If the settlement journal is incomplete or mis-posted, reconciliation issues are likely later, even if the bank deposit looks correct. For that reason, the settlement journal should be reviewed against the original settlement report before moving on to bank matching.

Matching the net payout to your bank transaction

Once the settlement journal is posted, the next step is to match the net payout to the bank transaction when it appears in your bank feed.

In Xero, this is usually done by posting or confirming a transfer from the Amazon clearing account to the relevant bank account for the exact amount received. When the bank deposit is matched to this transfer, the clearing account balance should reduce accordingly.

A key principle is that the bank feed does not drive revenue or expense recognition. It only clears the amount that was already recognised through the settlement journal. If a seller instead posts the bank deposit directly to sales or fees, reconciliation may appear to work in the short term, but the underlying records will not support VAT reporting or audit review.

Where Amazon deposits are delayed by several days, it is normal for the clearing account to show a temporary balance. This does not indicate an error as long as the deposit arrives within the expected timeframe and clears the balance when matched.

Clearing account equals zero, what it means

A correctly functioning Amazon clearing account should return to zero once a settlement has fully cleared. This is a strong signal that the settlement journal and the bank deposit agree.

A zero balance means that all settlement activity has been accounted for, all deductions have been recognised, and the corresponding cash has been received or explained. It also means that no Amazon-related amounts are being carried forward incorrectly on the balance sheet.

If the clearing account does not return to zero after the bank deposit has been matched, this usually indicates one of three things. Either part of the settlement was not included in the journal, an additional deduction was applied outside the settlement report, or the wrong amount was matched during reconciliation.

Persistent balances in the clearing account should not be ignored. They represent unresolved differences that can compound over time and make month-end and VAT reconciliation increasingly difficult.

How to handle timing differences (ads, refunds, reserves)

Many reconciliation differences are caused by timing rather than errors.

Advertising charges are a common example. Amazon Ads can be billed separately from FBA settlements, either through threshold charges during the month or via a monthly invoice issued after month-end. When this happens, the settlement journal may not include advertising costs that are deducted from the seller account shortly before or after payout. These charges need to be posted separately so the clearing account can be adjusted correctly.

Refunds and chargebacks also introduce timing gaps. A customer return may be initiated in one month but deducted from the seller’s balance several weeks later. Under accrual accounting, the revenue reversal should be recognised when the return occurs, not when Amazon finally processes the deduction. The later cash movement then clears against the balance already recognised.

Account-level reserves create another common timing difference. Amazon may withhold a portion of a payout as a reserve without treating it as a fee. These amounts are typically posted to a separate reserve asset account, not expensed, and released when Amazon pays them out in a later settlement.

Understanding these timing mechanics allows reconciliation differences to be explained and documented rather than treated as unexplained errors.

Fixing reconciliation mismatches

When a payout does not reconcile cleanly, the first step is to compare three figures: the net payout shown in the settlement report, the amount posted to the clearing account, and the amount received in the bank.

If the clearing account amount matches the settlement but not the bank, the difference is usually caused by reserves, advertising deductions, currency conversion, or cross-marketplace offsets. These require adjustment entries rather than changes to revenue.

If the bank amount matches the settlement but the clearing account does not clear, the issue is often a missing or duplicated journal entry, or a settlement posted to the wrong account.

The correct approach is usually to adjust the clearing account, not the bank feed or the original sales figures. Each adjustment should be supported by documentation from Seller Central or Amazon invoices and described clearly in Xero so the reconciliation can be followed later.

When the reconciliation is complete, the clearing account should return to zero, the bank deposit should be fully matched, and the settlement should be traceable from Amazon report to general ledger to bank statement with any differences clearly explained.

7. Multi-Marketplace and Multi-Currency Considerations

Selling across multiple Amazon marketplaces opens up significant growth opportunities, but it also introduces layers of accounting complexity that UK sellers often underestimate.

When a business trades simultaneously on Amazon UK, EU, and US marketplaces, it is no longer dealing with a single payout mechanism or tax framework. Each region operates its own settlement logic, currency rules, and tax treatment, all of which should be reflected accurately in the accounting records.

For UK sellers using Amazon and accounting software such as Xero, the challenge is configuring systems so that settlements reconcile correctly, VAT is reported accurately, and foreign exchange movements are controlled rather than obscured.

Without a structured approach, multi-marketplace selling often leads to reconciliation errors, distorted margins, and VAT compliance risks.

This section explains how payouts differ across regions, how foreign-currency settlement reports should be handled, how FX gains and losses arise in practice, and why multi-currency clearing accounts are generally essential for UK Amazon sellers.

EU and US marketplaces: how payouts differ

Amazon UK settlements are generated in GBP and follow UK VAT rules. From August 2024, many Amazon fees billed to UK-established sellers include 20 percent UK VAT where invoiced by the relevant UK entity, shown as separate VAT lines in settlement reports.

Product revenue, fees, VAT on fees, refunds, reimbursements, and adjustments are clearly separated, which can make UK reconciliation relatively straightforward once the clearing account is configured correctly.

EU marketplaces operate differently. Settlements are generated in euros, and sales are subject to country-specific VAT rules depending on where goods are stored and where customers are located. Storage fees are calculated using cubic metres rather than cubic feet, which materially affects cost analysis when EU and UK fees are compared side by side.

Fees are billed by the relevant Amazon entity and, from August 2024, often include VAT under Amazon’s updated invoicing rules. For many UK sellers, this may appear as UK VAT on some EU marketplace fees depending on how Amazon invoices those services, rather than local country VAT. This makes it important to rely on the VAT shown on Amazon invoices and settlement data, rather than assuming a fixed country rate based on the marketplace alone.

US marketplaces differ again. Amazon US settlements are denominated in USD and operate outside the VAT system entirely. The US uses state-level sales tax rather than VAT, and Amazon typically acts as the marketplace facilitator in most cases, collecting and remitting sales tax on behalf of sellers. These sales tax amounts appear in settlement reports for information but do not typically create VAT liabilities for UK sellers. Amazon fees in the US are charged net, generally with no VAT component.

For accounting purposes, each marketplace is usually treated as a separate revenue and settlement stream, even if all payouts ultimately arrive in a single UK bank account.

Handling foreign-currency settlement reports

Amazon settlement reports are generally denominated in the native currency of the marketplace. UK reports are in GBP, EU reports in EUR, and US reports in USD. Amazon does not convert figures within the settlement report itself. Currency conversion only occurs when funds are paid out or revalued later in the accounting system.

Best practice for UK sellers is generally to post each settlement to Xero in its original currency. Xero’s multi-currency engine then handles translation and revaluation in line with UK accounting standards. Prematurely converting settlements to GBP before posting can break the audit trail and often leads to incorrect VAT treatment, hidden FX differences, and reconciliation failures.

Specialist tools such as A2X or Link My Books are designed to post Amazon settlements in the source currency, provided multi-currency is enabled in Xero. The settlement report should generally be treated as the authoritative transaction record, with currency conversion recognised only when funds are paid out or when balances are revalued at period end.

FX gain and loss posting in Xero

Foreign exchange differences arise because Amazon settlement timing, payout timing, and accounting recognition dates rarely align. Xero automatically posts realised FX gains or losses when a foreign-currency settlement is matched to a bank transaction. It also performs automatic revaluations of foreign-currency balances at period end, creating unrealised FX movements.

Amazon accounting introduces additional FX complexity because estimated exchange rates used when settlements are generated often differ from the confirmed rates applied when payouts complete. This commonly leaves small residual balances in clearing accounts once a payout has been reconciled.

Best practice is to review all Amazon clearing accounts at month end and post a single FX adjustment journal to clear any residual balances to an FX gain or loss account. This helps keep clearing accounts tidy and FX movements reported transparently rather than accumulating unnoticed over time.

Understanding Amazon Currency Converter

Many UK sellers allow Amazon to convert EU and US earnings into GBP using Amazon Currency Converter for Sellers. Under this service, Amazon applies an exchange rate that embeds a conversion fee, typically between 0.75 percent and 1.5 percent, depending on seller volume. The fee is not shown as a separate line item. Instead, it is built into the rate offered.

From an accounting perspective, this means the conversion cost appears as part of the settlement outcome rather than as a visible expense. Xero should be reconciled to the actual GBP amount received in the bank, not an estimated figure based on mid-market rates. While conversion costs are generally allowable business expenses, they represent margin leakage that can materially affect profitability at scale.

Some sellers choose to receive EUR or USD payouts into dedicated foreign-currency accounts to control conversion timing and reduce costs. Whichever approach is used, the accounting records should reflect the actual amounts received and the FX differences arising.

Multi-currency clearing accounts

For UK sellers operating across multiple marketplaces, separate clearing accounts for each currency are generally required. A single generic “Amazon clearing account” is not sufficient once EUR and USD settlements are involved.

Best practice is to maintain distinct clearing accounts for GBP, EUR, and USD. Each settlement is posted to the clearing account that matches its currency. Each payout then clears that account when funds are received. This structure prevents different currencies from being mixed, isolates FX differences by currency, and allows each regional settlement cycle to be reconciled independently.

At month end, clearing account balances should reflect only genuine pending settlements or reserves held by Amazon. Any unexplained balances usually indicate timing issues, FX differences, or mapping errors that need to be resolved before accounts are finalised.

Where sellers store inventory in EU warehouses or meet distance-selling thresholds in certain Member States, additional VAT registration and reporting obligations may arise depending on local rules and the seller’s circumstances.

These scenarios can trigger EU VAT registrations and additional reporting requirements, which should be reflected appropriately in the accounting structure based on the seller’s specific VAT position and reporting obligations. This is covered in more detail in our guide to VAT Registration for Amazon Sellers, which explains how cross-border VAT rules interact with Amazon settlement data and UK bookkeeping.

Why this matters for UK sellers

Multi-marketplace selling increases revenue potential, but it also increases accounting risk if not handled correctly. Without currency-specific clearing accounts and disciplined FX treatment, reconciliation errors multiply, VAT reporting becomes unreliable, and management accounts lose credibility.

A well-structured multi-currency workflow allows UK Amazon sellers to maintain clean books, defensible VAT positions, and clear visibility over profitability by region. More importantly, it creates a controlled, repeatable accounting process that scales as the business grows, rather than one that becomes harder to manage with every new marketplace added.

8. Stripe and PayPal Accounting for Amazon Sellers

The role of Stripe and PayPal in an Amazon-led business

Many UK Amazon sellers do not operate exclusively through Amazon. Alongside marketplace sales, it is common to see the same legal entity accepting payments through Stripe and PayPal for Shopify stores, wholesale customers, subscriptions, or B2B orders.

From an accounting perspective, this matters because HMRC generally views all of these income streams as part of one taxable business, not separate operations. Revenue earned via Amazon, Stripe, and PayPal all contributes to:

• VAT registration thresholds (see UK VAT Thresholds Explained for how the £90,000 rolling test operates in practice)
• VAT reporting obligations
• Corporation tax or income tax calculations
• Management accounts used for decision-making

The challenge for Amazon sellers is that Stripe and PayPal operate very differently from Amazon’s settlement model. If they are treated casually, for example as simple bank deposits, errors can quickly appear in turnover figures, VAT returns, and reconciliation controls.

Why Amazon sellers often mis-handle Stripe and PayPal

Amazon accounting forces discipline because sellers will generally work from settlement reports. Stripe and PayPal, by contrast, pay out frequently and appear simpler on the surface. This often leads to a common but risky shortcut.

A typical mistake is to:

• Record Amazon sales from settlement reports, but
• Treat Stripe or PayPal payouts as net revenue when they hit the bank

For example, a £9,700 Stripe deposit is often posted as £9,700 of turnover, even though:

• The customer may have paid £10,000
• Stripe retained processing fees
• Refunds or chargebacks may already be netted off
• FX conversion may have occurred before payout

This approach may understate revenue, misclassify fees, and distort VAT calculations in practice. Over time, the difference between platform reports and accounting records becomes large enough to cause compliance risk.

How Amazon, Stripe, and PayPal payouts differ

Amazon operates a settlement model. Transactions are accumulated over a defined period, and Amazon issues a settlement report showing gross sales, refunds, fees, VAT, and adjustments. One net payout follows.

Stripe and PayPal operate payout models. Payments are captured individually, fees are deducted immediately, and funds are released to the bank on a rolling basis. The payout itself does not contain the full accounting story.

This structural difference means:

• Amazon requires settlement-level accounting
• Stripe and PayPal require transaction-level or clearing-account accounting

Treating all three platforms in the same way inside Xero often leads to errors.

Mapping fees across Stripe, PayPal, and Amazon

Each platform charges fees under different VAT rules, and these differences should be reflected appropriately in the chart of accounts.

Amazon seller fees charged to UK sellers are now generally subject to 20 percent UK VAT, following the August 2024 change. VAT appears separately in settlement reports and can usually be reclaimed if the seller is VAT-registered.

Stripe fees are supplied from outside the UK, typically via Stripe’s Irish entity. For VAT-registered UK businesses that provide a valid VAT number, Stripe fees typically fall under the reverse charge mechanism for services received from overseas suppliers, in line with HMRC guidance on the VAT reverse charge for services. This means:

• No VAT is charged on the Stripe invoice
• The UK business will usually need to apply the reverse charge to those fees, depending on its VAT status and the nature of its supplies
• The VAT is declared and usually reclaimed in the same VAT return, resulting in a nil cash impact but a mandatory reporting entry

For a deeper breakdown of Stripe’s VAT treatment, reverse charge rules, and how fees should be recorded in UK accounting software, see our guide on How Stripe Fees Are Treated in Accounting.

PayPal fees are treated differently. PayPal is generally regarded as supplying exempt financial services, so:

• No VAT is charged
• No reverse charge applies
• No input VAT can be reclaimed

If all platform fees are posted to a single “merchant fees” account with one tax code, VAT reporting is likely to be wrong. Common consequences include over-claiming VAT on PayPal fees or failing to apply the reverse charge to Stripe fees.

Reconciling Stripe and PayPal in Xero

There are two commonly used approaches to reconciling Stripe and PayPal payouts in Xero, and the correct choice depends on transaction volume and reporting needs.

For very low volumes, direct bank feed reconciliation can work, provided rules are set up to split gross revenue from fees correctly. This approach tends to break down as volumes increase.

For most multi-channel Amazon sellers, clearing accounts provide better control. Under a clearing-account approach:

• Gross Stripe or PayPal revenue is posted to income
• Fees are posted separately with correct VAT treatment
• The net payout clears the balance when funds hit the bank

This mirrors the Amazon settlement workflow and makes it much easier to:

• Reconcile payouts cleanly
• Handle refunds that span accounting periods
• Apply correct month-end cut-offs under UK GAAP and FRS 102

Tracking multi-channel revenue accurately

Once Amazon, Stripe, and PayPal are all feeding into the same accounting system, visibility becomes critical. The safest structures are either:

• Separate revenue accounts per channel, or
• A single revenue account combined with mandatory tracking categories in Xero

Tracking categories are often preferred because they allow profitability analysis by channel without bloating the chart of accounts. They also make it easier to reconcile platform reports to accounting totals.

From 2025 onwards, HMRC is expected to receive transaction data from platforms such as Stripe and PayPal for in-scope sellers under international data-sharing rules. Where reported platform figures do not align with VAT returns or statutory accounts, the risk of enquiry may increase.

Accurate mapping, disciplined reconciliation, and consistent revenue recognition are increasingly important for multi-channel sellers.

Why this matters for Amazon-led businesses

Amazon sellers often focus on getting Amazon accounting right and underestimate the impact of Stripe and PayPal. In reality, these platforms affect:

• VAT accuracy
• Revenue completeness
• FX reporting
• Audit defensibility

When Stripe and PayPal are treated as first-class accounting streams, alongside Amazon rather than beneath it, sellers gain clean books, defensible VAT positions, and reliable insight into which channels are genuinely profitable.

9. Common Amazon Reconciliation Errors

Amazon reconciliation errors rarely happen in isolation in practice. They usually surface when settlement reports, bank deposits, clearing accounts, and VAT records stop aligning properly, often weeks after the original transaction occurred.

These problems tend to sit downstream of the wider Amazon accounting structure, so if you are not already confident in how Amazon settlements, reserves, fees, and VAT should flow through Xero, it may be worth reviewing the Amazon Seller Accounting – Complete Guide before working through the specific reconciliation issues below.

This section focuses on the most common reconciliation errors UK Amazon sellers encounter once settlements are being imported into accounting software, whether manually or via tools such as A2X or Link My Books.

Each issue is explored from a practical accounting perspective, explaining why it occurs, how it shows up in Xero, and what corrective steps are commonly used to keep records accurate and HMRC-compliant.

Clearing account not returning to zero

An Amazon clearing account is designed to be a temporary holding account. When a settlement is posted, the clearing account balance increases. When the corresponding bank deposit is reconciled, the balance should return to zero. If it does not, there is usually an underlying reconciliation issue that needs investigation.

The most common causes include missing settlement periods, withheld reserves, split-month settlements, negative settlements, foreign exchange differences, or duplicate journals.

A typical example is a settlement showing £20,000 of net proceeds in Seller Central, while only £15,000 is paid into the bank because Amazon has withheld £5,000 under the account-level reserve. If the full £20,000 is posted to the clearing account but only £15,000 is reconciled against the bank deposit, the remaining £5,000 will sit in the clearing account unless it is reclassified to a reserve or pending payout account.

Split-month settlements can also cause persistent balances. When a settlement spans two accounting periods, automation tools create two linked entries with a carried-forward balance. If one side of that linkage is deleted, edited, or reconciled incorrectly, the clearing account will not clear correctly in either month.

From a diagnostic perspective, the correct approach is to review the clearing account transaction history line by line. Each settlement should have a matching bank deposit or a valid explanation for why the balance remains outstanding, such as reserves, pending payouts, or FX differences. Any balance that does not fall into one of those categories is likely to indicate a reconciliation error that should be reviewed and corrected as necessary.

Payout does not match the settlement report

A common concern among UK sellers is that the amount paid into the bank does not match the net payout shown in Amazon Seller Central. This discrepancy is often mechanical rather than an error, but it should be understood clearly to avoid misposting.

One frequent cause is consolidated payouts across multiple marketplaces. Amazon may combine UK, EU, and US marketplace settlements into a single GBP deposit, even though Seller Central shows separate settlement figures by marketplace and currency. Without consolidating those figures in Xero, the payout will appear incorrect.

Reserves are another major factor. Account-level reserves, performance reserves, and dispute holds reduce the cash payout but do not eliminate the seller’s entitlement to those funds. The withheld amount is often recognised as an asset until it is released, rather than left unresolved in the clearing account.

Foreign currency settlements introduce further differences. Amazon often applies an estimated exchange rate when generating the settlement and a confirmed rate when processing the payout. The resulting difference is typically recognised as an FX gain or loss rather than forced through reconciliation.

A commonly used diagnostic method is to compare three figures: the net settlement amount, the amount scheduled for payment in Seller Central, and the actual bank deposit. Differences between the first two usually relate to reserves or timing adjustments. Differences between the scheduled amount and the bank deposit usually relate to currency conversion or consolidation.

Missing settlement periods

Missing or skipped settlement periods are more common than many sellers expect, particularly for new accounts, accounts under review, or businesses relying heavily on automation tools.

One major contributor is Amazon’s delivery-date-based payment delay policy, often referred to as DD+7. Sales that occur late in a settlement period may not be released for payment until seven days after delivery, pushing them into the next settlement cycle. This can make it appear as though revenue has disappeared when, in reality, it has been deferred.

Automation tools can also fail to import settlements due to expired credentials, API interruptions, subscription lapses, or archived reports. Amazon automatically archives older settlements, and these typically need to be manually requested before tools can access them.

A practical way to identify missing settlements is to compare three sources: the list of settlements in Seller Central, the settlement entries posted in Xero, and the bank deposits received. Any settlement present in Seller Central but missing from Xero will normally require investigation and recovery, either by triggering a resync or by manually importing the report.

From an HMRC compliance perspective, missing settlements present a risk. Under HMRC’s Making Tax Digital rules, businesses are required to maintain complete and digitally linked records that support VAT submissions and provide an audit trail. Any recovered settlement should be documented clearly, with evidence retained to explain when and why it was posted late.

Refunds recorded in the wrong period

Refund timing is one of the most common causes of distorted monthly figures for Amazon sellers. Amazon may take several weeks to process returns, and chargebacks can take even longer to resolve. As a result, refunds often appear in a later settlement period than the original sale.

If accounting is based purely on payout data, revenue will be overstated in the sale month and understated in the refund month. This distortion affects both profit reporting and VAT accuracy.

From a VAT perspective, output VAT is generally adjusted in line with the original sale. If refunds are recorded only when they appear in a later settlement, VAT may be shifted between quarters, which can attract HMRC scrutiny if left uncorrected.

The standard approach under UK GAAP is to accrue for known refunds or chargebacks once they are probable and measurable. When the refund is eventually processed through Amazon, the accrual is reversed. This ensures that revenue, costs, and VAT are recognised in the correct period.

Duplicate journals from A2X or Link My Books

Duplicate settlement journals are a relatively common issue for sellers using automation tools. They typically arise when settlements are re-synced, date ranges are extended backwards, or multiple marketplace connections are configured incorrectly.

The symptom is straightforward. Xero shows two identical settlement entries, but only one bank deposit exists. As a result, the clearing account does not return to zero.

Detection involves counting the number of settlements posted in Xero and comparing that figure to Seller Central. If Xero shows more settlements than Amazon, duplicates exist.

Correction requires identifying the original entry, unreconciling any duplicates that have been matched to the bank, deleting or voiding the duplicate, and then re-reconciling the correct settlement. Prevention involves careful control of sync ranges, avoiding unnecessary resyncs, and ensuring only one connection exists per marketplace.

Incorrect VAT mapping

VAT mapping errors are among the higher-risk reconciliation issues because they directly affect compliance.

Since August 2024, many Amazon seller fees billed to UK sellers include UK VAT rather than the reverse charge mechanism. Sellers who have not updated their tax codes may be misreporting VAT, either under-claiming input tax or creating mismatches between Amazon-reported VAT and VAT returns.

Other common errors include applying UK VAT to EU marketplace sales that may follow destination VAT rules, coding Stripe fees as standard-rated instead of reverse-charged, or treating PayPal fees as VATable when they are VAT-exempt.

HMRC increasingly cross-checks VAT returns using third-party data received directly from platforms and payment processors. Incorrect VAT mapping is therefore more likely to be identified. Small errors can usually be corrected in the next return, but larger errors may need to be disclosed separately to HMRC in accordance with the applicable error reporting thresholds and procedures.

Small residual differences after reconciliation

Sometimes reconciliation leaves a small residual balance, often a few pounds or less. These differences are usually caused by FX rounding, advertising charges billed separately from settlements, partial reimbursements, or retroactive fee adjustments.

The correct response is not to force reconciliation, but to identify the source. Reviewing advertising billing settings, checking settlement detail reports, comparing estimated and confirmed exchange rates, and searching for late adjustment entries will usually reveal the cause.

Once identified, the residual is usually cleared through the appropriate account, such as FX gains and losses, advertising expenses, or reimbursement write-offs. Allowing small balances to accumulate can undermine confidence in the accounts and complicate year-end reporting.

Why these errors matter

Unresolved reconciliation errors lead to unreliable financial data, incorrect VAT returns, and increased HMRC risk. They also make it harder for sellers to understand true profitability, manage cash flow, or make informed business decisions.

A disciplined reconciliation process, built around a properly structured clearing account and supported by regular diagnostics, ensures that Amazon data, bank records, and accounting reports remain aligned. For UK sellers, this is not just good bookkeeping practice, it is an essential control for compliance under Making Tax Digital and for maintaining confidence in the numbers that drive the business.

10. Month-End Review Checklist

Month-end is where Amazon bookkeeping either becomes reliable and repeatable, or can quietly drift out of control. For UK Amazon sellers, the purpose of a month-end review is not just to close the books, but to confirm that every settlement, VAT category, reimbursement, and currency balance has been captured correctly and can be supported if HMRC raises questions.

Amazon’s settlement model, delivery-date deferrals, reserves, multi-currency payouts, and post-August 2024 VAT changes mean that relying on bank deposits alone may not be sufficient.

A proper month-end review creates a control point between Amazon Seller Central and your accounting software, usually Xero, and helps ensure the numbers you rely on for VAT returns, management accounts, and cash-flow planning are grounded in reality.

For sellers who want a structured, repeatable process, this section should be used alongside the Amazon Seller Bookkeeping Checklist, which sets out the ongoing monthly bookkeeping tasks that feed directly into an accurate month-end close.

Confirm all settlement periods are posted

The first and most important month-end task is confirming that every Amazon settlement period relevant to the month has been downloaded, posted to Xero, and accounted for.

Amazon operates on fixed settlement cycles, most commonly every 14 days. These cycles rarely align neatly with calendar months, and since the introduction of delivery-date plus seven days (DD+7), late-month sales are often deferred into the following settlement. This makes it easy to assume a settlement is missing when it is simply delayed, or to overlook a settlement that should have been posted but was not.

An effective check starts in Seller Central. Navigate to Payments and review the list of settlements covering the month. Count how many settlements you expect based on your payout frequency, then compare that to how many settlement entries exist in Xero. If the counts do not match, the month-end review should pause until the discrepancy is explained.

It can be helpful to review settlement statuses carefully. Completed and scheduled settlements will normally appear in Xero, even if the bank deposit has not yet arrived. Settlements marked as pending, on hold, or retrying may legitimately be missing from the accounts, but their status should be documented so that any absence is clearly understood and not mistaken for an omission.

For sellers operating across multiple marketplaces, this check is often performed separately for each marketplace. A single consolidated GBP payout does not reduce the requirement to post and reconcile each underlying settlement.

Check the clearing account equals zero

Once all settlements are posted, the Amazon clearing account becomes the key control account for month-end accuracy.

In a typical month-end close, the clearing account should return to zero, or reflect only clearly identifiable items such as unsettled payouts or account-level reserves. Any unexplained balance may indicate something has been missed or duplicated.

Small residual balances can sometimes arise from foreign exchange rounding, but balances above a few pounds usually indicate a missing settlement, a duplicate posting, a reserve that has not been reclassified, or a transaction that has not yet been matched to a bank deposit.

Negative balances are equally important. These typically arise when a settlement has been posted but the payout has not yet arrived. A short delay is normal, but if the balance remains negative for more than a few business days, Seller Central should be checked for payout holds, retries, or account reviews.

At month-end, you should be able to explain every pound in the clearing account. If you cannot, the books may not be ready to be closed.

Verify VAT categories

VAT verification is a critical month-end step for UK Amazon sellers, particularly since Amazon’s fee VAT treatment changed in August 2024.

At month-end, it can be useful to review the VAT treatment applied to UK standard-rated sales, zero-rated sales, Amazon seller fees, advertising fees, and any third-party payment processor fees such as Stripe or PayPal.

Amazon seller fees for UK sellers are now generally subject to 20 percent UK VAT, based on Amazon’s current invoicing approach, rather than the reverse charge. Sellers who continue to apply reverse-charge tax codes can underclaim input VAT and create inconsistencies between Amazon VAT invoices and VAT returns.

A practical approach is to sample recent transactions in Xero and confirm that the tax codes applied align with the underlying transaction type and jurisdiction. You should also reconcile movements in Box 1 and Box 4 to commercial activity for the month. Unexplained movements often point to VAT mapping errors.

Review reimbursement entries

Reimbursements require deliberate review because they affect inventory, cost of goods sold, and VAT.

You should confirm that all reimbursements shown in Seller Central for the month appear in Xero, either within settlement postings or as separate reimbursement entries. Lost or damaged inventory reimbursements usually require an adjustment to inventory or cost of goods sold rather than being treated as ordinary sales income.

From a compliance perspective, Seller Central reports supporting reimbursements should be retained in line with record-keeping expectations. Inventory adjustment reports, reimbursement reports, and removal order reports form part of the audit trail HMRC may request during a VAT or compliance review.

Month-end is also the point at which unreimbursed inventory losses should be reviewed against Amazon’s claim windows, so that eligible claims are not missed.

Ensure multi-currency balances are accurate

For sellers receiving EUR or USD settlements, month-end often includes additional checks around foreign currency balances and exchange differences.

Each foreign currency settlement should be recorded in its original currency, with Xero handling conversion and revaluation. Clearing accounts and foreign currency bank accounts should be reviewed to ensure balances represent genuine unsettled amounts rather than reconciliation errors.

Many sellers run Xero’s currency revaluation process at month-end to recognise unrealised exchange gains or losses on outstanding balances, ensuring compliance with UK accounting standards.

If Amazon’s currency conversion service is used, Amazon’s conversion figures should be compared to the GBP amounts received. Small differences are normal, but unexplained variances should be investigated where material and recorded as exchange differences.

Export downloadable reports for record-keeping

The final step of the month-end checklist is documentation.

Even well-reconciled accounts can be weak from a compliance perspective if the supporting evidence is not retained. At month-end, key Amazon reports should be downloaded and stored, including settlement reports, transaction views, reimbursement reports, inventory adjustments, and VAT invoices.

These files form part of your digital records under Making Tax Digital and are generally retained for at least six years under UK record-keeping guidance. Reports should be stored in a consistent, dated folder structure alongside reconciliation notes explaining any variances or timing differences.

A disciplined month-end review does more than tidy up the numbers. It helps ensure Amazon accounting is accurate, compliant, and scalable, and it significantly reduces the risk of VAT errors, HMRC queries, and painful clean-up work later in the year.

11. Action Plan and Download the Reconciliation Template

By this point in the guide, you may now have a clearer picture of how Amazon payouts flow, where reconciliation problems usually arise, and what a good month-end process looks like in practice.

This final section brings everything together into a practical action plan. The aim is to help you move from understanding to practical execution, whether you are behind on your bookkeeping, transitioning to automation, or tightening up an existing process.

This section is also where the reconciliation template fits in. When used appropriately, the template can serve as a bridge between Amazon Seller Central, your accounting software, and your VAT returns. It provides structure, evidence, and repeatability to what is otherwise a fragmented process.

What to do if you are behind on reconciliation

If you are several months behind on Amazon reconciliation, the most important step is to stop trying to fix everything at once. Some UK accountants use a staged approach that prioritises compliance risk over historical perfection.

Start by identifying how far back the backlog goes and which periods matter most. The immediate priority is typically the most recent completed VAT quarter, followed by any periods that affect an upcoming year end. Older periods can be cleaned up later, but VAT deadlines and Companies House filing dates cannot.

The practical steps usually look like this:

• Pull bank statements for the last six to twelve months and list all Amazon deposits.
• Compare those deposits to settlement periods in Amazon Seller Central to identify missing or unposted settlements.
• Request any archived settlement reports older than 90 days.
• Reconcile the most recent VAT quarter first, then work backwards month by month.

If the backlog exceeds three months, or if the Amazon clearing account does not return to zero once postings are made, that may indicate it could be helpful to involve an accountant rather than continuing to troubleshoot alone.

How to migrate from manual spreadsheets to automated tools

Moving from spreadsheets to automation is not just about switching on software. The transition needs a clean cutover point to avoid duplicated income, overstated revenue, or broken VAT figures.

Before enabling any automation, it can be beneficial to review existing entries in Xero. Draft invoices can usually be deleted safely, but posted invoices and journals are typically voided rather than removed to preserve an audit trail. Decide on a cutover date, usually the day before the last manually entered settlement, and lock earlier periods once they are correct.

Only once the chart of accounts, VAT codes, and clearing accounts are set up cleanly should automation begin. As a practical safeguard, it is generally advisable to review the first one or two settlements manually before enabling full auto-posting.

When to use A2X or Link My Books

Both A2X and Link My Books solve the same core problem, translating Amazon settlement data into accounting entries, but they suit different seller profiles.

For UK sellers trading on multiple Amazon marketplaces, especially across Europe, Link My Books is often perceived as more cost effective and handles VAT and deferred transactions with less manual intervention out of the box. For sellers with a long-standing setup already built around A2X, it can make sense to stay put unless the cost or complexity has outgrown the tool.

The key decision factors are transaction volume, number of marketplaces, VAT complexity, and whether you want automated handling of refunds, reimbursements, and deferred settlement timing.

When to work with an Amazon accountant

There is a clear line between routine bookkeeping and situations where professional intervention is advisable. Persistent clearing account balances, unexplained foreign exchange differences, VAT misclassification after August 2024, and multi-country VAT registrations are all strong indicators that an accountant’s involvement may be appropriate.

This is particularly true if you receive correspondence from HMRC or if you are approaching a VAT filing deadline with unresolved discrepancies. In these cases, the cost of professional support is often lower than the potential cost of penalties, interest, or account suspension.

How to set up ongoing reconciliation processes

Once you are up to date, the goal is to stay that way with minimal effort. Many UK ecommerce accountants recommend a weekly light touch process combined with a structured month-end review.

Weekly checks focus on confirming that new settlements have posted correctly and that bank deposits match. Month-end work is where VAT, reimbursements, reserves, and clearing accounts are reviewed in full.

Using a consistent checklist, supported by your accounting software such as Xero, can help ensure that each month is closed on the same basis and that issues are identified early rather than months later.

Download your Amazon payout reconciliation template

To support all of the steps above, we have created a practical, UK-focused Amazon payout reconciliation template. It is designed to help capture settlement periods, sales and fee breakdowns, VAT codes, clearing account movements, and supporting evidence in a way that aligns with Making Tax Digital record-keeping expectations.

You can download the template here and use it as:

• A catch-up tool if you are behind.
• A control document when migrating to automation.
• A monthly reconciliation workpaper to support VAT returns and year-end accounts.