Journal entries to Undeposited Funds: a small entry, big cleanup problem

When a “quick fix” to Undeposited Funds blows up your cleanup

You open a new QBO file and pull a balance sheet. Undeposited Funds is sitting at $18,423.76. You click in, expecting a long list of old customer payments.

Instead, you see a chunky journal entry: Debit Undeposited Funds $10,000, Credit Sales $10,000, memo: "clean up old UF." The client swears, "But my bank is reconciled every month."

This is one of those patterns you start to recognize after a few messy files. Someone didn’t understand how Undeposited Funds works, got frustrated with the lingering balance, and dropped a journal entry on it. The list of undeposited payments is still wrong, the bank deposits don’t tie cleanly to revenue, and now you’ve got a layer of manual entries masking the real problem.

Journal entries to Undeposited Funds are almost never a good sign. They’re usually a symptom of:

• Payments recorded but never deposited
• Deposits recorded without matching payments
• Duplicate income
• Or all of the above, wrapped in a single JE “cleanup”

If you don’t catch these early in a cleanup, you can waste hours reconciling cash and revenue around numbers that were never right to begin with.

Where this problem hides inside QuickBooks Online

In QBO, Undeposited Funds is an Other Current Asset account that acts as a holding bucket between customer payments and bank deposits. In a clean file, it’s only touched by:

• Receive Payment (customer payments)
• Sales Receipt
• Bank Deposit (clearing those payments to the bank account)

When you see Journal Entries hitting Undeposited Funds, that’s your red flag.

The fastest way to surface them:

1. Run a General Ledger or Transaction Detail by Account report.
2. Filter Account = Undeposited Funds.
3. Filter Transaction Type = Journal Entry.
4. Set the date range to your diagnostic period (e.g., last 12–24 months).

Now you’ll see every JE that touched Undeposited Funds, with the offsetting accounts and dates.

A classic example:

• 03/31/2024 Journal Entry #45
  • Debit Undeposited Funds $10,000
  • Credit Sales Income $10,000
    Memo: "clear old deposits"

The Undeposited Funds list still shows a pile of old customer payments from 2022–2023. The JE didn’t clear those items; it just forced the GL balance to something the prior bookkeeper liked the look of.

Key red flags to look for:

• Journal entries dated at month-end or year-end hitting Undeposited Funds
• Offsetting accounts like Sales, Other Income, Ask My Accountant, or Owner’s Draw
• Large round-dollar amounts ($5,000, $10,000, $25,000) with vague memos
• Multiple JEs in a row trying to "zero out" Undeposited Funds
• JEs posted long after the original customer payments

What happens if you just live with it

Letting these journal entries stand is tempting, especially when the bank is reconciled and the client is impatient. But they create a quiet mess that shows up everywhere: revenue, cash, A/R, and future cleanup work.

The damage inside your numbers

Here’s what those JEs actually do under the hood:

• Double-counted or missing income. If the original payments and deposits were already recorded (even if mismatched), a JE crediting Sales can overstate revenue. Or a JE debiting Sales to "fix" something can understate it.
• Misstated cash vs. Undeposited Funds. You can end up with deposits in the bank that don’t tie to any customer payments, and payments in Undeposited Funds that never hit the bank. The JE just moves balances around on paper.
• A/R and customer history break. When you bypass the Receive Payment → Deposit workflow, customer invoices may show as unpaid even though the bank has the money. Or the opposite: invoices marked paid with no real deposit trail.
• Audit and due diligence headaches. Anyone doing a deeper review (banker, buyer, auditor, new CPA) will see Undeposited Funds JEs and immediately question the reliability of cash and revenue.

Once you start building tax returns, valuations, or advisory work on top of those numbers, you’re compounding the problem.

The damage in client conversations

From the client’s perspective, the books "look fine":

• Bank reconciliations show as done.
• P&L shows healthy revenue.
• Balance sheet doesn’t have a huge Undeposited Funds balance anymore.

But when you dig in and explain that the "cleanup" JE:

