Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Clear up Undeposited Funds account with Client Data Review (CDR)

If a deposit is created manually, rather than by selecting payments in the Payments to Deposit window, the amount of the payment can stay in the Undeposited Funds account indefinitely. This Client Data Review (CDR) tool allows you to link deposits to payments to clear out the Undeposited Funds account.

Note: The Client Data Review (CDR) Feature is only available in the Accountant Edition of QuickBooks.

Detailed instructions

It is important to note that running this tool can affect account balances in prior periods. Back up your data file before proceeding with the steps below.

The Clear Up Undeposited Funds Account window contains two tables.

  • The left table shows deposits that were entered manually without linking them to payments or Undeposited Funds.
  • The right table shows all available payments in Undeposited Funds.

The Payers list on the left shows a list of payers from which to select to limit the display on the right. You may see an entry with No Name in Deposit. This entry refers to deposits that have no name assigned to them. You can link deposits without a name to payments from multiple customers.

To link deposits and payments:

  1. pecify the lists of undeposited funds and payments that are visible.
    • Click a payer or the last entry No Name in Deposit in the Payers list on the left.
      • If you select a payer, only deposits and payments from the selected payer are shown.
      • If you select No Name in Deposit, all deposits and payments are shown.
  2. Select a deposit and payments to apply.
    • First, check any deposit to start working on it. You can only work on one deposit at a time. If you try to check a second deposit, nothing happens. You must uncheck a deposit before checking a second one. Deposits that are grayed out have already been processed and cannot be selected.
    • After the deposit is selected, you can select payments. Select any payments to apply to the deposit by clicking the checkbox in the left of the Payments table. You can select any number of payments. If you change your mind, you can unselect a payment by clicking the checkbox again.
    • The Remaining column is the rightmost column in the Deposits table. When you start, the Remaining column for the deposit is the same as the Total Amt column. As you select payments, the remaining column decreases by the amount of the payment. To apply payments to a deposit, the remaining column must be zero; that is, the total of all the selected payments must be equal to the amount of the deposit.
    • When the Remaining column is zero, click Apply to apply the payments to the deposit or Close to close the window. Be sure to Save before switching to a new Payer or closing the window.
  3. Select Apply after the correct total is selected.
    • After selecting Apply, the deposit and the payments are grayed out.
  4. Process another deposit for this payer, if desired.
    • After the items are applied, you can process more deposits for the selected payer or clicking Save. However, you cannot move to another payer before taking one of these actions.
  5. Select Save to link the transactions or click Un apply All to undo all changes.
    • There are four options, as follows:
      1. Select Save to save your work. The deposits and payments you linked are removed from the Deposits and Payments tables and you can keep working.
      2. Select Save & Close to save your work and return to the CDR Center.
      3. Select Un apply to remove the last link applied between deposits and payments since the last time you saved.
      4. Select Un apply All to remove any links between deposits and payments you made since the last time you saved. All payments that were applied to a deposit for this payer are removed, not just the last one. After un applying, you can continue working with the selected payer, or select another payer.
Repeat the process as many times as you need to until you have processed all the deposits.
Suggested work order:
First, clear up all the deposits that have associated payer names. Then, clear up the deposits that have no associated payer name.
Note: You can select Close at any time to return to the CDR Center.
KB ID# HOW13370
4/24/2017 6:10:43 AM
QYPPRDQBKSWS03 9138 Pro 2017 509d65