Audit 328076

FY End
2023-12-31
Total Expended
$1.65M
Findings
2
Programs
21
Organization: Douglas County (IL)
Year: 2023 Accepted: 2024-11-12

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
505399 2023-003 Material Weakness - L
1081841 2023-003 Material Weakness - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $876,406 Yes 1
20.509 Formula Grants for Rural Areas and Tribal Transit Program $137,000 - 0
93.268 Immunization Cooperative Agreements $96,169 - 0
93.994 Maternal and Child Health Services Block Grant to the States $75,000 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $51,026 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $39,416 - 0
10.559 Summer Food Service Program for Children $34,265 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $28,658 - 0
93.332 Cooperative Agreement to Support Navigators in Federally-Facilitated Exchanges $24,585 - 0
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $23,734 - 0
93.069 Public Health Emergency Preparedness $17,312 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $16,204 - 0
93.332 Cdc Partnership: Strengthening Public Health Laboratories $12,154 - 0
93.008 Medical Reserve Corps Small Grant Program $10,048 - 0
93.667 Social Services Block Grant $7,465 - 0
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $7,238 - 0
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $5,751 - 0
97.042 Emergency Management Performance Grants $4,293 - 0
93.788 Opioid Str $2,961 - 0
93.940 Hiv Prevention Activities Health Department Based $2,204 - 0
66.605 Performance Partnership Grants $138 - 0

Contacts

Name Title Type
U12XLNWN75F6 Judi Pollock Auditee
2172532411 Curtis Root Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Revenue from federal awards is recognized when the County receives the cash. Expenditures of federal awards are recognized in the accounting period when the cash is paid. De Minimis Rate Used: N Rate Explanation: Douglas County has elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance for the following grant: Immunization Cooperative Agreements-COVID Mass Vaccination- 93.268. The accompanying schedule of expenditures of federal awards is prepared on the modified cash basis method of accounting which is a comprehensive basis of accounting other than accounting principles generally accepted in the United States of America.
Title: Non-Cash Assistance Accounting Policies: Revenue from federal awards is recognized when the County receives the cash. Expenditures of federal awards are recognized in the accounting period when the cash is paid. De Minimis Rate Used: N Rate Explanation: Douglas County has elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance for the following grant: Immunization Cooperative Agreements-COVID Mass Vaccination- 93.268. Douglas County did not receive any non-cash awards.
Title: Insurance In Effect, Loans, and Guarantees Accounting Policies: Revenue from federal awards is recognized when the County receives the cash. Expenditures of federal awards are recognized in the accounting period when the cash is paid. De Minimis Rate Used: N Rate Explanation: Douglas County has elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance for the following grant: Immunization Cooperative Agreements-COVID Mass Vaccination- 93.268. Douglas County did not receive any federal awards in the form of non-cash assistance for insurance in effect during the year, loans, or guarantees.

Finding Details

2023SA-003 Insufficient Grant Monitoring Federal Agency/Passthrough Agency: US Department of Treasury Program: Coronavirus State and Local Fiscal Recovery Fund- American Rescue Plan Act Federal Award Number: N/A Assistance Listing Number: 21.027 Material Weakness Material Noncompliance – Financial Management Criteria: 2 CFR 200.302 states that the Grantee must have an accounting system that provides accurate, current, and complete disclosure of all financial transactions related to each state and federally funded program. Accounting records must contain information pertaining to state and federal pass-through awards, authorizations, obligations, unobligated balances, assets, outlays, and income. The records must be maintained on a current basis and balances at least quarterly. Condition: The accounting records for the ARPA grant included $328,600 of expenses that were not reported on the annual grant report filed in March 2024. Context: From reviews of the County’s internal control and accounting procedures along with inquiries made, it was indicated that there was a high probability that transactions were not reported correctly. There is no review process in place. Effect: Inaccurate reporting of grant activity. Questioned Costs: None. Cause: There is a systematic problem with lack of adequate documentation and monitoring of expenses paid for with grant funds throughout the County. The County needs to be able to compile a complete list of grants for the entire County and monitor that the grant activity is property reported. The County needs to have a better understanding of grant reporting requirements, grant restrictions, and compliance requirements. Repeated Finding: No Recommendation: The County should have someone review grant reports prior to their submission. Management’s Response: The County will work to improve grant documentation and will consider implementing a review process to ensure the grant records agree to grant reports that are filed.
2023SA-003 Insufficient Grant Monitoring Federal Agency/Passthrough Agency: US Department of Treasury Program: Coronavirus State and Local Fiscal Recovery Fund- American Rescue Plan Act Federal Award Number: N/A Assistance Listing Number: 21.027 Material Weakness Material Noncompliance – Financial Management Criteria: 2 CFR 200.302 states that the Grantee must have an accounting system that provides accurate, current, and complete disclosure of all financial transactions related to each state and federally funded program. Accounting records must contain information pertaining to state and federal pass-through awards, authorizations, obligations, unobligated balances, assets, outlays, and income. The records must be maintained on a current basis and balances at least quarterly. Condition: The accounting records for the ARPA grant included $328,600 of expenses that were not reported on the annual grant report filed in March 2024. Context: From reviews of the County’s internal control and accounting procedures along with inquiries made, it was indicated that there was a high probability that transactions were not reported correctly. There is no review process in place. Effect: Inaccurate reporting of grant activity. Questioned Costs: None. Cause: There is a systematic problem with lack of adequate documentation and monitoring of expenses paid for with grant funds throughout the County. The County needs to be able to compile a complete list of grants for the entire County and monitor that the grant activity is property reported. The County needs to have a better understanding of grant reporting requirements, grant restrictions, and compliance requirements. Repeated Finding: No Recommendation: The County should have someone review grant reports prior to their submission. Management’s Response: The County will work to improve grant documentation and will consider implementing a review process to ensure the grant records agree to grant reports that are filed.