We recently published a blog discussing the impact of outdated and incomplete vendor master files. Your vendor master reduces the risk of fraud and payment errors for health systems. Now we walk you through the laborious steps involved in cleaning up, validating, and maintaining your vendor master.
Inspecting and assessing your current data is the most time-consuming part of a vendor data cleanse. Begin by identifying and collecting all of your relevant documentation, vendor files, and data sources.
Once all the necessary information is collected, import to your preferred data management platform such as Microsoft Excel or Access and begin identifying and sorting information such as:
Make note of missing and/or duplicate information to address later. Pay special attention to any missing information that is required by your health system and ensure this data is input in the coming steps.
Start your data cleanse by consolidating duplicate vendors. Look for common errors including:
Archive inactive vendors that have not been used in the past 15-18 months.
Removing inactive vendors streamlines your system’s data processing time resulting in faster processing.
Review duplicate payments made in the last six months and note consistent errors that may have been caused by inaccurate data in the vendor master file. Review your processes and policies and implement process mapping to discover the root causes associated with the errors you found.
Many large organizations often hire third parties such as TAG to cleanse their data due to the complexities and time-consuming nature of the process. Vendors with the ability to clean data have tools built to discover variance and tolerances in data that takes much of the burden out of manual review and speeds up the process.
TAG TIP: To reduce future errors, put data entry standards in place and assign the responsibility of inputting new vendors to one person in your organization.
Once the data has been organized, consolidated, and scrubbed, missing data needs to be added and all data must be verified. When adding new data, refer to your data entry guidelines to ensure your data input follows your organization’s policies.
Next, begin validating information such as vendor tax IDs and addresses by comparing the IDs to online databases often for a subscription fee.
After the vendor master files are organized, cleansed, and verified, identify common reasons for duplicated vendor entries. Are there repetitive causes forcing these errors? What can be done in the future to prevent these errors?
More than likely, the reasons for errors will lie in one of three buckets:
A clean master vendor file delivers cost savings and increases productivity throughout the Procure-to-Pay process by providing user-friendly, reliable, and accurate information. Although the analysis and cleanup may be time-consuming, once finished, it provides a framework for future vendor management.
Learn how TAG can help you cleanse and maintain your vendor master files. Reach out now.