1 / 19

Interactive Single Audit Database: A State’s Perspective on Pass-Through Entities

Join George D. Strudgeon, CPA, Audit Director of the Auditor of Public Accounts in Virginia, for an informative session focused on understanding pass-through entities from the perspective of state audits. This presentation will cover what pass-throughs are, their roles, the amount of funding and grants awarded, and how to analyze their impact using the Federal Audit Clearinghouse. Learn to navigate these audits with practical Excel techniques, including pivot tables and IF.THEN functions, to create meaningful reports and insights.

gelilah
Download Presentation

Interactive Single Audit Database: A State’s Perspective on Pass-Through Entities

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