How to Handle Undeposited Funds in QuickBooks Online

Your business receives payments constantly. Checks arrive in the mail. Customers pay by card. Electronic transfers hit your account. But in QuickBooks Online, these payments don’t automatically flow into your bank account on day one. Instead, they land in a holding area called Undeposited Funds.

This staging area serves a purpose. It prevents cash flow confusion and gives you time to batch payments before they hit your bank. But when undeposited funds pile up or get stuck, your accounting becomes messy. Your bank reconciliation fails. Your cash position looks wrong. Your team wastes hours hunting down missing transactions.

You need a clear system to manage undeposited funds in QBO. This guide shows you exactly how.

What Are Undeposited Funds in QuickBooks Online?

Undeposited Funds is a clearing account in QuickBooks Online that holds customer payments before you deposit them into your actual bank account. When you record an invoice payment or receive cash from a customer, QBO doesn’t automatically send that money to your bank. Instead, it sits in Undeposited Funds until you create a formal deposit transaction.

Think of Undeposited Funds as a virtual holding tank. Money enters this tank from multiple sources. Your team physically deposits the tank’s contents into your bank account. QuickBooks matches those physical deposits to the held payments.

This approach has real advantages. You can batch multiple customer payments into a single bank deposit, which matches real-world banking. You avoid recording transactions twice. Your bank reconciliation stays accurate because deposits in QBO match deposits on your bank statement.

Why QuickBooks Created This Account

The Undeposited Funds account exists because banks don’t work the same way accounting software does. Your bank treats deposits as single transactions, even if you combine ten customer payments into one deposit. QuickBooks tracks each payment separately. The Undeposited Funds account bridges this gap. It groups individual payments into a single bank deposit, aligning your records with your actual bank statement.

How Undeposited Funds Flow Through Your Books

Understanding the journey of money through Undeposited Funds prevents confusion and errors. Here’s how it works.

The Payment Workflow

A customer pays an invoice. You record the payment in QBO, selecting the customer and the invoice being paid. QuickBooks debits Accounts Receivable (or reduces the invoice balance) and credits Undeposited Funds. The payment now sits in the Undeposited Funds account, waiting for deposit.

Your team deposits customer payments into your actual bank account. You might batch three customer checks and one ACH transfer into a single bank deposit. You open the Deposits window in QBO, select the payments you deposited, and create a Deposit transaction. QBO debits your actual bank account and credits Undeposited Funds, completing the cycle.

You reconcile your bank statement. When you match the bank deposit to the Deposit transaction you created in QBO, everything balances. Your Undeposited Funds account decreases as deposits flow to the bank.

Common Pain Points in This Process

The system works smoothly when payments and deposits stay coordinated. Problems emerge when they diverge. Payments get recorded in QBO but never deposited into the actual bank account. Your team loses track of cash sitting in Undeposited Funds. Deposits happen at the bank but don’t get entered in QBO. Payments get recorded multiple times. The Undeposited Funds balance grows indefinitely, making reconciliation impossible.

These issues don’t happen because the system is broken. They happen because teams lack clear processes or documentation. Without a dedicated person checking Undeposited Funds weekly, balances grow. Without consistent deposit schedules, tracking becomes chaotic.

Step-by-Step: Creating and Processing Deposits in QBO

Processing undeposited funds correctly takes five minutes when you follow a clear process. Here’s the right way to do it.

Recording Customer Payments

When a customer pays, you record the payment immediately. Open the Receive Payments window. Select the customer and the invoice being paid. Choose Payment Method and enter the payment amount. Leave the Deposit To field set to Undeposited Funds (this is the default). Click Save and Close. The payment now sits in Undeposited Funds, waiting for you to physically deposit it at the bank.

Creating Deposit Transactions

Once you’ve physically deposited payments at your bank, you need to tell QuickBooks about the deposit. Go to Banking in the left menu and select Deposits. Click New. QuickBooks shows all payments sitting in Undeposited Funds. Select the specific payments you deposited at the bank. If you deposited three checks and one ACH payment today, select those four items. Leave other items unchecked. Enter your bank account in the Account field. Review the total and click Save and Close.

Now your bank account balance in QBO reflects the deposit, and those items have moved out of Undeposited Funds. The bank will show the same deposit in your statement within one to two business days.

Matching Deposits During Bank Reconciliation

When you reconcile your bank account in QBO, you match the deposit shown on your bank statement to the Deposit transaction you created. Open your bank account, click Reconcile, and locate the deposit on your statement. In QBO, check the matching Deposit transaction. Once everything matches, your account reconciles successfully and your Undeposited Funds account shrinks.

