QuickBooks Undeposited Funds: why the balance keeps growing, and how to clear it

    Undeposited Funds is a real account doing a real job, but a balance that never goes down means payments got recorded and never deposited. Here is what causes it, what it does to your numbers, and how to clear it without a journal entry.

    Small Business Bookkeeping · 6 min read

    Jacob Sheldon ·

    Undeposited Funds is the account people notice when they finally look at their balance sheet and find several thousand dollars in a line they never created. The money is not missing, and the account is not a bug. What the balance is telling you is that payments went in and never came out.

    It is worth understanding the account before clearing it, because the fastest way to make the number go to zero is also the way that leaves the file worse than it started.

    What the account is actually for

    Undeposited Funds exists because of a gap in the real world.

    A customer pays you on Monday. Two more pay you on Tuesday. On Wednesday you take all three to the bank, and the bank records one deposit. Your books need to show three separate payments applied to three separate invoices, and your bank statement shows one number. Something has to hold the payments in between.

    That is the job. QuickBooks calls it Undeposited Funds, and older accounting systems called it an undeposited receipts or cash-on-hand account. When you use Receive Payment, the money leaves Accounts Receivable and sits here. When you use Bank Deposit and select those payments, they leave here and land in checking as one line that matches the statement.

    Two steps, and the account should empty out every time the second one runs.

    Why the balance grows instead

    The balance grows when the first step happens and the second one does not.

    Someone records the payment, the invoice correctly shows as paid, the customer stops getting reminders, and everything visible looks finished. Nobody has a reason to go back. Meanwhile the money is still parked in a holding account, and the next payment lands on top of it.

    There is a second cause that does more damage, and it comes from the bank feed.

    The deposit shows up in the feed a few days later. QuickBooks offers two things to do with it: match it to something already in the file, or add it as a new transaction. Add is the bigger, more obvious button, and it works, in the sense that the feed goes quiet and the bank line gets cleared. What it actually did was create a second transaction for money that was already recorded. The deposit now hits income directly, the original payment stays in Undeposited Funds with nothing to pair it with, and the revenue for that month counts the same sale twice.

    That is the version worth checking for, because it does not announce itself. The bank feed is empty, the reconciliation may even balance, and the only visible symptom is a holding account that climbs every month and never falls.

    What it does to the numbers

    The balance sheet overstates current assets, because money shown as held is money that already reached the bank under a different transaction.

    Accounts receivable can read clean while the underlying payments are unresolved, which makes collections reporting look better than it is.

    Where a bank feed added deposits as new income, revenue is overstated by the amount of the duplicate, and that flows into net income, into any metric built on revenue, and into the return if it is still there at year end. Someone reading your gross margin is reading a number with sales in it that only happened once.

    Reconciliation is where it usually surfaces. The account keeps reconciling because the bank side is fine. The month-end review is what catches it, when the balance sheet gets read rather than just closed.

    Reading yours

    Start from the register rather than the total, the same way you would with any holding account.

    Open the chart of accounts, find Undeposited Funds, and open the account register or run a transaction detail report against it. Set the date range wide enough to reach the beginning of the file. You want the individual payments, not the balance.

    Sort by date and look at the oldest first. Compare what you see against how often you actually deposit. If deposits go in weekly, anything older than about two weeks is stranded, and the date is the diagnosis: a payment sitting there from March was recorded, and its deposit either never happened or happened as a separate transaction somewhere else.

    Then take a few of the oldest ones and search the bank register for the same amount around the same date. Finding a deposit that already posted to income confirms the bank feed cause. Finding nothing means the deposit step was simply never run.

    Clearing it

    Clear it by finishing the work, not by making the number go away.

    Group the stranded payments into the deposits that actually happened. Open Bank Deposit, choose the bank account the money went to, and select the payments that made up one real statement line. The total on the screen has to equal the total on the statement. Date it the day the bank shows the money arriving, not today. Repeat for each deposit. This is slow and it is also the whole job, because it is the step that was skipped in the first place.

    Where a duplicate deposit already posted to income, remove the duplicate rather than the payment. The customer payment is the correct record, since it is the one tied to the invoice. The bank feed entry is the one that invented a second sale. Delete it, then include the original payment in a Bank Deposit so the bank line has something real to match.

    Where a payment has no deposit and no bank activity behind it at all, find out why before touching it. A payment recorded for money that never arrived is a different problem, and writing it off is a decision about the customer, not a cleanup step.

    Watch for processing fees. If payments come through a card processor, the deposit is usually the gross amount minus a fee, so the batch will not tie until the fee is recorded as an expense on the same deposit. QuickBooks allows a line for it directly on the Bank Deposit screen.

    Work forward chronologically and reconcile as you go. Fixing the oldest month first means each later month has a clean opening position, and the ones after it get easier rather than harder.

    What not to do

    Do not journal the balance to zero. It reads as finished, the payments stay unlinked underneath, and the next reconciliation inherits the same mess with the audit trail now pointing at your journal entry rather than at the missing deposits.

    Do not delete the payments to flatten the account. Deleting them reopens every invoice they were applied to, and the customer balances that were correct stop being correct.

    Do not fix a filed year by editing it. Correct the current period instead, so the numbers a return was built on stay where they were.

    Keeping it at zero

    The account stays clean when the two steps stay joined together. Record the payment, then deposit it in the same session, grouping payments the way the bank will group them.

    In the bank feed, treat Match as the default and Add as the exception. If a deposit has no match offered, the reason is worth ten seconds of attention, because it usually means the payment behind it was never entered or was entered for a different amount.

    Then read the balance once a month as part of the close. Undeposited Funds is one line on the balance sheet, and its age tells you whether the payment process ran or stalled. A holding account with nothing old in it is a process working. A holding account that only ever grows is a step nobody has run since the file was set up.

    Frequently asked questions

    Not always, and that is what makes it harder to read than a holding account that should always be empty. It is legitimately holding money between the day you record a payment and the day it lands in the bank. What matters is the age of what sits there. A few days of recent receipts is the account working. Items from months ago are stranded.

    No. QuickBooks marks it as a default account and will not let you remove it, and you would not want to. The account is doing real work, modelling the gap between a customer paying you and the money reaching your bank. The problem is never the account itself, it is payments that were put in and never taken out.

    They are different accounts with a related cause. Unapplied Cash Payment Income appears on a cash-basis profit and loss when a customer payment is not linked to an invoice. Undeposited Funds sits on the balance sheet and holds payments that were linked to invoices but never deposited. You can have one without the other, and a file with sloppy payment entry often has both.

    Usually because the bank shows one line for a batch and QuickBooks holds the individual payments. That is the situation the account exists for, and the fix is to select every payment in the batch on one Bank Deposit so the total matches the statement line. If it still will not match, look for a merchant processing fee taken out before the money arrived.

    The balance on its own does not, because recording the payment did not create revenue, the invoice did. Revenue gets overstated when the bank feed is used to add the deposit as a new sale instead of matching it to the payment already recorded. Then the same money is counted twice and the original payment is left behind in Undeposited Funds.

    Back to the start of any period that is still open. Anything inside a year that has been filed should be corrected by adjusting the current period rather than by editing closed transactions, since changing a filed year moves numbers a return was built on.

    The QuickBooks cleanup checklist

    Every step, in the order the work is actually done, from the first backup through locking the closed periods. Works for Xero too.

    We'll only email you about this. Unsubscribe anytime.

    Find out what is actually wrong with your books.

    Share accountant access to QuickBooks or Xero 48 hours ahead and we will spend twenty minutes going through what is broken, ranked, with what each one costs you. You keep the findings whether or not you work with us.

    Book the teardown