MVPMost Valued Partner
Home/Blog/What is Undeposited Funds in QuickBooks? A contractor's guide

Bookkeeping 5 min read

What is Undeposited Funds in QuickBooks? A contractor's guide

Undeposited Funds is a holding account for payments you have received but not banked. Here is how it works and why the balance keeps growing.

Undeposited Funds is a holding account in QuickBooks Online for customer payments you have received but not yet put in the bank. It exists so that three checks deposited together show up in QuickBooks as one deposit, the same way they appear on your bank statement. If the balance in that account keeps growing, payments are going in and nobody is recording the deposit that takes them out, and your income may be overstated.

What is the Undeposited Funds account for?

Intuit describes it as a temporary account that holds payments you plan to deposit later at the bank. Think of it as the envelope in the office drawer where checks sit until someone drives to the bank.

Here is why it matters. Say a small electrical shop collects three payments on a Tuesday:

  • $1,200 check from one customer
  • $850 check from another
  • $2,400 check from a third

The office deposits all three on Wednesday. The bank statement shows one line: $4,450. If QuickBooks had put each payment straight into the checking account, you would have three lines that don't match anything on the statement, and reconciling would be a guessing game. With Undeposited Funds, the three payments wait in the holding account, you record one bank deposit of $4,450, and it matches the bank line exactly.

The same thing happens with card payments. Your processor pays out one lump for several jobs, usually minus fees. The lump is the deposit. The individual payments are what sat in the holding account.

One note on naming: Intuit's article says the account can be renamed, so in your file it may appear under another name such as Payments to deposit. To find it, open the chart of accounts and look for "Undeposited Funds" in the Detail type column.

How is it supposed to work?

There are two steps, and the trouble always comes from skipping the second.

  1. Receive the payment. When you record a payment against an invoice, the "Deposit to" field is set to Undeposited Funds. The invoice is marked paid, and the money sits in the holding account.
  2. Record the bank deposit. When the money goes to the bank, you create a bank deposit in QuickBooks and tick the payments that were in that deposit. Intuit notes that all payments in Undeposited Funds automatically appear in the Bank Deposit window. The total moves from the holding account to checking.

After step 2 the holding account goes back toward zero. On a healthy set of books, the balance equals only the payments collected in the last few days that haven't reached the bank.

Intuit also says you don't need to do this for invoice payments processed through QuickBooks Payments, because QuickBooks handles those for you.

Why does the balance keep growing?

The bank feed deposit was added as new income

This is the most common cause. The deposit shows up in the bank feed, and whoever is working the feed categorizes it as sales income and clicks Add. The payments in Undeposited Funds never get cleared, so they sit there forever. Worse, the income is now recorded twice: once when the invoice was created, and once when the deposit was categorized as sales.

Owners ask about this often. One thread on Intuit's community forum is titled "Why are my paid invoices and then when I deposit them are double counted as profit?" The answer there is the one above: the deposits were never linked to the customer payments.

Your job software sends payments in, and nobody finishes the job

Field-service apps can post synced payments to Undeposited Funds. Jobber's sync even throws an error, "Undeposited funds account not found," if the account is missing. That design is correct. But the sync only does step 1 unless payout syncing is also set up and working. If it isn't, someone in the office has to do step 2, and often nobody knows that.

Payments were recorded twice

A payment gets entered by hand in QuickBooks and also arrives through the sync. One copy gets deposited. The other stays in the holding account.

How do you know if you have a problem?

Run a balance sheet as of today and find the Undeposited Funds line. Then ask one question: do we really have that much money sitting in the office waiting to go to the bank?

  • A balance equal to a few days of collections is normal.
  • A balance of tens of thousands of dollars, in a shop that deposits every week, is not.
  • A balance that only ever goes up is a sign that step 2 is being skipped.

Click the balance to open the detail. If you see payments from last year still sitting there, the deposits for those were almost certainly entered some other way.

How do you fix it going forward?

  1. When a deposit appears in the bank feed, look for a match first. If the payments are in Undeposited Funds, create the bank deposit, select those payments, and then match the feed line to that deposit.
  2. For card payouts, add the processing fee as a negative line on the deposit so the net equals what hit the bank.
  3. Never categorize a customer deposit as sales income if an invoice already exists for that job.
  4. Check the Undeposited Funds balance at every month end. It should be explainable in one sentence.
  5. If your job software can sync payouts as well as payments, turn that on and map the fee account, then confirm it works on one real payout.

What about the old balance?

Go carefully here. Old payments stuck in the holding account usually mean income was double counted in past periods. Fixing them changes prior-period numbers, and some of those periods may already be reconciled or reported on a tax return.

The safe order is: work one month at a time, link each old deposit to the payments it contained, and check that the bank reconciliation still holds after each month. For anything touching a year you have already filed, talk to your CPA before changing it. We are bookkeepers, not accountants, so on our QuickBooks cleanup work we fix the records and flag anything that affects a filed return for your CPA to decide.

Once it is clean, keeping it clean is routine work that belongs in monthly bookkeeping.

If you're not sure whether your balance is normal, our free systems check will tell you.

Start with a free systems check.

Twenty minutes on a call. You get a written list of what we found and a fixed quote, whether or not you hire us.

  • Fixed price, quoted before any work starts
  • Every account stays in your name
  • Month to month after the first three months

We reply within one business day. No sales calls, no mailing list.