Ask a founder what they sold last month and they will read a number off the Shopify dashboard. Ask what actually landed in the bank and there is a pause. The two numbers are never the same, and most stores have never truly closed the gap between them.
That gap is not an accounting curiosity. It is real money. Processing fees, refunds, chargebacks, currency conversion, held reserves and timing all sit between the sale and the deposit. Left unreconciled, small errors compound silently, and a store can lose a percent or two of revenue it never notices was gone.
01 · The gap
Sales are not deposits.
Shopify reports what customers agreed to pay. Your bank reports what the payment processor actually sent. Between those two figures sit a dozen deductions and delays, and a payout almost never maps cleanly to a single day's orders. One deposit might bundle parts of three days, minus refunds from a fourth, minus a fee on every transaction.
Because the dashboard looks authoritative, most teams assume it reconciles itself. It does not. Nobody at Shopify is checking that every order you fulfilled turned into money in your account. That job is yours, and skipping it is how leaks survive for years.
02 · Anatomy
What a payout is actually made of.
A single payout is a net figure hiding many moving parts. To reconcile it, you have to be able to decompose it back into its components.
- Gross sales: what customers were charged.
- Processing fees: a percentage plus a fixed amount per transaction.
- Refunds and returns: often from earlier orders, netted out of a later payout.
- Chargebacks and disputes: reversals, plus dispute fees.
- Currency conversion: spreads on cross-border sales.
- Reserves and holds: amounts withheld and released on a delay.
Until you can rebuild the deposit from these parts, you are trusting a black box with your revenue.
03 · Leaks
Where the money quietly leaks.
Reconciliation matters because the gaps are rarely random. They cluster in predictable, correctable places.
A leak you cannot see is a leak you cannot fix. Reconciliation is the flashlight.
Refunds issued but never deducted correctly. Fees charged at a higher rate than your agreement states. Chargebacks lost by default because nobody responded in time. Multi-currency orders converted at a worse spread than expected. Duplicate charges from a checkout app glitch. Each one is small. Across a year of volume, they add up to a number worth an afternoon of attention.
The pattern is almost always the same: the errors are individually trivial and collectively meaningful. A tenth of a percent on fees, a handful of undisputed chargebacks, a few refunds netted to the wrong period. No single line would ever trip an alarm, which is exactly why they survive. Reconciliation is not about catching one dramatic mistake. It is about catching the steady drip of small ones before a year of them becomes a number that matters.
04 · Match
Match line by line; do not trust the total.
The only reliable reconciliation is at the transaction level. Netting one grand total against another hides exactly the errors you are hunting for, because offsetting mistakes cancel out and look correct.
Instead, match each order to its fee, its refund, its payout and its bank deposit. When a line does not tie out, you have found something specific: a mispriced fee, a missing refund, an unaccounted dispute. This is tedious by hand, which is precisely why most stores never do it, and precisely why the leaks persist.
05 · Ledger
Automate it with a real ledger.
This is exactly the problem we built Payout Ledger to solve. It pulls your Shopify transactions, the processor's payout records and your fee schedule, then matches them line by line automatically. Every order ties to its fee, refund and deposit, and anything that does not reconcile is flagged for review.
Instead of an afternoon of spreadsheet archaeology, you get a clean statement: here is what you sold, here is what you were charged, here is what should have hit your account, and here is every line that did not. Discrepancies surface in days instead of never, while there is still time to dispute a chargeback or query a mistaken fee.
06 · Cadence
Make it a monthly habit.
Reconciliation is not a one-time cleanup. It is a rhythm. Fees drift, new apps introduce new charges, dispute rates move, and a new market adds currency complexity. A store that reconciles once and forgets slides straight back into the fog.
Close the books on payouts every month, the same way you would any other financial control. It protects margin, it catches processor errors while they are still recoverable, and it gives you an honest revenue number to actually run the business on.
Quick check
Do your payouts actually tie out?
- You can rebuild each deposit from its fees, refunds and reserves.
- Every order matches a fee, a payout and a bank deposit.
- Processing fees match your actual rate agreement.
- Refunds and chargebacks are deducted where they belong.
- Discrepancies are flagged while disputes are still winnable.
- You reconcile on a fixed monthly cadence.
Know the number that is real.
Growth built on a revenue figure you cannot trust is growth built on a guess. Reconciling payouts is unglamorous, but it hands you the one number that actually matters, the money you truly kept, and defends the margin you already earned. That is leverage hiding in plain sight.