The Reconciliation Process is designed to compare, Account Details to Client report/file Details and give you the differences in NAME, File Principal Due or If the Account is in your System but not on the Clients Report/File they sent to compare.
First, configure a Data Interface for the Reconciliation CSV Comparator from Impact → Tables → Data Interface Tables → Data Interface Config Table. While creating the Data Interface Config, select COMPANY and CLIENT for which this process is for. Disregard the Company ID, Last Request ID and New Debtor Batch Parameters.
Next, setup a Client Code Export Table for the interface you just created above from the following menu: Impact → Tables → Data Interface Tables → Client Code Export Table
Next, configure the Status Code Export Table from the following menu: Impact → Tables → Data Interface Tables → Status Code Export Table. One for each status code that will be used on that client's accounts
Example setup for Status Code NEW
Next, upload your Reconciliation CSV Comparator file.
Note: valid CSV column name sin CSV file must be any of the following in any order: dbt_no, clnt_acnt1, clnt_acnt2, name, lname, fname, princ_due
To process the Reconciliation CSV select:Ex
Reconciliation CSV Comparator Navigation Menu
Reconciliation CSV Comparator UI Navigation Window
Once the Reconciliation CSV Comparator option is selected, the following window is displayed
Reconciliation CSV Comparator Window
|Interface -||Select the Data Interface you created for this Process for the Client you received the file from. If Mutliple Client Codes, please configure the Data Interface Client Code Import table with the Additional Client Codes. (Make sure to select the Data Interface Code you Setup)|
|Referral Dates - Thru -||Used to Select the Beginning Referral Date of the Accounts from the Client Report/File they sent to you|
|Up to Date -||Used to Select the Ending Referral Date of the Accounts from the Client Report/File they sent to you|
|Input Path -||Select the Location of the Report/File you Client sent you to Compare|