Undeposited Funds in QuickBooks: Old Items, Big Balances, Real Risk

When Undeposited Funds turns into a dumping ground

You open a new QuickBooks Online file, run a Balance Sheet, and there it is: Undeposited Funds sitting at $15,000. You drill in and see payments from a year and a half ago, still "waiting" to be deposited.

The client swears, "But my bank is reconciled every month." And they might be right. The bank recs can be green while Undeposited Funds quietly fills up with old customer payments, duplicate entries, and workflow mistakes.

This is one of those cleanup issues that tells you a lot in the first five minutes:

• How far back you really need to go.
• Whether cash and revenue are even in the same ballpark.
• How much re-education the client team is going to need on the Receive Payment / Bank Deposit workflow.

When Undeposited Funds carries a large balance or is packed with old items, you’re not just looking at a cosmetic issue. You’re looking at stuck cash receipts and a high chance of mis-stated income.

Where this problem hides inside QuickBooks Online

Start with a Balance Sheet as of your diagnostic date. If Undeposited Funds is more than a rounding error, you’ve got work to do.

Click into the balance and look at the transaction detail. What you’re really trying to separate is:

• Payments and sales receipts that are still legitimately in transit (e.g., this week’s checks).
• Old, orphaned items that never made it into a Bank Deposit.

A classic messy-file example:

• Diagnostic date: 12/31/2024
• Undeposited Funds ending balance: $15,000
• Detail: 10 customer payments dated between 6/1/2023 and 7/15/2023
• None of those payments are linked to a Bank Deposit

In a healthy file, by contrast, you might see:

• Ending balance: $50
• 2 payments from the last week of December
• Both scheduled to be deposited in early January

Red flags to look for:

• Undeposited Funds balance over your materiality threshold (say $1,000+) at period end.
• Any items older than 60–90 days still sitting in Undeposited Funds.
• A long scroll of undeposited payments (dozens or hundreds of lines).
• Multiple Undeposited Funds-type accounts in the Chart of Accounts.
• Payments that appear to be duplicates of amounts already in the bank.

What happens if you just live with it

Leaving Undeposited Funds messy is tempting when the bank recs are done and the client is impatient. But this is one of those accounts where "good enough" comes back to bite you.

The damage inside your numbers

When Undeposited Funds is bloated with old items, a few things usually follow:

• Cash is wrong: If payments were recorded but never deposited, cash on the Balance Sheet may be understated while Undeposited Funds is overstated, or vice versa if someone forced deposits or journal entries.
• Income may be double-counted: Staff sometimes record a customer payment to Undeposited Funds and then also add a bank feed deposit directly to income. Now you’ve got revenue recognized twice for the same money.
• A/R aging is misleading: If payments were posted to the wrong customer, wrong invoice, or never applied properly, the aging report doesn’t reflect reality. You can’t trust who still owes what.
• Cash flow analysis is distorted: Management thinks they collected $X in a period, but part of that "collection" is stuck in Undeposited Funds limbo.

If you’re signing off on compiled or reviewed financials, this is not a minor housekeeping issue. It’s a core cash and revenue integrity issue.

The damage in client conversations

From the client’s perspective, Undeposited Funds is invisible. They look at their bank app, not at that account.

So when you explain that:

• Some "deposits" in QuickBooks never hit the bank, or
• Some bank deposits were never tied to customer payments,

…you’re essentially telling them, "Your revenue and cash reports haven’t been trustworthy."

That’s uncomfortable, but it’s also where your value shows up. If you can quantify it ("You’ve got about $15,000 in old undeposited payments from 18+ months ago"), you turn a vague mess into a concrete problem with a plan.

How solid firms clean up Undeposited Funds

A good Undeposited Funds cleanup is structured, not ad hoc. You’re trying to answer three questions:

1. What’s legitimately in transit at period end?
2. What’s old and needs cleanup?
3. What workflow change will stop this from happening again?

Here’s a practical sequence:

1. Pull the detail and segment by age. From the Balance Sheet, drill into Undeposited Funds and export to Excel or Google Sheets. Add an "Age in days" column based on your review date. Group items into 0–30, 31–90, and 90+ days.
2. Tie recent items to the bank. For the last 30–60 days, match payments to actual bank deposits. Fix any that were never included in a Bank Deposit (create proper Bank Deposits and match to the feed; remove any duplicate income-only deposits).
3. Investigate the 90+ day items. This is where you talk to the client. Were these payments actually received? Were they reversed? Written off? Deposited under a different name? Based on that answer, you’ll either:
   • Create missing Bank Deposits and match to the bank (if the money really did hit the bank), or
   • Void/adjust the payment and correct A/R or income (if it was a duplicate or error).
4. Handle closed years carefully. For really old items in closed tax years, you may decide not to edit historical transactions. Instead, you might:
   • Record a current-period journal entry to clear Undeposited Funds to an appropriate account (e.g., Other Income, Prior Period Adjustment, or Owner’s Equity), with documentation.
5. Fix the workflow. Once the account is clean, retrain the client’s staff: Receive Payment to Undeposited Funds (or directly to the bank if appropriate), then use Bank Deposit to group and match to the bank feed. Remove any habits of posting bank feed deposits straight to income when they relate to customer payments.

If you’re doing a lot of these, you don’t want to manually scan every file from scratch. Tools like CleanupOwl can automatically flag Undeposited Funds accounts with large balances, lots of items, or very old payments so you know exactly where to dig.

Making this a standard part of every engagement

This shouldn’t be a "maybe" step. Undeposited Funds deserves its own line on your cleanup checklist and your diagnostic review.

At a minimum, define firm-level thresholds:

• Balance threshold (e.g., flag if Undeposited Funds > $1,000 at period end).
• Age threshold (e.g., flag if any item > 90 days old).
• Count threshold (e.g., flag if more than 10 undeposited items).

Then decide how you’ll check it:

• Manually: Run the Balance Sheet, drill in, sort by date, and quickly assess.
• Semi-automated: Use a saved report or export and filter by age.
• Automated: Let a diagnostic tool like CleanupOwl run the check across all Undeposited Funds-type accounts and hand you a list of which clients are in trouble.

The patterns you’ll keep seeing in client files

Your response should scale with what you see.

• When the balance is small and items are recent, a quick review and a bit of training may be enough.
• When balances are large or items are very old, you’re in full cleanup mode: tracing to bank statements, making adjusting entries, and documenting decisions.
• When there are dozens of items, even if the total isn’t huge, you’re looking at a workflow problem that will keep generating noise until you fix the process.

Making this part of your cleanup playbook

Undeposited Funds is one of the fastest ways to gauge the health of a QBO file. A large balance or a pile of old items tells you there’s a cash and revenue story to untangle, and it gives you a concrete scope conversation with the client.

Build a standard step into every diagnostic review: check Undeposited Funds, apply your thresholds, and decide whether you’re in "quick tidy" or "deep cleanup" territory. Document what you find and what you’re choosing to fix (or not fix) in closed years.

If you want to stop doing that first pass by hand, CleanupOwl can run this check across all your client files and flag the ones with large balances, old items, or excessive volume in Undeposited Funds before you even quote the work. If you’re a business owner reading this, this is the kind of question you can ask your accountant: "Are you checking Undeposited Funds for old or stuck payments, manually or with a diagnostic tool like CleanupOwl?"

The firms that treat Undeposited Funds as a must-review account—not an afterthought—end up with cleaner cash, more reliable revenue, and far fewer awkward surprises at year-end.