All services

Amazon settlement and Shopify payout reconciliation for accurate accounts.

Platform settlement reports and gateway payouts are not accounting documents. Amazon settlement reports combine sales proceeds, FBA fees, advertising costs, reimbursements and loan repayments in a single net figure. Shopify payouts mix multiple gateways, each settling on different cycles. Bookkeeping built from these documents produces inaccurate accounts and unreliable VAT returns. We reconcile settlement data back to gross trading figures for accurate accounts.

Net payout
Amazon and Shopify settle net of fees; bookkeeping from bank statements alone misstates gross revenue and VAT
Every 2 weeks
Typical Amazon settlement cycle; each settlement mixes sales, fees, reimbursements and adjustments into one net deposit
Software neutral
Settlement reconciliation works with or without accounting software integrations like A2X or Link My Books

The challenges clients face.

Settlement reports mix revenue and expense categories

An Amazon settlement report is a single document combining gross sales (revenue), FBA fulfilment fees (expense), referral fees (expense), advertising costs (expense), reimbursements (revenue adjustment) and any loan repayments (financing). Treating the net figure as revenue, or treating fee categories as a single line, produces inaccurate accounts and a VAT return that does not reconcile to actual sales.

Multiple settlement cycles do not align with accounting periods

Amazon settles approximately every two weeks; Shopify Payments, PayPal and Stripe each have different settlement schedules. Monthly accounts need to accrue revenue and costs to the correct period regardless of when funds arrive in the bank. Settlement-based bookkeeping that matches bank deposits to accounting periods produces timing mismatches.

Returns and refunds in settlement data

Returns processed through Amazon or Shopify appear as negative adjustments in subsequent settlement periods. Correctly matching returns to the original sale period, and accounting for FBA return fees, is necessary for accurate revenue recognition and VAT returns.

COGS recognition for inventory-based businesses

Product sellers need to recognise cost of goods sold in the period the goods are sold, not when stock is purchased. Settlement-based bookkeeping that records stock purchases as expenses when bought overstates costs in stock-building periods and understates them in draw-down periods.

How we help.

Monthly reconciliation of settlement reports to gross trading figures

We reconcile Amazon settlement reports and Shopify payout data back to gross sales, categorise fees correctly as expenses, and produce monthly management accounts showing true trading revenue and margin.

VAT return preparation from reconciled data

Our reconciled accounts provide the gross sales figures needed for an accurate VAT return, with platform fees and advertising costs correctly treated for input VAT recovery.

COGS and inventory tracking

We set up or review your COGS recognition methodology so that stock costs are matched to sales in the correct period, giving a reliable profit figure for tax planning and business decisions.

Common questions

Can I just use my bank statement for my Amazon accounts?
No. Your bank statement shows net settlement payouts, not gross sales. For VAT purposes, taxable turnover is gross sales before Amazon's fees. For income tax, gross revenue and fee expenses need to be shown separately. Bookkeeping from bank statements understates revenue, understates expenses and produces a VAT return that cannot be reconciled to actual sales.
Do I need A2X or Link My Books to reconcile Amazon settlements?
These tools automate the reconciliation process and are widely used, but they are not the only approach. We can reconcile Amazon settlement data with or without these integrations, using exported settlement reports. If you already use A2X or Link My Books, we work with that data.

Speak to an ecommerce tax specialist.

Tell us about your situation and we will reply within 24 hours.