How to Fix Undeposited Funds in QuickBooks: A Simple Guide

In the complex ecosystem of small business accounting, the Undeposited Funds account in QuickBooks serves as a critical staging area. However, for many users, this account becomes a source of significant confusion, leading to duplicate income, mismatched bank statements, and skewed financial reporting.

We understand that maintaining a pristine general ledger is paramount to your business’s financial health. This guide provides a definitive, step-by-step framework for identifying, resolving, and preventing errors within the Undeposited Funds workflow.

The Fundamental Purpose of Undeposited Funds

To fix the issues associated with this account, one must first master its conceptual framework. The Undeposited Funds account is a temporary “holding tank” for payments that have been received but have not yet been physically deposited into your bank account.

Imagine receiving three separate checks from three different clients on a Tuesday. You record each payment in QuickBooks. However, you do not go to the bank until Friday, at which point you deposit all three checks as a single consolidated sum.

If you were to record each payment directly into your “Checking” account in QuickBooks, your software would show three individual transactions, while your bank statement would show one single deposit.

This discrepancy makes bank reconciliation nearly impossible. By using Undeposited Funds, we bridge the gap between individual sales and bulk bank deposits.

Identifying Common Errors in Undeposited Funds

Before we apply the fix, we must diagnose the symptoms. The most frequent error occurs when a user records a payment to Undeposited Funds but then later records the bank deposit manually as “Income” or “Sales” via the Bank Feed.

This effectively double-counts your revenue: once when the invoice was paid, and a second time when the bank deposit was categorized directly to an income account.

Signs your Undeposited Funds account needs attention:

• Your Balance Sheet shows an unusually high balance in Undeposited Funds that does not reflect actual cash on hand.
• You see “ghost” payments appearing in your Bank Deposit window that date back months or years.
• Your Profit and Loss statement shows inflated income figures that do not align with your actual bank deposits.

Step-by-Step Resolution: How to Clear Undeposited Funds

We recommend a systematic approach to cleaning up this account to ensure no data is lost and your books remain balanced.

1. Review the Undeposited Funds Detail

The first step is to see exactly what is sitting in the account.

Navigate to your Chart of Accounts, find Undeposited Funds, and select View Register.

Alternatively, go to the + New button and select Bank Deposit. This window will display every payment that QuickBooks believes is waiting to be taken to the bank.

2. Match Payments to Existing Bank Deposits

If you find old payments that have already been deposited into your bank account (but were recorded incorrectly), you must link them.

• Identify the date and the total amount of the deposit on your Bank Statement.
• In the Bank Deposit window in QuickBooks, select the specific payments that made up that total.
• Ensure the “Account” selected at the top is the correct bank account.
• Ensure the Date matches the actual deposit date.
• Save the transaction.

3. Correcting Duplicated Income (The “Bank Feed” Trap)

If you accidentally categorized a deposit from your bank feed as “Sales Income” instead of matching it to an invoice payment, follow these steps:

1. Go to the Banking or Transactions menu.
2. Select the Categorized or In Business tab.
3. Find the deposit in question and select Undo.
4. The transaction will move back to the For Review tab.
5. Now, go to Bank Deposit (under the + New menu) and create the deposit using the payments sitting in Undeposited Funds.
6. Return to the Banking tab; QuickBooks should now show a “Match Found” for that deposit. Select Match.

Advanced Troubleshooting: Handling Stale Payments

Sometimes, you may find payments in Undeposited Funds from prior fiscal years. Caution is required here, as changing these could alter your previously filed tax returns.

Handling Uncollectible or Error Entries

If an entry in Undeposited Funds is a result of a mistake (e.g., an invoice was paid twice in the system but only once in reality), you cannot simply delete it if the period is closed.

Instead:

• Create a Journal Entry to credit Undeposited Funds and debit the appropriate account (often a “Clearing” account or “Bad Debt” if applicable).
• Consult with your CPA before adjusting balances in closed sets of books.

The Golden Workflow: Preventing Future Issues

To ensure your Undeposited Funds account remains accurate moving forward, we advise adopting the Three-Step QuickBooks Sales Process:

1. Receive Payment

When a customer pays an invoice, use the Receive Payment feature. Ensure the “Deposit to” field is set to Undeposited Funds.

2. Group Deposits

When you are ready to record the actual bank deposit, use the Bank Deposit tool. Select all individual payments that are included in that specific bank trip.

3. Match in Banking

When the deposit appears in your Bank Feed, it will automatically find a match with the Deposit transaction you created in Step 2. Click Match to reconcile.

Crucial Settings to Automate Accuracy

We can streamline this process by adjusting your QuickBooks settings. You can set the default “Deposit to” account to avoid manual errors.

• Go to Settings (Gear Icon) > Account and Settings.
• Select Sales.
• In the Sales form content section, ensure that your preferences align with your workflow.

While you cannot always “lock” Undeposited Funds, training your staff to look at the “Deposit To” dropdown is the best defense against errors.

Frequently Asked Questions (FAQs)

Why is my Undeposited Funds balance different from my bank balance?

The Undeposited Funds balance represents money you have received but not yet deposited. Your Bank Balance represents cleared funds.

These will rarely match unless you have zero pending deposits. If the Undeposited Funds balance is excessively high, it usually indicates that payments were recorded but the final Bank Deposit step was skipped.

Can I bypass Undeposited Funds entirely?

Yes. If you receive a single payment and deposit it immediately into the bank as a standalone transaction, you can select your Checking Account directly in the “Deposit to” field of the Receive Payment screen.

However, we do not recommend this if you combine multiple checks or cash into a single deposit, as it will break the reconciliation link.

How do I fix a deposit that was put into the wrong bank account?

Go to the Bank Deposit in QuickBooks, change the Account dropdown at the top to the correct bank account, and select Save and Close.

If the transaction was already reconciled, you will need to unreconcile it first, which may require an accountant’s access.

What happens if I delete a transaction in Undeposited Funds?

Deleting a payment will essentially “unpay” the invoice associated with it. The invoice will return to an Open status.

If the payment was legitimate, do not delete it; instead, use the Bank Deposit tool to move it to the correct ledger.

Why does QuickBooks Online create a “New Deposit” instead of matching?

This typically happens because the amounts or dates do not match perfectly.

If your bank deposit was $1,000.50 and your QuickBooks record is $1,000.00, the software will not see the match.

Ensure that any bank fees or merchant processing fees are accounted for in the “Add funds to this deposit” section of the Bank Deposit screen to make the totals align.

Conclusion: Financial Clarity Through Better Processes

Maintaining the integrity of your Undeposited Funds account is not merely a matter of “cleaning up” software; it is about ensuring your financial statements accurately reflect your business’s performance.

By following the “Receive-Deposit-Match” workflow, we ensure that every dollar is accounted for, duplicate income is eliminated, and the bank reconciliation process becomes a simple, stress-free task.

Regularly auditing your Bank Deposit window—ideally once a week—will prevent the accumulation of “stale” payments and keep your Balance Sheet audit-ready.

If you encounter complexities involving prior-year adjustments, we always recommend consulting with a certified QuickBooks ProAdvisor or your corporate accountant to maintain compliance with standard accounting principles.