Shopify bookkeeping gets confusing when your store reports £20,000 of sales but the amount that reaches the bank is noticeably lower. The missing-looking money may be perfectly explainable: payment-processing fees, refunds, chargebacks, reserves, currency conversion, timing differences and transactions handled by other payment providers can all sit between an order and the final payout.
The important question is not simply, “What did Shopify pay me?” It is, “Can I connect the sales activity, payment activity and deductions to the amount that reached the bank?” Good Shopify bookkeeping should make that trail visible every month rather than treating the bank deposit as the sales figure.
Why Shopify bookkeeping should not start with the bank payout
A payout is the end of a payment process, not a complete sales record. Shopify’s own payout reconciliation report guidance says the report can include transactions, fees, refunds, chargebacks, adjustments and payouts. It also states that the report is not a statement of revenue for accounting purposes.
That distinction matters for Shopify bookkeeping. If the business records a £17,400 bank deposit as £17,400 of sales when the store actually generated £20,000 of relevant sales activity, both revenue and the deductions between the two figures can become hidden.
Your broader eCommerce bookkeeping may also need to deal with stock, advertising, VAT, marketplaces and overseas transactions. This article focuses on one narrower control: reconciling Shopify sales and payment activity to the money that eventually reaches the bank.
Shopify bookkeeping has three different numbers to understand
For many online stores, three figures can be confused with one another: the sales shown in Shopify reports, the activity passing through Shopify Payments or another processor, and the payout appearing in the bank.
They do not necessarily cover the same transactions or the same dates. Shopify explains that its Finance reports are based on orders and sales activity, while the payout reconciliation report reflects Shopify Payments balance activity and payouts. Payout timing can therefore create differences even when the underlying records are correct.
A reliable Shopify bookkeeping process keeps those layers separate. Sales tell you what the store sold. Payment reports explain how customer money moved through a processor. Bank deposits show when net funds finally became cash in the business bank account.
A £20,000 sales month can produce a much smaller payout
Consider a hypothetical store showing £20,000 of sales activity for a period. That does not mean £20,000 must arrive in the bank during the same period.
Some transactions may not yet have reached their payout date. Refunds can reduce available funds. Payment fees can be deducted. A dispute or chargeback may affect the balance. Some money may be held temporarily. Orders paid through PayPal or another third-party method may never enter the Shopify Payments payout at all.
Good Shopify bookkeeping does not force the £20,000 sales figure to equal one bank deposit. It identifies which parts belong to Shopify Payments, which belong to other processors, what was deducted and what remains in transit or held at the reporting date.
Shopify Payments has its own balance activity
Shopify Payments is not simply a route that sends each customer payment directly to the bank. It has balance activity that can change before a payout is made.
Shopify’s payout reconciliation report separates starting balance, activity, fees, payouts and ending balance. It can also show categories such as refunds, disputes, adjustments, reserves and holds where they apply.
For Shopify bookkeeping, that makes the processor balance an important control account. Sales and other payment activity move through it, deductions reduce it, payouts move money out to the bank, and any remaining balance needs an explanation at month end.
Processing fees should not disappear inside lower sales
If Shopify Payments deducts processing fees before sending a payout, the fees may never appear as a separate payment in the bank account. That makes them easy to miss if the bookkeeping is built only from bank transactions.
A proper Shopify bookkeeping entry should preserve the relevant gross activity and record the processing cost separately where appropriate. The net payout can then be matched to the bank without pretending the fee never existed.
This gives the owner better management information too. If payment-processing costs rise, the business can see that change rather than experiencing it only as a vague reduction in cash receipts.
Refunds can affect Shopify bookkeeping in a later payout
A customer sale and the related refund may not affect the same payout. Shopify states that refunds can be deducted from available Shopify Payments funds, and its guidance explains that the original credit-card processing fee is not returned when a refund is issued through Shopify Payments.
That means Shopify bookkeeping should not assume that a lower payout is simply lower sales. Part of the reduction may relate to refunds from earlier orders or fees that remain after a refund.
The records should preserve the original sale, the refund and any related fee effect rather than replacing the original transaction with a single lower net figure.
Chargebacks and disputes need their own trail
A chargeback is different from an ordinary customer refund. The payment provider may remove disputed funds, apply related fees or later reverse some of the effect depending on the outcome.
Shopify includes dispute activity within the types of balance movement that can appear in its payout reconciliation report. During Shopify bookkeeping, those movements should remain distinguishable from routine sales and refunds.
If a dispute is simply buried inside the net payout, the owner may never see how much revenue was challenged or what additional costs arose from the dispute process.
Reserves and holds can explain money that has not reached the bank
Shopify’s payout reconciliation report can include reserves and holds. These amounts remain within the Shopify Payments balance until they are released or otherwise dealt with, rather than appearing immediately in the bank.
For Shopify bookkeeping, a held balance should not be written off as a fee simply because the money is missing from the payout. It may still represent funds held on the business’s behalf.
The month-end reconciliation should therefore explain both the bank payout and any remaining processor balance. If cash has not reached the bank yet, the records should show where it is rather than forcing the processor account to zero.
Timing differences are normal, but they still need reconciling
Shopify says settlement timing can vary and that transactions captured on different days may be grouped into payouts according to the applicable schedule. Bank processing can add further delay after Shopify sends a payout.
This is why Shopify bookkeeping should not compare one calendar month of store sales with one calendar month of bank deposits and expect an exact match automatically.
The stronger approach is to reconcile the processor balance itself. If the opening balance, activity, deductions, payouts and closing balance agree, timing differences stop being mysterious. They become identifiable amounts that move into a later payout.
Third-party payment methods need separate Shopify bookkeeping controls
One of the easiest mistakes is to assume that Shopify Payments reports contain every payment made through a Shopify store. Shopify explicitly says its payout reconciliation report does not include third-party payment processors or certain third-party payment methods.
If customers can pay through PayPal, Stripe in another setup, a buy-now-pay-later provider or another gateway, Shopify bookkeeping may need a separate control account and reconciliation for each material processor.
Otherwise, sales can appear in the store while the related cash arrives through a completely different route. Trying to make the Shopify Payments payout explain those transactions will create a difference that never resolves.
PayPal should be reconciled as its own financial account
PayPal provides a Balance Reconciliation report designed to help merchants reconcile payment activity, including payments, disputes and fee-incurring events.
Where PayPal is used alongside Shopify, Shopify bookkeeping should therefore treat PayPal as a separate payment account rather than assuming PayPal receipts are included in the Shopify Payments settlement.
The process is similar to a bank reconciliation: opening balance plus activity should explain transfers, fees and the closing balance. Transfers from PayPal to the business bank can then be matched without recording the same customer sale again.
Stripe activity may also need a separate reconciliation
Stripe’s official reporting documentation describes balance transactions as a ledger-style record covering activity such as charges, refunds, payouts, fees and adjustments.
If Stripe is used separately from Shopify Payments, Shopify bookkeeping should follow that processor activity through its own control account. A bank payout from Stripe is not automatically a new sale, just as a transfer from PayPal to the bank is not a new sale.
The sale should be recorded once from the appropriate sales source. The processor accounts then explain how the customer money moved from sale to available balance and finally to the bank.
Do not double-count sales when money moves between systems
This is a common risk when several systems are connected. The Shopify order creates sales income. A payment processor records the customer payment. The bank feed then imports the eventual payout.
If each stage is posted as income, the same commercial sale can be counted more than once. Good Shopify bookkeeping uses clearing or control accounts so the later movements settle an existing balance rather than creating fresh revenue. This is one of the wider problems covered in our guide to common bookkeeping mistakes.
A practical test is to ask what each transaction represents. If it is a transfer of money already recorded elsewhere, it should not normally be treated as a second sale merely because it has reached a different account.
Shopify bookkeeping should reconcile the processor before the bank
The order of the checks matters. Starting from the bank and trying to reverse-engineer everything from net deposits can make the bookkeeping harder than it needs to be.
A cleaner Shopify bookkeeping sequence is to establish sales activity, reconcile Shopify Payments and any other processors, and only then match the resulting payouts to the bank.
Our guide to bank reconciliation explains the wider principle of comparing accounting balances with independent external evidence. Payment processors deserve the same discipline because they can hold balances and combine many transactions into one transfer.
VAT records should be based on the underlying transactions
For VAT-registered businesses, the fact that a payment processor sends a net payout does not remove the need for records supporting the underlying VAT position. HMRC’s VAT record-keeping guidance sets out the digital and accounting records that VAT-registered businesses must maintain.
Good Shopify bookkeeping should therefore keep the sales, refunds, purchase evidence and relevant processor reports connected. The exact VAT treatment can depend on the transaction, customer location, goods, services and other facts.
Where the VAT treatment is uncertain, the bookkeeping should identify the transaction and preserve the evidence rather than guessing. Specialist VAT questions should be referred to an appropriately qualified adviser.
Multi-currency payouts create another reconciliation layer
A Shopify store may sell in one currency and receive payouts in another. Shopify says its payout reconciliation report can be viewed by payout currency, and currency conversion can affect the movement from customer payment to bank receipt.
For Shopify bookkeeping, foreign-currency differences should not simply disappear inside sales or processing fees. The records should show the relevant sales, processor activity and conversion effect in a way that agrees with the accounting software and bank.
Where several payout currencies are used, each currency balance may need to be reconciled separately before the final sterling or other home-currency bank receipt is considered complete.
Shopify bookkeeping should preserve an audit trail
A good reconciliation is not only a number that balances. Somebody should be able to revisit the month later and understand where the figures came from.
Useful Shopify bookkeeping evidence can include Shopify sales or finance reports, the Shopify Payments payout reconciliation report, individual payout detail where needed, third-party processor reports, refund information, fee evidence and bank statements.
For UK limited companies, GOV.UK requires accounting records covering money received and spent and relevant supporting financial records. Sole traders likewise need records of business sales, income and expenses. The bookkeeping trail should make those figures supportable.
7 essential Shopify bookkeeping checks before closing the month
- Confirm the sales period. Run the relevant Shopify sales or finance reports using a consistent month-end cut-off.
- Reconcile Shopify Payments. Check opening balance, payment activity, refunds, fees, disputes, adjustments, payouts and closing balance.
- Reconcile every other payment processor. PayPal, Stripe or another gateway should have its own explainable activity and closing balance.
- Match payouts to the bank. Once each processor agrees, match its transfers to the actual deposits received.
- Review refunds, chargebacks and holds. Keep these visible instead of burying them inside a lower net payout.
- Check VAT and currency treatment. Make sure the supporting records are present and refer uncertain technical treatment where needed.
- Review remaining control-account balances. Every material balance left at month end should have an explanation, such as timing, a reserve, a pending payout or an unresolved query.
These seven checks turn Shopify bookkeeping from a process of coding bank deposits into a genuine reconciliation of the store’s financial activity.
Common Shopify bookkeeping errors that lower the quality of the accounts
- Posting net payouts as sales. This can hide both gross activity and processor deductions.
- Ignoring processor balances. Money still held by Shopify Payments, PayPal or Stripe disappears from view.
- Posting bank transfers as new income. Sales can be counted twice when a processor payout is treated as fresh revenue.
- Mixing payment providers together. One control account is expected to explain transactions handled by several different systems.
- Forgetting refunds and disputes. Lower payouts are accepted without identifying why the balance changed.
- Forcing control accounts to zero. Valid timing differences or held funds are written off as expenses rather than investigated.
- Waiting until year end. Old processor differences become much harder to explain once the underlying orders and refunds are no longer recent.
A strong Shopify bookkeeping process avoids these errors by reconciling the payment journey rather than simply categorising whatever lands in the bank feed.
Why a reconciled Shopify file gives better management information
Once gross sales, refunds, payment fees and processor balances are separated, the owner can see more than whether the bank balance increased.
Good Shopify bookkeeping can make payment-processing costs visible, show the financial effect of refunds and disputes, identify cash still held by processors and support a clearer view of channel performance.
That also strengthens wider monthly reporting. Our guide to good bookkeeping habits explains why payment platforms should be reconciled separately rather than treating each bank settlement as total sales.
When Shopify bookkeeping becomes difficult to maintain in-house
A small store using only Shopify Payments with modest transaction volume may be straightforward to reconcile. The workload grows when the business adds PayPal, other gateways, several currencies, frequent refunds, chargebacks, stock, VAT and multiple sales channels.
The warning sign is not simply the number of orders. It is when Shopify bookkeeping can no longer explain the relationship between store sales, processor balances and the bank without a large manual reconstruction.
Regular bookkeeping services can keep the payment reports, reconciliations and supporting records current. Where the whole recurring process needs to be handed over, outsourced bookkeeping can provide a regular monthly workflow while the business’s accountant or tax adviser handles work outside the bookkeeping scope.
Shopify bookkeeping should answer one simple question
A successful month does not have to produce one bank payout that matches the Shopify sales screen. The systems are measuring different stages of the same financial journey.
The test for reliable Shopify bookkeeping is whether you can start with the store activity, follow the money through Shopify Payments and any third-party processors, explain the fees, refunds, disputes and timing differences, and finish at the amount that reached the bank.
If the store says £20,000 of sales but you cannot explain why a much smaller amount reached the bank, you can contact Bookkeeping Packages Ltd to discuss the current records and the bookkeeping work required to reconcile them.
About the Author
Stuart Kerr is Managing Director of Bookkeeping Packages Ltd, an outsourced bookkeeping service supporting UK small businesses and accountancy practices. With over 20 years of bookkeeping experience, Stuart specialises in helping businesses maintain reliable financial records and useful management information.
This article is provided for general information only. Stuart Kerr is a professional bookkeeper, not a regulated financial adviser. Nothing in this article constitutes tax, legal or financial advice. Advice specific to your circumstances should be obtained from an appropriately qualified professional.