Weekly Ecommerce Accounting Insights: Shopify Payout Reconciliation and VAT Done Right for UK Sellers

Start with the difference between sales and payouts

A Shopify sales report shows activity over a selected period. A payout shows money transferred to your bank after Shopify Payments processes transactions and deductions. The payout date may also fall after the order date, so the two reports can cover different periods.

Common reasons they don’t match include:

• Settlement timing: orders are recorded before the related funds reach your bank.
• Refunds and chargebacks: these reduce the amount paid out and may be recorded on a different date from the original sale.
• Processing fees: Shopify Payments fees are deducted from eligible transactions.
• Adjustments: reserves, disputes or other balance changes can affect a payout.
• Currency conversion: exchange rates and currency-related charges can change the sterling amount received.
• Other payment methods: payments handled by another provider may be paid out separately and have a different fee structure.

For example, a sales report might show £1,200 in orders for a particular week. The bank might receive less because some orders are still awaiting settlement, a refund was processed, and fees were deducted. The difference needs to be explained in your records, not written off as a reduction in sales.

Use a clearing account to make every payout traceable

A Shopify clearing account gives you a practical way to connect sales activity to bank deposits. It records amounts due from Shopify Payments before they arrive in your bank account.

A typical reconciliation separates:

1. Sales and the related VAT.
2. Refunds, chargebacks and other adjustments.
3. Shopify Payments processing fees.
4. The net payout transferred to your bank.

The net payout should then match the amount credited to your bank, with any remaining balance in the clearing account explained by transactions still in settlement.

Don’t record the net bank payout as your sales figure. That can understate turnover and make it harder to verify the VAT due on your sales. Your bookkeeping should show what customers paid, the applicable VAT, deductions and the amount received separately.

To find payout details, open the payout information in Shopify and export the relevant transaction data. Shopify provides guidance on viewing and exporting Shopify Payments payout details and viewing payout fees. Keep the exports with your bookkeeping records so you can follow the trail from order to bank deposit.

Record Shopify Payments fees separately

Payment processing fees are business expenses. They reduce the cash paid out, but they do not reduce the value of the original customer sale.

Post fees to a dedicated payment-processing expense account and retain the relevant Shopify fee details. Check the fee information for the transactions and payout period you are reconciling. Rates and charges can depend on your payment setup and other factors, so use your actual Shopify records rather than relying on a standard estimate.

Also separate Shopify Payments from other payment providers. Where a customer pays through a third-party gateway, its settlement and charges may not appear in the same payout as Shopify Payments. Match each provider’s reports to its own bank deposits to avoid omissions or duplicate entries.

Check the VAT treatment of Shopify fees

The VAT on Shopify’s charges is separate from the VAT you account for on customer orders. Do not assume that every fee document is a UK VAT invoice with 20% VAT added.

Shopify’s guidance states that UK Shopify Payments processing fees are subject to a 0% rate described as a reverse charge. Check the tax details shown for your own fees and follow the treatment on the relevant Shopify record. Where the reverse charge applies, a UK VAT-registered business generally accounts for VAT on the received service under the reverse-charge rules. VAT recovery is subject to the usual eligibility and evidence requirements.

Keep the fee documentation with your records. A customer VAT invoice generated for one of your Shopify orders is not an invoice for Shopify’s payment-processing fees. Shopify explains its separate VAT invoice feature for customer orders in the UK and EU.

If the tax details are missing, unclear or inconsistent with your books, resolve that before filing. The correct treatment depends on the service and documentation, so don’t add input VAT to your return simply because a charge is described as a fee.

Treat multi-currency payouts consistently

If you sell in a foreign currency or receive a payout in a different currency from your bookkeeping records, retain both the original transaction details and the amount ultimately settled. Conversion rates, timing and any related charges can affect the sterling deposit.

For each currency:

• Reconcile transactions to payouts in that currency where possible.
• Record the exchange rate and sterling value used in your accounting records.
• Post conversion or payout charges separately when shown.
• Investigate differences between the converted balance and the bank receipt.

Consistent records make it easier to explain exchange differences and produce dependable reports. They also help when you’re comparing performance across Shopify and other sales channels, such as Amazon.

Keep your VAT records MTD-ready

If your company is VAT-registered, Making Tax Digital for VAT generally requires you to keep specified VAT records digitally and submit VAT Returns using compatible software, unless an exemption applies. HMRC also requires digital links when records are transferred between relevant software; manually copying information between systems may not meet the rules.

That makes a repeatable reconciliation process more than a bookkeeping convenience. It helps ensure sales, refunds, fees and VAT figures are properly recorded and flow into your return. Check HMRC’s guidance on keeping VAT records and software compatible with Making Tax Digital for VAT.

Complete this Shopify reconciliation checklist this week

Set aside time for one payout period and work through these steps:

1. Export the payout details and relevant sales or finance reports. Use matching date ranges where possible.
2. Match each payout to your bank statement. Note deposits that are pending or relate to another period.
3. Post gross sales and applicable VAT separately. Don’t use the bank deposit as a substitute for sales records.
4. Record refunds, chargebacks and adjustments. Match them to the related order or payout period.
5. Post Shopify Payments fees to the correct expense account. Keep the fee documentation with your records.
6. Review the clearing account balance. Investigate anything that cannot be explained by timing or pending settlement.
7. Reconcile other payment providers separately. Match each provider’s reports to its own bank deposits.

Once the process is working for one payout period, repeat it each month. A consistent routine keeps your records reliable, makes VAT figures easier to verify and reduces the chance of unexplained differences building up.