There are numerous reasons that an import record does not match with an account in the ES100. The following are some of the common reasons that could result in a mismatch:

1. The account does not exist and must be set up.

2. The account is set up but the Account Type is wrong.

3. The account is set up but Detail 1 is not formatted exactly as it is in the import record.

4. The account is set up but Detail 1 is incorrect for the account.

5. The data in the ES 100 is set up correctly, however the data in the import file is incorrect.

To troubleshoot, click Processing Tab.

Click Import Accounts

Click Edit Exceptions and a report of all exception will appear.

The above screen shows no exceptions. However if there are exceptions, they will appear on this screen. Click on the first exception. This will open the import record.  Typically you would NOT edit the exception record, as this is most likely the information provided by your third party vendor.  Typically you would identify the corresponding account in the ES 100 and edit the Detail 1 field to match the information to the imported record.  You can however edit any of the information of the imported record.

Click Cancel. Follow the instructions in the next section to Edit the account records. Repeat the process until all exceptions have been resolved. Click Rerun Exception. Click Process– The number of exceptions successfully assigned will appear on the screen.