“You cannot enter a date earlier than the close date for the last reconciled statement. Enter a new date.” message prompts on Reconcile Account Statement page when entering a Previous Reconciliation Date.

Scenario

Reconcile Account Statement > Edit Previous Reconciliation Date > Edit Previous reconciliation when using the Reconcile Account Statement feature.

Solution

Editing previous reconciliation is not possible if you are already using the Reconcile Account Statement feature. When you try to open a previous reconciliation using this feature, there is a message that states: “You cannot enter a date earlier than the close date for the last reconciled statement. Enter a new date.”

To edit the account reconciliation, please follow the steps below:

1. Open the account record of the bank account by navigating to Lists > Accounting > Accounts > Edit link on bank account
2. In the account record, set USE MATCH BANK DATA AND RECONCILE ACCOUNT STATEMENT PAGES checkbox = False
3. Click Save
4. Go to Transactions > Bank > Reconcile Bank Statement
5. Select the bank account on the Account drop-down list to navigate back to the previously saved bank reconciliation
6. Click Save once the editing is completed
7. Go back to the account record (see Step 1)
8. Set the USE MATCH BANK DATA AND RECONCILE ACCOUNT STATEMENT PAGES  checkbox = True
9. Click Save

You can now continue using the Reconcile Account Statement feature with your previous reconciliation edited.