| Wrong statement date entered for bank reconciliation |
Description | Change an incorrectly entered Statement date for a bank reconciliation in Tasks, Reconcile in Cash Management. |
Resolution | Choose an option below based on the status of your reconciliation. 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.
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.
- 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.
- When you've corrected all entries, click Finish.
- If you haven't completed any subsequent reconciliations, 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 box and click OK.
|
|