GAO WatchBlog Reblog: 2017 High Risk List

This year, we added the federal government’s environmental liability to our High Risk List—our biennial report highlighting areas particularly susceptible to fraud, waste, abuse, mismanagement, or needing a fundamental transformation.

When federal government activities contaminate the environment, the government’s on the hook for the cleaning bill. In 2016, this bill was estimated to be $447 billion, and the actual costs may be more.

Read more here, or watch the video below.


Want to know what else made the high risk list this year? Check it out.


Accountability and Media Featured

Government Waste Hotline: January – December 2015


The Oregon Secretary of State Government Waste Hotline (hotline) was established in 1995 to provide a way for the public to report possible instances of fraud, waste, or abuse of state funds. Approximately $16 million in questioned costs have been identified since the inception of the hotline. As required by law, we prepare an annual hotline report to summarize the activity reported during the most recently ended calendar year. During calendar year 2015 the hotline received 243 initial reports (up 35% from the prior year) ranging from requests for information to reports requiring further review.

Read full report here

This report summarizes activity reported through the Oregon Secretary of State Government Waste Hotline (hotline) in calendar year 2015. As required by Oregon Revised Statute 177.180, we describe the number, nature and resolution of hotline reports received during the year.

The toll-free hotline was established in 1995 for public employees and members of the public to report waste, inefficiency or abuse by state agencies, state employees or persons under contract with state agencies. The hotline’s toll-free number connects callers to professional operators who receive reports 24 hours a day. In addition to a toll-free telephone line, hotline reports may be submitted through other methods such as online reporting, email, and telephone calls directly to the Secretary of State, Audits Division (division). Staff at the division review each hotline report and determine which reports to investigate further.

Since the inception of the hotline, we have identified approximately $16 million in questioned costs. Those amounts represent misappropriated public and private funds, questionable expenditures, monies not spent in accordance with applicable laws, errors in federal awards, and potential savings that could result from improved efficiencies or elimination of waste or abuse.

The hotline received 243 initial reports in calendar year 2015. The nature of the reports varied from requests for information to reports that may warrant further investigation. We resolved reports by performing reviews, referring reports to contacts at other public bodies for their consideration and review, referring callers to appropriate contacts, and providing requested information. Six reports from calendar year 2015 remain open and may result in a review, audit or investigation.

The Government Waste Hotline can be reached at:



Read last year’s report here:

Government Waste Hotline: January – December 2014


Featured New Audit Release

How to: Apply Benford’s Law in Excel to Detect Fraudulent Activity

We apply Benford’s Law here at the Oregon Audits Division as part of our fraud investigations.

For those who haven’t heard of it yet, Benford’s Law is a natural phenomenon that occurs in certain data sets. Just as the Bell Curve predicts certain distribution of numbers, so does Benford’s. You can use Benford’s to detect fraudulent transactions by looking for outliers.

Benford’s Law predicts that the number 1 will occur more often as the first digit than any other number. In fact, the number 1 is about 6 times more likely to occur than the number 9 (30.1% vs. 4.6%). The law can also be applied to the first two digits and other applications, but we won’t get into that now.

So what data sets conform to Benford’s? Well there are some, like the drainage of rivers, that do not apply to auditing, but there are also plenty of financial transactions that do.  First off, you want to have a dataset that has a large sample size.  Ideally, over 1,000 records.  This is one of the cases when 30 is a very inappropriate sample size.

Second, you want data that is not limited. ATM transactions for example are limited because there are minimum and maximum withdrawals.  They also generally require increments of $20.  Being limited also includes using assigned values like invoice numbers.  All of the digits (1 through 9) should be possible.

The data should also ideally cross multiple orders of magnitude (e.g. 1 to 10, 10 to 100, 100 to 1,000).

Here’s a list of data that should generally conform:

  • Home addresses
  • Bank account balances
  • Census data
  • Accounting related data such as Accounts Receivables
  • Transaction level data

Now that I know what data to use, how can I analyze it? With Excel of course!


1 – Load Data in Excel

2 – Calculate first digit

3 – Run Benford’s using Countif

4 – Graph

The following uses real world data that helped to convict several fraudsters in Oregon.

Screenshot of Steps 1 & 2

benfords 1

Using the left function, you can calculate the first digit of a number.

Screenshot of Step 3

benfords 2

Using the countif function, you can calculate the number of first digit in your data. You will need to calculate the percentage too.  The log formula on the right is Benfords Law in numerical form.

Screenshot of Step 4

 benfords 4

Looking at the graph, you can see that the digit 1 is overrepresented. The next step is to drill down on records that do not match Benfords.  A closer examination of these records with a first digit of 1 will yield a large number of $100 transactions.  Those $100 transactions were largely, if not all, fraudulent.  By using Benfords you can quickly identify suspicious patterns to help detect fraud.

Benfords will lead to false positives, so do not assume that if there is an outlier it has to be fraud. Next time, how to do Benford’s in ACL and why you should use the 2-digit Benford’s test.

Data Wonk Featured Fraud Investigation How To

Audits in the News: Week of Dec. 7

Audits in the News: The division’s fraud hotline is featured in The Daily Astorian.

We here in the audits division are proud that the work we do makes a difference. Our work attracts the attention of the legislature, statewide news sources, and even local media outlets. Local media coverage of our audits is just another way we communicate with the people of Oregon about the work that we’re doing on their behalf to make government better. This is part of an ongoing series of posts rounding up recent instances in which the Oregon Audits Division makes a cameo in the local news.

In addition to our audits, the division is responsible for the Secretary of State’s government waste, fraud and abuse hotline. The hotline accepts anonymous calls and complaints from citizens and investigates instances in which waste or abuse of resources — or downright fraud — may be occurring within state government. Recently, our hotline received a little media coverage of its own.

The Daily Astorian – Calls to government waste hotline at a five-year high

Read the story here.

“As of Nov. 10, the agency had received 235 complaints, according to audit manager V. Dale Bond at the Secretary of State’s Audits Division. Employees still have to go back to remove any duplicate complaints, but the highest number of complaints in the last five years was 184 complaints in 2010, according to an email from Bond. The lowest number of complaints during that period was 145 complaints in 2012.”

Photo: © Kornwa | Dreamstime Stock Photos
Audits in the News Featured Fraud Investigation

2014 Secretary of State Hotline Report

2014 Secretary of State Audits Division Hotline Report

  • The Audits Division Hotline received 180 reports in calendar year 2014.
  • We resolved all but four of the reports at year’s end by performing reviews, referring reports to contacts at other public bodies for their consideration and review, referring callers to appropriate contacts, and providing requested information.
  • We invite anyone with concerns about fraud, waste, or abuse to contact the Hotline at 1-800-336-8218. We can also be reached online here.
Featured Fraud Investigation New Audit Release