Skip to main content

Format X (Generic CSV File)

The generic CSV format loads a CSV file in the format in which Coins ERP+ displays the statement; that is, the fields in the file must be comma-separated and in the following format:

  • 1st field: Transaction Date (must be in the format day month year with no spaces or with slashes separating the parts)

  • 2nd field: cheque. Integer. The cheque number if the statement item is a cheque. Cheque number as it appears on the statement

  • 3rd field: Description (must be enclosed in quotes or two quotes together to represent a blank)

  • 4th field: Value

  • 5th field: Transaction Type (must be enclosed in quotes or two quotes together to represent a blank)

The entries are checked and return an error if the transaction date is out of the statement range, if the transaction date is unknown or the value is unknown.

If the format you require is not available, you could use the generic format and reconfigure the statement file to fit the format Coins ERP+ requires.

Did this answer your question?