190 likes | 272 Views
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
E N D
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
Federal Government Compared to Pass-throughs • Who are Pass-throughs, what they do and Provide • Dollars Awarded • Number of Grants • Single Audits to Review
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.
Q: What Do Pass-throughs Do? A: Step into the shoes of the Federal Government What did we get into? The Feds
How Does the Math Work? Mixed Feds Pass-throughs 25,910 26,364
How Does the Math Work? Mixed Feds Pass-throughs 38% 30% 32% 37,864
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
Pass-throughs’ A State’s Perspective Equal Tools for Equal Work