Wrong statement date entered for bank reconciliation
Description
Cause

Resolution

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

  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.

Option 2: 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. 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])
    4. 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.
        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.
    5. When you have corrected all entries, click Finish.
  2. If no subsequent reconciliations have been completed, 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 check 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?