Your Shopify sales total will never equal the deposit in your bank, and that is by design. Here is the exact process for tying the two together without guessing.
The deposit Shopify sends to your bank is a net number. It is your gross sales minus refunds, minus processing fees, minus any chargebacks or reserves held for the period. If you try to match that single deposit against your sales report, the numbers will not line up, and they are not supposed to. Reconciliation is the process of breaking the deposit back into its parts and proving each one belongs where it landed.
Done right, it takes minutes per payout. Done by eyeballing the bank feed, it eats hours and still leaves gaps. This walkthrough covers the manual method so you understand the mechanics, then the automated path for stores past a few hundred orders a month.
In the Shopify admin, open the Payouts section under your Shopify Payments settings. Each payout has a date, a total, and a breakdown: gross sales (charges), refunds, adjustments, fees, and the net amount. The net amount is what hits your bank. That breakdown is the source of truth. Start there, not from the bank deposit.
Write down or export the payout: the gross charges, the refunds, the fees, and the net. Those four numbers are the entire reconciliation.
Find the deposit in your bank that equals the payout's net amount. The date will lag the payout date by a day or two depending on your bank's processing. Match on the amount first, then confirm the date is plausible. If the net amount in Shopify equals the deposit in the bank, the cash side reconciles. If it does not, something is off (a refund booked late, a reserve you missed, or a second gateway's deposit you mistook for Shopify's).
This is the step manual bookkeepers skip and regret. A single net deposit should not be booked as a single revenue entry. Split it:
The sum of those components equals the net deposit. When you post them this way, your revenue reflects what you actually sold, your fees show up as a real expense, and the net still ties to the bank. Booking the deposit as one lump of revenue understates sales and hides fees entirely.
| PAYOUT COMPONENT | GOES TO | WHY |
| Gross charges | Revenue | What you actually sold |
| Refunds | Contra-revenue | Reduces sales without hiding fees |
| Processing fees | Processing expense | A real cost, not a revenue reduction |
| Chargebacks | Chargeback account | Tracks disputes separately |
| Reserves | Reserve account | In-transit cash, not yet free |
| Net deposit | Bank | Ties the whole entry to cash |
The hard cases live at month-end. A sale on the 31st may settle in a payout dated the 1st or 2nd. The sale belongs to the old month; the cash belongs to the new one. To reconcile cleanly, book the sale when it happens and carry the not-yet-deposited amount as an in-transit receivable (sometimes called undeposited funds or a clearing account). When the payout lands, clear the receivable against the bank deposit. This keeps revenue in the right month and stops phantom discrepancies where your month-end cash and month-end sales refuse to agree.
If you run PayPal, an external Stripe account, or any non-Shopify gateway, each one has its own payout file and its own deposit stream. Reconcile each separately using the same five steps. Do not try to reconcile all gateways against your total sales at once. Match each gateway's settlements to its own deposits, then confirm the gateways together account for all your sales.
The manual method works at low volume. Past a few hundred orders a month, with refunds, multiple gateways, and period-end timing gaps, it becomes the reason your close takes days. Automation reads the payout breakdown directly, posts each component to the correct account, carries in-transit funds across the period boundary, and matches the net to the bank feed.
ConnectBooks syncs Shopify payout data into QuickBooks Online, QuickBooks Desktop, or Xero and posts the gross sales, refunds, fees, and chargebacks to their own accounts, so each payout reconciles to the bank deposit automatically. That turns a manual matching exercise into a review-and-confirm step.
Because the deposit is net of fees, refunds, chargebacks, and any reserves, and because settlement timing lags the sale date. The deposit is supposed to be smaller than your gross sales. Reconciliation breaks the deposit back into those components and proves each one.
It holds the value of sales that have occurred but not yet been deposited, usually across a period boundary. You book the sale to revenue and the cash to the clearing account, then clear it when the payout actually lands in the bank. This keeps revenue in the correct month.
No. Book gross sales to revenue, refunds to contra-revenue, and fees to a processing-expense account. The sum equals the net deposit. Booking the net as revenue understates your sales and erases your processing-fee expense for the period.
Reconcile each gateway separately. Match Shopify Payments settlements to their deposits, then match PayPal settlements to theirs. Trying to reconcile all gateways against one combined sales figure makes discrepancies impossible to isolate.
At minimum monthly, as part of close. Higher-volume sellers benefit from reconciling each payout as it arrives, which keeps discrepancies small and easy to trace rather than letting a month of mismatches pile up.
ConnectBooks reconciles every Shopify payout to your bank deposit automatically, fees and refunds split to the right accounts. See plans at /pricing.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
