Vendor Management : Proper Vendor

1104 Words5 Pages
Vendor Management Proper Vendor Inactivation In order to determine the vendors that made invoice payments in 2015 (hence, they do not have a year of no payment history), our team used the FILTER tool in Excel in order to isolate vendors that had orders after November 18th, 2014. Once those vendors were isolated, we used the CONCATENATE tool to set up the STATA function “drop if Vendor_name”. Once this function was entered into STATA, the program dropped vendors that did have a year of payment history. This let us with a worksheet of vendors’ orders that have been paid over a year and since had no payment history. We used the “conditional formating” function in order to isolate and remove the duplicate vendor entries. Our team found 393…show more content…
Additionally, when the addresses of the employees were compared to the vendor payment historical list, we found six instances where payments have been issued to addresses of employees, as mentioned above in the section titled “Vendor Approval”. Multiple Active Vendors Due to business growth and expansion, vendors may have multiple active vendor records, but they should have unique vendor numbers and remitting addresses. To examine if the vendor master file followed this business rule, we ran some tests in Excel. We used the concatenation, sort & filter, and conditional formatting functions to identify the duplicates and then reviewed each vendor. The total number of active vendors is 3,697. We found 434 duplicates active vendor name out of 779 instances of multiple active vendors with unique vendor numbers and remitting addresses. There are 345 unique vendors that have multiple active vendor records where there mailing address is different. Please find the table below for some instances that the vendors have multiple active vendor records with different mailing addresses. Vendors and Tax I.D. Different vendor entities should have different Tax IDs and vendors with multiple vendor records should have the same Tax ID. In order to test if the client’s vendor master file followed these guidelines, we used the same method. First, we analyzed the Vendor Master file using ACL and
Open Document