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. |
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 |
Related Concepts
About Check Ranges and Numbers
What is a Bank Statement Definition?
Related Tasks
Creating Custom Bank Account List Views
Creating and Activating Check Ranges
Creating Bank Statement Definitions
Reference