Shopify Payments Activity Report: A Complete Guide to Reconciliation, Payouts, and Month‑End Close

Table of Contents

1. Key Highlights
2. Introduction
3. What the Shopify Payments Activity Report Actually Shows
4. Where to Find and Generate the Report
5. How the Activity Report Differs from Payout-by-Payout Exports
6. Practical Uses: Month-End Close and Reconciliation Workflows
7. Reconciling Shopify Payments with Bank Deposits: A Step-by-Step Workflow
8. Handling Refunds, Chargebacks, and Adjustments
9. Integrating the Activity Report with Accounting Software
10. Best Practices for Accurate Reporting and Audit Trail
11. Troubleshooting Common Issues and How to Fix Them
12. Security, Permissions, and Compliance Considerations
13. Advanced Tips: Using Exports in Excel and Google Sheets
14. Real-World Examples: How Merchants Use the Activity Report
15. Change Management: Training Your Finance Team
16. Frequently Overlooked Details
17. FAQ

Key Highlights

• The Shopify Payments activity report consolidates starting balance, gross activity, fees, payouts, and ending balance across a chosen date range to show how funds moved through your Shopify Payments balance.
• Use the report for month-end close, balance reconciliation, investigating balance changes, and exporting a PDF for financial records; it presents a balance‑centric view distinct from payout-by-payout exports.
• The report is accessible from Finance > Documents > Shopify Payments activity report or from the Payouts page; integrate it into accounting workflows, reconcile timing differences, and handle refunds, chargebacks, and currency conversions with clear procedures.

Introduction

Every business that accepts payments online needs a reliable, audit-ready view of how money flows into and out of its payments account. Shopify Payments records dozens of transaction types—sales, refunds, fees, adjustments, chargebacks—and deposits them to your bank as payouts. When deposits hit the bank, the ledger in Shopify can look different from the deposit line on your bank statement, because Shopify organizes records around balance activity and transaction dates rather than solely by payout. The Shopify Payments activity report stitches those pieces together in a single, date-range oriented view that simplifies reconciliation, clarifies why balances changed, and provides documentation you can attach to month-end close packages or hand to an accountant.

The following guide explains what the activity report shows, how it differs from payout exports, practical reconciliation workflows, handling refunds and disputes, integration with accounting software, common issues and fixes, and advanced tips for turning the export into a reliable bookkeeping tool.

What the Shopify Payments Activity Report Actually Shows

The activity report consolidates the lifecycle of money in your Shopify Payments balance over a selected date range. Its core components are:

• Starting balance: the balance in your Shopify Payments account at the start of the reporting period.
• Gross activity: all inflows into the balance during the period, typically sales, authorizations that converted to charges, and other credits such as manual adjustments.
• Fees and adjustments: Shopify Payments processing fees, refunds processed (which reduce gross receipts), chargeback fees, and any other debits applied against the balance.
• Payouts: the gross deposit amounts Shopify sent to your bank during the reporting window.
• Ending balance: what remains in Shopify Payments after all activity and payouts within the period.

The report lists individual entries by balance activity date and transaction date where applicable. That dual-date approach makes it possible to spot timing issues—when a sale posts on one date but affects the balance on another, or when a refund reduces the balance before the corresponding payout clears.

Visual layout (typical): top-level summary with opening and closing balances and totals, followed by a chronological ledger of entries that created those totals—credits, debits, and payout entries. Exports can be rendered as PDF for records or used in downstream financial workflows.

Where to Find and Generate the Report

The activity report is accessible within Shopify's admin. Two entry points are common:

• Finance > Documents > Shopify Payments activity report: the primary path for finance and accounting users preparing reports as part of monthly close.
• Payouts page: when reviewing payouts you can generate an activity report centered on the payout history for a chosen period.

Generating the report:

1. Choose the date range you want to review. Pick a month for month-end close or a custom range when investigating a balance discrepancy.
2. Generate the report. Shopify compiles starting balance, activity, fees, and payouts for that window.
3. Export options: PDF is available for audit packages and manager sign-off; CSV/Excel exports may be available for deeper analysis depending on Shopify’s current UI. If a CSV export is not available directly, you can export data from Payouts and use the activity report PDF alongside it.

Selecting date ranges with intention matters. Choose the period that matches your accounting cutoffs rather than matching a bank deposit date. The activity report uses balance and transaction dates, so a sales date falling at month-end may affect the balance in the next month if refunds or adjustments occur later.

How the Activity Report Differs from Payout-by-Payout Exports

