The Automatic Reconciliation program is used to define the data fields for the file received from the bank to reconcile the district's disbursements. The required formatting for the file is determined by the bank's requirements.
The Import File Type must be equal to one of the following:
- CSV - Indicating comma separated delimited file. The Length is preset for each field. Comma separated files place quotes around text fields and separate fields with commas. These files are simpler to work with compared to fixed length files, as only the field order needs to be known.
- Fixed Length - All information is formatted with either valid data or spaces. Fixed Length fields are filled with spaces to a specified width. Each field has an offset from the start of the line, and a length in number of characters.
The Import Fields to choose from include:
- Amount (Explicit Decimal): this means an explicit decimal meaning the check amount on the file type includes decimals
- Amount (Implicit Decimal) this implies decimals so the check amount on the file type should not include decimals
- Bank Account
- Check Day
- Check Month
- Check Number
- Check Year
- Ignore: May be used to account for a "space" on the CSV or Fixed Length format. needs to be accounted for in order for USAS to read the check number and amount correctly
- Payee
- Void Flag
The Length will be automatically determined by the import field chosen. The format of the field will be automatically displayed.
Once the Reconcile format has been chose, click on 'Save' to save the format.
You can add several bank formats for a district. To view a specific bank format, click on the drop down box next to 'Saved Formats', choose a format and click on LOAD.