How to Reconcile Your Stripe Payouts for Bookkeeping

Why Stripe Payout Reconciliation Matters

Stripe processes payments for millions of online businesses, but its payout structure creates a unique bookkeeping challenge. Unlike marketplaces that send a single settlement per period, Stripe batches charges, refunds, and fees into daily or weekly payouts — each containing dozens or hundreds of transactions.

If you simply record the net deposit in your bank account, you're missing the detail your clients need for accurate P&L reporting, sales tax compliance, and audit readiness. Proper reconciliation means breaking every payout into its component parts: gross sales, processing fees, refunds, disputes, and adjustments.

Anatomy of a Stripe Payout Report

When you export payout data from Stripe, you'll typically work with the Payout reconciliation report from the Stripe Dashboard. Key columns include:

Column	Description
payout_id	Unique identifier for the bank transfer
created	Date the transaction was processed
type	charge, refund, adjustment, stripe_fee, dispute, etc.
gross	Original transaction amount before fees
fee	Stripe processing fee for this transaction
net	Amount after fees (gross − fee)
currency	Transaction currency code
description	Customer-facing charge description

Each payout groups all transactions that were batched together for a single bank deposit. The sum of the net column for a payout ID equals the amount deposited into the bank account.

Understanding Stripe Fee Types

Stripe charges several types of fees. Mapping these correctly is critical for accurate expense reporting.

Per-Transaction Fees

• Processing fee: 2.9% + $0.30 per successful charge (standard US pricing)
• International card fee: Additional 1.5% for cross-border transactions
• Currency conversion fee: Additional 1% when converting currencies

Dispute and Adjustment Fees

• Dispute fee: $15.00 per chargeback (non-refundable even if you win)
• Dispute reversal: −$15.00 credit if the dispute is resolved in your favor (fee portion only)

Other Fees

• Stripe Radar (fraud prevention): $0.05–$0.07 per screened transaction
• Stripe Tax: per-transaction fee if using automatic tax collection
• Connect platform fees: applicable if using Stripe Connect for marketplace payouts

Worked Journal Entry Example

Suppose a weekly Stripe payout contains the following activity:

Category	Amount
Gross charges (12 transactions)	$4,280.00
Processing fees	−$155.42
Refund (1 order)	−$89.00
Dispute (1 chargeback)	−$150.00
Dispute fee	−$15.00
Net payout	$3,870.58

The journal entry to record this payout:

Account	Debit	Credit
Bank Account (checking)	$3,870.58
Stripe Processing Fees	$155.42
Refunds & Returns	$89.00
Chargeback Losses	$150.00
Dispute Fees	$15.00
Sales Revenue		$4,280.00
Totals	$4,280.00	$4,280.00

The entry balances: total debits equal total credits. The bank deposit matches the net payout, and every fee and adjustment is categorized for reporting.

How to Download Your Stripe Payout Data

1. Log in to the Stripe Dashboard
2. Navigate to Balance > Payouts
3. Click the payout you want to reconcile (or select a date range)
4. Click Export and choose CSV
5. Select the columns you need (include at minimum: payout_id, type, gross, fee, net)
6. Download the file

For bulk reconciliation, use the Reports section under Business > Reports > Payout reconciliation to download data spanning multiple payouts.

Importing into Your Accounting Software

QuickBooks Online

Use the SettleBooks Stripe converter to transform your payout CSV into QBO-compatible journal entries. Upload the file, review the mapped categories, and export as IIF (Desktop) or CSV (Online) for direct import.

Xero

Export as a Xero-formatted CSV from SettleBooks. In Xero, go to Accounting > Manual Journals > Import and upload the file. Each payout becomes a single balanced journal entry.

Sage

Export as a Sage CSV from SettleBooks. Import via Transactions > Journal Entries > Import. SettleBooks maps Stripe fee categories to Sage nominal codes automatically.

Edge Cases to Watch For

Disputes and Chargebacks

A dispute temporarily removes funds from your balance. If you win the dispute, the charge amount is returned but the $15 dispute fee is not refunded. Track disputes in a separate liability account until resolved, then reclassify.

Stripe Connect (Platform/Marketplace)

If your client uses Stripe Connect, payouts may include application fees collected from connected accounts. These need separate revenue classification — they're platform income, not product sales.

Multi-Currency Transactions

Stripe converts foreign currencies at the time of charge. The fee column includes the currency conversion fee. If your client's books are in USD but they accept EUR, the converted amount is what hits the payout — but you may need to track exchange rate differences for tax purposes.

Partial Refunds

Stripe shows partial refunds as a separate refund line with the partial amount. The original processing fee is not refunded on partial refunds (only on full refunds does Stripe sometimes return the fee — and only on certain plans).

Recommended Chart of Accounts

Stripe Category	Account Name	Account Type
Gross charges	Sales Revenue	Income
Processing fees	Stripe Processing Fees	Expense
Refunds	Refunds & Returns	Contra-Revenue
Disputes (charge)	Chargeback Losses	Expense
Dispute fees	Dispute Fees	Expense
Connect app fees	Platform Fee Income	Income
Net payout	Bank Account	Asset

Automate Your Stripe Reconciliation

Manually categorizing hundreds of Stripe transactions per payout is tedious and error-prone. SettleBooks parses your Stripe payout export, maps every transaction to the correct accounting category, and produces balanced journal entries ready for import.

Convert your Stripe payout report now →