How do I clean up undeposited funds in QuickBooks?
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.
Premium Controller & CFO Advisory Firm
Next Step:
Let's Talk About Your Business
Tell us about your business and your goals. We'll discuss how Jargo can support your financial operations and growth.
More Questions
What accounting challenges do construction companies face?
Construction accounting differs from standard business accounting due to job costing requirements, long project timelines, retention holdbacks, and complex subcontractor relationships. These factors make accurate financial tracking and cash flow management significantly harder.
Read answerWhat's the difference between S-Corp and LLC taxation?
Both are pass-through entities, but S-Corps can reduce self-employment taxes by splitting income between salary and distributions. The trade-off is higher compliance costs including mandatory payroll and stricter IRS scrutiny on reasonable compensation.
Read answerHow do dental practices manage patient billing and collections?
Dental billing involves coordinating insurance claims with patient responsibility. Most practices use dedicated practice management software to submit claims, track payments, and follow up on outstanding balances.
Read answerHow do I handle sales tax for online sales in Florida?
Florida requires online sellers meeting certain thresholds to collect sales tax based on the buyer's location. You'll need to register with the Department of Revenue, charge the correct combined state and county rate, and file returns on your assigned schedule.
Read answerHow do I manage cash flow for a seasonal business?
Managing seasonal cash flow requires forecasting your annual cycle, building reserves during peak months, and controlling expenses in the off-season. The goal is ensuring you have enough runway to cover fixed costs when revenue drops.
Read answerWhat financial reports should a fractional CFO provide?
A fractional CFO should deliver monthly financial statements, cash flow forecasts, KPI dashboards, and variance analysis with executive commentary. The value is in the interpretation and strategic recommendations, not just the reports themselves.
Read answer
