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