If you run an operating store, you have seen this: your Shopify dashboard says you sold a certain amount this week, but the deposit in your bank is smaller, and the two never line up. That gap is not an error. It is the normal distance between a sale and settled cash, and payment reconciliation is the discipline of accounting for every dollar of it.
This guide walks the mechanics precisely — what settlement actually does to your money, why four different systems report four different "sales" numbers, and how to match a deposit back to the orders that produced it. For the broader picture of how all your store data lines up, start with our guide to reconciling your ecommerce data.
Reconciliation vs. settlement: not the same thing
These words get used interchangeably, and that is the first thing that trips people up.
Settlement is a cash event. Your payment processor captures the charges customers made, groups them into a batch, deducts its processing fees and any refunds or disputes, and deposits what's left. The deposit is the settlement. It is a fact — a number that landed in your account.
Reconciliation is an accounting process. You take that settlement deposit and work backward, matching it line by line against the orders and balance transactions that make it up, until you can explain every cent of the difference between "what I sold" and "what I got paid." Reconciliation is how you prove the settlement is correct.
Settlement happens whether or not you ever look at it. Reconciliation only happens if you do the work — and skipping it is how stores quietly lose money to unmatched refunds, double-charged fees, and deposits that never arrive.
Why your settlement never equals your sales
Say your store does 340 orders in a week at a $31 average order value. Your subtotal sales are 340 × $31 = $10,540. The deposit will not be $10,540. Here is everything that sits between the sale and the cash.
Processing fees come out first
Every captured charge loses a processing fee. On Shopify Payments, US online rates run about 2.9% + 30¢ per transaction on the Basic plan, stepping down to roughly 2.7% + 30¢, 2.5% + 30¢, and 2.25% + 30¢ on higher plans, with international cards adding about 1% and currency conversion another 1 to 1.5%, according to this Shopify payouts breakdown from Webgility. That per-transaction 30¢ is the part operators forget — at 340 orders it is $102 in flat fees alone, before the percentage.
Refunds reduce the deposit, not the sale count on every platform
When you refund an order, the money comes back out of your settlement. Shopify lowers your net and total sales to match. But refunds are also where reconciliation gets tricky: your ad platforms generally do not retroactively remove the original conversion, so their totals stay high while your bank deposit drops.
Chargebacks and disputes get debited mid-batch
A disputed charge pulls the order amount and a dispute fee out of your settlement — roughly $15 per dispute on US accounts, per the same Webgility breakdown. Those debits land in whatever payout batch clears them, not the week the original order happened, which is exactly why a settlement rarely maps cleanly to one day's sales.
Timing shifts the money across days
Settlement is not instant. Shopify Payments defaults to a daily payout schedule; funds reach a Shopify Balance account around the next business day and an external bank via ACH roughly two to three business days later, with weekend and holiday orders batching to the next business day, as Webgility documents. So Friday's sales may not settle until Tuesday, and that single fact desynchronizes any day-to-day comparison you try to run.
A worked settlement, start to finish
Take that same week — 340 orders, $31 subtotal AOV. Add a realistic $4 shipping and $3 tax, so each order totals $38 and the gross captured is 340 × $38 = $12,920. Now settle it (Basic-plan US rates, arithmetic shown):
- Captured charges: 340 × $38 = $12,920.00
- Processing fees: (2.9% × $12,920) + (340 × $0.30) = $374.68 + $102.00 = −$476.68
- Refunds issued this period: 11 orders × $38 = −$418.00
- Dispute fees: 2 × $15 = −$30.00
- Net settlement deposited: $11,995.32
So four different numbers describe one week:
- Subtotal sales (product only): $10,540
- Total sales captured (with shipping and tax): $12,920
- Total sales after refunds: ~$12,502
- Cash actually deposited: $11,995.32
None is wrong. Your Shopify order count and total sales are the truth about how much you sold. The settlement deposit is the truth about cash in the bank. Reconciliation is the bridge between them — and the fee rates above are volatile, so verify your own plan's rates at Shopify's pricing page before you build this math into a spreadsheet.
The reconciliation checklist: what to match against what
Reconciling a settlement means matching three layers until they agree:
- Orders → captured charges. Every successfully paid order should appear as a captured charge in the same currency and amount. A paid order with no matching charge is a tracking break.
- Captured charges − deductions → payout. The batch of balance transactions (charges, refunds, disputes, adjustments, reserves) should sum to the exact deposit. This is where fee math and dispute debits get verified.
- Payout → bank deposit. The number your processor says it sent should equal the number your bank received, on the date ACH cleared.
The single most common reconciliation error is assuming a payout equals one day's sales minus fees. It does not. A payout is a batch of balance transactions that cleared together — charges, refunds, and chargebacks from different days — settled as one deposit. Our deeper guide to payment reconciliation tools breaks down the matching logic in more detail.
The "gross minus expenses equals net" trap
In Shopify's finance reports, net sales equals gross sales minus discounts and returns — not minus fees. Fees live in the payout, never in the sales report, per Shopify's own finances-report documentation. If you try to reconcile by subtracting fees from net sales, the numbers will never tie out, and you will chase a discrepancy that was never there.
Where third-party gateways break reconciliation
Here is the gotcha that sinks most spreadsheets. Orders paid through a third-party gateway — PayPal, Shop Pay Installments routed outside Shopify Payments, Amazon Pay — never enter your Shopify Payments payout at all. They settle on their own schedule, with their own fees, into a separate deposit.
So if 18% of your orders run through PayPal, your Shopify Payments settlement will always be short of your total sales by roughly that share, and no amount of staring at the payout report will explain it. You have to reconcile each gateway against its own settlement. Any process that assumes one deposit covers all your orders is broken before it starts — and gateway fee details, like Stripe's invoice fees, differ enough that you cannot reuse one fee assumption across all of them.
Why reconciliation is really a profit question
Matching a deposit is not accounting hygiene for its own sake. The reason it matters is profit. Until you have reconciled settlement against orders, subtracted the real processing fees, and attributed each refund and dispute to the order that caused it, you do not know your true margin on anything.
A store can look profitable on gross sales and bleed money once fees, refunds, chargeback penalties, and ad spend are netted against real deposits. That is the number that actually decides which products to keep, which to reprice, and which ad sets to cut. When you are ready to automate the matching instead of rebuilding it each month, compare your options in our guide to payment reconciliation software.
How Victor keeps settlement and profit in one view
PodVector AI gives you Victor, an AI employee who does the reconciliation work your store needs instead of handing you another dashboard to read.
Victor sees every Shopify order, every ad dollar from Meta Ads and Google Ads, and every supplier cost from Printify, Printful, and Gelato together — so he computes the true per-order profit after fees and refunds, not just gross sales. Product costs from your print providers are known before the first sale, so Victor can tell you the real margin on each SKU from day one.
And Victor acts on what he finds. He reprices the thin-margin products inside Shopify, pauses the ad set that is losing money in Meta Ads, adjusts bids in Google Ads, builds the win-back flow in Klaviyo, and delivers the reconciled profit report to your Google Drive. For the matching logic specifically, see how AI matching handles payment reconciliation.
Start with PodVector AI and let Victor connect your store.
FAQs
What is the difference between payment reconciliation and settlement?
Settlement is the cash event — your processor batches captured charges, subtracts fees and refunds, and deposits the remainder. Reconciliation is the accounting process of matching that deposit back to the orders and balance transactions that make it up, so you can explain every dollar of the gap between what you sold and what you were paid.
Why is my Shopify payout less than my sales?
Because processing fees, refunds, and dispute debits all come out of the deposit, and the timing of the batch rarely lines up with one day's orders. On Basic-plan US rates, fees alone run about 2.9% + 30¢ per transaction, per Webgility. Third-party gateway orders like PayPal never enter the Shopify Payments payout at all, which widens the gap further.
How often should I reconcile payments?
Reconcile on the same cadence your settlements arrive — daily if you are on a daily payout schedule. Daily or near-real-time matching lets you catch a missing deposit, a double-charged fee, or an unexplained dispute within a day instead of discovering it weeks later during a monthly close.
Can I reconcile payouts by matching them to a single day's sales?
No. A payout is a batch of balance transactions — charges, refunds, chargebacks, and adjustments from whatever cleared — not one day's orders minus fees. Match the deposit against the full set of balance transactions in that batch, and reconcile each payment gateway separately.
Does reconciliation tell me my profit?
It is the foundation of it. Once you have reconciled settlement against orders and subtracted real fees, refunds, and disputes, you can layer in ad spend and supplier costs to reach true per-order profit. That reconciled number — not gross sales — is what tells you which products and campaigns actually make money.