Changing the Reconciliation Status of a Transaction in Cash Management

Changing the Reconciliation Status of a Transaction in Cash Management

Summary
How to adjust the Reconciliation Status for a transaction in Cash Management (updating an item after making fixes)

Definition of Cash Management Reconciliation Statuses:
  1. O - Open: The transaction is expected to clear the bank and appear on a future bank statement.
  2. C - Cleared: The transaction has cleared the bank and is expected to appear on a future bank statement
  3. R - Reconciled: The transaction has cleared the bank and has appeared on a previously reconciled bank statement.
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. 
  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 I above, use the same Cleared amount and Cleared date that you made a note of in step 6 in Option I.
  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.