Using a clearing account for Stripe reconciliation

Stripe transactions and Stripe payouts happen at different stages.

A customer can pay you today, Stripe can deduct a processing fee immediately, and the resulting balance can reach your bank later as part of a payout containing many transactions.

If individual Stripe transactions are recorded directly against your checking account, the activity in QuickBooks won't necessarily resemble what appears on your bank statement.

A Stripe clearing account provides an intermediate place for that activity. Payments, refunds and fees affect the clearing account first. When Stripe sends a payout, the money moves from the clearing account to your actual bank account.

What is a clearing account?

A clearing account is a temporary account used to move money between different parts of an accounting workflow.

QuickBooks describes a clearing account as an account used when money can't be moved directly between two accounts. Intuit recommends setting it up as a Bank-type account and normally expects a traditional clearing account to return to zero once the related movements are complete. QuickBooks

For Stripe, the idea is slightly more intuitive if you think of the account as representing money currently held by Stripe.

The flow becomes:

Customer payment → Stripe clearing account → Bank account

Fees and refunds also affect the Stripe balance before the payout reaches your bank.

Why not record everything directly in checking?

Suppose three customers make payments through Stripe:

Your bank doesn't receive three customer deposits and a separate Stripe fee.

It receives a Stripe payout of $217.75.

If the individual transactions were recorded directly in checking, QuickBooks would contain activity that doesn't correspond directly to the transactions on the bank statement.

With a clearing account, the individual activity stays on the Stripe side until the payout occurs.

This mirrors the distinction Stripe and QuickBooks themselves make between sales activity and payouts. Intuit describes a Stripe payout as the transfer of accumulated Stripe funds - after fees, adjustments or holds - to the bank account. QuickBooks

How the clearing account works

Using the same example, the clearing account first receives the customer payments:

+$100.00

+$75.00

+$50.00

Stripe fees reduce it:

-$7.25

The clearing account now contains:

$217.75

When Stripe sends the payout, $217.75 moves from the Stripe clearing account to checking.

After that transfer:

Stripe clearing: $0.00

Checking: +$217.75

And the $217.75 appearing in checking now corresponds to the $217.75 deposit appearing on the bank statement.

In practice, the clearing account may not always be zero because Stripe can still be holding transactions that haven't been paid out yet.

Set up a Stripe clearing account in QuickBooks

Create a separate account in your QuickBooks Chart of Accounts for Stripe activity.

Intuit's general guidance for clearing accounts recommends creating them with the Bank account type and without an opening balance. QuickBooks

A straightforward name is:

Stripe Clearing

Keeping it separate from your actual checking account makes it clear which balance represents funds still moving through Stripe.

[SCREENSHOT: QuickBooks New account screen showing a new Bank-type account named "Stripe Clearing", with no opening balance entered.]

Record Stripe transactions in the clearing account

Individual Stripe transactions should affect the Stripe clearing account rather than pretending that every customer payment arrived directly in your checking account.

For example, a $100 customer payment increases Stripe Clearing by $100.

If Stripe charges a $3.20 processing fee, the fee reduces Stripe Clearing by $3.20 and is recorded against the appropriate fee expense account.

The remaining Stripe balance is $96.80.

QuickBooks similarly recommends recording third-party processing fees separately from the underlying sales when working with external payment processors. QuickBooks

If you're preparing Stripe transactions through CSV, see How to import Stripe transactions to QuickBooks.

Record fees separately

Keeping Stripe fees separate is particularly useful with a clearing-account workflow.

Instead of recording:

Net payment: $96.80

you can represent what actually happened:

Customer payment: +$100.00

Stripe fee: -$3.20

The clearing account still ends up with $96.80, but your books retain the $100 payment and $3.20 processing cost separately.

BalanceFlow's Stripe to QuickBooks Split Fee template is designed for this type of transaction-level workflow.

See How to split Stripe fees for QuickBooks import for the underlying concept and conversion process.

Record refunds against the same flow

Refunds also reduce the amount held by Stripe.

If the original customer payment increased Stripe Clearing, a subsequent refund should reduce it rather than being treated as an unrelated movement from your checking account.

This keeps payments, refunds and fees together on the Stripe side of the accounting flow.

The clearing account balance can therefore represent the cumulative effect of:

payments + adjustments − refunds − fees − payouts

The exact balance won't necessarily match Stripe at every instant because of settlement timing, pending transactions and other Stripe activity, but differences become something you can investigate rather than being hidden inside bank deposits.

Match the payout to your bank deposit

When Stripe sends a payout, don't record it as another sale.

The sale has already been represented by the underlying transactions.

The payout is a transfer of funds:

Stripe Clearing → Checking

Suppose Stripe Clearing contains $217.75 of settled activity and Stripe sends a $217.75 payout.

Record the transfer out of Stripe Clearing and into the bank account.

When the $217.75 deposit appears in your connected bank feed, match it to that transfer rather than creating new income.

This is also how Intuit describes payouts in its current Stripe integration: adding a payout creates a bank deposit connected to the underlying sales and fees, and that payout can then be matched against the deposit downloaded from the bank. QuickBooks

[SCREENSHOT: QuickBooks Bank transactions screen showing a Stripe payout from the connected checking account ready to be matched against an existing transfer/deposit. The matching amounts should be clearly visible.]

Reconcile the clearing account

The clearing account gives you another useful checkpoint.

If all Stripe activity for a completed payout has been recorded correctly, the payment, refund and fee activity associated with that payout should explain the amount Stripe transferred.

For example:

Payments: $225.00

Fees: -$7.25

Payout: -$217.75

Remaining balance: $0.00

If the expected balance isn't there, you have a smaller set of things to investigate: a missing payment, refund, fee, adjustment, payout, or timing difference.

This is easier to reason about than trying to reconcile individual Stripe sales directly against a bank statement containing only aggregated payouts.

QuickBooks' general reconciliation process follows the same basic principle: compare the transactions recorded in QuickBooks with the external statement and investigate differences until the balance agrees. QuickBooks

A non-zero balance isn't automatically a problem

Don't assume Stripe Clearing must always show exactly $0.

At any given moment, Stripe may have processed transactions that haven't yet been included in a payout.

For example:

Stripe Clearing balance: $340

could simply represent $340 of activity still waiting for its next payout.

The useful question isn't:

“Is Stripe Clearing always zero?”

It's:

“Can the remaining balance be explained by Stripe activity that hasn't been paid out yet?”

After accounting for outstanding activity, completed payout periods should reconcile.

The complete workflow

With a clearing account, the relationship between Stripe and your bank becomes much clearer:

1. Customer pays through Stripe
Record the transaction against Stripe Clearing.

2. Stripe charges fees or processes refunds
Record those against Stripe Clearing as well.

3. Stripe accumulates the resulting balance
The clearing account represents funds still on the Stripe side.

4. Stripe sends a payout
Transfer the payout amount from Stripe Clearing to Checking.

5. The payout appears in your bank feed
Match the bank deposit against the transfer instead of recording new income.

6. Reconcile
Check that the remaining clearing balance can be explained by Stripe activity that hasn't yet been paid out.

Using this workflow with BalanceFlow

BalanceFlow focuses on importing the individual Stripe transactions, rather than treating payouts as the underlying sales activity.

That fits naturally with a clearing-account workflow: transaction-level activity builds the Stripe balance, while the payout represents the eventual movement of that balance into your bank account.

For the full transaction import process, see How to import Stripe transactions to QuickBooks.

If you want Stripe fees represented separately, use the Stripe to QuickBooks Split Fee template.

The result is a workflow where the individual transactions explain how the Stripe balance changed, and the payout explains how that balance reached your bank.