Audit 311309

FY End
2023-12-31
Total Expended
$1.60M
Findings
32
Programs
13
Organization: District Health Department No 4 (MI)
Year: 2023 Accepted: 2024-07-01

Organization Exclusion Status:

Checking exclusion status...

Findings

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

Contacts

Name Title Type
Z55UP6LJNX58 Jerry Hillis Auditee
9893587955 Kristy L Schulze Auditor
No contacts on file

Notes to SEFA

Title: NOTE 1 BASIS OF PRESENTATION Accounting Policies: The Schedule of Expenditures of Federal Awards is reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts (if any) shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: District Health Department No. 4 did not elect to use a flat de minimis rate of 10% of modified total direct costs for their direct cost rate. THE ACCOMPANYING SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (THE SCHEDULE) INCLUDES THE FEDERAL AWARD ACTIVITY OF THE DISTRICT HEALTH DEPARTMENT NO. 4 UNDER PROGRAMS OF THE FEDERAL GOVERNMENT FOR THE YEAR ENDED DECEMBER 31, 2023. THE INFORMATION IN THIS SCHEDULE IS PRESENTED IN ACCORDANCE WITH THE REQUIREMENTS OF TITLE 2 U.S. CODE OF FEDERAL REGULATIONS PART 200, UNIFORM ADMINISTRATIVE REQUIREMENTS, COST PRINCIPLES, AND AUDIT REQUIREMENTS OF FEDERAL AWARDS (UNIFORM GUIDANCE). BECAUSE THE SCHEDULE PRESENTS ONLY A SELECTED PORTION OF THE OPERATIONS OF THE DISTRICT HEALTH DEPARTMENT NO. 4, IT IS NOT INTENDED TO AND DOES NOT PRESENT THE FINANCIAL POSITION, CHANGES IN NET ASSETS, OR CASH FLOWS OF THE DISTRICT HEALTH DEPARTMENT NO. 4.
Title: NOTE 3 SUBRECIPIENTS Accounting Policies: The Schedule of Expenditures of Federal Awards is reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts (if any) shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: District Health Department No. 4 did not elect to use a flat de minimis rate of 10% of modified total direct costs for their direct cost rate. NO FEDERAL AWARDS WERE PASSED THROUGH BY THE DEPARTMENT TO ANY SUBRECIPIENTS DURING THE YEAR.
Title: NOTE 4 SUMMARY OF SIGNIFICANT EXPLANATIONS OF SCHEDULE Accounting Policies: The Schedule of Expenditures of Federal Awards is reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts (if any) shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: District Health Department No. 4 did not elect to use a flat de minimis rate of 10% of modified total direct costs for their direct cost rate. THE FOLLOWING DESCRIPTIONS IDENTIFIED BELOW AS (A) - (D) REPRESENT EXPLANATIONS THAT CROSS REFERENCE TO AMOUNTS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS: A. REIMBURSEMENTS OF THIS CONTRACT ARE PASSED THROUGH THE STATE. THE AMOUNT REPORTED ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS REPRESENTS THE PORTION OF THE GRANT THAT IS CONSIDERED FEDERAL. B. DENOTES PROGRAM TESTED AS "MAJOR PROGRAM". C. DENOTES PROGRAM REQUIRED TO BE CLUSTERED BY UNITES STATES ENVIRONMENTAL PROTECTION AGENCY. D. DENOTES PROGRAM REQUIRED TO BE CLUSTERED BY UNITED STATES DEPARTMENT OF HEALTH AND HUMAN SERVICES.

Finding Details

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.
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.
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.
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.
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.
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.
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.
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.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
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.
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.
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.
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.
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.
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.
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.
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.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.
GRANT REPORTING-WAGES AND FRINGE BENEFIT COSTS & GENERAL EXPENDITURES: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (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 251156, PASSED THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: A RECIPIENT OF FEDERAL AWARDS IS REQUIRED TO SUBSTANTIATE ELIGIBLE COSTS FOR FEDERAL PROGRAMS. IN THE CASE OF THE HEALTH DEPARTMENT WAGES AND FRINGE BENEFIT COSTS AND GENERAL EXPENDITURES, THE GENERAL LEDGER WAS NOT UPDATED TO ALLOCATE EXPENSES ACCURATELY FOR EACH PROGRAM. CONDITION: AS PART OF ITS RECORD KEEPING PROCESS THE HEALTH DEPARTMENT COULD NOT PROVIDE APPROPRIATE SOURCE INFORMATION TO SUBSTANTIATE THE ELIGIBLE COSTS ALLOCATED TO EACH PROGRAM. CAUSE: THE CONDITION APPEARS TO HAVE BEEN CAUSED BY NOT COMPARING ELIGIBLE COSTS, PER THE HEALTH DEPARTMENT'S GENERAL LEDGER TO SOURCE INFORMATION. EFFECT: AS A RESULT OF THIS CONDITION, THE HEALTH DEPARTMENT MISSTATED THE AMOUNTS INCLUDED IN GRANT REPORTS BY AMOUNTS THAT WERE MATERIAL TO THE GRANT PROGRAM. THIS MISREPORTING CAUSES THE HEALTH DEPARTMENT TO RECEIVE INACCURATE ALLOCATIONS. QUESTIONED COSTS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.5547; 17 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; 21 WAGES AND FRINGE BENEFIT EXPENDITURE SELECTIONS OF 25 WERE NOT SUBSTANTIATED AND 13 GENERAL EXPENDITURES SELECTIONS OF 25 WERE NOT SUBSTANTIATED. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT UPDATE THEIR PROCEDURES FOR FEDERAL AWARDS. THE HEALTH DEPARTMENT'S GENERAL LEDGER SHOULD BE REVIEWED FOR HOW ELIGIBLE COSTS ARE ALLOCATED. AN UPDATED SYSTEM OF RECORDS SHOULD BE AVAILABLE FOR SOURCE INFORMATION FOR ELIGIBLE COSTS. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMET WILL REVISIT THEIR PROCEDURES AND METHOD OF ASSEMBLING SOURCE INFORMATION.