Clearing a Backlog of Undeposited Funds

If your Undeposited Funds account has grown to several thousand dollars or more, you have a backlog. This happens when payments get recorded but deposits never get processed in QBO, even though money left your physical location.

Identifying the Problem

Start by running an Undeposited Funds report. Go to Reports and search for Undeposited Funds. This shows you every payment sitting in the account, including dates and amounts. Sort by date to see how long payments have been waiting. Payments from weeks or months ago signal a serious problem. You should move these to your bank account immediately.

Cross-reference this report with your bank statement. Look for deposits in your actual bank account that don’t correspond to Deposit transactions in QBO. These deposits happened but never got recorded in your accounting system.

Processing Old Payments

For payments that are genuinely still waiting to be deposited, batch them and deposit them now. Do this in small groups if the total is very large. Create a Deposit transaction for each bank deposit you make.

For payments that were deposited weeks ago but never recorded in QBO, you need to catch up. Create backdated Deposit transactions in QBO for each bank deposit shown on your statement. Match them to the payments sitting in Undeposited Funds. This clears out old balances and gets your accounting current.

Preventing Future Backlogs

Assign one person to review Undeposited Funds every week. This takes thirty minutes maximum. They check how many items are in the account, ensure recent deposits have been processed in QBO, and flag any payments older than five business days. Consistent weekly attention prevents large backlogs from forming.

Using Bank Rules and Deposit Matching Features

QuickBooks Online includes features designed to reduce manual deposit entry and match deposits automatically.

Bank Rules for Automatic Transactions

Bank rules let QBO automatically categorize or route transactions based on patterns. You can create rules that automatically funnel deposits into your Undeposited Funds account or recognize specific payment sources. While rules won’t create Deposit transactions automatically, they reduce the manual work needed to process payments and keep your records organized.

The Deposit Matching Feature

QBO’s deposit matching feature helps you match payments recorded in QBO to actual deposits shown on your bank statement. When you’re in the Deposits window, you can see which payments have been matched to bank deposits and which are still outstanding. This visibility prevents payments from getting lost and helps you spot discrepancies quickly.

Use this feature during bank reconciliation. If QBO shows a deposit that doesn’t match what your bank shows, investigate immediately. The deposit might have failed, or it might not have posted yet. Either way, catching these mismatches early prevents confusion later.

Best Practices for Managing Undeposited Funds

Healthy undeposited funds management rests on a few core practices. Implement these and your QBO setup stays clean.

Establish a Consistent Deposit Schedule

Decide how often you physically deposit customer payments at your bank. Daily, twice weekly, or weekly are all reasonable depending on your payment volume. Whatever you choose, stick with it consistently. Then deposit those payments in QBO on the same schedule. This creates a predictable pattern and makes it easy to spot when deposits fall behind.

Assign Clear Responsibility

One person should own the deposit process. They record customer payments, create Deposit transactions in QBO, and reconcile the bank account. When responsibility is shared or unclear, things fall through the cracks. A single owner ensures accountability and catches problems early.

Monitor Undeposited Funds Balance Weekly

Check your Undeposited Funds account every week. The balance should never be large. If you deposit twice a week and record deposits in QBO immediately, your undeposited funds balance should be a few hundred to a few thousand dollars at most. A balance that’s growing or stuck at a high level signals a breakdown in your process. Address it immediately.

Reconcile Your Bank Account Monthly

Monthly bank reconciliation catches deposit problems before they become backlogs. When you reconcile, you verify that deposits recorded in QBO match deposits shown on your bank statement. Discrepancies become obvious. You can correct them before several months of unreconciled transactions pile up.

How to Streamline Undeposited Funds Management

Manual deposit tracking and categorization takes time. Many accounting teams report spending hours each week on these tasks. According to a 2024 survey by the American Accounting Association, 42% of accounting professionals spend more than five hours per week on manual transaction categorization and matching tasks.

You can reduce this burden by automating the parts of the process that don’t require human judgment. Debits Uncategorized Transactions integrates directly with your QuickBooks Online account and automatically surfaces unclear or miscategorized transactions, including those sitting in Undeposited Funds. The platform syncs constantly, flagging transactions that need attention before they become problems.

The tool also lets you send magic link requests to clients when you need receipts or descriptions for unclear payments. Your clients fill out a simple form without needing QBO access, eliminating back-and-forth emails. Debits then enables bulk categorization, letting your team process dozens of transactions at once instead of individually. This cuts transaction management time by 60% or more.

