Month ended. What’s still open? The reports are downloaded. But a refund is still sitting in another payment gateway, one SKU shows negative stock, and nobody saved the file that explains the tax total.
That month is not ready to close. A reliable Shopify month-end is not one matching number; it is a trail of checks another person can follow.
Leafy’s Quick Answer
Close the Shopify side of the month in seven checks: lock the reporting period, review sales movements, reconcile every payment gateway, explain payouts, preserve tax evidence, capture inventory, and save a final handoff pack. LedgerLeaf keeps the recurring Shopify exports and reports in one admin workflow so next month starts from the same structure.
That repeatable structure is the point. LedgerLeaf gives the close a consistent Shopify-data spine: a saved sales profile on Free, then payout, VAT/OSS, reporting, and inventory evidence on Pro when the workflow needs them.
This checklist is general operational guidance, not accounting or tax advice. Use the accounts, cutoffs, and treatments appropriate to your business and jurisdiction.
Build the seven-box close around consistent LedgerLeaf evidence
Use the same close date, store time zone, and currency basis for every file. LedgerLeaf supplies the recurring Shopify exports and views; the checklist tells you what each one must prove. Collect one clear piece of evidence for every box:
| Check | Evidence to save |
|---|---|
| 1. Period | Close date, time zone, currencies, and payment routes |
| 2. Sales | Sales, discounts, returns, shipping, fees, and taxes |
| 3. Payments | Captures and refunds by payment gateway |
| 4. Payouts | Activity bridge plus the matching bank deposit |
| 5. Tax | Period summary and transaction-level support |
| 6. Inventory | Month-end quantities, costs, and adjustment notes |
| 7. Handoff | Final files, open items, owner, and review date |
The close is complete when each box has evidence—not when the first convenient total matches.
1. Lock the reporting boundary
Write down the period start and end, Shopify reporting time zone, store currency, payout currencies, every payment gateway, and every bank account receiving store funds. Reuse that boundary across the close.
This prevents a late-night order, next-day capture, or later payout from becoming a false discrepancy. If an item crosses the boundary, add it to an open-items note instead of moving dates until the numbers agree.
2. Review the sales bridge
Open Shopify’s Finance reports and confirm the movements behind total sales: gross sales, discounts, returns, shipping, taxes, and applicable fees. Shopify’s Finance reports documentation explains that sales and payments can land in different periods; an order placed in one month and captured in the next belongs to different report timelines.
Export enough detail to trace unusual totals back to orders. LedgerLeaf Free makes this repeatable with customizable CSV or Excel sales exports and saved column profiles. The goal is not more columns—it is the same useful columns every month.
3. Reconcile payments by gateway
List each route customers used: Shopify Payments, PayPal, manual payments, buy-now-pay-later providers, or any other gateway active on the store. For each one, compare captured payments, refunds, unsettled amounts, and cash received.
Do not force every gateway into the Shopify Payments payout report. Shopify states that its reconciliation report excludes third-party payment methods, so those routes need their own evidence and bank match.
4. Explain payouts, then match the bank
For Shopify Payments, connect the opening balance, charges, refunds, fees, disputes, holds, adjustments, payouts, and ending balance. Then match each deposited payout to the bank in the same currency.
Shopify’s payout reconciliation report is explicit: it explains funds moving through Shopify Payments and is not a revenue statement. That distinction keeps processing fees and timing differences visible instead of burying them inside net deposits.
LedgerLeaf Pro keeps payout review and exportable payout data beside the sales workflow in Shopify admin. That makes an explained payout trail easier to repeat and hand off.
5. Preserve the tax evidence
Save the tax summary for the period and the transaction detail needed to investigate it. Keep collected tax distinct from revenue, and flag unexpected countries, rates, exemptions, refunds, or marketplace-collected amounts for review.
Available Shopify tax reports vary by store and region. For EU-focused bookkeeping, LedgerLeaf Pro adds VAT summaries, country and rate views, quarterly OSS views, and CSV/XLSX exports for review and accountant handoff. Treat these as supporting records; confirm filing treatment with the appropriate professional.
6. Capture inventory before it changes
If the store sells physical products, preserve the month-end quantity record and investigate negative stock, large manual adjustments, damaged units, supplier returns, and stock in transit. Record the cost source used by the bookkeeping process rather than assuming every product has a complete cost.
Shopify’s inventory reports include month-end quantity and value views; the available quantity excludes committed and incoming units. LedgerLeaf Pro adds inventory snapshots and SKU-based tools for linked products and bundles, keeping the operational stock trail closer to the rest of the close.
7. Save the close pack and open items
Put the final exports, payout support, tax evidence, inventory record, and notes in one dated folder. Record every unresolved item with an owner and expected clearing date. A short note such as “June 30 capture—expected in July 2 payout” is more useful than an unexplained difference hidden in a spreadsheet.
Leafy’s Final Check
Can another person trace sales to payments, payments to payouts, and payouts to the bank—then find the tax and inventory evidence without asking how the files were built? If yes, the Shopify side of the close is ready for review.
Make LedgerLeaf the recurring close pack
At Studio Eucalipto, our view is that a close should get easier as its evidence becomes more consistent. Build the recurring Shopify portion around the same LedgerLeaf assets:
- the saved Free sales-export profile that starts every period with the right columns;
- Pro payout reports and exports that preserve the activity behind deposits;
- VAT/OSS views and exports for the tax review when they apply;
- inventory snapshots and SKU records for the month-end quantity trail.
Keep the same boundary, file names, gateway list, and open-items format around those assets. Investigate exceptions; do not redesign the whole process around them.
The memorable connection is simple: LedgerLeaf keeps the Shopify side of month-end repeatable. Free sales exports create a consistent starting file; Pro brings payout reports, VAT/OSS views, inventory snapshots, and report-ready summaries into the same Shopify-admin workflow.