Shopify provides multiple ways to export payments information. The Payouts page lists individual payout deposits and can export payout-by-payout details. The activity report gives a different, often more useful perspective:

• Payout exports = deposit-centric. They show the individual bank deposits Shopify made (payouts), which accountants reconcile to bank statements.
• Activity report = balance-centric. It shows how every transaction affected the Shopify Payments balance during a period, tying opening balance, gross activity, fees, and payouts into a single reconciliation view.

Use cases that favor the activity report:

• Explaining why your Shopify Payments balance decreased between two dates despite no payouts hitting the bank during that window.
• Completing a month-end package where you must reconcile the net change in Shopify Payments balance rather than just matching deposits to bank statements.
• Tracing the origin of a specific adjustment or dispute and how it affected rolling balance totals.

Payout exports remain important. Reconcile payout deposits to bank statements using payout exports. Use the activity report when the balance movements themselves are central to the question—e.g., reconciling held funds, refunds that outweighed sales in a period, or chargebacks that reduced the available balance before payouts.

Practical Uses: Month-End Close and Reconciliation Workflows

The activity report integrates neatly into standard accounting rhythms. Here are step-by-step workflows for common tasks.

Monthly close reconciliation (example workflow)

1. Run the activity report for the month (e.g., June 1–30). Record starting balance and ending balance.
2. Pull payout exports for the same window or the Payouts page to list bank deposits Shopify initiated.
3. Pull your bank statement for the period that contains those deposits. Bank statement dates may differ if payouts clear on different days.
4. Reconcile as follows:
   • Match each payout line from Shopify to the corresponding bank deposit line.
   • Use the activity report to explain any balance decreases or increases not represented on bank statements (such as refunds or chargebacks that reduce balance but may not correspond to a separate bank movement).
   • Adjust accounting entries for processing fees and chargebacks to reflect what hit your profit and loss for the month.

Example numbers:

• Starting balance: $5,000
• Gross sales in period: $30,000
• Refunds/returns: $1,200
• Processing fees: $900
• Payouts initiated to bank: $32,800
• Ending balance: $3,100

Explain the arithmetic: opening balance + gross activity - refunds - fees - payouts = ending balance. If the numbers do not reconcile, examine transaction-level entries in the activity report for late refunds, disputed transactions, or manual adjustments.

Reconciling timing differences Timing creates the majority of disputes between Shopify records and bank statements. A sale may post and affect balance on the transaction date, but a payout that includes that sale may deposit to bank several days later. Use the activity report’s transaction and balance dates to identify entries that impact the balance in different reporting windows. For month-end close, book accruals for sales recognized in the period even if the bank deposit falls into the next month.

Preparing a month-end package Include:

• Activity report PDF for the period.
• Payout export and bank statement showing corresponding deposits.
• Summary reconciliation worksheet showing starting balance, all adjustments (fees, refunds), and ending balance with explanatory notes for any exceptions.
• Journal entries required to align books with bank deposits and recognized revenue.

Use explanatory footnotes in the package for unusual items (big refunds, multiple chargebacks, or manual adjustments).

Reconciling Shopify Payments with Bank Deposits: A Step-by-Step Workflow

Reconciling Shopify Payments to your bank is routine but requires attention to timing, fees, and exceptions.

Step 1: Export supporting documents

• Export the activity report for your reconciliation period.
• Export the payout-by-payout report or capture payout entries from the Payouts page.
• Download the bank statement for the period that contains the relevant deposit dates.

Step 2: Build the reconciliation worksheet (use Excel or Google Sheets) Columns should include:

• Shopify reference (transaction ID or payout ID)
• Transaction date (sale/refund date)
• Balance activity date (as shown in activity report)
• Description (sale, refund, fee, adjustment)
• Amount (positive for credit, negative for debit)
• Payout ID (if tied to a specific payout)
• Bank deposit date and amount
• Reconciliation status (Matched/Outstanding/Investigate)

Step 3: Match payouts to bank deposits

• Identify each payout amount in Shopify and find the corresponding deposit on the bank statement. Match by payout amount and date.
• If the payout was split or combined by the bank, or if the bank applied its own fees, annotate the differences.

Step 4: Investigate unmatched items

• Outstanding sales that are not part of matched payouts: Check whether they are included in a later payout.
• Refunds that reduce Shopify balance but do not appear as separate bank transactions: These typically offset gross receipts and are represented in payout amounts rather than as separate bank lines.
• Chargebacks and reversals: Banks may debit the merchant account directly; refer to the activity report entries showing chargeback debits and fees.

