Stripe split fee import

The Stripe to QuickBooks Split Fee template prepares a Stripe payments export for QuickBooks while keeping Stripe processing fees separate from the payment itself.

Instead of representing a Stripe transaction as a single net amount, the template creates separate rows for the payment and its fee. This makes the fee visible as its own entry and allows it to be assigned separately during your accounting workflow.

If you prefer to keep each Stripe transaction as a single row, use the Stripe to QuickBooks Net template instead.

What the template produces

The Split Fee template takes each Stripe payment and creates accounting rows from it.

The primary row represents the payment itself. When a Stripe fee is present, an additional row represents that fee.

The output contains:

Date · Description · Amount · Customer

This gives you a simple CSV while preserving the distinction between money received and the cost of processing the transaction.

[SCREENSHOT: Preview of a Stripe to QuickBooks Split Fee conversion showing one Stripe source transaction becoming a payment row and a separate fee row. Include the Date, Description, Amount, and Customer columns.]

Why split the fee?

A Stripe payment isn't necessarily the same as the amount that ultimately reaches your bank.

For example, a customer payment and Stripe's processing fee are two different parts of the same activity. Importing only the net amount is simpler, but it doesn't represent the fee separately.

The Split Fee template keeps those parts distinct. The payment can be recorded as income while the Stripe fee can be handled separately as an expense.

For a more detailed explanation of this accounting workflow, see How to split Stripe fees for QuickBooks import.

Transformations applied by the template

Like the Net template, Split Fee uses explicit transformation rules. You can inspect the template to see where every output value comes from.

The main difference is that this template contains separate mappings for the payment row and the fee row.

Payment row

The first output row represents the Stripe payment.

Date

BalanceFlow takes Created date (UTC), converts it from UTC to your selected timezone, and formats it as:

MM/DD/YYYY

The converted value becomes the output Date.

[SCREENSHOT: Split Fee template editor showing the payment-row Created date (UTC) → Date mapping, including UTC conversion and MM/DD/YYYY formatting.]

Description

Stripe's Description is written to the output Description column.

If the Stripe description is empty, the template uses:

Stripe balance transaction

This provides a usable description even when the source transaction doesn't contain one.

Amount

The template uses Converted Amount when Stripe provides it. If that value is empty, it falls back to Amount.

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

Using the converted value first keeps the transaction in Stripe's settlement currency when currency conversion has taken place.

Customer

Customer Email is used for the output Customer value.

If no customer email is available, the template uses:

Stripe

[SCREENSHOT: Split Fee template editor showing the payment-row mappings for Description, Converted Amount → Amount, and Customer Email → Customer. Include the fallback values and amount normalization operations.]

Refund row

When a transaction contains a refund, the template can create a separate row representing the refunded amount.

The refund row uses the same transaction date and identifies the entry as a refund rather than combining it invisibly into the original payment amount.

For the refund value, BalanceFlow uses Converted Amount Refunded when available and falls back to Amount Refunded when it isn't.

The amount is normalized before being written to the output CSV.

[SCREENSHOT: Split Fee template editor showing the complete refund split-row configuration, including its condition and the Converted Amount Refunded mapping.]

Fee row

When a Stripe fee is present, the template creates another output row for the fee.

The fee row uses the transaction date and Stripe's Fee value. The description identifies the row as a Stripe fee, making it easier to distinguish from the original payment after import.

The amount is normalized to the same decimal format as the other monetary values.

[SCREENSHOT: Split Fee template editor showing the complete fee split-row configuration, including the condition that controls whether the row is created and the Fee → Amount mapping.]

Converted and original amounts

Stripe exports can contain both the original transaction amount and a converted amount.

The template prefers Converted Amount and Converted Amount Refunded when they're available. If either converted field is empty, BalanceFlow uses its corresponding original value instead.

This matters when Stripe has converted a payment into your settlement currency. It also keeps the transaction and refund values consistent with Stripe's fee information.

You don't need to choose between these fields manually for every conversion - the fallback is part of the template.

For details about downloading the correct Stripe export, see Prepare a Stripe CSV for QuickBooks import.

Matching the Stripe export

When creating a conversion, BalanceFlow lets you match the uploaded CSV in two ways.

By position is the default. It expects the source columns to appear in the order defined by the template.

By header identifies fields by their column names instead, so the expected columns can appear in a different order.

Stripe can remember previous changes to its export settings. If you've customized your Stripe exports before, check the selected fields or use header matching when appropriate.

Using the template

Create a new conversion and choose Stripe to QuickBooks Split Fee.

Upload your Stripe payments CSV, choose how the input columns should be matched, and continue to the conversion. You can preview the transformed data before processing the complete file.

Once the conversion finishes, download the resulting CSV.

[SCREENSHOT: Completed Stripe to QuickBooks Split Fee conversion showing Status: Completed, the generated CSV filename, and the Download File button.]

For the complete accounting workflow, including how the separate rows should be handled in QuickBooks, see How to split Stripe fees for QuickBooks import.

If you're importing Stripe activity through a clearing account, see Using a clearing account for Stripe reconciliation.