Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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 (optional)
    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)'.

...