top of page
Search

QuickBooks Desktop Undeposited Funds: Why Your Deposit Doesn’t Match (and How to Fix It)

If you’ve ever looked at your bank feed, looked at QuickBooks Online, and thought, “Fantastic. These numbers aren’t even pretending to be friends,” you’re not alone.


Undeposited Funds in QBO is one of those features that makes sense until it quietly becomes a holding tank for payments you thought were already dealt with. Then deposits stop matching, reconciliation gets ugly, and you start wondering whether QuickBooks is helping or freelancing.


This guide is for QuickBooks Online users who want to fix the problem without duplicating income or making the mess more creative.


Quick diagnosis


Before clicking around like a raccoon in a pantry, ask:

  • Do you receive customer payments first, then deposit them later?

  • Does your bank show one lump deposit, but QuickBooks shows several separate payments?

  • Do you have payments sitting in Undeposited Funds that should already be gone?


If yes, this is probably your issue.


What Undeposited Funds is in QBO


Undeposited Funds is a temporary holding account inside QuickBooks Online.

The basic flow looks like this:

  • You receive one or more customer payments

  • Those payments go into Undeposited Funds

  • You create a Bank Deposit in QBO to group the right payments together

  • That deposit should match what actually hit your bank

When that flow is used correctly, bank matching and reconciliation are much easier.

When it is not, you usually end up with:

  • deposits that do not match the bank

  • duplicate income

  • payments that look missing

  • Undeposited Funds that never clears out

The 3 most common reasons your deposit doesn’t match in QBO


1) The payment was recorded, but never included in a bank deposit

The payment exists, but it is still sitting in Undeposited Funds instead of being grouped into the deposit that hit your bank.


2) The deposit was created, but it does not match the real bank deposit

This happens when:

  • some payments were grouped incorrectly

  • deposits from different days got combined

  • one payment was deposited separately while others were grouped together

  • merchant fees changed the amount that actually hit the bank


3) The same money got recorded twice

This usually happens when:

  • a payment was received and a sales receipt was also created

  • a bank deposit was entered manually even though the payment was already recorded

  • a transaction from the bank feed was added instead of matched

That last one is a repeat offender in QBO.

Step-by-step: the safe way to fix it in QuickBooks Online

Step 1: Check what actually hit the bank

Pick one bad deposit and write down:

  • the date

  • the amount

  • which payments made it up, if you know

You are trying to make QBO match reality, not the other way around.

Step 2: Review what is sitting in Undeposited Funds

In QBO, look for customer payments that were recorded but not properly deposited.

A common path is:

  • Go to Sales

  • Open the related customer payments

  • Check whether they were posted to Undeposited Funds

You can also review transactions tied to the Undeposited Funds account from your chart of accounts.


If you find old payments sitting there, that is common. Irritating, but common.


Step 3: Create the bank deposit correctly


In QuickBooks Online:

  • Go to + New

  • Select Bank Deposit

  • Choose the correct bank account

  • In the list of payments included in this deposit, select the payments that make up the real bank deposit

  • Confirm the total matches what hit the bank

That is the key move. QBO needs one grouped deposit that matches the lump amount your bank shows.


Step 4: Handle merchant fees properly


If you use Stripe, Square, PayPal, or another processor, the amount that lands in your bank may be less than the customer payment total.

In that case, you may need to:

  • include the full customer payments in the deposit

  • add a negative line for the processing fee

  • code that fee to the appropriate expense account

If the gross payment was $500 and the bank only received $485, QBO needs to reflect why the other $15 vanished instead of acting surprised.

Step 5: Check the bank feed before adding anything

If the deposit already exists in QBO, the transaction coming through the bank feed should usually be matched, not added.

If you click Add when the deposit is already recorded, you may create duplicate income.

That is how a fix turns into a sequel.

Step 6: Sanity-check for duplicates

Before you move on:

  • run a Profit and Loss for the month

  • make sure income is not overstated

  • search for the payment and confirm it only exists once

  • confirm the bank feed item matched the deposit instead of creating a second transaction

How to prevent this next time

You do not need a full life makeover. You need a tiny repeatable habit.

  • receive payments consistently

  • use Bank Deposit to group payments that hit the bank together

  • match bank feed transactions instead of adding duplicates

  • handle merchant fees the same way every time

  • check Undeposited Funds regularly so it does not become QuickBooks purgatory

When to stop and get help

Pause and get another set of eyes if:

  • you are not sure whether the money was entered as a payment, sales receipt, or manual deposit

  • the month has already been reconciled

  • multiple bank accounts are involved

  • deposits from a payment processor are being handled inconsistently

  • you suspect duplicates but cannot tell where they came from

 
 
 

Comments

bottom of page