This article provides steps to change an incorrectly entered Statement date for a bank reconciliation in Tasks, Reconcile in Cash Management. - If your bank reconciliation is still in-progress, follow Option 1
- If you need to cancel the bank reconciliation that is in-progress, follow Option 1
- If you have already finished the bank reconciliation, use the steps in Option 2
Option 1: Reconciliation still in progress - Complete the reconciliation in-progress without reconciling any transactions:
- In Cash Management, from Tasks, select Reconcile.
- Select the bank account from the Bank account list.
- Click OK to the reconciliation in-progress message.
- Click OK, leaving the balances as they are.
- Go to the "All" tab at the top.
- Unreconcile any entries by unchecking each entry's matching the check box.
- Click the Statement button.
- Change the Statement ending balance to match the Statement opening balance. Click OK.
- The Difference should show 0.00.
- Click Finish.
- Click Start to print your journal.
- Review the journal to verify that you successfully completed a $0.00 reconciliation.
- Re-start the bank reconciliation with the correct date:
- From Tasks, select Reconcile.
- Type the correct Statement date and Statement ending balance.
- Click OK to continue with the reconciliation.
Option 2: Reconciliation has finished - Correct the statement date on the reconciled transactions:
- From the Cash Management File menu, select Company Settings, CM Settings.
- Select the Allow reconciliation status change in register check box. Click OK.
- From Tasks, select Edit Register. Select the bank account.
- Tip: Use Conditions to add a condition for the incorrect Statement Date so that only those transactions will display. (Statement Date Equal to [incorrect date])
- For each affected entry:
- Click the ...> button.
- In the Reconciliation Status drop down list, select O.
- In the Reconciliation Status drop down list, select R.
- In the Cleared Date field, enter the correct statement date.
Note: When changing the reconciliation status of a transaction in Edit Register, changing the status from R to O clears the statement date from the transaction. The Statement date repopulates based on the Cleared Date field when changing the status back from O to R and clicking OK.
- When you have corrected all entries, click Finish.
- If no subsequent reconciliations have been completed, correct the Last reconciled date:
- From Tasks, select Reconcile.
- Enter the amount displayed in the Statement Opening Balance in the Statement Ending Balance Field.
- Enter the correct last reconciled date in the Statement Ending Date field.
- Click OK and click Finish. Don't select any transactions.
- Click Start to print the reconciliation journal.
- Restore your Cash Management settings:
- From File, select Company Settings, CM Settings.
- Clear the Allow reconciliation status change in Register check box and click OK.
|