Record bank account opening balances

Some Of the nominals and ledgers used in this topic may be different to those in your chart of accounts.

You need to add the opening balance to the bank statement so you can reconcile the establishment / organisation bank statement with the opening balance posted to the cash book.

Adding an opening balance to a bank account consists of the following:

  1. Access the bank statements

  2. Add an opening balance before a bank statement is added manually

  3. Add an opening balance to an existing bank statement

Access the bank statements

  1. Select Banks, then select Bank Statements from the menu.

  2. The Select a bank account dialog opens. Double-select to select the required bank account.

  3. The Bank Account Maintenance window opens. Any existing statements are listed in the left-hand panel. You can add an opening balance for a new or an existing bank statement. For more information, see Add an opening balance before a bank statement is added manually or Add an opening balance to an existing bank statement.

    You can add bank statements for an account manually or import them, and they need an opening balance. Add the opening balance before you create manual statements, or after you import a statement if it has no opening balance. For more Information, see Manually Adding a Bank Statement or Importing Bank Statements.

Add an opening balance before a bank statement is added manually

  1. On the Bank Statement Maintenance window, select ADD NEW, then select STATEMENT.

  2. A blank statement appears in the left-hand panel and the system selects it automatically. Enter the date of the statement in Date in DD Month YYYY format, for example, 31 January 2021, or use the up-down buttons, or select a date from the list calendar.

  3. Next, to identify the amount as the opening balance for the account, enter Opening Balance in Description.

  4. Enter the value of the opening balance in Paid In, for example, 50,000.00 (do not enter currency symbols, such as £ or $)

  5. When you have entered all the details of the opening balance, select SAVE. The Balance updates automatically to show the opening balance and the sheet number in the left-hand panel changes automatically to 0.

  6. An Update complete message appears. Select OK to close the message and return to the window.

Add an opening balance to an existing bank statement

  1. On the Bank Statement Maintenance window, select the first statement from the left-hand panel, select ADD NEW, then select STATEMENT (INSERT).

  2. A blank statement appears in the left-hand side panel and the system selects it automatically. Enter the date of the statement in Date in DD Month YYYY format, for example, 31 January 2021, or use the up-down buttons, or select a date from the list calendar.

  3. Next, to identify the amount as the opening balance for the account, enter Opening Balance in Description.

  4. Enter the value of the opening balance in Paid In, for example, 50,000.00 (do not enter currency symbols, such as £ or $)

  5. When you have entered all the details of the opening balance, select SAVE. The Balance updates automatically to show the opening balance and the sheet number in the left-hand panel changes automatically to 0.

  6. An Update complete message appears. Select OK to close the message and return to the window.