Choose one of the following options to adjust the balance.

You can use the Change or Delete options when you haven't created any transactions or reconciliations for the new bank. If you posted transactions to the bank, use the Reconcile option.

Change the balances on the bank account

Change the balances on the bank account to 0.00 and use the Reconcile task to update the Last reconciled balance to 0.00.

1. Turn on the Audit Setup Activity tool.
2. In Cash Management, from the Setup menu, select Bank Accounts.
3. Select the bank.
4. Change the Register Balance and Bank Balance to 0.00.
5. Make note of the Last reconciled date.
6. Select the Totals by GL Cash Account tab.
7. Change the Posted (CM) Balance to 0.00. Also change the Amount in the grid below next to the cash account to 0.00.
8. Click Close.
9. From the File menu, select Company Settings, CM Settings.
10. Select Override opening balance in Reconcile.
11. Click OK.
12. From the Tasks menu, select Reconcile.
13. Select the bank.
14. Change the Opening Balance to 0.00.
15. Enter the Ending Balance as 0.00.
16. Enter the Statement Date the same as the Last reconciled date noted in step 5 above.
17. Click OK.
18. Click Finish.
19. From the File menu, select Company Settings, CM Settings.
20. Unmark Override opening balance in Reconcile.
21. Click OK.
22. Turn off the Audit Setup Activity tool.

Delete and recreate the bank account

Delete the bank account and set it back up again using Setup Assistant and enter 0.00 balances.

1. Delete the bank account.
2. Set up the bank account again (you can use the same bank account ID).

Reconcile the bank and change the balances

Use this option when you've completed bank statement reconciliations since you set up the bank. Reconcile transactions included in the starting balance and change the bank account balances to match.

• If you haven't entered opening transactions, record the opening transactions to match your actual bank account.
• If the transactions exist in General Ledger, create the transactions in Cash Management without affecting your General Ledger.

Correct the transaction status and bank balances

1. In Cash Management, from the File menu, select Company Settings, CM Settings.
2. Select the Allow reconciliation status change in Register checkbox then click OK.
3. From the Tasks menu, select Edit Register.
4. Find the item then click the ...> button.
5. Change the Status from O to R and enter the Cleared Date as the correct date.
6. Click OK.
7. Click Finish.
8. From the File menu, select Company Settings, CM Settings.
9. Clear the Allow reconciliation status change in Register checkbox then click OK.
10. Run the Bank Account Balance Verification report and correct the variances resulting from the status change.
    
    NOTE:

    Confirm the Variance matches the balance of the transactions that you didn't originally reconcile.

11. Reconcile Cash Management to General Ledger to confirm period totals match.