Results
Using the scoring process to rank each vendor file based on missing or mis-formatted data helped separate valid vendor records from duplicates or invalid entries. Remaining records were merged and formatted to comply with the vendor master naming convention. The project reduced the mixed records from approximately 130,000 to 20,655 active records. Records that were missing critical information, such as a valid Tax ID were deactivated, as were any records associated with the Golden Vendor other than the correct record.
Carrtegra provided the client with production versions of the IDEAscripts, and reference materials to ensure existing and new vendors are entered properly to prevent future errors and help reduce potential risk.
About Carrtegra, LLC
Carrtegra, LLC is a successful financial and accounting management consulting firm specializing in designing and reviewing business processes, evaluating controls and making critical recommendations that increase process efficiency and reduce risk. As an IDEA Integration Partner, Carrtegra provides creative and effective solutions using IDEA to evaluate and resolve complex challenges, investigate fraud and monitor processes for compliance. For more information, visit www.carrtegra.com.