Amazon Seller Bookkeeping Checklist (Free Template)
Amazon bookkeeping is not difficult because of volume, it’s difficult because of structure. Settlements bundle sales, fees, refunds, VAT, reserves, and timing differences into one payout, which means your bank feed never tells the full story.
This Amazon Seller Bookkeeping Checklist shows you exactly what to download, what to reconcile, what to review monthly, and how to keep VAT, inventory, and clearing accounts aligned in Xero or QuickBooks. By the end, you’ll understand how to turn Amazon’s settlement logic into a controlled, MTD-ready bookkeeping system that stays explainable as your business grows.
Contents
- Introduction: Why Amazon Sellers Need a Bookkeeping Checklist
- How to Use This Amazon Bookkeeping Checklist
- Monthly Amazon Bookkeeping Tasks (Core Checklist)
- Reconciling Amazon Payouts Correctly
- Tracking Inventory, COGS, and Amazon Fees
- Key VAT Checks Amazon Sellers Should Perform
- Multi-Channel Bookkeeping (Stripe & PayPal Checks)
- Tools That Simplify Amazon Bookkeeping
- Month-End & Quarter-End Review Checklist
- Download the Amazon Seller Bookkeeping Checklist (Free)
Important: This guide is for general information only and is not accounting, tax, or legal advice. VAT treatment and Amazon arrangements depend on specific facts, including entity type, VAT status, fulfilment locations, contractual terms, and reporting policies. This content is written for educational purposes and does not constitute professional advice or an offer of services. If you need advice for your business, you should speak to a qualified accountant or tax adviser.
1. Introduction: Why Amazon Sellers Need a Bookkeeping Checklist
Amazon bookkeeping feels simple at first – until it isn’t.
The problem is not transaction volume. The problem is structure.
Amazon does not pay you per order. It pays in settlements. Fees are deducted before you see the cash. Refunds are netted off. Reserves are held back. VAT appears in different reports. Inventory moves without money changing hands.
That means your bank feed never tells the full story.
Instead of simple customer invoices and clean deposits, you’re dealing with:
- Biweekly settlement cycles
- Fees and refunds deducted before payout
- Withheld balances and reserves
- VAT invoices that matter once you’re registered
- Multiple “truth sources” inside Seller Central (settlements, transaction detail, VAT reports, fee invoices, inventory reports)
Without a structure, small inconsistencies compound.
A bookkeeping checklist turns this into a controlled monthly routine.
The goal isn’t paperwork.
The goal is confidence:
- Every number in your accounts can be traced back to Amazon evidence.
- VAT figures are supportable.
- Month-end doesn’t become a reconstruction exercise.
This checklist sits within a wider Amazon accounting framework. For the complete end-to-end structure covering VAT, inventory, settlements, and reporting, see Amazon Seller Accounting – Complete Guide.
What “good bookkeeping” means for Amazon sellers
For a UK Amazon seller, “good bookkeeping” means your records are complete, consistent, and explainable.
In practice, that usually requires a minimum evidence pack from Amazon Seller Central that you download and retain (rather than relying on being able to re-access it later). For most sellers this includes:
- Settlement reports (the payout statements showing the build-up from sales through to net payout)
- Transaction-level detail (orders, refunds, adjustments that explain settlement totals)
- VAT transaction reports (where relevant, to support VAT rates and tax point logic)
- Fee invoices (to evidence Amazon charges and any VAT charged on those services)
- Inventory and stock movement records (so COGS and closing stock are supportable at year-end)
This matters because HMRC expects you to keep business records for VAT purposes for at least six years, and those records need to be sufficient to support the figures on your VAT returns and tax filings.
On the bookkeeping workflow side, “good” is less about the brand of software and more about whether the workflow creates an audit trail that holds up under review.
A clean Amazon workflow in Xero or QuickBooks typically includes:
- an Amazon clearing account (or settlement control account) so you can post gross activity and then match payouts cleanly
- a chart of accounts that separates material categories such as sales, refunds, referral fees, FBA fees, storage fees, advertising, reimbursements, and withheld amounts
- reconciliations that show your clearing account either returns to £0 at month-end, or equals a clearly explainable “in transit” settlement balance (for example, a settlement that lands in the bank just after month-end)
That “clearing account behaves logically” outcome is one of the strongest practical signals that your Amazon numbers are being captured completely, rather than just “whatever hit the bank”.
Why Amazon bookkeeping fails without a checklist
Most Amazon bookkeeping failures are process failures, not intelligence failures.
Without a checklist, sellers usually fall into one of these patterns:
- Posting Amazon payouts as sales: this makes your turnover, fees, refunds, and VAT position hard to evidence because the accounts only show a net figure, not the underlying components.
- Missing settlement periods: especially around month-end, when a settlement covers sales and refunds across two calendar months.
- Refunds and reimbursements being mishandled: refunds reduce revenue, reimbursements often relate to inventory losses or adjustments and need consistent classification so margins remain meaningful.
- Fees being lumped into one bucket: it becomes impossible to see whether margin issues are driven by referral fees, fulfilment fees, storage creep, or advertising.
- False confidence from bank reconciliation: a bank balance can reconcile while revenue, VAT coding, or fee VAT recovery is still wrong, because the bank only proves cash movement, not correct classification.
A checklist is a control system. It forces the small disciplines that prevent quarter-end panic:
- “Did we download every settlement?”
- “Did we post each settlement to the clearing account?”
- “Do payouts reconcile exactly to settlements?”
- “Do we have the fee invoices and VAT reports saved with the period evidence?”
How HMRC and Amazon expose weak bookkeeping
The risk for sellers is not that HMRC expects a perfect system. The risk is that your records do not allow you to explain how you arrived at your VAT and income figures.
1) Record retention and sufficiency
HMRC generally require you to keep VAT records for at least six years and to retain records in a way that supports the VAT return figures (see HMRC guidance on VAT record keeping). If you cannot produce adequate supporting records, HMRC can challenge the figures and corrections can become expensive and time-consuming.
2) MTD digital records and digital links
Under HMRC’s Record keeping for VAT (VAT Notice 700/21) guidance, once data has entered your functional compatible software, further transfers that form part of your electronic account are required to be made through digital links rather than manual re-keying or copy and paste. The notice is explicit that “cut and paste” or “copy and paste” does not constitute a digital link.
This is why many sellers feel “MTD compliant” because they submit via software, but still create avoidable exposure earlier in the process if they are copying figures between spreadsheets and systems.
Separately, Amazon also increases pressure on accuracy because Seller Central is often the source of documents used in account verification and compliance reviews. If your VAT number, business details, and the supporting documents you can produce are inconsistent, it can slow verification and create operational disruption. A checklist reduces that risk by making document capture and storage part of the monthly routine, not a last-minute scramble.
Where errors do happen, HMRC penalty outcomes depend on behaviour and disclosure position (for example, careless vs deliberate), which is why professional workflows emphasise evidence, reasonable care, and clear records rather than relying on assumptions.
Who this checklist is designed for (and who it isn’t)
This checklist is designed for UK-based Amazon sellers (FBA or FBM) who want a repeatable monthly process that keeps records tidy, VAT-ready, and explainable.
It is a good fit if you:
- use Xero or QuickBooks Online
- have regular Amazon settlements and want a controlled month-end close
- are VAT-registered already, or expect to be, and want to keep an MTD-ready audit trail
It is not a substitute for specialist advice where the VAT position is structurally more complex, for example:
- non-UK sellers storing stock in the UK
- multi-country inventory storage and cross-border VAT registrations
- OSS/IOSS and multi-jurisdiction reporting
In those cases, the checklist still helps as an operational control, but you usually need the VAT position reviewed by someone who deals with these scenarios routinely.
2. How to Use This Amazon Bookkeeping Checklist
This checklist is designed to be used as an operational control framework, not as a one-off exercise. Amazon bookkeeping in the UK involves multiple systems, settlement timing differences, and VAT reporting obligations that do not align neatly with calendar months or bank deposits. Without a clear cadence and defined responsibilities, errors tend to accumulate and only surface when VAT returns or year-end accounts are prepared.
Used correctly, the checklist helps UK Amazon sellers maintain accurate digital records, reduce VAT return adjustments, and demonstrate reasonable care if records are reviewed by HMRC.
Monthly vs Quarterly vs Annual Tasks
UK VAT returns are filed quarterly, but VAT accuracy depends on work performed throughout the quarter. In practice, experienced Amazon accountants treat bookkeeping as a monthly discipline, with quarterly and annual work building on that foundation.
This approach aligns with HMRC’s Making Tax Digital guidance, which expects VAT records to be kept digitally and supported by an auditable trail from source data through to the VAT return.
Monthly tasks that support VAT accuracy
The following tasks are best performed monthly to keep records reliable and to reduce the risk of VAT return corrections later.
Amazon settlement reconciliation
Amazon pays sellers on settlement cycles that frequently span calendar month-ends. A single settlement can include transactions from two different months, and the payout date does not determine when sales occurred for accounting or VAT purposes.
As a matter of good practice, sellers will generally:
- Download all Amazon settlement reports covering the period
- Record settlements based on transaction dates, not payout dates
- Reconcile each settlement to the corresponding bank deposit
- Ensure any pending or reserved balances shown at month-end relate only to the most recent settlement period
Monthly reconciliation makes it easier to identify missing settlements, duplicate postings, or timing errors while the data is still recent and traceable.
Amazon fees and VAT verification
Amazon fees are subject to VAT depending on the invoicing entity and the VAT invoice issued for the period. The correct treatment cannot be assumed based on past periods.
Each month:
- Download Amazon VAT invoices from Seller Central
- Match invoiced fees to settlement reports
- Confirm VAT has been applied and coded consistently in the accounting system
This monthly check helps ensure any VAT reclaimed on fees is supported by valid documentation and is consistent with the business’s VAT recovery position, reducing the risk of adjustments if HMRC reviews the return.
Bank reconciliation
Monthly bank reconciliation confirms that all Amazon payouts, refunds, and other movements have been captured correctly in the accounts. While bank reconciliation alone does not prove VAT accuracy, it forms part of the digital audit trail expected under MTD.
Inventory monitoring (FBA sellers)
For Fulfilment by Amazon sellers, monthly review of inventory movements helps identify discrepancies, lost or damaged stock, and potential reimbursement claims. Claim eligibility and processes can change, so regular review reduces the risk of missed recoveries.
Quarterly tasks linked to VAT returns
Quarterly work is where VAT obligations crystallise, but it relies on accurate monthly data.
Typical quarterly checks include:
- Reviewing VAT Boxes 1, 4, and 6 for internal consistency
- Separating marketplace-collected VAT from seller-collected VAT where applicable
- Confirming that total net sales reconcile back to monthly settlement data
- Reviewing rolling 12-month taxable turnover against the UK VAT registration threshold
Where monthly records are complete and consistent, quarterly VAT returns will typically require review and confirmation rather than significant corrective work.
Annual tasks that rely on monthly routines
Year-end accounts preparation depends heavily on the quality of monthly bookkeeping. Annual-only tasks typically include:
- Inventory valuation reviews and write-downs where appropriate
- Cost of goods sold reconciliation across the year
- Review of reimbursements, accruals, and outstanding balances
- Retention and organisation of supporting records
Without reliable monthly reconciliations, annual adjustments become estimates rather than evidence-based figures, increasing risk during enquiries.
What Should Be Automated vs Reviewed Manually
Automation tools play an important role in Amazon bookkeeping, but they do not replace professional judgment or oversight.
Processes well suited to automation
The following tasks are commonly automated using tools such as A2X or Link My Books, provided they are configured appropriately and reviewed regularly:
- Importing Amazon settlement data
- Splitting settlements across accounting periods
- Categorising standard Amazon fees
- Applying consistent VAT rules once set up
- Posting cost of goods sold based on predefined SKU costs
- Matching settlements to bank deposits
Automation improves consistency and reduces manual error, especially as transaction volumes grow.
Areas that still require human review
Some checks cannot be reliably automated and should be reviewed manually:
- Clearing account balances at month-end
- Unusual or high-value reimbursements
- Significant changes in gross margin or refund rates
- Settlement discrepancies or unmatched bank deposits
- Changes in Amazon fee structures or VAT treatment
- Transactions affected by deferred payments or credit terms
These reviews demonstrate that records have been actively monitored, which is important if HMRC queries the accuracy of submitted figures.
Evidence of oversight under MTD
HMRC does not typically require a specific review format, but it expects businesses to be able to explain how figures were derived and checked.
Good practice includes:
- Monthly reconciliation schedules
- Notes explaining unusual transactions
- A clear audit trail within accounting software showing posting dates and users
- Retention of source reports and invoices
DIY Sellers vs Accountant-Supported Sellers
Not all Amazon sellers need the same level of professional involvement, but there are practical limits to DIY bookkeeping.
Tasks many DIY sellers can manage
- Downloading and organising settlement reports
- Matching settlements to bank deposits
- Reviewing automated postings for obvious errors
- Uploading expense receipts
- Maintaining basic reconciliation logs
These tasks are largely administrative and rely on consistency rather than technical judgment.
Common DIY failure points
- Record Amazon payouts as revenue instead of gross sales
- Miss settlement periods that cross month-end
- Apply inconsistent VAT treatment to fees
- Delay reconciliation until quarter-end
- Overlook inventory discrepancies or reimbursements
These issues often only become visible when an accountant reviews the records, increasing clean-up costs.
Accountant-supported model
- The seller gathers reports, flags unusual items, and maintains basic records
- The accountant reviews reconciliations, confirms VAT treatment, and prepares VAT returns and accounts
This division of responsibility keeps costs controlled while reducing compliance risk.
Even where bookkeeping is outsourced, sellers remain responsible for approving filings and understanding their numbers.
Tools You Need Before You Start (Xero, Reports, Integrations)
Accurate bookkeeping depends on having the right systems in place before transactions are posted.
Accounting software and MTD readiness
UK Amazon sellers will generally need accounting software that maintains digital records, supports MTD VAT submissions, and preserves an audit trail from source data to VAT return. You can verify whether a product is MTD-compatible using HMRC’s Find software that’s compatible with Making Tax Digital for VAT tool .
Choosing appropriate software early prevents structural errors that are expensive to unwind later. Choosing the right system determines whether your Amazon bookkeeping remains controllable as volumes grow. A detailed comparison of platforms, integrations, and VAT configuration considerations is covered in Best Accounting Software for Amazon Sellers (UK).
Amazon reports to collect before posting
Before posting any entries, sellers should download:
- Amazon settlement reports for the period
- Amazon VAT invoices from the Tax Document Library
- Inventory and reimbursement reports where applicable
- Advertising and other ancillary reports if used
Posting without complete source data may increase the risk of mis-statements.
Integrations and clearing accounts
Integrations such as A2X or Link My Books help enforce correct workflows by:
- Posting settlements to a clearing account
- Separating sales, fees, refunds, and VAT correctly
- Supporting period-accurate reporting
Without a clearing account structure, sellers may fall into the trap of treating bank deposits as revenue, which can distort margins and VAT figures.
Record storage and audit trail
Records should be stored digitally with consistent naming conventions and retained in line with HMRC record-keeping expectations. Sellers should be able to trace each reported figure back to supporting documents if requested.
Professional Use and Reliance
This checklist provides general guidance for UK Amazon sellers. It does not constitute tax advice, and VAT outcomes depend on the specific facts of each business, including where goods are located, who is treated as the supplier for VAT purposes, and what documentation supports each transaction.
If you are VAT-registered, approaching the VAT threshold, or operating across multiple marketplaces or jurisdictions, professional advice should be taken before filing VAT returns or relying on a particular treatment.
3. Monthly Amazon Bookkeeping Tasks (Core Checklist)
This section sets out the core monthly controls that underpin reliable Amazon bookkeeping for UK sellers. These tasks are designed to be performed every month, in a consistent sequence, using the same underlying evidence. When applied consistently, they help create accounting records that are structured, explainable, and easier to evidence if reviewed by HMRC or an external accountant.
The checklist assumes you sell through Amazon Seller Central, receive regular Amazon payouts, and maintain your accounting records in software such as Xero. If you use automation tools, the same control steps still apply. The difference is whether the underlying posting is performed manually or system-assisted.
This checklist should be treated as a control framework rather than a training guide. Each step exists because it addresses a common risk area in UK Amazon bookkeeping and VAT reporting.
☐ Download all Amazon settlement reports for the month
As a matter of good practice, each monthly close will typically begin by collecting the relevant source data from Amazon. Amazon settlement statements form the primary transactional evidence for sales, fees, refunds, VAT treatment, and net payouts. Bank statements alone do not provide this level of detail and cannot explain how a payout figure was derived.
For each month, it is generally advisable to retain, at a minimum:
- Settlement statements for every settlement period that overlaps the month (for example, the Flat File V2 format)
- Amazon VAT invoices from the Tax Document Library covering the same periods
- FBA Inventory Ledger and Reimbursement reports if you use Fulfilment by Amazon
Amazon settlement periods rarely align with calendar months or bank payout dates. A payout received in January may relate to sales made partly in December and partly in January. If transactions are analysed purely by bank date, this can lead to misstated revenue, incorrect VAT reporting, and distorted monthly performance figures.
Amazon does not guarantee indefinite, easily accessible access to historical settlement data. UK VAT record-keeping rules require VAT records and supporting evidence to be retained for at least six years, and different retention periods can apply for other taxes. In practice, most UK sellers retain their full Amazon evidence pack for at least six years to ensure consistency across VAT, corporation tax, and accounts preparation.
A simple but effective control is to download and store all settlement-related reports monthly, before they are archived, using a clear and consistent naming convention, for example:
Amazon_Settlement_2026-01-01_2026-01-14_UK.csv
This step underpins every control that follows.
☐ Post each settlement to an Amazon clearing account
In most Amazon bookkeeping systems, each settlement is posted via a dedicated Amazon clearing account. A settlement itself is not a single transaction. It is a structured bundle of multiple components, including sales, refunds, fees, VAT entries, adjustments, and transfers.
Posting Amazon settlements directly to revenue accounts or directly to the bank feed commonly creates downstream problems with VAT analysis, margin reporting, and reconciliation. Using a clearing account allows each component to be recorded separately and reviewed.
A properly posted settlement typically separates:
- Gross sales
- Refunds, recorded as negative revenue or separate refund lines
- Amazon fees recorded as expenses
- VAT on sales and VAT on fees, where applicable
Whether this breakdown is created manually or through tools such as A2X or Link My Books, the underlying control principle is the same. The clearing account acts as the checkpoint that allows you to demonstrate that all settlement components have been captured and nothing has been omitted or duplicated.
☐ Reconcile each Amazon payout to your bank feed
Once settlements have been posted, each Amazon payout should normally be reconciled to the clearing account rather than posted directly to revenue.
In practice, this involves:
- Waiting for the Amazon payout to appear in your bank feed
- Matching that payout to the corresponding clearing account balance
- Confirming the amounts agree, or documenting any explained differences such as currency conversion or bank charges
Amazon payouts can be delayed, split, combined, or adjusted due to reserves, chargebacks, or foreign exchange effects. Reconciling payouts against the clearing account ensures that these differences are identified and explained, rather than absorbed into revenue or expense figures without visibility.
☐ Confirm the clearing account returns to zero
After all settlements for the month have been posted and all related payouts reconciled, the Amazon clearing account should normally return to a nil balance.
A nil or near-nil balance indicates that:
- All settlements for the period have been recorded
- All corresponding payouts have been reconciled
- No amounts are left unaccounted for within the clearing process
A temporary non-zero balance can be acceptable where it clearly represents a pending settlement or a documented reserve hold. However, balances that carry forward from month to month without explanation commonly indicate control failures, such as missing settlements, duplicate postings, misclassified reimbursements, or foreign currency differences.
Clearing and suspense balances are frequently examined during accounts reviews and compliance checks because they can signal unresolved transactions. Any non-zero balance will generally require investigation and documentation before the month is closed.
☐ Review Amazon fees, refunds, and reimbursements
Before finalising the month, review the detailed composition of the figures posted.
As part of this reasonableness check, confirm that:
- Amazon fee totals in the profit and loss account agree to settlement data and invoices
- Refunds are identifiable as refunds and not silently netted into sales without visibility
- Reimbursements are classified according to their nature and not treated as customer revenue
Reimbursements for lost or damaged inventory are often presented as a reduction of the related inventory cost or cost of goods sold, where they relate directly to stock losses. Fee credits or overcharge reimbursements may be presented either as a reduction of the related expense or as other income, provided the treatment is applied consistently and supported by evidence.
The objective of this step is not to achieve absolute precision on every line, but to identify anomalies, omissions, or classifications that do not make commercial sense and may distort performance analysis or VAT reporting.
☐ Save source reports for your audit trail
The final step in the monthly process is evidence retention.
For each month, retain:
- Amazon settlement reports
- Amazon VAT invoices
- Bank statements showing Amazon payouts
- Your reconciliation schedules or summaries
Accounting software records what has been posted. Source reports explain how those figures were derived. Under Making Tax Digital for VAT, businesses are required to keep digital records and maintain digital links within the VAT reporting process. In the event of an HMRC check, businesses are generally expected to be able to trace figures from their VAT return and accounts back to the underlying Amazon data that supports them.
A simple, consistent habit makes this manageable: download and store all Amazon reports for the prior month on the same day each month, using the same folder structure and naming conventions. This significantly reduces the risk of missing evidence and speeds up any future review.
When this checklist is completed consistently each month, Amazon bookkeeping is more likely to remain structured, explainable, and repeatable. The remainder of this article builds on these controls, but this monthly checklist forms the foundation on which everything else depends.
4. Reconciling Amazon Payouts Correctly
Reconciling Amazon payouts correctly is one of the most important control processes in UK Amazon bookkeeping. It exists to prevent a specific and expensive failure pattern: treating Amazon cash deposits as if they were sales revenue.
From an HMRC enquiry perspective, payout reconciliation is where many weaknesses become visible. If settlement data, VAT reporting, bank receipts, and the general ledger do not align, HMRC may probe further. A well-structured reconciliation process demonstrates that figures are complete, consistently derived, and supported by source evidence.
This section explains how reconciliation should work in practice, what HMRC and professional accountants expect to see, and how to respond when the numbers do not agree. If you need a detailed walkthrough of how to post settlements, clear payouts, and diagnose mismatches, see Amazon Payout Reconciliation – Step-by-Step.
Why Amazon payouts should not be treated as revenue
An Amazon payout is not revenue. It is a net cash movement that combines multiple underlying transactions, including sales, refunds, platform fees, VAT on fees, and timing adjustments.
For UK accounting and VAT purposes, revenue is recognised when goods are supplied to the customer, not when cash is received. This principle sits at the core of UK GAAP accrual accounting and applies regardless of whether you use automation or manual bookkeeping.
When Amazon pays funds into your bank account, that payment represents the settlement of amounts Amazon already owes you, after deducting fees and other adjustments. Posting that payout directly to revenue collapses several distinct transactions into a single number and removes the audit trail.
From a VAT perspective, this creates immediate risk. VAT returns require gross sales figures, net of VAT but before Amazon fees. If payouts are treated as revenue, Box 6 will usually be understated, because fees and refunds have already been netted off. Over time, this can cause VAT turnover to diverge from statutory accounts, which is a common trigger for HMRC queries.
HMRC increasingly makes use of third-party marketplace data, including information supplied by platforms such as Amazon, and it is increasingly common for declared VAT turnover to be cross-checked against that data. Where reported sales figures appear consistently lower than expected, HMRC will normally ask how revenue has been calculated.
There is also a commercial consequence. Treating payouts as revenue hides the true cost of Amazon fees. Margins may appear artificially high or low depending on how costs are classified, which can distort pricing decisions, stock planning, and performance analysis.
For these reasons, most professional UK accountants do not treat Amazon payouts as revenue. They treat them as settlements of a clearing account balance that has already captured gross sales and associated costs.
What a healthy Amazon clearing account looks like
A clearing account is a control account used to temporarily hold Amazon transactions until cash is received. It allows you to separate what you earned from what Amazon paid, while keeping a complete audit trail.
In a healthy setup, Amazon settlements are posted to a dedicated clearing account. Each settlement records gross sales, refunds, Amazon fees, and any other adjustments. The net result of that settlement is then cleared when the corresponding payout arrives in your bank account.
Over the course of a normal month, the clearing account will fluctuate as settlements are posted and payouts are received. However, at month-end or quarter-end, the balance should normally return to zero, or to a small, clearly explained amount.
A non-zero balance can be acceptable in limited circumstances. For example, sales made at the very end of the month may not yet be eligible for payout due to Amazon’s delivery-based timing rules. In that case, the clearing balance represents amounts owed by Amazon and should clear in the next settlement cycle.
What is generally not acceptable is a clearing account that carries unexplained balances from one month to the next. Persistent balances usually indicate missing settlements, duplicated postings, misclassified fees, or reserve amounts that have not been accounted for properly.
From a professional review perspective, the clearing account is one of the first areas examined. A clean clearing account, supported by settlement reports and bank reconciliation, demonstrates that Amazon income is being handled in a controlled and methodical way.
Automation tools such as A2X or Link My Books can help enforce this discipline, but the underlying principle is the same even if everything is posted manually. The clearing account exists to prove that nothing has been omitted or double-counted.
How to spot missing or duplicated settlements
Amazon settlements follow a predictable structure. Each settlement covers a defined date range and is identified by a unique settlement reference. Reconciling correctly means confirming that every settlement issued by Amazon has been posted once, and only once.
Missing settlements often show up as a growing clearing account balance that never quite clears. If sales continue to be recorded but a payout does not arrive or is not posted, the balance accumulates. Over time, this becomes material and difficult to explain.
Duplicated settlements create the opposite problem. If the same settlement is posted twice, revenue and fees are overstated, and the clearing account may even move into a negative position, which would not normally be expected in typical circumstances.
To prevent both issues, each settlement should be logged and tracked. Settlement date ranges should be reviewed to ensure there are no gaps, and bank deposits should be matched back to specific settlements rather than posted in bulk.
Particular care is needed where settlements span month-end. A single Amazon settlement will generally not be split and posted twice simply because it covers two calendar months. Instead, the settlement should be posted once, with any necessary month-end accruals handled separately.
Professional accountants also cross-check settlement totals against Amazon reports such as transaction summaries and deferred transaction reports. While minor timing differences are normal, unexplained gaps are not.
What to do when the numbers don’t match
Even with good processes, there will be times when figures do not align immediately. When that happens, the key is to diagnose the difference methodically rather than forcing the reconciliation.
The first step is to quantify the difference and identify which settlement or period it relates to. This usually involves comparing the Amazon settlement report, the clearing account entries, and the bank statement side by side.
Common causes include timing differences on end-of-month sales, Amazon reserves, foreign currency conversion differences, or fees that were charged but not recorded separately. In many cases, the issue is not an error but a missing explanation.
Where the cause is clear and immaterial, a simple correcting entry may be sufficient. Where the difference affects VAT reporting, relates to a prior period, or exceeds material thresholds, it should be escalated to a qualified accountant before VAT returns or accounts are finalised.
If a difference cannot be resolved immediately, it should be documented. From an HMRC perspective, a documented explanation supported by Amazon reports and bank evidence is far preferable to an unexplained adjustment made simply to “make the numbers work”.
Repeated mismatches of the same type are a warning sign. They usually indicate a structural problem in how Amazon data is being captured, and they tend to surface during VAT inspections or year-end reviews. Addressing them early reduces both professional fees and compliance risk.
Reconciling Amazon payouts correctly is not about perfection. It is about consistency, evidence, and control. When settlements are posted through a clearing account, matched to bank receipts, and supported by retained reports, your Amazon figures remain explainable and defensible. That is exactly what HMRC and professional reviewers expect to see.
5. Tracking Inventory, COGS, and Amazon Fees
Accurate Amazon bookkeeping is not just about compliance. It is what determines whether your reported margins reflect reality or quietly mislead you.
Inventory movement, cost of goods sold (COGS), and Amazon fees interact in ways that are easy to get wrong if you rely only on payouts or high-level reports. This section explains what generally needs to be tracked each month, when costs are typically recognised, and why mis-posting fees or reimbursements can distort profitability and VAT analysis.
For a full breakdown of inventory valuation methods, shipment-based COGS recognition, and year-end stock treatment, see Inventory & Cost of Goods Accounting for Amazon.
What inventory movements should be tracked monthly
Amazon sellers do not control inventory in a single location, but under UK accounting principles inventory is generally tracked as a business asset until it is sold, written off, or otherwise disposed of.
Each month, records will generally need to reflect actual inventory movements rather than estimates based on payouts or on-hand snapshots.
At a minimum, the following movements need to be captured and supported by source data:
- Inbound inventory received at Amazon
Inventory should be recognised when Amazon confirms receipt at a fulfilment centre, not when you pay the supplier and not when you ship goods to Amazon. Goods in transit remain your asset until receipt is confirmed. - Customer shipments (sales)
Inventory leaves your balance sheet when Amazon ships the item to the customer. This shipment date is the point at which COGS is recognised. - Customer returns
Returned items that are restocked reverse COGS and return to inventory. Items that are not restocked require a write-off, potentially followed by a reimbursement. - Inventory adjustments
Lost, damaged, destroyed, or found stock will generally need to be recorded when identified, with later adjustments if Amazon reimburses you. - Removal orders
Inventory transferred out of FBA remains your asset but changes location, which should be reflected in your records.
Amazon’s Inventory Ledger Report is the primary evidence source for these movements. Relying solely on the “on-hand” figure in Seller Central is not sufficient for accounting or audit purposes.
From an HMRC or professional review perspective, the expectation is not perfection but consistency. Inventory balances should reconcile month to month, with any differences explained by identifiable movements supported by Amazon reports.
When COGS should be recognised (not when paid)
Under UK accrual accounting, COGS is recognised when the sale occurs, not when inventory is purchased and not when Amazon pays you.
For Amazon sellers, this means:
- Revenue is recognised when the customer order is fulfilled, typically the shipment date shown in Amazon’s transaction data.
- COGS is recognised in the same period, matching the cost of the inventory sold to the related revenue.
Recognising COGS on payout dates is a common shortcut, but it creates distorted margins, particularly when settlement timing shifts between months or when returns and reimbursements occur later.
Correct timing matters because:
- Gross margin trends become comparable month to month.
- Closing inventory values remain reliable.
- Year-end accounts do not require large corrective adjustments.
- VAT turnover and financial statements remain internally consistent.
In practice, most sellers post COGS as a monthly consolidated journal, based on shipment data for the period rather than individual transactions. The key requirement is that shipment dates, not payment dates, drive the calculation.
How Amazon fees distort margins if mis-posted
Amazon fees often represent 20–30% of seller revenue. Where these costs are posted in the accounts has a major impact on how profitability appears.
The most common error is treating all Amazon fees as COGS.
In well-structured accounts:
- COGS includes costs directly attributable to fulfilling the product, such as product cost, inbound freight, and per-unit FBA fulfilment fees.
- Operating expenses include referral fees, advertising, storage fees, subscriptions, and other platform charges.
When fees are pushed into COGS:
- Gross margin appears artificially low.
- Margin volatility increases during seasonal storage spikes.
- Pricing and product decisions are made on misleading data.
- VAT analysis becomes harder, particularly where input VAT on fees is recoverable.
Professional reviewers often identify fee misclassification by comparing gross margin trends to expected ranges and by reconciling settlement data back to the profit and loss account. Clean fee separation makes those checks straightforward and reduces the need for later rework.
Automation tools can help enforce consistent mapping, but the underlying accounting logic is the same whether entries are manual or system-generated.
Why reimbursements are generally not treated as sales
Amazon reimbursements are generally not revenue. They are recoveries of costs or corrections of prior charges.
Common reimbursement types include:
- Lost or damaged inventory
- Fee overcharges
- Incorrect returns processing fees
- VAT charged in error on fees
Posting reimbursements to sales inflates turnover, distorts performance metrics, and can interfere with VAT threshold monitoring. In most cases, reimbursements are not taxable supplies and would not be included when assessing VAT registration thresholds.
The correct treatment depends on the nature of the reimbursement:
- Inventory reimbursements typically offset a prior write-off.
- Fee reimbursements reduce the related expense.
- VAT refunds adjust the VAT control account or the original expense.
A useful control is the Amazon clearing account. When reimbursements are posted correctly, settlements, reimbursements, and payouts reconcile cleanly without unexplained balances or inflated revenue figures.
From an HMRC or audit perspective, the focus is whether reimbursements can be traced back to the original loss or charge using settlement reports and inventory records, not whether every reimbursement was claimed perfectly.
Why this matters beyond compliance
Tracking inventory, COGS, and fees properly does more than keep HMRC satisfied.
It allows you to:
- Trust your gross margin.
- Identify true cost drivers.
- Make pricing and inventory decisions based on real data.
- Avoid corrective work at year-end.
- Scale without losing visibility.
If your numbers do not explain your business clearly, they are not doing their job. This section sets the foundation for reliable reporting as order volumes increase and operational complexity grows.
6. Key VAT Checks Amazon Sellers Should Perform
This section is not about learning VAT rules. It is about verifying that your bookkeeping outputs are VAT-safe before a return is filed.
For UK Amazon sellers, most VAT problems do not arise from misunderstanding the law. They arise from weak controls, mis-mapped data, or relying on Amazon payouts instead of settlement detail. The checks below are designed to catch those issues early, using evidence you already have access to.
If any of these checks fail, the solution is usually to fix the bookkeeping process, not to “adjust” the VAT return.
Confirm VAT registration status and thresholds
For HMRC’s detailed view of when registration is required, see VAT Notice 700/1 (Should I be registered for VAT?) . Before reviewing figures, confirm your current VAT position.
It is important to be clear on:
- Whether the business is VAT registered, and if so, the effective date of registration
- Whether you are monitoring taxable turnover on a rolling 12-month basis
- Whether any recent changes in sales volume, pricing, or fulfilment could affect registration obligations
Taxable turnover is based on the value of taxable supplies, not Amazon payouts (see HMRC’s VAT registration threshold guidance ). That includes standard-rated, reduced-rated, and zero-rated sales, across all channels operated by the same legal entity.
If you are near the threshold, it is reasonable to expect that HMRC would look at what information was available at the time and whether turnover was being monitored in a consistent, documented way. Monthly tracking can help demonstrate reasonable care.
For a detailed explanation of how the rolling 12-month VAT threshold operates and how to monitor it correctly, see UK VAT Thresholds Explained. If your turnover is approaching the threshold or you are uncertain about your registration obligations, see VAT Registration for Amazon Sellers – Do You Need It.
Verify Amazon fees VAT treatment (post-August 2024)
Since August 2024, most Amazon.co.uk seller fees have been charged with 20 percent UK VAT in standard UK VAT-registered setups.
As part of a monthly review, it is advisable to check that:
- Amazon fees in your accounts agree to settlement reports
- VAT charged on fees is posted using a standard-rated expense VAT code
- Input VAT on fees is flowing into your VAT control account
A common error is leaving legacy reverse-charge codes in place, which prevents VAT on fees from appearing in Box 4. The result is under-claiming VAT, not over-claiming it.
This is a bookkeeping control issue, not a VAT judgement call. If the VAT is charged by Amazon and supported by valid invoices, it will often be reclaimable where the costs relate to taxable business activities and recovery is not otherwise restricted.
For a full explanation of Amazon fee VAT treatment, deemed supplier rules, input VAT recovery after registration, and how marketplace-facilitated sales affect your VAT return, see FBA VAT for Amazon Sellers – What You Need to Know.
Check facilitator versus seller-collected VAT
Amazon does not always account for VAT in the same way.
As part of a monthly review, it is advisable to sanity-check:
- Which sales Amazon treated as marketplace-facilitated
- Which sales you remained responsible for as the seller
- Whether this aligns with your fulfilment method, customer location, and VAT registration status
Amazon VAT reports are useful here, but they should be reviewed alongside settlement data and your own sales accounts. Do not assume that “Amazon handled the VAT” applies to all transactions.
This check is about classification consistency, not recalculating VAT line by line.
Review Box 1, Box 4, and Box 6 logic
Before filing a VAT return, review the logic behind the numbers, not just the totals.
In practice:
- Output VAT on sales will normally feed into Box 1
- Reclaimable VAT on fees and costs will normally feed into Box 4
- Net taxable sales (excluding VAT) will normally feed into Box 6
If Box 6 looks low compared to Amazon gross sales, or Box 4 looks unusually small given fee volumes, that may indicate a mapping or data-capture issue upstream.
VAT returns should be the result of correct bookkeeping, not a place where errors are fixed manually.
Store VAT reports for your MTD audit trail
Under Making Tax Digital, HMRC expects:
- Digital records
- A clear link between source data and VAT return figures
- Evidence retained for inspection if requested
Each VAT period, retain:
- Amazon settlement reports covering the period
- Amazon VAT invoices for fees
- VAT transaction or tax calculation reports
- Your VAT return and reconciliation workings
Amazon reports can be amended after issue. Keeping dated copies is part of a defensible audit trail, particularly where reimbursements or late adjustments occur.
Why these VAT checks matter
HMRC does not expect perfection. It does expect:
- Consistent processes
- Contemporaneous records
- Figures that can be explained using evidence available at the time
Running these checks monthly makes the VAT quarter routine rather than stressful. More importantly, it ensures that if questions arise later, your numbers can be traced back to Amazon source data without reconstruction.
The next sections build on this foundation, but these VAT checks are the point where bookkeeping discipline becomes compliance protection.
7. Multi-Channel Bookkeeping (Stripe & PayPal Checks)
Many Amazon sellers also take payments through Stripe or PayPal, typically via a Shopify store, subscriptions, or direct invoices. From an HMRC and accounting perspective, these are not separate activities. If they sit within the same UK legal entity, they will generally form part of the same business records, VAT turnover, and profit calculation.
This section explains how to include Stripe and PayPal correctly in your monthly bookkeeping, without duplicating work or distorting your Amazon figures.
Why Stripe and PayPal affect Amazon bookkeeping
For UK tax purposes, HMRC looks at the legal entity, not the platform. If the same sole trader or limited company sells through Amazon Seller Central, Stripe, and PayPal, those sales are generally assessed together.
This matters in three practical ways:
- VAT thresholds are based on total taxable turnover across all channels, not Amazon alone.
- Profitability can be misread if Amazon is analysed in isolation but shared costs sit elsewhere.
- HMRC reviews routinely compare accounting records to bank deposits and third-party data, not just marketplace reports.
A common failure pattern is keeping Amazon “clean” while Stripe or PayPal activity sits in spreadsheets or is reviewed only at year end. That usually results in understated turnover, incomplete digital records under Making Tax Digital, and avoidable clean-up work later.
Net vs gross revenue checks
Stripe and PayPal both pay out net of fees, unlike Amazon, which provides a structured settlement report. If you post only the net bank deposit as revenue, turnover is understated and margins become unreliable.
The underlying accounting principle is generally the same across platforms:
- Gross customer payments are revenue.
- Processing fees are expenses.
- Net payouts clear a temporary balance, they are not sales.
In practice, this means using Stripe payout reports and PayPal activity reports to reconstruct gross sales before fees, refunds, and chargebacks. This mirrors Amazon settlement logic and allows consistent treatment across channels.
For VAT-registered sellers, this helps ensure Box 6 reflects taxable sales rather than bank receipts. For non-registered sellers, it ensures VAT threshold monitoring is based on the correct figures.
Fee VAT treatment differences
Payment processor fees do not all carry VAT in the same way, and this is an area where sellers frequently lose money or misstate returns.
At a high level:
- Amazon fees are charged with UK VAT and supported by VAT invoices. Input VAT is normally recoverable.
- PayPal fees are VAT-exempt financial services. No VAT is charged and none can be reclaimed.
- Stripe fees are often subject to the reverse charge where Stripe is established outside the UK and the seller is VAT-registered. In those cases, VAT is self-accounted for and, if fully recoverable, may net to nil.
The practical control is simple. As part of a monthly review, fee invoices or statements would typically be downloaded and attached to the accounting entry, with the correct VAT code applied in software such as Xero. This keeps Box 4 accurate and avoids missed recovery or invalid claims.
For a detailed explanation of Stripe reverse-charge treatment and VAT reporting implications, see How Stripe Fees Are Treated in Accounting.
Clearing accounts vs bank-feed posting
Amazon sellers are usually familiar with clearing accounts for settlements. The same logic applies to Stripe and PayPal.
A clearing account acts as a holding account between:
- When the sale occurs
- When fees are deducted
- When cash reaches the bank
Posting Stripe or PayPal bank feeds directly to revenue bypasses this logic and causes several issues:
- Revenue recorded at net instead of gross
- Fees lost or double-counted
- Month-end timing mismatches
- Clearing balances that cannot be explained to an accountant or HMRC
It is generally considered best practice to maintain separate clearing accounts for Amazon, Stripe, and PayPal. Each would normally reconcile to zero, or to a clearly identifiable held balance, once payouts are complete.
This creates a consistent digital audit trail from source reports, through the ledger, to VAT returns and statutory accounts.
Why this matters
Multi-channel bookkeeping is not about adding complexity. It is about avoiding partial records. When Stripe and PayPal are reviewed alongside Amazon each month, VAT thresholds are monitored correctly, margins reflect reality, and year-end adjustments are kept to a minimum.
If your books make sense to you without explanation, they will usually make sense to HMRC and to your accountant as well.
8. Tools That Simplify Amazon Bookkeeping
As Amazon sales volumes grow, bookkeeping complexity increases quickly. Settlement reports bundle sales, refunds, fees, VAT, reimbursements, and timing differences into net payouts that do not map cleanly into traditional accounting records. What works at low volume often becomes fragile as transaction counts rise, VAT obligations expand, and additional sales channels are added.
This section explains when spreadsheets stop being reliable, how specialist tools fit into an Amazon bookkeeping workflow, and how UK sellers typically choose between platforms like Xero and QuickBooks. It is intended to help sellers understand where systems reduce risk, not to prescribe a single setup for every business.
When spreadsheets stop working
Spreadsheets are often the starting point for new Amazon sellers. They are flexible, inexpensive, and familiar. At low transaction volumes, they can be sufficient for tracking income, basic costs, and cash flow.
In practice, spreadsheet-only bookkeeping can become unreliable once sellers are dealing with:
- multiple Amazon settlements per month,
- frequent refunds, reimbursements, or chargebacks,
- VAT monitoring by rate and by marketplace-facilitator treatment,
- additional platforms such as Stripe, PayPal, Shopify, or eBay,
- longer month-end closes driven by manual reconciliation.
From an HMRC perspective, spreadsheets are not inherently non-compliant. However, spreadsheet-heavy processes can weaken the evidence base if they rely on manual adjustments, overwritten formulas, or copy-and-paste steps and lack a clear digital audit trail from source data to the accounting records. This can matter under Making Tax Digital, where HMRC’s focus is generally on traceability and consistency rather than on the tool itself.
Common warning signs that spreadsheets are no longer coping include clearing accounts that never reconcile cleanly, VAT returns that require adjustments every quarter, and financial figures that only make sense after significant accountant intervention.
What A2X and Link My Books automate
Tools such as A2X and Link My Books sit between Amazon Seller Central and the accounting software. Their role is to translate Amazon’s settlement logic into structured accounting entries.
In broad terms, these tools:
- pull settlement data directly from Amazon,
- break it into sales, refunds, fees, VAT, and adjustments,
- post summary entries into Xero or QuickBooks,
- and clear those entries against the actual bank payouts.
By doing this, they help reduce two of the most common Amazon bookkeeping errors:
- treating net payouts as revenue, and
- losing the audit trail between Amazon reports and the general ledger.
There are still areas that require human review, particularly reimbursements, unusual adjustments, and inventory-related postings. Automation reduces risk and workload, but it does not replace judgement.
In the UK context, Link My Books is often preferred by some advisers for its built-in VAT logic, including handling of Amazon fee VAT following the August 2024 changes. A2X offers deeper configurability and is widely used, but typically requires more VAT mapping and review.
Which tool is more suitable still depends on the seller’s VAT profile, product mix, transaction volume, and level of accounting support available. Neither tool is a universal answer.
Xero vs QuickBooks for Amazon sellers
For most UK Amazon sellers, the accounting platform choice comes down to Xero or QuickBooks Online. Both are MTD-compatible and widely supported by accountants.
In practice, many UK e-commerce accountants prefer Xero for Amazon businesses because:
- clearing accounts are easier to review and spot errors in,
- VAT reports align more clearly with Boxes 1, 4, and 6,
- reverse-charge and marketplace-facilitator treatments are more visible,
- unlimited users make collaboration with advisers simpler.
QuickBooks can handle Amazon bookkeeping correctly, but it may require tighter configuration. Powerful bank-feed rules can mis-post payouts to revenue if not carefully controlled, which increases the need for review.
Both platforms integrate with A2X and Link My Books. In the UK market, Link My Books is most commonly paired with Xero because the VAT categorisation and reporting workflow is lighter-touch for Amazon sellers.
Red flags your tooling is no longer sufficient
Tooling problems usually show up as process strain before they show up as errors. Typical warning signs include:
- clearing account balances that never fully reconcile or are hard to explain,
- VAT returns that need correction or amendment each quarter,
- difficulty reconciling bank deposits to reported sales,
- month-end closes that slip later and later,
- profit figures that only make sense after manual rework.
These signals do not automatically mean the numbers are wrong. They often indicate that the system may no longer be self-checking and that errors are becoming harder to spot early.
Why tooling matters for UK Amazon sellers
For UK Amazon businesses, bookkeeping tools are not just about speed. They support:
- accurate VAT-threshold monitoring,
- reliable Box 6 figures that reflect taxable turnover rather than payouts,
- correct input VAT recovery on Amazon fees,
- a defensible MTD audit trail,
- and lower cost and stress at year-end or during HMRC reviews.
The practical goal is not sophistication for its own sake. It is to reach a point where the books are boringly consistent, month after month, and traceable back to Amazon source reports without reconstruction.
9. Month-End & Quarter-End Review Checklist
This checklist brings together everything covered earlier in the guide and turns it into a practical review framework. The purpose is not to create more work, but to confirm that your Amazon bookkeeping operates as a controlled financial system, not a collection of loosely connected tasks.
A strong month-end and quarter-end review does three things at once:
- It confirms your numbers are internally consistent.
- It reduces the risk of VAT and HMRC issues.
- It makes year-end accounts predictable rather than painful.
Clearing Accounts Reviewed and Explained
A well-run Amazon clearing account does not need to be zero at month-end, but any balance would normally be expected, explainable, and short-lived.
From a UK professional accounting perspective, clearing accounts exist to bridge timing differences between when Amazon recognises transactions and when cash actually moves. At month-end, a non-zero balance is usually acceptable where it represents one of the following:
- Sales recognised in the accounts but not yet paid out by Amazon.
- Funds temporarily held under Amazon’s Delivery Date plus Seven (DD+7) reserve policy.
- Account-level reserves applied due to performance, risk, or chargeback exposure.
- Settlement periods that span the month-end cutoff.
What matters is not whether a balance exists, but whether it can be tied back to Amazon evidence and whether it would ordinarily resolve in the normal course of a subsequent settlement cycle.
A healthy review process checks that:
- The clearing account balance agrees to Amazon’s final settlement position at month-end.
- Any balance carried forward is supported by a specific settlement report, reserve notice, or timing explanation.
- Prior-month balances have reduced or cleared as expected when the next settlement was paid.
Balances that roll forward unchanged for multiple months, grow without explanation, or cannot be reconciled to Seller Central reports indicate deeper issues such as missing settlements, duplicated postings, or incorrect period cut-off.
For most UK Amazon sellers, a monthly review is sufficient. Higher-volume sellers often review weekly to prevent small timing differences from compounding into material errors.
Inventory and COGS Reasonableness Checks
Inventory and cost of goods sold do not need to reconcile perfectly at a SKU-by-SKU level every month, but they should make commercial sense when reviewed in aggregate.
At month-end, inventory values should broadly align with what Amazon is holding on your behalf, based on:
- Opening inventory.
- Purchases and inbound stock.
- Units sold.
- Known adjustments such as returns, losses, or write-offs.
Using Amazon’s Inventory Ledger Report and related FBA inventory reports, sellers would typically confirm that:
- Inventory is reducing when sales occur.
- Inventory is increasing when stock is received.
- Inventory is not remaining static while sales continue.
- Negative inventory balances are not appearing in the ledger.
On the profit and loss side, COGS should move in line with sales volumes and historical margins. Red flags include:
- Stable sales with falling COGS.
- Sudden margin swings without changes in product mix or supplier pricing.
- COGS spikes caused by Amazon fees or advertising costs being misclassified.
- Inventory balances that never change despite ongoing sales activity.
Returns, reimbursements, and write-offs require particular attention. Customer returns should restore inventory and reverse COGS. Lost or damaged stock should be written down when identified, with later Amazon reimbursements treated as recoveries rather than new revenue. Stranded or obsolete stock would generally be reviewed for potential write-downs under applicable accounting standards where recovery appears unlikely.
The objective of this review is confidence, not perfection. If inventory and margins behave consistently and deviations are explainable, the system is working.
VAT Return Ready Without Manual Adjustments
One of the clearest signals of bookkeeping maturity is simple: the VAT return can be prepared and filed without last-minute manual fixes.
A VAT return is genuinely “ready” when:
- Box 1 reflects output VAT on sales based on correct VAT rates.
- Box 4 reflects reclaimable input VAT supported by valid invoices, including Amazon fees where applicable.
- Box 6 reflects total taxable turnover, not Amazon payouts or net bank receipts.
These figures would normally flow from your accounting software and be capable of reconciling back to Amazon reports and bank deposits, allowing for normal timing differences.
Manual journals added purely to “make the VAT return work” are a signal that something upstream needs attention, rather than a sign of readiness. This is distinct from legitimate one-off corrections or properly documented adjustments, which can arise in any system. The key distinction is whether adjustments are routine and recurring, or exceptional and well-evidenced.
Common causes of late VAT fixes for Amazon sellers include:
- Outdated treatment of Amazon fees following VAT rule changes.
- Marketplace-facilitated sales being double-counted as seller output VAT.
- Zero-rated or reduced-rate products incorrectly coded.
- Returns and refunds not fully reflected in VAT figures.
Where these issues are resolved at source, the VAT return becomes a by-product of good bookkeeping rather than a separate exercise.
Reports Saved and Backed Up
Amazon is not your archive. Your business is.
To support UK digital record-keeping requirements and remain defensible in the event of an HMRC enquiry, sellers would typically retain their own copies of key Amazon reports, including:
- Settlement reports.
- VAT transaction reports.
- Sales and refund transaction reports.
- Amazon fee VAT invoices.
- Reimbursement reports.
These records would generally be stored digitally, clearly named, and retained in line with applicable statutory record-keeping requirements (often at least six years). Relying on Amazon to retain historical data indefinitely creates unnecessary risk, particularly if an account is suspended or reports are changed or withdrawn.
A simple, consistent file structure with clear date ranges makes retrieval straightforward and supports a clean audit trail.
Issues Logged for Accountant Review
No bookkeeping system runs without exceptions. What matters is whether issues are surfaced early and handled deliberately.
An issue log turns discrepancies into controlled conversations rather than last-minute surprises. Items that should always be logged include:
- Clearing account balances that cannot be explained.
- Repeated VAT adjustments or anomalies.
- Unexplained margin or COGS movements.
- Missing or duplicated settlements.
- System changes, migrations, or new sales channels.
Logging issues monthly allows patterns to emerge. A one-off variance may be noise. The same issue appearing repeatedly usually signals a broken process that needs redesign.
Over time, issue logging can reduce accounting costs, shorten month-end close, and help demonstrate reasonable care and active oversight.
Why This Checklist Matters
When these checks are performed consistently:
- Your books reconcile without heroic effort.
- VAT returns become routine rather than stressful.
- Inventory and margins can be trusted for decision-making.
- Quarter-end and year-end work becomes predictable.
- Scaling the business does not require rebuilding the finance function from scratch.
This is the difference between bookkeeping as a compliance burden and bookkeeping as a financial control system.
To understand how this monthly control process connects to VAT registration, inventory valuation, settlements, and year-end accounts, see Amazon Seller Accounting – Complete Guide.
10. Download the Amazon Seller Bookkeeping Checklist (Free)
Running an Amazon business creates a unique accounting workload that generic bookkeeping advice does not cover. Amazon settlements, the rolling VAT registration threshold (based on taxable turnover), inventory movement, marketplace-collected VAT, and withheld reserves all mean that “doing the books” is not just about posting bank transactions.
To make this manageable, we have created a free Amazon Seller Bookkeeping Checklist, designed specifically for UK sellers and aligned with how professional accountants actually review Amazon accounts.
This checklist is not software-specific and does not replace an accountant. Its purpose is to give you a clear, repeatable structure so that errors are identified early, records remain defensible, and month-end does not turn into a clean-up exercise.
What’s included in the checklist
The checklist is structured around monthly discipline, because this is where most Amazon bookkeeping failures occur.
It includes:
-
Amazon settlement reconciliation steps
Clear guidance on reconciling Amazon payment and settlement reports to bank deposits, so net payouts are not mistakenly treated as revenue and clearing accounts do not drift over time. -
VAT monitoring and verification checks
Monthly prompts to review VAT coding, turnover against the VAT registration threshold, and Amazon VAT Transactions Reports, helping reduce the risk of late registration or misclassified sales. -
Inventory and COGS sense checks
Practical checks using Amazon inventory and movement reports to ensure cost of goods sold broadly aligns with stock movement, without requiring SKU-level accounting unless appropriate for your size and complexity. -
Fee and reserve controls
Steps to confirm Amazon fees appear complete, are correctly categorised, and are supported by the relevant VAT invoices or fee documentation available in Seller Central (or equivalent evidence), and that Amazon-held reserves are reflected in cash-flow expectations. -
Record retention reminders
A simple framework for downloading and storing key Amazon reports so your business, not Amazon, controls its accounting evidence.
Each checklist item reflects how UK accountants typically assess Amazon seller records before VAT filings, year-end accounts, or HMRC enquiries.
Who should use it monthly
The checklist is most valuable once transaction volume or regulatory exposure makes ad-hoc bookkeeping risky.
It is particularly relevant if you are:
- An FBA seller with regular settlements, refunds, and fee adjustments
- Approaching or monitoring the UK VAT registration threshold
- Already VAT-registered and submitting VAT returns under Making Tax Digital
- Selling across multiple channels alongside Amazon
- Spending increasing time fixing bookkeeping issues at quarter-end or year-end
Early-stage sellers can still use the checklist in a lighter form. The value is not in ticking every box immediately, but in establishing a habit of structured review before complexity increases.
How it aligns with HMRC expectations
HMRC recognises that mistakes can happen, but it expects businesses to take reasonable care.
This checklist supports that standard by encouraging:
- Regular reconciliation rather than annual catch-up
- Digital records that link back to source reports
- Early identification and correction of VAT and turnover issues
- Consistent treatment of income, fees, and inventory over time
Used consistently, it can help create a clearer audit trail showing how figures were derived and reviewed. That matters both for Making Tax Digital compliance and for reducing exposure if HMRC queries your records.
Next steps if your books aren’t clean
If you cannot currently reconcile Amazon payouts to your accounts, or if VAT figures only “work” after manual fixes, start with the checklist as a diagnostic tool.
If issues persist after applying it consistently, that is usually the point where professional support becomes cost-effective. Cleanup work is often less costly when problems are identified early than when they span multiple quarters or years.
Download the checklist, use it monthly, and let the numbers tell you whether your current setup is working.
Download Bookkeeping Checklist
Get the Amazon Seller Bookkeeping Checklist as a PDF you can save, and print.
Download Bookkeeping Checklist