Bank Statements

There are 2 ways to add bank statements:

• Importing
  

• Manual
  

To import a bank statement it must be in either CSV or basic Xls (no formulas or fancy row filters etc). On the bank statements page, click on the "Add one now" button and complete the form:

• Statement number
  

• Date from
  

• Date to
  

• Bank account
  

• Closing balance
  

Select your file by clicking on the "Browse" button at the bottom of the form, then click on "Add Statement".

Then you need to match up the columns in your imported file (the 1st row must be column names) with the fields in the database. 

Click on the "Import" button and all your statement transactions will be imported.

If you don't have access to a statement export file you can add one manually. On the bank statements page click on the "Add one now" button and complete all the above fields, except for the browse to your file one.

Click "Add Statement", then click on the statement number and you will be taken to a page where you can add the transactions.

Click on the "Add Transaction" button and complete the form to add a transaction to the statement.

Once you have added a statement and transactions, click on the "Reconcile" button and you will be taken to a page that lists your bank statement transactions on the left and reconciling options on the right.

At the top of the page will be your current system balance next to the statement balance.

The idea is to reconcile each transaction by either of the following:

• Creating a system record that matches the statement transaction
  

• Matching the transaction to a system record already created
  

• Splitting the transaction across multiple records already created
  

If you have a transaction on your statement that you don't have a corresponding income or expense record for, click on the "Create" tab and complete the information.

The system will create a transaction that matches the statement one and mark it as reconciled.