Running an Amazon FBA business involves more than recording the amount that reaches your bank account. Amazon deducts selling fees, fulfilment charges, refunds, advertising costs, and other adjustments before transferring the remaining balance. That is why amazon fba bookkeeping uk needs to focus on the complete settlement rather than simply matching Amazon deposits to sales.
For UK sellers, VAT adds another layer of complexity. Good amazon seller accounting uk should clearly separate sales, Amazon fees, VAT, and bank settlements so your accounts accurately reflect what happened on Amazon.
This guide explains how to reconcile an Amazon settlement against Xero or QuickBooks using a simple example.
What Does Amazon FBA Bookkeeping Need to Capture?
A common mistake is treating the Amazon bank deposit as the sales figure. It is not.
Amazon may receive £10,000 from customers but deduct several charges before sending money to your business bank account. Your bookkeeping therefore needs to capture both income and deductions.
Typical settlement components include:
- Product sales
- Customer refunds
- Amazon referral fees
- FBA fulfilment fees
- Storage fees
- Advertising charges
- VAT and tax-related amounts
- Promotional discounts
- Other adjustments
- Final settlement transferred to the bank
This is where amazon fba bookkeeping uk differs from straightforward bank-feed bookkeeping. The bank statement shows the final payout, while the settlement report explains how that payout was calculated.
Before You Start
Download the relevant Amazon settlement report and have your accounting software open.
For this walkthrough, we will use the following simplified figures:
| Settlement item | Example amount |
| Product sales | £10,000 |
| Customer refunds | -£500 |
| Amazon selling/referral fees | -£1,500 |
| FBA fulfilment fees | -£1,200 |
| Advertising fees | -£600 |
| Other adjustments | -£200 |
| Net settlement paid | £6,000 |
The figures are illustrative. Your Amazon report will contain more detailed transaction categories.
How to Reconcile an Amazon Settlement
Step 1: Check the Settlement Period
Start by identifying the settlement start and end dates. Do not reconcile a payment simply because it has appeared in the bank. Confirm that it corresponds to the correct settlement period.
This is especially important around month-end because a settlement generated in one month may arrive in your bank during the next month. For amazon fba bookkeeping uk, the settlement date and bank receipt should therefore be checked separately.
Step 2: Record Gross Amazon Sales
Start with the gross product sales shown in the settlement report.
Gross sales = £10,000
Do not enter only the £6,000 bank receipt as sales. Doing so would understate revenue and hide the expenses deducted by Amazon. In Xero or QuickBooks, the account structure will depend on your setup, but sales and expenses should be recorded separately. This is a key principle of amazon seller accounting uk.
Step 3: Record Customer Refunds
Next, identify refunds included in the settlement.
Customer refunds = £500
Refunds should be accounted for separately from the original sales rather than ignored because Amazon has already deducted them from the payout. Recording refunds correctly provides a clearer view of turnover and refund levels.
Step 4: Record Amazon Selling Fees
Amazon selling or referral fees should be recorded as business expenses.
Amazon selling fees = £1,500
Use an appropriate bookkeeping account rather than reducing sales by the same amount. This helps distinguish revenue from Amazon’s costs and forms an important part of amazon seller accounting uk.
Step 5: Account for FBA Fulfilment Fees
The example contains:
FBA fulfilment fees = £1,200
These costs relate to Amazon’s fulfilment service. Keeping them separate from referral fees allows you to understand how much the business is spending on fulfilment. A structured amazon fba bookkeeping uk process makes it easier to monitor these costs across different settlement periods.
Step 6: Check Advertising Charges
Advertising fees can become a significant business expense.
In our example:
Advertising fees = £600
If Amazon deducts advertising charges directly from the settlement, they still need to be reflected in your accounting records. There may be no separate bank transaction, but the expense still occurred. This is one reason ecommerce bookkeeping uk requires more than simply importing bank transactions.
Step 7: Investigate Other Adjustments
Our example includes:
Other adjustments = £200
Do not automatically post unexplained amounts to a generic expense account.
Review the underlying transaction details to determine whether the adjustment relates to reimbursements, corrections, chargebacks, inventory transactions, or another Amazon activity. If you cannot identify an amount, flag it for review instead of guessing.
Step 8: Calculate the Expected Settlement
Now calculate the net amount:
£10,000 sales
− £500 refunds
− £1,500 selling fees
− £1,200 fulfilment fees
− £600 advertising
− £200 other adjustments
= £6,000
The expected settlement is therefore £6,000.
This should agree with the amount transferred to the business bank account. Checking this calculation is a fundamental part of amazon fba bookkeeping uk.
Step 9: Match the Bank Payment
Locate the £6,000 Amazon payment in Xero or QuickBooks. Depending on your bookkeeping setup, the payment can be matched against a settlement clearing account or reconciliation entry.
The key point is not to record the £6,000 as additional sales if the £10,000 gross sales and related deductions have already been recorded. Otherwise, the same transaction may be counted twice.
Step 10: Investigate Differences
If Amazon shows £6,000 but the bank shows £5,950, investigate the £50 difference.
Check:
- Bank fees
- Currency conversion
- Additional Amazon adjustments
- Settlement timing
- Previous-period balances
- VAT treatment
- Refunds
- Transactions included in another settlement
Do not force the reconciliation by posting an unexplained balancing amount. Good amazon fba bookkeeping uk should explain why Amazon’s settlement agrees with the amount received.
How VAT Fits Into Amazon Bookkeeping
VAT requires particular attention because Amazon transactions can have different VAT treatments depending on the seller’s circumstances, customer location, fulfilment arrangements and transaction type. For amazon vat uk sellers, the correct approach is to establish the VAT treatment of each relevant transaction rather than applying one rate to the entire settlement.
Do not assume that the amount deposited by Amazon is the figure that should appear on the VAT return.VAT on Amazon fees also needs to be considered. The treatment of individual charges should be supported by the relevant Amazon invoice or tax documentation.
For amazon vat uk sellers, keeping these documents with settlement records makes VAT reviews easier.
Common Amazon Bookkeeping Mistakes
Several mistakes occur frequently when Amazon bookkeeping is handled manually:
Recording bank deposits as sales: This ignores fees and refunds deducted before payment.
Combining all Amazon charges: This makes it harder to analyse fulfilment, advertising and selling costs.
Ignoring settlement timing: Month-end payments can create differences between Amazon and the bank.
Guessing VAT treatment: Transactions should be reviewed according to the applicable rules and documentation.
Failing to reconcile refunds: Unrecorded refunds can distort revenue figures.
Using unexplained adjustments: Material differences should always have a clear explanation.
A structured ecommerce bookkeeping uk process helps prevent these issues from accumulating.
Xero or QuickBooks: What Should Reconciliation Look Like?
Whether you use Xero or QuickBooks, the principle remains the same:
Amazon settlement report → sales and adjustments → Amazon fees → settlement balance → bank receipt
Some businesses use an Amazon clearing account to track the settlement before the money reaches the bank.
The clearing account should ultimately reconcile to zero, or to a clearly explained outstanding balance, once all relevant settlements have been processed.
This approach makes amazon fba bookkeeping uk easier to review because Amazon activity can be compared with bank transactions without treating every payout as revenue.
When Should Amazon Settlements Be Reconciled?
Ideally, settlements should be reconciled regularly rather than left until year-end. Monthly reconciliation is practical for many growing sellers, while higher-volume businesses may benefit from more frequent processing.
Regular amazon seller accounting uk can help identify unexpected fee increases, refund trends and reconciliation problems before they affect management accounts or year-end reporting. For VAT-registered businesses, regular processing is also useful when preparing VAT returns.
How Top Bookkeeping Services Can Help
As sales volume, product ranges, advertising activity and international transactions grow, Amazon FBA bookkeeping can become increasingly complicated.
Top Bookkeeping Services can help sellers organise settlement reports, categorise fees, reconcile Amazon payouts and maintain clear accounting records.
The objective is not simply to make the bank balance agree. A properly maintained system should explain the journey from gross Amazon sales to refunds, fees, VAT considerations, and the final amount received.
Professional amazon fba bookkeeping uk can also provide a consistent reconciliation process for sellers handling multiple settlements or marketplaces.
Conclusion
Effective amazon fba bookkeeping uk requires you to look beyond the amount Amazon deposits into your bank account. The settlement report should be broken down into sales, refunds, fees, fulfilment, advertising and other adjustments before the payment is reconciled.
For amazon vat uk sellers, accurate VAT treatment and supporting documentation are equally important. A structured ecommerce bookkeeping uk process makes errors easier to identify and keeps Amazon activity traceable. With the right process in Xero or QuickBooks, Amazon settlements can be transformed from complicated reports into organised accounting records.
Frequently Asked Questions
What is the biggest bookkeeping mistake Amazon FBA sellers make?
The most common mistake is recording the Amazon bank payout as sales. The payout is normally the amount remaining after Amazon has deducted fees, refunds, and other amounts.
Do Amazon FBA sellers need to record Amazon fees separately?
Yes. Amazon fees are business costs and should generally be recorded separately from sales so the accounts accurately show revenue and expenses.
How should Amazon VAT be handled in UK bookkeeping?
The VAT treatment depends on the specific transaction and the seller’s circumstances. Sellers should review Amazon’s tax documentation and ensure their accounting treatment agrees with the applicable VAT rules.
Should Amazon settlements be reconciled every month?
Monthly reconciliation is practical for many businesses. Higher-volume sellers may need to reconcile more frequently to identify errors and unexpected charges promptly.
Can Xero or QuickBooks automatically reconcile Amazon settlements?
Accounting software can automate parts of the process, but automation does not remove the need to review settlement data. Sales, fees, refunds, VAT, and the final bank payment should all be accounted for correctly.