The undeposited funds account is a holding spot for payments you’ve received but haven’t yet deposited at the bank. When this account has a large or growing balance that doesn’t match actual cash waiting to go to the bank, something went wrong in the data entry process.

Run a report first to see what’s actually in there. In QuickBooks Desktop, go to Reports, then Accountant & Taxes, then Deposit Detail. In QuickBooks Online, run a Transaction Detail report filtered to the Undeposited Funds account. This shows every payment sitting in the account with dates, amounts, and customer names.

Most undeposited funds problems fall into a few categories. Old payments that were received and recorded but never deposited in QuickBooks create a balance that doesn’t exist in reality. The money went to the bank months ago but QuickBooks still thinks it’s waiting. Duplicate entries happen when a payment was recorded as a receive payment and also entered directly as a deposit. Now it exists twice in your books.

For legitimate payments that were never properly deposited in QuickBooks, create a bank deposit using those items. Go to the Bank Deposits screen and select the payments that should have been deposited together. Match the deposit total to an actual historical deposit on your bank statement. This clears the items from undeposited funds and records the deposit properly.

For duplicates, you need to determine which entry is correct. If the payment was recorded against an invoice and also entered as a direct deposit, delete the direct deposit entry. The payment linked to the invoice is usually the correct one because it closed out what the customer owed. Deleting the wrong entry will reopen invoices or throw off your bank reconciliation.

After making corrections, reconcile the affected bank accounts. The reconciliation process will confirm whether your cleanup worked or if you introduced new problems. If your beginning balance changed unexpectedly, you deleted something from a previously reconciled period and need to investigate further.

Going forward, always use the two-step process. Record payments when received, then create deposits that match your actual bank deposits. Never enter deposits directly to the bank account when they relate to customer payments. Controller-level oversight catches these workflow breakdowns during monthly review before the undeposited funds balance gets out of control.

If the account has years of accumulated items or you’re not confident identifying which entries are duplicates, this is a job for someone who can trace transactions back to source documents. Controller services in Boca Raton include reviewing and correcting exactly these kinds of issues so your financial statements actually reflect reality. Cleaning up undeposited funds incorrectly can throw off revenue recognition, bank reconciliations, and accounts receivable all at once.