Bank Statement Definition Fields
Here is a description of the custom fields in a bank statement definition. Some of these fields might 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 |