Step 5: Post adjusting journal entries

• Record processing fees as merchant fees expense if not automatically recorded.
• Book refunds and chargebacks against revenue or a returns/chargeback account as per accounting policy.
• Record journal entries for unapplied balances (e.g., platform holds or reserve amounts) until resolved.

Practical example You run the activity report for April. Starting balance $1,200. Total sales $25,000. Refunds $500. Fees $750. Payouts $24,000. Ending balance $950.

Bank statement shows deposits: $10,000 (April 3), $14,000 (April 17). Both correspond to Shopify payouts but the dates differ by one business day. Reconcile both and attach the activity report to support entries. Post processing fee expense of $750 for the month, match refunds against revenue adjustments, and ensure ending Shopify balance is properly reflected as a clearing account balance in your general ledger.

Handling Refunds, Chargebacks, and Adjustments

Refunds and chargebacks often create confusion in reconciliation. The activity report reveals how these items impacted your balance and when.

Refunds

• Refunds reduce gross activity and the Shopify Payments balance. They appear as debits in the report and will lower the amounts included in subsequent payouts.
• Refunds processed after a sale may cause a payout to be lower than expected. The activity report ties refunds to balance impacts so you can trace why a particular payout amount changed.

Chargebacks

• Chargebacks typically show as a debit against the balance (the disputed amount) plus an associated fee. If the chargeback is later won and funds returned to you, a corresponding credit appears.
• For chargebacks, note the date Shopify applied the debit (balance activity date) and whether there's a timing lag for when funds are reclaimed (if you win). Document the dispute process and any adjustments that follow.

Manual adjustments and reimbursements

• Occasionally Shopify or other parties may apply manual adjustments to your balance—for example, reimbursements after an appeal. These show as separate entries. Use the activity report to capture and explain these out-of-band entries.

How to reflect refunds and chargebacks in your accounting

• Refunds: Reduce revenue and cash/receivables accordingly; if using accrual accounting, record them against the original revenue account or a dedicated returns account per company policy.
• Chargebacks: Record as reductions to revenue and as separate chargeback expense if desired for management visibility. Record the chargeback fee separately from the amount of the chargeback.

Practical tip: Always attach supporting documentation (chargeback notices, evidence submitted, resolution receipts) to the reconciliation line in your accounting system. The activity report gives the transaction-level context; store correspondence and evidence in the same folder or record.

Integrating the Activity Report with Accounting Software

Most merchants use QuickBooks, Xero, or another accounting package. The activity report supports integration in two ways: as audit documentation and as a source of truth for manual or semi-automated journal entries.

Direct integrations and apps

• Some merchants use apps that pull payout and transaction data directly from Shopify Payments into accounting software. These apps typically map payouts to bank deposits and break out fees, refunds, and taxes into separate ledger lines.
• If you rely on an integration, use the activity report as a reconciliation check. Ensure the integration’s mapping matches how you want to present processing fees, refunds, and transaction taxes on the P&L and balance sheet.

Manual import workflow

1. Export the activity report data as CSV if available, or export payout and transactions from the Payouts page.
2. Prepare a mapping template in Excel that aligns Shopify fields (transaction ID, date, amount, payout ID, fee) with your chart of accounts.
3. Import or paste into your accounting system’s import template and create journal entries or bank deposits as necessary.

Examples of account mapping

• Gross sales → Revenue (sales)
• Processing fees → Payment processing expense
• Refunds → Contra-revenue (or returns and allowances)
• Chargeback fees → Chargeback expense
• Payouts → Clearing account (Shopify Payments clearing) matched to bank deposits when the payout appears on the bank statement

Reconciliation strategy: Use a clearing account named “Shopify Payments (clearing)” in your ledger. Record all Shopify activity to that clearing account, then create bank deposits when payouts land in your bank and clear them against the clearing account. The activity report provides the transaction-level activity to reconcile the clearing account balance.

Multicurrency considerations

• If you sell in multiple currencies, Shopify Payments may show separate balances or conversions. Reconcile each currency separately where possible.
• Foreign exchange (FX) adjustments may appear when Shopify converts funds to your settlement currency. Record FX gains or losses in a dedicated account.

Example integration with QuickBooks

• Record gross sales to sales revenue in QuickBooks and move funds into the Shopify Payments clearing account as credits.
• Post processing fees as debits to a merchant fees expense account against the clearing account.
• When a payout deposits to the bank, record a deposit in QuickBooks that clears the clearing account.

