How to Reconcile Shopify Payments, PayPal, Stripe and Amazon Settlements

If you sell through multiple channels, your bank balance rarely tells the full story. Shopify Payments, PayPal, Stripe and Amazon pay net amounts after deducting fees, refunds, reserves and adjustments. That means a single bank deposit may represent hundreds of sales and costs.

For UK ecommerce sellers, accurate settlement reconciliation is essential for clean bookkeeping, reliable VAT returns, correct corporation tax calculations and meaningful management accounts.

Why settlement reconciliation matters

Recording only the amount that arrives in your bank can understate both turnover and costs. Your accounts should reflect the gross sales value, refunds, platform fees and the eventual net payout separately.

This matters because:

• Gross sales affect reported turnover and VAT registration monitoring
• Refunds can affect output VAT and revenue recognition
• Platform and processing fees may include VAT that is potentially recoverable
• Marketplace facilitator rules can change who accounts for VAT on certain sales
• Accurate channel level reporting helps you understand real profitability by platform

The objective is simple. Every sale, fee, refund, reserve and payout should have a clear accounting trail.

Start with settlement reports

Do not begin with the bank statement or your Shopify sales dashboard. Start with each processor’s settlement or payout report, as this shows the calculation behind the money received.

For each period, download:

• Shopify Payments payout reports
• PayPal transaction and balance affecting payment reports
• Stripe balance and payout reports
• Amazon settlement and transaction reports
• Business bank statements for the same period

A sales report shows customer orders. A settlement report shows what the platform has actually deducted and paid. This normally includes sales, refunds, fees, disputes, reserves, adjustments and the net payout.

Use separate clearing accounts

Create a dedicated clearing account in your accounting software for each payment channel:

• Shopify Payments clearing account
• PayPal clearing account
• Stripe clearing account
• Amazon clearing account

Avoid putting every platform into one generic payment clearing account. Separate accounts make it much easier to identify missing payouts, incorrectly posted refunds, delayed settlements and unresolved reserves.

Each settlement should flow through the relevant clearing account. Once fully reconciled, the balance should return to zero, except for genuine timing differences such as a payout due after month end or an Amazon reserve still being held.

Record gross sales and costs separately

Never post the net amount received in the bank directly as sales income.

For example, assume Shopify pays £8,500 into your bank account. The settlement report shows:

• Gross sales: £10,000
• Refunds: £500
• Shopify and payment fees: £1,000
• Net payout: £8,500

Your accounting should show:

This approach ensures that turnover remains accurate, fees are visible and the bank deposit can be matched directly to the payout.

Match settlements to your bank

Once the settlement activity has been posted, match the net payout shown in the settlement report to the deposit in the bank statement.

Check:

• The payout date
• The payout reference or settlement ID
• The amount received
• The currency
• Whether a transfer is pending, delayed or split into multiple payments

Amazon, PayPal and Stripe may have different payout timings from Shopify Payments. Amazon can also withhold reserves, while PayPal may hold funds because of account reviews, disputes or rolling reserve arrangements.

If the bank payment does not match the settlement report, do not force the reconciliation. Investigate the difference first.

Common reasons include:

• A payout is still pending
• A settlement spans a different date range
• A refund or chargeback was processed after the sale
• Currency conversion charges were deducted
• A reserve has been withheld
• The deposit relates to more than one settlement
• A fee has been omitted from the accounting entry

Reconcile Shopify Payments

Shopify Payments payouts should be reconciled against the relevant payout report rather than the Shopify sales dashboard.

For each payout, identify:

• Gross card sales
• Refunds
• Chargebacks and dispute fees
• Shopify Payments fees
• Currency conversion fees where applicable
• Net payout received in the bank

Where Shopify Payments is used alongside PayPal or other gateways, remember that not every Shopify order will be included in the Shopify Payments payout. Filter sales by payment method so that you do not double count income.

Reconcile PayPal

PayPal is often the most difficult platform to reconcile because the sale may be made through Shopify, but the cash is received and settled through PayPal.

The sales order may appear in Shopify as paid through PayPal. However, the fees, refunds, currency conversions and transfer to your bank are shown in PayPal.

For each period:

