A Shopify payout lands below the amount your team expected. Is the difference explained by processing fees, refunds, or settlement timing—or is a transaction missing? During peak season, answering that question can mean hours spent comparing order exports, payment reports, and accounting entries.
Order reconciliation means matching orders with their payments, refunds, fees, and accounting records, then investigating any unexplained differences. The totals do not need to be identical: gross sales and net payouts measure different things. What matters is whether your team can explain the difference and identify anything that needs attention.
This order reconciliation checklist covers six checks to run before Black Friday and Cyber Monday, from missing settlements to inventory discrepancies that can affect your books. Use it to identify gaps, assign an owner, and resolve exceptions before they become month-end cleanup.
Why order reconciliation gets harder during peak season
Higher order volume increases the number of transactions your team needs to match—and the exceptions it needs to investigate. Refunds may fall into a later payout period than the original payment. Partial captures, split shipments, chargebacks, and fee adjustments can add more records to review for a single order.
A manual process that works during a normal week can develop a backlog during Black Friday and Cyber Monday. If unresolved differences have no assigned owner or review deadline, they can carry into the next accounting period, making month-end reconciliation harder.
Before peak demand arrives, confirm how your team will identify overdue settlements, distinguish expected deductions from unexplained differences, and follow each exception through to resolution. Reviewing these issues throughout the month gives your team less to untangle at close.
What an effective order reconciliation workflow should do
A dashboard can show gross sales, refunds, and net payouts. An order reconciliation workflow goes further: it connects the underlying transactions, accounts for expected differences, and identifies records that need investigation.
For example, a payout below gross sales may be fully explained by processing fees and refunds. An exception arises when a deduction cannot be explained, a payment remains unsettled beyond its expected window, or a transaction is missing from the accounting records. As we explain in our guide to multi-channel revenue reconciliation, different totals can be correct—as long as the differences are accounted for.
Each exception should include the affected order or transaction, the expected and recorded amounts, the reason it was flagged, an assigned owner, and a record of its resolution. Where automation is available, matching rules and alerts should use your settlement windows and review thresholds so expected timing differences do not become unnecessary alerts.
Order reconciliation checklist: 6 checks before peak season
Use these six checks to review how orders connect to payments, payouts, refunds, and accounting records. The final two checks cover related inventory and purchasing discrepancies that can affect stock valuation and cost of goods sold.
For each check, define what counts as an exception, who investigates it, and when it should be resolved. Apply the checks at the appropriate level—individual transaction, payout batch, or inventory receipt—rather than assuming every record maps directly to one order.
1. Captured payments with no matching settlement
Check that each captured customer payment can be traced to a payout or an explained settlement status within the payment provider’s expected timeframe. Payouts often combine multiple transactions, so match payments to the transactions within each batch rather than expecting a separate bank deposit for every order.
Flag payments that remain unsettled beyond the expected window without a documented explanation. Investigate whether funds are pending, held in reserve, affected by a dispute, or missing from the imported records. For wholesale orders paid on invoice, review overdue receivables separately against the agreed payment terms.
Checklist action: Review overdue unsettled payments and record the amount, payment reference, expected settlement date, and person responsible for follow-up.
2. Payout amounts with unexplained differences
Calculate the expected net payout using the transactions included in that settlement batch. Account for captured payments, refunds, processing fees, disputes, reserves, and other adjustments shown in the payment provider’s report. Then compare the expected amount with the payout received in your bank account.
A payout below gross sales is not automatically an error. The exception is a difference that remains unexplained after the batch’s transactions and deductions have been accounted for. Trace order-level charges to the relevant payment or refund, and document batch-level adjustments separately.
Checklist action: Compare each payout with its settlement report and bank deposit. Assign any unexplained difference to an owner, and retain supporting records for the resolution.
3. Refunds missing from payment, accounting, or return records
Match each refund to the original order, confirm its status with the payment provider, and check that the accounting records reflect the refunded amount and any applicable tax adjustment. Flag missing entries, duplicate refunds, or amounts that differ between systems.
Review the inventory outcome separately. A refund does not always mean stock should increase: the customer may keep the item, the return may still be in transit, or the product may arrive damaged. Returned units should become available for sale only after receipt, inspection, and approval for restocking.
Checklist action: Verify the financial record for each refund. Where a physical return is expected, track its receipt, condition, and final disposition against the original order.
4. Multi-channel transactions missing or counted twice
Reconcile each sales channel with its payment or settlement records, then check that the corresponding transactions appear correctly in your accounting system. Look for missing orders, duplicate imports, and refunds or fees assigned to the wrong channel.
Use consistent reporting periods and definitions when comparing channel totals. Shopify sales, marketplace settlements, and wholesale invoices do not necessarily reach the bank in the same period. Document timing differences and unpaid invoices rather than expecting combined revenue to equal bank deposits.
Checklist action: Review each channel separately, then check the combined accounting records for omissions and duplicates. Where an order appears in more than one connected system, use a consistent order reference to prevent double counting.
5. Inventory write-offs without supporting records
Check that each inventory write-off records the SKU, quantity, value, reason, date, and approving person. Link it to the relevant source record—a customer return, warehouse damage report, stock count, or receiving discrepancy—and confirm that the inventory and accounting entries agree.
Not every write-off originates from a customer order. When one does, such as a returned item deemed unsellable, retain the order and return references. For other losses, preserve the evidence explaining why stock was removed and how its value was determined.
Checklist action: Review recent write-offs for missing reasons, approvals, or source records. Use our inventory write-off audit trail guide to assess whether each adjustment can be explained.
6. Purchase order, receipt, and supplier invoice discrepancies
Compare the purchase order, the quantities actually received, and the supplier invoice. Flag short shipments, damaged units, incorrect prices, and charges that do not match the agreed terms. A receipt marked “complete” should reflect what arrived, with any shortage or damage documented separately.
Unresolved discrepancies can overstate inventory, lead to supplier overpayments, or affect inventory valuation and cost of goods sold (COGS), depending on how the receipt and invoice were recorded. A short shipment does not automatically create a COGS error, but inaccurate receiving records can carry into later accounting calculations.
Checklist action: Record each discrepancy against the PO and receipt, assign an owner, and track the correction, replacement shipment, or supplier credit through to resolution.
Why month-end reconciliation needs checks throughout the month
Month-end reconciliation remains essential: it confirms balances, accounts for timing differences, and supports an accurate close. But if it is the first time your team investigates missing payments or unexplained adjustments, several weeks of exceptions may need attention at once.
Review transactions throughout the month at a cadence that fits your order volume and settlement schedules. Assign unresolved exceptions as they appear, document the investigation, and carry open items into close with a clear status. This reduces the amount of research left until month-end.
Your ERP or accounting platform may already offer reconciliation, matching, or purchasing controls. Check which features are configured, which channels they cover, and whether someone reviews the exceptions they identify. The gap may be a missing integration, an unused rule, or unclear ownership—not necessarily a missing system.
How to measure the cost of manual order reconciliation
The cost of manual order reconciliation includes time spent exporting reports, matching transactions, investigating differences, and correcting records. During peak season, a growing exception backlog can also delay close and leave your team working with unresolved balances.
To measure the workload, track reconciliation time for one week. Separate routine matching from exception investigation, and record how many issues remain open at the end of the week. This shows whether the bottleneck is report preparation, missing data, or repeated discrepancies.
For example: One hour per business day adds up to roughly 20 hours in a month with 20 working days. Multiply those hours by the employee’s hourly cost to estimate the labor expense, then track overtime or outside accounting support separately.
Put your order reconciliation checklist into practice before peak season
Start with one recent payout batch. Can your team trace its payments, refunds, fees, and adjustments through to the bank deposit and accounting records? For any unexplained difference, can you identify who owns the investigation and when it should be resolved?
Then work through the remaining checks: missing or duplicate channel transactions, refund and return records, inventory write-offs, and receiving discrepancies. Prioritize gaps that repeatedly cause extra work or remain unresolved at month-end.
Want help reviewing your process? Book a 20-minute reconciliation diagnostic with SuppliFlex to discuss your Shopify, 3PL, and accounting workflows, identify potential gaps, and prioritize practical next steps before peak order volume arrives.