Document automation: Keep the activity report PDF attached to your monthly reconciliation entry in QuickBooks or Xero’s attachment feature. It provides context for auditors and future inquiries.

Best Practices for Accurate Reporting and Audit Trail

Consistency, permissions, and documentation reduce reconciliation friction.

Define cutoffs and policies

• Set a consistent accounting cutoff for Shopify transactions. Decide whether revenue recognition follows transaction date or settlement date and apply that consistently.
• Document refund handling, chargeback accounting, and criteria for when to record a reserve or hold.

Use a clearing account

• Route all Shopify Payments activity to a single clearing account for easy reconciliation. Payouts should clear the clearing account when deposits match bank statements.

Schedule regular reconciliations

• Reconcile Shopify Payments weekly if you have high volume or frequently processed refunds and chargebacks. Monthly reconciliation suffices for lower-volume merchants.

Attach supporting documents

• Attach the activity report and relevant payout exports to every monthly reconciliation. Maintain a folder with chargeback notices, refund evidence, and any platform adjustments.

Control access

• Limit who can generate and export financial reports. Maintain an approval process for users who can issue refunds or initiate chargebacks.

Record retention

• Keep activity reports as part of your financial archive for at least the statutory requirement in your jurisdiction. Use cloud storage with versioning or your ERP’s attachments to prevent data loss.

Internal reviews

• Have a second person review large refunds, chargebacks, or manual adjustments. Document approvals.

Reconciliation checklist (sample)

• Activity report exported for the period
• Payout export reviewed and matched to bank statement
• Clearing account reconciled to activity report ending balance
• Fees and chargebacks posted and cross-checked to the activity report
• Attachments and notes included for any exception items

Troubleshooting Common Issues and How to Fix Them

Missing transactions, negative balances, or unexplained variances are common. Use these diagnostic steps.

Problem: Payout amount on bank statement does not match Shopify payout Checks:

• Has the bank applied an unrelated fee to the deposit? Confirm with bank fee schedule.
• Did Shopify combine multiple payouts into a single bank deposit, or split one payout into multiple deposits? Look for payout IDs in the Payouts export.
• Is the difference due to currency conversion or FX fees? Check settlement currency and any conversion entries.

Problem: Activity report shows a negative balance Explanation:

• Negative balances occur when debits (refunds, chargebacks, fees) exceed credits in the reporting period. Shopify may draw from future sales to cover these debits, causing temporary negative balances until the next payout cycles upward. Fix:
• Investigate the transactions causing the negative balance. Document chargebacks or large refunds. If necessary, top up funds or wait for upcoming sales to offset.

Problem: Transactions missing from the activity report Checks:

• Ensure the date range covers the transaction and that you’re viewing the correct balance activity date vs transaction date.
• Confirm user permissions; some transactions may be filtered for certain roles.
• If the transaction is absent from both the activity report and Payouts, contact Shopify Support with the order/transaction ID.

Problem: Differences between activity report and Payouts export Explanation:

• Payout exports focus on payouts; the activity report focuses on balance changes. A refund may reduce balance and not correspond to a separate payout line. Fix:
• Use both reports; reconcile the activity report’s net change in balance to the sum of payouts plus/minus other adjustments.

Problem: Currency conversion issues Checks:

• Verify settlement currency for your Shopify Payments account.
• Check whether Shopify applied an automatic conversion before payout.
• Account for FX gains/losses in your books if conversion occurs.

When to contact Shopify Support

• Persistent unexplained discrepancies after checking dates, payout IDs, and bank fees.
• Missing payouts that were expected to be initiated.
• Suspected reporting errors in Shopify (rare but possible).

Security, Permissions, and Compliance Considerations

Financial reports expose sensitive data. Control access, monitor exports, and comply with local rules.

User roles and permissions

• Limit access to Finance > Documents and Payouts to finance team members and senior management.
• Implement role-based access controls in Shopify and in your accounting software.

Export policies

• Require approval for exporting financial reports and PDFs to external devices or email.
• Use password-protected storage for archived PDFs and reconciliation documents.

Handling PCI and personal data

• Ensure only authorized personnel handle transaction-level data that includes partial customer payment details. Shopify masks full card numbers, but treat exported data responsibly.
• If your reconciliation process includes customer personal information, comply with data protection regulations (e.g., GDPR) regarding local storage and retention policies.

Audit readiness

• Keep a record of who generated activity reports, the date, and the purpose. If your platform doesn’t log that automatically, maintain a manual log as part of reconciliation procedures.
• Store activity reports and related reconciling documents with your accounting records for the audit period.

