Which Stripe Report Should You Use for Bookkeeping?

TL;DR

When exporting financial data from Stripe for bookkeeping in QuickBooks Online or Xero, you must use the Balance change from activity (Itemized) report located under Reports → Balance.

Do not use the standard Payments export (under the Payments tab) or the aggregate All Activity summary:

• The Payments export only tracks charge attempts. It completely ignores bank payouts, processing fee refunds, and dispute holds, making bank reconciliation impossible.
• The Balance Summary provides high-level monthly aggregates, but lacks individual transaction rows required for bank feeds.
• The Balance change from activity (Itemized) report is the only export containing every transaction type—gross sales, processing fees, refunds, dispute adjustments, and bank payouts—needed to maintain an audit-ready double-entry ledger.

Because raw Stripe itemized reports contain dozens of metadata columns and UTC timestamps that QuickBooks rejects, use PayoutPrep to convert the export into an import-ready CSV in seconds.

---

The Stripe Reporting Maze: Why Most Bookkeepers Start with the Wrong File

Stripe provides powerful reporting tools, but its dashboard is built primarily for developers and software platforms rather than accountants. Across the navigation menu, you will encounter multiple export buttons:

• In the Payments tab, an Export button downloads customer transactions.
• In the Payouts tab, an export button outputs bank transfers.
• In the Reports section, multiple menus offer Balance, Financial Reports, and Revenue Recognition.

Downloading the wrong CSV report is the leading cause of bookkeeping errors, duplicate revenue entries, and unbalanced clearing accounts. Understanding what each report contains—and what it leaves out—is essential to maintaining clean financial statements.

---

Comparing the Three Primary Stripe Financial Reports

To understand why only one report satisfies double-entry bookkeeping standards, review this direct comparison:

Feature / Data Point	Payments Export (payments.csv)	Balance: All Activity Summary	Balance Change from Activity (Itemized)
Location in Stripe	Payments → Export	Reports → Balance → Summary	Reports → Balance → Itemized
Gross Customer Sales	Yes	Yes (Aggregate total only)	Yes (Itemized row per charge)
Merchant Processing Fees	Yes (Estimated per charge)	Yes (Aggregate total only)	Yes (Exact fee charged per event)
Bank Payout Details	❌ No	Yes (Aggregate total only)	Yes (Itemized with payout IDs)
Customer Refunds	Partial (Initial charge status)	Yes (Aggregate total only)	Yes (Itemized with fee credits)
Disputes & Chargeback Holds	❌ No	Yes (Aggregate total only)	Yes (Itemized reserve changes)
Double-Entry Compliant	❌ No	❌ No (Too aggregated)	✅ Yes (Full ledger audit trail)
Direct Import to QuickBooks	❌ No	❌ No	✅ Yes (After standard formatting)

Let’s examine each report in detail to evaluate its specific bookkeeping role.

---

Report 1: Balance Change from Activity (Itemized) — The Gold Standard

If you are performing monthly bookkeeping, reconciling a clearing account, or preparing annual tax filings, this is the only report you should download.

Where to Find It

In your Stripe Dashboard:

1. Click Reports in the top navigation bar.
2. Select Balance from the left sidebar.
3. Scroll to the card titled Balance change from activity.
4. Click Download, select Itemized, configure your date range, and export the CSV.

Why It Is Essential for Double-Entry Accounting

Double-entry bookkeeping requires that every dollar entering or leaving your business be accounted for. The Itemized Balance report acts as Stripe’s general ledger. It documents every single event that affects your Stripe balance:

1. Gross Customer Charges: Each payment appears on its own row with customer identifiers and descriptions.
2. Individual Processing Fees: Every deduction by Stripe (interchange fees, percentage take, fixed per-transaction fees) is explicitly tracked against each charge.
3. Refunds and Fee Credits: When a customer is refunded, the report records the cash outflow and any processing fees returned by Stripe.
4. Disputes and Inquiries: If a customer disputes a charge, the itemized report shows the disputed amount held from your balance alongside non-refundable dispute fees.
5. Bank Payout Transfers: Each transfer of accumulated funds to your physical bank account is logged with its unique payout identifier (e.g., po_1Nxxxxxxxx).

Without this comprehensive ledger, your QuickBooks registers cannot reflect the movement of funds from customer credit cards into your checking account.

Key Columns in the Itemized Report

When you open this CSV in a spreadsheet editor, several critical columns stand out:

• balance_transaction_id: The unique ledger transaction ID (e.g., txn_1ABC...).
• created (UTC): The exact timestamp when the transaction occurred.
• reporting_category: The classification of the row (charge, refund, fee, payout, dispute).
• gross: The full customer payment before fee deductions.
• fee: The merchant processing fee subtracted by Stripe.
• net: The actual cash impact on your Stripe balance (gross - fee).
• description: Customer-facing notes, product titles, or invoice references.

---

Report 2: Payments Export — Why It Creates Unbalanced Books

The Payments export (accessed by clicking Payments in the main sidebar and clicking Export) is the report most business owners instinctively download. However, relying on it for accounting leads to severe problems.

What the Payments Export Includes

The Payments export is designed for sales and marketing teams. It includes customer email addresses, card brands (Visa, Mastercard, Amex), country codes, and payment status indicators (succeeded, failed, requires_action).

