'Bank Statement Batches' allow you to import / enter bank statement data from the client's 'bank accounts'.

Bank Statement data should be entered exactly as it appears on the statement issued by the financial institution in terms of:

  • Transaction date
  • Payment amount
  • Receipt amount
Details and Reference fields are as you wish (either import just as on the actual statement - or - your own improved descriptions).


How to add bank statement data:

There are numerous places to get to the same import page but here's two of them...

From 'Bank Accounts' home page or via 'Bank Statement Batches' home page, hit Add Statement data:

    

You'll then be brought to a page with three options:
  1. Use AutoEntry Statement Capture
    • This allows you to import data already extracted from paper / pdf statements in AutoEntry's Bank Statements folder
  2. Import data using a CSV file
    • Alternatively use one of our simple import templates for adding statement data 
    • Just follow the hints on the import page  and 
    • and remember to save as a CSV file before importing the template
  3. Enter data on screen
    • Jump straight into an empty bank statement batch entry page and begin adding transactions on screen
Note: Using the third method will require you to code each transaction to the general ledger before posting whereas import options 1 & 2 will import the data into an 'unposted' state where you can code transactions to the general ledger as and when you like.. 


Key things to know in bank statement batches:


  • If there is a payment to (or receipt from) another account which is set up as a 'bank account', then you need to follow the process for a bank transfer - see here for more...

  • If there are payments which need to be reconciled / matched with outstanding cheques see here

  • If there are receipts which need to be reconciled / matched with outstanding deposits follow the same method as cheques (above), but for deposits instead...

  • If you need to split a payment or receipt amount between two or more accounts see here


Checking the accuracy of bank statement data: