Wrong statement date entered for bank reconciliation
Description

Change an incorrectly entered Statement date for a bank reconciliation in Tasks, Reconcile in Cash Management.

Cause

Resolution

Choose an option below based on the status of your reconciliation.

Reconciliation still in-progress

  1. Complete the reconciliation in-progress without reconciling any transactions:
    1. In Cash Management, from Tasks, select Reconcile.
    2. Select the bank account from the Bank account list.
    3. Click OK to the reconciliation in-progress message.
    4. Click OK, leaving the balances as they are.
    5. Go to the "All" tab at the top.
    6. Unreconcile any entries by unchecking each entry's matching the check box.
    7. Click the Statement button.
    8. Change the Statement ending balance to match the Statement opening balance. Click OK.
    9. The Difference should show 0.00.
    10. Click Finish.
    11. Click Start to print your journal.
    12. Review the journal to verify that you successfully completed a $0.00 reconciliation.
  2. Re-start the bank reconciliation with the correct date:
    1. From Tasks, select Reconcile.
    2. Type the correct Statement date and Statement ending balance.
    3. Click OK to continue with the reconciliation.

Reconciliation has finished

  1. Correct the statement date on the reconciled transactions:
    1. From the Cash Management File menu, select Company Settings, CM Settings.
    2. Select the Allow reconciliation status change in register check box. Click OK.
    3. From Tasks, select Edit Register.
    4. Select the bank account.
    5. Use Conditions to add a condition for the incorrect Statement Date so that only those transactions will display. (Statement Date Equal to [incorrect date])
    6. For each affected entry:
      1. Click the ...> button.
      2. In the Reconciliation Status drop down list, select O.
      3. In the Reconciliation Status drop down list, select R.
      4. In the Cleared Date field, enter the correct Statement date.
    7. When you've corrected all entries, click Finish.
  2. If you haven't completed any subsequent reconciliations, correct the Last reconciled date:
    1. From Tasks, select Reconcile.
    2. Enter the amount displayed in the Statement Opening Balance in the Statement Ending Balance Field.
    3. Enter the correct last reconciled date in the Statement Ending Date field.
    4. Click OK and click Finish. Don't select any transactions.
    5. Click Start to print the reconciliation journal.
  3. Restore your Cash Management settings:
    1. From File, select Company Settings, CM Settings.
    2. Clear the Allow reconciliation status change in Register box and click OK.

 

 

 

Need more help?

Chat now





 

Steps to duplicate
Related Solutions

How do I change the reconciliation status of a transaction in Cash Management?
How do I redo a finished Cash Management bank reconciliation?