Defining Auto Check Reconciliation Formats

Use the Auto Check Reconciliation Import Formats screen to define the file format of check information to import for automatic check reconciliation purposes. You may need to define multiple formats if you import information from multiple banks.

To be able to use this functionality you must set up the Auto Check Reconciliation Administrator User ID control maintenance record. To set up this record, enter the user or group to message if the format ID specified in an automatic check reconciliation import file is not listed in the Auto Check Reconciliation Import Formats control maintenance record.

To define an import format:

  1. From the System > System Files menu, select Control Maintenance to display the Control Maintenance screen.

  2. In the Keyword field, enter Auto Check Reconciliation Import Formats to display the Auto Check Reconciliation Import Formats window.

  1. Complete the following fields regarding the import format:

Field

Description

Format ID

Enter a unique ID for the import format.

Desc

Enter a description of the format ID.

Bank ID

Select the bank from which to import the file.

User to Notify

Enter the user or group to message if there is an error in the bank file that prevents any part of the check reconciliation process from completing.

The system sends the error report to the Hold file of the user or every user in the message group.

Date Format

Select from one of the following to determine the format of the date field on the import file:

  • US Dates - Formats the dates as MM/DD/YYYY.

  • EURO Dates - Formats the dates as DD/MM/YYYY.

  1. Click File Format to display the Upload File Format screen and then define the file format:

Field

Description

Record Type

Press F10 and select whether the record type is blocked at a fixed-length, or variable-length.

Record Length

Do one of the following:

  1. If the record type is blocked, specify the record length.

  2. If records terminate with a carriage return or line feed character, enter 0 as the record length.

Delimiter Char

Select whether a comma or tab character separates data fields within records.

Delete Chars

Enter any characters in the import file that are not related to the data and can be deleted, such as quotes.

  1. Press Esc to save the file format information and return to the Auto Check Reconciliation Import Formats screen.

  2. In the Data Format table, the system hard codes the settings for the following areas, but you can, if necessary, change them: Check Number, Date Cleared, Check Amount, and Bank Account.

The settings in the Data Format area are defined as follows:

Field

Description

Start

Enter the starting position of the number, date, or amount.

Lngth

Enter the length of the number, date, or amount.

Dec#

Enter the number of decimal points in the Amount data item.

Note: For variable records, in theElmt#field, specify the relative position in the import file record of each data item listed in theData Formatfield.

  1. Use the Log hot key, as needed, to view the maintenance log for this record.

Note: For the system to log changes to this record, maintenance logging must be enabled for the WORK.MISC file.

  1. Press Esc to save the format.