Versions Compared

Key

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

...

Note
titleUpload File Format

The Bank statement upload needs to have the following headings - modify your CSV file to suit

  • Date (of transaction)
  • Credit
    • Bank Account this is an increase in $ Value > (this is a positive number not a negative number)
    • Credit Account this is a decrease in Amount owed) > (this is a positive number not a negative number)
  • Debit
    • Bank Account this is an decrease in $ Value
    • Credit Account this is a increase in Amount owed)
  • Description - the text on the transaction

Negative values will NOT be converted - you need to create separate columns of debit and credit

...