Finding 404914 (2023-001)

Material Weakness
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-07-01

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) was not properly reconciled with federal grant revenues and expenditures, leading to material misstatements.
  • Impacted Requirements: Compliance with CFR sections 200.303(B), 200.502(A), and 200.510(B) regarding internal controls and accurate reporting of federal awards was not met.
  • Recommended Follow-Up: The Health Department should regularly track federal awards and ensure timely reconciliation with the general ledger to prevent future discrepancies.

Finding Text

PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (REPORTING, CASH MANAGEMENT AND ALLOWABLE COSTS/COST PRINCIPLES. PROGRAMS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.557; AWARD NUMBERS 50022 AND 50035, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; AWARD NUMBER 251126, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: THE CODE OF FEDERAL REGULATIONS (CFR) SECTION 200.303(B) REQUIRES NON-FEDERAL ENTITIES TO ESTABLISH AND MAINTAIN EFFECTIVE INTERNAL CONTROL OVER THE FEDERAL AWARD THAT PROVIDES REASONABLE ASSURANCE THAT THE NON-FEDERAL ENTITY IS MANAGING BY THE FEDERAL AWARD IN COMPLIANCE WITH FEDERAL STATUTES, REGULATIONS, AND TERMS AND CONDITIONS OF THE FEDERAL AWARD. CFR SECTION 200.502(A) STATES THAT THE DETERMINATION OF WHEN A FEDERAL AWARD IS EXPENDED SHOULD BE BASED ON WHEN THE ACTIVITY RELATED TO THE FEDERAL AWARD OCCURS. GENERALLY, THE ACTIVITY PERTAINS TO EVENTS THAT REQUIRE THE NON-FEDERAL ENTITY TO COMPLY WITH FEDERAL STATUTES, REGULATIONS, AND THE TERMS AND CONDITIONS OF FEDERAL AWARDS, SUCH AS EXPENDITURE/EXPENSE TRANSACTIONS ASSOCIATED WITH GRANT AWARDS. THE HEALTH DEPARTMENT REPORTS EXPENDITURES ON THE SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA FOR THE PERIOD COVERED BY THE AUDITEE'S FINANCIAL STATEMENTS WHICH MUST INCLUDE TH TOTAL FEDERAL AWARDS EXPENDED AS DETERMINED IN ACCORANCE WITH CRF SECTION 200.502(A), AS STATED ABOVE, AND MUST RECONCILE AMOUNTS REPORTED IN THE SEFA TO THE AMOUNTS REPORTED IN THE AUDITEEE'S FINANCIAL STATEMENTS. CONDITION: THE SEFA WAS NOT APPROPRIATELY RECONCILED TO THE FEDERAL GRANT REVENUES AND EXPENDITURES RECORDED IN THE FINANCIAL STATEMENTS. CHANGES WERE MADE TO MAJOR PROGRAM EXPENDITURES, AS WELL AS EXPENDITURES OF OTHR PROGRAMS DURING THE CLOSING PROCESS AND DURING COMPLETION OF THE SINGLE AUDIT TO PROPERLY REPORT EXPENDITURES ON THE SEFA. CLOSING PROCEDURES SHOULD BE IN PLACE TO RECONCILE GRANT EXPENDITURES INCURRED AT YEAR-END, CONFIRM THE AMOUNT AS ELIGIBLE WITH THE GRANTOR, CLAIM THE GRANT REVENUES ON A TIMELY BASIS, RECONCILE THE CLAIM TO THE GENERAL LEDGER, AND ENSURE THE EXPENDITURES THAT WILL BE CLAIMED UNDER FEDERAL AWARDS ARE PROPERTLY REPORTED ON THE SEFA AND AUDITED FINANCIAL STATEMENTS PRIOR TO THE START OF THE SINGLE AUDIT. IF EXPENDITURES REPORTED ON THE SEFA ARE MISSTATED, THE COUNTY COULD FAIL TO HAVE A PROGRAM APPROPRIATELY INDENTIFIED AS A MAJOR PROGRAM AND TESTED AS A MAJOR PROGRAM DURING THE SINGLE AUDIT. FAILURE TO HAVE A PROGRAM AUDITED DURING THE SINGLE AUDIT WOULD RESULT IN NONCOMPLIANCE WITH TITLE 2 U.S. CODE OF FEDERAL REGULATIONS PART 200, UNIFORM ADMINISTRATIVE REQUIREMENTS, COST PRINCIPLES, AND AUDIT REQUIREMENTS FOR FEDERAL AWARDS (UNIFORM GUIDANCE). CAUSE: THE WAS THE HEALTH DEPARTMENT'S FIRST STANDALONE AUDIT AND MANAGEMENT HAD NOT PREPARED A SEFA IN THE PAST. EFFECT: THE SEFA RQUIRED MATERIAL ADJUSTMENTS TO INCLUDE ALL FEDERAL EXPENDITURES PRIOR TO THE SINGLE AUDIT BEGINNING, WHICH RESULTED IN A MISSTATED PRELIMINARY SEFA AND INEFFICIENCIES DURING THE SINGLE AUDIT. QUESTIONED COSTS: NO COSTS HAVE BEEN QUESTIONED AS A RESULT OF THIS FINDING. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT TRACT THEIR FEDERAL AWARDS MORE REGULARLY AND RECONCILE IT TO THE GENERAL LEDGER. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMENT WILL REVISIT THEIR PROCEDURES AND METHOD OF FEDERAL AWARDS.

Categories

Reporting Allowable Costs / Cost Principles

Other Findings in this Audit

  • 404910 2023-001
    Material Weakness
  • 404911 2023-001
    Material Weakness
  • 404912 2023-001
    Material Weakness
  • 404913 2023-001
    Material Weakness
  • 404915 2023-001
    Material Weakness
  • 404916 2023-001
    Material Weakness
  • 404917 2023-001
    Material Weakness
  • 404918 2023-002
    Material Weakness
  • 404919 2023-002
    Material Weakness
  • 404920 2023-002
    Material Weakness
  • 404921 2023-002
    Material Weakness
  • 404922 2023-002
    Material Weakness
  • 404923 2023-002
    Material Weakness
  • 404924 2023-002
    Material Weakness
  • 404925 2023-002
    Material Weakness
  • 981352 2023-001
    Material Weakness
  • 981353 2023-001
    Material Weakness
  • 981354 2023-001
    Material Weakness
  • 981355 2023-001
    Material Weakness
  • 981356 2023-001
    Material Weakness
  • 981357 2023-001
    Material Weakness
  • 981358 2023-001
    Material Weakness
  • 981359 2023-001
    Material Weakness
  • 981360 2023-002
    Material Weakness
  • 981361 2023-002
    Material Weakness
  • 981362 2023-002
    Material Weakness
  • 981363 2023-002
    Material Weakness
  • 981364 2023-002
    Material Weakness
  • 981365 2023-002
    Material Weakness
  • 981366 2023-002
    Material Weakness
  • 981367 2023-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $66,847
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $49,951
93.788 Opioid Str $42,065
93.235 Affordable Care Act (aca) Abstinence Education Program $29,084
93.069 Public Health Emergency Preparedness $17,989
93.217 Family Planning_services $7,673
93.917 Hiv Care Formula Grants $4,906
93.994 Maternal and Child Health Services Block Grant to the States $4,597
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $3,169
93.268 Immunization Cooperative Agreements $2,887
66.468 Capitalization Grants for Drinking Water State Revolving Funds $1,469
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $469
93.778 Medical Assistance Program $403