Macros for Procurement Audit
Macros for Procurement Audit Benford's Law Fraud detectionDownloads First digits lawSite Map
Home Page | Population | Sampling | Fraud | Other | Tutorial | Macros
Macros for Procurement Audit
LinkSummary Description
runall Run all the macros here sequentially
POStep1 Extract PO data from MS-Access database
POStep2 Sort by voucher number
POStep3 Check for duplicate voucher numbers
POStep4 Check for gaps in check number sequences
POStep5 Sort by vendor, sub-total by cost
POStep6 Obtain basic population statistics
POStep7 Obtain Invoice statistics by vendor
POStep8 Stratify by invoice amount
POStep9 Extract an interval sample
POStep10 test using benford's Law
POStep12 Check benford's law by vendor
POStep13 Quantify use of round numbers
POStep14 Quantify use of round numbers by vendor
POStep15 Check for Holiday dates
POStep16 Check for holidays by vendor
POStep17 Obtain analysis of weekday by vendor

 

 

 

 

Main Page

Complete Auditor resources
Links | Privacy Policy | FAQ | Downloads | Trademarks
Web Page last updated on 04-20-2008
© EZ-R Stats, LLC 2005-2007