Direct answer: Reconcile each Shopify payout as a settlement batch: match its gross charges, refunds, fees, disputes, reserves, and adjustments to a clearing account, then match the payout ID and bank reference to the single net bank deposit.
Why does a Shopify payout not equal sales?
An order report, a payments report, and a bank statement describe different events. An order can be created in one period, captured in another, refunded later, and included in a payout after that. Shopify explicitly says its payout reconciliation report reflects balance activity and payout timing rather than revenue for accounting purposes. Treating the deposit as sales therefore compresses several events into one number and can misstate revenue, fees, taxes, refunds, and receivables.
Use two dates. The economic date determines when the sale, refund, or fee belongs in the ledger under your accounting policy. The settlement date determines when the processor liability becomes cash. Reconciliation connects the dates; it should not erase their difference.
What is the three-ledger reconciliation map?
| Layer | Source and key | What it proves | Control total |
|---|---|---|---|
| Commerce | Orders, returns, taxes; order ID | What customers bought and what the business owes or earned | Captured charges and valid refunds by currency |
| Processor | Payout reconciliation/export; transaction ID, payout ID | How money moved through Shopify Payments | Charges − refunds − fees − disputes ± reserves/adjustments = payout |
| Bank | Bank statement; bank reference, amount, value date | What cash actually settled | One posted deposit or debit per payout reference |
This map is the first original control: match commerce to processor by transaction identity, and processor to bank by payout identity. Do not join all three layers only on date and amount. Shopify's January 2026 export update added Bank Reference to payout exports and Payout ID to order transaction exports, providing stronger join keys than a fuzzy date match.
Create one clearing account per processor and settlement currency. Debit Shopify Payments clearing when a captured payment is recognized; credit it for refunds, processor fees, disputes, and the net payout transferred to bank. Separate PayPal, Klarna, Amazon Pay, or a second settlement currency because they have different statements and payout timing.
How do I build the payout control total?
For each payout ID, compute this bridge in payout currency:
Expected payout = captured charges − refunds − processing fees − disputes/chargebacks − reserve holds + reserve releases ± other documented adjustments.
Use the processor export's signed amounts rather than reconstructing fees from a public price schedule. Plans, card types, cross-border transactions, Shop Pay Installments, and currency conversion can produce different fee components. Shopify also states that the original credit-card processing fee is not returned when a Shopify Payments transaction is refunded; recording a refund as a reversal of the entire original journal can therefore overstate the clearing balance.
Which difference should I investigate first?
The second original control is a deterministic variance tree. Start with the smallest branch that can explain the difference:
- Identity: Does the payout ID map to the bank reference? If no, check an omitted payout, split bank posting, manual debit, or wrong bank account.
- Currency: Are report, payout, and bank amounts in the same currency? If no, separate processor conversion from bank conversion and book the supported FX difference.
- Status: Is the payout paid, pending, failed, canceled, or reversed? A pending payout is not missing cash.
- Completeness: Do all balance transactions for the payout appear once? Look for export cutoffs, pagination, duplicate imports, and refunds booked in two systems.
- Classification: Does the remaining amount equal a fee, dispute, reserve, tax, loan repayment, or adjustment? Reclassify with source evidence.
- Timing: Does it equal activity after the ledger cutoff or a payout in transit? Keep a reconciling item with an expected clear date rather than forcing it to zero.
A useful materiality rule has two dimensions: amount and age. A small unmatched balance that persists for 60 days can indicate a broken integration; a large one-day balance may simply be the latest payout in transit.
What does a complete hypothetical reconciliation look like?
Hypothetical example—assumptions. A USD store has one payout batch. The export shows $12,480.00 of captured charges, $820.00 of refunds, $366.40 of processing fees, a $150.00 dispute, a $300.00 reserve hold, and a positive $25.00 adjustment. Assume all entries are valid, the bank has no separate conversion fee, and the reserve is not yet released.
| Component | Signed amount | Accounting treatment |
|---|---|---|
| Captured charges | +$12,480.00 | Debit clearing; credit the appropriate sales/tax/receivable accounts under policy |
| Refunds | −$820.00 | Credit clearing; debit returns/refund liability as supported |
| Processing fees | −$366.40 | Credit clearing; debit merchant fees |
| Dispute | −$150.00 | Credit clearing; debit dispute receivable or loss based on recoverability |
| Reserve hold | −$300.00 | Credit clearing; debit processor reserve receivable |
| Adjustment | +$25.00 | Debit clearing; classify only after reading its source description |
| Expected bank deposit | $10,868.60 | Debit bank; credit clearing |
Calculation: $12,480 − $820 − $366.40 − $150 − $300 + $25 = $10,868.60. If the bank reference and deposit equal $10,868.60, the payout-to-bank leg is complete. The $300 reserve remains on the balance sheet until a later release or documented charge.
Interpretation and limits. This example proves arithmetic, not revenue recognition or tax treatment. Gift cards, marketplace-facilitator taxes, multiple gateways, foreign exchange, and chargeback recoveries may require separate accounts and advice appropriate to the entity's reporting framework.
What steps produce an audit-ready month-end close?
- Lock the reporting cutoff and list every processor and payout currency.
- Export orders/payments, Shopify payout reconciliation, payout status, and bank transactions without truncating rows.
- Preserve transaction ID, payout ID, bank reference, currency, type, gross, fee, net, status, and timestamps in a controlled workpaper.
- Recalculate every payout control total and compare it to the bank by reference and amount.
- Post or review the clearing-account journals without netting fees or refunds into revenue.
- Run the variance tree on every exception; attach the underlying export line or bank evidence.
- Roll forward valid in-transit payouts and reserves with expected clear dates.
- Have a reviewer sign off totals, exceptions, and journal references.
How do I know the reconciliation is finished?
- All payout IDs are unique and complete.
- Every paid payout maps to a bank reference or documented in-transit item.
- Charges, refunds, fees, disputes, reserves, and adjustments sum to payout totals.
- No transaction is imported twice across apps and manual journals.
- Each currency has its own control total.
- The clearing balance equals named open items, not an unexplained plug.
- Old items have owners and resolution dates.
- Reports, journals, and review evidence are retained for the required period.
When does this method need modification or professional review?
Do not apply a single simple journal when the store has multiple legal entities, marketplace-facilitator tax, gift-card liabilities, buy-now-pay-later providers, processor loans, material FX, or a reporting framework that requires order-level revenue treatment. Escalate unexplained bank debits, repeated negative balances, suspected duplicate settlements, and aged disputes. The method reconciles cash movement; it does not decide legal revenue, indirect-tax, or escheatment obligations.
Caigeek can help when the useful input is transaction-level Shopify exports plus bank and ledger data. The work should produce a payout control, exception register, clearing-account roll-forward, proposed journals, and reviewer evidence—not merely a software connection or an unexplained month-end adjustment.
Frequently asked questions
Should I record a Shopify payout as sales?
No. A payout is net cash settlement and can contain charges, refunds, fees, disputes, reserves, and timing from different dates. Record the supported underlying activity and use the payout to clear the processor balance.
Why is my Shopify clearing account not zero at month-end?
A balance can be valid if it equals identified payouts in transit, reserve receivables, pending refunds, or disputes. It is a problem when the amount has no transaction identity, owner, or expected clear date.
Which Shopify report should I use for bank reconciliation?
Use the payout reconciliation report or payout export for the Shopify Payments-to-bank leg, because it describes balance activity and payouts. Use finance and order reports for revenue and commerce analysis, not as substitutes for settlement evidence.
How should a refund be handled if the original fee is not returned?
Post the refund and the retained processing fee as separate supported components. Shopify says the original credit-card processing fee is not reimbursed for a Shopify Payments refund, so reversing the entire original entry can create a variance.
Can I combine PayPal and Shopify Payments in one clearing account?
It is safer to use separate clearing accounts by processor and currency. Combining providers makes payout identity, timing, fees, and unresolved balances harder to prove.
Sources and last checked
- Shopify, Better way to match Shopify Payments payouts with bank deposits — last checked August 10, 2026.
- Shopify Help Center, Finance reports — last checked August 10, 2026.
- Shopify Help Center, Shopify Payments refunds — last checked August 10, 2026.
- Shopify Help Center, Getting paid — last checked August 10, 2026.
This article is operational accounting guidance, not tax, legal, or audit advice. Verify current Shopify features and the accounting policy that applies to your entity.