FIND THE RIGHT DATA IN YOUR BIG DATA

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)
• Split JEs (single je/multiple accounts, multiple JEs/single account)
• Segregation of duties (park vs. post, post vs. create account)
• Dormant accounts
• Even dollar JEs
• Suspicious keyword in JE description
• Duplicate GL accounts based on the account description

FCPA - Anti-Bribery & Corruption

• PEP/OFAC sanctioned providers name matching
• Suspicious key word matching
• Transactions with high risk countries
• Repeat even dollar transactions
• Flip-flop bank account
• Unauthorized vendor data changes
• Overpaid purchase orders
• Invoice receipt greater than goods receipt
• Flip-flop payee names
• Split payments