Stripe to QuickBooks Online CSV Converter (Free, Private)

Stripe → QuickBooks Online in three steps

The cleanest way to get Stripe into QuickBooks Online is to treat Stripe like a bank account. Stripe collects your sales, takes its fees and then pays out the rest. Import that activity into a “Stripe Clearing” account and your books show gross income, real fees and payouts that match your checking deposits.

1. How to export your Stripe balance and payout reports

In the Stripe Dashboard open Reports → Balance summary and set the date range (for example, last month).
In the Balance change from activity section click Export, choose CSV and the Itemized format, keep the default columns, then download.
In the Payouts section click Export → CSV → Itemized for the same period.
Drop both files into the converter together. They are merged into one statement, so charges, fees, refunds and payouts all land in the same clearing account.

The itemized activity report excludes payouts by design, which is why you also add the payouts file. Older Dashboard “Balance → Export” files (columns like Created (UTC), Amount, Fee, Net) are detected too.

2. Convert it here

Drop the file into the converter above. The source is detected from the column headers, and the summary shows money in, money out and the net change so you can sanity-check against Stripe's own totals before downloading.

3. How to import the file into QuickBooks Online

Create a bank-type account for Stripe Clearing first: Settings ⚙ → Chart of accounts → New, account type Bank, name it “Stripe Clearing”. This holds your Stripe balance, the way a real bank account would.

Go to Transactions → Bank transactions. If you see a tile for Stripe Clearing, select it.
Select Link account ▼ → Upload from file (or Upload transactions if the account isn't connected to online banking).
Drag in the converted CSV and select Continue, then choose the Stripe Clearing account.
Map the columns: Date → Date, Description → Description, and Amount as one column with both positive and negative values (3-column file), or Credit/Debit as two columns (4-column file). Confirm the date format matches your choice in this tool.
Select the transactions to import, then Continue → Yes → Done. Categorize them in the For review tab. Bank rules (e.g. description contains “fee” → Merchant fees) save a lot of clicks.

QuickBooks Online accepts CSV uploads in English, up to 350 KB and 1,000 lines per file, with either 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit). Zero amounts must be blank, and every date must use the same format. The converter applies all of this and splits large outputs into 1,000-row parts.

What each Stripe row becomes

Stripe row	In the QuickBooks file	Typical category
charge	Gross amount as money in, plus a separate processing-fee line	Sales / Income and Merchant fees
refund	Money out	Refunds / contra-income
dispute / dispute_reversal	Disputed amount out, dispute fee out; reversals back in	Chargebacks; Merchant fees
fee (Billing, Radar, Tax, etc.)	Money out	Software / merchant fees
payout (from the Payouts file)	Money out of the clearing account	Transfer to your checking account (not an expense!)
other_adjustment, contribution, network_cost…	Signed as Stripe reports them	Review case by case

The QuickBooks format we produce

Column	Contents
`Date`	One consistent format (MM/DD/YYYY or DD/MM/YYYY)
`Description`	Text: platform, type, item/customer and the reference ID
`Amount`	Signed: positive = money in, negative = money out (3-column)
`Credit / Debit`	Positive numbers in one column each, the other left blank (4-column)

Stripe quirks the converter handles

Stripe reports gross, fee and net in major units (dollars), with net = gross − fee. Every row is checked, and you get a warning if a row doesn't add up.
Payout sign conventions differ between Stripe exports. Payouts always come out as money leaving the Stripe clearing account.
Failed or cancelled payouts are skipped automatically.
If you use more than one settlement currency, export one currency at a time. The converter warns you if a file mixes currencies.

Avoid double-counting. When the payout reaches your bank, QuickBooks will also see it in your checking account's feed. Record that as a transfer from Stripe Clearing, not as income. The sales were already recorded from this file.

FAQ

Do my Stripe files get uploaded anywhere?

No. The conversion runs entirely in your browser with JavaScript, and the file is never sent to a server. You can check this by loading the page, switching off your Wi-Fi and converting a file. It still works. We don't use analytics or tracking scripts either.

Why are fees on separate lines instead of netted?

Your Stripe payout is gross sales minus fees. Recording both lets your books show true gross income (which is what a 1099-K reports) and a deductible fee expense. If you prefer net amounts, untick “Split fees into separate lines” in Options.

Won't this double-count income that already shows up in my bank feed?

Not if you use the clearing-account method. The Stripe statement goes into a “Stripe Clearing” account in QuickBooks. When Stripe pays out, the payout line leaving Stripe Clearing is matched as a transfer to the deposit in your checking account, so it isn't booked as new income.

What date format should I choose?

US companies normally use MM/DD/YYYY. Intuit's own guide recommends DD/MM/YYYY for regions that write day-first. What matters is that every row uses the same format and that you confirm it on the mapping screen.

Is it free?

Files that produce up to 20 rows convert and download for free, and you can preview any file. Bigger files need a Pro pass. You can download the first 20 rows to test the import before you buy.

Other converters

Last reviewed October 2026. Platform menus change from time to time. If a step looks different for you, email support@payouttobooks.com and we'll update the guide.

Convert Stripe CSV to QuickBooks Online

Stripe → QuickBooks Online in three steps

1. How to export your Stripe balance and payout reports

2. Convert it here

3. How to import the file into QuickBooks Online

What each Stripe row becomes

The QuickBooks format we produce

Stripe quirks the converter handles

FAQ

Other converters

Simple pricing

Free

30-day pass

Pro monthly

Pro annual