QuickBooks Undeposited Funds Cleanup: How to Clear the Account
No account needed for your first conversions. We never store your bank login.
Undeposited Funds is a QuickBooks holding account for money you have received but not yet deposited to the bank. It balloons when you record customer payments and never group them into a deposit that matches your bank statement, so the account shows income that has effectively landed nowhere. The cleanup is to find those stranded payments and either deposit them or match them to the deposit that already cleared, until the account balance is zero or equals only genuinely undeposited checks.
This is one of the most common messes a bookkeeper inherits, and it quietly inflates both your bank reconciliation and your income. Here is what causes it, how to read the account, and the step-by-step way to clear it without double-counting revenue.
What is the Undeposited Funds account in QuickBooks?
Undeposited Funds is a current-asset clearing account that holds customer payments between the moment you record them and the moment you deposit them. It exists so QuickBooks can group several payments into one bank deposit that matches the single lump sum your bank shows. Used correctly, money flows in when you receive a payment and flows out when you record the deposit, and the account returns to zero. Left alone, every un-deposited payment piles up.
Why does my Undeposited Funds balance keep growing?
The balance grows because payments go in but deposits never take them out. The usual cause is recording a customer payment with Undeposited Funds as the destination, then entering the bank deposit as a separate transaction (or matching it from the bank feed) instead of using Bank Deposit to clear the payment. QuickBooks then counts the money twice on the books: once stuck in Undeposited Funds and once in the bank. Duplicate payment entries and payments applied to the wrong invoice make it worse.
How do I clean up Undeposited Funds in QuickBooks Online?
Open the Undeposited Funds register or run a balance-sheet detail on the account, then work oldest to newest. For each stranded payment, confirm the deposit actually hit the bank, then use New, Bank Deposit, tick the payment, and record the deposit to the correct bank account so it clears out of Undeposited Funds. If a matching deposit was already entered directly to the bank, delete or reclassify that duplicate rather than adding a second one. Reconcile as you go so the bank balance stays right.
How do I match undeposited payments to a bank deposit?
Group the payments the way your bank did. If the bank shows one $1,240 deposit made up of three checks, select those three payments together in Bank Deposit so they total $1,240 and clear as one line. Matching the group, not each payment individually, is what makes the bank feed line reconcile cleanly. It helps to cross-check each payment against the invoice it paid, which is simpler when your invoices are already in a spreadsheet you can sort by amount and date.
What happens if I just delete Undeposited Funds entries?
Deleting a payment out of Undeposited Funds also un-applies it from its invoice, which reopens the invoice and understates your income. Do not delete genuine payments to force the balance down. Delete only true duplicates, the entries where the same payment was recorded twice. For real payments that were already deposited, the fix is to match them to the deposit or move the deposit, never to erase the income.
How do I stop Undeposited Funds from filling up again?
Pick one consistent path for received money and stick to it. If you group deposits, always clear payments through Bank Deposit before you match the bank feed line. If you deposit each payment on its own, set the customer payment to go straight to the bank account instead of Undeposited Funds. Reconcile every month, because a monthly reconciliation surfaces a stranded payment within weeks instead of letting a year of them accumulate.
Undeposited Funds cleanup checklist
| Step | What to check | Fix |
|---|---|---|
| 1. Pull the detail | Every open item sitting in Undeposited Funds | Run the account detail, sort by date |
| 2. Confirm the deposit cleared | Does a matching deposit show on the bank statement? | Match the payment to that deposit |
| 3. Find duplicates | Same payment recorded twice, or deposited directly and left in UF | Delete only the true duplicate |
| 4. Group correctly | Payments that made up one bank deposit | Clear them together in Bank Deposit |
| 5. Reconcile | Bank balance after clearing | Reconcile the month to lock it |
Does fixing Undeposited Funds change my income?
Done correctly, no. Matching a stranded payment to the deposit that already cleared moves money from the clearing account to the bank without touching revenue, because the income was recorded when you received the payment. Your income only changes if you incorrectly delete real payments or find that a payment was genuinely never recorded as income at all. That is why you match and reconcile rather than delete.
Why does the bank feed create duplicate deposits?
The bank feed is the single biggest source of Undeposited Funds duplicates. When a deposit clears, the feed pulls it in as a new transaction and offers to add it. If you click Add instead of Match, QuickBooks posts a brand-new deposit straight to the bank while the original payments stay stuck in Undeposited Funds. Now the money is on the books twice. Always look for a Match on deposit lines, and use Bank Deposit to clear the underlying payments first so the feed has something to match against.
How long does Undeposited Funds cleanup take?
A few stranded payments take an hour. A year of un-cleared payments on an active account can take a full day, because you have to tie each one to a real deposit on the statement and unwind every duplicate the bank feed created. Budget the time by counting the open items in the account detail: expect a handful of minutes per item once you have the bank statements open beside you. Reconciling each month afterward keeps the next cleanup down to minutes.
Once received money is clean, the other half of a tidy set of books is the transactions coming in from the bank. If a client account has no live feed or the feed stops at 90 days, export the history as a CSV and use the CSV to QBO converter for accountants and bookkeepers to import it as a .qbo, then work through the QuickBooks cleanup checklist for a new client and price the job with the QuickBooks cleanup cost guide.