eCommerce Payment Reconciliation UK: Match Shopify, Amazon, Stripe and PayPal Payouts

eCommerce payment reconciliation is the process of matching each Shopify, Amazon, Stripe and PayPal payout to the orders, fees, refunds and VAT behind it, then to the deposit in your bank account. It confirms your accounts record true gross sales, not just the net amount received.

Picture a seller, Sarah, who runs a small eCommerce business. At the end of the month, she sat down to check her accounts. Her Shopify and Amazon dashboards displayed £12,000 in sales. But the total amount in her bank account was far lower than the sales data. After checking the transactions she found that marketplace fees, payment charges, refunds and payouts cover different sales periods.

What should have been a simple bookkeeping task turned into hours of matching numbers. This is a common challenge faced by online sellers who accept payments through multiple platforms.

eCommerce payment reconciliation helps you match each payout from Shopify, Amazon, Stripe and PayPal to the related orders, fees, refunds and VAT. In this guide, we will explain how eCommerce payment reconciliation works and how to reconcile these payments and keep your UK accounting records accurate.

What is eCommerce payment reconciliation? 

eCommerce payment reconciliation is the process of matching the orders recorded in an online store with the payments received from payment providers, and the deposits received in the business bank account. It confirms that every sale has been paid for, and that the amounts received agree with the amounts expected for fees, refunds and chargebacks. 

The payment reconciliation process is more complicated than standard bank reconciliation because money is not received at the same time as the sale. Payment providers such as Stripe, PayPal, Adyen and Shopify Payments usually pay out in batches, generally daily or weekly, after deducting their fees. A single bank deposit may therefore cover dozens or hundreds of orders, so the deposit cannot be matched directly to individual sales.

The reconciliation usually compares three sources:

• Store orders: the gross sales value recorded on the ecommerce platform
• Payment provider reports: transactions, fees, refunds, chargebacks and payout amounts
• Bank statement: the net payouts actually received

For every payout the figures should agree as follows: gross sales, less refunds, fees and chargebacks, equals the net payout deposited in the bank. 

Why eCommerce payouts never match your bank statement 

eCommerce payouts rarely match the sales figures or bank deposits, because payout is not a record of sales. It is a net settlement from the payment provider, covering a batch of transactions after deductions, and it arrives on a different date from the orders it relates to. 

The main reasons are: 

• Fees deducted before payout: Payment providers like Stripe, PayPal and Shopify Payments deduct their processing fees before sending the money to your account. This means the amount you receive is lower than the total sales made. 

• Batching: A single payment combined from many orders, often from several days.  No individual order matches the bank figure. 

• Timing gaps: Sales are recorded on the order date but payouts are settled some days later. Orders placed at the end of a period fall into the next period’s payout, so month-end totals never line up. 

• Refunds: Refunds are deducted from later payouts, sometimes in a different period from the original sale. 

• Chargebacks and dispute fees: The disputed amount and a separate fee are withdrawn often weeks after the order. 

• VAT: Order totals include VAT, while provider fees may carry their own VAT treatment, so the net figure cannot be compared with sales on a like-for-like basis. 

• Failed, pending or duplicate transactions: These appear in the store data but not in the payout, or the reverse. 

• Multiple channels: Payments from different providers or platforms may go into the same bank account, along with other unrelated payments. 

A mismatch is common and not a sign of error. The solution has two stages: first match orders to the provider’s payout report, where gross sales, refunds, fees and chargebacks add up to the net payout.  Then match each payout to its deposit on the bank statement. 

The eCommerce payment reconciliation process (step by step) 

The process works in two stages: first reconcile orders to each payout, then reconcile each payout to the bank. Follow these steps for every reporting period, whether monthly or weekly.

• Set the period and arrange your data: For ecommerce payment reconciliation process, first choose the date range. Then export the order report from your eCommerce platform, the payout and transaction reports from each payment provider, and the bank statement for the same period. Use the same date basis (transaction date or payout date) throughout. 
  
