Accounting software for UK Amazon sellers must reconcile settlements at line level, produce a true profit and loss that separates fees from sales, keep Making Tax Digital compliant records with proper digital links, and automate advertising cost tracking. Osellpa is one option built specifically for this job, combining profit analytics with Amazon API data. The rest of this guide explains how to set these pieces up correctly and stay compliant.
TL;DR:
- Most Amazon settlement reports bundle sales, VAT, refunds, fees, and reimbursements, which must be split into individual components for accurate accounting.
- Software should automatically pull and reconcile settlement data at line level, ensuring proper VAT reporting and precise profit and loss calculations.
- Making Tax Digital compliance requires a fully integrated, digitally linked software stack that automates VAT submissions without manual data entry.
- Inventory valuation method consistency, especially between FIFO and weighted average, directly impacts gross profit accuracy and should match your stock reordering pattern.
- Using software like Osellpa that automates settlement, ad spend, and inventory data can boost sales by up to 20% and reduces reconciliation time from weeks to minutes.
Table of Contents
- What accounting software for Amazon sellers actually needs to do
- How to reconcile Amazon settlements into an accurate P&L
- Making Tax Digital for VAT: what your software must check
- Practical setup and automation checklist for UK Amazon sellers
- Handling VAT obligations for Amazon seller activity
- Choosing an inventory accounting method that fits your stock
- Recording Amazon fees that never appear in a settlement report
- Meeting VAT return deadlines without last-minute pressure
- Why analytics and MTD compatibility need to sit together
- Where Osellpa fits into your accounting setup
- Where to check the official rules yourself
- Sources
- FAQ
What accounting software for Amazon sellers actually needs to do
Amazon sellers tend to fall into two camps. Some want bookkeeping done right: clean ledgers, VAT boxes that match HMRC’s expectations, an audit trail that survives a compliance check. Others want to see where the profit actually comes from, down to the SKU, after fees and ad spend. Many UK sellers need both, and the software you choose should not force a choice between them.
The starting point is settlement-level detail. Amazon pays out a net figure every settlement period, but that number hides sales, VAT, refunds, FBA fees, storage costs, advertising debits and reimbursements all bundled together. Software that only records the net payout gives you a bank-matching figure and nothing useful for tax or profit analysis.
From there, three things matter most:
- Settlement-level imports that split every deposit into its component parts rather than recording one lump sum.
- Inventory valuation that feeds an accurate cost of goods sold into your profit and loss, not just a stock count.
- Advertising import and attribution so PPC spend appears against the products it was spent on, not as a single unexplained debit.
Get these three right and the rest, VAT reporting, margin analysis, month-end close, becomes far less painful. Get them wrong and you are reconciling by guesswork, which tends to surface at the worst possible moment: a VAT inspection or a year-end review.
How to reconcile Amazon settlements into an accurate P&L
Recording only the net payout from a settlement is the single most common accounting error among Amazon sellers. It looks tidy in the bank feed, but it buries the sales figure, the VAT collected, the fees charged and any refunds inside one number, which makes an accurate VAT return nearly impossible to produce.
The fix is a repeatable process:
- Pull the settlement report. Amazon makes flat file settlement reports available through the Selling Partner API, and software should schedule regular automated pulls rather than relying on manual downloads.
- Break each line into its components. Sales, VAT, refunds, fees and reimbursements each need their own ledger code, not a single “Amazon income” catch-all.
- Match the settlement total to the bank deposit. If you sell in more than one currency, apply a consistent conversion rule at the point of settlement rather than at the point of bank receipt, so the two figures tie out.
Pro Tip: Reconcile one full settlement end-to-end before trusting the automation on the rest. That single test catches mapping errors early.
Exceptions crop up regularly: inventory reimbursements arrive on a different schedule to the original sale, reserve holds shift balances between periods, and chargebacks can lag by weeks. Good software flags these separately rather than folding them into ordinary sales, which keeps your Amazon P&L accurate month to month.
Making Tax Digital for VAT: what your software must check
If you are VAT registered, Making Tax Digital rules apply to how you keep records and file returns, not just what figures you report. HMRC requires digital records and submission through functional compatible software, and when data moves between two different tools, that transfer must happen through a digital link rather than being retyped or copied by hand.
This matters more than it sounds. HMRC’s compliance guidance warns that failing to use compatible software and proper checking functions can result in penalties, and manual re-entry between spreadsheets breaks the digital link requirement even when the final figures are correct.
Before you file anything, check that your setup covers:
- A single MTD-enabled package that handles the full journey from Amazon data to VAT return, or a digitally linked stack where each handoff is automated rather than manual.
- The software’s own checking functions, including the ability to review figures before submission.
- A downloadable copy of the return and a clear audit trail, both of which HMRC guidance specifically calls out.
Test the digital links and the HMRC submission path with a real return before you rely on the system for a live filing. Enabling MTD is not the same as confirming it works end to end.
Practical setup and automation checklist for UK Amazon sellers
Getting from a blank account to a working, MTD-ready setup follows a fairly fixed order. Skipping steps tends to surface as reconciliation errors weeks later.
- Connect your account to Amazon through the Reports API and schedule daily or weekly settlement imports.
- Map each settlement field, sales, fees, refunds, reimbursements, to the correct nominal ledger code and VAT rate.
- Run one settlement through the system fully and check every figure against the original report before trusting the automation.
- Enable automated PPC import and confirm ad spend attributes correctly to a sample SKU.
- Set inventory cost updates to run automatically, or take regular stock-cost snapshots if your software does not update in real time.
- Run reconciliation reports weekly and download the VAT return copy before every filing.
Pro Tip: Do this checklist once with a full month of live data before switching off any manual checks, it is the fastest way to catch a mapping mistake before it reaches HMRC.
Once this is running, weekly reconciliation becomes a ten-minute check rather than a monthly scramble.
Handling VAT obligations for Amazon seller activity
You must register for VAT once your taxable turnover exceeds £90,000 in a rolling 12-month period, or as soon as you expect to cross that threshold within the next 30 days. This applies to the whole business, not just Amazon sales, so sellers running income through more than one channel need to track the combined total.
Many smaller sellers sit below the threshold but choose voluntary registration anyway, often because it allows them to reclaim VAT on stock and fees. If you are close to £90,000, track VAT-relevant fields in your accounting software before you are legally required to, since retrofitting VAT codes onto months of historic transactions is far slower than building them in from the start.
Cross-border sales add another layer. Selling into the EU or storing stock through Amazon’s European fulfilment network can trigger VAT obligations in those countries under rules separate from UK registration, and the fee structure your business faces may shift as a result, as covered in more detail in our guide to VAT changes affecting Amazon fees. Any software you use needs to distinguish domestic UK sales from cross-border ones at the point of import, not lump them together as generic revenue.
Choosing an inventory accounting method that fits your stock
Amazon sellers typically choose between two inventory valuation methods: FIFO (first in, first out) and weighted average cost. FIFO assumes the oldest stock sells first, which tends to suit sellers with fairly stable costs or products that do not change price often. Weighted average smooths cost fluctuations across a batch, which can suit sellers who reorder frequently at different unit prices, particularly when freight or exchange rate movements shift landed cost from one shipment to the next.
Whichever method you pick, consistency matters more than which one you choose. Switching methods partway through a year distorts your cost of goods sold and makes period-on-period profit comparisons unreliable.
Inventory valuation feeds directly into your P&L, since cost of goods sold is calculated from it, and an inaccurate stock valuation understates or overstates gross profit on every unit sold that period. Software that only tracks stock quantity, without linking unit cost to each sale, cannot produce a reliable P&L regardless of how well it handles settlement reconciliation elsewhere.
Recording Amazon fees that never appear in a settlement report
Settlement reports do not capture everything. Referral fees and per-unit FBA fulfilment fees usually do show up there, tied to individual orders, but storage fees, particularly long-term storage charges, are billed separately and can land in a different period to the sales they relate to.
This creates a timing mismatch: a product sold in March might carry storage costs charged in January, and if your software only reads settlement data, that cost disappears from the product’s own margin calculation. Accurate FBA fee tracking means pulling storage and other non-settlement charges into the same ledger structure, tagged to the right SKU and period, rather than leaving them as an unexplained deduction from cash.
The practical fix is to treat fee types as their own category in your chart of accounts: referral fees, FBA fulfilment fees, storage fees and advertising debits, each tracked separately rather than netted into one Amazon expense line. This is the only way to see which fee category is actually eating into margin on a given product.
Meeting VAT return deadlines without last-minute pressure
VAT returns are due within about six weeks after the end of your VAT quarter, and payment is due by the same time frame. Missing either can trigger penalty points under HMRC’s system, so the safest habit is to build reconciliation into your calendar well before the deadline rather than starting it in the final week.
A workable rhythm looks like this: reconcile settlements weekly throughout the quarter, run a full VAT check in the first few days after the quarter closes, and download the return copy from your MTD software before submitting, exactly as HMRC’s compliance guidance recommends. Leaving reconciliation until the deadline week is when digital link errors and missing reimbursements tend to surface, often too late to fix cleanly.
Why analytics and MTD compatibility need to sit together
Most sellers treat profit tracking and tax compliance as separate problems, solved with separate tools. That split is where the real admin burden comes from. Osellpa was built around the idea that profit tracking, PPC optimisation and AI-driven listing work should sit on the same data pulled directly from Amazon’s API, rather than requiring a seller to reconcile two systems by hand.
That same API connection is what makes automated advertising management possible: because spend and sales data come from one source, wasted ad spend becomes visible quickly rather than showing up as a vague dent in monthly profit. Sellers using these tools have reported sales increases of up to 20% after implementation. For the technical detail behind these workflows, our profit tracking validation guide walks through how to check the numbers yourself.
— Harry
Where Osellpa fits into your accounting setup
If you are spending hours each week piecing together settlement reports, ad spend and stock costs across spreadsheets, that is exactly the gap Osellpa was built to close. Growing sellers and part-time sellers alike tend to see the biggest benefit, since manual reconciliation eats a disproportionate share of time once order volume climbs.
Osellpa connects directly to Amazon’s API to pull settlement data, PPC spend and inventory costs into one profit and loss view, so you are not toggling between your ad dashboard and your bookkeeping software to work out what actually made money. Plans run from Launch at £96 a year up to Advanced at £384 a year, with monthly billing also available.
A practical next step is to test the profit and loss tool against one recent settlement, or check current pricing to see which plan fits your sales volume.
Where to check the official rules yourself
For the underlying requirements covered here, HMRC’s Making Tax Digital VAT notice sets out digital record-keeping rules, GOV.UK confirms VAT registration thresholds, and Amazon’s developer documentation details settlement report formats. For general bookkeeping workflow context, T-Ledgers outlines a bookkeeping-first approach worth comparing against an analytics-first one.
Sources
FAQ
What software features matter most for Amazon seller accounting in the UK?
Look for settlement-level reconciliation, a profit and loss report that separates sales, fees and advertising, and Making Tax Digital compatible record-keeping with proper digital links. Automation for advertising cost import and inventory valuation is what separates a workable setup from one that needs constant manual correction.
Do I need to register for VAT as an Amazon seller?
You must register for VAT once your taxable turnover exceeds £90,000 in a rolling 12-month period, or when you expect to cross that threshold within 30 days. Many sellers below the threshold register voluntarily to reclaim VAT on fees and stock.
How does Making Tax Digital affect Amazon sellers specifically?
Making Tax Digital requires VAT-registered sellers to keep digital records and file returns through compatible software, with digital links between any separate tools used in the process. Manually retyping figures between spreadsheets breaks this requirement even if the final numbers are correct.
How do I reconcile Amazon settlement reports correctly?
Pull the full settlement report through Amazon’s Selling Partner API rather than recording the net payout, then split each line into sales, VAT, fees, refunds and reimbursements before matching the total to your bank deposit. This level of detail is what keeps VAT reporting and your profit and loss accurate.
Does Osellpa handle both profit tracking and accounting reconciliation?
Osellpa pulls settlement, advertising and inventory data directly from Amazon’s API into one profit and loss view, which covers the analytics side of the job. Plans start at £96 a year for Launch, with Scale and Advanced tiers available for higher sales volumes.
