Kayabyte

Stripe payouts reconciliation

By Kayabyte · Last updated 29 October 2026

Stripe pays out your balance on a schedule, so the amount in your bank is not the amount of your sales. Stripe has two reports for this, and each downloads as CSV. Labels change, so treat them as a guide.

1. Choose the report

In the Dashboard open Reports, choose the report and period, and use Download on a section to get the CSV.

2. Reconcile by hand

In the balance CSV, add a Category column: charges are sales, Stripe fees are payment fees, refunds reduce sales, disputes and their fees are adjustments, payouts are money movement. The starting balance plus the sum of all rows should equal the ending balance. For payouts, the batch should sum to the bank deposit.

3. Book it

Post a journal per period with a Stripe clearing account: sales and refunds, fees by type, and the payout to the bank. The clearing account should end the period at the Stripe balance.

4. Where Balanced helps

Balanced reads a Stripe balance or payout CSV on your Mac. Each row gets a category by rules, and the check compares a payout to the sum of its lines and the running balance where the file has one. Export a categorised CSV, Excel, a category summary, a Xero manual journal or QuickBooks Online journal entries, Beancount or Ledger.

Honest limits: report layouts change, so check the preview and the category totals; Balanced does not log in to your account or fetch anything, you download the file yourself; the Schedule C worksheet is a suggested grouping, not tax advice, so check it with your tax professional or accountant.

Download Balanced and try it free: the free version reads and checks everything and exports the first 10 lines per file, so you can test your own report before paying. Pro is USD 59 per year or USD 7.99 per month, for up to 3 Macs. See pricing and the help page. macOS 14 or later.