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.


    • Related Articles

    • Why Can't Cleared Entries Be Changed to Open During Reconciliation?

      Reason for Issue: The particular entry has undergone reconciliation and the reconciliation process is still underway. Solution: Navigate to the Cash Management Tasks menu and choose the Reconcile option. Pick the specific bank account and proceed by ...

    • Moving a Cash Receipt Deposit From One Customer to Another

      Summary Follow these instructions for reallocating a cash receipt from one customer's account to another through the Modify Customer option in Accounts Receivable of Sage 300 CRE. It's important to note that modifying the customer for any part of a ...

    • Interest Earned & Service Charges in Sage Intacct Cash Management

      Managing interest and bank charges efficiently in Sage Intacct Cash Management can significantly enhance your financial tracking and reporting. This tutorial provides a comprehensive guide on how to handle these transactions. Accessing Interest and ...

    • Undo a Voided Check in Accounts Payable

      Sage 300 CRE does not allow for the deletion or undo on a voided check, which means you'll have to reprint. While printing checks in Accounts Payable, the check number is verified against Cash Management transactions to ensure duplicate check numbers ...

    • Voiding a Direct Deposit or Payroll Check

      If you've created a direct deposit in Sage 300 CRE and need to make corrections, you must first void the original transaction. Afterward, re-initiate the "Generate Direct Deposits" process. See how to void a payroll check or direct deposit by ...