Single Audit Training Workshop Assessing Single Audit Quality of - - PowerPoint PPT Presentation

▶
single audit training workshop
SMART_READER_LITE
LIVE PREVIEW

Single Audit Training Workshop Assessing Single Audit Quality of - - PowerPoint PPT Presentation

Sep 03, 2023 6 likes •499 views

Single Audit Training Workshop Assessing Single Audit Quality of Local Governments in Virginia _____________________________________ August 6, 2015 Michael A. Sidell, CGFM Audit Supervisor Auditor of Public Accounts Quote The goal is to

slide-1
SLIDE 1

Single Audit Training Workshop

Assessing Single Audit Quality of Local Governments in Virginia _____________________________________ August 6, 2015 Michael A. Sidell, CGFM Audit Supervisor Auditor of Public Accounts

slide-2
SLIDE 2

Quote

“The goal is to turn data into information, and information into insight”

  • Carly Fiorina, Former CEO of HP

Page 2 WWW.APA.VIRGINIA.GOV

slide-3
SLIDE 3

Learning Objectives

  • Provide overview of APA’s audit oversight

responsibilities

  • Demonstrate how to obtain data from the Federal

Audit Clearinghouse

  • Demonstrate how to analyze data from the

Federal Audit Clearinghouse

  • Share the results of our analysis
  • Explain how this impacts organizations with audit
  • versight responsibilities

WWW.APA.VIRGINIA.GOV Page 3

slide-4
SLIDE 4

Learning Objectives

  • Provide overview of APA’s audit oversight

responsibilities

  • Demonstrate how to obtain data from the Federal

Audit Clearinghouse

  • Demonstrate how to analyze data from the

Federal Audit Clearinghouse

  • Share the results of our analysis
  • Explain how this impacts organizations with audit
  • versight responsibilities

Page 4 WWW.APA.VIRGINIA.GOV

slide-5
SLIDE 5

Local government audit requirements

  • § 15.2-2511 of the Code of Virginia requires local

governments to: – Have their accounts and records audited by an independent CPA annually

  • APA may undertake the audit or hire a CPA if

locality fails to obtain an annual audit – Applies to all cities, counties, and towns with populations exceeding 3,500

Page 5 WWW.APA.VIRGINIA.GOV

slide-6
SLIDE 6

APA responsibilities

  • Perform periodic reviews to confirm that audits of

local governments complied with applicable standards (GAGAS, OMB A-133) – Accomplished through on-site and/or desk reviews – CPA firms receive a rating of pass, pass with deficiencies, or fail

  • Results are communicated to State Board of

Accountancy

Page 6 WWW.APA.VIRGINIA.GOV

slide-7
SLIDE 7

Page 7 WWW.APA.VIRGINIA.GOV

slide-8
SLIDE 8

Learning Objectives

  • Provide overview of APA’s audit oversight

responsibilities

  • Demonstrate how to obtain data from the

Federal Audit Clearinghouse

  • Demonstrate how to analyze data from the

Federal Audit Clearinghouse

  • Share the results of our analysis
  • Explain how this impacts organizations with audit
  • versight responsibilities

Page 8 WWW.APA.VIRGINIA.GOV

slide-9
SLIDE 9

Step 1 - Access the Federal Audit Clearinghouse

Page 9 WWW.APA.VIRGINIA.GOV

https://harvester.census.gov/sac/

slide-10
SLIDE 10

Step 2 – Select Federal Audit Clearinghouse IDDS

Page 10 WWW.APA.VIRGINIA.GOV

slide-11
SLIDE 11

Step 3 – Download Single Audit data

Page 11 WWW.APA.VIRGINIA.GOV

slide-12
SLIDE 12

Step 4 – Download Single Audit data set

Page 12 WWW.APA.VIRGINIA.GOV

slide-13
SLIDE 13

Step 5 – Obtain Single Audit Field Definition List

Page 13 WWW.APA.VIRGINIA.GOV

slide-14
SLIDE 14

