Importing / Updating Cleared Check Data

Importing / Updating Cleared Check Data

The Import / Update Cleared Check Data utility uses a 3-column spreadsheet to bring cleared check data into FIMS. It matches the information in the spreadsheet to the Check Reconciliation by check number and check amount. When a match is found, the Date Reconciled field is updated with the value in the Date Cleared column. The import also checks for duplicates during the process, so that the same check clear data is not entered more than once.

NOTE: If the check number and amount do not match data in FIMS, the data will not be imported.

1. In the Accounts Payable module, select File Maintenance > Import / Update Cleared Check Data. The Import / Update Cleared Check Data window opens.
   
   Import / Update Cleared Check Data Window

2. In the Import File field, enter the full path and file name for the spreadsheet file that contains your check data. If you are not sure of the exact path and file name, click the Lookup button to search for the desired file.
3. (Optional) If you want to limit the import to a certain range of rows in the spreadsheet, enter the desired range in the Import Row From / Through fields.
4. Click the arrow in the Bank Account drop-down and select the account associated with the spreadsheet entries.
5. Click the arrow in the Check Number field and select the spreadsheet column that contains the check number information.
6. Click the arrow in the Check Amount field and select the spreadsheet column that contains the check amount information.
7. Click the arrow in the Date Cleared field and select the spreadsheet column that contains the cleared check date information.
8. (Optional) If you only want to include exceptions in the report, select the Exceptions Only Report checkbox.

   NOTE: Running an exceptions only report allows you to view all of the items in your spreadsheet that do not have a matching transaction in FIMS. These transactions cannot be imported, but will allow you to verify your FIMS data.

9. (Optional) If you want to save your settings for future use, click the Defaults button and click the Add button to create a new saved setting.
10. Click the Import button. The Check Reconciliation Import report opens in the FIMS Viewer.