If you’ve ever opened Undeposited Funds in QuickBooks Online and wondered why there’s a balance sitting there that you can’t explain, you’re not alone.
One of the most common questions I hear from business owners is: “What is Undeposited Funds in QuickBooks Online, and why won’t it clear?” It’s one of the most misunderstood features in QuickBooks Online—and one of the most common reasons I see duplicate income, bank reconciliation problems, and inaccurate financial statements.
As a CPA and QuickBooks ProAdvisor, I regularly find Undeposited Funds issues when reviewing QuickBooks Online files for new bookkeeping clients. Fortunately, once you understand how the account is supposed to work, it’s actually one of the most useful tools in QuickBooks.
Let’s look at what it is, the mistakes to avoid, and how to use it correctly.
*At Melton Bookkeeping & Accounting Services, we help small businesses throughout Marshfield, Springfield, and Southwest Missouri clean up QuickBooks Online, maintain accurate monthly bookkeeping, and prepare tax-ready financial statements. Many of the issues discussed in this article are problems we regularly solve for our clients.
❌ The Most Common Undeposited Funds Mistakes in QuickBooks Online
Many business owners don’t fully understand the purpose of the Undeposited Funds account in QuickBooks Online.
As a result, they accidentally create bookkeeping errors such as:
- Customer payments remain in Undeposited Funds for weeks or months.
- Sales receipts are never included in a bank deposit.
- Deposits are entered manually through the Bank Deposit screen and then downloaded again through the bank feed.
- Customer payments are recorded correctly, but another deposit is created and coded directly to an income account.
- Deposits are recorded twice—once when payment is received and again when the money reaches the bank. Payments downloaded from the bank feed are added instead of matched.
The result is often an Undeposited Funds account that continues to grow with old transactions that should have cleared long ago.
⚠️ Why Incorrect Undeposited Funds Transactions Create Accounting Problems
Misusing Undeposited Funds affects much more than one account in QuickBooks.
Your income may be overstated.
One of the most common mistakes is recording customer payments correctly and then recording the bank deposit as new income.
This duplicates your revenue.
Your Profit & Loss Statement may show thousands—or even hundreds of thousands—of dollars in sales that never actually occurred.
Your bank reconciliations become difficult.
Deposits that don’t match your actual bank deposits make reconciliation much more complicated.
You’ll often see outstanding deposits that never clear or deposits that don’t match your bank statement.
Your financial statements become unreliable.
If income is duplicated, every financial report based on that information becomes inaccurate.
That means you may be making important business decisions using incorrect numbers.
Your tax return may also be incorrect.
Because taxable income is based on your accounting records, duplicated income can result in paying more tax than you actually owe.
Undeposited Funds becomes a “mystery account.”
When transactions remain in Undeposited Funds month after month, it becomes difficult to determine which payments have actually been deposited and which still require attention.
✅ The Correct Way to Handle Undeposited Funds in QuickBooks Online
Undeposited Funds has one very specific purpose.
It acts as a temporary holding account for customer payments until those payments are grouped together exactly the way they appear on your actual bank deposit.
For example:
Suppose you receive three customer checks during the day:
- Customer A pays $500.
- Customer B pays $750.
- Customer C pays $250.
At the end of the day, you make one bank deposit totaling $1,500.
The proper workflow in QuickBooks Online is:
- Record each customer payment using “Receive Payment” or create a “Sales Receipt”.
- Allow QuickBooks to place those payments into Undeposited Funds.
- Open the “Bank Deposit” screen and select those three customer payments.
- Create one deposit totaling $1,500
- When the deposit downloads through the bank feed, use the “Match” feature instead of adding a new transaction.
Now your QuickBooks records match your actual bank deposit exactly. That’s how QuickBooks Online was designed to work.
💡 A CPA’s Insight: Undeposited Funds Is Not an Income Account
One of the biggest misconceptions I see is treating the Bank Deposit screen like a place to record sales.
It isn’t.
Your income is recorded when you create the invoice or sales receipt—not when the money reaches your bank account.
Undeposited Funds simply holds customer payments temporarily until they are deposited.
Think of it like the cash drawer in a retail store.
Throughout the day, customers hand you checks, cash, and credit card payments.
Those payments belong to the business immediately.
They’re simply waiting to be taken to the bank.
That’s exactly what Undeposited Funds represents.
When you record the bank deposit correctly, you’re simply moving money from one asset account (Undeposited Funds) to another asset account (your checking account).
No additional income should be created.
Understanding this simple accounting concept helps prevent one of the most common QuickBooks mistakes I see.
📖 A Real-Life Example: A $300,000 Duplicate Income Error
One of my favorite examples of why understanding Undeposited Funds matters comes from a client I took on several years ago.
Their prior year’s tax return had already been filed when I began reviewing their QuickBooks Online file.
As part of my review of their QuickBooks file, I completed the July bank reconciliation. Something immediately caught my attention.
The reconciliation report showed approximately $300,000 of outstanding deposits. Even more concerning… the deposits were dated in the previous year!
Outstanding checks may remain uncleared for weeks or even months. Deposits typically clear the bank within a day or two. That told me something wasn’t right.
After investigating, I discovered the problem.
The customer payments had originally been recorded correctly and were sitting in Undeposited Funds.
Later, instead of creating the bank deposit from Undeposited Funds, someone entered new deposits directly into a Sales account using the Bank Deposit screen.
The same income had been recorded twice.
To correct the problem, we reopened the prior year’s books, removed the duplicate deposits, and properly recorded the deposits from Undeposited Funds. Because the bookkeeping had overstated the company’s taxable income by approximately $300,000, we amended the client’s previously filed tax return.
Correcting that bookkeeping mistake reduced the client’s taxable income by approximately $300,000, resulting in a tax reduction of approximately $117,000.
The entire issue was discovered because one reconciliation report contained deposits that simply didn’t make sense.
It was a powerful reminder that good bookkeeping isn’t just entering transactions. It is understanding the accounting behind them. Understanding how Undeposited Funds works isn’t just about keeping QuickBooks organized—it can have a significant financial impact on the client.
✔️ Key Takeaways
Undeposited Funds isn’t a problem. Using it incorrectly is.
Remember these best practices:
✔ Record customer payments when you receive them.
✔ Use Undeposited Funds only as a temporary holding account.
✔ Create bank deposits that exactly match your actual bank deposits.
✔ Use the Match feature when the deposit appears in your bank feed.
✔ Never record the same deposit as income twice.
✔ Review your Undeposited Funds balance regularly. Old transactions should be investigated.
Following these steps will help keep your income accurate, your reconciliations clean, and your financial statements reliable.
❓ Frequently Asked Questions
What is Undeposited Funds in QuickBooks Online?
Undeposited Funds is a temporary holding account that stores customer payments until they are grouped into a bank deposit that matches your actual deposit at the bank.
Should Undeposited Funds always have a balance?
Most people would say, no. In my practice, however, I find that this is normal. Customer payments are not always deposited to the bank on the day they are received.
A small balance for very recent customer payments is normal, but older transactions often indicate that payments haven’t been deposited correctly or need to be investigated.
Why does my Undeposited Funds account keep growing?
The most common reasons are:
- Payments were never included in a bank deposit.
- Duplicate deposits were created.
- Deposits were recorded incorrectly to income.
- Payments were added from the bank feed instead of matched.
Can duplicate deposits affect my taxes?
Yes. If deposits are recorded as income more than once, your revenue and taxable income may be overstated, potentially causing you to pay more tax than necessary.
Why don’t my bank deposits match my bank statement?
One common reason is that customer payments were not grouped into deposits the same way they appeared at the bank. QuickBooks should mirror your actual bank deposits.
Can I simply delete transactions from Undeposited Funds?
Not necessarily. Before deleting anything, it’s important to determine why the transaction is there. Removing the wrong transaction can create even larger bookkeeping problems.
Can a CPA clean up my Undeposited Funds account?
Absolutely.
Cleaning up Undeposited Funds is one of the most common QuickBooks cleanup projects we perform. We identify duplicate transactions, correct deposits, reconcile accounts, and ensure your financial statements accurately reflect your business activity.
📞 How Melton Bookkeeping & Accounting Services Can Help
At Melton Bookkeeping & Accounting Services, we frequently help business owners clean up QuickBooks Online files with outdated or incorrect Undeposited Funds balances.
Whether you need a QuickBooks Online cleanup, ongoing monthly bookkeeping services, or help understanding your financial reports, we’ll make sure your customer payments, deposits, and bank reconciliations are handled correctly.
We proudly serve small businesses throughout Marshfield, Springfield, and Southwest Missouri, providing professional bookkeeping, accounting, QuickBooks Online cleanup, and tax-ready financial reporting.
If your Undeposited Funds balance doesn’t make sense – or your bank reconciliations never seem to balance – we would love to help.
Schedule a consultation today and let us help you gain confidence in your numbers with accurate, reliable bookkeeping.
Continue Reading the QuickBooks & Bookkeeping Mistakes Series
Want to avoid other common bookkeeping mistakes that can cost your business time and money? Check out the rest of the series:
- Bookkeeping Mistake #1: Why You Should Never Mix Personal and Business Finances
- Bookkeeping Mistake #2: Why Monthly Bank and Credit Card Reconciliations Matter
- QuickBooks Mistake #3: Understanding Undeposited Funds (And How to Avoid Duplicate Income)
- QuickBooks Mistake #4: Is Your Chart of Accounts Helping Your Business or Hurting It?
Each article is written specifically for small business owners and provides practical tips to help you maintain accurate books, understand your financial reports, and make better business decisions.