• Divide the data according to payment provider and channel: Separate the data according to payment platforms and marketplace sales. and any other sources, so each can be reconciled on its own terms.

• Match orders to provider transactions: Verify that every paid order transaction is matching with the provider’s report. Spot orders with no payment, payments with no order and other duplicate transactions.

• Record fees, refunds and chargebacks: Record processing fees, refunds and chargebacks separately instead of deducting them from sales. This will help to show the full sales revenue and make payment-related costs easier to track. 

• Account for VAT and currency: Verify that the VAT on sales is accurately recorded and VAT on provider fees is treated according to the invoice. And foreign currency sales are converted at the rate used by the provider, with any exchange differences recorded. 

• Identify and investigate unmatched transactions: Make a list of every difference, missing payouts, unexplained deductions,and timing items. Resolve whatever is possible and carry forward genuine timing differences. 

• Post adjusting entries: If a transaction appears in the provider or bank data but not in your books, record it. Typical items are fees, reserves, chargebacks and currency differences.

• Confirm the closing balances and review: Check that the balance in the payment provider account matches the money still waiting to be paid into the bank. Make sure the updated records match the bank statements. Keep the reports and an approved summary as evidence for your accountant or auditor. 

eCommerce Payment reconciliation example: one Shopify payout 

This eCommerce payment reconciliation example uses illustrative figures for one Shopify Payments payout covering a week of orders.

Line	Amount	Note
Gross sales (VAT inclusive)	£2,400.00	Includes £400.00 VAT, one sixth of the gross amount
Refunds	(£120.00)	Includes £20.00 VAT reversed in the refund period
Processing fees	(£68.50)	Record as an expense, separate from sales
Chargeback	(£45.00)	The disputed order amount
Dispute fee	(£15.00)	A separate cost
Net payout to bank	£2,151.50	Matches one bank deposit

£2,400.00 less £120.00, £68.50, £45.00 and £15.00 equals £2,151.50. In your books, post the full £2,400.00 as sales, then post each deduction on its own line, so the bank deposit matches a single summary entry.

How to reconcile each platform 

Each eCommerce platform’s payment reconciliation method is the same. Match orders to the platform’s own payout report, then match each payout to a bank deposit. The only change is which report to use and which deductions to expect.

Shopify (Shopify Payments): Shopify is an online platform that enables companies to create and run their own online stores. It is used by numerous independent companies and small enterprises in the UK to sell directly to consumers. Shopify Payments and other payment processors like PayPal and Klarna can accept payments. 

Reconciliation point: Orders paid with Shopify Payments are the only ones covered by Shopify Payments. Payments made by bank transfers, PayPal, or Klarna must be independently compared to the records of the applicable supplier. 

UK consideration: Customer payments are separated from Shopify subscription and app fees. These should be documented as business expenses. Check the VAT shown on the invoice, as UK VAT registered businesses may need to apply the reverse charge.

Amazon UK (Seller Central): In the UK Amazon is one of the most popular eCommerce platforms. Online business owners can sell their products directly to customers through Amazon. Payment is directly deposited into online sellers’ bank accounts. 

Reconciliation point: Sales, refunds, and a variety of expenses, including referral fees, delivery and fulfillment charges, storage fees, and advertising costs, are all included in each settlement. What is left over after these deductions is the total sum paid into the bank. Settlements are usually paid about every 14 days. Use the settlement report, which lists each transaction by type, amount type and description. It shows sales and refunds with VAT, but it is not a VAT invoice for Amazon’s fees.

UK consideration: Two different months may be included in Amazon settlement periods. To ensure that revenues and expenses are recorded in the appropriate month, businesses might need to divide the numbers between accounting periods. Amazon fees and VAT on sales must also be accurately recorded. 

eBay UK: eBay is used by both individuals and businesses to sell products. It collects payments from customers and transfers money to sellers bank accounts after deducting the relevant amount of fees. 

