Note: Reconciliation Input comes with five predefined file formats that have been tested and assigned to a user. You can create a data file and use the Test Format option to verify that the data file has been created properly.

From the Issue File Format Maintenance page:

1. Click Test Format in the row of the desired file format.
2. The File Format drop-down list will prepopulate with the format selected.
3. Click Browse and select a file located on your local hard drive or network drive. (You can also type in the complete file path and name.)
4. Click Open to capture the file path.
5. If you’re testing a file format that requires the account number to be selected on upload, choose an account in the Account Number drop-down list.
6. Click Upload to begin testing the file upload.

Upload Progress details the steps, date and time of the test upload. This page will close once a valid test has completed

The following is a sample of some messages you might see during Upload Progress:

Once a file format has passed a complete validation, the Upload Results page will display the message, "File format was tested successfully."

The error processing scenario for invalid test formats and failed uploads is similar. The upload progress page will display the message, “Errors identified in uploaded file.”

When you receive an error message, move your cursor to the Recon Input tab and choose File Upload History.
Note: If performing a Production Upload, you can click Back to take you to the Issue File Format Maintenance screen.

Click the Status column to see the error message description on the State Log page.

Click Back to return to the Issue File Upload History page.
Note: If there are file format errors, or if the complete file is a duplicate, you must make corrections before the file can be re-uploaded. If you have individual records that cannot be processed, the remainder of the file can still be processed.

Error Messages

• Invalid account numbers: ____, ____.
• The Customer is not associated with the account number(s): ____, ____.
• The user is not associated with the account number(s): ____, ____, ____.
• The data in line number ___ is not valid as per the Layout.
• The line number ___ is empty.
• Data is incorrect in line number ___.
• The ____ field value in line number ____ is invalid.
• The ____ field value in line number ____should not be more than $99999999.99.
• The field ____ in line number ____ has an invalid date format.
• The length of line number ____ is more than the allowed length.
• Duplicate record(s) found in line number ____ of the uploaded file.
• The data in line Number(s) ____, ____ has been uploaded in earlier transactions