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
How much does an outsourced controller cost?
Outsourced controller services typically cost $2,000 to $5,000 per month for most small to mid-sized businesses. The actual price depends on scope of work, transaction volume, and how much financial oversight your business requires.
Read answerWhat business tax forms do I need to file in Florida?
Florida has no personal income tax, but businesses still have federal filing requirements and may owe Florida corporate income tax. The forms you need depend on your entity type and whether you collect sales tax.
Read answerWhat business expenses can I deduct on my tax return?
Most costs that are ordinary and necessary for running your business are deductible. This includes rent, payroll, supplies, professional services, insurance, and many other operating costs. The key is proper documentation and correct categorization.
Read answerHow long do businesses typically use a fractional CFO?
It depends on why you engaged one. Project-based needs like fundraising or M&A might last 6-12 months, while ongoing strategic guidance often continues for years. Many businesses find the arrangement works indefinitely.
Read answerWhat financial reporting do insurance agencies need?
Insurance agencies need trust account reconciliation, commission tracking by carrier and producer, and standard financial statements. The unique handling of client premiums and carrier commissions creates reporting requirements beyond typical service businesses.
Read answerWhat is the sales tax rate in Broward County?
Broward County's combined sales tax rate is 7%, made up of Florida's 6% state rate plus a 1% county discretionary surtax. This rate applies to most taxable goods and services.
Read answer
