Subscribe for NewsLetters
Email: *
 
First Name: *
 
Last Name:
 
Organization:
 
Position:
 
Country:
Enter Captcha:*
captcha
Search_btn
Audit Net Ad   Trends Report
Futr 468x60 (1)
Asv Banner
C Risk Academy Banner
Vendor Matching Workbook July 2014

Name

Vendor Matching Workbook July 2014

Description


Background: This macro performs 3 types of tests
Test 1: Exact Match on Full Address
Test 2: Similar Match on Full Address (this is a 'fuzzy' match. The macro will first remove 'spaces' and 'special characters' and then compare the addresses. You'll get more matches to review but might have some false positives.)
Test 3: Similar Match on Partial Address (this is a 'fuzzy' match. The macro will first remove 'spaces' and 'special characters' and then compare only the first 7 characters of each address. You'll get more matches to review but might have some false positives).

Instructions:
Step 1: Paste your employee address information into the 'Employee Address' tab using the column headers provided and following the example text provided
Step 2: Paste your vendor address information into the 'Vendor Address' tab using the column headers provided and following the example text provided
Step 3: Click the 'Run Macro' button below

Results: See 'Potential' Matches section. Use the 'Audit Tracking' numbers to trace matches back to the detail info in the 'Employee Addresses' tab and the 'Vendor Address' tab.

Reset Macro: Press the 'Reset Macro' button to prepare the macro for subsequent testing.

IT Audit Program

Comments

Download

This audit program is only available to premium subscribers. Please log in or sign up for a subscription to get this audit program.

Subscription Level

Premium

Language

English