Reconciliation point: Every payout includes payments for several orders. Fees, refunds and other costs are deducted before the money reaches the bank. These may include selling fees, postage label costs and promoted listing charges.

UK consideration: UK sellers are generally charged fees in pounds sterling, with VAT added where applicable. The transaction report should be used to identify the fees and VAT amounts so they can be recorded correctly in the accounts.

Stripe: Stripe pays your balance to your bank on the schedule set in your account, so each deposit covers many charges. Use the Stripe balance and payout reports to see which charges, refunds, fees and disputes make up each payout. Reconcile the report total to the bank deposit, then post gross sales, fees and refunds on separate lines.

UK consideration: Payment processing fees are generally exempt from VAT, but follow the VAT shown on Stripe’s invoice or statement.

PayPal: PayPal holds a balance, and money reaches your bank only when you transfer it. Use the PayPal activity or transaction report to list sales, fees, refunds and transfers. Give PayPal its own clearing account, then match each transfer to its bank deposit. Sales taken through PayPal never appear in Shopify Payments payouts, so reconcile them separately.

Payout timing at a glance

Platform	Typical payout pattern	Report to use
Shopify Payments	Rolling schedule	Payouts and transactions reports
Amazon UK	Settlement about every 14 days	Settlement report
Stripe	Schedule you choose	Balance and payout reports
PayPal	On demand transfer	Activity report

UK VAT on eCommerce fees, refunds and sales 

Sales: 

Rates: Standard 20%, reduced 5%, zero 0%. VAT on a VAT-inclusive price is one sixth of the gross amount. 

Registration: You must register if taxable turnover passes £90,000 in any rolling 12 month period, or if you expect to pass it in the next 30 days alone. You can apply to deregister if turnover is expected to fall below £88,000. Both figures apply for 2026/27, and zero rated sales count towards the threshold.

Who accounts for VAT: UK based sellers account for VAT on their own sales. For consignments of £135 or less sold to UK customers from overseas, UK VAT is charged at the point of sale, and the marketplace is treated as the seller where it facilitates the sale. The same applies where an overseas seller sells goods already held in the UK through a marketplace.

2026 update: Separately from VAT, the £135 customs duty relief on low value imports is being removed. Draft legislation was published in July 2026, and duty is expected to apply by October 2028 at the latest. Check HMRC guidance before pricing imported stock.

Delivery: Charges to the customer follow the VAT rate of the goods.

Refunds: 

• Refunds can be made in full or in proportion to the original sale and its VAT.
• Instead of the period of the initial sale, the VAT adjustment occurs during the VAT period in which the refund is given.
• The input VAT on those costs also changes when the client receives a refund because eCommerce platform commission is partially reimbursed, less a refund administration fee. 

Making Tax Digital: VAT registered businesses must keep digital records and file VAT returns through MTD compatible software. From April 2026, sole traders and landlords with qualifying income above £50,000 also join MTD for Income Tax, so reconciled records need to feed that software too. Confirm current thresholds and dates on GOV.UK.

Automated payment reconciliation: when spreadsheets stop working 

For low-volume eCommerce payment reconciliation, spreadsheets make sense. When the time and error risk of manually matching transactions exceed the expense of automating it, they cease to function. The indicators can be measured.

Where spreadsheets fail: 

• Volume: Hundreds or thousands of transactions make manual checking slow and time-consuming. 
• Multiple platforms: Shopify, Amazon, eBay, PayPal and Stripe all use different report formats and fee structures.
• Month-end splits: Payments covering different months or VAT periods must be separated, which can lead to mistakes.
• Unmatched payments: Differences may remain unresolved because there is not enough time to investigate them.
• Delayed accounts: Slow reconciliation can delay month-end accounts and VAT returns.
• Spreadsheet errors: Broken formulas, overwritten figures and incorrect data can go unnoticed.
• Poor records: It can be difficult to show how payouts were calculated and who made changes.

How does automation help: 

The identical two-stage match is carried out by automated eCommerce payment reconciliation software or a payout-based accounting connector (like A2X or Link My Books) without the need for manual steps:

