Wrong statement date entered for bank reconciliation
Description
Cause
Resolution

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.

  1. Go to Cash Management, Tasks, 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 checkbox.
  7. Click the Statement button.
  8. Change the Statement ending balance to match the Statement opening balance. Click OK.
  9. Confirm the Difference field shows 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.

Re-start the bank reconciliation with the correct date.

  1. Go to Cash Management, Tasks, Reconcile.
  2. Type the correct Statement date and Statement ending balance.
  3. Click OK to continue with the reconciliation.

Reconciliation has finished

Correct the statement date on the reconciled transactions.

  1. Go to Cash Management, File, Company Settings, CM Settings.
  2. Select the Allow reconciliation status change in register checkbox. 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 dropdown list, select O.
    3. In the Reconciliation Status dropdown list, select R.
    4. In the Cleared Date field, enter the correct Statement date.
    5. When you've corrected all entries, click Finish.

If you haven't completed any subsequent reconciliations, correct the Last reconciled date.

  1. Go to Cash Management, Tasks, 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.

Restore your Cash Management settings.

  1. Go to Cash Management, File, 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?