Add a bank statement manually
To carry out a bank reconciliation, add all required bank statements to the system. You usually do this by importing the statements from a CSV file, which you can download from your establishment / organisation's bank. However, there may be occasions when you cannot download online statements, so you can add statements manually, as this topic describes. You can also use this method to change transactions or add extra transaction lines to bank statements that you imported.
If you are manually entering a bank statement to an account for the first time, you must have entered an opening balance for the bank account before entering the bank statement details. For more information, refer to Recording bank account opening balances.
-
Go to Banks, then select Bank Statements from the menu.
-
Double-select to select the required account from the Select a bank account dialog.
-
The Bank Statement Maintenance window opens and lists any existing bank statement sheets in the left-hand panel. To edit an existing bank statement, select the required statement from the left-hand panel. To add a new bank statement, select ADD NEW, then select STATEMENT.
If the date of the bank statement you are entering falls between the dates of two existing statements, select the statement dated immediately after the one you are entering from the left-hand panel, then select ADD NEW, then select STATEMENT (INSERT).
-
The system creates a new statement record with the next available sheet number and shows editable fields in the right-hand panel. You can now add transactions to the statement. Enter each transaction as it appears on the bank statement in a separate transaction line.
-
Select the Date list arrow, then select the date of the bank statement line.
-
Enter a description for the transaction in Description, typically what appears on the bank statement, such as the supplier name. Enter the amount Paid In or Paid Out, as this graphic shows, depending on whether the value was paid in or out of the account.
-
If you need to add more statement lines, select ADD NEW, then select BANK STATEMENT LINE from the menu.
-
A new line appears, which you can complete as previously described. Repeat this process until all the contents of the bank statement have been recorded, then select SAVE.
-
An Update complete message appears. Select OK to close the message and return to the window.