Stripe net import

The Stripe to QuickBooks Net template turns a Stripe payments export into a simpler CSV that can be imported into QuickBooks.

It keeps each Stripe transaction as a single row and calculates the net amount after refunds and Stripe fees. Along the way, it also converts dates, handles Stripe's converted-currency fields, and reduces the export to the information useful for the QuickBooks import.

If you want Stripe fees to appear as separate transactions instead, use the Stripe to QuickBooks Split Fee template.

What the template produces

Stripe exports contain many fields that aren't needed for a typical QuickBooks bank transaction import. The Net template takes the relevant information and produces seven output columns:

Date · Description · Net Amount · Amount · Refund · Fee · Customer

Each source transaction produces one output row.

The original Stripe export isn't modified. BalanceFlow creates a new CSV containing the converted data.

Transformations applied by the template

The template isn't a black box. Each output column is built from fields in the Stripe export using a defined set of rules.

You can review these rules in the template editor and, on plans that support template customization, adjust them for your own workflow.

Date

Stripe provides the transaction creation time as Created date (UTC).

BalanceFlow converts this timestamp from UTC to your timezone and then formats the date as:

MM/DD/YYYY

The resulting value is written to the Date column.

This means the QuickBooks file uses the local transaction date rather than leaving the timestamp in UTC.

[SCREENSHOT: Stripe to QuickBooks Net template editor showing the Created date (UTC) → Date mapping. Include the "Convert from UTC" operation with the user's timezone and the "Date and time format" operation showing MM/DD/YYYY.]

Description

The Stripe Description field is copied to the output Description column.

When the source description is empty, the template uses:

Stripe balance transaction

This avoids producing transactions with a completely empty description.

[SCREENSHOT: Template editor showing Description → Description and the fallback value "Stripe balance transaction".]

Net Amount

Net Amount represents the amount remaining after refunds and Stripe fees.

The template starts with Stripe's Converted Amount. If that field is empty, it falls back to Amount.

It then accounts for the refunded amount and fee to produce the net value for the transaction.

The final amount is normalized to a standard decimal format before being written to the output CSV.

Using the converted amount first is important when Stripe has performed currency conversion. When there is no converted value, the original amount provides the fallback.

[SCREENSHOT: Template editor showing the complete Converted Amount → Net Amount mapping. Include the fallback to Amount, refund and fee operations, and decimal amount normalization.]

Amount

The Amount column contains the original transaction amount used for the accounting entry.

BalanceFlow first looks at Converted Amount. If it is empty, it uses Amount instead.

The result is normalized to a decimal amount before being written to the CSV.

[SCREENSHOT: Template editor showing Converted Amount → Amount, including the fallback to Amount and decimal amount normalization.]

Refund

Refunds follow the same converted-currency logic.

BalanceFlow uses Converted Amount Refunded when available. If it is empty, it falls back to Amount Refunded.

The value is then normalized and written to the Refund column.

This keeps the transaction amount and refund amount based on the same currency representation whenever Stripe provides converted values.

[SCREENSHOT: Template editor showing Converted Amount Refunded → Refund, including the fallback to Amount Refunded and decimal amount normalization.]

Fee

Stripe's Fee value is written to the Fee column and normalized to a decimal amount.

If the fee field is empty, the template uses 0.

[SCREENSHOT: Template editor showing Fee → Fee, including the fallback value of 0 and decimal amount normalization.]

Customer

The Stripe Customer Email field is used for the output Customer column.

If no customer email is available, the template uses Stripe instead.

This gives the imported transaction a useful customer value even when the Stripe payment isn't associated with an email address.

[SCREENSHOT: Template editor showing Customer Email → Customer and the fallback value "Stripe".]

Why converted amounts are used first

Stripe exports can contain both the original transaction values and converted values.

The template prefers Converted Amount and Converted Amount Refunded where they're available. This is useful when the currency charged to the customer differs from the currency in which Stripe settles the transaction.

When those fields are empty, BalanceFlow falls back to Amount and Amount Refunded.

This also keeps the amount calculations consistent with Stripe's fee information, which is associated with the settlement currency.

For more information about getting the correct source file from Stripe, see Prepare a Stripe CSV for QuickBooks import.

Matching the Stripe export

When creating a conversion, you can choose how BalanceFlow identifies columns in the uploaded CSV.

By position is the default and expects the columns to appear in the order defined by the template. This is the quickest option when you're using the expected Stripe export format.

By header uses the column names instead. This allows the expected source columns to appear in a different order.

Stripe can remember previous export settings, so it's worth checking your export if you've customized its fields before.

Using the template

Create a conversion, choose Stripe to QuickBooks Net, and upload your Stripe payments CSV.

You can preview the result before running the full conversion. Once the conversion is complete, download the processed CSV and continue with your QuickBooks import.

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

For detailed Stripe export instructions, see Prepare a Stripe CSV for QuickBooks import.

For the next step, see the QuickBooks import guide.