Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards Background: The DOA, State Controller?s Office (SCO) is responsible for coordinating with the other state agencies to prepare the State of Wisconsin Schedule of Expenditures of Federal Awards (SEFA). The SEFA, which is required to be published in the State of Wisconsin single audit report, is a listing of all federal programs administered by an entity, includes the total expenditures for the reporting period, and identifies any amounts provided to subrecipients for each federal program. Each state agency, including DHS, prepares a SEFA for the federal programs that it administers and provides this to DOA SCO. DOA SCO compiles the agency-level SEFAs into the statewide SEFA. DOA SCO performs desk reviews of the agency-level SEFAs to ensure the expenditures reconcile to the accounting records in STAR, which is the State?s accounting system. Criteria: Under 2 CFR 200.510 (b), the State is required to prepare a SEFA for the period covered by the State's financial statements and the SEFA must include the total federal awards expended. Under 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Further, 2 CFR 200.514 indicates that the financial statements and SEFA must be for the same audit period. Finally, in accordance with Office of Management and Budget (OMB) Compliance Supplement, recipients and subrecipients of federal funding provided under the COVID-19 Emergency Acts, which includes funding the State received under the American Rescue Plan Act (ARPA), must separately identify the COVID-19 expenditures in the SEFA. Further, in its instructions to state agencies, DOA identified that separate reporting of COVID-19 Emergency Acts expenditures was required. Condition: We identified four concerns in our review of the DHS FY 2021-22 SEFA. First, we found DHS did not separately identify $329.2 million in FY 2021-22 expenditures as COVID-19 MA Program expenditures related to the enhanced federal medical assistance percentage for home and community-based services authorized under ARPA. Second, during FY 2021-22 DHS transferred $55.9 million in FY 2020-21 expenditures from the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) grant (Assistance Listing number 93.323) to the Disaster Grants?Public Assistance (Presidentially Declared Disasters) grant. In the STAR General Ledger, the prior-year transferred expenditures resulted in a reduction in the ELC grant expenditures. In reporting these amounts in the FY 2021-22 SEFA, DHS did not make a subsequent adjustment to remove the expenditure adjustment from the total expenditures reported for the ELC grant. Third, DHS did not report all CSLFRF expenditures it incurred in FY 2021-22. DHS requested reimbursement from DOA as it incurred expenditures under the CSLFRF grant. In its FY 2021-22 SEFA, DHS reported $161.9 million in CSLFRF expenditures, which was the total expenditures for which it had received reimbursement from DOA. However, DHS had actually incurred $173.6 million in CSLFRF expenditures in FY 2021-22. Finally, DHS included a $2.6 million repayment of a prior-year overpayment as an expenditure for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant. This should have been excluded from total expenditures because it did not relate to FY 2021-22 program expenditures. Context: The State administered and reported in its SEFA $20.2 billion in federal financial assistance in FY 2021-22. DHS administered $11.9 billion in federal financial assistance in FY 2021-22. We reviewed the DHS SEFA to assess the reported expenditures, particularly for major programs. Questioned Costs: None. Effect: Although total expenditures for the MA Program were accurately reported, DHS did not accurately report $329.2 million as COVID-19 expenditures separately in the SEFA. Further, DHS underreported expenditures by $55.9 million for the ELC grant, underreported expenditures by $11.7 million for CSLFRF, and overreported expenditure by $2.6 million for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Cause: DHS did not consider the new enhanced federal funding it received for home and community-based services as amounts that should be identified as COVID-19 expenditures when compiling the SEFA. DHS sought to reflect the expenditures for the grant programs based on the amounts recorded in the STAR General Ledger. However, DHS did not consider that the negative expenditures resulting from the transfers of FY 2020-21 expenditures led to the underreporting of the ELC grant expenditures in the DHS SEFA. Further, for the CSLFRF grant, DHS indicated that it thought it was appropriate to report only what had been reimbursed by DOA. Finally, DHS overlooked the inclusion of a repayment of a prior-year overpayment when reporting its expenditures for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Recommendation: We recommend the Wisconsin Department of Health Services further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is: -properly identifying applicable COVID-19 expenditures; -adjusting expenditures for prior-year transfers of expenditures in the current year; -reporting all federal expenditures for each federal grant program, regardless of whether the agency has received reimbursement from the pass-through entity; and -removing repayments of prior-year overpayments of expenditures from current-year expenditures. Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards WIC Special Supplemental Nutrition Program for Women, Infants, and Children (Assistance Listing number 10.557) Award Number Award Year 16W1006 2016 COVID-19?Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing number 21.027) Award Number Award Year None 2021 COVID-19?Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-06 2020 6 NU50CK000534-01-07 2020 6 NU50CK000534-01-08 2020 6 NU50CK000534-01-09 2021 6 NU50CK000534-02-00 2021 6 NU50CK000534-02-01 2021 6 NU50CK000534-02-05 2021 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-00 2020 6 NU50CK000534-01-01 2020 6 NU50CK000534-02-00 2021 COVID-19?Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Questioned Costs: None Type of Finding: Significant Deficiency, Noncompliance Response from the Wisconsin Department of Health Services: The Wisconsin Department of Health Services agrees with the audit finding and recommendations.
Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards Background: The DOA, State Controller?s Office (SCO) is responsible for coordinating with the other state agencies to prepare the State of Wisconsin Schedule of Expenditures of Federal Awards (SEFA). The SEFA, which is required to be published in the State of Wisconsin single audit report, is a listing of all federal programs administered by an entity, includes the total expenditures for the reporting period, and identifies any amounts provided to subrecipients for each federal program. Each state agency, including DHS, prepares a SEFA for the federal programs that it administers and provides this to DOA SCO. DOA SCO compiles the agency-level SEFAs into the statewide SEFA. DOA SCO performs desk reviews of the agency-level SEFAs to ensure the expenditures reconcile to the accounting records in STAR, which is the State?s accounting system. Criteria: Under 2 CFR 200.510 (b), the State is required to prepare a SEFA for the period covered by the State's financial statements and the SEFA must include the total federal awards expended. Under 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Further, 2 CFR 200.514 indicates that the financial statements and SEFA must be for the same audit period. Finally, in accordance with Office of Management and Budget (OMB) Compliance Supplement, recipients and subrecipients of federal funding provided under the COVID-19 Emergency Acts, which includes funding the State received under the American Rescue Plan Act (ARPA), must separately identify the COVID-19 expenditures in the SEFA. Further, in its instructions to state agencies, DOA identified that separate reporting of COVID-19 Emergency Acts expenditures was required. Condition: We identified four concerns in our review of the DHS FY 2021-22 SEFA. First, we found DHS did not separately identify $329.2 million in FY 2021-22 expenditures as COVID-19 MA Program expenditures related to the enhanced federal medical assistance percentage for home and community-based services authorized under ARPA. Second, during FY 2021-22 DHS transferred $55.9 million in FY 2020-21 expenditures from the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) grant (Assistance Listing number 93.323) to the Disaster Grants?Public Assistance (Presidentially Declared Disasters) grant. In the STAR General Ledger, the prior-year transferred expenditures resulted in a reduction in the ELC grant expenditures. In reporting these amounts in the FY 2021-22 SEFA, DHS did not make a subsequent adjustment to remove the expenditure adjustment from the total expenditures reported for the ELC grant. Third, DHS did not report all CSLFRF expenditures it incurred in FY 2021-22. DHS requested reimbursement from DOA as it incurred expenditures under the CSLFRF grant. In its FY 2021-22 SEFA, DHS reported $161.9 million in CSLFRF expenditures, which was the total expenditures for which it had received reimbursement from DOA. However, DHS had actually incurred $173.6 million in CSLFRF expenditures in FY 2021-22. Finally, DHS included a $2.6 million repayment of a prior-year overpayment as an expenditure for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant. This should have been excluded from total expenditures because it did not relate to FY 2021-22 program expenditures. Context: The State administered and reported in its SEFA $20.2 billion in federal financial assistance in FY 2021-22. DHS administered $11.9 billion in federal financial assistance in FY 2021-22. We reviewed the DHS SEFA to assess the reported expenditures, particularly for major programs. Questioned Costs: None. Effect: Although total expenditures for the MA Program were accurately reported, DHS did not accurately report $329.2 million as COVID-19 expenditures separately in the SEFA. Further, DHS underreported expenditures by $55.9 million for the ELC grant, underreported expenditures by $11.7 million for CSLFRF, and overreported expenditure by $2.6 million for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Cause: DHS did not consider the new enhanced federal funding it received for home and community-based services as amounts that should be identified as COVID-19 expenditures when compiling the SEFA. DHS sought to reflect the expenditures for the grant programs based on the amounts recorded in the STAR General Ledger. However, DHS did not consider that the negative expenditures resulting from the transfers of FY 2020-21 expenditures led to the underreporting of the ELC grant expenditures in the DHS SEFA. Further, for the CSLFRF grant, DHS indicated that it thought it was appropriate to report only what had been reimbursed by DOA. Finally, DHS overlooked the inclusion of a repayment of a prior-year overpayment when reporting its expenditures for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Recommendation: We recommend the Wisconsin Department of Health Services further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is: -properly identifying applicable COVID-19 expenditures; -adjusting expenditures for prior-year transfers of expenditures in the current year; -reporting all federal expenditures for each federal grant program, regardless of whether the agency has received reimbursement from the pass-through entity; and -removing repayments of prior-year overpayments of expenditures from current-year expenditures. Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards WIC Special Supplemental Nutrition Program for Women, Infants, and Children (Assistance Listing number 10.557) Award Number Award Year 16W1006 2016 COVID-19?Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing number 21.027) Award Number Award Year None 2021 COVID-19?Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-06 2020 6 NU50CK000534-01-07 2020 6 NU50CK000534-01-08 2020 6 NU50CK000534-01-09 2021 6 NU50CK000534-02-00 2021 6 NU50CK000534-02-01 2021 6 NU50CK000534-02-05 2021 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-00 2020 6 NU50CK000534-01-01 2020 6 NU50CK000534-02-00 2021 COVID-19?Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Questioned Costs: None Type of Finding: Significant Deficiency, Noncompliance Response from the Wisconsin Department of Health Services: The Wisconsin Department of Health Services agrees with the audit finding and recommendations.
Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards Background: The DOA, State Controller?s Office (SCO) is responsible for coordinating with the other state agencies to prepare the State of Wisconsin Schedule of Expenditures of Federal Awards (SEFA). The SEFA, which is required to be published in the State of Wisconsin single audit report, is a listing of all federal programs administered by an entity, includes the total expenditures for the reporting period, and identifies any amounts provided to subrecipients for each federal program. Each state agency, including DHS, prepares a SEFA for the federal programs that it administers and provides this to DOA SCO. DOA SCO compiles the agency-level SEFAs into the statewide SEFA. DOA SCO performs desk reviews of the agency-level SEFAs to ensure the expenditures reconcile to the accounting records in STAR, which is the State?s accounting system. Criteria: Under 2 CFR 200.510 (b), the State is required to prepare a SEFA for the period covered by the State's financial statements and the SEFA must include the total federal awards expended. Under 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Further, 2 CFR 200.514 indicates that the financial statements and SEFA must be for the same audit period. Finally, in accordance with Office of Management and Budget (OMB) Compliance Supplement, recipients and subrecipients of federal funding provided under the COVID-19 Emergency Acts, which includes funding the State received under the American Rescue Plan Act (ARPA), must separately identify the COVID-19 expenditures in the SEFA. Further, in its instructions to state agencies, DOA identified that separate reporting of COVID-19 Emergency Acts expenditures was required. Condition: We identified four concerns in our review of the DHS FY 2021-22 SEFA. First, we found DHS did not separately identify $329.2 million in FY 2021-22 expenditures as COVID-19 MA Program expenditures related to the enhanced federal medical assistance percentage for home and community-based services authorized under ARPA. Second, during FY 2021-22 DHS transferred $55.9 million in FY 2020-21 expenditures from the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) grant (Assistance Listing number 93.323) to the Disaster Grants?Public Assistance (Presidentially Declared Disasters) grant. In the STAR General Ledger, the prior-year transferred expenditures resulted in a reduction in the ELC grant expenditures. In reporting these amounts in the FY 2021-22 SEFA, DHS did not make a subsequent adjustment to remove the expenditure adjustment from the total expenditures reported for the ELC grant. Third, DHS did not report all CSLFRF expenditures it incurred in FY 2021-22. DHS requested reimbursement from DOA as it incurred expenditures under the CSLFRF grant. In its FY 2021-22 SEFA, DHS reported $161.9 million in CSLFRF expenditures, which was the total expenditures for which it had received reimbursement from DOA. However, DHS had actually incurred $173.6 million in CSLFRF expenditures in FY 2021-22. Finally, DHS included a $2.6 million repayment of a prior-year overpayment as an expenditure for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant. This should have been excluded from total expenditures because it did not relate to FY 2021-22 program expenditures. Context: The State administered and reported in its SEFA $20.2 billion in federal financial assistance in FY 2021-22. DHS administered $11.9 billion in federal financial assistance in FY 2021-22. We reviewed the DHS SEFA to assess the reported expenditures, particularly for major programs. Questioned Costs: None. Effect: Although total expenditures for the MA Program were accurately reported, DHS did not accurately report $329.2 million as COVID-19 expenditures separately in the SEFA. Further, DHS underreported expenditures by $55.9 million for the ELC grant, underreported expenditures by $11.7 million for CSLFRF, and overreported expenditure by $2.6 million for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Cause: DHS did not consider the new enhanced federal funding it received for home and community-based services as amounts that should be identified as COVID-19 expenditures when compiling the SEFA. DHS sought to reflect the expenditures for the grant programs based on the amounts recorded in the STAR General Ledger. However, DHS did not consider that the negative expenditures resulting from the transfers of FY 2020-21 expenditures led to the underreporting of the ELC grant expenditures in the DHS SEFA. Further, for the CSLFRF grant, DHS indicated that it thought it was appropriate to report only what had been reimbursed by DOA. Finally, DHS overlooked the inclusion of a repayment of a prior-year overpayment when reporting its expenditures for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Recommendation: We recommend the Wisconsin Department of Health Services further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is: -properly identifying applicable COVID-19 expenditures; -adjusting expenditures for prior-year transfers of expenditures in the current year; -reporting all federal expenditures for each federal grant program, regardless of whether the agency has received reimbursement from the pass-through entity; and -removing repayments of prior-year overpayments of expenditures from current-year expenditures. Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards WIC Special Supplemental Nutrition Program for Women, Infants, and Children (Assistance Listing number 10.557) Award Number Award Year 16W1006 2016 COVID-19?Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing number 21.027) Award Number Award Year None 2021 COVID-19?Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-06 2020 6 NU50CK000534-01-07 2020 6 NU50CK000534-01-08 2020 6 NU50CK000534-01-09 2021 6 NU50CK000534-02-00 2021 6 NU50CK000534-02-01 2021 6 NU50CK000534-02-05 2021 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-00 2020 6 NU50CK000534-01-01 2020 6 NU50CK000534-02-00 2021 COVID-19?Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Questioned Costs: None Type of Finding: Significant Deficiency, Noncompliance Response from the Wisconsin Department of Health Services: The Wisconsin Department of Health Services agrees with the audit finding and recommendations.
Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards Background: The DOA, State Controller?s Office (SCO) is responsible for coordinating with the other state agencies to prepare the State of Wisconsin Schedule of Expenditures of Federal Awards (SEFA). The SEFA, which is required to be published in the State of Wisconsin single audit report, is a listing of all federal programs administered by an entity, includes the total expenditures for the reporting period, and identifies any amounts provided to subrecipients for each federal program. Each state agency, including DHS, prepares a SEFA for the federal programs that it administers and provides this to DOA SCO. DOA SCO compiles the agency-level SEFAs into the statewide SEFA. DOA SCO performs desk reviews of the agency-level SEFAs to ensure the expenditures reconcile to the accounting records in STAR, which is the State?s accounting system. Criteria: Under 2 CFR 200.510 (b), the State is required to prepare a SEFA for the period covered by the State's financial statements and the SEFA must include the total federal awards expended. Under 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Further, 2 CFR 200.514 indicates that the financial statements and SEFA must be for the same audit period. Finally, in accordance with Office of Management and Budget (OMB) Compliance Supplement, recipients and subrecipients of federal funding provided under the COVID-19 Emergency Acts, which includes funding the State received under the American Rescue Plan Act (ARPA), must separately identify the COVID-19 expenditures in the SEFA. Further, in its instructions to state agencies, DOA identified that separate reporting of COVID-19 Emergency Acts expenditures was required. Condition: We identified four concerns in our review of the DHS FY 2021-22 SEFA. First, we found DHS did not separately identify $329.2 million in FY 2021-22 expenditures as COVID-19 MA Program expenditures related to the enhanced federal medical assistance percentage for home and community-based services authorized under ARPA. Second, during FY 2021-22 DHS transferred $55.9 million in FY 2020-21 expenditures from the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) grant (Assistance Listing number 93.323) to the Disaster Grants?Public Assistance (Presidentially Declared Disasters) grant. In the STAR General Ledger, the prior-year transferred expenditures resulted in a reduction in the ELC grant expenditures. In reporting these amounts in the FY 2021-22 SEFA, DHS did not make a subsequent adjustment to remove the expenditure adjustment from the total expenditures reported for the ELC grant. Third, DHS did not report all CSLFRF expenditures it incurred in FY 2021-22. DHS requested reimbursement from DOA as it incurred expenditures under the CSLFRF grant. In its FY 2021-22 SEFA, DHS reported $161.9 million in CSLFRF expenditures, which was the total expenditures for which it had received reimbursement from DOA. However, DHS had actually incurred $173.6 million in CSLFRF expenditures in FY 2021-22. Finally, DHS included a $2.6 million repayment of a prior-year overpayment as an expenditure for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant. This should have been excluded from total expenditures because it did not relate to FY 2021-22 program expenditures. Context: The State administered and reported in its SEFA $20.2 billion in federal financial assistance in FY 2021-22. DHS administered $11.9 billion in federal financial assistance in FY 2021-22. We reviewed the DHS SEFA to assess the reported expenditures, particularly for major programs. Questioned Costs: None. Effect: Although total expenditures for the MA Program were accurately reported, DHS did not accurately report $329.2 million as COVID-19 expenditures separately in the SEFA. Further, DHS underreported expenditures by $55.9 million for the ELC grant, underreported expenditures by $11.7 million for CSLFRF, and overreported expenditure by $2.6 million for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Cause: DHS did not consider the new enhanced federal funding it received for home and community-based services as amounts that should be identified as COVID-19 expenditures when compiling the SEFA. DHS sought to reflect the expenditures for the grant programs based on the amounts recorded in the STAR General Ledger. However, DHS did not consider that the negative expenditures resulting from the transfers of FY 2020-21 expenditures led to the underreporting of the ELC grant expenditures in the DHS SEFA. Further, for the CSLFRF grant, DHS indicated that it thought it was appropriate to report only what had been reimbursed by DOA. Finally, DHS overlooked the inclusion of a repayment of a prior-year overpayment when reporting its expenditures for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Recommendation: We recommend the Wisconsin Department of Health Services further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is: -properly identifying applicable COVID-19 expenditures; -adjusting expenditures for prior-year transfers of expenditures in the current year; -reporting all federal expenditures for each federal grant program, regardless of whether the agency has received reimbursement from the pass-through entity; and -removing repayments of prior-year overpayments of expenditures from current-year expenditures. Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards WIC Special Supplemental Nutrition Program for Women, Infants, and Children (Assistance Listing number 10.557) Award Number Award Year 16W1006 2016 COVID-19?Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing number 21.027) Award Number Award Year None 2021 COVID-19?Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-06 2020 6 NU50CK000534-01-07 2020 6 NU50CK000534-01-08 2020 6 NU50CK000534-01-09 2021 6 NU50CK000534-02-00 2021 6 NU50CK000534-02-01 2021 6 NU50CK000534-02-05 2021 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-00 2020 6 NU50CK000534-01-01 2020 6 NU50CK000534-02-00 2021 COVID-19?Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Questioned Costs: None Type of Finding: Significant Deficiency, Noncompliance Response from the Wisconsin Department of Health Services: The Wisconsin Department of Health Services agrees with the audit finding and recommendations.
Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards Background: The DOA, State Controller?s Office (SCO) is responsible for coordinating with the other state agencies to prepare the State of Wisconsin Schedule of Expenditures of Federal Awards (SEFA). The SEFA, which is required to be published in the State of Wisconsin single audit report, is a listing of all federal programs administered by an entity, includes the total expenditures for the reporting period, and identifies any amounts provided to subrecipients for each federal program. Each state agency, including DHS, prepares a SEFA for the federal programs that it administers and provides this to DOA SCO. DOA SCO compiles the agency-level SEFAs into the statewide SEFA. DOA SCO performs desk reviews of the agency-level SEFAs to ensure the expenditures reconcile to the accounting records in STAR, which is the State?s accounting system. Criteria: Under 2 CFR 200.510 (b), the State is required to prepare a SEFA for the period covered by the State's financial statements and the SEFA must include the total federal awards expended. Under 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Further, 2 CFR 200.514 indicates that the financial statements and SEFA must be for the same audit period. Finally, in accordance with Office of Management and Budget (OMB) Compliance Supplement, recipients and subrecipients of federal funding provided under the COVID-19 Emergency Acts, which includes funding the State received under the American Rescue Plan Act (ARPA), must separately identify the COVID-19 expenditures in the SEFA. Further, in its instructions to state agencies, DOA identified that separate reporting of COVID-19 Emergency Acts expenditures was required. Condition: We identified four concerns in our review of the DHS FY 2021-22 SEFA. First, we found DHS did not separately identify $329.2 million in FY 2021-22 expenditures as COVID-19 MA Program expenditures related to the enhanced federal medical assistance percentage for home and community-based services authorized under ARPA. Second, during FY 2021-22 DHS transferred $55.9 million in FY 2020-21 expenditures from the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) grant (Assistance Listing number 93.323) to the Disaster Grants?Public Assistance (Presidentially Declared Disasters) grant. In the STAR General Ledger, the prior-year transferred expenditures resulted in a reduction in the ELC grant expenditures. In reporting these amounts in the FY 2021-22 SEFA, DHS did not make a subsequent adjustment to remove the expenditure adjustment from the total expenditures reported for the ELC grant. Third, DHS did not report all CSLFRF expenditures it incurred in FY 2021-22. DHS requested reimbursement from DOA as it incurred expenditures under the CSLFRF grant. In its FY 2021-22 SEFA, DHS reported $161.9 million in CSLFRF expenditures, which was the total expenditures for which it had received reimbursement from DOA. However, DHS had actually incurred $173.6 million in CSLFRF expenditures in FY 2021-22. Finally, DHS included a $2.6 million repayment of a prior-year overpayment as an expenditure for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant. This should have been excluded from total expenditures because it did not relate to FY 2021-22 program expenditures. Context: The State administered and reported in its SEFA $20.2 billion in federal financial assistance in FY 2021-22. DHS administered $11.9 billion in federal financial assistance in FY 2021-22. We reviewed the DHS SEFA to assess the reported expenditures, particularly for major programs. Questioned Costs: None. Effect: Although total expenditures for the MA Program were accurately reported, DHS did not accurately report $329.2 million as COVID-19 expenditures separately in the SEFA. Further, DHS underreported expenditures by $55.9 million for the ELC grant, underreported expenditures by $11.7 million for CSLFRF, and overreported expenditure by $2.6 million for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Cause: DHS did not consider the new enhanced federal funding it received for home and community-based services as amounts that should be identified as COVID-19 expenditures when compiling the SEFA. DHS sought to reflect the expenditures for the grant programs based on the amounts recorded in the STAR General Ledger. However, DHS did not consider that the negative expenditures resulting from the transfers of FY 2020-21 expenditures led to the underreporting of the ELC grant expenditures in the DHS SEFA. Further, for the CSLFRF grant, DHS indicated that it thought it was appropriate to report only what had been reimbursed by DOA. Finally, DHS overlooked the inclusion of a repayment of a prior-year overpayment when reporting its expenditures for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Recommendation: We recommend the Wisconsin Department of Health Services further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is: -properly identifying applicable COVID-19 expenditures; -adjusting expenditures for prior-year transfers of expenditures in the current year; -reporting all federal expenditures for each federal grant program, regardless of whether the agency has received reimbursement from the pass-through entity; and -removing repayments of prior-year overpayments of expenditures from current-year expenditures. Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards WIC Special Supplemental Nutrition Program for Women, Infants, and Children (Assistance Listing number 10.557) Award Number Award Year 16W1006 2016 COVID-19?Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing number 21.027) Award Number Award Year None 2021 COVID-19?Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-06 2020 6 NU50CK000534-01-07 2020 6 NU50CK000534-01-08 2020 6 NU50CK000534-01-09 2021 6 NU50CK000534-02-00 2021 6 NU50CK000534-02-01 2021 6 NU50CK000534-02-05 2021 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-00 2020 6 NU50CK000534-01-01 2020 6 NU50CK000534-02-00 2021 COVID-19?Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Questioned Costs: None Type of Finding: Significant Deficiency, Noncompliance Response from the Wisconsin Department of Health Services: The Wisconsin Department of Health Services agrees with the audit finding and recommendations.
Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards Background: The DOA, State Controller?s Office (SCO) is responsible for coordinating with the other state agencies to prepare the State of Wisconsin Schedule of Expenditures of Federal Awards (SEFA). The SEFA, which is required to be published in the State of Wisconsin single audit report, is a listing of all federal programs administered by an entity, includes the total expenditures for the reporting period, and identifies any amounts provided to subrecipients for each federal program. Each state agency, including DHS, prepares a SEFA for the federal programs that it administers and provides this to DOA SCO. DOA SCO compiles the agency-level SEFAs into the statewide SEFA. DOA SCO performs desk reviews of the agency-level SEFAs to ensure the expenditures reconcile to the accounting records in STAR, which is the State?s accounting system. Criteria: Under 2 CFR 200.510 (b), the State is required to prepare a SEFA for the period covered by the State's financial statements and the SEFA must include the total federal awards expended. Under 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Further, 2 CFR 200.514 indicates that the financial statements and SEFA must be for the same audit period. Finally, in accordance with Office of Management and Budget (OMB) Compliance Supplement, recipients and subrecipients of federal funding provided under the COVID-19 Emergency Acts, which includes funding the State received under the American Rescue Plan Act (ARPA), must separately identify the COVID-19 expenditures in the SEFA. Further, in its instructions to state agencies, DOA identified that separate reporting of COVID-19 Emergency Acts expenditures was required. Condition: We identified four concerns in our review of the DHS FY 2021-22 SEFA. First, we found DHS did not separately identify $329.2 million in FY 2021-22 expenditures as COVID-19 MA Program expenditures related to the enhanced federal medical assistance percentage for home and community-based services authorized under ARPA. Second, during FY 2021-22 DHS transferred $55.9 million in FY 2020-21 expenditures from the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) grant (Assistance Listing number 93.323) to the Disaster Grants?Public Assistance (Presidentially Declared Disasters) grant. In the STAR General Ledger, the prior-year transferred expenditures resulted in a reduction in the ELC grant expenditures. In reporting these amounts in the FY 2021-22 SEFA, DHS did not make a subsequent adjustment to remove the expenditure adjustment from the total expenditures reported for the ELC grant. Third, DHS did not report all CSLFRF expenditures it incurred in FY 2021-22. DHS requested reimbursement from DOA as it incurred expenditures under the CSLFRF grant. In its FY 2021-22 SEFA, DHS reported $161.9 million in CSLFRF expenditures, which was the total expenditures for which it had received reimbursement from DOA. However, DHS had actually incurred $173.6 million in CSLFRF expenditures in FY 2021-22. Finally, DHS included a $2.6 million repayment of a prior-year overpayment as an expenditure for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant. This should have been excluded from total expenditures because it did not relate to FY 2021-22 program expenditures. Context: The State administered and reported in its SEFA $20.2 billion in federal financial assistance in FY 2021-22. DHS administered $11.9 billion in federal financial assistance in FY 2021-22. We reviewed the DHS SEFA to assess the reported expenditures, particularly for major programs. Questioned Costs: None. Effect: Although total expenditures for the MA Program were accurately reported, DHS did not accurately report $329.2 million as COVID-19 expenditures separately in the SEFA. Further, DHS underreported expenditures by $55.9 million for the ELC grant, underreported expenditures by $11.7 million for CSLFRF, and overreported expenditure by $2.6 million for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Cause: DHS did not consider the new enhanced federal funding it received for home and community-based services as amounts that should be identified as COVID-19 expenditures when compiling the SEFA. DHS sought to reflect the expenditures for the grant programs based on the amounts recorded in the STAR General Ledger. However, DHS did not consider that the negative expenditures resulting from the transfers of FY 2020-21 expenditures led to the underreporting of the ELC grant expenditures in the DHS SEFA. Further, for the CSLFRF grant, DHS indicated that it thought it was appropriate to report only what had been reimbursed by DOA. Finally, DHS overlooked the inclusion of a repayment of a prior-year overpayment when reporting its expenditures for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Recommendation: We recommend the Wisconsin Department of Health Services further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is: -properly identifying applicable COVID-19 expenditures; -adjusting expenditures for prior-year transfers of expenditures in the current year; -reporting all federal expenditures for each federal grant program, regardless of whether the agency has received reimbursement from the pass-through entity; and -removing repayments of prior-year overpayments of expenditures from current-year expenditures. Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards WIC Special Supplemental Nutrition Program for Women, Infants, and Children (Assistance Listing number 10.557) Award Number Award Year 16W1006 2016 COVID-19?Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing number 21.027) Award Number Award Year None 2021 COVID-19?Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-06 2020 6 NU50CK000534-01-07 2020 6 NU50CK000534-01-08 2020 6 NU50CK000534-01-09 2021 6 NU50CK000534-02-00 2021 6 NU50CK000534-02-01 2021 6 NU50CK000534-02-05 2021 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-00 2020 6 NU50CK000534-01-01 2020 6 NU50CK000534-02-00 2021 COVID-19?Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Questioned Costs: None Type of Finding: Significant Deficiency, Noncompliance Response from the Wisconsin Department of Health Services: The Wisconsin Department of Health Services agrees with the audit finding and recommendations.
Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards Background: The DOA, State Controller?s Office (SCO) is responsible for coordinating with the other state agencies to prepare the State of Wisconsin Schedule of Expenditures of Federal Awards (SEFA). The SEFA, which is required to be published in the State of Wisconsin single audit report, is a listing of all federal programs administered by an entity, includes the total expenditures for the reporting period, and identifies any amounts provided to subrecipients for each federal program. Each state agency, including DHS, prepares a SEFA for the federal programs that it administers and provides this to DOA SCO. DOA SCO compiles the agency-level SEFAs into the statewide SEFA. DOA SCO performs desk reviews of the agency-level SEFAs to ensure the expenditures reconcile to the accounting records in STAR, which is the State?s accounting system. Criteria: Under 2 CFR 200.510 (b), the State is required to prepare a SEFA for the period covered by the State's financial statements and the SEFA must include the total federal awards expended. Under 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Further, 2 CFR 200.514 indicates that the financial statements and SEFA must be for the same audit period. Finally, in accordance with Office of Management and Budget (OMB) Compliance Supplement, recipients and subrecipients of federal funding provided under the COVID-19 Emergency Acts, which includes funding the State received under the American Rescue Plan Act (ARPA), must separately identify the COVID-19 expenditures in the SEFA. Further, in its instructions to state agencies, DOA identified that separate reporting of COVID-19 Emergency Acts expenditures was required. Condition: We identified four concerns in our review of the DHS FY 2021-22 SEFA. First, we found DHS did not separately identify $329.2 million in FY 2021-22 expenditures as COVID-19 MA Program expenditures related to the enhanced federal medical assistance percentage for home and community-based services authorized under ARPA. Second, during FY 2021-22 DHS transferred $55.9 million in FY 2020-21 expenditures from the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) grant (Assistance Listing number 93.323) to the Disaster Grants?Public Assistance (Presidentially Declared Disasters) grant. In the STAR General Ledger, the prior-year transferred expenditures resulted in a reduction in the ELC grant expenditures. In reporting these amounts in the FY 2021-22 SEFA, DHS did not make a subsequent adjustment to remove the expenditure adjustment from the total expenditures reported for the ELC grant. Third, DHS did not report all CSLFRF expenditures it incurred in FY 2021-22. DHS requested reimbursement from DOA as it incurred expenditures under the CSLFRF grant. In its FY 2021-22 SEFA, DHS reported $161.9 million in CSLFRF expenditures, which was the total expenditures for which it had received reimbursement from DOA. However, DHS had actually incurred $173.6 million in CSLFRF expenditures in FY 2021-22. Finally, DHS included a $2.6 million repayment of a prior-year overpayment as an expenditure for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant. This should have been excluded from total expenditures because it did not relate to FY 2021-22 program expenditures. Context: The State administered and reported in its SEFA $20.2 billion in federal financial assistance in FY 2021-22. DHS administered $11.9 billion in federal financial assistance in FY 2021-22. We reviewed the DHS SEFA to assess the reported expenditures, particularly for major programs. Questioned Costs: None. Effect: Although total expenditures for the MA Program were accurately reported, DHS did not accurately report $329.2 million as COVID-19 expenditures separately in the SEFA. Further, DHS underreported expenditures by $55.9 million for the ELC grant, underreported expenditures by $11.7 million for CSLFRF, and overreported expenditure by $2.6 million for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Cause: DHS did not consider the new enhanced federal funding it received for home and community-based services as amounts that should be identified as COVID-19 expenditures when compiling the SEFA. DHS sought to reflect the expenditures for the grant programs based on the amounts recorded in the STAR General Ledger. However, DHS did not consider that the negative expenditures resulting from the transfers of FY 2020-21 expenditures led to the underreporting of the ELC grant expenditures in the DHS SEFA. Further, for the CSLFRF grant, DHS indicated that it thought it was appropriate to report only what had been reimbursed by DOA. Finally, DHS overlooked the inclusion of a repayment of a prior-year overpayment when reporting its expenditures for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Recommendation: We recommend the Wisconsin Department of Health Services further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is: -properly identifying applicable COVID-19 expenditures; -adjusting expenditures for prior-year transfers of expenditures in the current year; -reporting all federal expenditures for each federal grant program, regardless of whether the agency has received reimbursement from the pass-through entity; and -removing repayments of prior-year overpayments of expenditures from current-year expenditures. Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards WIC Special Supplemental Nutrition Program for Women, Infants, and Children (Assistance Listing number 10.557) Award Number Award Year 16W1006 2016 COVID-19?Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing number 21.027) Award Number Award Year None 2021 COVID-19?Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-06 2020 6 NU50CK000534-01-07 2020 6 NU50CK000534-01-08 2020 6 NU50CK000534-01-09 2021 6 NU50CK000534-02-00 2021 6 NU50CK000534-02-01 2021 6 NU50CK000534-02-05 2021 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-00 2020 6 NU50CK000534-01-01 2020 6 NU50CK000534-02-00 2021 COVID-19?Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Questioned Costs: None Type of Finding: Significant Deficiency, Noncompliance Response from the Wisconsin Department of Health Services: The Wisconsin Department of Health Services agrees with the audit finding and recommendations.
Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards Background: The DOA, State Controller?s Office (SCO) is responsible for coordinating with the other state agencies to prepare the State of Wisconsin Schedule of Expenditures of Federal Awards (SEFA). The SEFA, which is required to be published in the State of Wisconsin single audit report, is a listing of all federal programs administered by an entity, includes the total expenditures for the reporting period, and identifies any amounts provided to subrecipients for each federal program. Each state agency, including DHS, prepares a SEFA for the federal programs that it administers and provides this to DOA SCO. DOA SCO compiles the agency-level SEFAs into the statewide SEFA. DOA SCO performs desk reviews of the agency-level SEFAs to ensure the expenditures reconcile to the accounting records in STAR, which is the State?s accounting system. Criteria: Under 2 CFR 200.510 (b), the State is required to prepare a SEFA for the period covered by the State's financial statements and the SEFA must include the total federal awards expended. Under 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Further, 2 CFR 200.514 indicates that the financial statements and SEFA must be for the same audit period. Finally, in accordance with Office of Management and Budget (OMB) Compliance Supplement, recipients and subrecipients of federal funding provided under the COVID-19 Emergency Acts, which includes funding the State received under the American Rescue Plan Act (ARPA), must separately identify the COVID-19 expenditures in the SEFA. Further, in its instructions to state agencies, DOA identified that separate reporting of COVID-19 Emergency Acts expenditures was required. Condition: We identified four concerns in our review of the DHS FY 2021-22 SEFA. First, we found DHS did not separately identify $329.2 million in FY 2021-22 expenditures as COVID-19 MA Program expenditures related to the enhanced federal medical assistance percentage for home and community-based services authorized under ARPA. Second, during FY 2021-22 DHS transferred $55.9 million in FY 2020-21 expenditures from the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) grant (Assistance Listing number 93.323) to the Disaster Grants?Public Assistance (Presidentially Declared Disasters) grant. In the STAR General Ledger, the prior-year transferred expenditures resulted in a reduction in the ELC grant expenditures. In reporting these amounts in the FY 2021-22 SEFA, DHS did not make a subsequent adjustment to remove the expenditure adjustment from the total expenditures reported for the ELC grant. Third, DHS did not report all CSLFRF expenditures it incurred in FY 2021-22. DHS requested reimbursement from DOA as it incurred expenditures under the CSLFRF grant. In its FY 2021-22 SEFA, DHS reported $161.9 million in CSLFRF expenditures, which was the total expenditures for which it had received reimbursement from DOA. However, DHS had actually incurred $173.6 million in CSLFRF expenditures in FY 2021-22. Finally, DHS included a $2.6 million repayment of a prior-year overpayment as an expenditure for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant. This should have been excluded from total expenditures because it did not relate to FY 2021-22 program expenditures. Context: The State administered and reported in its SEFA $20.2 billion in federal financial assistance in FY 2021-22. DHS administered $11.9 billion in federal financial assistance in FY 2021-22. We reviewed the DHS SEFA to assess the reported expenditures, particularly for major programs. Questioned Costs: None. Effect: Although total expenditures for the MA Program were accurately reported, DHS did not accurately report $329.2 million as COVID-19 expenditures separately in the SEFA. Further, DHS underreported expenditures by $55.9 million for the ELC grant, underreported expenditures by $11.7 million for CSLFRF, and overreported expenditure by $2.6 million for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Cause: DHS did not consider the new enhanced federal funding it received for home and community-based services as amounts that should be identified as COVID-19 expenditures when compiling the SEFA. DHS sought to reflect the expenditures for the grant programs based on the amounts recorded in the STAR General Ledger. However, DHS did not consider that the negative expenditures resulting from the transfers of FY 2020-21 expenditures led to the underreporting of the ELC grant expenditures in the DHS SEFA. Further, for the CSLFRF grant, DHS indicated that it thought it was appropriate to report only what had been reimbursed by DOA. Finally, DHS overlooked the inclusion of a repayment of a prior-year overpayment when reporting its expenditures for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Recommendation: We recommend the Wisconsin Department of Health Services further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is: -properly identifying applicable COVID-19 expenditures; -adjusting expenditures for prior-year transfers of expenditures in the current year; -reporting all federal expenditures for each federal grant program, regardless of whether the agency has received reimbursement from the pass-through entity; and -removing repayments of prior-year overpayments of expenditures from current-year expenditures. Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards WIC Special Supplemental Nutrition Program for Women, Infants, and Children (Assistance Listing number 10.557) Award Number Award Year 16W1006 2016 COVID-19?Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing number 21.027) Award Number Award Year None 2021 COVID-19?Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-06 2020 6 NU50CK000534-01-07 2020 6 NU50CK000534-01-08 2020 6 NU50CK000534-01-09 2021 6 NU50CK000534-02-00 2021 6 NU50CK000534-02-01 2021 6 NU50CK000534-02-05 2021 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-00 2020 6 NU50CK000534-01-01 2020 6 NU50CK000534-02-00 2021 COVID-19?Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Questioned Costs: None Type of Finding: Significant Deficiency, Noncompliance Response from the Wisconsin Department of Health Services: The Wisconsin Department of Health Services agrees with the audit finding and recommendations.
Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards Background: The DOA, State Controller?s Office (SCO) is responsible for coordinating with the other state agencies to prepare the State of Wisconsin Schedule of Expenditures of Federal Awards (SEFA). The SEFA, which is required to be published in the State of Wisconsin single audit report, is a listing of all federal programs administered by an entity, includes the total expenditures for the reporting period, and identifies any amounts provided to subrecipients for each federal program. Each state agency, including DHS, prepares a SEFA for the federal programs that it administers and provides this to DOA SCO. DOA SCO compiles the agency-level SEFAs into the statewide SEFA. DOA SCO performs desk reviews of the agency-level SEFAs to ensure the expenditures reconcile to the accounting records in STAR, which is the State?s accounting system. Criteria: Under 2 CFR 200.510 (b), the State is required to prepare a SEFA for the period covered by the State's financial statements and the SEFA must include the total federal awards expended. Under 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Further, 2 CFR 200.514 indicates that the financial statements and SEFA must be for the same audit period. Finally, in accordance with Office of Management and Budget (OMB) Compliance Supplement, recipients and subrecipients of federal funding provided under the COVID-19 Emergency Acts, which includes funding the State received under the American Rescue Plan Act (ARPA), must separately identify the COVID-19 expenditures in the SEFA. Further, in its instructions to state agencies, DOA identified that separate reporting of COVID-19 Emergency Acts expenditures was required. Condition: We identified four concerns in our review of the DHS FY 2021-22 SEFA. First, we found DHS did not separately identify $329.2 million in FY 2021-22 expenditures as COVID-19 MA Program expenditures related to the enhanced federal medical assistance percentage for home and community-based services authorized under ARPA. Second, during FY 2021-22 DHS transferred $55.9 million in FY 2020-21 expenditures from the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) grant (Assistance Listing number 93.323) to the Disaster Grants?Public Assistance (Presidentially Declared Disasters) grant. In the STAR General Ledger, the prior-year transferred expenditures resulted in a reduction in the ELC grant expenditures. In reporting these amounts in the FY 2021-22 SEFA, DHS did not make a subsequent adjustment to remove the expenditure adjustment from the total expenditures reported for the ELC grant. Third, DHS did not report all CSLFRF expenditures it incurred in FY 2021-22. DHS requested reimbursement from DOA as it incurred expenditures under the CSLFRF grant. In its FY 2021-22 SEFA, DHS reported $161.9 million in CSLFRF expenditures, which was the total expenditures for which it had received reimbursement from DOA. However, DHS had actually incurred $173.6 million in CSLFRF expenditures in FY 2021-22. Finally, DHS included a $2.6 million repayment of a prior-year overpayment as an expenditure for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant. This should have been excluded from total expenditures because it did not relate to FY 2021-22 program expenditures. Context: The State administered and reported in its SEFA $20.2 billion in federal financial assistance in FY 2021-22. DHS administered $11.9 billion in federal financial assistance in FY 2021-22. We reviewed the DHS SEFA to assess the reported expenditures, particularly for major programs. Questioned Costs: None. Effect: Although total expenditures for the MA Program were accurately reported, DHS did not accurately report $329.2 million as COVID-19 expenditures separately in the SEFA. Further, DHS underreported expenditures by $55.9 million for the ELC grant, underreported expenditures by $11.7 million for CSLFRF, and overreported expenditure by $2.6 million for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Cause: DHS did not consider the new enhanced federal funding it received for home and community-based services as amounts that should be identified as COVID-19 expenditures when compiling the SEFA. DHS sought to reflect the expenditures for the grant programs based on the amounts recorded in the STAR General Ledger. However, DHS did not consider that the negative expenditures resulting from the transfers of FY 2020-21 expenditures led to the underreporting of the ELC grant expenditures in the DHS SEFA. Further, for the CSLFRF grant, DHS indicated that it thought it was appropriate to report only what had been reimbursed by DOA. Finally, DHS overlooked the inclusion of a repayment of a prior-year overpayment when reporting its expenditures for the WIC Special Supplemental Nutrition Program for Women, Infants, and Children grant program. Recommendation: We recommend the Wisconsin Department of Health Services further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is: -properly identifying applicable COVID-19 expenditures; -adjusting expenditures for prior-year transfers of expenditures in the current year; -reporting all federal expenditures for each federal grant program, regardless of whether the agency has received reimbursement from the pass-through entity; and -removing repayments of prior-year overpayments of expenditures from current-year expenditures. Finding 2022-302: Multiple Grants?Reporting in the Schedule of Expenditures of Federal Awards WIC Special Supplemental Nutrition Program for Women, Infants, and Children (Assistance Listing number 10.557) Award Number Award Year 16W1006 2016 COVID-19?Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing number 21.027) Award Number Award Year None 2021 COVID-19?Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-06 2020 6 NU50CK000534-01-07 2020 6 NU50CK000534-01-08 2020 6 NU50CK000534-01-09 2021 6 NU50CK000534-02-00 2021 6 NU50CK000534-02-01 2021 6 NU50CK000534-02-05 2021 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (Assistance Listing number 93.323) Award Numbers Award Years 6 NU50CK000534-01-00 2020 6 NU50CK000534-01-01 2020 6 NU50CK000534-02-00 2021 COVID-19?Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Medical Assistance Program (Assistance Listing number 93.778) Award Numbers Award Years 2105WI5MAP 2021 2205WI5MAP 2022 Questioned Costs: None Type of Finding: Significant Deficiency, Noncompliance Response from the Wisconsin Department of Health Services: The Wisconsin Department of Health Services agrees with the audit finding and recommendations.
2022 ? 002: SEFA Reporting Federal Agency: U.S. Department of Agriculture, U.S. Department of Health And Human Services Federal Program Title: Cooperative Extension (ASU and MSU), Maternal & Child Health Federal Consolidated Programs (UMMC) ALNs: 10.500 (ASU, MSU) ; 93.110 (UMMC) Federal Award Identification Number and Year: Various Award Period: July 1, 2021 to June 30, 2022 Type of Finding: Material Weakness in Internal Control over Compliance Applicable Institutions: Alcorn State University (ASU), Mississippi State University (MSU), University of Mississippi Medical Center (UMMC) Criteria or specific requirement: 2 CFR, Part 200 ? Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, ?200.510(b) requires that auditees 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. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned costs: None Context: The following SEFA errors were noted: ? ASU- incorrectly reported $2,255,873 in expenditures as 10.500 that should have been coded to 10.512, 10.514 or 10.515 ? MSU- incorrectly reported $8,912,566 in expenditures as 10.500 that should have been coded to 10.511, 10.514 or 10.515 ? UMMC- incorrectly excluded $16,959,752 in F&A costs from the SEFA. Cause: ? ASU - CFDA numbers were not properly identified/coded in banner. And inherently, were not cross referenced with NIFA Notice of Awards Face for those referenced awards resulting in incorrect reporting on the SEFA. ? MSU misclassified MSU Cooperative Extension funds as 10.500 due to human transcription error. ? UMMC - Accounting data is accurately recorded in Workday. UMMC professionals erroneously generated and submitted an internal version of the SEFA report from Workday, which was built to exclude F&A cost items. The use of the wrong report was not identified by UMMC professionals, due to a lack of performance of sufficient post-generation quality review over balances. The root cause of which was a vacancy within a key role in the process of SEFA reporting, the Director, Post-Award. Due to the vacancy, others without the requisite knowledge and experience, were required to step in to generate the SEFA report. This lack of knowledge lead to the selection of the wrong report in Workday, as well as, the lack of sufficient post-generation quality review of the report. Effect: The SEFA was not prepared in accordance with OMB requirements and resulted in an incorrect major program risk assessment for federal programs during planning that was subsequently corrected and included for major program selection. Repeat Finding: No Recommendation: We recommend the institutions review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of responsible officials: There is no disagreement with the audit finding.
2022 ? 006: SEFA Reporting Federal Agency: U.S. Department of Education Federal Program Title: Education Stabilization Fund ALN: 84.425F Federal Award Identification Number and Year: P425F202078 (5/7/2020 ? 5/13/2022) Award Period: July 1, 2021 to June 30, 2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Applicable Institution: Mississippi Valley State University Criteria or specific requirement: 2 CFR, Part 200 ? Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, ?200.510(b) requires that auditees 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. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information. Questioned costs: $367,461 Context: The institution incorrectly duplicated $367,461 of FY21 expenditures on the FY22 SEFA. Cause: The $367,461 of FY21 was inadvertently posted in error due to an attempt to correct the banner organization codes posted incorrectly. Effect: The SEFA was not prepared in accordance with OMB requirements. Repeat Finding: No Recommendation: We recommend the institutions review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of responsible officials: There is no disagreement with the audit finding.
2022 ? 002: SEFA Reporting Federal Agency: U.S. Department of Agriculture, U.S. Department of Health And Human Services Federal Program Title: Cooperative Extension (ASU and MSU), Maternal & Child Health Federal Consolidated Programs (UMMC) ALNs: 10.500 (ASU, MSU) ; 93.110 (UMMC) Federal Award Identification Number and Year: Various Award Period: July 1, 2021 to June 30, 2022 Type of Finding: Material Weakness in Internal Control over Compliance Applicable Institutions: Alcorn State University (ASU), Mississippi State University (MSU), University of Mississippi Medical Center (UMMC) Criteria or specific requirement: 2 CFR, Part 200 ? Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, ?200.510(b) requires that auditees 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. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned costs: None Context: The following SEFA errors were noted: ? ASU- incorrectly reported $2,255,873 in expenditures as 10.500 that should have been coded to 10.512, 10.514 or 10.515 ? MSU- incorrectly reported $8,912,566 in expenditures as 10.500 that should have been coded to 10.511, 10.514 or 10.515 ? UMMC- incorrectly excluded $16,959,752 in F&A costs from the SEFA. Cause: ? ASU - CFDA numbers were not properly identified/coded in banner. And inherently, were not cross referenced with NIFA Notice of Awards Face for those referenced awards resulting in incorrect reporting on the SEFA. ? MSU misclassified MSU Cooperative Extension funds as 10.500 due to human transcription error. ? UMMC - Accounting data is accurately recorded in Workday. UMMC professionals erroneously generated and submitted an internal version of the SEFA report from Workday, which was built to exclude F&A cost items. The use of the wrong report was not identified by UMMC professionals, due to a lack of performance of sufficient post-generation quality review over balances. The root cause of which was a vacancy within a key role in the process of SEFA reporting, the Director, Post-Award. Due to the vacancy, others without the requisite knowledge and experience, were required to step in to generate the SEFA report. This lack of knowledge lead to the selection of the wrong report in Workday, as well as, the lack of sufficient post-generation quality review of the report. Effect: The SEFA was not prepared in accordance with OMB requirements and resulted in an incorrect major program risk assessment for federal programs during planning that was subsequently corrected and included for major program selection. Repeat Finding: No Recommendation: We recommend the institutions review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of responsible officials: There is no disagreement with the audit finding.
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
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.