Shopify store owners often find that their sales reports show a different figure from the money that reaches their bank accounts. Payment processing fees, refunds, chargebacks and settlement delays can all explain the difference. Accurate Shopify bookkeeping UK helps online retailers track these transactions, record expenses correctly and prepare reliable VAT figures.
Online Accounting Services UK helps businesses organise their Shopify records, review payment settlements and maintain clear accounting records. This guide explains how to reconcile Shopify payouts, account for fees, handle VAT and connect Shopify with accounting software so you can manage your store’s finances with greater confidence.
Why Shopify Sales Do Not Match Your Bank Deposits
Shopify records customer orders and payment activity, while your bank statement shows the money you actually receive. These figures often differ because payment providers deduct charges or process refunds before transferring the remaining balance.
For example, a customer may pay £100 for an order, but Shopify Payments may deduct a processing fee before sending the balance to your bank. If you record only the deposit as sales income, your accounts will understate revenue and omit the payment fee.
Several factors can explain the difference:
- Processing fees: Payment providers deduct charges for handling card transactions.
- Refunds: Customer refunds reduce the amount available for settlement.
- Chargebacks: A bank may reverse a payment after a customer disputes a transaction.
- Settlement timing: A payment may appear in Shopify’s records before the provider transfers the money.
- Currency conversion: Exchange rates and conversion charges can change the amount you receive.
- Other adjustments: Reserve movements, payout corrections or disputes may affect the final settlement.
A reliable bookkeeping process records each transaction by purpose. Record sales, applicable VAT, refunds, and payment fees separately, then match the resulting balance to the bank deposit.
Which Shopify Reports Do You Need for Bookkeeping?
Before starting Shopify payout reconciliation, collect the records that explain how customer payments move from your store to your bank account. Each report serves a different purpose, so use them together rather than relying on a single sales summary.
- Orders and sales reports: Review order values, discounts, shipping charges, taxes and refunds to establish the sales figures for your accounts.
- Shopify Payments payout reports: Check individual payouts, processing fees, refunds and settlement adjustments.
- Transaction reports: Review captured payments, refunds and other payment movements.
- Bank statements: Match each deposit against the corresponding payout and investigate missing transfers.
- Fee invoices and receipts: Keep Shopify subscription invoices, app receipts and payment processing statements to support expense entries and VAT checks.
- Third-party payment reports: Download separate transaction and settlement records from PayPal, Stripe or any other gateway you use.
Open the relevant reports in your Shopify admin and select the period you want to reconcile. Keep the reporting dates consistent when comparing sales, payouts and bank transactions. This makes it easier to identify timing differences and missing entries.
How to Reconcile Shopify Payouts Step by Step
Reconciliation works best when you follow the full transaction trail, from customer payment to bank receipt. Use the following process for each settlement period.
Step 1: Match the Payout to Your Bank Statement
Find the payout in Shopify Payments and locate the corresponding deposit on your bank statement. Compare the amount, settlement date and payout reference. If the provider has initiated a transfer but the bank has not recorded it, keep the amount outstanding until the deposit appears.
Step 2: Calculate the Net Payout
Start with captured customer payments, then account for refunds, processing fees, chargebacks and other adjustments. Your calculation should explain the amount Shopify sends to your bank. If the figures do not match, inspect the transaction details rather than creating an unexplained adjustment.
Step 3: Record Sales, VAT and Fees Separately
Record the original sales value and applicable VAT according to the underlying transactions. Post payment processing charges to the appropriate expense account, and record refunds against the relevant sales and VAT entries. This approach keeps revenue separate from the cost of collecting payments.
Step 4: Use a Payment Clearing Account
A clearing account tracks payments that a provider has collected but has not yet transferred to your bank. When you record a customer payment, post the relevant amount to the clearing account. When Shopify sends the payout, reduce the clearing balance by recording the transfer to your bank account. Record the fees and other deductions separately.
Step 5: Investigate Unmatched Transactions
Review any remaining difference before closing the period. Check duplicate bank-feed entries, missing transactions, refunds that Shopify processed after the original payout, failed transfers and exchange rate differences. Keep a note of each unresolved item and follow it up when the missing information becomes available.
How to Record Shopify Fees Correctly
Shopify fees accounting requires you to separate payment processing charges from other costs associated with running your online store. This helps you measure operating expenses and check the supporting documents for each charge.
Common fee categories include:
- Payment processing fees: Charges for accepting card payments through Shopify Payments.
- Third-party transaction fees: Charges that may apply when you use an external payment provider, depending on your Shopify plan and payment setup.
- Subscription fees: Regular charges for your Shopify plan.
- App and software fees: Payments for apps, integrations and other store tools.
- Currency conversion charges: Costs associated with converting payments between currencies.
Record each expense in the appropriate account and keep its supporting invoice or statement. Do not combine every charge into one general expense category if you want to understand your store’s costs.
Check the supplier’s invoice before recording VAT on a fee. Some charges may include UK VAT, while overseas services may require different treatment, including the reverse charge in applicable cases. Your VAT registration status and the nature of the supply affect the accounting treatment.
How to Handle VAT on Shopify Sales in the UK
Shopify VAT UK rules require you to check the tax treatment of each sale and purchase rather than applying one rate to every transaction. Your obligations depend on the products you sell, customer location, fulfilment arrangements and VAT registration status.
Check Sales, Refunds and VAT on Fees
Identify the correct VAT treatment for each product or service. Many standard-rated goods sold domestically attract the standard UK VAT rate of 20%, but reduced rates, zero-rated supplies and exempt transactions may apply in specific cases.
Check how discounts, shipping charges and refunds affect the taxable value. Record VAT against the underlying sale rather than calculating it from the net bank payout. When you refund a customer, link the refund to the original order and apply the relevant VAT adjustment. Keep records of the original sale, refund amount and any credit note or other supporting document required for the transaction.
Review the VAT information on Shopify invoices and payment provider statements. Do not assume that every fee carries UK VAT or that you can reclaim VAT on every charge. Where the reverse charge applies to services purchased from overseas suppliers, your VAT return may require entries for both output VAT and input VAT, subject to the applicable rules and your right to recover input tax.
Prepare Your VAT Return From the Accounting Records
Compare the sales ledger, purchase records, VAT accounts and relevant Shopify reports before submitting your return. If Making Tax Digital rules apply to your business, use compatible software and maintain the required digital records.
For overseas customers, cross-border sales and goods imported into the UK, check the relevant place-of-supply, export, import and marketplace rules. Shopify’s tax settings can help calculate tax in supported situations, but you remain responsible for checking your obligations and reporting the correct figures.
How to Reconcile Stripe, PayPal and Multi-Currency Payments
Stores that accept payments through several providers must reconcile each settlement against the provider’s own transaction records. Stripe PayPal reconciliation follows the same basic accounting principle as Shopify Payments, but each provider has its own reports, fee structure and settlement schedule.
Match Each Provider’s Settlements Separately
Download transaction and payout reports from each provider. Match customer payments, refunds, processing charges and other adjustments to the relevant bank deposits. Record each provider’s activity through a separate clearing account or another suitable tracking method. This makes it easier to identify missing transfers and compare outstanding balances.
Handle Foreign Currency and Timing Differences
For foreign currency transactions, keep the original transaction currency and the amount your provider settles into your bank account. Check the exchange rate, conversion charges and any difference between the transaction date and settlement date. Your accounts should reflect the applicable accounting exchange rate and any resulting foreign exchange gain or loss.
A customer payment may fall in one accounting period while the provider transfers the money in the next. Record the sale in the correct period and leave the unsettled amount in the clearing account until the bank receives the payout. This approach helps you report revenue and cash movements in the right periods.
Should You Connect Shopify to Xero or Use Manual Bookkeeping?
A Shopify Xero integration can reduce manual data entry by transferring sales, payment and fee information into your accounting software. The result depends on the integration you choose, its settings and the way it handles refunds, taxes and payment settlements.
| Method | Best suited to | Main consideration |
| Spreadsheets | Small stores with few transactions | Requires regular manual checks |
| Xero or QuickBooks | Businesses that want bank feeds and organised ledgers | Requires correct account mapping |
| Ecommerce reconciliation apps | Stores with frequent orders and multiple payment providers | Subscription costs and setup require review |
| Professional bookkeeping | Stores with complex transactions or recurring errors | Adds an ongoing service cost |
For e-commerce accounting UK, the right method depends on transaction volume, payment channels and reporting requirements.
Before choosing an integration, check whether it records gross sales, discounts, refunds, VAT, payment fees and net payouts separately. Test a sample period against your Shopify reports and bank statement before relying on automated entries.
Good e-commerce bookkeeping still requires human review. An integration can transfer incorrect settings or duplicate entries if you do not check its output.
What to Check Before Closing Your Shopify Accounts Each Month
Use these month-end checks to keep your Shopify bookkeeping UK records aligned with your payment providers and bank:
- Match completed Shopify payouts to bank deposits.
- Review failed, pending and missing settlements.
- Check refunds, chargebacks and payment disputes.
- Confirm that subscription and processing fees have the correct categories.
- Review VAT codes and supporting invoices.
- Investigate unexplained balances in payment clearing accounts.
- Check foreign currency adjustments.
- Compare sales and expense totals with the accounting ledger.
- Save reports and transaction records for future reference.
Resolve material differences before you close the period or prepare your VAT return. If a transaction remains outstanding, document the reason and follow it up in the next accounting period.
When Should You Get Professional Shopify Bookkeeping Support?
You may benefit from professional support if your bank deposits regularly fail to match Shopify reports, you sell through several payment providers, or your VAT records contain unexplained differences.
A bookkeeper can review your transaction flow, correct posting errors, reconcile fees and prepare your records for routine reporting. This can help you spend less time investigating payment differences and more time managing orders, stock and customer service.
Conclusion
Accurate Shopify bookkeeping UK helps you track revenue, control expenses and report VAT correctly. Record sales separately from payment fees, reconcile every settlement and investigate differences before closing your accounts. Keep invoices, payout reports and bank statements together so you can explain each entry when needed.
Online Accounting Services UK can help you review Shopify transactions, organise accounting records and prepare your books for reporting. A consistent monthly process gives you a clearer picture of cash flow and helps you address accounting errors before they affect business decisions.
Need Help With Your Shopify Bookkeeping?
Managing Shopify sales, payment fees and VAT can take time, especially when payouts do not match your bank records. Online Accounting Services UK helps businesses reconcile transactions, organise financial records and prepare accurate accounts. Contact our team to discuss your Shopify bookkeeping requirements and find the right support for your business.
FAQs
Should I record Shopify payouts as sales income?
No. Record the underlying sales and applicable VAT, then account for fees, refunds and other adjustments. Treat the bank deposit as the settlement of those transactions.
Why is my Shopify payout lower than my sales total?
Payment processing fees, refunds, chargebacks, adjustments and settlement timing can explain the difference. Review the payout report to identify the exact amounts.
Can I reclaim VAT on Shopify fees?
You may recover eligible input VAT if your business meets the relevant requirements. Check the invoice, supplier details and applicable VAT rules before claiming it.
Do I need accounting software for Shopify VAT?
VAT-registered businesses subject to Making Tax Digital generally need compatible software to maintain digital records and submit returns. Check the rules that apply to your business.
How often should I reconcile Shopify payouts?
Reconcile payouts regularly and review the accounts at least monthly. Frequent checks help you identify missing deposits, duplicate entries and incorrect fees before they create a larger backlog.