Credit card payment reconciliation is matching the card money that lands in your bank against the orders your store actually booked. For an operating store the deposit is always smaller than the sales figure, because processing fees, refunds, chargebacks, and payout timing sit in between. Reconcile against your payout's balance transactions, never against the sales report, and you will catch missing deposits and quietly eroded margins before they compound.

Most articles on this phrase are written for a finance team reconciling employee expense cards. That is the wrong problem if you run a store. You care about the other direction: the customer card payments coming in, and why the bank deposit never equals the number your sales report shows.

This guide covers the merchant side, with real payout math. If you want the broader picture of why every tool reports a different number, start with the hub on reconciling your ecommerce data.

The two kinds of credit card reconciliation

The term splits into two jobs that share a name but almost nothing else.

Statement-side reconciliation is the classic bookkeeping task: you match your business credit card statement against your own records of what you spent. This is the expense-card version the generic guides obsess over, and it matters for your supplier bills and ad spend. But it is about money going out.

Merchant-side reconciliation is the one that pays your rent. You match the deposits from your payment processor against the orders customers placed. This is where a store owner loses money silently, and it is where the top-ranking guides go quiet.

The rest of this article is about the merchant side.

Why your payout never equals your sales

Here is the single most expensive misconception in store bookkeeping: payout equals that day's sales minus fees. It does not.

A payout is a batch of balance transactions settled together, not a day's orders. Captured charges, refunds issued, chargeback debits, and reserve adjustments all clear on their own clock and get bundled into one deposit. So a Tuesday deposit can contain Monday's charges and last week's refunds.

A clean way to think about what a Shopify Payments payout actually is:

Payout deposited = captured charges − processing fees − refunds issued − chargebacks and dispute fees ± reserve adjustments.

Four things pry the deposit apart from your sales number. Walk each one.

Processing fees

Every card charge is skimmed before it reaches you. On Shopify Payments for US online orders, rates run about 2.9% + 30¢ on Basic, 2.7% + 30¢ on Grow, 2.5% + 30¢ on Advanced, and 2.25% + 30¢ on Plus, with roughly another 1% on international cards, according to ReportPundit's payout breakdown and Webgility's Shopify payouts guide. Plan names and rates drift, so confirm yours on Shopify's pricing page before you build it into a spreadsheet.

The flat 30¢ per order is the part that stings a POD store with a low average order value. On a $12 sticker, thirty cents is a bigger bite than the percentage. If you sell low-AOV items, these fees are closer to card economics for payments than the headline percentage suggests — the sibling breakdown of Stripe pricing and fees walks the same per-transaction math for another processor.

Refunds

When you refund an order, Shopify reduces your net and total sales, and the refunded amount comes straight out of a later payout. Your sales report drops; your deposit drops a few days later. If you are matching deposit to sales on the same calendar day, refunds will make every day look broken.

Chargebacks and disputes

A disputed charge pulls the order amount back and adds a flat dispute fee — roughly $15 per chargeback in the US, per Webgility. That is a double hit: you lose the sale and pay a penalty, both deducted from your payout, often weeks after the original order.

Timing and third-party gateways

Payouts default to daily, hitting Shopify Balance around the next business day and an external bank via ACH two to three business days later, with weekend orders batched to the next business day, again per Webgility. Orders paid through PayPal or another third-party gateway never enter the Shopify Payments payout at all — they settle in their own account and must be reconciled separately.

The sales-definition trap

Before you reconcile anything, know which "sales" number you are holding. Shopify reports three, and they are not interchangeable.

Gross sales is price times quantity before any deduction. Net sales is gross minus discounts and returns — not minus fees. Total sales is net plus shipping and taxes, minus returns, as defined in Shopify's Finances report docs.

The trap that catches nearly every first-time reconciler: gross minus expenses does not equal net. Fees are a payout deduction, not a sales-report line. If you try to tie them together, the numbers will never close.

Worked example: one week, one store

Say your store books 120 orders in a week. Each order averages $38 in product, $6 shipping, and $4 tax, so you collect $48 per order. Nine orders get refunded, and one turns into a chargeback.