What Is Critically Missing

Despite its popularity, the Payments export leaves significant gaps:

1. Zero Payout Information: It contains no payout IDs, transfer dates, or bank deposit totals. You cannot reconcile your physical bank account using this report.
2. Ignores Subsequent Balance Events: If a payment succeeded on October 15 but was refunded on October 28, the Payments export often shows the payment record without reflecting the refund as an independent accounting transaction.
3. Omits Non-Payment Fees: Account-level fees (such as Stripe Radar fraud fees, Invoicing fees, Tax calculation fees, or dispute fees) do not stem from individual charges and are omitted from this export.
4. No Balance Continuity: It does not track running cash balances, making it impossible to determine starting or ending balances for monthly reconciliations.

When to Use the Payments Export

Use the Payments export exclusively for commercial analytics: analyzing customer acquisition channels, evaluating declined card rates, or auditing subscription churn. Keep it out of your general ledger.

---

Report 3: Balance Summary (All Activity) — When to Use It

The Balance Summary report (found under Reports → Balance → Summary) aggregates all transactions over a given period into high-level totals.

What the Balance Summary Includes

Rather than thousands of transaction rows, the Summary report produces a concise statement showing:

• Starting balance for the period
• Total gross sales
• Total Stripe processing fees
• Total refunds issued
• Total dispute adjustments
• Total payouts transferred to your bank
• Ending balance for the period

Why It Cannot Be Uploaded to Bank Feeds

QuickBooks Online requires individual transaction dates, descriptions, and amounts to populate bank feeds. Because the Summary report contains no individual dates or line items, QuickBooks Online will reject the file if you attempt to upload it as a bank CSV.

How Bookkeepers Should Use It

The Balance Summary is an indispensable verification tool. When closing your books:

1. Import and categorize your itemized activity into your QuickBooks clearing account.
2. Open Stripe’s monthly Balance Summary.
3. Compare the summary totals (gross sales, fees, and ending balance) against your QuickBooks Profit & Loss and Balance Sheet.
4. If the figures match, your books are mathematically verified.

For an in-depth guide on matching payout transfers to bank feeds, see our article on how to reconcile Stripe payouts with your bank in QuickBooks.

---

Step-by-Step: How to Export the Itemized Balance Report Correctly

To ensure your data aligns with your accounting periods, follow these configuration steps in Stripe:

1. Set the Correct Reporting Timezone

By default, Stripe exports data in UTC. If your business operates in New York (EST) or Los Angeles (PST), transactions occurring late in the evening on the last day of the month will register as the first day of the next month in UTC.

• In the Stripe Dashboard, click Settings (⚙️) → Business settings.
• In the export dialog under Reports → Balance, verify that your timezone dropdown aligns with your bookkeeping calendar.

2. Configure Date Ranges

Set your date filter to cover a complete accounting period:

• For monthly reconciliations, select Custom and enter the first and last days of the calendar month (e.g., 2026-10-01 to 2026-10-31).
• Avoid overlapping date ranges, which create duplicate entries in QuickBooks.

3. Choose the “Itemized” Download Option

Under Balance change from activity:

• Click Download.
• In the modal window, make sure Itemized is selected.
• Under Columns, leave the default selection active.
• Click Download CSV.

---

Transforming Stripe’s Raw Export for QuickBooks Online

Once you have downloaded the Balance change from activity (Itemized) report, you cannot upload it into QuickBooks Online immediately. If you try, QuickBooks Online will reject it:

1. Too Many Columns: Stripe includes over 30 columns. QuickBooks Online only accepts 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit). Learn more in our breakdown of QuickBooks CSV 3-column vs 4-column formats.
2. UTC Timestamps: Stripe dates include time strings (e.g., 2026-10-18 14:22:10 UTC), which trigger date parsing errors. See our guide on how to fix QuickBooks CSV date format errors.
3. Combined Gross & Fee Rows: Stripe records gross amounts and processing fees on the same row. QuickBooks bank feeds require fees and sales to exist on separate lines to categorize income and expenses accurately.
4. Row Limits: QuickBooks Online caps manual CSV imports at 1,000 transaction rows per file.

PayoutPrep automates this transformation: it splits fees onto separate rows, strips timestamps into standard calendar dates, and automatically partitions large files into clean 999-row batches.

---

Related Guides and Resources

• How to Import Stripe Transactions into QuickBooks Online
• How to Reconcile Stripe Payouts with Your Bank in QuickBooks
• Fix ‘The date format you chose doesn’t match’ in QuickBooks
• QuickBooks CSV Format: 3-Column vs 4-Column Explained

---

Clean Up Your Stripe Bookkeeping Today

Stop guessing which Stripe report to download and wasting hours untangling mismatched accounts.

PayoutPrep takes your Balance change from activity (Itemized) report and instantly produces import-ready CSV files tailored for QuickBooks Online:

• 100% Client-Side Privacy: Runs locally in your browser; your transaction data is never uploaded to any server.
• Accurate Double-Entry Splits: Automatically separates gross income, merchant fees, refunds, and payout transfers.
• Error-Free Formatting: Generates clean dates, compliant column structures, and enforces QuickBooks row limits.

Ready to import your Stripe transactions cleanly? Convert your Stripe CSV →