In QuickBooks Online, managing your cash flow efficiently is crucial for keeping your business finances in check. One key feature that helps you do this is the "Undeposited Funds" account. If you're not familiar with it or are unsure how to use it properly, this guide will walk you through everything you need to know.
What is the Undeposited Funds Account?
The "Undeposited Funds" account in QuickBooks Online is essentially a holding account. It temporarily holds payments (such as checks, credit card payments, or cash) before they are deposited into your bank account. This process helps streamline your accounting and allows you to record payments as they are received, without needing to immediately reflect the deposit in your bank account.
In essence, it acts as a waiting area for payments until you're ready to reconcile them with your bank or actual deposit transactions.
Why Use the Undeposited Funds Account?
There are several reasons why businesses use the Undeposited Funds account:
1. Record Payments as They Are Received: When you receive payments (such as customer checks or credit card payments), you can log them right away without worrying about which bank account they’ll be deposited into. The payment sits in Undeposited Funds until you make the actual bank deposit.
2. Keep Bank Reconciliation Simple: Without using the Undeposited Funds account, you'd need to immediately match every incoming payment with your actual bank deposits. Using this account allows you to record payments without disrupting your bank reconciliation process.
3. Deposit Multiple Payments in One Go: Often, businesses may receive multiple payments in a single day or batch. The Undeposited Funds account lets you group these payments together, so when you're ready, you can deposit them into your bank account all at once. QuickBooks then matches the deposit to the bank statement during reconciliation.
4. Accurate Reporting: By properly using the Undeposited Funds account, you ensure that your revenue is recorded accurately and in the right period, while your bank accounts remain in sync.
How to Use the Undeposited Funds Account in QuickBooks Online
Step 1: Receive Payments from Customers
Confido payments and payments recorded in LeanLaw will automatically go into Undeposited Funds if that option is enabled in Settings > Trust Accounting.
If entering a payment directly into QBO:
1. Go to the + New button on the left-hand sidebar.
2. Under the Customers section, select Receive Payment.
3. In the Receive Payment window:
- Choose the customer who made the payment.
- Select the invoice or invoices that the payment is applying to (if applicable).
- Enter the payment method (check, cash, credit card, etc.).
- In the Deposit to field, choose Undeposited Funds (some subscription levels call this account Payments to Deposit instead of Undeposited Funds).
4. Click Save and Close or Save and New to record the payment.
Now, the payment is saved to the Undeposited Funds account, and no bank account is affected yet.
Step 2: Record a Deposit into Your Bank Account
Once you’re ready to make the actual deposit into your bank, you’ll need to "deposit" the funds from the Undeposited Funds account into your actual bank account in QuickBooks Online.
1. Go to the + New button again.
2. Under the Other section, select Bank Deposit.
3. In the Bank Deposit window:
- Choose the bank account you want to deposit the funds into.
- Under the Select the payments included in this deposit section, check the box next to the payments you've received that you want to deposit. These payments will show as coming from Undeposited Funds.
- Enter any additional details, such as payment method or any fees if applicable.
4. Click Save and Close to complete the transaction.
At this point, the funds will move from the Undeposited Funds account to your bank account in QuickBooks. The payment will also match the actual deposit shown on your bank statement during the reconciliation process.
Note: If you use Bank Feeds and deposited a single payment, the bank feed will look into the Undeposited Funds account and show “Match Payment”. You do not need to manually record a deposit for a single payment.
Step 3: Reconcile Your Bank Feed
As deposits come through the bank feed, single payments will automatically prompt a match (Match Payment). When matched, that will clear the payment from your Undeposited Funds account.
If a bulk deposit comes through your bank feed and does not show a match, you will want to check and make sure that you created a bank deposit from your Bank Deposit screen and recorded it to the correct account. When that has been done correctly, the bank feed will prompt “Match Deposit”
Step 4: Reconcile Bank Account
During bank reconciliation, QuickBooks will automatically match your recorded deposit to the transaction from your bank statement, so long as you’ve properly used the Undeposited Funds account. This helps ensure that your books and bank account are aligned, making the reconciliation process much easier.
Common Mistakes to Avoid
While the Undeposited Funds account is a handy tool, it's important to avoid common pitfalls that can lead to inaccuracies in your accounting:
- Skipping the Bank Deposit Step: If you forget to move payments from the Undeposited Funds account to your actual bank account register in QuickBooks, deposits coming through your bank feed will not find a match. If you do not use bank feeds and forget to move the payments, your financial reports might not reflect the true state of your cash flow, and bank reconciliation could become a headache.
- Depositing Payments Directly into a Bank Account: If you mistakenly record a payment directly into a bank account (instead of Undeposited Funds), you’ll lose the ability to group multiple payments together in one deposit. This can create discrepancies in your bank reconciliation process. You can correct that by editing the payment and moving it to Undeposited Funds so that it can be properly grouped with other payments in the bulk deposit.
Tips for Effective Use of Undeposited Funds
- Keep Transactions Organized: Regularly go through your Undeposited Funds account to ensure that payments are being deposited in a timely manner. This prevents confusion and reduces the risk of mistakes.
- Batch Deposits: If you receive multiple payments throughout the day, try to group them into one deposit in QuickBooks, matching the total deposit that appears on your bank statement. This helps with accuracy when reconciling.
- Monitor Undeposited Funds Regularly: Make it a habit to check your Undeposited Funds account to ensure that it isn't accumulating old payments that haven't been deposited yet.
The Undeposited Funds account in QuickBooks Online is a powerful tool for managing incoming payments and simplifying the bank deposit process. By using it effectively, you can maintain accurate financial records, ensure smooth bank reconciliations, and avoid errors in your accounting. Understanding how to properly handle payments, record deposits, and manage Undeposited Funds will save you time and help you stay on top of your business's finances.