...

1. Importing a statement file from the bank:
   1. The file must be an xlsx or csv format file.
   2. It must have column headings in row 1, containing (Column headings are not case sensitive) :
      1. narrative OR description
      2. date
      3. debit
      4. credit
      5. balance
   3. 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.
   4. the date on the first import line must be after the last bank line Bank Date
   5. Drag the statement file over the Statement-centric bank rec form and drop it.
   6. Reply Yes to upload the file.
   7. Action menu
      1. 'Import bank statement'.
      2. 'List bank statement(s)'.

Overwriting a statement import

1. Action menu option, 'Re-import bank statement days':
   1. Must have uploaded a spreadsheet or .csv file of bank statement lines.
   2. The balance on the first import line, if any, plus the Bank Out-DR or minus the Bank In-CR of the line must match the balance on the last bank line dated before the Bank Date of the line, if any.
   3. The balance on the last import line, if any, must match the balance on the first bank line dated after the Bank Date of the line, if any, plus the Bank Out-DR or minus the Bank In-CR of the line.
   4. All existing bank lines between and including the date of the first import line and the date of the last import line will be deleted before re-importing the uploaded bank statement lines.

Batches of Journals

Journal batches are common - example credit card batches where an aggregator deposits the result into the bank at the end of the day from a POS.  In this case all the journals as they are created are linked to the batch.

...