Joined: Apr 2003
Tuesday September 11, 2012 4:04 PM
You might first talk with the CFO or your operations managers to see if there are any analytics they would like. That would give you some insight into what they are most concerned about. It would make the results more appealing to your audience (who might not otherwise care if you do them on your own).
Having said that, here are some examples of common analytics in the areas you said were interested in.
Missing key data fields (e.g., part number, quantity, cost)
Duplicate item numbers, parts or descriptions
Negative quantities or costs
Items with zero cost
Significant usage near period-end
Identify surplus or obsolete inventory
High value items' analysis
Stock turnover analysis by item (aging)
Cardholders with a spending limit of the maximum amount that have an actual purchase amount significantly less
Summary of transactions by approver
Purchases by Merchant Category Code
Summary of purchases by vendor
Summary of purchases by cardholder
Spend analysis of each card holder to review for unusual activity
Potential duplicate transactions
Repetitive buying pattern of even dollars, near purchase limits, or same vendor
Purchases from unusual vendors
Individual spend > $ limit
Multiple transactions with same vendor on same day
Split transactions with same vendor on same day
Cardholders with spending limits greater than the policy standard
Missing data in payroll records, such as missing social security numbers or addresses
Review all pay rate changes for the year.
Employees with unusually high overtime compared to others or as a percentage of the employee’s salary
Commissions and bonuses paid as a percentage of product revenue
Changes in exemption, gross pay, rates and salary amounts
Duplicate direct deposit numbers
Individuals on the payroll with no work address, contact numbers, etc.
Match vendor file and employee human resources file for names, addresses, phone numbers, etc.