Better Business Through Data Analysis & Monitoring My Account

Analytics in Action

Financial and economic conditions have increased scrutiny of government spending. Auditors work under shrinking budgets to identify and eliminate fraud, waste and abuse amid a host of compliance mandates and other challenges. Government agencies carry the burden of public trust to protect sensitive data, increase efficiency, ensure transparency and maintain accountability.

Federal agencies are increasing their ability to improve the overall efficiency and effectiveness of audits by using a variety of techniques to analyze and interpret data. IDEA data analysis software has been used by U.S. federal government agencies, military and contractors for more than two decades to help:

  • Gain greater understanding of data while ensuring data quality and security
  • Compare data from separate systems to identify anomalies
  • Detect potential false, inflated or duplicate invoice payments within large amounts of data
  • Apply predictive analytic techniques to identify fraud and errors before payments are made
  • Automate repeatable processes to increase efficiency and streamline processes
  • Meet new data standards such as the DATA Act

Key Analytics

avt.TabsPro

 Operations & Financial Management
  • Extract duplicate names and social security numbers from employee database
  • Compare employee termination dates to payroll to ensure no erroneous payments
  • Identify employees earning more than a specified percentage of salary in overtime
  • Identify duplicate payments (e.g. same amounts, common dates, etc.)
  • Determine whether journal vouchers are corrected on a timely basis
  • Perform trend analysis of expenditures for each month, compare departments, and identify large and small monthly expenditures
  • Identify staff with a large number of correcting journal entries
  • Highlight postings to infrequently used accounts
 Project Management
  • Summarize government program dollars spent and calculate averages by program
  • Identify capital project with large unexpended dollars
  • Compare expenditures to budget
  • Identify key indicators on completed projects and compare them to projects in progress
  • Summarize sources of funding and compare to budgeted amounts
 P-Card
  • Monitor for duplicate payments between P-card merchants and Accounts Payable vendors
  • Check for charges at inappropriate or unusual merchants (i.e. department stores, cash, personal care) by MCC code or vendor name keyword search
  • Pinpoint split charges to circumvent purchasing card limits
  • Identify cards used by terminated employees and/or employees on leave of absence
  • Search for expenses that may be approved without verification of receipt
  • Look for cardholders who made purchases on weekends or holidays
  • Check for unused or duplicate cards, which may be causing unnecessary liability
  • Search for sales tax charges. As a non-profit organization, most universities are exempted from sales tax.
  • Identify the top 20 spenders to pinpoint which cardholders have the highest total purchases
 Purchasing Management
  • Extract contractor payments and trace contractor expenses to determine whether expense was valid and properly supported
  • Compare total vendor purchases to amount of approved contract and terms
  • Analyze products purchased to identify potential waste and mismanagement
  • Extract purchase orders below dollar amount requiring compliance with sealed bids
  • Match vendor information to employee information (employee, dependent, emergency contacts) to ensure compliance with vendor restrictions


Delena Spann, MSc., CFE, CCA,
US Federal Law Enforcement Agency

Trusted by Government Agencies