Definition of Cash Management Reconciliation Statuses

• O - Open: The transaction will clear the bank and appear on a future bank statement
• C - Cleared: The transaction cleared the bank and will appear on a future bank statement
• R - Reconciled: The transaction cleared the bank and appeared on a previously reconciled bank statement

Change the transactions status

Change 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 checkbox 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’re changing the status for corrections, use this when you change the status back to Reconciled.
   
   NOTE:

   If the Cleared Date and Statement Date aren’t the same, then use the Statement Date to re-reconcile.

7. Change the Status from R to O. If the Status is unavailable to change, there’s a reconciliation in progress.
8. Click OK.
9. Repeat for other line items as needed.
10. Click Finish to exit the Edit Register task. Completely close the Edit Register task or incorrect processing can occur.
11. From the File menu, select Company Settings, CM Settings.
12. Unmark the Allow reconciliation status change in Register checkbox and click OK.

Change 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 checkbox 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 status, use the original Cleared amount and Cleared date. The Cleared date will be the Statement Date.
8. Click OK and then click Finish to exit the Edit Register task. Completely close the Edit Register task or incorrect processing can occur.
9. From the File menu, select Company Settings, CM Settings.
10. Unmark the Allow reconciliation status change in Register checkbox and click OK.

Change 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 checkbox 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 checkbox in the C column as applicable.
6. If you’re marking it C (Cleared), enter the Cleared Date.
7. Click Finish to exit the Edit Register task. Completely close the Edit Register task or incorrect processing can occur.
8. From the File menu, select Company Settings, CM Settings.
9. Unmark the Allow reconciliation status change in Register checkbox and click OK.

How do I correct a Cash Management transaction created in Setup Assistant when the bank account isn’t 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?