...
- Importing a statement file from the bank:
- The file must be an xlsx or csv format file.
- It must have column headings in row 1, containing (Column headings are not case sensitive) :
- narrative OR description
- date
- debit
- credit
- balance (optional)
- The balance on the first data row + debit - credit must match the balance on the last row of the previous import for the host/bank account, unless it is the first import.
- the date on the first import line must be after the last bank line Bank Date
- Drag the statement file over the Statement-centric bank rec form and drop it.
- Reply Yes to upload the file.
- Action menu
- 'Import bank statement'.
- 'List bank statement(s)'.
...