1 / 19

Creating an Interactive Single Audit Database a State’s Perspective

Creating an Interactive Single Audit Database a State’s Perspective. Pass-throughs’. Association of Government Accountants Central PA Chapter in Harrisburg Hearing Room 1 of the Keystone Building 11:00 a.m. – 11:50 a.m. February 9, 2011. George D. Strudgeon, CPA

stephen-ochoa
Download Presentation

Creating an Interactive Single Audit Database a State’s Perspective

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Creating an Interactive Single Audit Databasea State’s Perspective Pass-throughs’ Association of Government Accountants Central PA Chapter in Harrisburg Hearing Room 1 of the Keystone Building 11:00 a.m. – 11:50 a.m. February 9, 2011 George D. Strudgeon, CPA Audit Director, Auditor of Public Accounts Richmond, Virginia George.Strudgeon@apa.virginia.gov

  2. Federal Government Compared to Pass-throughs • Who are Pass-throughs, what they do and Provide • Dollars Awarded • Number of Grants • Single Audits to Review

  3. Federal Audit Clearinghouse: http://harvester.census.gov/sac/ • Instructions and screenshots showing how to pull information from the FAC and recreate amounts in this report using: Excel, pivot tables, and the IF THEN function.

  4. Interactive FAC

  5. Q: What Do Pass-throughs Do? A: Step into the shoes of the Federal Government What did we get into? The Feds

  6. Feds vs. Pass-throughs

  7. Dollars Awarded .

  8. Number of Grants .

  9. Why Pass-throughs Have More Grants (Virginia Examples)

  10. Number of Grants from the prior slide’s examples

  11. Number of Grantees to Monitor

  12. How Does the Math Work? Mixed Feds Pass-throughs 25,910 26,364

  13. How Does the Math Work? Mixed Feds Pass-throughs 38% 30% 32% 37,864

  14. Recap - Pictures

  15. Recap - Words • Non-Federal Entities, that are responsible for protecting Federal funds just like the Feds • For every $1.00 the federal government awards, $0.15 is awarded by pass-throughs • For every 5grants the federal government makes, pass-throughs make 8 • 32% of the Single Audits in the FAC, the Feds do not need to review or make management decisions

  16. Pass-throughs’ A State’s Perspective Equal Tools for Equal Work

More Related