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 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 auto check reconciliation 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 screen.

3. In the Format ID field, enter an ID for the import format.

4. In the Desc field, enter a description of the format ID.

5. In the Bank ID field, select the bank from which to import the file.

6. In the User to Notify field, 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.

7. In the Date Format field, press F10 and select 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.

8. Use the File Format hot key to display the Upload File Format screen and then define the file format.

9. In the Record Type field, press F10 and select whether the record type is blocked at a fixed-length, or variable-length.

10. In the Record Length field, do one of the following:

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

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

11. In the Delimiter Char field, press F10 and select whether a comma or tab character separates data fields within records.

12. In the Delete Chars field, enter any characters in the import file that are not related to the data and can be deleted, such as quotes.

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

14. In the Data Format area, the system hard codes the settings for the following areas, but you can, if necessary, change them:

• Check Number

• Date Cleared

• Check Amount

• Bank Account

Define the settings in the Data Format area as follows:

• 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 the Elmt# field, specify the relative position in the import file record of each data item listed in the Data Format field.

15. 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.

16. Press Esc to save the format.

See Also:

Reconciling Checks Overview