• Export the PayPal transaction report
• Identify customer receipts, refunds, fees and disputes
• Match PayPal transactions to the relevant Shopify orders where applicable
• Post PayPal fees separately from sales income
• Match PayPal withdrawals to the business bank account
• Investigate funds still held in the PayPal balance at period end

Your PayPal clearing account should equal the actual PayPal balance plus any known pending transactions.

Reconcile Stripe

Stripe usually groups individual card transactions into payouts. The payout report will show which charges, refunds, fees and adjustments sit behind each deposit.

For every Stripe payout:

• Record gross customer charges as sales
• Record refunds as sales returns or refund adjustments
• Post Stripe processing fees to payment processing expenses
• Consider currency conversion fees separately
• Match the net Stripe payout to the bank deposit
• Review disputes, chargebacks and chargeback fees individually

Stripe may pay out a few days after the original sale. This timing difference is normal and is exactly why a dedicated Stripe clearing account is useful.

Reconcile Amazon settlements

Amazon settlements require particular attention because they can include many different transaction types in one report.

These may include:

• Product sales
• Shipping income
• Gift wrap income
• Refunds
• Referral fees
• Fulfilment by Amazon fees
• Storage fees
• Advertising charges
• VAT related adjustments
• Account level reserves
• Reimbursements
• Net disbursements

Amazon reserves should not be treated as an unexplained difference. If Amazon holds money back at the end of a settlement, record it as a receivable or remaining balance in the Amazon clearing account. Release it when Amazon includes the reserve in a later payout.

For VAT purposes, check the VAT Transaction Report alongside the settlement data. Amazon may be deemed to supply certain transactions for VAT purposes, depending on where goods are held, where the customer is based and the nature of the sale. The accounting treatment should reflect the relevant marketplace facilitator rules rather than simply treating every Amazon order in the same way.

Review refunds, chargebacks and reserves

Refunds and chargebacks should not be ignored simply because they are deducted before payment reaches your bank.

A refund normally reduces sales and may require an adjustment to output VAT. A chargeback can involve both a reversed sale and a separate chargeback fee. These should be posted separately so that your revenue and dispute costs remain visible.

Reserves should be monitored closely. If a processor holds funds at the end of a month or quarter, your clearing account should show a reconciling balance that agrees to the amount held by the platform.

Complete a monthly reconciliation pack

A good monthly reconciliation process should leave an audit trail. Keep the following records for each platform:

• Settlement and payout reports
• Transaction reports
• Refund and dispute reports
• VAT reports where available
• Bank statements
• Clearing account reconciliation
• Notes explaining open balances and timing differences

Your final reconciliation should prove that: Gross sales − refunds − fees ± adjustments = net payout

The net payout should then agree to the bank deposit, while any remaining clearing account balance should be supported by pending payouts, reserves or other documented timing differences.

Common mistakes to avoid

• Posting only net bank deposits as revenue
• Using sales reports instead of settlement reports
• Combining Shopify, Stripe, PayPal and Amazon into one clearing account
• Missing platform fees and losing potential VAT recovery
• Double counting Shopify orders paid via PayPal
• Ignoring Amazon reserves at month end
• Treating chargeback fees as part of a refund
• Reconciling infrequently and allowing differences to build up
• Filing VAT returns before payment clearing accounts have been reviewed

How UK Ecommerce Accountants Can Help

Managing several payment providers is time consuming, especially where each platform has different payout cycles, fee structures and VAT reporting requirements. A professional ecommerce accountant can turn complex settlement data into clear, accurate financial records that support better tax compliance and decision making.

Our specialists Accountants for Amazon help ecommerce businesses keep control of multi channel sales, protect VAT accuracy and understand the true profitability of every sales platform.

• Setting up separate clearing accounts for Shopify Payments, PayPal, Stripe and Amazon
• Reconciling sales, refunds, fees, reserves and payouts against bank deposits
• Ensuring gross turnover is correctly reported for VAT registration and VAT returns
• Reviewing platform fees for correct VAT treatment and potential input VAT recovery
• Identifying sales affected by Amazon marketplace facilitator VAT rules
• Preparing accurate monthly management accounts and cash flow reporting
• Resolving historical reconciliation differences and clearing old suspense balances
• Supporting year end accounts, corporation tax returns and HMRC record keeping
• Providing clear profitability reporting by channel, product category and marketplace

Frequently Asked Questions