I Found $500,000 in a QuickBooks Account the Contractor Didn't Know Existed

If your QuickBooks Undeposited Funds account has a balance right now, stop reading and go check it. It might be telling you something your P&L isn't.

I once found over $500,000 sitting in a contractor's Undeposited Funds account that the owner had no idea existed. Not $500,000 in real money but $500,000 in phantom entries that had been quietly inflating his revenue for years.

What Is the Undeposited Funds Account in QuickBooks?

Undeposited Funds is a holding account built into QuickBooks Online. It's a temporary home for payments that have been recorded but not yet matched to an actual bank deposit. Think of it as a drawer where money sits before it's officially put in the bank. When a payment is received correctly, it moves from Undeposited Funds to your bank account through the reconciliation process. When that process breaks down, the balance grows.

For this client, that drawer had been accumulating unmatched entries for years.

How Phantom Revenue Hides in Your QuickBooks Books

None of the $500,000 was real. Every dollar was a duplicate or mishandled entry such as payments recorded twice, deposits never matched to the corresponding invoice, invoices closed out manually without properly clearing the account. Their books showed $500,000 more revenue than they actually had.

The owner had been making real business decisions based on those numbers. Pricing decisions. Hiring decisions. He thought the business was performing better than it was. The Undeposited Funds account was quietly lying to him every month.

Why Contractors Miss This QuickBooks Error

Most contractors and even most generalist bookkeepers never look at this account. It doesn't appear prominently on the P&L. It sits on the balance sheet as a current asset which makes it look like money you have rather than a problem to fix. Unless someone is actively reconciling the account and matching every payment to a bank deposit, the balance just keeps growing without triggering any obvious alarm.

A healthy Undeposited Funds account should have a near-zero balance at the end of every month. Any balance over a few thousand dollars at month-end is a sign that something isn't being matched correctly.

How to Check Your Undeposited Funds Balance Right Now

In QuickBooks Online go to Reports → Balance Sheet and find Undeposited Funds under Current Assets. If the balance is more than a few thousand dollars, click the plus icon --> Bank Deposit and review the available payments that you can deposit.  Look for duplicate payments, old unmatched deposits, or invoices that were closed without a corresponding bank match. Each one of those entries represents a discrepancy between what your books say and what actually happened.

For a deeper look at how your chart of accounts should be structured to catch errors like this, read our post on Chart of Accounts for Contractors.

Frequently Asked Questions

• What should my Undeposited Funds balance be in QuickBooks?

• Ideally near zero at the end of every month. A small balance is normal if you received payments right before month-end that haven't been deposited yet. A balance in the thousands, especially one that's been growing for months, indicates unmatched payments, duplicate entries, or reconciliation errors that need to be corrected.

• How do undeposited funds errors affect my QuickBooks P&L?

• If payments are recorded but never properly matched to bank deposits, your revenue can appear higher than it actually is. This overstates your gross profit and net income, which leads to bad business decisions based on numbers that don't reflect reality.

• Can undeposited funds errors affect my taxes?

• Potentially yes. If your books show phantom revenue that was never actually earned, your reported income may be higher than it should be. This is one of the reasons clean monthly reconciliation isn't just a bookkeeping best practice; it's financial protection.

If you want to know what else might be hiding in your books, our free resources including the Cash Flow Leak Scorecard are available for download here. Or if you want a second set of eyes on your books specifically, book a call here.