How to use this template
- Download the CSV. Every sample uses [EXAMPLE] descriptions and EXAMPLE- references (not real Stripe IDs).
- Record each charge as positive Income (gross). Record the Stripe fee as a separate negative Expense.
- Record refunds as negative Expense (or a Refunds category), not as deleted charges.
- When Stripe pays out, record a negative Transfer on Stripe Balance and a positive Transfer on the destination bank account if you track both.
- Put Stripe’s object id (ch_, re_, po_, py_) in Reference once you replace the examples.
- Do not collapse a charge and its fee onto one net line if you want fee reports to stay accurate.
Example rows
Fictional Stripe-style activity only. IDs like ch_example_91 are placeholders, not live Stripe objects.
| Sample | Date | Description | Amount | Currency | Category | Type | Account | Reference |
|---|---|---|---|---|---|---|---|---|
| Example | 2026-05-01 | [EXAMPLE] Charge — Pro monthly plan | 29.00 | USD | Revenue | Income | Stripe Balance | EXAMPLE-CH-91 |
| Example | 2026-05-01 | [EXAMPLE] Stripe processing fee | -1.14 | USD | Fees | Expense | Stripe Balance | EXAMPLE-FEE-91 |
| Example | 2026-05-02 | [EXAMPLE] Charge — Pro annual plan | 290.00 | USD | Revenue | Income | Stripe Balance | EXAMPLE-CH-92 |
| Example | 2026-05-02 | [EXAMPLE] Stripe processing fee | -8.71 | USD | Fees | Expense | Stripe Balance | EXAMPLE-FEE-92 |
| Example | 2026-05-03 | [EXAMPLE] Refund — Pro monthly plan | -29.00 | USD | Refunds | Expense | Stripe Balance | EXAMPLE-RE-12 |
| Example | 2026-05-04 | [EXAMPLE] Payout to Checking *4821 | -280.15 | USD | Payout | Transfer | Stripe Balance | EXAMPLE-PO-44 |
| Example | 2026-05-04 | [EXAMPLE] Stripe payout received | 280.15 | USD | Payout | Transfer | Checking *4821 | EXAMPLE-PO-44-BANK |
| Example | 2026-05-06 | [EXAMPLE] Charge — usage overage | 12.40 | USD | Revenue | Income | Stripe Balance | EXAMPLE-CH-93 |
The downloaded file contains only the eight data columns. The Sample label is shown here so example rows stay obvious on the page.
Usage guidance
- Stripe Balance is the Account for in-platform activity. Your checking account is a different Account used only for payouts.
- Currency should match the charge currency. Multi-currency accounts need separate rows, not mixed Amounts without a code.
- Disputes and partial refunds get their own rows on the date Stripe posted them.
- If you already have a Stripe CSV, map their columns into this template, or convert a statement PDF then remap.
- Import the cleaned file into BudgetPilot so subscription revenue and fees sit in the same workspace as the rest of the business.
Convert a statement, then import
Starting from a PDF or a bank-specific export? Use the bank statement converter to get a CSV, map it onto these columns, then create a free BudgetPilot account to import the file into a workspace.
Other CSV templates
- Bank statement CSV template — A simple, BudgetPilot-ready layout for reconstructing a checking or savings statement when your bank export is messy, incomplete, or locked in PDF.
- Freelancer transaction CSV template — A bookkeeping-friendly CSV for independent contractors who get paid by invoice and pay for tools, coworking, and estimated taxes from a business account.
- PayPal transaction CSV template — A seller-friendly CSV that separates PayPal receipts, platform fees, buyer refunds, and withdrawals to your bank so balances reconcile.