Import bank statement transactions using the Accountability Excel template

You can use the standard Accountability template to import transactions from banks that do not provide data feeds of statement transactions. 

1. Navigate to Accounting>General Ledger>Bank Reconciliation and click the Import Statement Transactions link. Click Download Template to get the Accountability template. 
2. Log into your banking platform and export the data required then copy and paste it into the Accountability import template. Transaction amounts should be pasted as follows: 

If this is an existing bank account, you need to specify the date from which you will start using this account as an ‘auto reconcile account’. Once you import statement data, Accountability recognizes this as an account that you receive or import statement data for and the method of reconciling transactions changes as described below:

Instead of selecting the transactions on the bank reconciliation page and clicking Present, i.e., telling the system when transactions appeared or where ‘presented’ at the bank, you click the Present button to load a reconciliation page which shows the Accountability transaction postings to this account on the left of the page, and the bank statement transactions on the right side of the page.