How do I change the reconciliation status of a transaction in Cash Management?
Description

Definition of Cash Management Reconciliation Statuses:

  • O - Open: The transaction is expected to clear the bank and appear on a future bank statement.
  • C - Cleared: The transaction has cleared the bank and is expected to appear on a future bank statement
  • R - Reconciled: The transaction has cleared the bank and has appeared on a previously reconciled bank statement.
Cause
Resolution
Option 1: Change the status of a Cash Management transaction from Reconciled to Open

 

  1. In Cash Management, from the File menu, select Company Settings, CM Settings.
  2. Select the Allow reconciliation status change in Register check box and click OK.
  3. From the Tasks menu, select Edit Register.
  4. Select the applicable bank account and click OK.
  5. Find the applicable transaction and click ...> for the detail window.
  6. Make a note of the Cleared amount and Cleared date. If you are changing the status for error correction, you'll use this information when you change the status back to Reconciled.
    Note: If the Cleared date and the Statement Date on the entry are not the same, then use the Statement Date to re-reconcile. See How do I determine the Statement Date on a transaction in Cash Management? for steps to find the Statement Date.
  7. Change the Status from R to O.
    Note: If the Status is unavailable to change, there is a reconciliation in progress. See Why can't I change the reconciliation status of an entry from cleared to open? (Entry is part of a reconcile in progress).
  8. Click OK.
  9. Repeat for additional line items as needed.
  10. Click Finish to exit the Edit Register task.
    Note: Completely close the Edit Register task or incorrect processing may occur.
  11. From the File menu, select Company Settings, CM Settings.
  12. Unmark the Allow reconciliation status change in Register check box and click OK.

Option 2: Change the status of a Cash Management transaction from Open to Reconciled

  1. In Cash Management, from the File menu, select Company Settings, CM Settings.
  2. Select the Allow reconciliation status change in Register check box and click OK.
  3. From the Tasks menu, select Edit Register.
  4. Select the appropriate bank account and click OK.
  5. Find the appropriate transaction and click ...> for the detail window.
  6. Change the Status from O to R.
  7. Type the appropriate entries for the Cleared amount and Cleared date. If you previously changed the reconciliation status by following the steps in Option 1 above, use the same Cleared amount and Cleared date that you made a note of in step 6 in Option 1. The Cleared date will be the Statement Date.
  8. Click OK and then click Finish to exit the Edit Register task.
    Note: Completely close the Edit Register task or incorrect processing may occur.
  9. From the File menu, select Company Settings, CM Settings.
  10. Unmark the Allow reconciliation status change in Register check box and click OK.

Option 3: Change the status from Open to Cleared or from Cleared to Open

  1. In Cash Management, from the File menu, select Company Settings, CM Settings.
  2. Select the Allow reconciliation status change in Register check box and click OK.
  3. From the Tasks menu, select Edit Register.
  4. Select the appropriate bank account and click OK.
  5. Find the appropriate transaction and select or clear the check box in the C column as applicable.
  6. If you are marking it C (Cleared), enter the Cleared Date.
  7. Click Finish to exit the Edit Register task.
    Note: Completely close the Edit Register task or incorrect processing may occur.
  8. From the File menu, select Company Settings, CM Settings.
  9. Unmark the Allow reconciliation status change in Register check box and click OK.



[BCB:20:Chat 300 CRE US:ECB]



Steps to duplicate
Related Solutions

How do I correct a Cash Management transaction created in Setup Assistant when the bank account is not yet live?
How do I correct a Cash Management transaction created in Setup Assistant when the bank account is live?
How do I change the General Ledger account on a Cash Management transaction?