1. It imports orders and payout data directly from each platform.
2. It splits each payout into sales, VAT, refunds, fees and adjustments.
3. It posts one summary entry per payout to Xero, QuickBooks or Sage.
4. It matches that entry to the bank feed deposit.
5. It flags differences, such as missing fees, reserves or unmatched deposits, for review.

Common mistakes and how often to reconcile 

The eCommerce business has several transactions. Therefore, mistakes can happen while doing eCommerce payment reconciliation.

1. Matching orders directly to the bank deposit

• Problem: A deposit is a net payout covering many orders, so it never equals order totals. 
• Solution: Reconcile in two stages: match orders to the payout report, then match each payout to its bank deposit.

2. Recording the net payout as sales

• Problem: Revenue, VAT and fees are all understated.
• Solution: Post gross sales from the order data, with fees, refunds and chargebacks on separate lines.

3. Netting refunds against sales

• Problem: This hides the refund rate and makes VAT adjustments hard to trace.
• Solution: Post refunds on their own lines, and reverse the VAT in the period in which the refund is made.

4. Ignoring settlements that span period ends

• Problem: Sales and fees land in the wrong month or VAT period.
• Solution: Split each settlement by transaction date before posting.

5. Claiming input VAT from the payout report

• Problem: A fee line in a payout or settlement report is not a VAT invoice.
• Solution: Reclaim input VAT only on a valid VAT invoice from the platform, and check that its total agrees with the fees deducted.

6. Treating all fees alike for VAT

• Problem: Marketplace fees are standard-rated, while payment processing fees are often exempt.
• Solution: Follow the VAT shown on each supplier’s invoice, and code each fee type to its own account and VAT rate.

7. Using one account for every provider

• Problem: Errors in one provider are hidden by the others.
• Solution: Use a separate clearing account for each platform and gateway, and reconcile each before combining totals.

8. Missing non-card payments

• Problem: PayPal, Klarna and bank transfers do not appear in Shopify Payments payouts.
• Solution: Reconcile each gateway to its own report, and match manual payments such as bank transfers directly to the bank statement.

9. Forgetting reserves, holds and disputes

• Problem: Withheld or clawed-back funds create unexplained gaps.
• Solution: Record reserves, holds and disputes as adjustments, and track each one until the funds are released or the dispute is closed.

10. Mixing date bases

• Problem: Combining order date and payout date makes periods impossible to agree.
• Solution: Choose one date basis for each reconciliation and apply it consistently to every source.

11. Leaving small differences unresolved

• Problem: Minor gaps accumulate and mask real errors.
• Solution: Investigate and clear differences each period, and list any that remain open with an owner and a resolution date.

12. Not keeping evidence

• Problem: Support for accountants, auditors or HMRC is weak.
• Solution: Keep the platform report, payout ID and bank line together for every payout, and retain VAT invoices with them.

13. Starting a sync mid-period

• Problem: This creates partial payouts that never match.
• Solution: Start syncing on the first day of a period, and test the first payout against the bank deposit before syncing the rest.

When to hire an eCommerce accountant 

It is the right time to hire an eCommerce accountant when eCommerce payment reconciliation and other accounting tasks take time away from growing the business.

Signs it is time:

• VAT threshold: The registration threshold is £90,000 of taxable turnover in any rolling 12-month period. An accountant can advise on timing and VAT schemes.

• Multiple channels: Shopify, Amazon, eBay and PayPal each need their own reconciliation.  

• Overseas selling or imports: Overseas VAT, import VAT and currency add compliance risk. 

• Unsure on VAT treatment: Fees, refunds and chargebacks vary by supplier. 

• Rapid growth, investment or sale: Investors and buyers expect clean, reconciled accounts. 

• Amazon FBA or warehouse stock: Stock location can create VAT obligations. 

Not sure if you have outgrown your current bookkeeping? Talk to E2E Accounting about where your eCommerce accounts stand today. 

FAQs: Frequently Asked Questions