
Revenue Analytics
Part of Ecommerce analytics operations
Scheduling monthly reconciliation with finance
Set a monthly ecommerce finance handoff: agree the basis, preserve extracts, explain differences and record sign-off.
Add ecommerce reconciliation to the finance close calendar as a fixed monthly routine: agree the measure before month end, extract on the first business day after it, bridge the differences next, and lock an approved figure before finance closes the ledger. Store sales, captured payments and payouts can describe different activity in the same month.
Agree on the basis before close
Name the reporting month, time zone, extraction date and finance owner. Finance should specify whether it needs orders placed, sales after adjustments, captured payments, refunds or another approved measure. Record currency, channels, order states, tax and delivery treatment, test-order exclusions and the date used for each transaction.
Shopify sales reports include pending and unpaid orders, record a sale when an order is placed and a reversal when processed. Shopify's finance reports provide financial information for selected time frames, including sales and payments; its guidance distinguishes sales-report returns from refunds shown in the Payments finance report. Choose the source that answers the agreed question rather than trying to make these headlines identical.
For a GST-registered store, the approved sales figure also feeds the activity statements that report total sales, GST on sales and GST credits. Agree with finance which approved monthly figure the activity statement preparation will use, so the two are not reconciled separately.
Schedule the handoff
| Point in the close | Who hands what to whom | Record to produce |
|---|---|---|
| Last week of the month | Finance owner confirms measures and cut-off with the ecommerce analyst | Agreed measures, owners, period, cut-off and source definitions. |
| First business day after month end | Ecommerce analyst extracts store, payment and payout totals | Original totals, filters, extraction times and provisional-feed flags. |
| Second and third business days | Analyst sends the bridge to the finance owner for review | A bridge of explained differences and unmatched records. |
| Fourth business day | Financial controller signs off before the ledger is locked | Approved figure for its stated use, open exceptions and next review date. |
Book the four points as recurring calendar entries so the same rhythm repeats every month, and set the next review date at each sign-off. Move a step only when the finance close timetable moves. A month-end trading extract may remain provisional for an order group that can still receive cancellations or refunds, so flag it and re-run that group before sign-off.
Monthly Ecommerce Reconciliation Handoff Schedule
- Last week of the month
- Finance owner confirms measures and cut-off with the ecommerce analyst
- First business day after month end
- Ecommerce analyst extracts store, payment and payout totals
- Second and third business days
- Analyst sends the bridge to the finance owner for review
- Fourth business day
- Financial controller signs off before the ledger is locked
Pre-Sign-Off Reconciliation Checklist
- Agreed measure confirmedCurrency, channels, tax treatment, and order states defined.
- Extracts preserved with metadataOriginal totals, filters, extraction times, and provisional flags recorded.
- Bridge of differences explainedUnmatched records separated; groupings by timing, status, tax, etc.
- Exception register updatedOpen items assigned to owners with due dates and actions.
- Next review date bookedCalendar entry set for the following month’s reconciliation.
Explain the bridge
Align currency and included transactions before comparing. Match orders to payment and adjustment records using the order number, the payment transaction reference and the payout reference; keep unmatched records separate. Group differences by timing, status, tax or delivery components, reversals and test-order treatment. Check representative records in material groups.
An order placed near month end and captured in the next month appears in different periods under order-date and capture-date views. That is a possible timing difference, not an error. Shopify identifies differences between sales reports and order exports as a possible discrepancy; check the applicable report definitions and date range before classifying it.
Give each unresolved difference an amount or count, owner, next action and due date in an exception register handed to finance with the bridge. If record-level matching is unavailable, compare defined aggregates and state that individual transactions were not matched.
Sign-off should identify the approved figure and remaining uncertainty; it need not force unlike reports to the same total. An exception still open at sign-off is escalated to the financial controller, carried into next month's register with its amount, and closed or written off at the following close.
Key Steps in Monthly Reconciliation Process
- Align currency and transaction scopeEnsure both reports use the same currency, tax treatment, and order states.
- Match records using identifiersUse order number, payment reference, and payout reference to match transactions.
- Group differences by categoryClassify discrepancies by timing, status, tax, delivery, reversals or test orders.
- Document unresolved exceptionsRecord amount, owner, next action, and due date in an exception register.
- Final sign-off with clarity on uncertaintyApprove the figure while noting open exceptions; escalate if needed.