• Didn’t actually clear the Undeposited Funds list
• May have distorted revenue in prior periods
• Makes it harder to prove what was really collected and when

…you’re suddenly having a much harder conversation about trust in the numbers and potential rework. It’s better to catch and explain this pattern up front, during your diagnostic, than after you’ve already quoted or started the engagement.

How to unwind bad Undeposited Funds journal entries

The good news: the pattern is consistent enough that you can build a repeatable approach.

Here’s a practical workflow:

1. Identify all JEs hitting Undeposited Funds.

   • Use the GL / Transaction Detail by Account report as described earlier.
   • Export to Excel or Google Sheets if there are more than a couple.

2. Segment by period and materiality.

   • Group JEs by year and by size.
   • Decide your lookback: e.g., fully fix current year, document and possibly leave prior closed tax years unless the client wants a restatement.

3. Understand what the JE was trying to fix.

   • For a sample of entries, drill into the date range around the JE.
   • Look at the Undeposited Funds list, bank deposits, and customer payments for that period.
   • Was the JE trying to zero out Undeposited Funds? Force revenue to match the bank? Clear old items?

4. Reverse and replace with proper workflow (for periods you’re fixing).

   • Reverse the JE as of an appropriate date (often the same date or the start of the following period).
   • Rebuild the correct trail: Receive Payment / Sales Receipt → Bank Deposit that matches the actual bank statement.
   • Match deposits to the bank feed where possible.

5. Clean the Undeposited Funds list itself.

   • After reversing JEs, run the Undeposited Funds detail report.
   • Systematically clear old items by either:
     • Matching to real deposits, or
     • Voiding/reclassing if they were duplicates or errors, with clear memos.

6. Document what you’re not fixing.

   • For older years you’re leaving as-is, add workpaper notes: which JEs exist, why they weren’t unwound, and any known distortions.
   • Make sure tax returns and management reports are interpreted in that context.

Turning this into a standard diagnostic habit

This shouldn’t be something you "remember to check" only when Undeposited Funds looks weird. It belongs on your standard QBO diagnostic checklist.

A simple pattern:

• During your initial review, run the Undeposited Funds GL filtered to Journal Entries for the last 12–24 months.
• If you see any JEs, tag the file as having a cash/UF structural issue.
• Use that to inform your cleanup scope, quote, and timeline.

This is also where automation helps. A diagnostic tool like CleanupOwl can scan the file and hand you a list of every JE that touched Undeposited Funds, with dates, amounts, and offsetting accounts. Instead of spending 30–60 minutes building that list manually, you start your review with the problem transactions already surfaced.

If you’re a business owner, this is the kind of question you can ask your accountant: "Are you checking for journal entries to Undeposited Funds, and if so, how? Manually or with a diagnostic tool like CleanupOwl?"

The patterns you’ll keep seeing in client files

Here are some common real-world scenarios and how they show up:

Not every JE to Undeposited Funds justifies a full forensic rebuild. Some are small, ancient, and immaterial; some are in years you and the client have agreed not to reopen. But they all deserve at least a conscious decision: fix, partially fix, or document and move on.

Tools like CleanupOwl can help you quickly distinguish between "one oddball JE from 2018" and "a pattern of monthly JEs that completely undermine cash and revenue." That way, your team spends its time where it actually matters.

Making this part of your cleanup playbook

Undeposited Funds is already a known trouble spot in QBO. Adding journal entries into the mix turns it from a simple cleanup task into a structural integrity issue for cash and revenue.

That’s why this deserves its own checklist line: "Scan for journal entries hitting Undeposited Funds and decide fix vs. document." It’s a small step that can save you from quoting too low, mis-stating revenue, or spending hours untangling someone else’s "quick fix" halfway through the engagement.

For firms, the goal is a repeatable diagnostic: same reports, same filters, same decision framework, every time. Whether you pull those reports manually or let CleanupOwl run the checks and hand you the list, the important part is that the check always happens.

If you’re a business owner, this is one of those behind-the-scenes things that separates "data entry" from real accounting. Ask your accountant how they make sure Undeposited Funds is cleared properly and not patched with journal entries.