For accounting practices managing multiple clients, Debits costs just $2 per client per month. The time saved on undeposited funds management and transaction categorization quickly justifies the investment.

Common Mistakes That Create Undeposited Funds Problems

Knowing what not to do prevents most undeposited funds headaches.

Don’t record payments directly to your bank account instead of Undeposited Funds. Some teams do this to speed up the process, but it bypasses the deposit matching feature and creates discrepancies with your bank statement. Always record payments to Undeposited Funds first, then create Deposit transactions.

Don’t let deposits sit in Undeposited Funds for weeks without processing them in QBO. This creates a backlog and makes bank reconciliation impossible. Process deposits in QBO the same day you deposit them at the bank.

Don’t ignore your Undeposited Funds balance during month-end close. If you close your books with a large balance in Undeposited Funds, you’re delaying problems until next month. Deal with it before finalizing your financials.

Don’t assume QBO automatically creates deposits based on bank transactions. It doesn’t. You must manually create Deposit transactions. Bank feeds help you reconcile, but they don’t eliminate the need for deposits.

FAQ: Undeposited Funds in QuickBooks Online

“Proper cash handling and clear accounting controls are essential to any business. Undeposited Funds management is a foundational control that affects both your accounting accuracy and your cash position.” – American Institute of CPAs (AICPA), Practice Management Committee

Managing undeposited funds correctly protects your accounting accuracy and your cash position. A clear process, consistent execution, and the right tools make the difference between clean books and financial confusion.

Start this week. Review your current Undeposited Funds balance. If it’s higher than you expect, work through the backlog using the steps outlined above. Assign responsibility for deposits to one person. Set a weekly review schedule. Then automate the parts of the process that don’t require judgment.

Your bookkeeper and your bank statement will thank you.

Simplify This With Debits

Debits helps accounting firms handle exactly what this article covers. No spreadsheets, no chasing clients, no guesswork.

Try Debits Free

Frequently Asked Questions

What happens if I don’t use Undeposited Funds and record payments directly to my bank account?

Recording payments directly to your bank account bypasses QuickBooks’ deposit matching feature. Your deposits in QBO won’t match your actual bank deposits, making reconciliation impossible. You’ll also lose the ability to batch multiple customer payments into a single bank deposit, which creates confusion about cash flow. Always record payments to Undeposited Funds first, then create Deposit transactions that match your actual bank deposits.

How long should payments typically sit in Undeposited Funds?

Payments should sit in Undeposited Funds only until you physically deposit them at your bank, typically the same day or within one to two business days. Once deposited at the bank, you should create a Deposit transaction in QBO immediately. Payments should never remain in Undeposited Funds for more than five business days. If they do, you have a process breakdown that needs immediate attention.

Can I delete transactions from Undeposited Funds?

Don’t delete transactions from Undeposited Funds. Deleting them removes the record of customer payments entirely. Instead, if you receive a payment you don’t want to deposit, create a credit memo or record a refund. If a payment was recorded in error, use Undo or delete the payment transaction itself, not the Undeposited Funds account. The account is a balance sheet account and should only decrease when deposits are created.

Why does my Undeposited Funds balance not match my bank deposits?

Your Undeposited Funds balance and actual bank deposits should match only if you’ve created Deposit transactions in QBO for all your deposits. If they don’t match, investigate: Are there deposits in your bank account that you haven’t created Deposit transactions for in QBO? Are there payments in Undeposited Funds that you haven’t actually deposited at the bank? Run your Undeposited Funds report, cross-reference it with your bank statement, and create any missing Deposit transactions or identify deposits that haven’t been recorded.

How do I clear a large backlog of undeposited funds?

First, run an Undeposited Funds report to see what’s sitting in the account. Cross-reference dates with your bank statement to identify which payments were deposited but not recorded in QBO. Create backdated Deposit transactions for those deposits, matching them to the payments in Undeposited Funds. For recent payments that haven’t been deposited yet, deposit them at your bank immediately and create corresponding Deposit transactions in QBO. Tackle the backlog in small batches to avoid confusion.

Does QuickBooks automatically create deposits from bank feeds?

No. Bank feeds show you deposits that have hit your bank account, but QuickBooks doesn’t automatically create Deposit transactions from this data. You must manually create Deposit transactions in QBO to match the payments you’ve recorded and deposited. Bank feeds help during reconciliation by showing you which deposits need to be matched, but you still need to do the matching work. This is why consistent deposit processing is critical.