Captured charges: 120 × $48 = $5,760.

Processing fees at Basic rates: 2.9% of $5,760 = $167.04, plus 30¢ × 120 = $36.00, totaling $203.04.

Refunds issued: 9 × $48 = $432.00.

One chargeback: $48 order debited + $15 dispute fee = $63.00.

Net payout deposited: $5,760.00 − $203.04 − $432.00 − $63.00 = $5,061.96.

Now look at Shopify's total sales for the same week. Gross is $5,760; after the nine refunds it reports about $5,328 in total sales. So for one week of real orders you are staring at three different numbers: $5,760 captured, $5,328 in reported sales, and $5,061.96 in the bank. None is wrong. The order count and total sales tell you what sold; the payout tells you what cash arrived. Reconcile the deposit against the balance transactions that built it — never against the sales report.

A reconciliation routine that actually closes

You do not need enterprise software to do this well. You need a repeatable weekly pass.

  1. Pull the payout report for the period and list every balance transaction: charges, refunds, chargebacks, adjustments.
  2. Pull the orders for the same trailing window — use seven or fourteen days, never a single day, so timing differences wash out.
  3. Match captured charges to orders, then subtract refunds and disputes that cleared in this payout.
  4. Flag anything that does not match: a missing deposit, a double refund, an unexplained adjustment, or a reserve hold.
  5. Reconcile third-party gateway orders (PayPal and friends) in their own pass, since they never touch the Shopify payout.

Do this weekly and discrepancies stay small and findable. Skip it for a quarter and you are untangling months of batched refunds at tax time. When manual matching stops scaling, the down-funnel guide to payment reconciliation software covers what to automate first.

From reconciled cash to real profit

Reconciling the payout tells you the cash is correct. It does not tell you which products are actually making money — and that is the number that decides where you spend next.

This is the job Victor does. Victor is the AI employee inside PodVector AI who computes the true per-order profit on every order you ship. He sees every order from Shopify, every ad dollar from Meta and Google Ads, and every supplier cost from Printify, Printful, and Gelato together, so he can tell you what each product really earns after the costs that reconciliation surfaces.

Because those supplier costs are known before the first sale, Victor does not wait for history to tell you a SKU is thin. He reprices the thin-margin products in Shopify, pauses the ad sets that are selling at a loss, and delivers a clean profit report to your Google Drive. Victor is not a dashboard you read — he does the work and leaves you a reconciled, profit-true picture of the store.

Put Victor on your store's true profit and stop guessing which orders actually paid.

FAQs

Why is my Shopify payout less than my sales?

Because the payout is cash after deductions, and the sales report is the top-line before them. Processing fees, refunds, chargebacks, and reserve holds all come out of the deposit, and third-party gateway orders never enter it. A payout that is a few percent under total sales is normal; a payout that is wildly off points to a missing deposit, a reserve, or a dispute you have not logged.

How often should I reconcile credit card payments?

Weekly is the sweet spot for an operating store. Reconcile on a trailing seven- or fourteen-day window so that payout timing and click-date reporting differences do not make individual days look broken. Monthly is the minimum before you close the books.

Do refunds and chargebacks show up the same way?

No. A refund returns the order amount and reduces your sales report. A chargeback returns the order amount, adds a flat dispute fee of roughly $15 in the US per Webgility, and does not necessarily lower your platform sales numbers — only your payout and your Shopify totals reflect it. Treat chargebacks as the more expensive event and track them separately.

What about orders paid through PayPal or other gateways?

They settle outside Shopify Payments, so they never appear in your Shopify payout. Reconcile each gateway against its own deposit report. Trying to match a PayPal order to a Shopify Payments payout is the most common reason a reconciliation refuses to close.

Can software do credit card payment reconciliation for me?

Automation can match charges, refunds, and disputes against orders far faster than a spreadsheet, which is worth it once volume climbs. But understand the mechanics first — the structural gap between a sale and a deposit is not a software bug to fix, it is card economics to account for. If you also sell across borders, the Stripe fees in France breakdown shows how international and currency surcharges widen that gap.