Identification of the Federal Program - Community Programs to Improve Minority Health Grant Program- Assistance Listing Number 93.137 Criteria - Per 2 CFR 200.332, Requirements for Pass-Through Entities, the City is required to monitor the subrecipients activities to ensure that the grant funds are used for authorized purposes by reviewing financial and performance reports that were required by the City. The City was also required by 2 CFR 200.332 to verify that each of their subrecipients had a single audit performed if their federal expenditures exceeded $750,000. In the Notice of Award, the Department of Health and Human Services required the City to create and provide to the Department a subrecipient monitoring plan as well as use that plan to monitor each of the City’s subrecipients. In the subrecipient monitoring plan, the City was required to perform the following steps: •Regularly communicate at least once a month with subrecipients to ensure that the project is beingcarried out as proposed and according to schedule. •Review and approve periodic technical/performance reports. •Review and approve subrecipient invoices. •Monitor general rate of expenditures and implementation of activities. •Review each subrecipient monthly through the subrecipients preparation of the City’s SubrecipientDesk Review form. •Perform an annual review for each subrecipient through the preparation of the Annual SubrecipientField Review form using the monthly desk review forms. 2 CFR 200.303, Internal Controls, requires that recipients establish and maintain effective internal control over Federal awards that provides reasonable assurance that the recipient is managing Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal awards. Condition - There was a lack of subrecipient monitoring and appropriate review by the City. The City did not effectively monitor subrecipient activities to ensure the proper utilization of grant funds. There was a lack of documented evidence demonstrating the monitoring of subrecipients. The City also failed to verify whether each of their subrecipients met the threshold of $750,000 in federal expenditures and subsequently underwent a single audit. There is no documented evidence indicating that the City systematically reviewed the subrecipient expenditures to ensure compliance with this requirement. Effect - Without proper documentation and monitoring, there is an increased likelihood of financial mismanagement, misuse of funds, and noncompliance with grant terms and regulations. Additionally, the absence of adequate records impedes transparency and accountability in the use of federal funds. This deficiency also may result in undetected instances of subrecipients failing to undergo required single audits. Cause - The absence of robust monitoring procedures may stem from insufficient staff training on federal grant requirements, a lack of awareness regarding the importance of maintaining accurate records and conducting thorough monitoring of subrecipient activities, a lack of established processes for reviewing financial and performance reports, or inadequate internal controls. Additionally, there may be a lack of clear communication and accountability regarding subrecipient monitoring roles and responsibilities. Recommendation - The City should establish and enforce comprehensive subrecipient monitoring protocols. This includes developing standardized monitoring procedures, providing staff training on monitoring requirements, allocating sufficient resources for monitoring activities, and implementing mechanisms for regular review and documentation of monitoring efforts. By strengthening subrecipient monitoring practices, the City can mitigate risks, ensure compliance with grant requirements, and safeguard the effective utilization of grant funds. Views of Responsible Officials - The City agrees with the finding. The City will implement additional subrecipient monitoring procedures.
2023-001 – Communications with Subrecipients (repeat comment) Finding Type: Significant Deficiency in internal control over compliance / noncompliance Program: ALN 93.959 – Prevention ALN 93.959 – COVID-19 – Treatment ALN 93.959 – COVID-19 – Prevention II ALN 93.959 – COVID-19 – ARPA Prevention Criteria: As required by 2 CFR 200.332, the pass-through entity must communicate specific information to subrecipients, as applicable. Condition: Contracts with subrecipients did not include portions of required disclosures. Cause/Effect: Inadequate internal controls over compliance. Select contracts were not in compliance with 2 CFR 200.332. Questioned Cost: None. Recommendation: We recommend that the PIHP update all contracts with subrecipients to include required language. View of Responsible Official: Management is in agreement with this recommendation.
2023-001 – Communications with Subrecipients (repeat comment) Finding Type: Significant Deficiency in internal control over compliance / noncompliance Program: ALN 93.959 – Prevention ALN 93.959 – COVID-19 – Treatment ALN 93.959 – COVID-19 – Prevention II ALN 93.959 – COVID-19 – ARPA Prevention Criteria: As required by 2 CFR 200.332, the pass-through entity must communicate specific information to subrecipients, as applicable. Condition: Contracts with subrecipients did not include portions of required disclosures. Cause/Effect: Inadequate internal controls over compliance. Select contracts were not in compliance with 2 CFR 200.332. Questioned Cost: None. Recommendation: We recommend that the PIHP update all contracts with subrecipients to include required language. View of Responsible Official: Management is in agreement with this recommendation.
2023-001 – Communications with Subrecipients (repeat comment) Finding Type: Significant Deficiency in internal control over compliance / noncompliance Program: ALN 93.959 – Prevention ALN 93.959 – COVID-19 – Treatment ALN 93.959 – COVID-19 – Prevention II ALN 93.959 – COVID-19 – ARPA Prevention Criteria: As required by 2 CFR 200.332, the pass-through entity must communicate specific information to subrecipients, as applicable. Condition: Contracts with subrecipients did not include portions of required disclosures. Cause/Effect: Inadequate internal controls over compliance. Select contracts were not in compliance with 2 CFR 200.332. Questioned Cost: None. Recommendation: We recommend that the PIHP update all contracts with subrecipients to include required language. View of Responsible Official: Management is in agreement with this recommendation.
2023-001 – Communications with Subrecipients (repeat comment) Finding Type: Significant Deficiency in internal control over compliance / noncompliance Program: ALN 93.959 – Prevention ALN 93.959 – COVID-19 – Treatment ALN 93.959 – COVID-19 – Prevention II ALN 93.959 – COVID-19 – ARPA Prevention Criteria: As required by 2 CFR 200.332, the pass-through entity must communicate specific information to subrecipients, as applicable. Condition: Contracts with subrecipients did not include portions of required disclosures. Cause/Effect: Inadequate internal controls over compliance. Select contracts were not in compliance with 2 CFR 200.332. Questioned Cost: None. Recommendation: We recommend that the PIHP update all contracts with subrecipients to include required language. View of Responsible Official: Management is in agreement with this recommendation.
2023-001 – Communications with Subrecipients (repeat comment) Finding Type: Significant Deficiency in internal control over compliance / noncompliance Program: ALN 93.959 – COVID-19 - ARPA Treatment Criteria: As required by 2 CFR 200.332, the pass-through entity must communicate specific information to subrecipients, as applicable. Condition: Contracts with subrecipients did not include portions of required disclosures. Cause/Effect: Inadequate internal controls over compliance. Select contracts were not in compliance with 2 CFR 200.332. Questioned Cost: None. Recommendation: We recommend that the PIHP update all contracts with subrecipients to include required language. View of Responsible Official: Management is in agreement with this recommendation.
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
Condition/Effect: The Council conducted programmatic monitoring; however, no fiscal monitoring activities were performed during the year of its sub-recipients as required by 2 CFR §200.332 (d).
$4,521 Finding No. 2023 003: Activities Allowed and Unallowed (Control Deficiency) Allowable Costs and Cost Principles (Control Deficiency) Reporting (Control Deficiency) Subrecipient Monitoring (Control Deficiency) Federal Agency: U.S. Department of Commerce U.S. Department of the Interior U.S. Agency for International Development Assistance Listing Number and Title: 11.431 – Climate and Atmospheric Research 11.468 – Applied Meteorological Research 15.820 – National and Regional Climate Adaptation on Science Centers 98.001 – Foreign Assistance for Programs Overseas Condition During our audit, we noted the following instances of noncompliance: Activities Allowed and Unallowed / Allowable Costs and Cost Principles We noted the following with regards to salaries and wages expenditures selected for testing: Due to the application of an incorrect allocation rate, we noted salaries and wages were inaccurately allocated to the Research and Development Cluster (“R&D Cluster”) program for 4 out of 16 individuals selected for testing. We noted that at the end of the fiscal year management recorded an adjustment in an attempt to correct the error, however, for two of the impacted individuals the amounts calculated in the adjustment were inaccurate. For the remaining two individuals, the amounts calculated in the adjustment were accurate, however the program accounts to which such costs were approved to be allocated as stated per the individual’s “Personnel Budget Form” did not agree to the actual program accounts to which the expenses were recorded in the Center’s general ledger. In addition to the samples selected for testing, we noted salaries and wages were inaccurately allocated to the R&D Cluster program for one individual due to the application of an incorrect allocation rate. We noted the following with regards to non-salaries and wages expenditures selected for testing: We noted that for 3 out of 24 non salaries and wages expenditures selected for testing, we were unable to obtain documentation evidencing Fiscal Officer approval of the expenditure. Reporting We noted two instances in which the Center did not complete the reporting required by Section 2, Full Disclosure of Entities Receiving Federal Funding, of the Federal Funding Accountability and Transparency Act (“FFATA”) for subgrants made during 2023. Subrecipient Monitoring We noted an instance in which the Center did not properly communicate the federal assistance listing number to a subrecipient upon execution of the subaward agreement. Criteria Activities Allowed and Unallowed / Allowable Costs and Cost Principles Section 200.403 – Factors affecting allowability of costs of Title 2 U.S. CFR Part 200, states “costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles… (g) Be adequately documented.” Reporting Section 2, Full Disclosure of Entities Receiving Federal Funding, of the FFATA requires an entity to report subcontracts made under federally-awarded contracts by the end of the month following the month in which the prime recipient awards any subgrant greater than or equal to $30,000. Section 2, Full Disclosure of Entities Receiving Federal Funding, of the FFATA also specifies the data elements to be included by an entity in their reporting submission. Subrecipient Monitoring Section 200.332 – Requirements for pass-through entities of Title 2 U.S. CFR Part 200, states “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (xii) Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement;” Cause Activities Allowed and Unallowed / Allowable Costs and Cost Principles For the identified instances of noncompliance associated with salaries and wages expenditures, we were informed by management that the inaccurate allocation of amounts to the R&D Cluster program may be due to the untimely updating of level of effort allocation percentages on the individual’s “Personnel Budget Form.” The inaccurate calculation of amounts included in the correcting adjustment and the recordation of amounts to inaccurate program accounts within the Center’s general ledger may be attributed to general management oversight. For the identified instances of noncompliance associated with non salaries and wages expenditures, we were informed by management that although the Fiscal Officer has the ability to electronically approve transactions within the general ledger, the historical retention of such information is an additional service which management did not elect to activate. Reporting The lack of FFATA reporting may be attributed to general management oversight. Subrecipient Monitoring We were informed by management that an outdated template which did not include a field for the federal assistance listing number was utilized when executing the subaward agreement. Effect Activities Allowed and Unallowed / Allowable Costs and Cost Principles Failure to adhere to the allowable cost principles of Title 2 U.S. CFR Part 200 exposes the Center to an undue risk of misuse of federal funds. Furthermore, the inaccurate calculation of salaries and wages expenditures included in the correcting adjustment resulted in the following: • An overstatement of $24 in expenditures allocated to the U.S. Agency for International Development – Foreign Assistance for Program Overseas grant within the R&D Cluster grant. • An understatement of $24 in expenditures allocated to the Cultural, Technical and Educational Centers grant. Reporting Failure to file required reports reduces transparency on the use of program funds and represents an instance of noncompliance with the requirements of Title 2 U.S. CFR Part 200. Subrecipient Monitoring Failure to communicate the required information to subrecipients exposes the Center to an undue risk of misuse of federal funds. Context Activities Allowed and Unallowed / Allowable Costs and Cost Principles A sample of 16 salaries and wages expenditures totaling approximately $57,000 were selected for audit from a population of approximately $402,000 in salaries and wages expenditures. Our test found four instances in which salaries and wages were erroneously recorded under the R&D Cluster program. Our sample is a statistically valid sample. A sample of 24 non salaries and wages related expenditures totaling approximately $98,000 were selected for audit from a population of approximately $601,000 in non salaries and wages related expenditures. Our test found three instances in which documentation of the Fiscal Officer approval of the non salaries and wages related expenditures were not properly retained. Our sample is a statistically valid sample. Reporting A sample of two subawards totaling approximately $129,000 were selected for audit from a population of two subawards totaling approximately $129,000. Our test found two instances in which the FFATA reports were not completed in a timely manner. Our sample is a statistically valid sample. Subrecipient Monitoring A sample of one subaward totaling approximately $92,000 was selected for audit from a population of two subawards totaling approximately $129,000. Our test found one instance in which the federal assistance listing number was not properly communicated to the subrecipient upon execution of the subaward agreement. Our sample is a statistically valid sample. Repeat Finding This is not a repeat finding. Recommendation We recommend that the Center perform the following to ensure compliance: Activities Allowed and Unallowed / Allowable Costs and Cost Principles With regards to salaries and wages expenditures, ensure the level of effort allocation percentages on an individual’s “Personnel Budget Form” are updated in an accurate and timely manner. Also, ensure that correcting adjustments, as necessary, are calculated and recorded within the general ledger in an accurate manner. With regards to non salaries and wages expenditures, ensure that documentation is maintained evidencing Fiscal Officer approval of the expenditure. Reporting Ensure that required FFATA reports are completed in a timely and accurate manner. Subrecipient Monitoring Ensure that information required pursuant to Section 200.332 – Requirements for pass-through entities of Title 2 U.S. CFR Part 200 is properly communicated to subrecipients upon execution of a subaward agreement. Cause and View of Responsible Officials Activities Allowed and Unallowed / Allowable Costs and Cost Principles New payroll allocation procedures were implemented during fiscal 2023 in an effort to streamline the allocation process. Starting in fiscal 2024, management has reverted to the fiscal 2022 payroll allocation procedures to ensure that the proper percentages are used in calculating charges to its contracts and grants. The procedures used in fiscal 2022 and prior resulted in clean audit opinions and can be trusted to allocate payroll properly. The allocation errors noted during the audit were corrected in the subsequent fiscal year. Reporting The FFATA report was filed in fiscal 2024. Procedures were modified to ensure that necessary information is requested from Center subaward recipients to assist in preparing the FFATA reports. Furthermore, the subaward agreement template was revised to make reference to the need for filing FFATA reports. Subrecipient Monitoring Management has revised procedures to ensure that the subaward recipients are notified of the federal assistance listing number. In addition, Finance staff have been reminded of the necessity to communicate the assistance number to our subaward recipients.
$4,521 Finding No. 2023 003: Activities Allowed and Unallowed (Control Deficiency) Allowable Costs and Cost Principles (Control Deficiency) Reporting (Control Deficiency) Subrecipient Monitoring (Control Deficiency) Federal Agency: U.S. Department of Commerce U.S. Department of the Interior U.S. Agency for International Development Assistance Listing Number and Title: 11.431 – Climate and Atmospheric Research 11.468 – Applied Meteorological Research 15.820 – National and Regional Climate Adaptation on Science Centers 98.001 – Foreign Assistance for Programs Overseas Condition During our audit, we noted the following instances of noncompliance: Activities Allowed and Unallowed / Allowable Costs and Cost Principles We noted the following with regards to salaries and wages expenditures selected for testing: Due to the application of an incorrect allocation rate, we noted salaries and wages were inaccurately allocated to the Research and Development Cluster (“R&D Cluster”) program for 4 out of 16 individuals selected for testing. We noted that at the end of the fiscal year management recorded an adjustment in an attempt to correct the error, however, for two of the impacted individuals the amounts calculated in the adjustment were inaccurate. For the remaining two individuals, the amounts calculated in the adjustment were accurate, however the program accounts to which such costs were approved to be allocated as stated per the individual’s “Personnel Budget Form” did not agree to the actual program accounts to which the expenses were recorded in the Center’s general ledger. In addition to the samples selected for testing, we noted salaries and wages were inaccurately allocated to the R&D Cluster program for one individual due to the application of an incorrect allocation rate. We noted the following with regards to non-salaries and wages expenditures selected for testing: We noted that for 3 out of 24 non salaries and wages expenditures selected for testing, we were unable to obtain documentation evidencing Fiscal Officer approval of the expenditure. Reporting We noted two instances in which the Center did not complete the reporting required by Section 2, Full Disclosure of Entities Receiving Federal Funding, of the Federal Funding Accountability and Transparency Act (“FFATA”) for subgrants made during 2023. Subrecipient Monitoring We noted an instance in which the Center did not properly communicate the federal assistance listing number to a subrecipient upon execution of the subaward agreement. Criteria Activities Allowed and Unallowed / Allowable Costs and Cost Principles Section 200.403 – Factors affecting allowability of costs of Title 2 U.S. CFR Part 200, states “costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles… (g) Be adequately documented.” Reporting Section 2, Full Disclosure of Entities Receiving Federal Funding, of the FFATA requires an entity to report subcontracts made under federally-awarded contracts by the end of the month following the month in which the prime recipient awards any subgrant greater than or equal to $30,000. Section 2, Full Disclosure of Entities Receiving Federal Funding, of the FFATA also specifies the data elements to be included by an entity in their reporting submission. Subrecipient Monitoring Section 200.332 – Requirements for pass-through entities of Title 2 U.S. CFR Part 200, states “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (xii) Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement;” Cause Activities Allowed and Unallowed / Allowable Costs and Cost Principles For the identified instances of noncompliance associated with salaries and wages expenditures, we were informed by management that the inaccurate allocation of amounts to the R&D Cluster program may be due to the untimely updating of level of effort allocation percentages on the individual’s “Personnel Budget Form.” The inaccurate calculation of amounts included in the correcting adjustment and the recordation of amounts to inaccurate program accounts within the Center’s general ledger may be attributed to general management oversight. For the identified instances of noncompliance associated with non salaries and wages expenditures, we were informed by management that although the Fiscal Officer has the ability to electronically approve transactions within the general ledger, the historical retention of such information is an additional service which management did not elect to activate. Reporting The lack of FFATA reporting may be attributed to general management oversight. Subrecipient Monitoring We were informed by management that an outdated template which did not include a field for the federal assistance listing number was utilized when executing the subaward agreement. Effect Activities Allowed and Unallowed / Allowable Costs and Cost Principles Failure to adhere to the allowable cost principles of Title 2 U.S. CFR Part 200 exposes the Center to an undue risk of misuse of federal funds. Furthermore, the inaccurate calculation of salaries and wages expenditures included in the correcting adjustment resulted in the following: • An overstatement of $24 in expenditures allocated to the U.S. Agency for International Development – Foreign Assistance for Program Overseas grant within the R&D Cluster grant. • An understatement of $24 in expenditures allocated to the Cultural, Technical and Educational Centers grant. Reporting Failure to file required reports reduces transparency on the use of program funds and represents an instance of noncompliance with the requirements of Title 2 U.S. CFR Part 200. Subrecipient Monitoring Failure to communicate the required information to subrecipients exposes the Center to an undue risk of misuse of federal funds. Context Activities Allowed and Unallowed / Allowable Costs and Cost Principles A sample of 16 salaries and wages expenditures totaling approximately $57,000 were selected for audit from a population of approximately $402,000 in salaries and wages expenditures. Our test found four instances in which salaries and wages were erroneously recorded under the R&D Cluster program. Our sample is a statistically valid sample. A sample of 24 non salaries and wages related expenditures totaling approximately $98,000 were selected for audit from a population of approximately $601,000 in non salaries and wages related expenditures. Our test found three instances in which documentation of the Fiscal Officer approval of the non salaries and wages related expenditures were not properly retained. Our sample is a statistically valid sample. Reporting A sample of two subawards totaling approximately $129,000 were selected for audit from a population of two subawards totaling approximately $129,000. Our test found two instances in which the FFATA reports were not completed in a timely manner. Our sample is a statistically valid sample. Subrecipient Monitoring A sample of one subaward totaling approximately $92,000 was selected for audit from a population of two subawards totaling approximately $129,000. Our test found one instance in which the federal assistance listing number was not properly communicated to the subrecipient upon execution of the subaward agreement. Our sample is a statistically valid sample. Repeat Finding This is not a repeat finding. Recommendation We recommend that the Center perform the following to ensure compliance: Activities Allowed and Unallowed / Allowable Costs and Cost Principles With regards to salaries and wages expenditures, ensure the level of effort allocation percentages on an individual’s “Personnel Budget Form” are updated in an accurate and timely manner. Also, ensure that correcting adjustments, as necessary, are calculated and recorded within the general ledger in an accurate manner. With regards to non salaries and wages expenditures, ensure that documentation is maintained evidencing Fiscal Officer approval of the expenditure. Reporting Ensure that required FFATA reports are completed in a timely and accurate manner. Subrecipient Monitoring Ensure that information required pursuant to Section 200.332 – Requirements for pass-through entities of Title 2 U.S. CFR Part 200 is properly communicated to subrecipients upon execution of a subaward agreement. Cause and View of Responsible Officials Activities Allowed and Unallowed / Allowable Costs and Cost Principles New payroll allocation procedures were implemented during fiscal 2023 in an effort to streamline the allocation process. Starting in fiscal 2024, management has reverted to the fiscal 2022 payroll allocation procedures to ensure that the proper percentages are used in calculating charges to its contracts and grants. The procedures used in fiscal 2022 and prior resulted in clean audit opinions and can be trusted to allocate payroll properly. The allocation errors noted during the audit were corrected in the subsequent fiscal year. Reporting The FFATA report was filed in fiscal 2024. Procedures were modified to ensure that necessary information is requested from Center subaward recipients to assist in preparing the FFATA reports. Furthermore, the subaward agreement template was revised to make reference to the need for filing FFATA reports. Subrecipient Monitoring Management has revised procedures to ensure that the subaward recipients are notified of the federal assistance listing number. In addition, Finance staff have been reminded of the necessity to communicate the assistance number to our subaward recipients.
$4,521 Finding No. 2023 003: Activities Allowed and Unallowed (Control Deficiency) Allowable Costs and Cost Principles (Control Deficiency) Reporting (Control Deficiency) Subrecipient Monitoring (Control Deficiency) Federal Agency: U.S. Department of Commerce U.S. Department of the Interior U.S. Agency for International Development Assistance Listing Number and Title: 11.431 – Climate and Atmospheric Research 11.468 – Applied Meteorological Research 15.820 – National and Regional Climate Adaptation on Science Centers 98.001 – Foreign Assistance for Programs Overseas Condition During our audit, we noted the following instances of noncompliance: Activities Allowed and Unallowed / Allowable Costs and Cost Principles We noted the following with regards to salaries and wages expenditures selected for testing: Due to the application of an incorrect allocation rate, we noted salaries and wages were inaccurately allocated to the Research and Development Cluster (“R&D Cluster”) program for 4 out of 16 individuals selected for testing. We noted that at the end of the fiscal year management recorded an adjustment in an attempt to correct the error, however, for two of the impacted individuals the amounts calculated in the adjustment were inaccurate. For the remaining two individuals, the amounts calculated in the adjustment were accurate, however the program accounts to which such costs were approved to be allocated as stated per the individual’s “Personnel Budget Form” did not agree to the actual program accounts to which the expenses were recorded in the Center’s general ledger. In addition to the samples selected for testing, we noted salaries and wages were inaccurately allocated to the R&D Cluster program for one individual due to the application of an incorrect allocation rate. We noted the following with regards to non-salaries and wages expenditures selected for testing: We noted that for 3 out of 24 non salaries and wages expenditures selected for testing, we were unable to obtain documentation evidencing Fiscal Officer approval of the expenditure. Reporting We noted two instances in which the Center did not complete the reporting required by Section 2, Full Disclosure of Entities Receiving Federal Funding, of the Federal Funding Accountability and Transparency Act (“FFATA”) for subgrants made during 2023. Subrecipient Monitoring We noted an instance in which the Center did not properly communicate the federal assistance listing number to a subrecipient upon execution of the subaward agreement. Criteria Activities Allowed and Unallowed / Allowable Costs and Cost Principles Section 200.403 – Factors affecting allowability of costs of Title 2 U.S. CFR Part 200, states “costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles… (g) Be adequately documented.” Reporting Section 2, Full Disclosure of Entities Receiving Federal Funding, of the FFATA requires an entity to report subcontracts made under federally-awarded contracts by the end of the month following the month in which the prime recipient awards any subgrant greater than or equal to $30,000. Section 2, Full Disclosure of Entities Receiving Federal Funding, of the FFATA also specifies the data elements to be included by an entity in their reporting submission. Subrecipient Monitoring Section 200.332 – Requirements for pass-through entities of Title 2 U.S. CFR Part 200, states “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (xii) Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement;” Cause Activities Allowed and Unallowed / Allowable Costs and Cost Principles For the identified instances of noncompliance associated with salaries and wages expenditures, we were informed by management that the inaccurate allocation of amounts to the R&D Cluster program may be due to the untimely updating of level of effort allocation percentages on the individual’s “Personnel Budget Form.” The inaccurate calculation of amounts included in the correcting adjustment and the recordation of amounts to inaccurate program accounts within the Center’s general ledger may be attributed to general management oversight. For the identified instances of noncompliance associated with non salaries and wages expenditures, we were informed by management that although the Fiscal Officer has the ability to electronically approve transactions within the general ledger, the historical retention of such information is an additional service which management did not elect to activate. Reporting The lack of FFATA reporting may be attributed to general management oversight. Subrecipient Monitoring We were informed by management that an outdated template which did not include a field for the federal assistance listing number was utilized when executing the subaward agreement. Effect Activities Allowed and Unallowed / Allowable Costs and Cost Principles Failure to adhere to the allowable cost principles of Title 2 U.S. CFR Part 200 exposes the Center to an undue risk of misuse of federal funds. Furthermore, the inaccurate calculation of salaries and wages expenditures included in the correcting adjustment resulted in the following: • An overstatement of $24 in expenditures allocated to the U.S. Agency for International Development – Foreign Assistance for Program Overseas grant within the R&D Cluster grant. • An understatement of $24 in expenditures allocated to the Cultural, Technical and Educational Centers grant. Reporting Failure to file required reports reduces transparency on the use of program funds and represents an instance of noncompliance with the requirements of Title 2 U.S. CFR Part 200. Subrecipient Monitoring Failure to communicate the required information to subrecipients exposes the Center to an undue risk of misuse of federal funds. Context Activities Allowed and Unallowed / Allowable Costs and Cost Principles A sample of 16 salaries and wages expenditures totaling approximately $57,000 were selected for audit from a population of approximately $402,000 in salaries and wages expenditures. Our test found four instances in which salaries and wages were erroneously recorded under the R&D Cluster program. Our sample is a statistically valid sample. A sample of 24 non salaries and wages related expenditures totaling approximately $98,000 were selected for audit from a population of approximately $601,000 in non salaries and wages related expenditures. Our test found three instances in which documentation of the Fiscal Officer approval of the non salaries and wages related expenditures were not properly retained. Our sample is a statistically valid sample. Reporting A sample of two subawards totaling approximately $129,000 were selected for audit from a population of two subawards totaling approximately $129,000. Our test found two instances in which the FFATA reports were not completed in a timely manner. Our sample is a statistically valid sample. Subrecipient Monitoring A sample of one subaward totaling approximately $92,000 was selected for audit from a population of two subawards totaling approximately $129,000. Our test found one instance in which the federal assistance listing number was not properly communicated to the subrecipient upon execution of the subaward agreement. Our sample is a statistically valid sample. Repeat Finding This is not a repeat finding. Recommendation We recommend that the Center perform the following to ensure compliance: Activities Allowed and Unallowed / Allowable Costs and Cost Principles With regards to salaries and wages expenditures, ensure the level of effort allocation percentages on an individual’s “Personnel Budget Form” are updated in an accurate and timely manner. Also, ensure that correcting adjustments, as necessary, are calculated and recorded within the general ledger in an accurate manner. With regards to non salaries and wages expenditures, ensure that documentation is maintained evidencing Fiscal Officer approval of the expenditure. Reporting Ensure that required FFATA reports are completed in a timely and accurate manner. Subrecipient Monitoring Ensure that information required pursuant to Section 200.332 – Requirements for pass-through entities of Title 2 U.S. CFR Part 200 is properly communicated to subrecipients upon execution of a subaward agreement. Cause and View of Responsible Officials Activities Allowed and Unallowed / Allowable Costs and Cost Principles New payroll allocation procedures were implemented during fiscal 2023 in an effort to streamline the allocation process. Starting in fiscal 2024, management has reverted to the fiscal 2022 payroll allocation procedures to ensure that the proper percentages are used in calculating charges to its contracts and grants. The procedures used in fiscal 2022 and prior resulted in clean audit opinions and can be trusted to allocate payroll properly. The allocation errors noted during the audit were corrected in the subsequent fiscal year. Reporting The FFATA report was filed in fiscal 2024. Procedures were modified to ensure that necessary information is requested from Center subaward recipients to assist in preparing the FFATA reports. Furthermore, the subaward agreement template was revised to make reference to the need for filing FFATA reports. Subrecipient Monitoring Management has revised procedures to ensure that the subaward recipients are notified of the federal assistance listing number. In addition, Finance staff have been reminded of the necessity to communicate the assistance number to our subaward recipients.
$4,521 Finding No. 2023 003: Activities Allowed and Unallowed (Control Deficiency) Allowable Costs and Cost Principles (Control Deficiency) Reporting (Control Deficiency) Subrecipient Monitoring (Control Deficiency) Federal Agency: U.S. Department of Commerce U.S. Department of the Interior U.S. Agency for International Development Assistance Listing Number and Title: 11.431 – Climate and Atmospheric Research 11.468 – Applied Meteorological Research 15.820 – National and Regional Climate Adaptation on Science Centers 98.001 – Foreign Assistance for Programs Overseas Condition During our audit, we noted the following instances of noncompliance: Activities Allowed and Unallowed / Allowable Costs and Cost Principles We noted the following with regards to salaries and wages expenditures selected for testing: Due to the application of an incorrect allocation rate, we noted salaries and wages were inaccurately allocated to the Research and Development Cluster (“R&D Cluster”) program for 4 out of 16 individuals selected for testing. We noted that at the end of the fiscal year management recorded an adjustment in an attempt to correct the error, however, for two of the impacted individuals the amounts calculated in the adjustment were inaccurate. For the remaining two individuals, the amounts calculated in the adjustment were accurate, however the program accounts to which such costs were approved to be allocated as stated per the individual’s “Personnel Budget Form” did not agree to the actual program accounts to which the expenses were recorded in the Center’s general ledger. In addition to the samples selected for testing, we noted salaries and wages were inaccurately allocated to the R&D Cluster program for one individual due to the application of an incorrect allocation rate. We noted the following with regards to non-salaries and wages expenditures selected for testing: We noted that for 3 out of 24 non salaries and wages expenditures selected for testing, we were unable to obtain documentation evidencing Fiscal Officer approval of the expenditure. Reporting We noted two instances in which the Center did not complete the reporting required by Section 2, Full Disclosure of Entities Receiving Federal Funding, of the Federal Funding Accountability and Transparency Act (“FFATA”) for subgrants made during 2023. Subrecipient Monitoring We noted an instance in which the Center did not properly communicate the federal assistance listing number to a subrecipient upon execution of the subaward agreement. Criteria Activities Allowed and Unallowed / Allowable Costs and Cost Principles Section 200.403 – Factors affecting allowability of costs of Title 2 U.S. CFR Part 200, states “costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles… (g) Be adequately documented.” Reporting Section 2, Full Disclosure of Entities Receiving Federal Funding, of the FFATA requires an entity to report subcontracts made under federally-awarded contracts by the end of the month following the month in which the prime recipient awards any subgrant greater than or equal to $30,000. Section 2, Full Disclosure of Entities Receiving Federal Funding, of the FFATA also specifies the data elements to be included by an entity in their reporting submission. Subrecipient Monitoring Section 200.332 – Requirements for pass-through entities of Title 2 U.S. CFR Part 200, states “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (xii) Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement;” Cause Activities Allowed and Unallowed / Allowable Costs and Cost Principles For the identified instances of noncompliance associated with salaries and wages expenditures, we were informed by management that the inaccurate allocation of amounts to the R&D Cluster program may be due to the untimely updating of level of effort allocation percentages on the individual’s “Personnel Budget Form.” The inaccurate calculation of amounts included in the correcting adjustment and the recordation of amounts to inaccurate program accounts within the Center’s general ledger may be attributed to general management oversight. For the identified instances of noncompliance associated with non salaries and wages expenditures, we were informed by management that although the Fiscal Officer has the ability to electronically approve transactions within the general ledger, the historical retention of such information is an additional service which management did not elect to activate. Reporting The lack of FFATA reporting may be attributed to general management oversight. Subrecipient Monitoring We were informed by management that an outdated template which did not include a field for the federal assistance listing number was utilized when executing the subaward agreement. Effect Activities Allowed and Unallowed / Allowable Costs and Cost Principles Failure to adhere to the allowable cost principles of Title 2 U.S. CFR Part 200 exposes the Center to an undue risk of misuse of federal funds. Furthermore, the inaccurate calculation of salaries and wages expenditures included in the correcting adjustment resulted in the following: • An overstatement of $24 in expenditures allocated to the U.S. Agency for International Development – Foreign Assistance for Program Overseas grant within the R&D Cluster grant. • An understatement of $24 in expenditures allocated to the Cultural, Technical and Educational Centers grant. Reporting Failure to file required reports reduces transparency on the use of program funds and represents an instance of noncompliance with the requirements of Title 2 U.S. CFR Part 200. Subrecipient Monitoring Failure to communicate the required information to subrecipients exposes the Center to an undue risk of misuse of federal funds. Context Activities Allowed and Unallowed / Allowable Costs and Cost Principles A sample of 16 salaries and wages expenditures totaling approximately $57,000 were selected for audit from a population of approximately $402,000 in salaries and wages expenditures. Our test found four instances in which salaries and wages were erroneously recorded under the R&D Cluster program. Our sample is a statistically valid sample. A sample of 24 non salaries and wages related expenditures totaling approximately $98,000 were selected for audit from a population of approximately $601,000 in non salaries and wages related expenditures. Our test found three instances in which documentation of the Fiscal Officer approval of the non salaries and wages related expenditures were not properly retained. Our sample is a statistically valid sample. Reporting A sample of two subawards totaling approximately $129,000 were selected for audit from a population of two subawards totaling approximately $129,000. Our test found two instances in which the FFATA reports were not completed in a timely manner. Our sample is a statistically valid sample. Subrecipient Monitoring A sample of one subaward totaling approximately $92,000 was selected for audit from a population of two subawards totaling approximately $129,000. Our test found one instance in which the federal assistance listing number was not properly communicated to the subrecipient upon execution of the subaward agreement. Our sample is a statistically valid sample. Repeat Finding This is not a repeat finding. Recommendation We recommend that the Center perform the following to ensure compliance: Activities Allowed and Unallowed / Allowable Costs and Cost Principles With regards to salaries and wages expenditures, ensure the level of effort allocation percentages on an individual’s “Personnel Budget Form” are updated in an accurate and timely manner. Also, ensure that correcting adjustments, as necessary, are calculated and recorded within the general ledger in an accurate manner. With regards to non salaries and wages expenditures, ensure that documentation is maintained evidencing Fiscal Officer approval of the expenditure. Reporting Ensure that required FFATA reports are completed in a timely and accurate manner. Subrecipient Monitoring Ensure that information required pursuant to Section 200.332 – Requirements for pass-through entities of Title 2 U.S. CFR Part 200 is properly communicated to subrecipients upon execution of a subaward agreement. Cause and View of Responsible Officials Activities Allowed and Unallowed / Allowable Costs and Cost Principles New payroll allocation procedures were implemented during fiscal 2023 in an effort to streamline the allocation process. Starting in fiscal 2024, management has reverted to the fiscal 2022 payroll allocation procedures to ensure that the proper percentages are used in calculating charges to its contracts and grants. The procedures used in fiscal 2022 and prior resulted in clean audit opinions and can be trusted to allocate payroll properly. The allocation errors noted during the audit were corrected in the subsequent fiscal year. Reporting The FFATA report was filed in fiscal 2024. Procedures were modified to ensure that necessary information is requested from Center subaward recipients to assist in preparing the FFATA reports. Furthermore, the subaward agreement template was revised to make reference to the need for filing FFATA reports. Subrecipient Monitoring Management has revised procedures to ensure that the subaward recipients are notified of the federal assistance listing number. In addition, Finance staff have been reminded of the necessity to communicate the assistance number to our subaward recipients.
$4,521 Finding No. 2023 003: Activities Allowed and Unallowed (Control Deficiency) Allowable Costs and Cost Principles (Control Deficiency) Reporting (Control Deficiency) Subrecipient Monitoring (Control Deficiency) Federal Agency: U.S. Department of Commerce U.S. Department of the Interior U.S. Agency for International Development Assistance Listing Number and Title: 11.431 – Climate and Atmospheric Research 11.468 – Applied Meteorological Research 15.820 – National and Regional Climate Adaptation on Science Centers 98.001 – Foreign Assistance for Programs Overseas Condition During our audit, we noted the following instances of noncompliance: Activities Allowed and Unallowed / Allowable Costs and Cost Principles We noted the following with regards to salaries and wages expenditures selected for testing: Due to the application of an incorrect allocation rate, we noted salaries and wages were inaccurately allocated to the Research and Development Cluster (“R&D Cluster”) program for 4 out of 16 individuals selected for testing. We noted that at the end of the fiscal year management recorded an adjustment in an attempt to correct the error, however, for two of the impacted individuals the amounts calculated in the adjustment were inaccurate. For the remaining two individuals, the amounts calculated in the adjustment were accurate, however the program accounts to which such costs were approved to be allocated as stated per the individual’s “Personnel Budget Form” did not agree to the actual program accounts to which the expenses were recorded in the Center’s general ledger. In addition to the samples selected for testing, we noted salaries and wages were inaccurately allocated to the R&D Cluster program for one individual due to the application of an incorrect allocation rate. We noted the following with regards to non-salaries and wages expenditures selected for testing: We noted that for 3 out of 24 non salaries and wages expenditures selected for testing, we were unable to obtain documentation evidencing Fiscal Officer approval of the expenditure. Reporting We noted two instances in which the Center did not complete the reporting required by Section 2, Full Disclosure of Entities Receiving Federal Funding, of the Federal Funding Accountability and Transparency Act (“FFATA”) for subgrants made during 2023. Subrecipient Monitoring We noted an instance in which the Center did not properly communicate the federal assistance listing number to a subrecipient upon execution of the subaward agreement. Criteria Activities Allowed and Unallowed / Allowable Costs and Cost Principles Section 200.403 – Factors affecting allowability of costs of Title 2 U.S. CFR Part 200, states “costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles… (g) Be adequately documented.” Reporting Section 2, Full Disclosure of Entities Receiving Federal Funding, of the FFATA requires an entity to report subcontracts made under federally-awarded contracts by the end of the month following the month in which the prime recipient awards any subgrant greater than or equal to $30,000. Section 2, Full Disclosure of Entities Receiving Federal Funding, of the FFATA also specifies the data elements to be included by an entity in their reporting submission. Subrecipient Monitoring Section 200.332 – Requirements for pass-through entities of Title 2 U.S. CFR Part 200, states “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (xii) Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement;” Cause Activities Allowed and Unallowed / Allowable Costs and Cost Principles For the identified instances of noncompliance associated with salaries and wages expenditures, we were informed by management that the inaccurate allocation of amounts to the R&D Cluster program may be due to the untimely updating of level of effort allocation percentages on the individual’s “Personnel Budget Form.” The inaccurate calculation of amounts included in the correcting adjustment and the recordation of amounts to inaccurate program accounts within the Center’s general ledger may be attributed to general management oversight. For the identified instances of noncompliance associated with non salaries and wages expenditures, we were informed by management that although the Fiscal Officer has the ability to electronically approve transactions within the general ledger, the historical retention of such information is an additional service which management did not elect to activate. Reporting The lack of FFATA reporting may be attributed to general management oversight. Subrecipient Monitoring We were informed by management that an outdated template which did not include a field for the federal assistance listing number was utilized when executing the subaward agreement. Effect Activities Allowed and Unallowed / Allowable Costs and Cost Principles Failure to adhere to the allowable cost principles of Title 2 U.S. CFR Part 200 exposes the Center to an undue risk of misuse of federal funds. Furthermore, the inaccurate calculation of salaries and wages expenditures included in the correcting adjustment resulted in the following: • An overstatement of $24 in expenditures allocated to the U.S. Agency for International Development – Foreign Assistance for Program Overseas grant within the R&D Cluster grant. • An understatement of $24 in expenditures allocated to the Cultural, Technical and Educational Centers grant. Reporting Failure to file required reports reduces transparency on the use of program funds and represents an instance of noncompliance with the requirements of Title 2 U.S. CFR Part 200. Subrecipient Monitoring Failure to communicate the required information to subrecipients exposes the Center to an undue risk of misuse of federal funds. Context Activities Allowed and Unallowed / Allowable Costs and Cost Principles A sample of 16 salaries and wages expenditures totaling approximately $57,000 were selected for audit from a population of approximately $402,000 in salaries and wages expenditures. Our test found four instances in which salaries and wages were erroneously recorded under the R&D Cluster program. Our sample is a statistically valid sample. A sample of 24 non salaries and wages related expenditures totaling approximately $98,000 were selected for audit from a population of approximately $601,000 in non salaries and wages related expenditures. Our test found three instances in which documentation of the Fiscal Officer approval of the non salaries and wages related expenditures were not properly retained. Our sample is a statistically valid sample. Reporting A sample of two subawards totaling approximately $129,000 were selected for audit from a population of two subawards totaling approximately $129,000. Our test found two instances in which the FFATA reports were not completed in a timely manner. Our sample is a statistically valid sample. Subrecipient Monitoring A sample of one subaward totaling approximately $92,000 was selected for audit from a population of two subawards totaling approximately $129,000. Our test found one instance in which the federal assistance listing number was not properly communicated to the subrecipient upon execution of the subaward agreement. Our sample is a statistically valid sample. Repeat Finding This is not a repeat finding. Recommendation We recommend that the Center perform the following to ensure compliance: Activities Allowed and Unallowed / Allowable Costs and Cost Principles With regards to salaries and wages expenditures, ensure the level of effort allocation percentages on an individual’s “Personnel Budget Form” are updated in an accurate and timely manner. Also, ensure that correcting adjustments, as necessary, are calculated and recorded within the general ledger in an accurate manner. With regards to non salaries and wages expenditures, ensure that documentation is maintained evidencing Fiscal Officer approval of the expenditure. Reporting Ensure that required FFATA reports are completed in a timely and accurate manner. Subrecipient Monitoring Ensure that information required pursuant to Section 200.332 – Requirements for pass-through entities of Title 2 U.S. CFR Part 200 is properly communicated to subrecipients upon execution of a subaward agreement. Cause and View of Responsible Officials Activities Allowed and Unallowed / Allowable Costs and Cost Principles New payroll allocation procedures were implemented during fiscal 2023 in an effort to streamline the allocation process. Starting in fiscal 2024, management has reverted to the fiscal 2022 payroll allocation procedures to ensure that the proper percentages are used in calculating charges to its contracts and grants. The procedures used in fiscal 2022 and prior resulted in clean audit opinions and can be trusted to allocate payroll properly. The allocation errors noted during the audit were corrected in the subsequent fiscal year. Reporting The FFATA report was filed in fiscal 2024. Procedures were modified to ensure that necessary information is requested from Center subaward recipients to assist in preparing the FFATA reports. Furthermore, the subaward agreement template was revised to make reference to the need for filing FFATA reports. Subrecipient Monitoring Management has revised procedures to ensure that the subaward recipients are notified of the federal assistance listing number. In addition, Finance staff have been reminded of the necessity to communicate the assistance number to our subaward recipients.
FINDING 2023-032 Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Subrecipient Monitoring - Subaward Information See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS and MDE did not report to their subrecipients all subaward information as required by the Uniform Guidance. We noted: a. MDHHS did not report the correct unique entity identifier (UEI) or FAIN for all 4 sampled CSLFRF subrecipients. b. MDE did not correctly report one or more of the following for 5 of 6 sampled CSLFRF subrecipients: subrecipient name that matches the name associated with its UEI, unique entity identifier, FAIN, and closeout terms and conditions. Criteria Federal regulation 2 CFR 200.332(a) requires all pass-through entities ensure every subaward includes certain information. Cause For part a., MDHHS informed us because of an oversight, it did not use the correct ALN when determining the FAIN, and the grantee profile contained the Data Universal Numbering System (DUNS) number rather than the UEI. For part b., MDE informed us because of an oversight, it did not use the appropriately updated grant agreement templates with the correct subaward information for fiscal year 2023. Effect Subrecipients and their auditors may not be aware of the federal award information needed to ensure compliance with the federal requirements. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs None. Recommendation We recommend MDHHS and MDE report to their subrecipients all subaward information as required by the Uniform Guidance. Management Views MDHHS and MDE agree with the finding.
Finding Number: 2023-013 Prior Year Finding Number: N/A Compliance Requirement: Subrecipient Monitoring Program: Government Department/Agency: U.S. Department of the Treasury COVID-19 - Homeowner Assistance Fund ALN: 21.026 Award #: Various Award Year: 10/01/2022 – 09/30/2023 Department of Housing and Community Development (DHCD) Criteria - The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Additionally, 2 CFR 200.332 specifies that pass-through entities must evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Based upon the pass-through entity's assessment of risk posed by the subrecipient, auditee management determined that onsite reviews of the subrecipient’s program operations were appropriate and designed the following control: DHCD performs desk audits, scheduled site visits and unscheduled site visits during the fiscal year. Reports are prepared at the site visits and properly documented. The reports include deficiencies, recommendations, and proposed corrective action and are reviewed and approved by the Project Managers, Program Managers, and Supervisory Program Managers. Condition – During our review of four (4) subrecipient samples, we noted the following: • For two (2) subrecipients, DHCD conducted onsite reviews for the Community Development Block Grants program. However, these reviews did not specifically address the Homeowner Assistance Fund program as required by the guidance and controls outlined. • For one (1) subrecipient, DHCD conducted a review, but was unable to provide evidence of a finalized report. • For one (1) subrecipient, DHCD neither performed an onsite review nor a desk audit. Questioned Costs – Not determinable. Context – This is a condition identified per review of DHCD’s compliance with the subrecipient monitoring requirements using a statistically valid sample. Effect – DHCD did not comply with the subrecipient monitoring requirements of the Homeowner Assistance Fund program. Cause – DHCD does not have fully effective internal controls over compliance with respect to the onsite review process. Recommendation – We recommend that DHCD strictly adhere to its policies and procedures to ensure that onsite reviews are properly performed and documented for subrecipients. Related Noncompliance – Noncompliance. Views of Responsible Officials and Planned Corrective Actions – DHCD concurs with the conditions and recommendations of this finding. The District’s corrective action is described in the Management’s Corrective Action Plan included as Appendix B of the attached Management’s Section.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Finding 2023-004 Subrecipient Pre-award Risk Assessment (Significant Deficiency) Information on the Federal Programs: ALN #93.576 Refugee and Entrant Assistance Discretionary Grants, ALN # U.S. Refugee Admissions Program Criteria or Specific Requirement: CFR § 200.332, "Requirements for pass-through entities", requires pass-through entities to evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. Condition: As part of our audit, we selected a sample of subawards charged to the major Federal programs. We noted that subaward risk assessments were not available for our inspection for those samples selected. Based on discussion with HIAS, the process for performing annual pre-award risk assessments for new subrecipients as well as determining and documenting the appropriate level of ongoing monitoring for existing sub recipients was implemented during January 2024 (during the time of our audit fieldwork). Cause: HIAS did not perform subaward risk assessments as required by Federal regulation. Effect or Potential Effect: HIAS may have inadvertently failed to perform monitoring procedures appropriate for a subrecipient’s assessed level of risk. Questioned Costs: N/A Context: HIAS executes subaward agreements under US Federal grants. Therefore, HIAS is subject to CFR § 200.332 "Requirements for pass-through entities". Our audit procedures consisted of test work completed on subawards and individual expenditures charged to the Federal awards. The report in which samples were selected was generated directly from HIAS' general ledger (accounting system). We consider our sample to be representative of the population. Identification as a Repeat Finding: N/A Recommendation: We recommend that HIAS strictly adhere to its new pre-award risk assessment policy for all subaward relationships in the upcoming fiscal year.
Reference Number: 2023-001 – Material Weakness, Subrecipient Monitoring Criteria: According to 2 CFR sections 200.332 (d) through (f) pass through entities must monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, complies with the terms and conditions of the subaward and achieves performance goals. Condition: During the contract period between August 1, 2022 through September 30, 2023, the Boards subrecipient over enrolled program participants which required the Board to utilize $5,737,560 of 2024 fiscal year CCS program funds to cover 2023 fiscal year obligations. Cause: The Board has weekly check in meeting with its subrecipient to discuss programmatic goals and results. The subrecipient was directed to continue enrolling program participants however, the budget for the continued enrollment had been exceeded and not identified in a timely manner to the program function. Continued enrollment resulted in grant funds being depleted. The Board sought approval from its funder to use fiscal 2024 funds to cover expenditures already incurred. Over enrollment began in March of 2023 and was not closed until July of 2023. Furthermore, the Board relies on an independent accounting firm to perform agreed upon procedures for fiscal monitoring. These procedures occurred once during the fiscal as of December 6, 2023. The Board did not conduct any additional fiscal monitoring throughout the year. Effect: The Board did not effectively monitor the budget of its subrecipient, in a timely manner. As a result, its subrecipient over enrolled program participants. The Texas Workforce Commission subsequently reduced the FY 24 award to supplement the FY23 award to account for the over expenditure. Recommendation: We recommend that the Board improve policies and procedures to ensure communication identifies available funding for program services provided in a timely and efficient manner to the program providers. With respect to monitoring of its subrecipients, policies and procedures should be enhanced to ensure that oversight of its subrecipients is more frequent, timely and responsive to findings. Management Response: See management’s corrective action plan.
Reference Number: 2023-001 – Material Weakness, Subrecipient Monitoring Criteria: According to 2 CFR sections 200.332 (d) through (f) pass through entities must monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, complies with the terms and conditions of the subaward and achieves performance goals. Condition: During the contract period between August 1, 2022 through September 30, 2023, the Boards subrecipient over enrolled program participants which required the Board to utilize $5,737,560 of 2024 fiscal year CCS program funds to cover 2023 fiscal year obligations. Cause: The Board has weekly check in meeting with its subrecipient to discuss programmatic goals and results. The subrecipient was directed to continue enrolling program participants however, the budget for the continued enrollment had been exceeded and not identified in a timely manner to the program function. Continued enrollment resulted in grant funds being depleted. The Board sought approval from its funder to use fiscal 2024 funds to cover expenditures already incurred. Over enrollment began in March of 2023 and was not closed until July of 2023. Furthermore, the Board relies on an independent accounting firm to perform agreed upon procedures for fiscal monitoring. These procedures occurred once during the fiscal as of December 6, 2023. The Board did not conduct any additional fiscal monitoring throughout the year. Effect: The Board did not effectively monitor the budget of its subrecipient, in a timely manner. As a result, its subrecipient over enrolled program participants. The Texas Workforce Commission subsequently reduced the FY 24 award to supplement the FY23 award to account for the over expenditure. Recommendation: We recommend that the Board improve policies and procedures to ensure communication identifies available funding for program services provided in a timely and efficient manner to the program providers. With respect to monitoring of its subrecipients, policies and procedures should be enhanced to ensure that oversight of its subrecipients is more frequent, timely and responsive to findings. Management Response: See management’s corrective action plan.