NSC | Editing a Previous Reconciliation

Micah Timbol-Oracle

Scenario:
A user needs to edit or redo a bank reconciliation for April 2025.

Note: Before proceeding, consult with your system Administrator to ensure this action aligns with your organization’s financial policies and does not conflict with other reconciliations or reporting requirements.

Attempting to open an earlier reconciliation will result in the following system message:
"You cannot enter a date earlier than the close date for the last reconciled statement. Enter a new date."
To work around this restriction, you can temporarily disable the "Match Bank Data and Reconcile Account Statement Pages" setting for the bank account, make your changes, and then re-enable the setting.

Solution:

Access the Bank Account Record

1. Navigate to: Lists > Accounting > Accounts
2. Click the Edit link for the relevant bank account
3. In the bank account record, uncheck the box: Use Match Bank Data and Reconcile Account Statement Pages
4. Click Save

Open the Reconciliation Page

1. Navigate to Transactions > Bank > Reconcile Bank Statement
2. In the Account dropdown, select the relevant bank account.
3. You should now be able to access and edit the previously saved reconciliation for April 2025.

Modify the Reconciliation

1. Go to the Deposits and Credits tab and the Checks and Payments tab.
2. Select or unselect transactions as needed.
3. Click Save to apply your changes.

Re-enable the Reconcile Account Statement Feature

1. Return to the bank account record: Lists > Accounting > Accounts > Edit
2. Re-check the box: Use Match Bank Data and Reconcile Account Statement Pages
3. Click Save

Hope this helped!