Bank File Format

If Bank Reconciliation is to be run in CSV mode (i.e. the bank's data will be imported into the reconciliation then matched to GL transactions), it is necessary to set up a Bank Format record. This is a definition of how to interpret the data on the import file; which position holds the date, the amount and so on.

There is one Bank Format for each GL Bank account. When running the bank reconciliation in CSV mode, the system will pick up the appropriate Bank Format based on the GL Account entered in the set-up window for a new CSV reconciliation.