Step 6 – Obtain local government listing

Page 14 WWW.APA.VIRGINIA.GOV

slide-15
SLIDE 15

Step 6 – Import data into Access

Page 15 WWW.APA.VIRGINIA.GOV

slide-16
SLIDE 16

Step 7 – Limit data by creating a join

Page 16 WWW.APA.VIRGINIA.GOV

slide-17
SLIDE 17

Page 17 WWW.APA.VIRGINIA.GOV

slide-18
SLIDE 18

Learning Objectives

  • Provide overview of APA’s audit oversight

responsibilities

  • Demonstrate how to obtain data from the Federal

Audit Clearinghouse

  • Demonstrate how to analyze data from the

Federal Audit Clearinghouse

  • Share the results of our analysis
  • Explain how this impacts organizations with audit
  • versight responsibilities

Page 18 WWW.APA.VIRGINIA.GOV

slide-19
SLIDE 19

Objectives of Analysis

  • To identify potential:

– Miscalculated Type A thresholds – Missed Type A programs – Improper percent of coverage – Improper auditee risk determinations

Page 19 WWW.APA.VIRGINIA.GOV

slide-20
SLIDE 20

Overview of analysis – broad steps

  • Step 1 – Limit data within Access
  • Step 2 – Export to Excel and perform analysis
  • Step 3 – Evaluate results using audit reports

Page 20 WWW.APA.VIRGINIA.GOV

slide-21
SLIDE 21

Example 1 – Recalculate Type A Thresholds

  • Step 1 – Limit data within Access
  • Step 2 – Export to Excel and analyze

Page 21 WWW.APA.VIRGINIA.GOV

slide-22
SLIDE 22

Obtain total federal expenditures and Type A threshold

Page 22 WWW.APA.VIRGINIA.GOV

slide-23
SLIDE 23

Example 1 – Recalculate Type A Thresholds

  • Step 1 – Limit data within Access
  • Step 2 – Export to Excel and analyze

Page 23 WWW.APA.VIRGINIA.GOV

slide-24
SLIDE 24

Determine local government’s “expenditure tier”

Page 24 WWW.APA.VIRGINIA.GOV

=IF(AND(E2>300000,E2<=100000000),"Tier 1",IF(AND(E2>=100000000,E2<=10000000000 ),"Tier 2","Tier3"))

slide-25
SLIDE 25

Recalculate Type A threshold

Page 25 WWW.APA.VIRGINIA.GOV

=ROUNDUP(IF(AND(G2="Tier 3",(E2*0.0015)>30000000),E2*0.0015,IF(AND(G2="Tier 3",(E2*0.0015)<30000000),30000000,IF(G2="Tier 2",IF((E2*0.003)<3000000,3000000,E2*0.003),IF(AND(G2 ="Tier 1",(E2*0.03)>300000),E2*0.03,300000)))),0)

slide-26
SLIDE 26

Example 2 – Missed Type A Programs

  • Step 1 – Limit data within Access
  • Step 2 – Export to Excel and analyze

Page 26 WWW.APA.VIRGINIA.GOV

slide-27
SLIDE 27

Obtain auditee’s SEFA

Page 27 WWW.APA.VIRGINIA.GOV

slide-28
SLIDE 28

Obtain prior year federal findings

Page 28 WWW.APA.VIRGINIA.GOV

slide-29
SLIDE 29

Determine 2012 and 2013 major programs

Page 29 WWW.APA.VIRGINIA.GOV

slide-30
SLIDE 30

Determine 2014 major programs

Page 30 WWW.APA.VIRGINIA.GOV

slide-31
SLIDE 31

Example 2 – Missed Type A Programs

  • Step 1 – Limit data within Access
  • Step 2 – Export to Excel and analyze

Page 31 WWW.APA.VIRGINIA.GOV

slide-32
SLIDE 32

Obtain cluster listing from Circular A-133

Page 32 WWW.APA.VIRGINIA.GOV

slide-33
SLIDE 33