Legal and tax compliance

• Use the activity report to support tax filings where required: sales tax collected, refunds issued, and processing fees captured.
• Maintain documentation for tax audits: the activity report plus payout and bank statements give a clear trail of revenue and settlements.

Advanced Tips: Using Exports in Excel and Google Sheets

Turning the raw export into a living reconciliation workbook saves time month to month.

Set up a reconciliation template

• Create a standard workbook with tabs: Activity import, Payouts import, Bank statement import, Reconciliation ledger, Variance notes.
• Use unique keys (transaction ID, payout ID) to match records across sheets.

Key formulas and tools

• SUMIFS to aggregate by transaction type and date range.
• VLOOKUP or XLOOKUP to match transaction IDs to payout IDs.
• Pivot tables to summarize fees, refunds, and sales by day or payment method.
• Conditional formatting to highlight negative balances, unmatched transactions, or high-value refunds.
• Reconciliation flag column with data validation (Matched/Outstanding/Investigate) and a dashboard showing outstanding counts and totals.

Automation suggestions

• Use Google Sheets’ IMPORT functions if you can export simplified CSVs to a URL or cloud storage.
• If using Excel, Power Query can ingest multiple CSVs and transform data each month with minimal manual steps.
• Link the workbook to your accounting system exports for one-click updates.

Sample pivot layouts

• Fees by day and by payment method (credit card brand)
• Refunds and chargebacks by order size
• Net payout amounts by payout date

Version control and backups

• Keep dated copies of reconciliation workbooks for audit trail.
• Use cloud storage with version history to recover previous months.

Real-World Examples: How Merchants Use the Activity Report

Example 1: Small consumer goods store (low volume)

• Scenario: Weekly payouts with occasional refunds.
• Use: The merchant uses the activity report weekly to reconcile Shopify clearing account. Refunds are infrequent, so reconciling the clearing account to bank deposits is a quick task. The merchant attaches the activity report to the accounting file monthly.

Example 2: Subscription-based merchant (recurring revenue)

• Scenario: Recurring charges and periodic refunds due to trial cancellations.
• Use: The activity report helps separate recurring revenue inflows from one-off chargebacks and refunds. For revenue recognition, the business records revenue on transaction dates and uses the activity report to adjust for late refunds or disputed charges.

Example 3: Marketplace seller with high refunds and chargebacks

• Scenario: Complex returns policy and frequent disputes.
• Use: The activity report exposes chargeback trends and helps the seller quantify chargeback fees by product. The finance team uses pivot tables to identify problematic SKUs and collaborates with product and customer service teams to reduce dispute rates.

Example 4: International merchant with multiple currencies

• Scenario: Sales in EUR and GBP with settlement to USD bank account.
• Use: The activity report shows converted amounts and any FX adjustments. The merchant accounts for FX gains and losses in a separate account and reconciles conversions month to month using the activity report as primary evidence.

These real-world uses show the report’s versatility across business models. The consistent theme: use the activity report as the immovable ledger of how Shopify Payments saw your balance move over a period.

Change Management: Training Your Finance Team

Rolling the activity report into your process requires team alignment.

Training checklist

• Teach how to access and generate the report from both Finance > Documents and the Payouts page.
• Review the meanings of starting/ending balance, balance activity date, and transaction date.
• Demonstrate a full reconciliation: export activity report, export payouts, pull bank statement, match, and prepare journal entries.
• Walk through common exceptions: refunds, chargebacks, combined payouts, and FX conversions.

Create a runbook

• A single‑page runbook listing steps to produce and attach the activity report, who approves the reconciliation, and where to store documents reduces onboarding time and protects institutional knowledge.

Audit-run drills

• Conduct mock audits quarterly. Have the finance team prepare a reconciliation package from the activity report and present it to a senior manager. This surface inconsistencies before external audits.

Frequently Overlooked Details

• Refund timing: Refunds processed late in a day may not appear in the payout that follows. Use the activity report’s balance date to confirm.
• Manual adjustments: Platform reimbursements may be labeled generically; track internal notes and evidence for such entries.
• Multi-entity operations: If you run several stores or legal entities, ensure the activity report is tied to the correct store and account.
• Payout holds and reserves: Shopify may withhold funds for risk reasons; an activity report will show the effect, but you may need direct Shopify communications for the rationale.
• Rounding and cent-level discrepancies: Small rounding differences can accumulate; document any rounding policy used in reconciliation.

FAQ

