How to Handle Undeposited Funds in QuickBooks Online (The Account That Confuses Everyone)

If there's one account in QuickBooks Online that causes more confusion, more frustration, and more cleanup headaches than any other, it's Undeposited Funds. I've lost count of how many times I've opened a QBO file and found thousands — sometimes tens of thousands — of dollars sitting in this account with no one understanding how they got there or what to do about them.

I get it. Undeposited Funds is not intuitive. The name doesn't help. The way QBO uses it behind the scenes doesn't help. And most of the explanations you'll find online are either too basic ("it's a holding account!") or too abstract to actually help you fix the mess in front of you.

So let me break this down the way I wish someone had explained it to me when I was first figuring it out — practically, with real examples, and with the specific QBO steps you need to clean it up and keep it clean going forward.

What Undeposited Funds Actually Is

Undeposited Funds is a holding account. That's the standard explanation, and it's technically correct, but it's not very helpful on its own. So here's the analogy I use:

Think of Undeposited Funds as a desk drawer. When your client receives payments — checks from customers, cash, credit card payments — those payments go into the desk drawer first. They sit there until someone takes them to the bank and deposits them. The bank deposit is what moves the money from the desk drawer (Undeposited Funds) into the bank account.

In accounting terms, Undeposited Funds is an Other Current Asset on the Balance Sheet. It represents money that the business has received but hasn't yet deposited into a bank account. It's real money — it's just in transit between "received" and "in the bank."

In QBO, the flow is supposed to work like this:

Step 1: Customer pays an invoice. You record the payment using "Receive Payment." QBO puts the payment into Undeposited Funds.

