Understanding and Managing Undeposited Funds in QuickBooks

July 9, 2024

How to Clear Undeposited Funds in QuickBooks

Before diving into the process of managing undeposited funds, it’s crucial to understand their relevance in QuickBooks. The undeposited funds account is a vital feature that serves as a temporary holding area for payments and sales receipts you intend to combine before making a bank deposit. This guide will walk you through the concept of undeposited funds and provide detailed instructions on how to clear or delete them from your bank deposit in QuickBooks.

What are Undeposited Funds in QuickBooks?

In QuickBooks, the undeposited funds account is an automatically generated feature that acts as a virtual space for storing payment information received from clients. When a payment is made via check or any type of sale receipt, the amount is initially added to this account. This process is crucial for maintaining accurate financial records and facilitating proper reconciliation.

Purpose of the Undeposited Funds Account

  1. Temporary Storage: It holds invoice payments and sales receipts until you’re ready to deposit them into your bank account.
  2. Payment Consolidation: Allows you to combine multiple payments into a single bank deposit.
  3. Accurate Record-Keeping: Helps maintain a clear trail of incoming payments before they’re officially deposited.
  4. Simplified Reconciliation: Makes it easier to match your QuickBooks records with your bank statements.

What Causes a Buildup in Undeposited Funds?

A buildup in the undeposited funds account can occur due to several reasons:

  1. Incorrect Transaction Recording: Not following the proper procedure for recording money-in transactions.
  2. Misclassification: Adding payments directly to income accounts instead of routing them through the undeposited funds account.
  3. Delayed Deposits: Not regularly processing bank deposits in QuickBooks.
  4. Overlooked Payments: Forgetting to include certain payments when making bank deposits.

How to Clear Undeposited Funds from Bank Deposit in QuickBooks

Before clearing or deleting entries from the undeposited funds account, it’s crucial to ensure that you’re only removing entries that have been properly deposited and reconciled. Follow these steps to safely manage your undeposited funds:

Step 1: Reconcile Your Data

  1. Open QuickBooks Online and navigate to Settings > Reconcile.
  2. Have your bank statement ready for reference.
  3. Choose the bank account, enter the statement’s start and end dates, and click “Start Reconciling.”
  4. Match each entry from your bank statement to the corresponding item in QuickBooks.
  5. Verify the balances and click “Finish” when complete.

Step 2: Clear Out Undeposited Funds

After successful reconciliation, any remaining entries in the undeposited funds account are likely duplicates and can be safely removed:

  1. In QuickBooks Online, click the “+” icon and select “Bank Deposit.”
  2. Locate the duplicate payment that needs to be deleted.
  3. Click on the customer’s name to open the transaction details.
  4. At the bottom of the payment screen, click “More” and select “Delete” to remove the entry.

Advanced Methods for Clearing Undeposited Funds

Method 1: Remove and Record Process

This method involves reversing uncategorized cash inflow transactions and re-entering them correctly:

  1. Go to the Banking tab and select the appropriate bank account.
  2. Click “Undo” for uncategorized money-in transactions.
  3. Navigate to the Bank Deposit tab.
  4. Choose the correct bank account, add the payment date, and select the removed payment.
  5. Save and close the entry.

Method 2: Dummy Bank Account Process

This approach uses a temporary account to clear undeposited funds:

  1. Create a new “Dummy Bank Account” in your Chart of Accounts.
  2. Use the Bank Deposits feature to transfer amounts from the Undeposited Funds account to the dummy account.
  3. Create an Expense transaction to move the amount from the dummy account to the correct income account.
  4. Verify that the dummy account balance is zero after these transactions.

Managing Undeposited Funds in QuickBooks Desktop

For QuickBooks Desktop users, the process is slightly different:

  1. Go to Banking > Make Deposits.
  2. Select the payment you want to remove from Undeposited Funds.
  3. Choose the appropriate bank account for the deposit.
  4. Enter the deposit date and any necessary transaction details.
  5. Save the deposit to clear the amount from Undeposited Funds.

Best Practices for Managing Undeposited Funds

  1. Regular Reconciliation: Perform bank reconciliations frequently to catch discrepancies early.
  2. Timely Deposits: Process bank deposits in QuickBooks promptly after receiving payments.
  3. Proper Classification: Ensure all incoming payments are correctly routed through the Undeposited Funds account.
  4. Periodic Review: Regularly review your Undeposited Funds account for any lingering or unusual entries.
  5. Staff Training: Ensure all team members handling financial transactions understand the proper use of the Undeposited Funds account.

Frequently Asked Questions (FAQs)

  1. Q: Can I remove the Undeposited Funds account entirely in QuickBooks?
    A: While you can’t remove the account, you can delete individual payments from it by going to Lists > Chart of Accounts > Undeposited Funds > Amount, then right-clicking and selecting “Delete deposit.”
  2. Q: How do I change Undeposited Funds to a deposit in QuickBooks?
    A: Click the “+” icon, choose “Bank Deposit,” select the account for deposit, check the boxes for each transaction, and click “Save and Close.”
  3. Q: Can the Undeposited Funds account have a credit balance?
    A: Yes, it can have both debit and credit balances. Received payments debit the account, while deposit entries credit it.
  4. Q: How can I fix a negative balance in the Undeposited Funds account?
    A: Create a zero-value deposit by entering offsetting positive and negative values, effectively balancing the account.
  5. Q: Are Undeposited Funds considered Accounts Receivable?
    A: No, Undeposited Funds are not considered Accounts Receivable or Cash. They represent a transitional stage between receiving payment and depositing it in the bank.
close btn

Get Your Case Study

Call Now +1-800-596-0806
Top