Q: Where exactly do I find the Shopify Payments activity report in the admin? A: Access it via Finance > Documents > Shopify Payments activity report, or generate it from the Payouts page. Select your date range and export as PDF for record-keeping.

Q: Should I use the activity report or payout exports for bank reconciliation? A: Use payout exports to match individual bank deposits. Use the activity report to reconcile how balance changes occurred during a period—opening balance, gross activity, fees, payouts, and ending balance—especially when investigating discrepancies that payouts alone cannot explain.

Q: How does the activity report handle refunds and chargebacks? A: Refunds and chargebacks appear as debits against your Shopify Payments balance in the activity ledger. Chargebacks typically include a fee entry. The report makes clear when these debits happened so you can reconcile timing differences and book the appropriate accounting entries.

Q: Can I export the activity report as CSV for import into accounting software? A: Shopify provides PDF exports. CSV export availability depends on Shopify’s current admin features. If a direct CSV is not available, export payout and transaction data from the Payouts page and use the PDF activity report as your reconciliation backup. Many merchants use apps or integrations that pull data into QuickBooks or Xero.

Q: What causes discrepancies between the activity report and my bank statement? A: Most discrepancies come from timing differences, bank fees, currency conversions, combined/split payouts, refunds/chargebacks, or manual adjustments. Use the activity report’s transaction and balance dates to identify timing issues; cross-check payout IDs and amounts against bank deposits.

Q: How often should I reconcile Shopify Payments? A: Reconcile at least monthly as part of month-end close. High-volume merchants or those with frequent refunds and disputes should reconcile weekly.

Q: Where should Shopify Payments activity sit in my chart of accounts? A: Use a clearing account called "Shopify Payments" to collect transaction-level activity. Post gross sales, refunds, and fees to appropriate income and expense accounts, then clear the clearing account when payouts match bank deposits.

Q: What if the activity report shows a negative ending balance? A: A negative balance indicates debits exceeded credits during the period (refunds, chargebacks, fees). Investigate the entries causing the negative balance; a future payout or incoming sales should typically restore a positive balance. Contact Shopify Support if you suspect an error.

Q: How long should I retain activity reports? A: Retain them according to legal and tax requirements in your jurisdiction. Keep at least the same retention period you use for bank statements and accounting records, often 7 years for tax-related documents in many countries, but check local rules.

Q: Who should have permission to generate and access the activity report? A: Limit access to finance staff and senior management. Maintain a log or policy for who can export financial data and require approvals for large refunds or manual adjustments.

Q: Can the activity report help with tax audits? A: Yes. The report provides a clear, dated trail of sales, refunds, fees, and payouts; attach it to your reconciliation package to substantiate deposits and processing activities.

Q: What if I find a mistake in the activity report? A: First, double-check date ranges, filters, and payout IDs. If the activity is missing or clearly incorrect after verification, contact Shopify Support with transaction IDs and screenshots of your reconciliation.

Q: How do multi-currency transactions appear? A: The activity report will show amounts according to your Shopify Payments balance and settlement currency. Look for FX conversion entries if Shopify settled transactions in a currency different from your bank account. Account for FX gains/losses in your books.

Q: Is there an automated way to reconcile the activity report with accounting software? A: Several third-party apps integrate Shopify Payments with accounting platforms and automate mapping fees, refunds, and payouts. Evaluate integrations for their handling of clearing accounts, FX, and chargebacks, and always validate automated imports against the activity report.

Q: What supporting documents should accompany the activity report? A: Attach the payout export, bank statement showing deposits, any chargeback notices and dispute evidence, and notes explaining manual adjustments. Keep these with your monthly reconciliation package.

Q: How should I document unusual items like large refunds or platform reimbursements? A: Include notes in the reconciliation worksheet, attach evidence (refund receipts, customer correspondence, Shopify reimbursements), and have a manager approve the resolution. Flag these in your reconciliation checklist.

Q: How does Shopify present fees in the activity report? A: Processing fees and other fees appear as debit entries against the Shopify Payments balance. The report totals fees for the period so you can book the corresponding expense.

Q: Where can I learn more about the activity report? A: Shopify’s Help Center provides official documentation on generating and interpreting the Shopify Payments activity report. Use that resource in conjunction with your own reconciliation policies for specific platform behavior.

If you need a tailored reconciliation template, a walk-through for integrating the activity report with a specific accounting system, or a checklist for month-end close that includes Shopify Payments, provide your accounting system and typical transaction volumes and I will create a step-by-step workbook and runbook you can adopt immediately.