TaxRouter Logo
BlogIntegrationsPricingAboutContact
Log inStart now
All articles
Ecommerce finance5 October 20265 min read

Which report belongs in the month-end close package for Shopify, PayPal, Stripe, and Amazon?

If your team needs one report to anchor the month-end close package, the right choice is the period-level balance or activity report—not a single payout view. Shopify, PayPal, Stripe, and Amazon each describe reports that summarize activity across a period, but they frame that reporting differently. The practical decision is to pick the report that shows starting balance, movements, and ending balance for the period you are reconciling, then use payout detail only as a supporting view when you need to trace a bank,

TaxRouter editorial team

A finance lead reviewing printed provider reports and a spreadsheet on a desk beside a laptop

The primary report should match the reconciliation question

For a month-end close package, the report you want is the one that explains how a provider balance moved over the period, not just which payout hit the bank. That means the main source should be a period-level cash-and-balance report that ties opening balance, activity, fees, payouts, and closing balance together.

That distinction matters because a payout view answers a narrower question: what was paid out, and when. A period-level report is better suited to month-end reconciliation because it shows the full movement through the provider balance, which is what finance teams usually need before they hand the package to accounting or to an external accountant.

Sources: [1], [2], [3], [6]

Shopify: use the Payments activity report

Shopify’s own description makes the choice fairly direct. The Shopify Payments activity report is meant for period-level review, month-end reconciliation, PDF record keeping, and accountant handoff. Shopify also says the report shows starting balance, gross activity, fees, payouts, net movement, and ending balance.

That combination is what makes it useful as the lead report in the close package. It covers the full period movement, so you can compare the ending balance to what you expect after fees and payouts. Shopify also notes that the activity report is not a revenue statement for accounting purposes, so it should be treated as a reconciliation report rather than a substitute for general ledger reporting.

If your team has been relying on payout summaries alone, this report gives a broader view. It lets you see the balance bridge for the period instead of looking only at a single transfer out of the provider account.

Sources: [1]

PayPal: balance first, settlement as the detail layer

PayPal draws a similar line between balance-level reconciliation and settlement detail. The Balance report is described as a tool for reconciling sales, refunds, disputes, fees, and withdrawals against end-of-day PayPal balances. PayPal also says it helps reconcile payments received with an order management system and understand payouts to bank accounts.

For a month-end close package, that makes the Balance report the more natural primary source when the goal is period-level cash and balance reconciliation. It is framed around the balance position and the components that move that balance.

PayPal’s Settlement report still has a role, but it is more detailed. PayPal says it provides transaction detail affecting settlement and summarizes debits, credits, and beginning and ending balances for each currency. In practice, that makes it useful when you need to drill into how the balance changed, especially if you reconcile in multiple currencies. It is better as a supporting schedule than as the top-line report for the package.

Sources: [2], [3]

Stripe: use balance transactions when you need the movement trail

Stripe’s balance transactions endpoint returns transaction types such as charge, refund, payout, fee, reserve, and adjustment. Stripe also notes that the list can be filtered by payout ID for automatic payouts. That makes the endpoint useful when you need the transaction trail behind a payout or a balance movement.

For a month-end close package, this is the most relevant provider source when the team needs to build or verify the detailed movement schedule. It is not presented as a single month-end statement in the evidence, so the key decision is to use it as the movement-level source that supports the period reconciliation rather than treating a payout-filtered list as the whole answer.

A hypothetical example: if your close package needs to explain why the closing balance changed after refunds, fees, and reserves, the balance transactions view can support that bridge by showing the individual transaction types that affected the balance.

Sources: [4]

Amazon: prefer the updated payment reports for period reporting

Amazon’s Reports API is the system it uses to manage reports for a selling business, and Amazon notes that it regularly adds fields and values. That means the exact report set can change over time, so the close package should rely on the current payment reporting flow rather than an old payout snapshot.

In the updated reporting flow, Amazon describes its payment reports as giving clearer visibility of accrued earnings for month-end reconciliation and financial reporting. Amazon also says the transactions are organized by posted date rather than payout date. For a finance lead, that posted-date view is the more useful one when the objective is to reconcile a period, because it groups activity by when it was recorded in the report, not only when cash was paid out.

So for Amazon, the main choice is the updated payment report that reflects accrued earnings and posted-date organization. That is the report most aligned with a month-end close package built around period-level reconciliation.

Sources: [5], [6]

How to decide what sits in the close package

Across these providers, the same pattern appears: choose the report that shows balance movement for the period, then keep payout detail as a supporting attachment if you need it to explain a bank transfer. The close package is usually stronger when it starts with one primary period report and then includes supporting views only where they add traceability.

A practical way to structure the package is to ask three questions. First, does the report show opening balance, activity, and ending balance? Second, does it capture the items that move that balance, such as fees, refunds, reserves, and payouts? Third, does the provider describe it as a reconciliation or month-end reporting tool? If the answer is yes, it belongs near the front of the package.

For the specific providers in this question, the best fit is Shopify Payments activity report, PayPal Balance report, Stripe balance transactions, and Amazon’s updated payment reports. Those are the sources that line up with a period-level cash-and-balance reconciliation, rather than a single deposit or payout view. This article provides general information and is not tax or legal advice.

Sources: [1], [2], [4], [6]

Sources

  1. [1] Shopify Payments payouts activity reportShopify Help Center
  2. [2] Balance reportPayPal Developer
  3. [3] Settlement reportPayPal Developer
  4. [4] List balance transactionsStripe Docs
  5. [5] Reports APIAmazon Developer Docs
  6. [6] Updated payment reports discussionAmazon Seller Central

Sources checked: 5 October 2026

TaxRouter

Bring your sales data and bookkeeping together

Create your workspace
TaxRouter Logo

Bring e-commerce data together and move it reliably into DATEV.

Follow TaxRouter

LinkedIn

Product

  • Blog
  • Solutions
  • Integrations
  • Pricing
  • Alternatives
  • How TaxRouter works

Company

  • About
  • Contact

Legal

  • Privacy Policy
  • Terms of Service
  • Security & Data Handling
  • Data Processing Addendum
  • Subprocessors
  • Technical and Organizational Measures
  • Imprint

Copyright 2026 TaxRouter. All rights reserved.