FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-051 (See Finding Reference Number 2023-021) FEDERAL PROGRAM (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRLIEA (Federal Award Years: 2021 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR § 200.302, Financial Management, establishes that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450.) (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. … (6) Written procedures to implement the requirements of § 200.305 and (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION As part of our audit procedures over the reporting requirement for LIHEAP program, we selected two reports submitted during our fiscal year. We noted that the administrative expenditures do not reconcile with the accounting information from PRIFAS. In addition, for the amount of encumbrances of $11,032,784.51, the amount of $9,943,769.52 was not supported by a detail. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This is a systematic deficiency. Procedures and internal controls manuals should provide for and ensure the segregation of duties, and the reconciliation of financial information reported to federal agencies against the accounting records used to prepare financial statements and SEFA. ADSEF failure to support reported amounts with verifiable documentation and the absence of independent review increases the risk of inaccurate or misstated financial data being reported to the Federal awarding agency. STATEMENT OF CAUSE During our interviews and understanding of the internal controls over financial reporting, we noted that only one person prepares, submits and certifies the SF– 425 reports. No proper segregation of duties exists, that allows for validation of all accounting data before submitting the reports. In addition, the procedures manual for preparing reports does not establish a clear process for obtaining information, validating it, recording it, preparing it, and reporting it, as well as the responsibilities and segregation of duties to ensure that the reported information is consistent with ADSEF's accounting records. ADSEF lacks internal controls that allow for the timely validation and reconciliation of financial information. Furthermore, they lack a written procedures manual detailing the processes to follow in obtaining accounting data and reporting it to the Federal government, ensuring that the responsibility does not fall on a single individual. POSSIBLE ASSERTED EFFECT ADSEF does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports to the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend ADSEF to establish written procedures and internal controls manuals to provide and document the segregation of duties related to the reporting compliance requirement.
FINDING REFERENCE NUMBER 2023-054 (See Finding Reference Number 2023-023) FEDERAL PROGRAMS (ALN – 93.556) MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.667) SOCIAL SERVICES BLOCK GRANT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRFPSS (Federal Award Years: 2021 through 2022) 2211PRSOSR (Federal Award Years: 2021 through 2022) ADMINISTRATION ADMINISTRATION FOR FAMILIES AND CHILDREN (ADFAN, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR § 200.302 (a) establishes that each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. See § 200.450. In addition, the SF-425 Federal Financial Report requires the reporting of financial activities related to Federal awards. The accounting basis used for reporting expenditures (whether cash or accrual) must align with the accounting system employed by the recipient organization. The 2 CFR § 200.302 (b), establish that the recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (6) written procedures to implement the requirements of § 200.305 and (7) written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. The 2 CFR section 200.328(c) establishes that the recipient or subrecipient must submit financial reports as required by the Federal award. Reports submitted annually by the recipient or subrecipient must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. The 2 CFR §200.303 (a) establishes that the recipient and subrecipient must: establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should align with the guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control-Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). STATEMENT OF CONDITION As part of our audit procedures over internal controls and compliance for reporting requirements, we selected the Grants Awards 2101PRFPSS and 2111PRSOSR, which closes in the audit period from July 2022 to June 2023, to validate the recorded amounts. Upon evaluating the report for the Grant Award 2101PRFPSS, we found the following deficiencies: (1) The total Federal expenditure reported on line (e) does not match the database provided by the PRDF. (2) The matching expenditure on line (j) does not match the database provided by the PRDF, and (3) The report was not submitted within the established deadline, and an extension was granted to settle and report the funds until March 31, 2023, and they submitted on August 10, 2023. For both Grants Awards we found the following deficiencies: (4) The accounting basis should be Cash Basis instead of Accrual Basis, according to the accounting system used. Additionally, they provided a Procedures Manual for the Finance and Budget Divisions, approved in 2009 and delivered in Word format, which states that the accounting basis is “accrual”, even though their current system operates on a cash basis. (5) During the internal control’s interviews, we found that there is no designated person responsible for reviewing the information entered by the preparer. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This deficiency is a systemic problem. Procedures and internal controls manuals should provide for and ensure the segregation of duties, training, and the reconciliation of financial information reported to Federal agencies against the accounting records used to prepare financial statement and SEFA. STATEMENT OF CAUSE ADFAN does not have internal controls to effectively review the process and comply with the reporting requirements. The absence of effective internal controls at ADFAN to review processes and ensure compliance with reporting requirements can be attributed to inadequate organizational structure and insufficiently defined roles and responsibilities. There is no designated individual or team responsible for overseeing the accuracy and completeness of financial data entered reports. As mentioned above in the statement of condition, this responsibility falls under one person and does not have segregation of duties. This gap in accountability stems from a lack of internal review and insufficient oversight mechanisms, which restrains the organization's ability to ensure that reports are fully aligned with the required compliance standards. Additionally, there is a lack of training or resources dedicated to maintaining and monitoring compliance which contributes to the failure in reporting requirements. POSSIBLE ASSERTED EFFECT ADFAN does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports for the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that ADFAN ensures the SF– 425 is completed using the appropriate accounting basis consistent with the organization’s financial system. Additionally, ADFAN should establish and implement internal control procedures that include formal review process to verify the accuracy and completeness of the reported information and designate responsible personnel for the review and approval of reports prior to submission to ensure compliance with Federal reporting requirements.
FINDING REFERENCE NUMBER 2023-054 (See Finding Reference Number 2023-023) FEDERAL PROGRAMS (ALN – 93.556) MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.667) SOCIAL SERVICES BLOCK GRANT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRFPSS (Federal Award Years: 2021 through 2022) 2211PRSOSR (Federal Award Years: 2021 through 2022) ADMINISTRATION ADMINISTRATION FOR FAMILIES AND CHILDREN (ADFAN, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR § 200.302 (a) establishes that each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. See § 200.450. In addition, the SF-425 Federal Financial Report requires the reporting of financial activities related to Federal awards. The accounting basis used for reporting expenditures (whether cash or accrual) must align with the accounting system employed by the recipient organization. The 2 CFR § 200.302 (b), establish that the recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (6) written procedures to implement the requirements of § 200.305 and (7) written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. The 2 CFR section 200.328(c) establishes that the recipient or subrecipient must submit financial reports as required by the Federal award. Reports submitted annually by the recipient or subrecipient must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. The 2 CFR §200.303 (a) establishes that the recipient and subrecipient must: establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should align with the guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control-Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). STATEMENT OF CONDITION As part of our audit procedures over internal controls and compliance for reporting requirements, we selected the Grants Awards 2101PRFPSS and 2111PRSOSR, which closes in the audit period from July 2022 to June 2023, to validate the recorded amounts. Upon evaluating the report for the Grant Award 2101PRFPSS, we found the following deficiencies: (1) The total Federal expenditure reported on line (e) does not match the database provided by the PRDF. (2) The matching expenditure on line (j) does not match the database provided by the PRDF, and (3) The report was not submitted within the established deadline, and an extension was granted to settle and report the funds until March 31, 2023, and they submitted on August 10, 2023. For both Grants Awards we found the following deficiencies: (4) The accounting basis should be Cash Basis instead of Accrual Basis, according to the accounting system used. Additionally, they provided a Procedures Manual for the Finance and Budget Divisions, approved in 2009 and delivered in Word format, which states that the accounting basis is “accrual”, even though their current system operates on a cash basis. (5) During the internal control’s interviews, we found that there is no designated person responsible for reviewing the information entered by the preparer. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This deficiency is a systemic problem. Procedures and internal controls manuals should provide for and ensure the segregation of duties, training, and the reconciliation of financial information reported to Federal agencies against the accounting records used to prepare financial statement and SEFA. STATEMENT OF CAUSE ADFAN does not have internal controls to effectively review the process and comply with the reporting requirements. The absence of effective internal controls at ADFAN to review processes and ensure compliance with reporting requirements can be attributed to inadequate organizational structure and insufficiently defined roles and responsibilities. There is no designated individual or team responsible for overseeing the accuracy and completeness of financial data entered reports. As mentioned above in the statement of condition, this responsibility falls under one person and does not have segregation of duties. This gap in accountability stems from a lack of internal review and insufficient oversight mechanisms, which restrains the organization's ability to ensure that reports are fully aligned with the required compliance standards. Additionally, there is a lack of training or resources dedicated to maintaining and monitoring compliance which contributes to the failure in reporting requirements. POSSIBLE ASSERTED EFFECT ADFAN does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports for the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that ADFAN ensures the SF– 425 is completed using the appropriate accounting basis consistent with the organization’s financial system. Additionally, ADFAN should establish and implement internal control procedures that include formal review process to verify the accuracy and completeness of the reported information and designate responsible personnel for the review and approval of reports prior to submission to ensure compliance with Federal reporting requirements.
FINDING REFERENCE NUMBER 2023-056 (See Finding Reference Number 2023-025) FEDERAL PROGRAMS (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) 2022G9922PT; 2301PRTABD (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING – FINANCIAL TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA The 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. See § 200.450. (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. … (6) Written procedures to implement the requirements of § 200.305 and (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION As part of our audit procedures over the reporting requirement for TANF and Payment to Territories – Adult programs, we selected two reports submitted during our fiscal year. We found the following deficiencies: i. Administrative expenditures related to both programs are recorded under the same accounting account number, and the assistance listing number of TANF. That is, in PRIFAS, the administrative expenditures of both programs are not segregated by grant award and assistance listing number. ii. The ACF-196TR reports report expenditures under both programs that are not reconciled with the PRIFAS accounting system, specifically in administrative expenditures. We requested evidence of the expenditures incurred or details that were used to prepare the reports; this information was not available, and it was generated upon our request. iii. In both reports evaluated, the amounts reported on lines 2 and 3, related to the amounts that the TANF program transfers to two other federal programs, are recorded inconsistently. During the quarters from October to June, these lines report the amount of the budget that is allowed to be transferred, without validating whether the Federal programs incurred any expenditures. In the quarterly report of September, the expenditure for these lines is reported based on the amount of drawdowns incurred. This practice is inconsistent and does not reflect the actual expenditure incurred. iv. In the quarterly report of June 2023, an expenditure of $3,733,668 was reported on line 5(a). According to PRIFAS, the reported expenditure was $1,988,000. QUESTIONED COSTS Undetermined. PERSPECTIVE INFORMATION This is a systematic deficiency. Procedures and internal controls manuals should provide for and ensure the segregation of duties, and the reconciliation of financial information reported to federal agencies against the accounting records used to prepare financial statements and SEFA. In addition, the financial management system should provide to account separately the administrative expenditures incurred among all Federal programs administered. ADSEF failure to support reported amounts with verifiable documentation and the absence of independent review increases the risk of inaccurate or misstated financial data being reported to the federal awarding agency. STATEMENT OF CAUSE During our interviews and understanding of the internal controls over financial reporting, we noted that only one person prepares, submits and certifies the ACF-196TR reports. No proper segregation of duties exists, that allows for validation of all accounting data before submitting the reports. In addition, the procedures manual for preparing reports does not establish a clear process for obtaining information, validating it, recording it, preparing it, and reporting it, as well as the responsibilities and segregation of duties to ensure that the reported information is consistent with ADSEF's accounting records. PRIFAS accounting data base as configured, does not provide for the administrative expenditures incurred from the TANF and Payment to Territories – Adult program to be segregated. ADSEF lacks internal controls that allow for the timely validation and reconciliation of financial information. Furthermore, they lack a written procedures manual detailing the processes to follow in obtaining accounting data and reporting it to the federal government, ensuring that the responsibility does not fall on a single individual. POSSIBLE ASSERTED EFFECT ADSEF does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports to the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend ADSEF to establish written procedures and internal controls manuals to provide and document the segregation of duties related to the reporting compliance requirement. Additionally, work with the Puerto Rico Department of the Treasury to provide accounting records to segregate the administrative expenditures of both programs.
FINDING REFERENCE NUMBER 2023-056 (See Finding Reference Number 2023-025) FEDERAL PROGRAMS (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) 2022G9922PT; 2301PRTABD (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING – FINANCIAL TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA The 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. See § 200.450. (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. … (6) Written procedures to implement the requirements of § 200.305 and (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION As part of our audit procedures over the reporting requirement for TANF and Payment to Territories – Adult programs, we selected two reports submitted during our fiscal year. We found the following deficiencies: i. Administrative expenditures related to both programs are recorded under the same accounting account number, and the assistance listing number of TANF. That is, in PRIFAS, the administrative expenditures of both programs are not segregated by grant award and assistance listing number. ii. The ACF-196TR reports report expenditures under both programs that are not reconciled with the PRIFAS accounting system, specifically in administrative expenditures. We requested evidence of the expenditures incurred or details that were used to prepare the reports; this information was not available, and it was generated upon our request. iii. In both reports evaluated, the amounts reported on lines 2 and 3, related to the amounts that the TANF program transfers to two other federal programs, are recorded inconsistently. During the quarters from October to June, these lines report the amount of the budget that is allowed to be transferred, without validating whether the Federal programs incurred any expenditures. In the quarterly report of September, the expenditure for these lines is reported based on the amount of drawdowns incurred. This practice is inconsistent and does not reflect the actual expenditure incurred. iv. In the quarterly report of June 2023, an expenditure of $3,733,668 was reported on line 5(a). According to PRIFAS, the reported expenditure was $1,988,000. QUESTIONED COSTS Undetermined. PERSPECTIVE INFORMATION This is a systematic deficiency. Procedures and internal controls manuals should provide for and ensure the segregation of duties, and the reconciliation of financial information reported to federal agencies against the accounting records used to prepare financial statements and SEFA. In addition, the financial management system should provide to account separately the administrative expenditures incurred among all Federal programs administered. ADSEF failure to support reported amounts with verifiable documentation and the absence of independent review increases the risk of inaccurate or misstated financial data being reported to the federal awarding agency. STATEMENT OF CAUSE During our interviews and understanding of the internal controls over financial reporting, we noted that only one person prepares, submits and certifies the ACF-196TR reports. No proper segregation of duties exists, that allows for validation of all accounting data before submitting the reports. In addition, the procedures manual for preparing reports does not establish a clear process for obtaining information, validating it, recording it, preparing it, and reporting it, as well as the responsibilities and segregation of duties to ensure that the reported information is consistent with ADSEF's accounting records. PRIFAS accounting data base as configured, does not provide for the administrative expenditures incurred from the TANF and Payment to Territories – Adult program to be segregated. ADSEF lacks internal controls that allow for the timely validation and reconciliation of financial information. Furthermore, they lack a written procedures manual detailing the processes to follow in obtaining accounting data and reporting it to the federal government, ensuring that the responsibility does not fall on a single individual. POSSIBLE ASSERTED EFFECT ADSEF does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports to the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend ADSEF to establish written procedures and internal controls manuals to provide and document the segregation of duties related to the reporting compliance requirement. Additionally, work with the Puerto Rico Department of the Treasury to provide accounting records to segregate the administrative expenditures of both programs.
Federal Program Information: Federal Assistance Listing Number: 21.027 Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Federal Agency: U.S. Department of Treasury Federal Award Number: None Federal Award Year: March 3, 2021 to December 31, 2024 Criteria: 2 CFR 200.328, Financial Reporting, emphasizes the importance of submitting performance and financial reports that are complete, accurate, and consistent with the accounting records. Specifically: Financial data must be derived from and consistent with the recipient's accounting records. Reports must include all financial information in accordance with federal requirements. Additionally, 2 CFR 200.303, Internal Controls, mandates the implementation of effective internal controls, including proper segregation of duties, to maintain financial integrity and ensure compliance with federal regulations. Condition: The City's Annual Project and Expenditure Report (P&E) did not properly report federal expenditures for fiscal year 2023, as it does not align with the City's accounting records. Specifically, $98,428 in eligible fiscal year 2024 expenditures were incorrectly reported as fiscal year 2023 expenditures. While this amount is considered an eligible cost under the program, it was not reported properly in the correct accounting and reporting period. Additionally, the lack of segregation of duties, where the same personnel handled both preparation and review, raises concerns about internal control deficiencies and the risk of reporting errors. Questioned Cost: None. Cause and Effect: The City Council authorized federal expenditures for the CSLFRF project as a lump sum, resulting in the reporting of all eligible expenditures in a single reporting period, rather than aligning them with the appropriate fiscal year. Additionally, since CSLFRF was newly established in response to COVID-19 in 2021, the City had limited experience with managing and reporting such grants. The lack of prior exposure, coupled with an insufficient number of qualified staff, contributed to inaccuracies in financial reporting and deficiencies in internal controls. Recommendation: To ensure compliance with federal reporting requirements and strengthen internal controls, the City should: 1. Establish a reconciliation procedure to ensure all reported expenditures in the Annual Project and Expenditure Report (P&E) align with the City's accounting records. 2. Implement a structured review process that requires independent verification of financial reports. Assign separate personnel for the preparation and review of reports to address concerns regarding segregation of duties. 3. Conduct regular training sessions for finance and grant management staff to improve understanding of federal grant reporting requirements and best practices, ensuring the accuracy of future submissions. Views of Responsible Personnel and Corrective Action Plan: Management has instructed the department managers involved with grants to work with the Finance Director and Senior Accountant for all future grant accounting and reporting to ensure that grant expenditures are properly recorded and reported in the correct period. The Senior Accountant will complete GFOA’s Generally Accepted Accounting Principles for Grants in August 2026. As of the date of this letter, Management is working to identify other grants-related training appropriate for the Senior Accountant, the Utility Manager, and the Director of Development Services and Capital Projects, all of whom are involved in grant proposals, management, expenditures, accounting and required reporting. Meetings with all three department managers will be scheduled to coordinate administration and deadlines for the City’s new and existing grants as grant reporting deadlines occur. Responsible Personnel Name and Position: Jill Taura, Interim Finance Director Expected Implementation Date of Corrective Action Plan: Fiscal year 2026
State Agency: Illinois Governor’s Office of Management and Budget (GOMB) Federal Agency: U.S. Department of the Treasury (TREAS) Program Name: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds ALN and Program Expenditures 21.027 ($2,804,581,453) Award Numbers: Various - see table of award numbers Federal Award Year: Various - see table of award numbers Questioned Costs: None Compliance Requirement: Reporting Finding 2023-003: Failure to Accurately Prepare Performance Reports for the COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Program Condition Found: GOMB did not prepare accurate federal project and expenditure reports (Paperwork Reduction Act (PRA) 1505-0271) for the COVID-19 – Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) program. The State was required to prepare quarterly federal project and expenditure reports (PRA 1505-0271) for the CSLFRF program. To assist the State agencies, GOMB prepared these reports. According to the U.S. Treasury’s SLFRF Compliance and Reporting Guidance, expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. During our testing of two quarterly PRA 1505-0271 reports submitted during State fiscal year ended June 30, 2023, we noted that GOMB did not consistently apply cash or accrual basis for reporting and noted the following errors on the cash basis: "See Table in the Audit Report". Supervisory review procedures of the PRA 1505-0271 reports have not been designed to operate at an appropriate level of precision to ensure the financial reports are accurately prepared. Criteria or Requirement: 2 CFR 200.328 requires grantees to submit PRA 1505-0271 reports with the frequency required by the terms and conditions of the federal award. The State and Local Fiscal Recovery Funds: Project and Expenditure Report User Guide requires grantees to submit quarterly reports with current financial information, including current period and cumulative obligations and expenditures. In addition, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure financial information reported in required financial reports is complete and accurate prior to submission. Cause: In discussing these conditions with GOMB officials, management stated the reporting errors were a result of inaccurate information submitted to GOMB by other State agencies which were not detected. Possible Asserted Effect: Failure to prepare complete and accurate financial reports prevents the U.S. Treasury from effectively monitoring the CSLFRF program. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2023-003) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend GOMB implement more precise review procedures to ensure the reports submitted to the U.S. Treasury are complete, accurate, and agree or reconcile to its financial records. Views of GOMB Officials: GOMB agrees with the recommendation. GOMB will continue to work with the State agencies to produce accurate financial reporting for the CSLFRF program.
State Agency: Illinois Governor’s Office of Management and Budget (GOMB) Federal Agency: U.S. Department of the Treasury (TREAS) Program Name: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds ALN and Program Expenditures 21.027 ($2,804,581,453) Award Numbers: Various - see table of award numbers Federal Award Year: Various - see table of award numbers Questioned Costs: None Compliance Requirement: Reporting Finding 2023-003: Failure to Accurately Prepare Performance Reports for the COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Program Condition Found: GOMB did not prepare accurate federal project and expenditure reports (Paperwork Reduction Act (PRA) 1505-0271) for the COVID-19 – Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) program. The State was required to prepare quarterly federal project and expenditure reports (PRA 1505-0271) for the CSLFRF program. To assist the State agencies, GOMB prepared these reports. According to the U.S. Treasury’s SLFRF Compliance and Reporting Guidance, expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. During our testing of two quarterly PRA 1505-0271 reports submitted during State fiscal year ended June 30, 2023, we noted that GOMB did not consistently apply cash or accrual basis for reporting and noted the following errors on the cash basis: "See Table in the Audit Report". Supervisory review procedures of the PRA 1505-0271 reports have not been designed to operate at an appropriate level of precision to ensure the financial reports are accurately prepared. Criteria or Requirement: 2 CFR 200.328 requires grantees to submit PRA 1505-0271 reports with the frequency required by the terms and conditions of the federal award. The State and Local Fiscal Recovery Funds: Project and Expenditure Report User Guide requires grantees to submit quarterly reports with current financial information, including current period and cumulative obligations and expenditures. In addition, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure financial information reported in required financial reports is complete and accurate prior to submission. Cause: In discussing these conditions with GOMB officials, management stated the reporting errors were a result of inaccurate information submitted to GOMB by other State agencies which were not detected. Possible Asserted Effect: Failure to prepare complete and accurate financial reports prevents the U.S. Treasury from effectively monitoring the CSLFRF program. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2023-003) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend GOMB implement more precise review procedures to ensure the reports submitted to the U.S. Treasury are complete, accurate, and agree or reconcile to its financial records. Views of GOMB Officials: GOMB agrees with the recommendation. GOMB will continue to work with the State agencies to produce accurate financial reporting for the CSLFRF program.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S. Department of the Treasury (TREAS) Program Name: COVID-19 – Homeowner Assistance Fund Program ALN and Program Expenditures: 21.026 ($177,107,928) Award Numbers: Various - see table of award numbers Federal Award Year: Various - see table of award numbers Questioned Costs: None Compliance Requirement: Reporting Finding 2023-005: Failure to Accurately Prepare Financial Reports for the COVID-19 – Homeowner Assistance Fund Program Condition Found: IDHS did not prepare accurate federal financial reports (Paperwork Reduction Act (PRA) 1505-0269) for the COVID-19 – Homeowner Assistance Fund (HAF) program. IDHS was required to prepare quarterly federal financial reports (PRA 1505-0269) for the HAF program. During our testing of two quarterly PRA 1505-0269 reports submitted during State fiscal year ended June 30, 2023, we noted the following errors: "See Table in the Audit Report". Supervisory review procedures of the PRA 1505-0269 reports have not been designed to operate at an appropriate level of precision to ensure the financial reports are accurately prepared. Criteria or Requirement: 2 CFR 200.328 requires grantees to submit PRA 1505-0269 reports with the frequency required by the terms and conditions of the federal award. The Homeowner Assistance Fund: Quarterly Report User Guide requires grantees to submit quarterly reports with current financial information, including administrative expenses. In addition, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure financial information reported in required financial reports is complete and accurate prior to submission. Cause: In discussing these conditions with IDHS officials, management stated that during the reporting period sampled, the 3rd quarter report was the first group of program data reported. Due to limited availability of staff at that time, the Department was still working to identify appropriate staff to complete the reporting. Possible Asserted Effect: Failure to prepare complete and accurate financial reports prevents U.S. Treasury from effectively monitoring the HAF program. Repeat Finding: A similar finding was not reported in prior years. (Finding Code 2023-005) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS implement more precise review procedures to ensure the reports submitted to U.S. Treasury are complete, accurate, and agree or reconcile to its financial records. Views of IDHS Officials: The Department accepts the recommendation. The Department recognizes the need for accurate data submissions and now has standard templates for subrecipients to complete to ensure accurate program reporting is achieved.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were prepared by the Treasurer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction, of errors prior to submission. Due to the lack of effective internal controls, one of the six annual data reports was not supported by the School Corporation's records. For the ESSER III, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022, total expenses per the report were $688,778. However, the School Corporation's ledger had total expenses for the award, for that time period, of $784,638. INDIANA STATE BOARD OF ACCOUNTS 18 OAK HILL UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls and noncompliance were isolated to the ESSER III, Year 2 report. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the ESSER III, Year 2 report was not supported by the School Corporation's records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. 19 INDIANA STATE BOARD OF ACCOUNTS OAK HILL UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that all expenditures are reported on the reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were prepared by the Treasurer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction, of errors prior to submission. Due to the lack of effective internal controls, one of the six annual data reports was not supported by the School Corporation's records. For the ESSER III, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022, total expenses per the report were $688,778. However, the School Corporation's ledger had total expenses for the award, for that time period, of $784,638. INDIANA STATE BOARD OF ACCOUNTS 18 OAK HILL UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls and noncompliance were isolated to the ESSER III, Year 2 report. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the ESSER III, Year 2 report was not supported by the School Corporation's records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. 19 INDIANA STATE BOARD OF ACCOUNTS OAK HILL UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that all expenditures are reported on the reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Federal Agency: U.S. Department of Homeland Security Pass-Through Agency: Central Office of Recovery, Reconstruction and Resiliency of Puerto Rico (COR3) Program: Disaster Grants – Public Assistance (Presidentially-Declared Disaster) (ALN 97.036) Compliance Requirement: Reporting (L) Type of Finding: Significant Deficiency in Internal Control (SD), Instance of Noncompliance (NC) Statement of Condition In our Reporting Test, we evaluated the Quarterly Progress Reports of a total of five (5) projects for two quarters of fiscal year 2022-2023. Our audit procedures revealed that Quarterly Progress Reports were not submitted for one of the quarters for four of the five projects evaluated. Criteria 2 CFR 200.328 (c) states that the recipient or subrecipient must submit financial reports as required by the Federal award. […] Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. 2 CFR 200.329 (c) (1) states that the recipient or subrecipient must submit performance reports as required by the Federal award. […] Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. […] 2 CFR 200.332 (b) (3) states that any additional requirements that the pass-through entity imposes on the subrecipient for the pass-through entity to meet its responsibilities under the Federal award. This includes information and certifications […] required for submitting financial and performance reports that the pass-through entity must provide to the Federal agency. 44 CFR 206.204 (f) states that progress reports will be submitted by the recipient to the Regional Administrator quarterly. […] COR3, as a pass-through entity, requires Subrecipients to complete and submit a quarterly progress report for each Project Worksheet (“PW”) through the Disaster Recovery Solution (“DRS”) Platform. This information is then submitted to the Federal Emergency Management Agency (FEMA). Quarterly Progress Reports cannot be edited or submitted after the deadline. Cause of Condition The Municipality did not manage time effectively to complete the Quarterly Progress Reports as required by the Federal award. Effect of Condition The Municipality failed in the submission of Quarterly Progress Reports as required by the Federal award. Recommendation We recommend the Program Administrators manage time effectively to complete the Quarterly Progress Reports timely. Questioned Costs None. Views of Responsible Officials and Planned Corrective Action We will give instructions to the accounting staff in charge of the preparation of the quarterly progress reports of the Program, in order to comply with the FEMA reporting requirements. Responsible Official: Mrs. Irma M. Vargas Aguirre, Finance and Budget Director Implementation Date: December 31, 2025
Name: Schools and Roads – Grants to States Assistance Listing #:10.665 Federal Grantor: U.S. Department of Agriculture Pass-Through Entity: State Controller’s Office Award No.: Various Year: 2022-23 Compliance Requirement: Reporting Criteria: Per 2 CFR 200.328 and program-specific requirements under the Secure Rural Schools and Community Self-Determination Act (Public Law 110-343, as amended), counties receiving Title III funds must annually certify the amount of funds expended and the amount of unobligated funds by February 1 following the end of the Federal fiscal year. The certification must be submitted to the appropriate U.S. Forest Service Regional Office. Condition: For the fiscal year ended June 30, 2023, the County did not file the required Certification of Title III Expenditures and Unobligated Funds by the statutory deadline of February 1, 2024. Cause: The County did not have adequate procedures in place to track and ensure timely completion and submission of required federal reports for Title III funds. Effect: Failure to submit the certification may result in noncompliance with federal requirements and could lead to future ineligibility for Title III funds or required return of unobligated funds. Questioned Cost: No questioned costs were identified as a result of our procedures. Context: The condition noted above was identified during our procedures related to compliance testing over the major program identified above. Repeat Finding: This is not a repeat finding. Recommendation: We recommend that the County establish internal control procedures to ensure that required certifications for Title III expenditures and unobligated funds are completed, reviewed, and submitted timely in accordance with federal requirements. Views of Responsible Officials and Planned Corrective Action: Refer to separate Managements’ Corrective Action Plan for views of responsible officials and management’s responses.
Name: Epidemioloy and Laboratory Capacity for Infectious Diseases (ELC) Assistance Listing #: 93.323 Federal Grantor: U.S. Department of Health and Human Services Pass-Through Entity: State Department of Public Health Award No.: 19-ELC32 and 19-ELC90 Year: 2022-23 Compliance Requirement: Reporting Criteria: Per 2 CFR 200.327 and 200.328, recipients of federal awards must submit required financial and performance reports by the due dates specified in the award terms and conditions. The Notice of Award for ALN 93.323 requires the submission of monthly and quarterly expenditure and progress reports within 30 days after the end of each reporting period. Condition: During audit testing, it was noted that a majority of the required reports were not submitted within the required 30 day timeframe. Documentation provided by the grantee confirmed that the reports were filed late. Cause: The delays occurred due to staff turnover within the Plumas County Department of Health. Effect: Failure to submit required reports in a timely manner may hinder the federal agency's ability to monitor financial and program performance, increasing the risk of delayed reimbursement or potential noncompliance with grant requirements. Questioned Cost: No questioned costs were identified as a result of our procedures. Context: The condition noted above was identified during our procedures related to compliance testing over the major program identified above. Repeat Finding: This is not a repeat finding. Recommendation: We recommend that management establish and enforce procedures to ensure all required federal financial and progress reports are submitted by the applicable due dates. Views of Responsible Officials and Planned Corrective Action: Refer to separate Managements’ Corrective Action Plan for views of responsible officials and management’s responses.
2023-008 Improve Controls and Compliance with Reporting Federal Program Information Federal Agency: U.S. Department of Treasury Award Name(s): COVID-19 Coronavirus State and Local Fiscal Recovery Fund Assistance Listing Number(s): 21.027 Award Year: 2023 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance – Material Weakness Criteria or Specific Requirement Recipients of American Rescue Plan Act (ARPA) State and Local Fiscal Recovery Funds are required by Uniform Guidance (2 CFR § 200.328–200.329) and program requirements to submit accurate and timely quarterly performance and evaluation reports to the federal awarding agency. The City must maintain documentation supporting the submission and content of required reports as part of effective internal control over compliance. Condition and Context As part of our testing of the ARPA program, the City was unable to provide the requested quarterly performance and evaluation reports as required to be submitted under the program. Cause The City did not have adequate controls in place to ensure the timely preparation, submission, and retention of required quarterly performance and evaluation reports. Effect or Potential Effect Failure to prepare, submit, and retain quarterly performance and evaluation reports results in noncompliance with ARPA program requirements and undermines transparency and accountability for federal funds received. Questioned Costs No questioned costs are reported. Identification as a Repeat Finding This was not a finding in the prior year. Recommendation The City should establish and implement formal procedures to ensure all required quarterly performance and evaluation reports are prepared, submitted, and retained in accordance with program requirements. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Management should regularly monitor compliance with reporting deadlines and maintain adequate documentation. Views of Responsible Official Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
2023-010 Improve Controls and Compliance with Reporting Federal Program Information Federal Agency: U.S. Department of Housing and Urban Development Award Name(s): CDBG Entitlement Grants Cluster Assistance Listing Number(s): 14.218 Award Year: 2023 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance – Material Weakness Criteria or Specific Requirement Per Uniform Guidance (2 CFR § 200.328–200.329) and program-specific requirements for Community Development Block Grants/Entitlement Grants, recipients must submit required financial and programmatic reports accurately and timely to the federal awarding agency. Effective internal controls must be in place to ensure compliance with all reporting deadlines. Condition and Context The City did not file required financial and programmatic reports in a timely manner as stipulated under the grant program. Multiple reports were submitted after their respective deadlines, including the Consolidated Annual Performance and Evaluation Report (CAPER) which is required to be submitted 90 days after the close of a jurisdiction’s program year but was actually submitted in October of 2025. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Cause The City lacked adequate internal controls and procedures to ensure timely preparation, review, and submission of required reports to the federal awarding agency. Effect or Potential Effect Failure to file financial and programmatic reports on time constitutes noncompliance with federal program requirements and reduces transparency and accountability regarding the use of federal funds. Questioned Costs No questioned costs are reported. Identification as a Repeat Finding This is a repeat of prior year finding 2022-005. Recommendation The City should establish and implement formal procedures and controls to monitor reporting deadlines, ensure timely completion and submission of required financial and programmatic reports, and maintain documentation evidencing compliance with all reporting requirements. Views of Responsible Official Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
2 CFR § 2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 C.F.R. § 200.328 which states, unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMB-approved governmentwide data elements for collection of financial information (at time of publication the Federal Financial Report or such future, OMB-approved, governmentwide data elements available from the OMB-designated standards lead. This information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes, and preferably in coordination with performance reporting. The Federal awarding agency must use OMB-approved common information collections, as applicable, when providing financial and performance reporting information. 2 CFR § 200.208 states, in part, that Federal awarding agencies are responsible for ensuring that specific Federal award conditions are consistent with the program design reflected in § 200.202 and include clear performance expectations of recipients as required in § 200.301. The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed, in accordance with this section, based on an analysis of specified factors. Additional Federal award conditions may be added provided the applicant or non-Federal entity has been notified, and any additional requirements must be promptly removed once the conditions that prompted them have been satisfied. Additional Federal award conditions may include items such as additional, more detailed financial reports. The State of Ohio Community Development Block Grant (CDBG) Program Grant Agreements for the Village of Lafayette Water Line Project (B-W-20-1AB-1), the Gomer Wastewater Collection System Project (B-W-1AB-3) and Village of Harrod Water Line Project (B-W-20-1AB-2), state that the grantee shall submit the required reports in an adequate and timely fashion. Granter shall provide a format for these reports and shall instruct Grantee on the proper completion of said reports. All report forms and requirements listed herein shall be provided by Granter, but shall not be construed to limit Granter in making additional and/or further requests, nor in the change or addition of detail to the items listed. The Grantee shall submit to Granter a Status Report within 30 days of the request by Granter. The County submitted Status Reports; however, three out of six (fifty percent) Status Reports were submitted between three to six months late and for one out of six (sixteen percent) Status Reports the receipts and expenditures did not agree to the County records. Reporting errors could adversely affect future grant awards. A control system should be implemented to help ensure required reports are accurately prepared and submitted in a timely manner.
Community Development Financial Institutions Rapid Response Program (CDFI RRP), Assistance Listing Number: 21.024 U.S. Department of the Treasury Program Year 2022 Criteria or specific requirement – Reporting (2 CFR section 200.328 and 200.329) Condition – The Credit Union reported the incorrect amount of cumulative awards expended in the 2022 Use of Awards Report. Cause – The Credit Union’s controls did not ensure the proper amounts were reported. Effect – The Credit Union reported the incorrect amount of awards expended during 2022. Questioned costs – N/A Context – The Credit Union is required to submit three reports for the year ended December 31, 2022. All of the required reports were tested. The 2022 Use of Awards report reported $828,265 as the cumulative use of award, rather than the actual total cumulative use of $1,826,265 that was actually expended during the year. Identification as a repeat finding, if applicable – N/A Recommendation – Management should review and update controls over federal grant reporting to ensure reports are prepared using complete and accurate information. Views of responsible officials and planned corrective actions – The input error was corrected prior to end of the audit. The credit union's CDFI analyst was contacted by the Chief Strategic Officer and the analyst opened the data field for editing in the AMIS system. The Chief Strategic Officer made the correction in the AMIS system and submitted the corrected information. The Chief Strategic Officer has assigned CDFI reporting responsibilities to the Director of Strategy. Future submissions will be performed by the Director of Strategy and reviewed by the Chief Strategic Officer prior to submission.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Criteria: In accordance with 2 CFR 200.328 and 2 CFR 200.329, the College is required to prepare and publicly post quarterly reports related to the student aid and institutional portions of HEERF expenditures. Condition: During our audit, we selected one of the four quarterly reports to test the accuracy of the reporting. Our testing indicated certain amounts on the quarterly report that did not agree to the expenditures for the quarter. Questioned Costs: None Effect: The College was not in compliance with HEERF reporting requirements. Cause: Certain HEERF I expenditures were improperly excluded from the report and some misunderstanding of requirements of certain items in the report. Recommendation: We recommend reconciliation of quarterly reports to related grant documentation and review of the reports by an appropriate team member to ensure accuracy. Views of responsible officials and planned corrective action: The College agrees with this finding and will adhere to the corrective action plan on page 34 in this audit report.
Criteria: In accordance with 2 CFR 200.328 and 2 CFR 200.329, the College is required to prepare and publicly post quarterly reports related to the student aid and institutional portions of HEERF expenditures. Condition: During our audit, we selected one of the four quarterly reports to test the accuracy of the reporting. Our testing indicated certain amounts on the quarterly report that did not agree to the expenditures for the quarter. Questioned Costs: None Effect: The College was not in compliance with HEERF reporting requirements. Cause: Certain HEERF I expenditures were improperly excluded from the report and some misunderstanding of requirements of certain items in the report. Recommendation: We recommend reconciliation of quarterly reports to related grant documentation and review of the reports by an appropriate team member to ensure accuracy. Views of responsible officials and planned corrective action: The College agrees with this finding and will adhere to the corrective action plan on page 34 in this audit report.
Criteria: In accordance with 2 CFR 200.328 and 2 CFR 200.329, the College is required to prepare and publicly post quarterly reports related to the student aid and institutional portions of HEERF expenditures. Condition: During our audit, we selected one of the four quarterly reports to test the accuracy of the reporting. Our testing indicated certain amounts on the quarterly report that did not agree to the expenditures for the quarter. Questioned Costs: None Effect: The College was not in compliance with HEERF reporting requirements. Cause: Certain HEERF I expenditures were improperly excluded from the report and some misunderstanding of requirements of certain items in the report. Recommendation: We recommend reconciliation of quarterly reports to related grant documentation and review of the reports by an appropriate team member to ensure accuracy. Views of responsible officials and planned corrective action: The College agrees with this finding and will adhere to the corrective action plan on page 34 in this audit report.
Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.
Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.
Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.
Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.
Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.
Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.
Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.
Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.
Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.
Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.
Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.
Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.
U.S. Department of the Treasury Passed through State of Arizona, Maricopa County (Maricopa County), Federal Financial Assistance Listing #21.027, PE386182260A4 2022, Coronavirus State and Local Fiscal Recovery Funds Reporting Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal controls over the federal awards that provide assurance that the entity is managing the federal awards in compliance with federal statutes, regulations, and the conditions of the federal award. 2 CFR 200.327 and 2 CFR 200.328 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements, to assure performance expectations are being achieved, and to report these items in accordance with program requirements. The Foundation is required to submit quarterly performance reports. Reports should be prepared complete, accurate, and in accordance with the required basis for reporting, submitted timely with the terms of the grant award, and reviewed by an individual prior to submission to ensure accuracy. Condition: Although the reports were reviewed in accordance with internal controls, the review process did not properly identify on two out of the two reports tested that they were submitted with inaccurate information. Supporting documentation for the reports submitted used budgeted expensed amounts, not actual, and the budgeted expensed amounts for the period did not agree to amounts reported. Cause: The Organization has limited staffing and did not have proper controls in place relating to review of information included in reports to ensure completeness and accuracy. Effect: Inaccurate information may be provided to the grantor regarding performance of the Foundation. Questioned Costs: None reported. Context: A nonstatistical sample of 2 out of 4 reports submitted were selected for testing. Repeat Finding from Prior Years: No Recommendation: We recommend the Foundation’s management routinely review and consider modifications that would strengthen the internal controls surrounding the reporting process, recordkeeping, and the management thereof. Specifically, management should ensure that financial records are such to provide actual amounts of grant expenditures incurred for reporting purposes at required reporting dates, and that the review control ensures that reports provided to grantors agree with internal financial records. Views of Responsible Officials: Management agrees with the finding.
2 CFR 1000.10 provides that, except for the deviations set forth elsewhere in this Part, the Department of Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards set forth at 2 CFR Part 200. 2 CFR 200.302(b) states, in part, that the financial management system of each non-Federal entity must provide for the accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. The City did not have proper internal controls in place to ensure the accurate submission of the Project and Expenditure Reports. During testing of Project and Expenditure Reports for the Coronavirus State and Local Fiscal Recovery Funds (AL #21.027), we noted that: ? The City did not properly report cumulative obligations on the report required by July 31, 2022. The City over-reported cumulative obligations due to including a funding project more than once for $880,000 to the Justice Center Design project; and ? The City did not properly report cumulative obligations nor current period expenditures on the report required by October 31, 2022. The City over-reported cumulative obligations by $880,000 due to including a funding project more than once to the Justice Center Design project. The City also over-reported current period expenditures due to including the current period expenditures of $175,741 for a funding project more than once to Rehiring Staff project. Failure to have the proper controls in place to ensure the timely and accurate submission of the Project and Expenditure Reports could result in Treasury taking action against the City for failure to comply with programmatic requirements. The City should implement and have controls in place to ensure the quarterly Project and Expenditure Reports are accurate.
2 CFR 1000.10 provides that, except for the deviations set forth elsewhere in this Part, the Department of Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards set forth at 2 CFR Part 200. 2 CFR 200.302(b) states, in part, that the financial management system of each non-Federal entity must provide for the accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. The City did not have proper internal controls in place to ensure the accurate submission of the Project and Expenditure Reports. During testing of Project and Expenditure Reports for the Coronavirus State and Local Fiscal Recovery Funds (AL #21.027), we noted that: ? The City did not properly report cumulative obligations on the report required by July 31, 2022. The City over-reported cumulative obligations due to including a funding project more than once for $880,000 to the Justice Center Design project; and ? The City did not properly report cumulative obligations nor current period expenditures on the report required by October 31, 2022. The City over-reported cumulative obligations by $880,000 due to including a funding project more than once to the Justice Center Design project. The City also over-reported current period expenditures due to including the current period expenditures of $175,741 for a funding project more than once to Rehiring Staff project. Failure to have the proper controls in place to ensure the timely and accurate submission of the Project and Expenditure Reports could result in Treasury taking action against the City for failure to comply with programmatic requirements. The City should implement and have controls in place to ensure the quarterly Project and Expenditure Reports are accurate.
2 CFR 1000.10 provides that, except for the deviations set forth elsewhere in this Part, the Department of Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards set forth at 2 CFR Part 200. 2 CFR 200.302(b) states, in part, that the financial management system of each non-Federal entity must provide for the accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. The City did not have proper internal controls in place to ensure the accurate submission of the Project and Expenditure Reports. During testing of Project and Expenditure Reports for the Coronavirus State and Local Fiscal Recovery Funds (AL #21.027), we noted that: ? The City did not properly report cumulative obligations on the report required by July 31, 2022. The City over-reported cumulative obligations due to including a funding project more than once for $880,000 to the Justice Center Design project; and ? The City did not properly report cumulative obligations nor current period expenditures on the report required by October 31, 2022. The City over-reported cumulative obligations by $880,000 due to including a funding project more than once to the Justice Center Design project. The City also over-reported current period expenditures due to including the current period expenditures of $175,741 for a funding project more than once to Rehiring Staff project. Failure to have the proper controls in place to ensure the timely and accurate submission of the Project and Expenditure Reports could result in Treasury taking action against the City for failure to comply with programmatic requirements. The City should implement and have controls in place to ensure the quarterly Project and Expenditure Reports are accurate.