Check Setting Format Details

Auto Check Reconciliation is designed for businesses that want to automatically reconcile their checks based on the file provided from their financial institution. Checks in the downloaded file are compared against the checks in the Bank Reconciliation module and if they match, the checks are then marked as cleared from the bank.

Auto Check Reconciliation Wizard Column Heading Comparisons

The table below provides you with some alternative column heading names collected from various financial institutions that you can use to compare and select the predefined fields for the file.

Auto Check Reconciliation Wizard - Column Headings	Financial Institution - Column Headings	Description/Comments
Field Description	Description Data Element Field Field Description Field Name	Provides a list of common fields that are used by your financial institution.
Position	Position Beginning Position Field Position Start Position	Displayed only when using a fixed format file type.
Column No.	Field Field No. Position Column	Displayed when using a comma delimited (csv) file type.
Length	Length Field Length Field Size	You can enter the length of the field for fixed format file types.
Field Value	Value Description Contents	Used for constant values, reporting identifier, transaction type codes, and other conditional values.
Date Format	Date Format Format Rules Comments Description	Contains the following values: YYYYMMDD YYMMDD MMDDYY MMDDYYYY YYYYDDD MM/DD/YY MM/DD/YYYY MM-DD-YYYY YYDDD Note DDD is the number of the day of the year.
Implied Decimal	Field Type Field Details	Select the check box if the check amount includes 2 decimal places.

Define Formatting Information for the Header Record

Use the table below to help select the predefined fields that best match the fields provided by your financial institution. The field descriptions are used for the Header Record.

Auto Check Reconciliation Wizard Field Descriptions	Description/Comments
Record Type	This field indicates the type of record. It is also referred to as the Record Identifier. Example: H1
Account Number	This is compared to the Account Number field set up in Bank Code Maintenance. It is also referred to as the Checking Account Number, Bank Account Number, or Account.
Conditional Value	This field is used to filter the records in the file.

Example of setting up a conditional value for the Header record

A Header record has a Record Identifier field at 14-16. There is a table of possible values, but you want only value R12. When setting up the Header record, enter the following for the Conditional Value field:

Position = 14

Length = 3

Field Value = R12

Define Formatting Information for the Detail Record

Use the table below to help select the predefined fields that best match the fields provided by your financial institution. The field descriptions are used for the Detail record.

Auto Check Reconciliation Wizard Field Descriptions	Description/Comments
Record Type	This field indicates the type of record. It is also referred to as the Record Identifier. Example: R12
Account Number	This is compared to the Account Number field set up in Bank Code Maintenance. It is also referred to as the Checking Account Number, Bank Account Number, or Account.
Check/Serial Number	This field is also referred to as the Check Number, Serial Number, Cheque Sequence Number, or Cheque Serial Number.
Check Date	This field is also referred to as the Check Date, Issue Date, or Date.
Cleared Date	This field is also referred to as the Paid Date.
Amount	This field is also referred to as the Check Amount, Transaction Amount, Dollar Amount, or Cheque Amount.
Conditional Value	This field is used to filter the records in the file.

Example of setting up a conditional value for the Detail record

A Detail record has a Transaction field at 14-16. There are many possible values, but you want only value 057. When setting up the Detail record, enter the following for the Conditional Value field:

Position = 14

Length = 3

Field Value = 057