Determine if program is part of a cluster

Page 33 WWW.APA.VIRGINIA.GOV

=IFERROR(IF(D2="Y","Research and Development Cluster",VLOOKUP(C2,'Part 5 - Clusters'!B:C,2,FALSE)),C2)

slide-34
SLIDE 34

Determine federal expenditures by cluster

Page 34 WWW.APA.VIRGINIA.GOV

slide-35
SLIDE 35

Determine Type A programs

Page 35 WWW.APA.VIRGINIA.GOV

=IF(I2>=J2,"Yes","No")

slide-36
SLIDE 36

Was there a prior year federal finding?

Page 36 WWW.APA.VIRGINIA.GOV

slide-37
SLIDE 37

When was the program last audited?

Page 37 WWW.APA.VIRGINIA.GOV

slide-38
SLIDE 38

High risk Type A – prior year finding

Page 38 WWW.APA.VIRGINIA.GOV

=IF(K2="No","Not Type A",IF(AND(K2="Yes",M2="Yes"),"Yes","No"))

slide-39
SLIDE 39

High risk Type A – two year lookback?

Page 39 WWW.APA.VIRGINIA.GOV

=IF(K2="No","Not Type A",IF(AND(K2="Yes",(2014-N2>=3)),"Yes","No"))

slide-40
SLIDE 40

High risk Type A program?

Page 40 WWW.APA.VIRGINIA.GOV

=IF(K2="No","Not Type A",IF(OR(O2="Yes",P2="Yes"),"Yes","No"))

slide-41
SLIDE 41

Was high risk Type A audited?

Page 41 WWW.APA.VIRGINIA.GOV

=IF(K2="No","Not Type A",IF(AND(Q2="Yes",R2="No"),"Yes","No"))

slide-42
SLIDE 42

Learning Objectives

  • Provide overview of APA’s audit oversight

responsibilities

  • Demonstrate how to obtain data from the Federal

Audit Clearinghouse

  • Demonstrate how to analyze data from the

Federal Audit Clearinghouse

  • Share the results of our analysis
  • Explain how this impacts organizations with audit
  • versight responsibilities

Page 42 WWW.APA.VIRGINIA.GOV

slide-43
SLIDE 43

Results of analysis

  • 7 audits with deficiencies

– 2 missed high-risk Type A programs – 3 instances where the audit results were misreported in the Schedule of Findings and Questioned Costs – 2 instances where auditee risk was incorrect and sufficient audit coverage was not achieved

  • Auditors agreed to perform additional procedures

to correct audit deficiencies

Page 43 WWW.APA.VIRGINIA.GOV

slide-44
SLIDE 44

Learning Objectives

  • Provide overview of APA’s audit oversight

responsibilities

  • Demonstrate how to obtain data from the Federal

Audit Clearinghouse

  • Demonstrate how to analyze data from the

Federal Audit Clearinghouse

  • Share the results of our analysis
  • Explain how this impacts organizations with

audit oversight responsibilities

Page 44 WWW.APA.VIRGINIA.GOV

slide-45
SLIDE 45

How does the effect you?

Page 45 WWW.APA.VIRGINIA.GOV

35.5 percent of Single Audits were unacceptable

slide-46
SLIDE 46

How does this effect you?

  • National Single Audit Sampling Project will be

conducted in 2018 : – Performed once every six years – Assess work performed by non-federal auditors

  • Analyzing FAC data can provide insight to pinpoint

audit deficiencies and allow for timely resolution

Page 46 WWW.APA.VIRGINIA.GOV

slide-47
SLIDE 47

Quote

“The goal is to turn data into information, and information into insight”

  • Carly Fiorina, Former CEO of HP

Page 47 WWW.APA.VIRGINIA.GOV

slide-48
SLIDE 48

Questions?

Page 48 WWW.APA.VIRGINIA.GOV

slide-49
SLIDE 49

Page 49 WWW.APA.VIRGINIA.GOV

Thank you and safe travels!