Shopify, Amazon & eBay Reconciliation Guide
Ecommerce reconciliation across Shopify, Amazon, and eBay creates complexity that standard bookkeeping never touches. The definitive guide to online seller bookkeeping -- from settlement timing to multi-channel accounting.
Quick answer
E-commerce reconciliation across Shopify, Amazon, and eBay is fundamentally different from standard bank reconciliation because the platform settles in batches: one bank deposit can represent dozens or hundreds of underlying customer orders, less platform fees, less refunds, less chargebacks. The clean approach is to treat each platform as a clearing account in your books: record gross sales as income, platform fees as Bank Charges or Selling Fees, refunds as credit notes, and the net settlement as a transfer from the platform clearing account to the bank. MatchIQ and CodeIQ both have merchant parsers for eBay, Amazon, and PayPal that extract sales, fees, shipping, and refunds from platform CSVs (and map other marketplaces’ exports with RiQ’s help), so each bank deposit walks back to its underlying orders.
Online sales now make up close to 29% of all retail sales in Great Britain (28.8% in September 2026, according to the Office for National Statistics). For bookkeepers, that means ecommerce reconciliation is no longer a niche skill: it is essential.
Online seller bookkeeping at this volume is not standard. An eBay seller with 200 orders a month faces multi-channel accounting challenges that simply do not exist for a traditional retail shop. The bank statement shows one deposit. The platform shows 200 transactions. The difference is not a rounding error.
The Many-to-One Problem in Ecommerce Reconciliation
A traditional business receives 15 customer payments on Tuesday. The bank statement shows 15 deposits. Reconciliation is straightforward: match each deposit to its corresponding invoice.
An e-commerce business processes 200 orders on Tuesday through Stripe. The bank statement shows one deposit on Thursday. That single deposit represents 200 individual transactions, minus fees, minus refunds, plus or minus adjustments from previous settlement periods. You need to match one bank entry against a platform settlement report that runs to several pages.
This is the fundamental difference in ecommerce reconciliation. Online seller bookkeeping creates a many-to-one matching problem. Settlement reports become essential working documents, not optional extras.
The Settlement Report
Every major platform generates settlement reports. Shopify calls it a Payout Report. Amazon calls it a Settlement Report. Stripe calls it a Payout Reconciliation. The names differ but the purpose is identical: to explain how the platform arrived at the amount it deposited to your bank account.
Download the settlement report first. It is the bridge between your sales records and your bank statement.
Settlement Timing Varies Wildly
A customer places an order on Monday. When does the money reach your bank account? The answer depends entirely on which payment processor you use and your account history with them.
Stripe
Established UK accounts are paid out on a rolling schedule a few days after each charge, and a new account’s first payout takes longer while Stripe builds a history. You can switch to daily, weekly or monthly payouts, or pay out manually.
PayPal
Instant transfers: available for a fee if your bank supports it. Standard transfers: 3 to 5 business days. New sellers: funds may be held for up to 21 days on early transactions as fraud protection. The 21-day hold applies per transaction, not per account, until you establish a selling history.
Amazon
Settlements every 14 days, on a cycle tied to your own account rather than to calendar dates. A sale made on the first day of a cycle waits nearly two weeks; a sale on the last day waits one. The timing is uneven by design.
eBay
Daily or weekly payouts depending on your selected schedule. Managed Payments settles to your bank account directly, typically 2 business days after the buyer's payment clears.
These delays create timing differences between your sales reports and your bank statement. A sale recorded on March 15 might not reach your bank until March 22 via Stripe, March 30 via Amazon seller reconciliation, or April 5 via PayPal if you are a new seller. This is normal. Your reconciliation workflow must account for these predictable delays.
Fee Structures That Never Match
The bank deposit is always net of fees. The gross sale amount never appears in your bank account. Understanding the fee structure for each processor is essential because you need to reconcile both the gross sales and the fees separately.
UK Payment Processor Fees (October 2026)
PayPal: 2.9% + 30p on standard UK payments, or 1.2% + 30p when a buyer pays by card through PayPal’s card checkout. International payments add 1.29% (EEA) or 1.99% (elsewhere), and currency conversion costs 3% above the base rate.
Stripe: 1.5% + 20p for standard UK cards, 2.8% + 20p for premium UK cards, 2.5% + 20p for EEA cards and 3.15% + 20p for other international cards. Add 2% where currency conversion is needed.
Amazon: referral fees of mostly 7% to 15% depending on product category and price band (Amazon cut several bands for lower-priced items in 2026, so check the current category table). Add FBA fees if using Fulfilment by Amazon, charged per unit by size and weight, and monthly storage fees by volume, which rise in October to December.
eBay: business sellers pay a final value fee that varies by category (roughly 10% to 13% for most) on the total including postage, plus 30p per order (40p on orders over £10 since February 2026) and a 0.35% regulatory operating fee. Promoted Listings add a further percentage if used, and insertion fees apply beyond the monthly free allocation. Private sellers in the UK pay no final value fee in most categories.
These fees are deducted before settlement. If you sell £1,000 of goods through Stripe at 1.5% + 20p, the calculation per transaction varies by order value, but the settlement you receive will be approximately £985 after fees. Your bank statement shows £985. Your accounting records need to show £1,000 revenue and £15 payment processing expense.
The common error is to record only the net deposit. This understates both revenue and expenses. The bank statement does not tell you what the customer paid. Only the settlement report does.
Returns and Chargebacks from the Past
A customer buys a £200 item in November. You receive the payment in November. The customer returns the item in February. The refund is processed in February but relates to November's sale. Where does this appear in your accounts?
If you are reconciling February, you will see a negative entry in the settlement report. If you reconcile at transaction level, you need to identify the original November sale and reverse it. If you reconcile at settlement level, you accept the negative entry as a February adjustment. Both approaches are defensible but they produce different management accounts for the intervening months.
Chargebacks are worse. A chargeback is a forced reversal initiated by the customer's bank. Common triggers: item not received, item significantly not as described, unauthorised transaction. The customer has 120 days from the transaction date to file a chargeback. That is four months.
Platforms typically deduct the chargeback from your next settlement and add a fee. Stripe charges £20 per dispute. PayPal charges £14 per chargeback (see our PayPal reconciliation guide). You lose the original sale, you lose the product if it was shipped, and you pay the fee on top. This appears as a negative entry in the settlement report, possibly months after the original transaction.
The Timing Problem
Returns and chargebacks create timing mismatches between your sales records and your bank deposits. An aggressive approach is to reverse the original sale when the refund is processed. A conservative approach is to record refunds and chargebacks as separate expenses in the period they occur. The conservative approach is more common because the original sale has typically already been reported to HMRC in a prior VAT period.
Multi-Currency and Foreign Exchange
A UK seller on eBay.de receives a €150 payment. PayPal converts this to GBP at the point of settlement. The exchange rate used is not the rate on the day of sale. It is the rate on the day of settlement. If settlement occurs 3 days later and the pound strengthens against the euro, you receive fewer pounds than you expected.
Your accounting records need to reflect this. The sale was €150. The settlement was £127. The difference is a foreign exchange loss of £2 (assuming you recorded the sale at £129 based on the exchange rate at sale date). This loss is a genuine business expense but it only becomes apparent when you reconcile the settlement to the bank deposit.
Some platforms let you hold balances in multiple currencies. Stripe supports 135+ currencies. PayPal supports 25 currencies. If you hold a euro balance, you avoid the automatic conversion but you create a new reconciliation problem: you now have three bank accounts to reconcile (GBP current account, EUR PayPal balance, USD Stripe balance). Each balance has its own settlement reports and its own timing delays.
VAT Complexity Post-Brexit
E-commerce VAT is not straightforward even for purely domestic sales. Post-Brexit, the complexity increased substantially for sellers who trade internationally.
UK Domestic Sales
Standard-rated at 20%. This is the simple case. Record the sale including VAT, pay HMRC quarterly under MTD for VAT.
EU Sales Post-Brexit
Sales to businesses: goods sent from Great Britain to the EU are zero-rated exports if you keep proof of export. Sales to consumers: these are imports into the EU, so either you register for the EU’s Import One Stop Shop (IOSS) and charge EU VAT at checkout on parcels worth €150 or less, or the buyer pays import VAT and handling charges on delivery. (The €10,000 distance-selling threshold only helps sellers established in the EU.) Amazon and eBay collect EU VAT on your behalf under marketplace rules for low-value consignments and for stock that non-EU sellers hold in EU warehouses.
Amazon Deemed Supplier Rules
Amazon is the deemed supplier, and accounts for the VAT to HMRC itself, in two cases: B2C sales of goods held in the UK by sellers established outside the UK, and imported consignments worth £135 or less. In those cases the seller does not account for output VAT on the sale. A UK-established seller selling stock held in the UK is not covered: it charges VAT and pays it to HMRC as normal, so do not assume Amazon has dealt with it. Your accountant needs to know which applies or your VAT return will be wrong.
Platform Fees and Reverse Charge
Check which entity bills each fee and whether it charges VAT, rather than going by the brand. PayPal’s transaction fees are generally treated as exempt financial services, so there is no VAT to reclaim. Stripe’s treatment is less settled, so follow its invoices and agree the approach with your accountant. Marketplace selling fees from Amazon and eBay are standard-rated, and a VAT-registered seller can reclaim the VAT on them with a valid invoice. Only where a standard-rated fee comes from a supplier outside the UK with no UK VAT charged do you use the reverse charge: add the VAT as output tax and reclaim it as input tax in the same return. It nets to nil, but it must be done correctly or HMRC will query your return.
The VAT registration threshold for UK-established sellers is £90,000. The key detail is "UK-established". If you are a non-UK seller using FBA with stock in UK warehouses, you create a UK VAT obligation regardless of turnover. If you are a UK seller using FBA with stock in EU warehouses, you create local VAT obligations in those countries. The thresholds and rules vary by country. This is why many smaller sellers avoid storing stock abroad.
Since 1 July 2026 the EU has charged a temporary flat €3 customs duty per item on low-value parcels (up to €150) imported from outside the EU, including from the UK, ahead of removing the €150 duty exemption altogether in 2028. In the other direction, the UK confirmed in its November 2025 Budget that it will end customs duty relief on imports worth £135 or less by March 2029 at the latest (import VAT already applies to those parcels). The compliance burden for cross-border e-commerce is increasing, not decreasing. Platform integrations with customs brokers will become essential.
The Multi-Channel Accounting Workflow
Given these complexities, what does a competent ecommerce reconciliation workflow actually look like for online seller bookkeeping?
Download Settlement Reports First
Not your sales reports. Settlement reports. These show what was actually deposited to your bank account and how the platform calculated it. Shopify: Finance → Payouts. Amazon: Reports → Payments → Settlement. Stripe: Balance → Payouts. PayPal: Activity → Statements → Balance-Affecting Payments.
Match Settlement Totals to Bank Deposits
Open your bank statement. Find the deposit. Open the settlement report. Confirm the settlement total matches the bank deposit. If they match, you have successfully identified which settlement period corresponds to which bank deposit. If they do not match, you have either selected the wrong settlement period or there is a bank error (rare) or the settlement is still pending (common).
Reconcile Individual Orders Within the Settlement
The settlement report shows gross sales, fees, refunds, chargebacks, adjustments. Verify each category. Cross-reference the order IDs to your sales records if needed. Identify any unexpected fees or adjustments. Common surprises: subscription fees for platform services, currency conversion fees, VAT collected by the platform on your behalf.
Record Gross Sales and Fees Separately
Your accounting entries should show gross sales as revenue and platform fees as payment processing expenses. Do not record only the net deposit. This understates your revenue and hides your true cost of sales. If you sold £10,000 and paid £150 in fees, record £10,000 revenue and £150 expense, not £9,850 revenue.
Handle Refunds and Chargebacks as Period Adjustments
Unless the refund relates to the current period, record it as a separate adjustment rather than reversing the original sale. This keeps your historical records clean and avoids amending prior VAT returns unnecessarily. Chargebacks should include both the reversed sale and the chargeback fee as separate line items.
Reconcile Foreign Exchange Gains and Losses
If you trade in multiple currencies, compare the GBP value recorded at sale date to the GBP value received at settlement date. The difference is an FX gain or loss. Record it as such. Do not adjust the revenue figure. Revenue is what the customer paid at the exchange rate on the day of sale. The FX movement is a separate financial item.
This multi-channel accounting workflow is tedious if performed manually. A Shopify seller processing 500 orders a week will spend several hours on ecommerce reconciliation if doing this by hand. The arithmetic is not complex but the volume is high and the scope for error is substantial.
It is also the part worth automating. CodeIQ reads eBay, Amazon and PayPal settlement exports (and maps others such as Stripe, Etsy and Square with RiQ’s help), splits each payout into sales, fees, shipping and refunds, codes them alongside the bank statement and posts the result to Xero, QuickBooks, Sage, Pandle or FreeAgent. MatchIQ then checks every payout against the bank statement and lists anything that doesn’t agree.
If you keep the books in IQ Books, ReconcileIQ’s own accounting software, Stripe, PayPal and eBay can feed in directly as channel feeds alongside the bank, so the settlements arrive without an export at all.
Common Mistakes to Avoid
- Recording the bank deposit as revenue without accounting for fees separately. This understates expenses.
- Trying to match individual transactions to bank deposits instead of settlement periods. This fails because platforms batch transactions.
- Ignoring settlement timing. A sale in February might settle in March. Both the sale date and settlement date matter for different accounting purposes.
- Assuming Amazon has dealt with the VAT. It is the deemed supplier only for overseas sellers and low-value imports; a UK-established seller still owes the VAT on its own sales, and the return is wrong either way if you guess.
- Treating FBA fees as operating expenses instead of cost of goods sold. This misstates gross margin.
Ecommerce reconciliation is different because the underlying economics are different. Settlement timing, fee deduction, returns windows, chargeback rights and multi-currency conversion create layers of multi-channel accounting complexity that do not exist in traditional retail. A bookkeeper encountering their first e-commerce client should expect to spend longer on reconciliation than for a comparable traditional business. This is not inefficiency. This is the nature of the sector.
The good news is that the online seller bookkeeping workflow is repeatable. Once you understand how Shopify settlements work, every Shopify client follows the same pattern. Once you understand Amazon's referral fee structure, it applies across all Amazon sellers. The investment in learning the platforms pays dividends across your client base.
Automate Your E-commerce Reconciliation
Settlement reports, bank deposits, and platform fees reconciled automatically. See how MatchIQ handles multi-processor reconciliation.
Try MatchIQFrequently Asked Questions
Why is e-commerce reconciliation harder than standard reconciliation?
E-commerce creates a many-to-one problem. The bank statement shows one lump sum deposit; the platform shows hundreds of individual orders. Settlement timing varies wildly by processor: PayPal may hold funds for up to 21 days for new sellers, Stripe pays out within a few days, Amazon pays fortnightly. Fees are deducted before settlement so the bank deposit never matches gross sales. Returns and chargebacks from months ago appear as negative entries. Multi-currency sales create foreign exchange gains and losses.
How do I reconcile Shopify payments when the bank deposit does not match my sales?
Download the settlement report from Shopify, not just your sales report. The settlement report shows the actual amount deposited to your bank after fees, refunds and chargebacks. Match the settlement total to your bank deposit. Then reconcile the individual orders within that settlement period. You are matching one bank deposit against potentially hundreds of transactions.
What are the main fee structures for UK payment processors?
PayPal charges 2.9% + 30p on standard UK payments (1.2% + 30p when a buyer pays by card through its card checkout), with 1.29% to 1.99% more for international payments. Stripe charges 1.5% + 20p for standard UK cards, 2.5% + 20p for EEA cards and 3.15% + 20p for other international cards. Amazon charges referral fees of mostly 7% to 15% by category plus FBA and storage fees. eBay business sellers pay a final value fee that varies by category, a 30p or 40p per-order fee and a 0.35% regulatory operating fee. These fees are deducted before settlement, so the bank deposit is always net of fees.
How do I handle e-commerce VAT post-Brexit?
UK domestic sales are standard-rated at 20%. Goods exported to EU businesses are zero-rated with proof of export; parcels to EU consumers worth €150 or less can go through the EU's Import One Stop Shop. Amazon is the deemed supplier, and accounts for the VAT, only on sales by overseas sellers of goods held in the UK and on imported consignments of £135 or less; a UK-established seller still charges and pays VAT on its own UK sales. Check each platform's fee invoice before applying the reverse charge, which only applies to standard-rated fees from a supplier outside the UK. The UK VAT registration threshold is £90,000 for UK-established sellers.
What is the settlement timing for major payment processors?
Stripe pays out a few days after each charge for established accounts. PayPal can be instant for manual withdrawals, but may hold funds for up to 21 days for new sellers. Amazon pays fortnightly on a fixed schedule. eBay settles daily or weekly depending on your payout schedule. These delays create timing differences between when a sale is recorded and when the funds appear in your bank account.