It’s the 3rd of the month. Your bookkeeper needs the numbers for the P&L. Shopify reports $184,206 in sales, while the bank shows $161,940 in deposits.
That leaves a $22,266 difference.
The problem is that the answer usually isn’t sitting in one place. Someone has to open Shopify, review payout details, check the accounting system, trace refunds and fees, and often build or update a spreadsheet just to explain why the numbers don’t match.
That’s what an effective ecommerce month-end close checklist should prevent.
The goal isn’t to force Shopify sales and bank deposits to equal each other — they often shouldn’t. The goal is to create a clear trail from what customers purchased to what was actually paid out, including fees, refunds, disputes, timing differences, and other adjustments.
For multi-channel operators selling through Shopify alongside Amazon, wholesale, or other marketplaces, that trail becomes even harder to follow. This checklist breaks the reconciliation process into the checks that matter most, in the order they should happen, so unexplained differences don’t turn into days of back-and-forth at month-end.
Why the gap shows up every single month
The first thing to understand is that Shopify sales, payouts, bank deposits, and accounting entries represent different stages of the same transaction flow. They aren’t supposed to match automatically.
A customer might place an order in Shopify today, but the corresponding payout can arrive days later. Before that money reaches the bank, processing fees, refunds, disputes, and other adjustments may change the amount. Then the transaction still has to be recorded and categorized correctly in QuickBooks.
A few of the most common reasons for the gap include:
- Payment processing fees: The amount collected from customers is reduced by the actual fees associated with those transactions before or during settlement.
- Refund timing: A refund processed this month may relate to an order recorded as a sale in a previous month.
- Chargebacks and disputes: A deduction can appear weeks after the original transaction, separating the financial impact from the period in which the sale occurred.
- Payout timing: Orders placed near the end of the month may not settle until the following accounting period.
- Multi-channel settlement: Amazon, wholesale, Shopify, and other marketplaces can each have different payout schedules, fees, adjustments, and reporting structures.
None of those differences automatically means something is wrong. The problem starts when there’s no clear trail connecting the original order to the payout, adjustment, bank deposit, and accounting entry.
At month-end, those small timing and transaction differences become one larger unexplained variance that someone has to investigate manually.
If the difference between sales and payouts is the part causing confusion, we’ve broken down why your Shopify payout doesn’t match your sales and the specific factors that create that gap.
And the complexity grows as the operation grows. Add another sales channel, payment method, marketplace, or fulfillment workflow, and the team has another set of transactions and timing differences to reconcile. What was manageable with one storefront can quickly become hours of tracing orders, payouts, refunds, and accounting entries across multiple systems.
That’s why month-end reconciliation isn’t really about making two totals match. It’s about being able to explain every meaningful difference between them.
The ecommerce month end close checklist
Run these checks in order. The goal is to isolate where a difference enters the transaction flow instead of starting with one large month-end variance and working backward.
1. Start with sales — not the bank deposit
Begin with Shopify’s sales data for the closing period. Confirm that the reporting dates, order activity, refunds, discounts, taxes, and other relevant components are understood before comparing sales with money that reached the bank.
The key is to compare like with like. Gross sales, net sales, payouts, and bank deposits answer different questions, so putting two of those numbers side by side without accounting for what happened between them can create a discrepancy that isn’t actually an error.
If you also use an order management system or another source that records the same Shopify orders, compare equivalent sales totals across those systems first. Any unexplained difference at the order level should be investigated before moving downstream to payouts and accounting.
Once the sales side is understood, you have a reliable starting point for tracing how those transactions became payouts, deposits, and ultimately accounting entries.
2. Reconcile payouts before you reconcile bank deposits
Once the sales side is understood, move to the payout level.
A bank deposit tells you how much money arrived. The payout detail explains how that amount was calculated. For each payout, trace the transactions that contributed to it — including sales, refunds, processing fees, disputes, and other adjustments — and confirm that the resulting payout matches what actually reached the bank.
For example, if Shopify reports $184,206 in sales for the month while $161,940 reaches the bank, the $22,266 difference shouldn’t automatically be treated as missing revenue. Some sales may belong to payouts that settle in the following period, while fees, refunds, disputes, and other adjustments can reduce the amount deposited.
The goal is to account for those differences rather than force the two totals to match.
By the end of this step, you should be able to trace each bank deposit back to its corresponding payout and explain the transactions and adjustments that produced it. Anything that still can’t be explained becomes a specific exception to investigate instead of one large month-end variance.
3. Separate the refund date from the original order date
Refunds are one of the easiest ways for month-end numbers to become confusing because the sale and the refund can happen in different reporting periods.
For example, a customer might place an order in August and receive a refund in September. When reviewing September activity, don’t expect that refund to line up neatly with September sales. Trace it back to the original order so you can see when the sale occurred, when the refund was issued, and which payout activity reflects the refund.
This distinction becomes especially important around month-end. A high volume of returns processed shortly after the reporting period closes can create a noticeable difference between sales reports, payout activity, bank deposits, and accounting records.
The accounting treatment can depend on your reporting method and accounting setup, so the operational goal isn’t to decide which period a refund “belongs” to. It’s to maintain a clear link between the original order, the refund transaction, the relevant payout activity, and the corresponding accounting entry.
When that trail is intact, an older order refunded this month becomes an explainable transaction instead of another unexplained month-end difference.
4. Reconcile each sales channel separately before combining the totals
If you sell through Shopify, Amazon, wholesale, or other marketplaces, don’t start by combining everything into one month-end revenue or deposit total.
Each channel can have its own settlement schedule, fee structure, refund process, adjustments, and reporting format. A difference caused by Amazon’s payout timing is much easier to identify while Amazon activity is still separated from Shopify payouts and wholesale invoices.
Reconcile each channel from its transactions through its payouts or receivables first. Confirm that the activity within that channel is explainable, then bring the reconciled totals together for accounting and reporting.
Otherwise, a clean number from one channel can offset a discrepancy in another and make the combined total look correct even when an underlying issue still exists.
The more channels you operate, the more important this separation becomes. Month-end close should tell you not only whether the final numbers reconcile, but also where any remaining difference originated.
5. Trace chargebacks and disputes back to the original order
Chargebacks and disputes can create month-end differences because the financial impact often occurs well after the original sale.
Instead of treating a dispute as an isolated deduction, trace it back to the order and transaction that caused it. Record when the original sale occurred, when the dispute was opened, when funds were withheld or withdrawn, and whether any amount was later returned.
That gives you a complete transaction trail even when those events cross reporting periods.
For example, an August order could generate a dispute in September and affect a payout weeks after the original sale. Without the connection to the original order, the deduction can look like an unexplained difference in September. With that connection, the team can identify exactly which transaction caused it and why the payout changed.
At month-end, every material chargeback or dispute should be explainable without searching across multiple systems to reconstruct its history.
6. Reconcile actual processing fees — don’t estimate them
Don’t calculate expected processing fees using a single assumed percentage and treat the result as reconciled.
The actual fee attached to a transaction can vary based on the payment method, processor, transaction type, currency, pricing plan, and other factors. Even a small difference repeated across hundreds or thousands of orders can become meaningful by month-end.
Instead, reconcile against the actual fees reported in your payment and payout records. Those fees should be traceable to the transactions or payouts they affected and reflected appropriately in your accounting records.
If the expected payout still doesn’t match after sales, refunds, disputes, timing differences, and actual fees have been accounted for, you’ve narrowed the problem to a much smaller set of transactions worth investigating.
That’s the purpose of the checklist: not to estimate why the numbers are different, but to reduce a large month-end variance into specific, explainable exceptions.
“We already have a bookkeeper on this”
And that’s exactly who should benefit from a cleaner reconciliation process.
The issue isn’t whether someone owns the month-end close. It’s how much work they have to do before the numbers are ready to close.
When sales, payouts, refunds, fees, disputes, and bank deposits live across different systems, a bookkeeper or accounting team may still have to reconstruct the transaction trail manually — exporting reports, comparing spreadsheets, tracing individual transactions, and asking operations why something doesn’t match.
That work becomes much easier when the underlying data is already connected and the differences are identified before close begins.
Instead of handing your bookkeeper one unexplained variance, the goal is to give them a clear trail showing what was sold, what was adjusted, what was paid out, what reached the bank, and which transactions still require attention.
A better reconciliation process doesn’t replace the bookkeeper. It removes the manual detective work that keeps them from doing the higher-value accounting work you hired them for.
What actually closes this gap
A faster month-end close doesn’t come from another report. It comes from having a clear reconciliation trail before close begins.
That means connecting the operational events behind the numbers — orders, payouts, fees, refunds, disputes, and adjustments — so your team can see how activity moved from the storefront through settlement and into accounting.
That’s the workflow SuppliFlex is being built to support.
Instead of waiting until month-end to discover one large unexplained difference, SuppliFlex helps surface reconciliation exceptions closer to the transactions that caused them. When something doesn’t line up, the goal is to give your team the context needed to investigate the specific order, payout, or adjustment rather than reconstructing the entire month from spreadsheets and disconnected reports.
For Shopify-first ecommerce teams operating across multiple systems, that changes the month-end question from:
“Why are these two totals different?”
to:
“Which transactions explain the difference, and which ones still need attention?”
That’s a much smaller problem to solve.
If your month-end close still depends on someone manually piecing together Shopify activity, payouts, bank deposits, and accounting records, book a 20-minute diagnostic and we’ll walk through where the reconciliation process is breaking down and where SuppliFlex can help.
Want the six checks from this article in a format your team can keep for close week? Download the Ecommerce Month-End Close Checklist (PDF).