Shopify Month-End Reconciliation Checklist That Holds Up to Review

1. Freeze the scope and cutoff

Write down the store, payment account, currency, bank account, and month-end cutoff before downloading reports. Decide whether the review covers captured payment receipts, payout events, or bank-posted deposits; these are related but not identical populations. Keep the sales report definition explicit and do not describe gross sales as tax inclusive unless the source and policy actually establish that.

Collect the month-end bank statement, payout reconciliation reports, relevant sales and refund reports, and the prior month's open-items list. Save report dates and filters. This simple scope note prevents a common error: comparing a full-month sales report with only deposits that happened to post before the bank cutoff.

2. Tie each settled payout to the bank

List each payout identifier, report net total, processor event date, bank-posted date, currency, and bank reference. Match the payout's net amount to the corresponding statement credit. Shopify's payout timing guidance explains why event and bank dates can differ; preserve both rather than changing the cutoff to make them agree.

Use the payout reconciliation report to explain each net total. Do not book the bank deposit as new revenue. It settles captured activity and its associated adjustments.

• Mark matched, timing difference, investigation, or awaiting evidence.
• Check currency and payout status before comparing amounts.
• Attach the report reference to the reconciliation workpaper.

3. Explain the clearing balance

After settled payouts are matched, list what remains in the processor clearing account: captured receipts awaiting payout, held amounts, refunds or adjustments not yet settled, and genuine unexplained differences. A legitimate month-end balance is not a failure if each component has a source, status, and expected follow-up.

Fictional simplified example, not a fee quote: September captured payment receipts total $8,000, refunds total $300, and processing fees shown in the payout evidence total $240. The simplified net activity is $8,000 − $300 − $240 = $7,460. If $6,500 of the related payouts posted to the bank by September 30, $960 remains to be explained as in transit or otherwise unsettled. Gross here means before the listed items; the example is not tax advice or a tax calculation.

Check: $8,000 − $300 = $7,700; $7,700 − $240 = $7,460; $7,460 − $6,500 = $960. The $960 is not automatically a fee or loss. Tie it to specific payout status and timing evidence.

4. Review exceptions by status

Inspect large refunds, unusual adjustments, held funds, and disputes. A hold is not an expense simply because it delays cash. An open dispute is not necessarily a final loss. A refund does not always mean that a processing fee is returned. Record what the source says and leave the accounting outcome to the documented policy and final evidence.

For every open item, record amount, payout or transaction reference, status, owner, next evidence, and target review date. Roll the list forward only when the status is still supported. If an item is genuinely unexplained, keep it visible rather than posting a suspense plug without a reason.

5. Review, sign off, and carry forward

A preparer should prove the arithmetic and attach source reports. A reviewer should challenge cutoff choices, high-value adjustments, old clearing items, and any difference posted directly to income. Sign off the matched bank population separately from the open-items schedule so a valid timing balance does not obscure an unresolved variance.

At the next month open, bring forward only items with a clear owner and source. Compare the prior list with the new payout reports and close items when evidence arrives. This creates a repeatable close for a merchant, bookkeeper, or finance team without requiring every payment to settle by month-end.

Sources and further reading

Shopify: Payout reconciliation report and Payout timing. These sources help confirm current report and timing context; they do not replace a store-specific accounting policy.

Payout Explainer is coming soon

Product note: SlayCommerce's Payout Explainer is coming soon. It is intended to support review-before-posting for this checklist, with no automatic posting and no tax or FX advice.