01
Confirm provider and access.
The report requires Shopify Payments and payout-view permission. It excludes Shopify billing fees, third-party processors, and third-party payment methods.
Shopify Payments month-end
How to use the Shopify Payments activity report at month-end
Review how the Shopify Payments balance moved across a period—without treating the report as revenue or forcing it to equal the same month's bank deposits.
Period-level review · One payout currency at a time · No accounting conclusions
Quick answer
Use the report to explain balance movement, not one deposit.
In Shopify admin, go to Finance → Documents → Shopify Payments activity report. Select the period and one payout currency, then review the starting balance, gross activity, fees, payouts, net movement, and ending balance. Shopify labels that movement Balance change from activity and its expanded result Net amount. Use Finance reports for sales or revenue questions; use the Payouts page when one bank deposit needs transaction-level detail.
Before you start
Check the report's scope before comparing totals.
02
Separate payout currencies.
Shopify creates a separate report for each payout currency. Do not combine currencies to manufacture a single apparent match.
03
Respect the data delay.
Shopify says the activity report has a three-day data delay. Label a recent period incomplete instead of treating missing activity as a resolved variance.
Five-step close
Move from completeness to exceptions.
- 01
Set the exact date range and payout currency.
Record both selections and the timezone used by each source you compare. A same-month bank statement can still contain payouts produced by activity from a different date range, so matching month labels alone is not enough.
- 02
Preserve the period report.
Export the displayed report to PDF after the selected period is old enough for the reported delay. Shopify says the PDF carries the same Summary and Activity information shown in admin.
- 03
Tie the opening and closing balances.
Confirm that the starting balance plus Balance change from activity leads to the ending balance. Expand that field and review how gross activity, fees, and payouts produce the Net amount rather than comparing sales to the bank first. If the balance bridge does not tie, verify the selected range and currency, allow for the three-day delay, and rerun it. If the same inconsistency remains, contact Shopify Support instead of forcing the close.
- 04
Expand the activity groups that actually appear.
Shopify displays only applicable groups. Depending on the store and period, those can include charges, refunds, disputes, adjustments, reserves and holds, shipping, Shop Cash, or other balance activity.
- 05
Route each remaining question to the right source.
Use Finance reports for order and sales activity. Open the Payouts page for a specific payout or bank deposit. Keep an unresolved item open when the source evidence does not support a match. Follow the order-to-payout process map when a known transaction needs tracing, or use the bank-reference lookup guide when the investigation starts from a bank line.
Synthetic example
Read the summary as a balance bridge.
Starting balanceUS$1,250
Gross activity+ US$8,400
Fees− US$252
Payouts− US$7,900
Net amount / Balance change from activityUS$8,400 − US$252 − US$7,900 = + US$248
Ending balanceUS$1,250 + US$248 = US$1,498
This simplified example uses the summary fields named by Shopify. A real report can contain additional activity groups and line items. The ending balance is not the month's revenue, and the US$7,900 payout total does not need to equal bank deposits posted inside the same calendar dates.
Difference triage
Do not solve every difference with the same report.
| What looks different | First check | Next source |
|---|---|---|
| Activity report vs. Finance sales | Different purpose, date range, timezone, and totals | Finance reports for order and sales activity |
| Opening balance + net movement does not equal ending balance | Currency, date range, and three-day delay | Re-run; contact Shopify Support if it remains inconsistent |
| Activity report vs. bank deposits | Payout schedule and date-range timing | Payouts page for the specific deposit |
| Recent activity appears missing | Three-day report delay | Re-run after the delay; keep the period open |
| One currency does not tie | Selected payout currency | The separate report for that currency |
| Third-party payments are absent | Provider exclusion | The third-party provider's own settlement evidence |
Sources: Shopify Payments activity report, payout details and transaction export, and Finance reports.
When one payout remains unresolved
Switch from the period report to a payout-level review.
The US$9 Shopify Payout Reconciliation Workbook starts with one Shopify net payout and keeps the bank-deposit check separate. Use it only after the activity report or Payouts page has identified the payout that needs review.
It includes one editable .xlsx workbook, synthetic examples, and a checklist tab. It does not import the activity report, connect to Shopify or a bank, replace native reports, or decide accounting treatment.
View the US$9 workbook on GumroadShopify Payments only. One currency per workbook. Requires an app that can open and recalculate Excel formulas; compatibility with Google Sheets, Apple Numbers, mobile apps, and browser-only editors is not verified.
Boundary
A review workflow—not a revenue statement.
This guide organizes Shopify's own report views and unresolved questions. It does not establish revenue, predict payout timing, prove a Shopify or bank error, reconcile third-party processors, or make accounting, tax, or ledger decisions. A qualified bookkeeper or accountant makes the final treatment decision.