Bank statements

Bank statements



There are 2 ways to add bank statements:
  • Importing
  • Manual

Importing

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.

Manual

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.

Reconciling Statements

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

Creating new records

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.
    • Related Articles

    • Bank accounts

      Bank accounts are used when reconciling bank statements.  You can add as many as you need by simply going to "Setup > Finance > Bank Accounts".
    • Profit & loss

      When you start reconciling bank statements against your invoices and expenses, your profit & loss figures will be automatically populated. Click on the account codes to view all transactions for that account code. Click on a monthly figure to see all ...
    • Payment providers

      To have the ability to accept online credit and debit card payments from your members you need to setup a payment provider. We have teamed up with Stripe and it is free to get a Stripe account. To set this up, go to "Setup > Payment Providers" and ...
    • Expenses

      Expenses are used in the profit and loss sections. When you reconcile your bank statement, what you are doing is matching the transactions on the statement to the expenses (and income) in the system so that the two "match up".
    • Permission groups

      Access permissions are controlled by "Permission Groups". Each member can be in only one permission group, but you can set as many groups up as you need. There are various options available and they are self explanatory: Add Users  Add Awards Add ...