We are all swimming in data. But how do you tap the flow of information to gain the insights you need? Together, we find the data that matters most, analyze it, connect it, and figure out the best way for you to experience that information in order to reach your goals. How do we do that? We utilize the most advanced data analytics and visualization tools (ACL, Tableau) to meet your objectives.
INFORMATION MANAGEMENT AND DATA ANALYTICS > OFFERINGS
Data Visualization and Discovery
Data Management
Data Analytics
Information Strategy
Business Intelligence
Information Governance
INFORMATION MANAGEMENT AND DATA ANALYTICS > OFFERINGS > DATA ANALYTICS
Purchase to Pay (Accounts Payable)
Order to Cash (Accounts Receivable)
Travel and Entertainment
Purchasing Card
Payroll
General Ledger
Anti-Bribery Analytics for Foreign Corrupt Practices Act (FCPA)
Also:
Missing and Extreme Analysis
Sampling
Matching/Un-matching Analysis
Ad-Hoc Reports/Analysis
Advanced Scripting/Coding
Continuous Auditing and Monitoring
EXAMPLES OF DATA ANALYTICS:
Purchase to Pay (Accounts Payable)
Duplicate payments
Duplicate invoices
Duplicate/ghost vendors (by name, address, bank account number)
Employee-vendor match
Split purchase requisitions and POs
Stale purchase requisitions and POs
PO date after invoice date
Invoice number sequence
Goods received quantity vs. invoice quantity
Appropriate approval
Multiple invoices from one time vendors
Duplicate purchases (same vendor same invoice number, same amount same GL account)
Invoice layout
Frequent changes to vendor master
Invoices to stale purchase orders
Order to Cash (Accounts Receivable)
Duplicate customers (on name or address)
Credit limits vs. orders
Segregation of duties (order entry vs. customer master, order entry vs. product master)
Unauthorized/excessive commissions
Delivery quantity vs. sales order quantity
Shipment/sales order/price change by an unauthorized employee
Cash receipt vs. invoice amount
Shipment without a sales order
Days sales outstanding
Travel and Entertainment/Purchasing Card
Duplicate charges: corporate card and out-of-pocket
Suspicious keyword match
Round amounts
Excessive high-risk expense categories
Group meal amount per attendee
Gas without rental
Unusual/suspicious merchant category codes (MCC)
Charges made on vacation/holidays
Expense per hotel ratio
Meals over threshold
Invalid cardholder (no matching employee or terminated employee)
Duplicate cardholders (by employee id or address)
Declined and disputed transactions
Split purchases
Duplicate purchases (same merchant same amount)
New cardholder watch list/cardholder watch list
Ghost card activities
Even/small dollar amount transactions
Weekend and holiday transactions
Potential duplicate reimbursements: gas with mileage or P-card with an AP purchase
Spending limits on transactions (lavish hotel stays, dinners, etc.)
Payroll
Periodic departmental comparison
Paid before hired
Paid after termination
Ineligible employees paid overtime
Inflated overtime wage
Excessive overtime
Minimal vacation used
The serial vacationer
Phantom employees
Multiple salary increases
Duplicate employees (same bank account or address)
Employee status not matching the termination date
Exempt hours worked vs. standard hours
Non-exempt hours worked vs. expected hours
Hours worked vs. hours paid
Terminations within 14 days of hire
Invalid pay rates (actual/calculated vs. Master file)
Excessive gross pay
401k annual contribution limit, catch-up contribution limit and catch-up age limit
Job record deletions (data corrections not using effective date)
General Ledger
Unauthorized journal entry (JE)
JEs by unauthorized users
Duplicate JEs (same account/amount, same je number/amount)