Skip to main content

How do I match a Stripe payout to my invoices in QuickBooks?

Stripe pays out several card payments as one lump sum, minus the fee, so it never matches a single invoice. Use a Bank Deposit in QuickBooks: tick the payments in the payout, then add the fee as a negative line.

Written by Vladimir

If you take card payments through Stripe and your books are in QuickBooks Online, you have probably hit this: the deposit that lands in your bank does not match any single invoice, so nothing will match cleanly in the bank feed.

That is normal. This walks through the fix.

Why the deposit never matches an invoice

Stripe does not send you each payment as it happens. It batches them and sends one payout a couple of days later, and it takes its fee out of that payout before it leaves.

So if you took five card payments today, in a couple of days your bank shows one deposit that is the total of those five payments minus the fees. There is no invoice anywhere with that number on it.

Payout timing changes as you go. New Stripe accounts wait longer for their first payouts. Once Stripe has some history with you, payouts speed up. Your current schedule is in your Stripe dashboard under Balances.

Where the payments sit in the meantime

Each card payment goes into a QuickBooks holding account called Undeposited Funds — newer versions of QuickBooks call it Payments to deposit. Every payment sits there on its own until you deposit it.

You do not have to enter these payments yourself. If your shop is connected to QuickBooks, EasyTruckShop pushes every card payment across as soon as it is taken — on the terminal or through a payment link. By the time the payout reaches your bank, the payments are already in QuickBooks waiting to be deposited. The only part left to do by hand is the payout side, which is the rest of this article.

The Bank Deposit screen is simply where you see that list. Grouping several of those payments into one deposit is what people mean when they say "clearing Undeposited Funds".

The whole chain looks like this:

  1. A customer pays by card → EasyTruckShop pushes the payment to QuickBooks → it lands in Undeposited Funds.

  2. Stripe sends a payout covering several of them → you record a bank deposit for exactly those payments, and add the fee as a negative line.

  3. The deposit total now equals the bank line → you match it in the bank feed.

  4. Undeposited Funds goes back to zero.

Two things the fee line needs

The fee line uses two fields: Received From and Account. We recommend giving each of them a proper entry rather than leaving them blank — that is what lets you see, at the end of the year, exactly what card processing cost you.

  • Received From — a customer called "Stripe". Every fee line is then tied to one name.

  • Account — an expense account called "Stripe Fees". Many shops make it a sub-account of Bank Charges & Fees, so it groups with the other bank costs but still totals on its own.

Search "fee" in either dropdown and get no results? Then you do not have them yet — create them right from there. Both Received From and Account have + Add new at the top of the list, so you do not have to stop and go build them somewhere else first. You only do it once; after that they come up every time you type.

If you would rather set the expense account up properly in your chart of accounts first, the steps are in Connecting QuickBooks: Setting Up Expense Mapping.

Step 1 — Find out what the payout covers

Open your Stripe dashboard and click into the payout that hit your bank. Stripe shows you two things you need:

  • Which payments are in it — so you know which invoices to tick in QuickBooks.

  • The total fee taken out of that payout.

Use the fee number Stripe shows you — do not work it out yourself. The fee is not a fixed percentage. It changes with the card the customer used. The payout page tells you exactly what came out.

Step 2 — Open a Bank Deposit in QuickBooks

In QuickBooks Online: + Create in the top left → under Other, choose Bank deposit.

In the picture below: 1 = the + Create button. 2 = Bank deposit.

The QuickBooks Online Create menu. Marker 1 points at the plus Create button in the top left. Marker 2 points at Bank deposit in the Other column.

Step 3 — Tick the payments, then add the fee

The Bank Deposit screen lists every payment sitting in Undeposited Funds waiting to be deposited. Here is the whole job:

  • Tick the payments that the Stripe payout covers — the ones you just looked up in Stripe. Watch Selected Payments Total at the bottom right; it should equal the payout before fees.

  • Open Add funds to this deposit at the bottom and fill one line:

  • Received From = Stripe — nothing found when you type it? Use + Add new at the top of the list.

  • Account = your fee account — in the picture below it is Bank Charges & Fees: Stripe Fees. Same again: no results means you do not have it yet, so + Add new and create it.

  • Amount = the fee as a negative number — for example -45.81, not 45.81

