CREATE & IMPORT BANK STATEMENT

Main Menu > Accounting > Bank > Statements

Bank statements can be entered either via the user interface or can be uploaded by means of a csv file.

Can import bank statements from menu Accounting > Bank > Statements.

Or can here import via Bank Accounts item, by clicking on the Import a Statement from the dropdown menu under Manage Account. Can see more information as follows.

Before import the Bank Statement data should be prepare the CSV file. Can download the format file here.

Then, enter the required selecting the Account to import a statement. Choose the CSV file to import.

Once the import bank statement is successful, the system will automatically show the list of imported Bank Statements in the Bank Statement menu status is not yet Not Reconcile.

Enter Bank Statement via the user interface 

Click on the New Statement button.

Enter the required information of the Bank Statement.

• Account  : Select an account that add in the bank statement
• Start Date : Select the start date that add in the bank statement
• End Date :  Select the end date that add in the bank statement
• Start Balance : The beginning balance
• End Balance : The end balance
• Date : The balance date
• Description : The shot details
• Received : The received amount in Bank Statement
• Spent : The spent amount in Bank Statement
• Balance : The system calculate automatically by the (Opening balance + Received - Spent)

Click on Add a new line button to add a new item, once done can be saved.

Once saved it will appear as below.

And can edit the bank statement list by clicking the Edit button.