Skip to main content
Kofax

How to Reconcile Transaction(s) from a Third-Party Import File in Equitrac

How to Reconcile Transaction(s) from a Third-Party Import File in Equitrac Problem Statement: How to Reconcile Transaction(s) from a Third-Party Import File in Equitrac Cause: Transactions from a third party have been imported into EP5 and need to be reconciled. Resolution: Determine which (if any) transactions in the import file did not get posted to Equitrac by comparing the number of transactions in the import file with the number of transactions actually posted to EP5. Run a transaction report in EP5 for the transaction disbursement type of the transactions imported and the date range for the transactions in the import file, and compare it to the third-party import file.   HINT:  Open the import file in Excel to make it easier to read, especially if it contains a lot of records. If only one transaction did not post, look for a transaction of that amount in the import file. Compare the data in the transaction to any other transactions that might have the same amount and confirm which one is not in the EP5 system by checking reports and the Transaction Editor. Once you have identified the missing transaction, compare the record to the others in the file and determine if it contains erroneous/garbage data, or in the case of a fixed length file, determine if the fields in the record line up correctly. If more than one transaction did not post, compare the posted EP5 transactions against the import file to identify the missing data. You may need to also run a disbursement exception report for the disbursement type and date range included in the import file to identify transactions from the import that did not have valid clients and/or matters. HINT:  Import the entire import transaction file into Excel to view and manipulate. Once you have identified and corrected the missing transactions, there are two options available to post the transactions to EP5. You can manually enter them in Equitrac using the Web Admin, or you can cut and paste the transaction into a new import file, make any necessary data or format corrections, and then import the new file into EP5.