⚠️ The minus sign is the whole trick. A positive number adds money to the deposit. You want to take money out, so it has to be negative.

In the picture below: 1 = tick the payments in this payout. 2 = Received From: Stripe. 3 = Account: your Stripe Fees account, with + Add new at the top of the open dropdown. 4 = the fee as a negative amount. 5 = the deposit Total, which should now equal the amount that actually hit your bank.

The QuickBooks Bank Deposit screen. Marker 1 points at the ticked payment rows. Marker 2 points at Received From set to Stripe. Marker 3 points at the Account field set to Bank Charges and Fees colon Stripe Fees, with the dropdown open showing a plus Add new option. Marker 4 points at the fee entered as a negative amount. Marker 5 points at the deposit Total, which matches the Stripe payout.

Step 4 — Check the total, then save

Before you save, the Total at the bottom right must equal the deposit on your bank statement, to the penny.

The maths is:

Selected Payments Total − Stripe fee = deposit Total = what hit the bank

Here is that with real numbers, and it is the same deposit shown in the picture above:

Three payments ticked (Selected Payments Total)

4,340.00

Stripe fee, entered as a negative line

-45.81

Deposit Total — and the amount on the bank statement

4,294.19

If it is off, one of three things is wrong: you ticked a payment that is not in this payout, you missed one that is, or the fee number is wrong. Go back to the Stripe payout and check the list again.

When it matches, save the deposit. Now go to your bank feed and the deposit will match in one click.

I do not see my payments in the list

Card payments should already be in the Bank Deposit list, pushed across from EasyTruckShop when they were taken. If the list is empty or your Stripe payments are missing, check these in order:

  • Is the shop still connected to QuickBooks? If the integration has dropped or a sync has failed, nothing new reaches QuickBooks at all — not just the payments. Check your QuickBooks integration settings in EasyTruckShop first.

  • Are the payments going straight into the bank account instead? A payment recorded with Deposit to set to your checking account will never appear in the Bank Deposit list, because QuickBooks already treats it as banked.

⚠️ If payments land straight in the bank account and you also record a deposit for them, the same money is counted twice. Sort that out before you enter any more deposits.

What you end up with

  • Each invoice is marked paid against the right customer.

  • The Stripe fees are sitting in an expense account, so you can see what card processing costs you for the year.

  • Undeposited Funds clears out instead of growing forever.

  • Your bank feed matches without a forced or manual entry.

A few things that trip people up

  • Do not delete the payments and re-enter the deposit as one lump. It balances the bank, but the invoices stay unpaid and the customer statements go wrong.

  • Do one deposit per payout. Do not combine two Stripe payouts into a single deposit — you lose the one-to-one match with the bank line.

  • Cash, check and Zelle payments are separate. They are not in a Stripe payout, so do not tick them into a Stripe deposit. Deposit those the way you actually banked them.

  • Refunds show up too. If a payment was refunded, Stripe nets it out of a payout. It appears in the payout detail — deal with it the same way, as a line in Add funds to this deposit.

⚠️ This is how to record the payout in QuickBooks. It is not accounting advice — if you are not sure how your books should be set up, check with your bookkeeper or accountant.

Other ways shops ask this question

  • "My Stripe deposit does not match my invoice."

  • "Why is the deposit in my bank less than the invoice?"

  • "How do I reconcile Stripe in QuickBooks?"

  • "Stripe paid me for several invoices at once — how do I record it?"

  • "Where do I put the Stripe fee in QuickBooks?"

  • "How do I create a Stripe Fees account in QuickBooks?"

  • "I search for fees in the Account dropdown and nothing comes up."

  • "Do card payments go to QuickBooks automatically?"

  • "How do I clear Undeposited Funds?"

  • "What is Undeposited Funds?"

  • "My payments are not showing in the Bank Deposit screen."

  • "The invoice shows paid but the bank deposit is a different amount."

  • "How do I record a Stripe payout?"

  • "Why can't I match my Stripe deposit in the bank feed?"

  • "How do I enter merchant fees?"

Related Articles

Did this answer your question?