Bank Statement Definition Fields

Here is a description of the custom fields in a bank statement definition. Some of these fields may not be visible or editable at all times, or in all package combinations.

See What is a Bank Statement Definition? for more information on the options available.

Key:  * – Mandatory field

Field   Description
Bank Account * Reference to the related bank account. Only one bank statement definition per bank account is allowed.
Date Format * Format of dates in the file, such as mm/dd/yyyy.
Decimal Separator   Use a comma or period as a decimal separator.
File Delimiter * Use a comma or semi-colon as a file delimiter.
Maximum Decimal Places * Maximum number of decimal places. Defaults to 2.
Payment/Receipt Format * How payments and receipts are represented in the file.
Start Row * The row number to start the import from.
Thousands Separator   Use a comma or period as a thousands separator.

Column Mapping

Enter a column number for the following types of data in your bank statement import file as required.

Key:  * – Mandatory field; ** Mandatory if Payment/Receipt Format is "Two Columns", otherwise you must specify Amount Position.

  Field
** Amount Position
* Date Position
  Description Position
** Payment Position
** Receipt Position
  Reference Position