How to import Stripe transactions to Quickbooks

Stripe and QuickBooks both contain the information you need, but a Stripe payments export isn't formatted for direct import into QuickBooks.

BalanceFlow sits between the two: export your transactions from Stripe, convert the CSV using a reusable template, then upload the resulting file to QuickBooks.

Once you've done it once, the same workflow can be reused for your next export.

The workflow

Importing Stripe transactions with BalanceFlow has three main steps:

Stripe → BalanceFlow → QuickBooks

First, export the transactions you need from Stripe. Then use BalanceFlow to convert the Stripe CSV into a format suitable for QuickBooks. Finally, upload the converted file through QuickBooks Bank transactions.

The important part is choosing how you want Stripe transactions represented in your books before you start.

1. Export your transactions from Stripe

Start by downloading a CSV of your payments from Stripe.

BalanceFlow's built-in Stripe templates expect particular fields from the Stripe export. Stripe may remember changes you've previously made to its export settings, so check the selected fields rather than assuming every export has the same structure.

Follow Prepare a Stripe CSV for QuickBooks import for the exact fields and export settings.

[SCREENSHOT: Stripe Payments export dialog with the fields required by BalanceFlow selected. Show the date range and export controls clearly.]

2. Decide how you want to handle Stripe fees

BalanceFlow includes two Stripe to QuickBooks templates.

The right one depends mainly on how you want processing fees represented.

Net import

The Stripe to QuickBooks Net template keeps each Stripe transaction as a single output row.

It calculates the values needed for the import while retaining the payment, refund, and fee information in the converted file.

This is the simpler option when you don't need the Stripe fee represented as its own transaction.

Split-fee import

The Stripe to QuickBooks Split Fee template separates the payment and Stripe processing fee into different rows.

This makes the fee visible as a separate accounting entry rather than hiding it inside the net amount.

See How to split Stripe fees for QuickBooks import for a closer look at this workflow.

If you need a different CSV structure, you can also create a custom QuickBooks import template.

3. Convert the Stripe CSV

In BalanceFlow, create a new conversion and select the template you want to use.

Upload the Stripe CSV and choose how its columns should be matched.

By position uses the column order expected by the template and is the default option. By header identifies the required fields by their names, allowing them to appear in a different order.

Click Next when the file is ready.

[SCREENSHOT: BalanceFlow Create Conversion page with a Stripe to QuickBooks template selected, Match input columns visible, a Stripe CSV uploaded, and the Next button visible.]

4. Check the conversion

Before processing the complete file, you can preview the result.

This is useful the first time you use a template or whenever you've changed your Stripe export settings. Check a few transactions to make sure dates, amounts, refunds, and descriptions look as expected.

When you're ready, run the conversion.

[SCREENSHOT: BalanceFlow conversion preview showing several original Stripe transactions and their converted QuickBooks output. Choose rows that make the transformation easy to understand.]

5. Download the converted CSV

Once processing is complete, BalanceFlow makes the converted CSV available for download.

Your original Stripe export remains unchanged. The downloaded file contains the transformed data you'll use for the QuickBooks import.

[SCREENSHOT: Completed BalanceFlow conversion showing Status: Completed, the processed filename, and Download File button.]

6. Upload the file to QuickBooks

In QuickBooks Online, open Bank transactions and choose the option to Upload from file.

Select the CSV produced by BalanceFlow and choose the QuickBooks account where the transactions should be imported.

QuickBooks will then ask you to match the CSV columns with its transaction fields. Review the mapping before continuing.

Intuit currently supports CSV files using either a three-column format - Date, Description and Amount - or a four-column Credit/Debit format. QuickBooks

[SCREENSHOT: QuickBooks Online Bank transactions → Upload from file screen with a BalanceFlow-generated CSV selected.]

[SCREENSHOT: QuickBooks CSV column-mapping screen showing the BalanceFlow Date, Description, and Amount columns mapped to their corresponding QuickBooks fields.]

Review the transactions before adding them to your books, particularly if the same period already contains transactions from another import or connected bank feed.

For the QuickBooks side of the process in more detail, see our QuickBooks import guide.

Importing historical Stripe transactions

CSV import is also useful when you're moving historical Stripe activity into QuickBooks.

When you connect an account directly to QuickBooks, the amount of historical data QuickBooks can retrieve is limited. Intuit currently says connected accounts can provide anywhere from around 90 days to 24 months, depending on the financial institution. QuickBooks

That doesn't mean QuickBooks can't contain older transactions.

Intuit specifically supports manual uploads for transactions from earlier periods. A CSV therefore provides a practical way to import older Stripe activity that isn't available through a connected feed. QuickBooks

For a large history, you'll need to work in batches. QuickBooks currently allows up to 1,000 transaction lines in a single manual upload, and Intuit recommends shortening the date range for larger imports. QuickBooks

BalanceFlow can prepare those exports using the same transformation rules as your current transactions, so you don't need a separate spreadsheet process just because the data is older.

See Import historical Stripe transactions for the complete historical-import workflow.

Using a Stripe clearing account

If you process a meaningful number of Stripe transactions, importing individual payments directly against your checking account may not match what actually happens in Stripe.

Stripe collects customer payments, deducts fees and refunds, and later sends payouts to your bank. A clearing account can be used to keep that activity separate until the Stripe payout reaches your checking account.

That can make reconciliation easier, particularly when you're using the split-fee workflow.

See Using a clearing account for Stripe reconciliation for the full setup and workflow.

Once it's set up, the process stays the same

The initial setup takes a little more attention because you need to choose the right accounting workflow and make sure the Stripe export contains the expected fields.

After that, there isn't much to remember:

Export from Stripe → upload to BalanceFlow → run the conversion → import into QuickBooks.

The same template applies the same transformation rules each time.