Change an incorrectly entered Statement date for a bank reconciliation in Tasks, Reconcile in Cash Management. Choose an option below based on the status of your reconciliation. Reconciliation still in-progress Complete the reconciliation in-progress without reconciling any transactions. - Go to Cash Management, Tasks, 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 checkbox.
- Click the Statement button.
- Change the Statement ending balance to match the Statement opening balance. Click OK.
- Confirm the Difference field shows 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. - Go to Cash Management, Tasks, Reconcile.
- Type the correct Statement date and Statement ending balance.
- Click OK to continue with the reconciliation.
Reconciliation has finished Correct the statement date on the reconciled transactions. - Go to Cash Management, File, Company Settings, CM Settings.
- Select the Allow reconciliation status change in register checkbox. Click OK.
- From Tasks, select Edit Register.
- Select the bank account.
- 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 dropdown list, select O.
- In the Reconciliation Status dropdown list, select R.
- In the Cleared Date field, enter the correct Statement date.
- When you've corrected all entries, click Finish.
If you haven't completed any subsequent reconciliations, correct the Last reconciled date. - Go to Cash Management, Tasks, 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. - Go to Cash Management, File, Company Settings, CM Settings.
- Clear the Allow reconciliation status change in Register box and click OK.
|