You sold $5,000 worth of product yesterday. Your bank deposit says $4,782. The difference isn't theft — it's Shopify payout reconciliation catching you off guard.

Matching your bank deposits to your Shopify sales is the most confusing part of running a store that nobody warns you about. Fees get deducted. Refunds get netted. Chargebacks vanish from one report and show up in another. Until recently, Shopify didn't give you a reliable way to match a specific bank deposit to the orders that generated it. That changed in January 2026 when Shopify added two fields — Bank Reference and Payout ID — to their export files. Most merchants don't know these fields exist yet.

Why Does Your Bank Deposit Never Match Your Shopify Sales?

Shopify doesn't deposit what your customers paid. It deposits what's left after subtracting its cut. Every payout has deductions baked in before the money moves:

Processing fees — Shopify Payments charges per transaction (rates vary by plan, typically 2.4%–2.9% + $0.30 per domestic card transaction in the US)
Refunds — any refunds issued since your last payout get subtracted from the current one
Chargebacks — disputed transactions plus the $15 chargeback fee get pulled from your payout
Shop channel sales tax — if you sell through the Shop app in the US, Shopify acts as a marketplace facilitator and deducts sales tax before paying you. This started in January 2025. It catches merchants off guard because storefront orders don't work this way.

So a $5,000 sales day might generate a $4,782 deposit — or a $4,650 one, or a $5,120 one (if a prior day's refund reversal gets added back). Without knowing exactly what Shopify subtracted, you're guessing.

Shopify Payout Timing Makes Reconciliation Harder

Shopify doesn't pay you the same day you make a sale. Settlement delays vary by country: 2 business days in the US, 3 in Canada, the UK, and most of Europe, 4 in Hong Kong and Singapore, and 5 in Japan. Weekends and holidays don't count.

Monday's sales might land in your bank on Wednesday or Thursday. But Wednesday's payout includes Monday's sales minus Tuesday's refunds, plus a chargeback from last week. Your bank statement shows one lump deposit. Shopify's reports show individual orders across multiple days.

The gap between "when did the customer pay" and "when did the money arrive" is where most confusion lives. If you're comparing your bank balance to yesterday's sales dashboard, the numbers will never line up.

Use the New Bank Reference and Payout ID Fields

In January 2026, Shopify added two fields to payout exports that solve the matching problem:

Bank Reference — appears in your payout export and matches the reference number your bank shows on the deposit line. This is the direct link between Shopify's records and your bank statement.
Payout ID — appears in your order transactions export. Every transaction (sale, refund, fee) is tagged with the Payout ID it was included in, so you can see exactly which orders made up a specific deposit.

To access these: go to Settings → Payments → Shopify Payments → View payouts, then click Export. The CSV now includes the Bank Reference column. For the transaction-level detail, export your transactions from the same page — each row includes the Payout ID it belongs to.

The Step-by-Step Reconciliation Workflow

Here's how to match every bank deposit to the orders that created it:

Start with your bank statement. Pick a deposit you want to verify. Note the amount and the reference number your bank shows for that transaction.
Export your Shopify payouts. Open the CSV and find the row where the Bank Reference matches your bank's reference number. Note the Payout ID and the total amount — these should match your bank deposit exactly.
Export your Shopify transactions. Filter by the Payout ID from step 2. You'll see every order, refund, fee, and adjustment that was included in that payout.
Verify the math. Add up all transactions for that Payout ID. Gross sales minus fees minus refunds minus chargebacks should equal the payout amount (and your bank deposit).
Flag discrepancies. If the numbers still don't match, check for Shop channel tax deductions (listed as separate line items) or currency conversion fees if you sell internationally.

This takes about 5 minutes per payout once you've done it twice. For stores processing fewer than 50 orders per day, a weekly check is enough. Higher-volume stores should reconcile daily or use accounting software that automates the matching.

Build a Simple Spreadsheet for Payout Reconciliation

A Google Sheet with two tabs handles basic reconciliation without accounting software:

Tab 1: Payouts. Paste your Shopify payout export here. Columns you need: Payout ID, Bank Reference, Payout Date, Amount.

Tab 2: Bank Deposits. Paste or manually enter your bank statement deposits. Columns: Date, Amount, Bank Reference.

Add a VLOOKUP or XLOOKUP formula on the bank deposits tab that matches the Bank Reference to Tab 1. If every row returns a match and the amounts are identical, you're reconciled. Any row that returns #N/A or a different amount needs investigation.

For most small stores, this 10-minute weekly routine catches every discrepancy before it becomes a bookkeeping headache at tax time.

What Causes Most Shopify Payout Mismatches?

If your numbers don't line up after following the workflow above, check these five causes first:

Multi-currency orders. Shopify converts at its own exchange rate, not your bank's. The converted amount in the payout export may differ from the rate you saw at order time.
Shop channel tax withholding. Shopify deducts and remits US sales tax on Shop app orders automatically. This won't appear in your regular sales tax reports. Look for it as a separate line item in the transactions export.
Negative payouts. If refunds and chargebacks exceed sales for a payout period, Shopify deposits nothing and carries the negative balance forward. Your bank shows no transaction; Shopify shows a negative amount.
UTC time cutoff. Shopify calculates payouts based on a UTC cutoff time. An order placed at 11:55 PM your local time might fall into the next day's payout if you're behind UTC.
Third-party gateways. PayPal, Amazon Pay, and other gateways settle directly — those transactions never appear in Shopify payouts. Filter by payment method before comparing totals. For more on managing multiple payment gateways on Shopify, see our guide.

When to Use Accounting Software Instead

The spreadsheet method works for stores doing under $50,000/month. Beyond that, the volume of transactions makes manual matching impractical. Apps like A2X, Webgility, or Ottit connect Shopify to QuickBooks, Xero, or other accounting tools and automatically match each payout to its component transactions.

The cost ranges from $19 to $99/month depending on order volume. Worth it if you're spending more than 30 minutes per week on manual reconciliation — or if you've ever filed taxes based on numbers you weren't confident in.

Even with automation, check the reconciliation summary monthly. Automated tools match transactions but can't flag when Shopify changes how it categorizes a fee or adds a new deduction type. If your Shopify Payments account has ever been frozen or had funds held, those holds also create mismatches that require manual review.

Start with next week's payouts. Export both files from Shopify Payments, match one deposit to your bank using the Bank Reference field, and verify the transaction breakdown. Once you've confirmed the numbers line up for one payout, you'll know exactly where to look when they don't.