Finding Reference Number: 2022-002 NH Department of Administrative Services Federal Transit Cluster and COVID-19 Federal Transit Cluster (Assistance Listing #20.507and #20.526) Airport Improvement Program and COVID-19 Airport Improvement Program (Assistance Listing #20.106) COVID-19 Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing #21.027) Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) and COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing #93.323) Temporary Assistance for Needy Families and COVID-19 Temporary Assistance for Needy Families (Assistance Listing #93.558) Federal Award Numbers 2020G996115, 2021G996115, SLFRP0145, NUK50CK000522, 2001NHLEA, 2001NHLIE4, 2001NH5C3, 2101NHLIEA, 2101NHE5C6, 2201NHLIEA, 2101NHLIE4, 2021G996115, 2021G990228, 2022G996115 Federal Award Year: 2019, 2020, 2021 U.S. Department of Transportation, U.S. Department of Treasury, U.S. Department of Health and Human Services Type of Finding: Significant Deficiency Prior Year Finding: None Statistically Valid Sample: No Criteria Title 2 U.S. Code of Federal Regulations Part 200 (2 CFR section 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements, section 200.510(b) states the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. Additionally, per 2 CFR section 200.303, non-federal entities must establish and maintain effective internal control over federal awards that provide reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition The State of New Hampshire (the State) entered into contracts and subrecipient grant agreements to assist with the administration of its federal awards. As part of the Schedule of Expenditures of Federal Awards (SEFA) preparation process, the Department of Administrative Services requested information from each Department related to federal expenditures made by federal program and the portion of those expenditures that were passed through to subrecipients. For the year ended June 30, 2022, the State reported approximately $3.5 billion in federal expenditures on the SEFA. Of the total expenditures reported, approximately $783 million was reported as amounts passed through to subrecipients. During our audit, we identified several instances where the State inaccurately reported the value of the amounts passed through to subrecipients for certain federal programs. Specifically, we noted the following: A. Federal Transit Cluster - The State reported subrecipient expenditures in the amount of $4,038,163 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over procurement, we noted that 1 of 4 contracts selected for testwork was incorrectly identified as a contract. Upon further review and inquiry of management, the actual subrecipient expenditures for the year ended June 30, 2022 were $375,302, resulting in an overstatement of $3,662,861. This error was subsequently corrected on the final SEFA. B. Airport Improvement Program - The State reported subrecipient expenditures in the amount of $8,275,240 on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $8,168,301, resulting in an overstatement of $106,939. This error was subsequently corrected on the final SEFA. C. Coronavirus State and Local Fiscal Recovery Funds ? The State reported subrecipient expenditures in the amount of $7,435,217 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over subrecipient monitoring, we noted that for 5 of 10 subrecipients selected for testwork that the sample selection had been incorrectly identified as a subrecipient, resulting in an overstatement of $5,326,620. We further noted as part of our testwork over procurement, that 18 of 48 contracts selected for testwork had incorrectly been identified as a contract and instead of a subrecipient grant agreement. There were no expenditures associated with these agreements, and as a result, there was no impact on the amount reported on the SEFA within the amounts provided to subrecipients column. The error was subsequently corrected on the final SEFA to properly present $2,108,597 as passed through to subrecipient. D. Epidemiology and Laboratory Capacity for Infectious Diseases - The State reported subrecipient expenditures in the amount of $4,879,473 on the draft SEFA within the amounts provided to subrecipients column. During our testwork related to FFATA reporting, we noted that 1 of 4 items selected for testwork did not represent a tier-one award but instead was a contract. The impact on the amount reported on the SEFA within the amounts provided to subrecipients column was an overstatement of $8,400. The error was subsequently corrected on the final SEFA to properly present $4,871,073 as passed through to subrecipient. E. Temporary Assistance for Needy Families - The State did not report any subrecipient expenditures on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $3,307,974, resulting in an understatement of $3,307,974. This error was subsequently corrected on the final SEFA. Cause The cause of the condition found is primarily due to insufficient controls related to the determination of vendor versus subrecipient to ensure the proper identification of subrecipients. Effect The effect of the condition found is that subrecipient expenditures were not accurately presented on the SEFA. Questioned Costs None. Recommendation We recommend that the State review its existing statewide internal controls over vendor versus subrecipient determination to ensure they are operating effectively to properly identify a vendor versus a subrecipient. This will ensure that the amounts presented as pass through as subrecipient expenditures on the SEFA are complete and accurate. Views of Responsible Officials The Department of Administrative Services (DAS) concurs. Financial management of individual federal awards is decentralized throughout state agencies which centralizes annually in the culmination of the State?s SEFA. During this process, each agency is required to complete a standardized SEFA analysis and reconciliation tool for review by the DAS prior to the incorporation of the data into the State?s SEFA. This process also includes an annual Single Audit training and update session organized by the DAS. Additionally, the DAS notes all contracts, including subawards, entered by state agencies over a designated threshold are required to be authorized by the State?s Legislative Fiscal Committee and the Governor and Executive Council. The DAS will examine each of these processes to identify additional control activities to improve the accuracy and completeness of the pass through element of the SEFA. Anticipated Completion Date: April 30, 2024 Contact: Steven Giovinelli, Federal Grants and Cost Allocation Administrator, Department of Administrative Services
Finding Reference Number: 2022-002 NH Department of Administrative Services Federal Transit Cluster and COVID-19 Federal Transit Cluster (Assistance Listing #20.507and #20.526) Airport Improvement Program and COVID-19 Airport Improvement Program (Assistance Listing #20.106) COVID-19 Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing #21.027) Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) and COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing #93.323) Temporary Assistance for Needy Families and COVID-19 Temporary Assistance for Needy Families (Assistance Listing #93.558) Federal Award Numbers 2020G996115, 2021G996115, SLFRP0145, NUK50CK000522, 2001NHLEA, 2001NHLIE4, 2001NH5C3, 2101NHLIEA, 2101NHE5C6, 2201NHLIEA, 2101NHLIE4, 2021G996115, 2021G990228, 2022G996115 Federal Award Year: 2019, 2020, 2021 U.S. Department of Transportation, U.S. Department of Treasury, U.S. Department of Health and Human Services Type of Finding: Significant Deficiency Prior Year Finding: None Statistically Valid Sample: No Criteria Title 2 U.S. Code of Federal Regulations Part 200 (2 CFR section 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements, section 200.510(b) states the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. Additionally, per 2 CFR section 200.303, non-federal entities must establish and maintain effective internal control over federal awards that provide reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition The State of New Hampshire (the State) entered into contracts and subrecipient grant agreements to assist with the administration of its federal awards. As part of the Schedule of Expenditures of Federal Awards (SEFA) preparation process, the Department of Administrative Services requested information from each Department related to federal expenditures made by federal program and the portion of those expenditures that were passed through to subrecipients. For the year ended June 30, 2022, the State reported approximately $3.5 billion in federal expenditures on the SEFA. Of the total expenditures reported, approximately $783 million was reported as amounts passed through to subrecipients. During our audit, we identified several instances where the State inaccurately reported the value of the amounts passed through to subrecipients for certain federal programs. Specifically, we noted the following: A. Federal Transit Cluster - The State reported subrecipient expenditures in the amount of $4,038,163 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over procurement, we noted that 1 of 4 contracts selected for testwork was incorrectly identified as a contract. Upon further review and inquiry of management, the actual subrecipient expenditures for the year ended June 30, 2022 were $375,302, resulting in an overstatement of $3,662,861. This error was subsequently corrected on the final SEFA. B. Airport Improvement Program - The State reported subrecipient expenditures in the amount of $8,275,240 on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $8,168,301, resulting in an overstatement of $106,939. This error was subsequently corrected on the final SEFA. C. Coronavirus State and Local Fiscal Recovery Funds ? The State reported subrecipient expenditures in the amount of $7,435,217 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over subrecipient monitoring, we noted that for 5 of 10 subrecipients selected for testwork that the sample selection had been incorrectly identified as a subrecipient, resulting in an overstatement of $5,326,620. We further noted as part of our testwork over procurement, that 18 of 48 contracts selected for testwork had incorrectly been identified as a contract and instead of a subrecipient grant agreement. There were no expenditures associated with these agreements, and as a result, there was no impact on the amount reported on the SEFA within the amounts provided to subrecipients column. The error was subsequently corrected on the final SEFA to properly present $2,108,597 as passed through to subrecipient. D. Epidemiology and Laboratory Capacity for Infectious Diseases - The State reported subrecipient expenditures in the amount of $4,879,473 on the draft SEFA within the amounts provided to subrecipients column. During our testwork related to FFATA reporting, we noted that 1 of 4 items selected for testwork did not represent a tier-one award but instead was a contract. The impact on the amount reported on the SEFA within the amounts provided to subrecipients column was an overstatement of $8,400. The error was subsequently corrected on the final SEFA to properly present $4,871,073 as passed through to subrecipient. E. Temporary Assistance for Needy Families - The State did not report any subrecipient expenditures on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $3,307,974, resulting in an understatement of $3,307,974. This error was subsequently corrected on the final SEFA. Cause The cause of the condition found is primarily due to insufficient controls related to the determination of vendor versus subrecipient to ensure the proper identification of subrecipients. Effect The effect of the condition found is that subrecipient expenditures were not accurately presented on the SEFA. Questioned Costs None. Recommendation We recommend that the State review its existing statewide internal controls over vendor versus subrecipient determination to ensure they are operating effectively to properly identify a vendor versus a subrecipient. This will ensure that the amounts presented as pass through as subrecipient expenditures on the SEFA are complete and accurate. Views of Responsible Officials The Department of Administrative Services (DAS) concurs. Financial management of individual federal awards is decentralized throughout state agencies which centralizes annually in the culmination of the State?s SEFA. During this process, each agency is required to complete a standardized SEFA analysis and reconciliation tool for review by the DAS prior to the incorporation of the data into the State?s SEFA. This process also includes an annual Single Audit training and update session organized by the DAS. Additionally, the DAS notes all contracts, including subawards, entered by state agencies over a designated threshold are required to be authorized by the State?s Legislative Fiscal Committee and the Governor and Executive Council. The DAS will examine each of these processes to identify additional control activities to improve the accuracy and completeness of the pass through element of the SEFA. Anticipated Completion Date: April 30, 2024 Contact: Steven Giovinelli, Federal Grants and Cost Allocation Administrator, Department of Administrative Services
Finding Reference Number: 2022-002 NH Department of Administrative Services Federal Transit Cluster and COVID-19 Federal Transit Cluster (Assistance Listing #20.507and #20.526) Airport Improvement Program and COVID-19 Airport Improvement Program (Assistance Listing #20.106) COVID-19 Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing #21.027) Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) and COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing #93.323) Temporary Assistance for Needy Families and COVID-19 Temporary Assistance for Needy Families (Assistance Listing #93.558) Federal Award Numbers 2020G996115, 2021G996115, SLFRP0145, NUK50CK000522, 2001NHLEA, 2001NHLIE4, 2001NH5C3, 2101NHLIEA, 2101NHE5C6, 2201NHLIEA, 2101NHLIE4, 2021G996115, 2021G990228, 2022G996115 Federal Award Year: 2019, 2020, 2021 U.S. Department of Transportation, U.S. Department of Treasury, U.S. Department of Health and Human Services Type of Finding: Significant Deficiency Prior Year Finding: None Statistically Valid Sample: No Criteria Title 2 U.S. Code of Federal Regulations Part 200 (2 CFR section 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements, section 200.510(b) states the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. Additionally, per 2 CFR section 200.303, non-federal entities must establish and maintain effective internal control over federal awards that provide reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition The State of New Hampshire (the State) entered into contracts and subrecipient grant agreements to assist with the administration of its federal awards. As part of the Schedule of Expenditures of Federal Awards (SEFA) preparation process, the Department of Administrative Services requested information from each Department related to federal expenditures made by federal program and the portion of those expenditures that were passed through to subrecipients. For the year ended June 30, 2022, the State reported approximately $3.5 billion in federal expenditures on the SEFA. Of the total expenditures reported, approximately $783 million was reported as amounts passed through to subrecipients. During our audit, we identified several instances where the State inaccurately reported the value of the amounts passed through to subrecipients for certain federal programs. Specifically, we noted the following: A. Federal Transit Cluster - The State reported subrecipient expenditures in the amount of $4,038,163 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over procurement, we noted that 1 of 4 contracts selected for testwork was incorrectly identified as a contract. Upon further review and inquiry of management, the actual subrecipient expenditures for the year ended June 30, 2022 were $375,302, resulting in an overstatement of $3,662,861. This error was subsequently corrected on the final SEFA. B. Airport Improvement Program - The State reported subrecipient expenditures in the amount of $8,275,240 on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $8,168,301, resulting in an overstatement of $106,939. This error was subsequently corrected on the final SEFA. C. Coronavirus State and Local Fiscal Recovery Funds ? The State reported subrecipient expenditures in the amount of $7,435,217 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over subrecipient monitoring, we noted that for 5 of 10 subrecipients selected for testwork that the sample selection had been incorrectly identified as a subrecipient, resulting in an overstatement of $5,326,620. We further noted as part of our testwork over procurement, that 18 of 48 contracts selected for testwork had incorrectly been identified as a contract and instead of a subrecipient grant agreement. There were no expenditures associated with these agreements, and as a result, there was no impact on the amount reported on the SEFA within the amounts provided to subrecipients column. The error was subsequently corrected on the final SEFA to properly present $2,108,597 as passed through to subrecipient. D. Epidemiology and Laboratory Capacity for Infectious Diseases - The State reported subrecipient expenditures in the amount of $4,879,473 on the draft SEFA within the amounts provided to subrecipients column. During our testwork related to FFATA reporting, we noted that 1 of 4 items selected for testwork did not represent a tier-one award but instead was a contract. The impact on the amount reported on the SEFA within the amounts provided to subrecipients column was an overstatement of $8,400. The error was subsequently corrected on the final SEFA to properly present $4,871,073 as passed through to subrecipient. E. Temporary Assistance for Needy Families - The State did not report any subrecipient expenditures on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $3,307,974, resulting in an understatement of $3,307,974. This error was subsequently corrected on the final SEFA. Cause The cause of the condition found is primarily due to insufficient controls related to the determination of vendor versus subrecipient to ensure the proper identification of subrecipients. Effect The effect of the condition found is that subrecipient expenditures were not accurately presented on the SEFA. Questioned Costs None. Recommendation We recommend that the State review its existing statewide internal controls over vendor versus subrecipient determination to ensure they are operating effectively to properly identify a vendor versus a subrecipient. This will ensure that the amounts presented as pass through as subrecipient expenditures on the SEFA are complete and accurate. Views of Responsible Officials The Department of Administrative Services (DAS) concurs. Financial management of individual federal awards is decentralized throughout state agencies which centralizes annually in the culmination of the State?s SEFA. During this process, each agency is required to complete a standardized SEFA analysis and reconciliation tool for review by the DAS prior to the incorporation of the data into the State?s SEFA. This process also includes an annual Single Audit training and update session organized by the DAS. Additionally, the DAS notes all contracts, including subawards, entered by state agencies over a designated threshold are required to be authorized by the State?s Legislative Fiscal Committee and the Governor and Executive Council. The DAS will examine each of these processes to identify additional control activities to improve the accuracy and completeness of the pass through element of the SEFA. Anticipated Completion Date: April 30, 2024 Contact: Steven Giovinelli, Federal Grants and Cost Allocation Administrator, Department of Administrative Services
Finding Reference Number: 2022-002 NH Department of Administrative Services Federal Transit Cluster and COVID-19 Federal Transit Cluster (Assistance Listing #20.507and #20.526) Airport Improvement Program and COVID-19 Airport Improvement Program (Assistance Listing #20.106) COVID-19 Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing #21.027) Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) and COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing #93.323) Temporary Assistance for Needy Families and COVID-19 Temporary Assistance for Needy Families (Assistance Listing #93.558) Federal Award Numbers 2020G996115, 2021G996115, SLFRP0145, NUK50CK000522, 2001NHLEA, 2001NHLIE4, 2001NH5C3, 2101NHLIEA, 2101NHE5C6, 2201NHLIEA, 2101NHLIE4, 2021G996115, 2021G990228, 2022G996115 Federal Award Year: 2019, 2020, 2021 U.S. Department of Transportation, U.S. Department of Treasury, U.S. Department of Health and Human Services Type of Finding: Significant Deficiency Prior Year Finding: None Statistically Valid Sample: No Criteria Title 2 U.S. Code of Federal Regulations Part 200 (2 CFR section 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements, section 200.510(b) states the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. Additionally, per 2 CFR section 200.303, non-federal entities must establish and maintain effective internal control over federal awards that provide reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition The State of New Hampshire (the State) entered into contracts and subrecipient grant agreements to assist with the administration of its federal awards. As part of the Schedule of Expenditures of Federal Awards (SEFA) preparation process, the Department of Administrative Services requested information from each Department related to federal expenditures made by federal program and the portion of those expenditures that were passed through to subrecipients. For the year ended June 30, 2022, the State reported approximately $3.5 billion in federal expenditures on the SEFA. Of the total expenditures reported, approximately $783 million was reported as amounts passed through to subrecipients. During our audit, we identified several instances where the State inaccurately reported the value of the amounts passed through to subrecipients for certain federal programs. Specifically, we noted the following: A. Federal Transit Cluster - The State reported subrecipient expenditures in the amount of $4,038,163 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over procurement, we noted that 1 of 4 contracts selected for testwork was incorrectly identified as a contract. Upon further review and inquiry of management, the actual subrecipient expenditures for the year ended June 30, 2022 were $375,302, resulting in an overstatement of $3,662,861. This error was subsequently corrected on the final SEFA. B. Airport Improvement Program - The State reported subrecipient expenditures in the amount of $8,275,240 on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $8,168,301, resulting in an overstatement of $106,939. This error was subsequently corrected on the final SEFA. C. Coronavirus State and Local Fiscal Recovery Funds ? The State reported subrecipient expenditures in the amount of $7,435,217 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over subrecipient monitoring, we noted that for 5 of 10 subrecipients selected for testwork that the sample selection had been incorrectly identified as a subrecipient, resulting in an overstatement of $5,326,620. We further noted as part of our testwork over procurement, that 18 of 48 contracts selected for testwork had incorrectly been identified as a contract and instead of a subrecipient grant agreement. There were no expenditures associated with these agreements, and as a result, there was no impact on the amount reported on the SEFA within the amounts provided to subrecipients column. The error was subsequently corrected on the final SEFA to properly present $2,108,597 as passed through to subrecipient. D. Epidemiology and Laboratory Capacity for Infectious Diseases - The State reported subrecipient expenditures in the amount of $4,879,473 on the draft SEFA within the amounts provided to subrecipients column. During our testwork related to FFATA reporting, we noted that 1 of 4 items selected for testwork did not represent a tier-one award but instead was a contract. The impact on the amount reported on the SEFA within the amounts provided to subrecipients column was an overstatement of $8,400. The error was subsequently corrected on the final SEFA to properly present $4,871,073 as passed through to subrecipient. E. Temporary Assistance for Needy Families - The State did not report any subrecipient expenditures on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $3,307,974, resulting in an understatement of $3,307,974. This error was subsequently corrected on the final SEFA. Cause The cause of the condition found is primarily due to insufficient controls related to the determination of vendor versus subrecipient to ensure the proper identification of subrecipients. Effect The effect of the condition found is that subrecipient expenditures were not accurately presented on the SEFA. Questioned Costs None. Recommendation We recommend that the State review its existing statewide internal controls over vendor versus subrecipient determination to ensure they are operating effectively to properly identify a vendor versus a subrecipient. This will ensure that the amounts presented as pass through as subrecipient expenditures on the SEFA are complete and accurate. Views of Responsible Officials The Department of Administrative Services (DAS) concurs. Financial management of individual federal awards is decentralized throughout state agencies which centralizes annually in the culmination of the State?s SEFA. During this process, each agency is required to complete a standardized SEFA analysis and reconciliation tool for review by the DAS prior to the incorporation of the data into the State?s SEFA. This process also includes an annual Single Audit training and update session organized by the DAS. Additionally, the DAS notes all contracts, including subawards, entered by state agencies over a designated threshold are required to be authorized by the State?s Legislative Fiscal Committee and the Governor and Executive Council. The DAS will examine each of these processes to identify additional control activities to improve the accuracy and completeness of the pass through element of the SEFA. Anticipated Completion Date: April 30, 2024 Contact: Steven Giovinelli, Federal Grants and Cost Allocation Administrator, Department of Administrative Services
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Finding Reference Number: 2022-002 NH Department of Administrative Services Federal Transit Cluster and COVID-19 Federal Transit Cluster (Assistance Listing #20.507and #20.526) Airport Improvement Program and COVID-19 Airport Improvement Program (Assistance Listing #20.106) COVID-19 Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing #21.027) Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) and COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing #93.323) Temporary Assistance for Needy Families and COVID-19 Temporary Assistance for Needy Families (Assistance Listing #93.558) Federal Award Numbers 2020G996115, 2021G996115, SLFRP0145, NUK50CK000522, 2001NHLEA, 2001NHLIE4, 2001NH5C3, 2101NHLIEA, 2101NHE5C6, 2201NHLIEA, 2101NHLIE4, 2021G996115, 2021G990228, 2022G996115 Federal Award Year: 2019, 2020, 2021 U.S. Department of Transportation, U.S. Department of Treasury, U.S. Department of Health and Human Services Type of Finding: Significant Deficiency Prior Year Finding: None Statistically Valid Sample: No Criteria Title 2 U.S. Code of Federal Regulations Part 200 (2 CFR section 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements, section 200.510(b) states the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. Additionally, per 2 CFR section 200.303, non-federal entities must establish and maintain effective internal control over federal awards that provide reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition The State of New Hampshire (the State) entered into contracts and subrecipient grant agreements to assist with the administration of its federal awards. As part of the Schedule of Expenditures of Federal Awards (SEFA) preparation process, the Department of Administrative Services requested information from each Department related to federal expenditures made by federal program and the portion of those expenditures that were passed through to subrecipients. For the year ended June 30, 2022, the State reported approximately $3.5 billion in federal expenditures on the SEFA. Of the total expenditures reported, approximately $783 million was reported as amounts passed through to subrecipients. During our audit, we identified several instances where the State inaccurately reported the value of the amounts passed through to subrecipients for certain federal programs. Specifically, we noted the following: A. Federal Transit Cluster - The State reported subrecipient expenditures in the amount of $4,038,163 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over procurement, we noted that 1 of 4 contracts selected for testwork was incorrectly identified as a contract. Upon further review and inquiry of management, the actual subrecipient expenditures for the year ended June 30, 2022 were $375,302, resulting in an overstatement of $3,662,861. This error was subsequently corrected on the final SEFA. B. Airport Improvement Program - The State reported subrecipient expenditures in the amount of $8,275,240 on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $8,168,301, resulting in an overstatement of $106,939. This error was subsequently corrected on the final SEFA. C. Coronavirus State and Local Fiscal Recovery Funds ? The State reported subrecipient expenditures in the amount of $7,435,217 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over subrecipient monitoring, we noted that for 5 of 10 subrecipients selected for testwork that the sample selection had been incorrectly identified as a subrecipient, resulting in an overstatement of $5,326,620. We further noted as part of our testwork over procurement, that 18 of 48 contracts selected for testwork had incorrectly been identified as a contract and instead of a subrecipient grant agreement. There were no expenditures associated with these agreements, and as a result, there was no impact on the amount reported on the SEFA within the amounts provided to subrecipients column. The error was subsequently corrected on the final SEFA to properly present $2,108,597 as passed through to subrecipient. D. Epidemiology and Laboratory Capacity for Infectious Diseases - The State reported subrecipient expenditures in the amount of $4,879,473 on the draft SEFA within the amounts provided to subrecipients column. During our testwork related to FFATA reporting, we noted that 1 of 4 items selected for testwork did not represent a tier-one award but instead was a contract. The impact on the amount reported on the SEFA within the amounts provided to subrecipients column was an overstatement of $8,400. The error was subsequently corrected on the final SEFA to properly present $4,871,073 as passed through to subrecipient. E. Temporary Assistance for Needy Families - The State did not report any subrecipient expenditures on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $3,307,974, resulting in an understatement of $3,307,974. This error was subsequently corrected on the final SEFA. Cause The cause of the condition found is primarily due to insufficient controls related to the determination of vendor versus subrecipient to ensure the proper identification of subrecipients. Effect The effect of the condition found is that subrecipient expenditures were not accurately presented on the SEFA. Questioned Costs None. Recommendation We recommend that the State review its existing statewide internal controls over vendor versus subrecipient determination to ensure they are operating effectively to properly identify a vendor versus a subrecipient. This will ensure that the amounts presented as pass through as subrecipient expenditures on the SEFA are complete and accurate. Views of Responsible Officials The Department of Administrative Services (DAS) concurs. Financial management of individual federal awards is decentralized throughout state agencies which centralizes annually in the culmination of the State?s SEFA. During this process, each agency is required to complete a standardized SEFA analysis and reconciliation tool for review by the DAS prior to the incorporation of the data into the State?s SEFA. This process also includes an annual Single Audit training and update session organized by the DAS. Additionally, the DAS notes all contracts, including subawards, entered by state agencies over a designated threshold are required to be authorized by the State?s Legislative Fiscal Committee and the Governor and Executive Council. The DAS will examine each of these processes to identify additional control activities to improve the accuracy and completeness of the pass through element of the SEFA. Anticipated Completion Date: April 30, 2024 Contact: Steven Giovinelli, Federal Grants and Cost Allocation Administrator, Department of Administrative Services
Finding Reference Number: 2022-002 NH Department of Administrative Services Federal Transit Cluster and COVID-19 Federal Transit Cluster (Assistance Listing #20.507and #20.526) Airport Improvement Program and COVID-19 Airport Improvement Program (Assistance Listing #20.106) COVID-19 Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing #21.027) Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) and COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing #93.323) Temporary Assistance for Needy Families and COVID-19 Temporary Assistance for Needy Families (Assistance Listing #93.558) Federal Award Numbers 2020G996115, 2021G996115, SLFRP0145, NUK50CK000522, 2001NHLEA, 2001NHLIE4, 2001NH5C3, 2101NHLIEA, 2101NHE5C6, 2201NHLIEA, 2101NHLIE4, 2021G996115, 2021G990228, 2022G996115 Federal Award Year: 2019, 2020, 2021 U.S. Department of Transportation, U.S. Department of Treasury, U.S. Department of Health and Human Services Type of Finding: Significant Deficiency Prior Year Finding: None Statistically Valid Sample: No Criteria Title 2 U.S. Code of Federal Regulations Part 200 (2 CFR section 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements, section 200.510(b) states the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. Additionally, per 2 CFR section 200.303, non-federal entities must establish and maintain effective internal control over federal awards that provide reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition The State of New Hampshire (the State) entered into contracts and subrecipient grant agreements to assist with the administration of its federal awards. As part of the Schedule of Expenditures of Federal Awards (SEFA) preparation process, the Department of Administrative Services requested information from each Department related to federal expenditures made by federal program and the portion of those expenditures that were passed through to subrecipients. For the year ended June 30, 2022, the State reported approximately $3.5 billion in federal expenditures on the SEFA. Of the total expenditures reported, approximately $783 million was reported as amounts passed through to subrecipients. During our audit, we identified several instances where the State inaccurately reported the value of the amounts passed through to subrecipients for certain federal programs. Specifically, we noted the following: A. Federal Transit Cluster - The State reported subrecipient expenditures in the amount of $4,038,163 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over procurement, we noted that 1 of 4 contracts selected for testwork was incorrectly identified as a contract. Upon further review and inquiry of management, the actual subrecipient expenditures for the year ended June 30, 2022 were $375,302, resulting in an overstatement of $3,662,861. This error was subsequently corrected on the final SEFA. B. Airport Improvement Program - The State reported subrecipient expenditures in the amount of $8,275,240 on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $8,168,301, resulting in an overstatement of $106,939. This error was subsequently corrected on the final SEFA. C. Coronavirus State and Local Fiscal Recovery Funds ? The State reported subrecipient expenditures in the amount of $7,435,217 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over subrecipient monitoring, we noted that for 5 of 10 subrecipients selected for testwork that the sample selection had been incorrectly identified as a subrecipient, resulting in an overstatement of $5,326,620. We further noted as part of our testwork over procurement, that 18 of 48 contracts selected for testwork had incorrectly been identified as a contract and instead of a subrecipient grant agreement. There were no expenditures associated with these agreements, and as a result, there was no impact on the amount reported on the SEFA within the amounts provided to subrecipients column. The error was subsequently corrected on the final SEFA to properly present $2,108,597 as passed through to subrecipient. D. Epidemiology and Laboratory Capacity for Infectious Diseases - The State reported subrecipient expenditures in the amount of $4,879,473 on the draft SEFA within the amounts provided to subrecipients column. During our testwork related to FFATA reporting, we noted that 1 of 4 items selected for testwork did not represent a tier-one award but instead was a contract. The impact on the amount reported on the SEFA within the amounts provided to subrecipients column was an overstatement of $8,400. The error was subsequently corrected on the final SEFA to properly present $4,871,073 as passed through to subrecipient. E. Temporary Assistance for Needy Families - The State did not report any subrecipient expenditures on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $3,307,974, resulting in an understatement of $3,307,974. This error was subsequently corrected on the final SEFA. Cause The cause of the condition found is primarily due to insufficient controls related to the determination of vendor versus subrecipient to ensure the proper identification of subrecipients. Effect The effect of the condition found is that subrecipient expenditures were not accurately presented on the SEFA. Questioned Costs None. Recommendation We recommend that the State review its existing statewide internal controls over vendor versus subrecipient determination to ensure they are operating effectively to properly identify a vendor versus a subrecipient. This will ensure that the amounts presented as pass through as subrecipient expenditures on the SEFA are complete and accurate. Views of Responsible Officials The Department of Administrative Services (DAS) concurs. Financial management of individual federal awards is decentralized throughout state agencies which centralizes annually in the culmination of the State?s SEFA. During this process, each agency is required to complete a standardized SEFA analysis and reconciliation tool for review by the DAS prior to the incorporation of the data into the State?s SEFA. This process also includes an annual Single Audit training and update session organized by the DAS. Additionally, the DAS notes all contracts, including subawards, entered by state agencies over a designated threshold are required to be authorized by the State?s Legislative Fiscal Committee and the Governor and Executive Council. The DAS will examine each of these processes to identify additional control activities to improve the accuracy and completeness of the pass through element of the SEFA. Anticipated Completion Date: April 30, 2024 Contact: Steven Giovinelli, Federal Grants and Cost Allocation Administrator, Department of Administrative Services
Finding Reference Number: 2022-002 NH Department of Administrative Services Federal Transit Cluster and COVID-19 Federal Transit Cluster (Assistance Listing #20.507and #20.526) Airport Improvement Program and COVID-19 Airport Improvement Program (Assistance Listing #20.106) COVID-19 Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing #21.027) Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) and COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing #93.323) Temporary Assistance for Needy Families and COVID-19 Temporary Assistance for Needy Families (Assistance Listing #93.558) Federal Award Numbers 2020G996115, 2021G996115, SLFRP0145, NUK50CK000522, 2001NHLEA, 2001NHLIE4, 2001NH5C3, 2101NHLIEA, 2101NHE5C6, 2201NHLIEA, 2101NHLIE4, 2021G996115, 2021G990228, 2022G996115 Federal Award Year: 2019, 2020, 2021 U.S. Department of Transportation, U.S. Department of Treasury, U.S. Department of Health and Human Services Type of Finding: Significant Deficiency Prior Year Finding: None Statistically Valid Sample: No Criteria Title 2 U.S. Code of Federal Regulations Part 200 (2 CFR section 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements, section 200.510(b) states the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. Additionally, per 2 CFR section 200.303, non-federal entities must establish and maintain effective internal control over federal awards that provide reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition The State of New Hampshire (the State) entered into contracts and subrecipient grant agreements to assist with the administration of its federal awards. As part of the Schedule of Expenditures of Federal Awards (SEFA) preparation process, the Department of Administrative Services requested information from each Department related to federal expenditures made by federal program and the portion of those expenditures that were passed through to subrecipients. For the year ended June 30, 2022, the State reported approximately $3.5 billion in federal expenditures on the SEFA. Of the total expenditures reported, approximately $783 million was reported as amounts passed through to subrecipients. During our audit, we identified several instances where the State inaccurately reported the value of the amounts passed through to subrecipients for certain federal programs. Specifically, we noted the following: A. Federal Transit Cluster - The State reported subrecipient expenditures in the amount of $4,038,163 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over procurement, we noted that 1 of 4 contracts selected for testwork was incorrectly identified as a contract. Upon further review and inquiry of management, the actual subrecipient expenditures for the year ended June 30, 2022 were $375,302, resulting in an overstatement of $3,662,861. This error was subsequently corrected on the final SEFA. B. Airport Improvement Program - The State reported subrecipient expenditures in the amount of $8,275,240 on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $8,168,301, resulting in an overstatement of $106,939. This error was subsequently corrected on the final SEFA. C. Coronavirus State and Local Fiscal Recovery Funds ? The State reported subrecipient expenditures in the amount of $7,435,217 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over subrecipient monitoring, we noted that for 5 of 10 subrecipients selected for testwork that the sample selection had been incorrectly identified as a subrecipient, resulting in an overstatement of $5,326,620. We further noted as part of our testwork over procurement, that 18 of 48 contracts selected for testwork had incorrectly been identified as a contract and instead of a subrecipient grant agreement. There were no expenditures associated with these agreements, and as a result, there was no impact on the amount reported on the SEFA within the amounts provided to subrecipients column. The error was subsequently corrected on the final SEFA to properly present $2,108,597 as passed through to subrecipient. D. Epidemiology and Laboratory Capacity for Infectious Diseases - The State reported subrecipient expenditures in the amount of $4,879,473 on the draft SEFA within the amounts provided to subrecipients column. During our testwork related to FFATA reporting, we noted that 1 of 4 items selected for testwork did not represent a tier-one award but instead was a contract. The impact on the amount reported on the SEFA within the amounts provided to subrecipients column was an overstatement of $8,400. The error was subsequently corrected on the final SEFA to properly present $4,871,073 as passed through to subrecipient. E. Temporary Assistance for Needy Families - The State did not report any subrecipient expenditures on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $3,307,974, resulting in an understatement of $3,307,974. This error was subsequently corrected on the final SEFA. Cause The cause of the condition found is primarily due to insufficient controls related to the determination of vendor versus subrecipient to ensure the proper identification of subrecipients. Effect The effect of the condition found is that subrecipient expenditures were not accurately presented on the SEFA. Questioned Costs None. Recommendation We recommend that the State review its existing statewide internal controls over vendor versus subrecipient determination to ensure they are operating effectively to properly identify a vendor versus a subrecipient. This will ensure that the amounts presented as pass through as subrecipient expenditures on the SEFA are complete and accurate. Views of Responsible Officials The Department of Administrative Services (DAS) concurs. Financial management of individual federal awards is decentralized throughout state agencies which centralizes annually in the culmination of the State?s SEFA. During this process, each agency is required to complete a standardized SEFA analysis and reconciliation tool for review by the DAS prior to the incorporation of the data into the State?s SEFA. This process also includes an annual Single Audit training and update session organized by the DAS. Additionally, the DAS notes all contracts, including subawards, entered by state agencies over a designated threshold are required to be authorized by the State?s Legislative Fiscal Committee and the Governor and Executive Council. The DAS will examine each of these processes to identify additional control activities to improve the accuracy and completeness of the pass through element of the SEFA. Anticipated Completion Date: April 30, 2024 Contact: Steven Giovinelli, Federal Grants and Cost Allocation Administrator, Department of Administrative Services
Finding Reference Number: 2022-002 NH Department of Administrative Services Federal Transit Cluster and COVID-19 Federal Transit Cluster (Assistance Listing #20.507and #20.526) Airport Improvement Program and COVID-19 Airport Improvement Program (Assistance Listing #20.106) COVID-19 Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing #21.027) Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) and COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing #93.323) Temporary Assistance for Needy Families and COVID-19 Temporary Assistance for Needy Families (Assistance Listing #93.558) Federal Award Numbers 2020G996115, 2021G996115, SLFRP0145, NUK50CK000522, 2001NHLEA, 2001NHLIE4, 2001NH5C3, 2101NHLIEA, 2101NHE5C6, 2201NHLIEA, 2101NHLIE4, 2021G996115, 2021G990228, 2022G996115 Federal Award Year: 2019, 2020, 2021 U.S. Department of Transportation, U.S. Department of Treasury, U.S. Department of Health and Human Services Type of Finding: Significant Deficiency Prior Year Finding: None Statistically Valid Sample: No Criteria Title 2 U.S. Code of Federal Regulations Part 200 (2 CFR section 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements, section 200.510(b) states the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. Additionally, per 2 CFR section 200.303, non-federal entities must establish and maintain effective internal control over federal awards that provide reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition The State of New Hampshire (the State) entered into contracts and subrecipient grant agreements to assist with the administration of its federal awards. As part of the Schedule of Expenditures of Federal Awards (SEFA) preparation process, the Department of Administrative Services requested information from each Department related to federal expenditures made by federal program and the portion of those expenditures that were passed through to subrecipients. For the year ended June 30, 2022, the State reported approximately $3.5 billion in federal expenditures on the SEFA. Of the total expenditures reported, approximately $783 million was reported as amounts passed through to subrecipients. During our audit, we identified several instances where the State inaccurately reported the value of the amounts passed through to subrecipients for certain federal programs. Specifically, we noted the following: A. Federal Transit Cluster - The State reported subrecipient expenditures in the amount of $4,038,163 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over procurement, we noted that 1 of 4 contracts selected for testwork was incorrectly identified as a contract. Upon further review and inquiry of management, the actual subrecipient expenditures for the year ended June 30, 2022 were $375,302, resulting in an overstatement of $3,662,861. This error was subsequently corrected on the final SEFA. B. Airport Improvement Program - The State reported subrecipient expenditures in the amount of $8,275,240 on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $8,168,301, resulting in an overstatement of $106,939. This error was subsequently corrected on the final SEFA. C. Coronavirus State and Local Fiscal Recovery Funds ? The State reported subrecipient expenditures in the amount of $7,435,217 on the draft SEFA within the amounts provided to subrecipients column. During our testwork over subrecipient monitoring, we noted that for 5 of 10 subrecipients selected for testwork that the sample selection had been incorrectly identified as a subrecipient, resulting in an overstatement of $5,326,620. We further noted as part of our testwork over procurement, that 18 of 48 contracts selected for testwork had incorrectly been identified as a contract and instead of a subrecipient grant agreement. There were no expenditures associated with these agreements, and as a result, there was no impact on the amount reported on the SEFA within the amounts provided to subrecipients column. The error was subsequently corrected on the final SEFA to properly present $2,108,597 as passed through to subrecipient. D. Epidemiology and Laboratory Capacity for Infectious Diseases - The State reported subrecipient expenditures in the amount of $4,879,473 on the draft SEFA within the amounts provided to subrecipients column. During our testwork related to FFATA reporting, we noted that 1 of 4 items selected for testwork did not represent a tier-one award but instead was a contract. The impact on the amount reported on the SEFA within the amounts provided to subrecipients column was an overstatement of $8,400. The error was subsequently corrected on the final SEFA to properly present $4,871,073 as passed through to subrecipient. E. Temporary Assistance for Needy Families - The State did not report any subrecipient expenditures on the draft SEFA within the amounts provided to subrecipients column. Upon further review and inquiry of management, management determined the actual subrecipient expenditures for the year ended June 30, 2022 were $3,307,974, resulting in an understatement of $3,307,974. This error was subsequently corrected on the final SEFA. Cause The cause of the condition found is primarily due to insufficient controls related to the determination of vendor versus subrecipient to ensure the proper identification of subrecipients. Effect The effect of the condition found is that subrecipient expenditures were not accurately presented on the SEFA. Questioned Costs None. Recommendation We recommend that the State review its existing statewide internal controls over vendor versus subrecipient determination to ensure they are operating effectively to properly identify a vendor versus a subrecipient. This will ensure that the amounts presented as pass through as subrecipient expenditures on the SEFA are complete and accurate. Views of Responsible Officials The Department of Administrative Services (DAS) concurs. Financial management of individual federal awards is decentralized throughout state agencies which centralizes annually in the culmination of the State?s SEFA. During this process, each agency is required to complete a standardized SEFA analysis and reconciliation tool for review by the DAS prior to the incorporation of the data into the State?s SEFA. This process also includes an annual Single Audit training and update session organized by the DAS. Additionally, the DAS notes all contracts, including subawards, entered by state agencies over a designated threshold are required to be authorized by the State?s Legislative Fiscal Committee and the Governor and Executive Council. The DAS will examine each of these processes to identify additional control activities to improve the accuracy and completeness of the pass through element of the SEFA. Anticipated Completion Date: April 30, 2024 Contact: Steven Giovinelli, Federal Grants and Cost Allocation Administrator, Department of Administrative Services
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name - ALN 21.023, Department of Treasury, COVID-19 Emergency Rental Assistance Program (ERAP) ALN 20.205, Department of Transportation, Highway Planning and Construction Cluster, Highway Planning and Construction (Federal-aid Highway Program) ALN 20.505, Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research ALN 93.323, Department of Health and Human Services, COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ALN 97.036, Department of Homeland Security, COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters) (FEMA) ALN 93.268, Department of Health and Human Services, Total Immunizations Cooperative Agreements ALN 93.145, Department of Health and Human Services, HIV Related Training and Technical Assistance ALN 93.686, Department of Health and Human Services, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B Federal Award Identification Number and Year Various Pass-through Entity - N/A for ALN 21.023, 20.505, 93.145, and 93.686 ALN 20.205 is passed through Michigan Department of Transportation, Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. ALN 93.323 is passed through Michigan Department of Health and Human Services. ALN 97.036 is directly funded and passed through Michigan Department of Health and Human Services and Michigan State Police. ALN 93.323 is passed through Michigan Department of Health and Human Services. Finding Type - Material weakness Repeat Finding - Yes - 2021-013 Criteria - Per 2 CFR 200.510(b)-The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with ? 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. Condition - The schedule of expenditures of federal awards (SEFA) was not complete, accurate, or prepared timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2022, the City expended approximately $229.7 million of federal funding. The funding was received by various departments within the City from several federal and nonfederal entities. The City accumulates the financial data and other required information to complete the SEFA. The SEFA included the following inaccuracies: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were understated by $1,868,133 related to the June 30, 2022 accrual. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster, ALN 20.500, instead of the Highway Planning and Construction Cluster. ? ALN 20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research. - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster, ALN 20.516 and 20.521. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $283,851 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323 (ELC). ? ALN 93.268 Immunizations Cooperative Agreements Expenditures of $1,698,773 were improperly excluded from the SEFA. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America - Ryan White HIV/AIDS Program Parts A and B - Expenditures of $240,000 were improperly reported as ALN 93.686 instead of ALN 93.145. Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The resulting errors had the following impact: ? ALN 21.023 (ERAP) - The expenditures reported on the SEFA were initially understated by $1,868,133. ? ALN 20.205 Highway Planning and Construction program - Expenditures of $2,027,058 were improperly included under the Federal Transit Cluster instead of the Highway Planning and Construction Cluster resulting in the Highway Planning and Construction Cluster being a Type B program ? ALN 20.505 Metropolitan Transportation Planning and State and Non Metropolitan Planning and Research - Expenditures of $249,939 was improperly included under the Transit Services Program Cluster. ? ALN 93.323 (ELC) and ALN 97.036 (FEMA) - $1,371,758 spent under ALN 97.036 (FEMA) was improperly reported under ALN 93.323, (ELC). The initial understatement of FEMA expenditures impacted major program determination. ? ALN 93.268 Total Immunizations Cooperative Agreements - The expenditures reported on the SEFA were initially understated by $283,851. ? ALN 93.145, HIV Related Training and Technical Assistance and ALN 93.686, Ending the HIV Pandemic: A Plan for America Ryan White HIV/AIDS Program Parts A and B - $240,000 spent under ALN 93.145 were improperly included in ALN 93.686. These errors, noted above, have been corrected on the SEFA as of June 30, 2022. Recommendation - The City should implement process to ensure that the SEFA is prepared timely and that it is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - As part of the City Audit Finding Corrective Action Plan, in FY22, the City developed a SEFA checklist to help ensure all federal expenditures are properly reported. A follow up AFCAP will be implemented and additional processes put in place by management that will provide timelines, a pre SEFA reporting review before the year end close to effectively meet audit report timelines and help ensure completeness, validity, and accuracy in advance of the final SEFA reporting.
2022-005 ? Material Weakness and Noncompliance: Preparation of Schedule of Expenditures of Federal Awards (SEFA) Finding Type: Material Weakness in Internal Controls and Noncompliance (Reporting and Allowable Costs/Cost Principles) Federal Program: U.S. Department of Agriculture ? Water & Waste Disposal Systems for Rural Communities (AL #10.760) Questioned Costs: No costs have been questioned as a result of this finding. 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 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 City 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 for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502(a), as stated above, and must reconcile amounts reported in the SEFA to the amounts reported in the auditee?s financial statements. Condition: The SEFA was not appropriately reconciled to federal grant revenues and expenditures recorded in the financial statements. Changes were made to major program expenditures, as well as expenditures of other programs, during the closing process and during the 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 properly 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 City could fail to have a program appropriately identified 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: Closing procedures were not in place and management did not effectively communicate with City departments and consultants responsible for administering federal awards to identify all federal grant related activity. Effect: The SEFA required 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. Recommendation: We recommend that management meet with department heads and third party consultants throughout the year and during the closing process to identify all expenditures under federal awards. Training should be provided to all staff to make sure they are aware of the importance of accurately reconciling and claiming grant expenditures on a timely basis and providing the information to management for inclusion on the SEFA. Management Response: The City will work to improve closing processes and communications with various departments and consultants to ensure the SEFA is complete and accurate.
2022-005 ? Material Weakness and Noncompliance: Preparation of Schedule of Expenditures of Federal Awards (SEFA) Finding Type: Material Weakness in Internal Controls and Noncompliance (Reporting and Allowable Costs/Cost Principles) Federal Program: U.S. Department of Agriculture ? Water & Waste Disposal Systems for Rural Communities (AL #10.760) Questioned Costs: No costs have been questioned as a result of this finding. 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 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 City 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 for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502(a), as stated above, and must reconcile amounts reported in the SEFA to the amounts reported in the auditee?s financial statements. Condition: The SEFA was not appropriately reconciled to federal grant revenues and expenditures recorded in the financial statements. Changes were made to major program expenditures, as well as expenditures of other programs, during the closing process and during the 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 properly 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 City could fail to have a program appropriately identified 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: Closing procedures were not in place and management did not effectively communicate with City departments and consultants responsible for administering federal awards to identify all federal grant related activity. Effect: The SEFA required 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. Recommendation: We recommend that management meet with department heads and third party consultants throughout the year and during the closing process to identify all expenditures under federal awards. Training should be provided to all staff to make sure they are aware of the importance of accurately reconciling and claiming grant expenditures on a timely basis and providing the information to management for inclusion on the SEFA. Management Response: The City will work to improve closing processes and communications with various departments and consultants to ensure the SEFA is complete and accurate.
2022-005 ? Material Weakness and Noncompliance: Preparation of Schedule of Expenditures of Federal Awards (SEFA) Finding Type: Material Weakness in Internal Controls and Noncompliance (Reporting and Allowable Costs/Cost Principles) Federal Program: U.S. Department of Agriculture ? Water & Waste Disposal Systems for Rural Communities (AL #10.760) Questioned Costs: No costs have been questioned as a result of this finding. 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 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 City 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 for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502(a), as stated above, and must reconcile amounts reported in the SEFA to the amounts reported in the auditee?s financial statements. Condition: The SEFA was not appropriately reconciled to federal grant revenues and expenditures recorded in the financial statements. Changes were made to major program expenditures, as well as expenditures of other programs, during the closing process and during the 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 properly 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 City could fail to have a program appropriately identified 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: Closing procedures were not in place and management did not effectively communicate with City departments and consultants responsible for administering federal awards to identify all federal grant related activity. Effect: The SEFA required 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. Recommendation: We recommend that management meet with department heads and third party consultants throughout the year and during the closing process to identify all expenditures under federal awards. Training should be provided to all staff to make sure they are aware of the importance of accurately reconciling and claiming grant expenditures on a timely basis and providing the information to management for inclusion on the SEFA. Management Response: The City will work to improve closing processes and communications with various departments and consultants to ensure the SEFA is complete and accurate.
2022-005 ? Material Weakness and Noncompliance: Preparation of Schedule of Expenditures of Federal Awards (SEFA) Finding Type: Material Weakness in Internal Controls and Noncompliance (Reporting and Allowable Costs/Cost Principles) Federal Program: U.S. Department of Agriculture ? Water & Waste Disposal Systems for Rural Communities (AL #10.760) Questioned Costs: No costs have been questioned as a result of this finding. 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 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 City 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 for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502(a), as stated above, and must reconcile amounts reported in the SEFA to the amounts reported in the auditee?s financial statements. Condition: The SEFA was not appropriately reconciled to federal grant revenues and expenditures recorded in the financial statements. Changes were made to major program expenditures, as well as expenditures of other programs, during the closing process and during the 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 properly 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 City could fail to have a program appropriately identified 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: Closing procedures were not in place and management did not effectively communicate with City departments and consultants responsible for administering federal awards to identify all federal grant related activity. Effect: The SEFA required 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. Recommendation: We recommend that management meet with department heads and third party consultants throughout the year and during the closing process to identify all expenditures under federal awards. Training should be provided to all staff to make sure they are aware of the importance of accurately reconciling and claiming grant expenditures on a timely basis and providing the information to management for inclusion on the SEFA. Management Response: The City will work to improve closing processes and communications with various departments and consultants to ensure the SEFA is complete and accurate.
Finding No. 2022-001 Federal Agency: U.S. Department of Health and Human Services Program Name: HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Assistance Listing Number: 93.461 Federal Award Year: July 1, 2021 ? June 30, 2022 Compliance Requirements: Other ? Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the entity?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Conditions Found Lehigh Valley Health Network and Subsidiaries (the ?Organization?) did not have adequate controls relating to the reporting of expenditures for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund (the ?Uninsured Program?) in the SEFA. Specifically, the amounts originally provided on the SEFA for the year ended June 30, 2022 for the Uninsured Program were based on when claim payments were received rather than when the services were provided for claim reimbursement. Once the error was identified, management corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program. Cause and Effect In discussing these conditions with management, they stated that sufficient controls were not in place to ensure that the date of the patient service or treatment was used to determine the appropriate amounts and year to include the payment received from HRSA on the SEFA. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with 2 CFR Part 200. Questioned Costs There are no questioned costs related to this finding. Statistical Sample Not applicable. Repeat Finding A similar finding was not reported in the prior year audit. Recommendation We recommend the Organization establish internal controls to ensure the HRSA COVID-19 Uninsured Program is accurately reported on the SEFA and information provided for audit purposes is complete and accurate. View of Responsible Officials Since the inception of the program, the Organization reported the HRSA COVID-19 for the Uninsured based on payment date rather than on date of service/ incurred date. Once the error was identified, management properly reported and corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program.
Finding No. 2022-001 Federal Agency: U.S. Department of Health and Human Services Program Name: HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Assistance Listing Number: 93.461 Federal Award Year: July 1, 2021 ? June 30, 2022 Compliance Requirements: Other ? Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the entity?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Conditions Found Lehigh Valley Health Network and Subsidiaries (the ?Organization?) did not have adequate controls relating to the reporting of expenditures for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund (the ?Uninsured Program?) in the SEFA. Specifically, the amounts originally provided on the SEFA for the year ended June 30, 2022 for the Uninsured Program were based on when claim payments were received rather than when the services were provided for claim reimbursement. Once the error was identified, management corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program. Cause and Effect In discussing these conditions with management, they stated that sufficient controls were not in place to ensure that the date of the patient service or treatment was used to determine the appropriate amounts and year to include the payment received from HRSA on the SEFA. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with 2 CFR Part 200. Questioned Costs There are no questioned costs related to this finding. Statistical Sample Not applicable. Repeat Finding A similar finding was not reported in the prior year audit. Recommendation We recommend the Organization establish internal controls to ensure the HRSA COVID-19 Uninsured Program is accurately reported on the SEFA and information provided for audit purposes is complete and accurate. View of Responsible Officials Since the inception of the program, the Organization reported the HRSA COVID-19 for the Uninsured based on payment date rather than on date of service/ incurred date. Once the error was identified, management properly reported and corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program.
Finding No. 2022-001 Federal Agency: U.S. Department of Health and Human Services Program Name: HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Assistance Listing Number: 93.461 Federal Award Year: July 1, 2021 ? June 30, 2022 Compliance Requirements: Other ? Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the entity?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Conditions Found Lehigh Valley Health Network and Subsidiaries (the ?Organization?) did not have adequate controls relating to the reporting of expenditures for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund (the ?Uninsured Program?) in the SEFA. Specifically, the amounts originally provided on the SEFA for the year ended June 30, 2022 for the Uninsured Program were based on when claim payments were received rather than when the services were provided for claim reimbursement. Once the error was identified, management corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program. Cause and Effect In discussing these conditions with management, they stated that sufficient controls were not in place to ensure that the date of the patient service or treatment was used to determine the appropriate amounts and year to include the payment received from HRSA on the SEFA. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with 2 CFR Part 200. Questioned Costs There are no questioned costs related to this finding. Statistical Sample Not applicable. Repeat Finding A similar finding was not reported in the prior year audit. Recommendation We recommend the Organization establish internal controls to ensure the HRSA COVID-19 Uninsured Program is accurately reported on the SEFA and information provided for audit purposes is complete and accurate. View of Responsible Officials Since the inception of the program, the Organization reported the HRSA COVID-19 for the Uninsured based on payment date rather than on date of service/ incurred date. Once the error was identified, management properly reported and corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program.
Finding No. 2022-001 Federal Agency: U.S. Department of Health and Human Services Program Name: HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Assistance Listing Number: 93.461 Federal Award Year: July 1, 2021 ? June 30, 2022 Compliance Requirements: Other ? Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the entity?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Conditions Found Lehigh Valley Health Network and Subsidiaries (the ?Organization?) did not have adequate controls relating to the reporting of expenditures for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund (the ?Uninsured Program?) in the SEFA. Specifically, the amounts originally provided on the SEFA for the year ended June 30, 2022 for the Uninsured Program were based on when claim payments were received rather than when the services were provided for claim reimbursement. Once the error was identified, management corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program. Cause and Effect In discussing these conditions with management, they stated that sufficient controls were not in place to ensure that the date of the patient service or treatment was used to determine the appropriate amounts and year to include the payment received from HRSA on the SEFA. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with 2 CFR Part 200. Questioned Costs There are no questioned costs related to this finding. Statistical Sample Not applicable. Repeat Finding A similar finding was not reported in the prior year audit. Recommendation We recommend the Organization establish internal controls to ensure the HRSA COVID-19 Uninsured Program is accurately reported on the SEFA and information provided for audit purposes is complete and accurate. View of Responsible Officials Since the inception of the program, the Organization reported the HRSA COVID-19 for the Uninsured based on payment date rather than on date of service/ incurred date. Once the error was identified, management properly reported and corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program.
Finding No. 2022-001 Federal Agency: U.S. Department of Health and Human Services Program Name: HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Assistance Listing Number: 93.461 Federal Award Year: July 1, 2021 ? June 30, 2022 Compliance Requirements: Other ? Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the entity?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Conditions Found Lehigh Valley Health Network and Subsidiaries (the ?Organization?) did not have adequate controls relating to the reporting of expenditures for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund (the ?Uninsured Program?) in the SEFA. Specifically, the amounts originally provided on the SEFA for the year ended June 30, 2022 for the Uninsured Program were based on when claim payments were received rather than when the services were provided for claim reimbursement. Once the error was identified, management corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program. Cause and Effect In discussing these conditions with management, they stated that sufficient controls were not in place to ensure that the date of the patient service or treatment was used to determine the appropriate amounts and year to include the payment received from HRSA on the SEFA. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with 2 CFR Part 200. Questioned Costs There are no questioned costs related to this finding. Statistical Sample Not applicable. Repeat Finding A similar finding was not reported in the prior year audit. Recommendation We recommend the Organization establish internal controls to ensure the HRSA COVID-19 Uninsured Program is accurately reported on the SEFA and information provided for audit purposes is complete and accurate. View of Responsible Officials Since the inception of the program, the Organization reported the HRSA COVID-19 for the Uninsured based on payment date rather than on date of service/ incurred date. Once the error was identified, management properly reported and corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program.
Finding No. 2022-001 Federal Agency: U.S. Department of Health and Human Services Program Name: HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Assistance Listing Number: 93.461 Federal Award Year: July 1, 2021 ? June 30, 2022 Compliance Requirements: Other ? Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the entity?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Conditions Found Lehigh Valley Health Network and Subsidiaries (the ?Organization?) did not have adequate controls relating to the reporting of expenditures for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund (the ?Uninsured Program?) in the SEFA. Specifically, the amounts originally provided on the SEFA for the year ended June 30, 2022 for the Uninsured Program were based on when claim payments were received rather than when the services were provided for claim reimbursement. Once the error was identified, management corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program. Cause and Effect In discussing these conditions with management, they stated that sufficient controls were not in place to ensure that the date of the patient service or treatment was used to determine the appropriate amounts and year to include the payment received from HRSA on the SEFA. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with 2 CFR Part 200. Questioned Costs There are no questioned costs related to this finding. Statistical Sample Not applicable. Repeat Finding A similar finding was not reported in the prior year audit. Recommendation We recommend the Organization establish internal controls to ensure the HRSA COVID-19 Uninsured Program is accurately reported on the SEFA and information provided for audit purposes is complete and accurate. View of Responsible Officials Since the inception of the program, the Organization reported the HRSA COVID-19 for the Uninsured based on payment date rather than on date of service/ incurred date. Once the error was identified, management properly reported and corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program.
Finding No. 2022-001 Federal Agency: U.S. Department of Health and Human Services Program Name: HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Assistance Listing Number: 93.461 Federal Award Year: July 1, 2021 ? June 30, 2022 Compliance Requirements: Other ? Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the entity?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Conditions Found Lehigh Valley Health Network and Subsidiaries (the ?Organization?) did not have adequate controls relating to the reporting of expenditures for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund (the ?Uninsured Program?) in the SEFA. Specifically, the amounts originally provided on the SEFA for the year ended June 30, 2022 for the Uninsured Program were based on when claim payments were received rather than when the services were provided for claim reimbursement. Once the error was identified, management corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program. Cause and Effect In discussing these conditions with management, they stated that sufficient controls were not in place to ensure that the date of the patient service or treatment was used to determine the appropriate amounts and year to include the payment received from HRSA on the SEFA. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with 2 CFR Part 200. Questioned Costs There are no questioned costs related to this finding. Statistical Sample Not applicable. Repeat Finding A similar finding was not reported in the prior year audit. Recommendation We recommend the Organization establish internal controls to ensure the HRSA COVID-19 Uninsured Program is accurately reported on the SEFA and information provided for audit purposes is complete and accurate. View of Responsible Officials Since the inception of the program, the Organization reported the HRSA COVID-19 for the Uninsured based on payment date rather than on date of service/ incurred date. Once the error was identified, management properly reported and corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program.
Finding No. 2022-001 Federal Agency: U.S. Department of Health and Human Services Program Name: HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Assistance Listing Number: 93.461 Federal Award Year: July 1, 2021 ? June 30, 2022 Compliance Requirements: Other ? Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the entity?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Conditions Found Lehigh Valley Health Network and Subsidiaries (the ?Organization?) did not have adequate controls relating to the reporting of expenditures for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund (the ?Uninsured Program?) in the SEFA. Specifically, the amounts originally provided on the SEFA for the year ended June 30, 2022 for the Uninsured Program were based on when claim payments were received rather than when the services were provided for claim reimbursement. Once the error was identified, management corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program. Cause and Effect In discussing these conditions with management, they stated that sufficient controls were not in place to ensure that the date of the patient service or treatment was used to determine the appropriate amounts and year to include the payment received from HRSA on the SEFA. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with 2 CFR Part 200. Questioned Costs There are no questioned costs related to this finding. Statistical Sample Not applicable. Repeat Finding A similar finding was not reported in the prior year audit. Recommendation We recommend the Organization establish internal controls to ensure the HRSA COVID-19 Uninsured Program is accurately reported on the SEFA and information provided for audit purposes is complete and accurate. View of Responsible Officials Since the inception of the program, the Organization reported the HRSA COVID-19 for the Uninsured based on payment date rather than on date of service/ incurred date. Once the error was identified, management properly reported and corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program.
Finding No. 2022-001 Federal Agency: U.S. Department of Health and Human Services Program Name: HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Assistance Listing Number: 93.461 Federal Award Year: July 1, 2021 ? June 30, 2022 Compliance Requirements: Other ? Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the entity?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Conditions Found Lehigh Valley Health Network and Subsidiaries (the ?Organization?) did not have adequate controls relating to the reporting of expenditures for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund (the ?Uninsured Program?) in the SEFA. Specifically, the amounts originally provided on the SEFA for the year ended June 30, 2022 for the Uninsured Program were based on when claim payments were received rather than when the services were provided for claim reimbursement. Once the error was identified, management corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program. Cause and Effect In discussing these conditions with management, they stated that sufficient controls were not in place to ensure that the date of the patient service or treatment was used to determine the appropriate amounts and year to include the payment received from HRSA on the SEFA. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with 2 CFR Part 200. Questioned Costs There are no questioned costs related to this finding. Statistical Sample Not applicable. Repeat Finding A similar finding was not reported in the prior year audit. Recommendation We recommend the Organization establish internal controls to ensure the HRSA COVID-19 Uninsured Program is accurately reported on the SEFA and information provided for audit purposes is complete and accurate. View of Responsible Officials Since the inception of the program, the Organization reported the HRSA COVID-19 for the Uninsured based on payment date rather than on date of service/ incurred date. Once the error was identified, management properly reported and corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program.
Finding No. 2022-001 Federal Agency: U.S. Department of Health and Human Services Program Name: HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Assistance Listing Number: 93.461 Federal Award Year: July 1, 2021 ? June 30, 2022 Compliance Requirements: Other ? Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the entity?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Conditions Found Lehigh Valley Health Network and Subsidiaries (the ?Organization?) did not have adequate controls relating to the reporting of expenditures for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund (the ?Uninsured Program?) in the SEFA. Specifically, the amounts originally provided on the SEFA for the year ended June 30, 2022 for the Uninsured Program were based on when claim payments were received rather than when the services were provided for claim reimbursement. Once the error was identified, management corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program. Cause and Effect In discussing these conditions with management, they stated that sufficient controls were not in place to ensure that the date of the patient service or treatment was used to determine the appropriate amounts and year to include the payment received from HRSA on the SEFA. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with 2 CFR Part 200. Questioned Costs There are no questioned costs related to this finding. Statistical Sample Not applicable. Repeat Finding A similar finding was not reported in the prior year audit. Recommendation We recommend the Organization establish internal controls to ensure the HRSA COVID-19 Uninsured Program is accurately reported on the SEFA and information provided for audit purposes is complete and accurate. View of Responsible Officials Since the inception of the program, the Organization reported the HRSA COVID-19 for the Uninsured based on payment date rather than on date of service/ incurred date. Once the error was identified, management properly reported and corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program.
Finding No. 2022-001 Federal Agency: U.S. Department of Health and Human Services Program Name: HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Assistance Listing Number: 93.461 Federal Award Year: July 1, 2021 ? June 30, 2022 Compliance Requirements: Other ? Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the entity?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Conditions Found Lehigh Valley Health Network and Subsidiaries (the ?Organization?) did not have adequate controls relating to the reporting of expenditures for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund (the ?Uninsured Program?) in the SEFA. Specifically, the amounts originally provided on the SEFA for the year ended June 30, 2022 for the Uninsured Program were based on when claim payments were received rather than when the services were provided for claim reimbursement. Once the error was identified, management corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program. Cause and Effect In discussing these conditions with management, they stated that sufficient controls were not in place to ensure that the date of the patient service or treatment was used to determine the appropriate amounts and year to include the payment received from HRSA on the SEFA. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with 2 CFR Part 200. Questioned Costs There are no questioned costs related to this finding. Statistical Sample Not applicable. Repeat Finding A similar finding was not reported in the prior year audit. Recommendation We recommend the Organization establish internal controls to ensure the HRSA COVID-19 Uninsured Program is accurately reported on the SEFA and information provided for audit purposes is complete and accurate. View of Responsible Officials Since the inception of the program, the Organization reported the HRSA COVID-19 for the Uninsured based on payment date rather than on date of service/ incurred date. Once the error was identified, management properly reported and corrected the SEFA for the year ended June 30, 2022 to reflect the total amount of claims for services provided during the year ended June 30, 2022 for the Uninsured Program.
2022 002 Assistance Listing Number, Federal Agency, and Program Name 93.498, Department of Health and Human Services, Provider Relief Fund and American Rescue Plan Rural Distribution Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Significant deficiency Repeat Finding No Criteria Per 2 CFR 200.508(b), an auditee must prepare appropriate financial statements, including the schedule of expenditures of federal awards, in accordance with 200.510 financial statements. Per 2 CFR 200.510(b), the auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502 basis for determining federal awards expended. Additionally, per the frequently asked questions published by HRSA, and in conjunction with the compliance supplement issued by the office of management and budget, recipients with fiscal year ends of June 30, 2021 should report the total expenditures from the Period 1 provider relief fund portal submission on the SEFA. Condition The Corporation did not prepare a complete and accurate SEFA for the year ended June 30, 2021. Questioned Costs N/A Identification of How Questioned Costs Were Computed N/A Context The Corporation's SEFA was understated for the year ended June 30, 2021 by $1,271,104. Management has acknowledged the SEFA was understated for 2021. The SEFA for June 30, 2022 is complete and accurate. Cause and Effect Management of the Corporation misunderstood guidance regarding preparation of the SEFA for the year ended June 30, 2021, resulting in the SEFA being incomplete for the year ended June 30, 2021. The $1,271,104 of funds not reported on the 2021 SEFA have been included on the SEFA for the year ended June 30, 2022. Recommendation Management should continue to monitor the SEFA reporting requirements issued by OMB and ensure all federal funding received is properly included on the SEFA in the proper period. Views of Responsible Officials and Corrective Action Plan While technically considered a significant deficiency and audit finding in accordance with CFR guidance for federal award audit compliance purposes, management considers this finding to be an isolated incident. Management had prepared and provided a SEFA summary that properly identified all federal funding, including all of the CARES Act funding, received as of June 30, 2021. Management also prepared and provided information regarding amounts of the CARES Act funding expended and recognized as revenue within the financial statements for the years ended June 30, 2020 and 2021. However, there was interpretation that the amount that was supposed to be reported for the CARES Act funding on the SEFA for the period ended June 30, 2021, should be the amount expended and recognized as revenue as of the financial statements ended June 30, 2020, to align with the Period 1 portal reporting. As such, the amount reported for the final SEFA used for the June 30, 2021 compliance audit excluded $1,271,104 that was appropriately reported as deferred grant revenue liability as of June 30, 2020. The amount of CARES Act funding for the Period 1 portal reporting correctly included the $1,271,104. There was a significant amount of collective confusion regarding the Period 1 CARES Act portal reporting which was for the period ended June 30, 2020, in relation to the SEFA reporting and compliance audit reporting for that same period of time, which was unusually deferred by the federal government from June 30, 2020 to June 30, 2021. The results of the auditors procedures demonstrated that all the information management populated in the CARES Act portal for the June 30, 2020 reporting compliance Period 1 was accurate and that there were no other findings.