Step 2: You take the payment to the bank (or it's deposited electronically). You go to QBO and create a "Bank Deposit," selecting the payments from Undeposited Funds that make up that deposit. QBO moves the money from Undeposited Funds into the bank account.

That's it. Receive payment, then deposit. Two steps. When it works correctly, Undeposited Funds is basically a pass-through — money flows in and flows right back out, and the balance stays at or near zero.

Why Undeposited Funds Exists in the First Place

You might be thinking: why not just record the payment directly to the bank account? Why does this middle step exist?

The answer is grouping. In the real world, businesses don't deposit every payment individually. A small business might receive five checks on Tuesday and deposit all five as a single lump sum at the bank. On the bank statement, that shows up as one deposit for, say, $4,200. But in QBO, those are five separate payments from five separate customers.

Undeposited Funds lets you collect those five individual payments first, then group them into a single bank deposit that matches the single line item on the bank statement. Without this step, you'd have five separate deposits in QBO trying to match one deposit on the bank statement, and reconciliation would be a nightmare.

It also keeps your A/R accurate. When you use "Receive Payment" to apply a customer's payment to their invoice, QBO closes out that invoice in Accounts Receivable. The payment then waits in Undeposited Funds until you deposit it. This way, the invoice is marked as paid immediately (which is accurate — the customer did pay), even if the money hasn't hit the bank yet.

How Undeposited Funds Gets Messy

In theory, the system is elegant. In practice, it breaks in about four different ways. Here are the scenarios I see over and over again:

Scenario 1: Payments received but never deposited in QBO. Someone uses "Receive Payment" to record customer payments, which sends them to Undeposited Funds. But they never complete step two — they never create the bank deposit in QBO. The money actually gets deposited at the real bank, but in QBO, those payments are still sitting in the desk drawer. The bank feed might pull in the deposit, but since it's not connected to the payments in Undeposited Funds, it gets recorded as separate income. Now you've got duplicate revenue: once in A/R (via the received payment) and once on the bank feed.

Scenario 2: Deposits recorded directly to income. The bank feed pulls in a deposit. Instead of creating a bank deposit from Undeposited Funds, someone categorizes the bank feed transaction directly to an income account. The received payments are still sitting in Undeposited Funds, and the deposit has been recorded a second time as income. Same problem — duplicate revenue and a growing Undeposited Funds balance.

Scenario 3: Receive Payment used without invoices. Sometimes people use "Receive Payment" even when they haven't created invoices. QBO still routes the payment through Undeposited Funds, but since there's no invoice to apply it to, it just sits there with no clear connection to anything. This is common with businesses that take payments at point of sale but use QBO's invoicing feature inconsistently.

Scenario 4: Payment settings are misconfigured. QBO has a setting that controls where received payments go by default. If it's set to route payments to Undeposited Funds (which is the default), every "Receive Payment" and "Sales Receipt" goes through this account. If the person managing the books doesn't know about the deposit step, every single payment stacks up in Undeposited Funds indefinitely.

The Balance Sheet Symptom: A Number That Keeps Climbing

Here's how you usually discover the problem. You pull up the Balance Sheet and see "Undeposited Funds" listed under Other Current Assets with a balance that's way too high. Maybe it's $3,000. Maybe it's $15,000. Maybe it's $47,000. (More on that one in a minute.)

That number represents the total of all payments that went into the desk drawer but never came out. It's not real undeposited money sitting in an envelope somewhere — it's a QBO accounting problem. The money was almost certainly deposited at the bank a long time ago. It just wasn't deposited in QBO.

The impact on the financial statements is significant. That Undeposited Funds balance is inflating total assets on the Balance Sheet. And if the corresponding bank deposits were recorded separately as income, you might have overstated revenue on the P&L. It's a mess that cascades.

How to Find What's Stuck in Undeposited Funds

Before you can fix it, you need to see exactly what's in there. Here's how:

Step 1: Go to Reports > Balance Sheet. Set the report period to "All Dates." Look for "Undeposited Funds" under Other Current Assets.

Step 2: Click on the Undeposited Funds balance. This will drill down into a transaction detail report showing every payment that's currently sitting in this account.

Step 3: Review the list. You'll see the date, customer name, payment method, and amount for each stuck payment. Sort by date to see the oldest entries first — those are the ones that have been sitting there the longest and are most likely to be problematic.

Step 4: Export this list to Excel if it's long. You're going to need it as a reference while you work through the cleanup.

Pay attention to the dates. If payments from six months ago or a year ago are in here, those deposits definitely already hit the bank. Your job is to figure out how they were recorded on the bank side and clean up the mismatch.

How to Clear Out Undeposited Funds Properly

This is the part everyone wants to skip to, so let me be direct: there is a right way and a wrong way to clear Undeposited Funds. The right way takes more time but gives you accurate books. The wrong way is faster but hides the problem and creates new ones.

The right way:

Step 1: For each stuck payment, determine whether the corresponding bank deposit was already recorded in QBO. Check the bank register for the date around when the payment was received. Look for a deposit that matches the amount (or that the payment would have been part of).

Step 2: If the deposit was already recorded directly as income (via the bank feed), you need to delete or undo that bank feed transaction. Then create a proper Bank Deposit from Undeposited Funds to replace it.

To create the deposit: go to + New > Bank Deposit. Select the correct bank account. In the "Select the payments included in this deposit" section, you'll see the stuck payments from Undeposited Funds. Check the ones that belong in this deposit. The total should match the actual bank deposit amount. Save.

Step 3: If the deposit was recorded correctly through the bank feed but the received payment was never connected to it, you may need to match them. Go to the Banking tab, find the deposit in the bank feed, and see if QBO suggests a match to the Bank Deposit you just created. If it does, accept the match.

Step 4: If a payment in Undeposited Funds represents a transaction that never actually happened — maybe someone created a "Receive Payment" by mistake — you may need to void or delete it. But be careful: voiding the payment will reopen the invoice in A/R, so make sure the invoice status is actually correct before you do this.

Work through the list payment by payment. Yes, it's tedious. Yes, it requires cross-referencing with bank statements. But when you're done, your Undeposited Funds balance will be accurate, your bank account will be accurate, and your income won't be double-counted.

The Shortcut Trap: Why You Should NOT Journal Entry It to Zero

I need to address this directly because I see it recommended in Facebook groups and forums all the time: "Just create a journal entry to zero out Undeposited Funds."

Do not do this.

Here's what happens when you journal entry the balance to zero: you debit an income or bank account and credit Undeposited Funds. The balance disappears. Everything looks clean on the Balance Sheet. Problem solved, right?

Wrong. You've solved nothing. You've hidden the problem. Those payments are no longer sitting in Undeposited Funds, but they were never properly matched to actual bank deposits. Your bank account balance in QBO is now wrong by whatever amount you journal-entried. Your reconciliation is going to break. And if any of those payments were tied to customer invoices, the invoices still show as paid in A/R even though the financial trail is now broken.

The journal entry approach also makes it nearly impossible for the next bookkeeper to figure out what happened. When I inherit a file where someone journal-entried Undeposited Funds to zero, I have to undo the journal entry first, then start the real cleanup from scratch. It creates more work, not less.

The only time I'd even consider a journal entry is if the amounts are immaterial (under $50 total), the transactions are from several years ago, and the client has confirmed the money was received and deposited. And even then, I document exactly what I did and why.

When Undeposited Funds Should Be $0 vs. When a Small Balance Is Normal

A common question I get: "Should Undeposited Funds always be zero?"

Not necessarily — but it should be very close to zero most of the time, and any balance should be recent.

Here's when a balance is normal: if the business received payments today and hasn't deposited them at the bank yet, those payments should be in Undeposited Funds. That's the account working as designed. A small balance representing the last day or two of received payments is perfectly fine.

Here's when a balance is a problem: if payments have been sitting in Undeposited Funds for more than a few business days, something is wrong. Either the deposits aren't being recorded in QBO, or the workflow is broken. Anything older than 30 days is almost certainly stuck.

My rule of thumb: at the end of every month, Undeposited Funds should be at or near $0. If it's not, investigate before you close the month. This is one of my standard monthly close checks — I look at the Balance Sheet and make sure Undeposited Funds isn't accumulating.

How to Prevent the Problem Going Forward

Cleaning up Undeposited Funds is painful. Preventing it from getting messy again is much easier. Here's what I recommend:

Check your payment settings. In QBO, go to Settings (gear icon) > Account and Settings > Advanced. Look at the "Pre-fill forms with previously entered content" section and the payment deposit settings. You can configure whether payments automatically go to Undeposited Funds or directly to a bank account. For businesses that deposit every payment individually (like most businesses that accept online payments), you might want to set it to deposit directly to the bank account. This bypasses Undeposited Funds entirely for those transactions.

Create a weekly deposit routine. If the business does use Undeposited Funds (because they group payments into deposits), make sure the deposit step happens at least weekly. Every Friday, create Bank Deposits for all payments received that week. Don't let payments stack up.

Train clients on the workflow. If your clients are entering their own payments, they need to understand the two-step process: receive payment, then deposit. Most clients don't know about step two. Create a simple one-page guide or record a quick video showing them exactly how to create a Bank Deposit after receiving payments. This single piece of client education will save you hours of cleanup later.

Add Undeposited Funds to your monthly review. Every month, when you're closing the books, check the Undeposited Funds balance on the Balance Sheet. If it's anything other than recent payments, investigate immediately. Don't let it accumulate. A $200 balance is a 10-minute fix. A $20,000 balance is a multi-day project. Catch it early.

Real Talk: The $47,000 Undeposited Funds File

I promised you a real scenario, so here it is.

I once inherited a file with $47,000 sitting in Undeposited Funds. This was a service-based business — they'd been using QBO for about two years. The owner had been creating invoices and using "Receive Payment" when customers paid, which is exactly right. The problem was that nobody ever created the bank deposits in QBO.

For two full years, every single customer payment went into Undeposited Funds and stayed there. Meanwhile, the bank feed was pulling in the actual deposits, and the owner was categorizing them directly to income. So every dollar of revenue was recorded twice — once through the invoice/payment flow and once through the bank feed.

The financial statements were a disaster. Revenue was overstated by nearly $47,000 (the total amount of payments that were double-counted). Total assets were inflated by $47,000 (the Undeposited Funds balance). The P&L was essentially useless for any kind of financial analysis.

Here's how I cleaned it up:

First, I exported the Undeposited Funds detail report to Excel. That gave me a complete list of every stuck payment — about 180 transactions over two years.

Then, working month by month, I matched each payment to the corresponding bank feed deposit. For most of them, the bank feed deposits had been categorized directly to income, so I deleted those bank feed entries and replaced them with proper Bank Deposits from Undeposited Funds.

Some payments had been deposited together (three or four checks in one trip to the bank), so I had to figure out which payments went with which deposit. I pulled the actual bank statements and matched the deposit totals to groups of payments.

The whole cleanup took about 16 hours across several days. When it was done, Undeposited Funds was $0, the bank account balanced, and the revenue numbers were finally accurate. The owner was shocked when she saw the corrected P&L — she'd been looking at financials that overstated her income by nearly 25% for two years.

That's the reality of what happens when Undeposited Funds isn't managed. It's not just a bookkeeping annoyance — it distorts the financial picture of the entire business.

Don't Let Undeposited Funds Catch You Off Guard

Undeposited Funds is just one signal of a file's overall health. A bloated balance here usually means other things are off too — uncategorized transactions, duplicate entries, stale A/R, missing reconciliation history. That's why I always run a full diagnostic before quoting a cleanup.

I built LedgerClean to automate that diagnostic. Upload your client's QBO exports and it checks for balance sheet anomalies — including Undeposited Funds — alongside 7 other detection categories. You get a health score, prioritized findings, and time estimates so you know exactly what you're walking into before you commit to a price. Free to try.