FINDING REFERENCE NUMBER 2023-029 (See Finding Reference Number 2023-001) FEDERAL PROGRAM (ALN – 10.542) PANDEMIC EBT FOOD BENEFITS (P-EBT) U.S. DEPARTMENT OF AGRICULTURE AWARD NUMBERS 221PR456S9032; 2301PR456S9032 (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ACTIVITIES ALLOWED OR UNALLOWED // REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 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. … (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 As part of our internal control procedures for the financial management system, allowable activities and reporting requirements, we found the following deficiencies: • Of ten (10) expenditure accounting transactions, three (3) were selected for documentation review. It was found that a transaction posted in August 2022 for $193,642,697.32 included $54,195,406.92, corresponding to benefit payrolls for May 2022, which had previously been claimed in June 2022. They subsequently adjusted the expenditure reported for this amount. • All expenditure transactions are coded under the ID number PANDEMICEBT-B22; although, in the SF-778 report for the quarter ended June 30, 2023, for the grant award period for 2023, expenditures in the amount of $29,606,939 were reported as incurred. This data does not agree with the accounting information of PRIFAS. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This is a systematic deficiency. After conducting several interviews, we were able to identify the staff responsible for validating the benefit payrolls. This person told us these benefit payrolls were processed via email, which indicated that the information submitted was preliminary. However, the finance staff proceeded with the adjustment in the accounting system. We conducted interviews to determine if anything had been modified in the benefit payroll processing process. To prevent this situation from happening again, they told us it wasn't necessary because it hasn't happened again. 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 ADSEF has not established an adequate control procedure to identify duplicate claims before they are filed and recorded. 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 The failure to have an internal control procedure that identifies standard documentation or forms, personnel responsible for validating the information included, and controls payroll and benefit expenses and other previously claimed expenses allowed for the recognition and claim of an expense incurred twice. ADSEF is not ensuring that the reports are accurate and traceable to the accounting database used to prepare their financial reports to the Federal Agencies and their financial statements. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish an adequate internal controls process that identifies documentation, personnel responsible, authorizations, and validations that can prevent this situation from recurring. In addition, we recommend management 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-032 (See Finding Reference Number 2023-004) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 211PR426S7003/4; 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) 2022G9922PT; 2301PRTABD (Federal Award Years: 2022 through 2023) 2201PRLIEA; 2301PRLIEA (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 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. (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 As part of our audit procedures, we conducted an analysis of the process used to distribute administrative costs among the various programs administered by ADSEF. Administrative expenses are distributed based on a methodology called "Random Moment Sampling" (RMS). We identified the following deficiencies in the implementation and execution of this process: i. There is no written procedure that outlines the process for applying this formula for distributing administrative expenses. ii. There is no standardized monitoring or communication to ensure that employees who are required to complete this form are fully assigned to the roles subject to this process. In other words, the Human Resources Department or the Appointments Office do not communicate periodically or whenever a staff change occurs, in order to adjust the population subject to this questionnaire. iii. Among the options provided for responding to the RMS survey, three options are not assigned to a Federal program. These options include licenses; other types of work not directly tied to a Federal program function for which administrative expenses can be allocated. According to the State Plan, 3,300 questionnaires will be administered for functions performed by employees who are not at the central level, and 300 for employees who are at the central level. Two quarters of the Fiscal Year 2022-2023 were observed, in which these three options represented between 33% and 22% for local offices and 29% at the central level. Because these options are not tied to a Federal program function, they reduce the percentage to zero and redistribute the percentage among Federal programs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. This allocation of administrative expenses is made quarterly; however, the adjustment in the accounting system (PRIFAS) is not necessarily made in the same period. The administrative expenses of each program contain the redistribution of expenses not assigned to a Federal program. STATEMENT OF CAUSE ADSEF does not have a written procedure establishing the process for implementing and monitoring the execution of this methodology. Additionally, among the responses regarding functions performed, time may be allocated to functions not related to Federal programs. POSSIBLE ASSERTED EFFECT They lack a standardized process that ensures that the methodology used allocates reasonable administrative costs among Federal programs, ensures that the distribution base is complete, and is periodically monitored. Furthermore, by redistributing the percentage of responses not directly related to a Federal program function, administrative costs could be claimed from Federal programs that should likely be allocated to state funds. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish a written internal control procedure that provides certainty, monitoring frequency, data validation, and responsibilities for those responsible for executing this process. Additionally, it should be considered that there are functions performed by the personnel in charge of answering the RMS that are not directly linked to a Federal program and should be assigned to state funds.
FINDING REFERENCE NUMBER 2023-032 (See Finding Reference Number 2023-004) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 211PR426S7003/4; 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) 2022G9922PT; 2301PRTABD (Federal Award Years: 2022 through 2023) 2201PRLIEA; 2301PRLIEA (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 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. (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 As part of our audit procedures, we conducted an analysis of the process used to distribute administrative costs among the various programs administered by ADSEF. Administrative expenses are distributed based on a methodology called "Random Moment Sampling" (RMS). We identified the following deficiencies in the implementation and execution of this process: i. There is no written procedure that outlines the process for applying this formula for distributing administrative expenses. ii. There is no standardized monitoring or communication to ensure that employees who are required to complete this form are fully assigned to the roles subject to this process. In other words, the Human Resources Department or the Appointments Office do not communicate periodically or whenever a staff change occurs, in order to adjust the population subject to this questionnaire. iii. Among the options provided for responding to the RMS survey, three options are not assigned to a Federal program. These options include licenses; other types of work not directly tied to a Federal program function for which administrative expenses can be allocated. According to the State Plan, 3,300 questionnaires will be administered for functions performed by employees who are not at the central level, and 300 for employees who are at the central level. Two quarters of the Fiscal Year 2022-2023 were observed, in which these three options represented between 33% and 22% for local offices and 29% at the central level. Because these options are not tied to a Federal program function, they reduce the percentage to zero and redistribute the percentage among Federal programs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. This allocation of administrative expenses is made quarterly; however, the adjustment in the accounting system (PRIFAS) is not necessarily made in the same period. The administrative expenses of each program contain the redistribution of expenses not assigned to a Federal program. STATEMENT OF CAUSE ADSEF does not have a written procedure establishing the process for implementing and monitoring the execution of this methodology. Additionally, among the responses regarding functions performed, time may be allocated to functions not related to Federal programs. POSSIBLE ASSERTED EFFECT They lack a standardized process that ensures that the methodology used allocates reasonable administrative costs among Federal programs, ensures that the distribution base is complete, and is periodically monitored. Furthermore, by redistributing the percentage of responses not directly related to a Federal program function, administrative costs could be claimed from Federal programs that should likely be allocated to state funds. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish a written internal control procedure that provides certainty, monitoring frequency, data validation, and responsibilities for those responsible for executing this process. Additionally, it should be considered that there are functions performed by the personnel in charge of answering the RMS that are not directly linked to a Federal program and should be assigned to state funds.
FINDING REFERENCE NUMBER 2023-032 (See Finding Reference Number 2023-004) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 211PR426S7003/4; 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) 2022G9922PT; 2301PRTABD (Federal Award Years: 2022 through 2023) 2201PRLIEA; 2301PRLIEA (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 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. (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 As part of our audit procedures, we conducted an analysis of the process used to distribute administrative costs among the various programs administered by ADSEF. Administrative expenses are distributed based on a methodology called "Random Moment Sampling" (RMS). We identified the following deficiencies in the implementation and execution of this process: i. There is no written procedure that outlines the process for applying this formula for distributing administrative expenses. ii. There is no standardized monitoring or communication to ensure that employees who are required to complete this form are fully assigned to the roles subject to this process. In other words, the Human Resources Department or the Appointments Office do not communicate periodically or whenever a staff change occurs, in order to adjust the population subject to this questionnaire. iii. Among the options provided for responding to the RMS survey, three options are not assigned to a Federal program. These options include licenses; other types of work not directly tied to a Federal program function for which administrative expenses can be allocated. According to the State Plan, 3,300 questionnaires will be administered for functions performed by employees who are not at the central level, and 300 for employees who are at the central level. Two quarters of the Fiscal Year 2022-2023 were observed, in which these three options represented between 33% and 22% for local offices and 29% at the central level. Because these options are not tied to a Federal program function, they reduce the percentage to zero and redistribute the percentage among Federal programs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. This allocation of administrative expenses is made quarterly; however, the adjustment in the accounting system (PRIFAS) is not necessarily made in the same period. The administrative expenses of each program contain the redistribution of expenses not assigned to a Federal program. STATEMENT OF CAUSE ADSEF does not have a written procedure establishing the process for implementing and monitoring the execution of this methodology. Additionally, among the responses regarding functions performed, time may be allocated to functions not related to Federal programs. POSSIBLE ASSERTED EFFECT They lack a standardized process that ensures that the methodology used allocates reasonable administrative costs among Federal programs, ensures that the distribution base is complete, and is periodically monitored. Furthermore, by redistributing the percentage of responses not directly related to a Federal program function, administrative costs could be claimed from Federal programs that should likely be allocated to state funds. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish a written internal control procedure that provides certainty, monitoring frequency, data validation, and responsibilities for those responsible for executing this process. Additionally, it should be considered that there are functions performed by the personnel in charge of answering the RMS that are not directly linked to a Federal program and should be assigned to state funds.
FINDING REFERENCE NUMBER 2023-032 (See Finding Reference Number 2023-004) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 211PR426S7003/4; 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) 2022G9922PT; 2301PRTABD (Federal Award Years: 2022 through 2023) 2201PRLIEA; 2301PRLIEA (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 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. (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 As part of our audit procedures, we conducted an analysis of the process used to distribute administrative costs among the various programs administered by ADSEF. Administrative expenses are distributed based on a methodology called "Random Moment Sampling" (RMS). We identified the following deficiencies in the implementation and execution of this process: i. There is no written procedure that outlines the process for applying this formula for distributing administrative expenses. ii. There is no standardized monitoring or communication to ensure that employees who are required to complete this form are fully assigned to the roles subject to this process. In other words, the Human Resources Department or the Appointments Office do not communicate periodically or whenever a staff change occurs, in order to adjust the population subject to this questionnaire. iii. Among the options provided for responding to the RMS survey, three options are not assigned to a Federal program. These options include licenses; other types of work not directly tied to a Federal program function for which administrative expenses can be allocated. According to the State Plan, 3,300 questionnaires will be administered for functions performed by employees who are not at the central level, and 300 for employees who are at the central level. Two quarters of the Fiscal Year 2022-2023 were observed, in which these three options represented between 33% and 22% for local offices and 29% at the central level. Because these options are not tied to a Federal program function, they reduce the percentage to zero and redistribute the percentage among Federal programs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. This allocation of administrative expenses is made quarterly; however, the adjustment in the accounting system (PRIFAS) is not necessarily made in the same period. The administrative expenses of each program contain the redistribution of expenses not assigned to a Federal program. STATEMENT OF CAUSE ADSEF does not have a written procedure establishing the process for implementing and monitoring the execution of this methodology. Additionally, among the responses regarding functions performed, time may be allocated to functions not related to Federal programs. POSSIBLE ASSERTED EFFECT They lack a standardized process that ensures that the methodology used allocates reasonable administrative costs among Federal programs, ensures that the distribution base is complete, and is periodically monitored. Furthermore, by redistributing the percentage of responses not directly related to a Federal program function, administrative costs could be claimed from Federal programs that should likely be allocated to state funds. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish a written internal control procedure that provides certainty, monitoring frequency, data validation, and responsibilities for those responsible for executing this process. Additionally, it should be considered that there are functions performed by the personnel in charge of answering the RMS that are not directly linked to a Federal program and should be assigned to state funds.
FINDING REFERENCE NUMBER 2023-033 (See Finding Reference Number 2023-005) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 211PR426S7003/4; 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 2021G990229 (TANF – COVID-19) (Federal Award Year: 2021) 2022G996117; 2023996117 (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 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. … (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.” In addition, 45 CFR 260.31 (b)(1), defines what non-recurrent, short-term (NRST) benefits are. In relation to Pandemic Emergency Assistance Fund (PEAF), the regulation establishes that: “NRST benefits, like all NRSTs under TANF, must: be designed to deal with a specific crisis situation or episode of need; not be intended to meet on-going needs; and not extend beyond four months; and (as explained in the instructions for reporting on line 15 of the ACF-196R) NRSTs paid for with PEAF funds: must only include expenditures such as emergency assistance and diversion payments, emergency housing and short-term homelessness assistance, emergency food aid, short-term utilities payments, burial assistance, clothing allowances, and back-to-school payments; and may not include tax credits, child care, transportation, or short-term education and training.” STATEMENT OF CONDITION As part of our audit procedures over transactions related to emissions of benefits for the TANF program, we selected five (5) transactions, from a population of fifty-three (53) emissions made during the fiscal year. We noted the following deficiencies: i. An emission of benefits for $16,236,447.24 related to PEAF funding was made. We request evidence of an established manual or guide that defines or identifies the need that would be addressed with the issuance of these funds, and the subsequent monitoring of the usage. ii. An emission of benefits for $3,633,800 was made related to a bonus. The documentation for this issuance includes an authorization letter establishing a benefit of $800 per child between the ages of 5 and 17 years and 11 months, serving a population of 4,492 participants, for a total of $3,593,600. Later, another authorization letter added $37,000 but did not specify the number of children included in this amendment. The sum of both authorizations is $3,630,600; however, the amount reflected in PRIFAS is $3,633,800. According to the EBT document related to this issuance, the amount issued was $3,596,800 and indicates that the number of participants benefited was 4,974, giving an average benefit of $723.12. In this EBT document, beneficiaries are distributed by region; however, there are 5 beneficiaries who are not assigned to a region, for a total of $4,000. iii. An emission of $1,988,000 was made related to an incentive for some beneficiaries. In accordance with an authorization letter, the benefit included $3,500 per participants who worked or participated in an activity leading to employment for 3 months or more. In accordance with the State Plan, active recipients may receive a 6-months period Work Incentive Bonus payment. Per the authorization letter the benefit of $3,500 was issued to 522 participants, for a total of $1,827,000; another authorization letter increased $3,500 in funds. This amount does not agree with the PRIFAS amount of $1,988,000. ADSEF is allowed to claim 16.80% of indirect costs. As part of our audit procedures over the Nutrition Assistance for Puerto Rico and TANF program, we selected some transactions to evaluate the compliance with the indirect costs claims. The TANF program reported four (4) transactions related to indirect costs, and for the Nutrition Assistance for Puerto Rico five (5) transactions were reported. We requested evidence of two (2) transactions for the TANF program and one (1) for the Nutrition Assistance for Puerto Rico, no evidence of class object was provided in order to ascertain that only allowable expenditure transactions were considered in the calculation and claim of indirect costs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. There are no processes to reconcile PRIFAS information with emissions reported in EBT, nor to claim indirect costs. STATEMENT OF CAUSE ADSEF does not have a process for validating EBT issuances with PRIFAS, and this reconciliation is not performed periodically to detect any errors or missing information when accounting for transactions. POSSIBLE ASSERTED EFFECT The PRIFAS accounting system is not reconciled with EBT reports. This process is not stipulated as part of the internal controls required to ensure that the records used to prepare the financial statement, SEFA, and Federal reports are reconciled, and any discrepancies are identified. In addition, indirect costs calculation may include unallowable costs and not be detected timely. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish internal control processes to reconcile PRIFAS and the various sources of information used for reporting. Additionally, maintain clear records of indirect costs claimed and awarded.
FINDING REFERENCE NUMBER 2023-033 (See Finding Reference Number 2023-005) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 211PR426S7003/4; 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 2021G990229 (TANF – COVID-19) (Federal Award Year: 2021) 2022G996117; 2023996117 (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 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. … (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.” In addition, 45 CFR 260.31 (b)(1), defines what non-recurrent, short-term (NRST) benefits are. In relation to Pandemic Emergency Assistance Fund (PEAF), the regulation establishes that: “NRST benefits, like all NRSTs under TANF, must: be designed to deal with a specific crisis situation or episode of need; not be intended to meet on-going needs; and not extend beyond four months; and (as explained in the instructions for reporting on line 15 of the ACF-196R) NRSTs paid for with PEAF funds: must only include expenditures such as emergency assistance and diversion payments, emergency housing and short-term homelessness assistance, emergency food aid, short-term utilities payments, burial assistance, clothing allowances, and back-to-school payments; and may not include tax credits, child care, transportation, or short-term education and training.” STATEMENT OF CONDITION As part of our audit procedures over transactions related to emissions of benefits for the TANF program, we selected five (5) transactions, from a population of fifty-three (53) emissions made during the fiscal year. We noted the following deficiencies: i. An emission of benefits for $16,236,447.24 related to PEAF funding was made. We request evidence of an established manual or guide that defines or identifies the need that would be addressed with the issuance of these funds, and the subsequent monitoring of the usage. ii. An emission of benefits for $3,633,800 was made related to a bonus. The documentation for this issuance includes an authorization letter establishing a benefit of $800 per child between the ages of 5 and 17 years and 11 months, serving a population of 4,492 participants, for a total of $3,593,600. Later, another authorization letter added $37,000 but did not specify the number of children included in this amendment. The sum of both authorizations is $3,630,600; however, the amount reflected in PRIFAS is $3,633,800. According to the EBT document related to this issuance, the amount issued was $3,596,800 and indicates that the number of participants benefited was 4,974, giving an average benefit of $723.12. In this EBT document, beneficiaries are distributed by region; however, there are 5 beneficiaries who are not assigned to a region, for a total of $4,000. iii. An emission of $1,988,000 was made related to an incentive for some beneficiaries. In accordance with an authorization letter, the benefit included $3,500 per participants who worked or participated in an activity leading to employment for 3 months or more. In accordance with the State Plan, active recipients may receive a 6-months period Work Incentive Bonus payment. Per the authorization letter the benefit of $3,500 was issued to 522 participants, for a total of $1,827,000; another authorization letter increased $3,500 in funds. This amount does not agree with the PRIFAS amount of $1,988,000. ADSEF is allowed to claim 16.80% of indirect costs. As part of our audit procedures over the Nutrition Assistance for Puerto Rico and TANF program, we selected some transactions to evaluate the compliance with the indirect costs claims. The TANF program reported four (4) transactions related to indirect costs, and for the Nutrition Assistance for Puerto Rico five (5) transactions were reported. We requested evidence of two (2) transactions for the TANF program and one (1) for the Nutrition Assistance for Puerto Rico, no evidence of class object was provided in order to ascertain that only allowable expenditure transactions were considered in the calculation and claim of indirect costs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. There are no processes to reconcile PRIFAS information with emissions reported in EBT, nor to claim indirect costs. STATEMENT OF CAUSE ADSEF does not have a process for validating EBT issuances with PRIFAS, and this reconciliation is not performed periodically to detect any errors or missing information when accounting for transactions. POSSIBLE ASSERTED EFFECT The PRIFAS accounting system is not reconciled with EBT reports. This process is not stipulated as part of the internal controls required to ensure that the records used to prepare the financial statement, SEFA, and Federal reports are reconciled, and any discrepancies are identified. In addition, indirect costs calculation may include unallowable costs and not be detected timely. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish internal control processes to reconcile PRIFAS and the various sources of information used for reporting. Additionally, maintain clear records of indirect costs claimed and awarded.
FINDING REFERENCE NUMBER 2023-034 (See Finding Reference Number 2023-006) FEDERAL PROGRAMS (ALN – 93.556) MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.556) COVID-19 – 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; 2101PRFPSC; 2101PRFPCV; 2202PRFPCV; 2203PRFPSS (Federal Award Years: 2021 through 2023) 2111PRSOSR; 2211PRSOSR (Federal Award Years: 2021 through 2023) ADMINISTRATION ADMINISTRATION FOR FAMILIES AND CHILDREN (ADFAN, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES // CASH MANAGEMENT TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 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): … (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 As part of our audit procedures, we verified the requirements for the written procedures policies, and we didn’t obtain by ADFAN the required documentation. This represents a scope limitation. QUESTIONED COSTS None. PERSPECTIVE INFORMATION This deficiency is a systemic problem that is related to lack of proper training, segregation of duties and written policies and procedures. STATEMENT OF CAUSE ADFAN has not established a work plan to maintain the written procedures policies required by the Uniform Guidance. POSSIBLE ASSERTED EFFECT The absence of written procedures may lead to inconsistent program implementation, unclear assignment of responsibilities, and inadequate oversight. This increases the risk of noncompliance with applicable regulations, inefficiencies in operations, and reduced effectiveness in achieving program objectives. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that ADFAN develop, formalize, and implement comprehensive written procedures for the programs to comply with the Uniform Guidance. These procedures should clearly define roles and responsibilities, establish operational workflows, and include mechanisms for monitoring and compliance. Doing so will help ensure consistency in program execution, accountability, and alignment with regulatory and performance requirements.
FINDING REFERENCE NUMBER 2023-034 (See Finding Reference Number 2023-006) FEDERAL PROGRAMS (ALN – 93.556) MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.556) COVID-19 – 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; 2101PRFPSC; 2101PRFPCV; 2202PRFPCV; 2203PRFPSS (Federal Award Years: 2021 through 2023) 2111PRSOSR; 2211PRSOSR (Federal Award Years: 2021 through 2023) ADMINISTRATION ADMINISTRATION FOR FAMILIES AND CHILDREN (ADFAN, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES // CASH MANAGEMENT TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 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): … (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 As part of our audit procedures, we verified the requirements for the written procedures policies, and we didn’t obtain by ADFAN the required documentation. This represents a scope limitation. QUESTIONED COSTS None. PERSPECTIVE INFORMATION This deficiency is a systemic problem that is related to lack of proper training, segregation of duties and written policies and procedures. STATEMENT OF CAUSE ADFAN has not established a work plan to maintain the written procedures policies required by the Uniform Guidance. POSSIBLE ASSERTED EFFECT The absence of written procedures may lead to inconsistent program implementation, unclear assignment of responsibilities, and inadequate oversight. This increases the risk of noncompliance with applicable regulations, inefficiencies in operations, and reduced effectiveness in achieving program objectives. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that ADFAN develop, formalize, and implement comprehensive written procedures for the programs to comply with the Uniform Guidance. These procedures should clearly define roles and responsibilities, establish operational workflows, and include mechanisms for monitoring and compliance. Doing so will help ensure consistency in program execution, accountability, and alignment with regulatory and performance requirements.
FINDING REFERENCE NUMBER 2023-034 (See Finding Reference Number 2023-006) FEDERAL PROGRAMS (ALN – 93.556) MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.556) COVID-19 – 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; 2101PRFPSC; 2101PRFPCV; 2202PRFPCV; 2203PRFPSS (Federal Award Years: 2021 through 2023) 2111PRSOSR; 2211PRSOSR (Federal Award Years: 2021 through 2023) ADMINISTRATION ADMINISTRATION FOR FAMILIES AND CHILDREN (ADFAN, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES // CASH MANAGEMENT TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 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): … (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 As part of our audit procedures, we verified the requirements for the written procedures policies, and we didn’t obtain by ADFAN the required documentation. This represents a scope limitation. QUESTIONED COSTS None. PERSPECTIVE INFORMATION This deficiency is a systemic problem that is related to lack of proper training, segregation of duties and written policies and procedures. STATEMENT OF CAUSE ADFAN has not established a work plan to maintain the written procedures policies required by the Uniform Guidance. POSSIBLE ASSERTED EFFECT The absence of written procedures may lead to inconsistent program implementation, unclear assignment of responsibilities, and inadequate oversight. This increases the risk of noncompliance with applicable regulations, inefficiencies in operations, and reduced effectiveness in achieving program objectives. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that ADFAN develop, formalize, and implement comprehensive written procedures for the programs to comply with the Uniform Guidance. These procedures should clearly define roles and responsibilities, establish operational workflows, and include mechanisms for monitoring and compliance. Doing so will help ensure consistency in program execution, accountability, and alignment with regulatory and performance requirements.
FINDING REFERENCE NUMBER 2023-040 (See Finding Reference Number 2023-012) FEDERAL PROGRAMS (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE (ALN – 93.568) COVID-19 – LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRLIEA; 2201PRLIEA; 2301PRLIEA; 2001PRLIEA; 2001PRE5C3 (Federal Award Years: 2020 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ELIGIBILITY // REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200.334, Record retention requirements, establishes that: the recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. For awards that are renewed quarterly or annually, the recipient and subrecipient must retain records for three years from the date of submission of their quarterly or annual financial report, respectively. Records to be retained include but are not limited to financial records, supporting documentation, and statistical records. Further, in §200.337, Access to records, requires in (a) Records of recipients and subrecipients. The Federal agency or pass-through entity, Inspectors General, the Comptroller General of the United States, or any of their authorized representatives must have the right of access to any records of the recipient or subrecipient pertinent to the Federal award to perform audits, execute site visits, or for any other official use. This right also includes timely and reasonable access to the recipient's or subrecipient's personnel for the purpose of interviewing and discussion related to such documents or the Federal award in general. STATEMENT OF CONDITION As part of our audit procedures for eligibility requirements, we selected forty (40) participants from a population of 27,038 who were eligible for the crisis subsidy program. Of the sample of participants, only eight (8) files were submitted to us for evaluation. This represents a scope limitation. In relation to the requirement of Performance Reporting and Special reporting, we requested the applicable reports submitted during the fiscal year 2022-2023, the reports submitted for our review were applicable for the fiscal year 2023-2024. This represents a scope limitation. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This is a systemic deficiency. ADSEF was unable to demonstrate compliance with these compliance requirements. STATEMENT OF CAUSE ADSEF does not have an adequate process to identify participants' files within a reasonable timeframe for auditing. In addition, ADSEF does not have adequate controls and safeguards over the reports submitted to the Federal government. POSSIBLE ASSERTED EFFECT We were unable to obtain evidence of compliance with the eligibility and reporting requirements because the information in the files and applicable reports was not available for review. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish an appropriate mechanism to identify participants' files within a reasonable time. In addition, improve its system for filing reports submitted to the Federal government.
FINDING REFERENCE NUMBER 2023-040 (See Finding Reference Number 2023-012) FEDERAL PROGRAMS (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE (ALN – 93.568) COVID-19 – LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRLIEA; 2201PRLIEA; 2301PRLIEA; 2001PRLIEA; 2001PRE5C3 (Federal Award Years: 2020 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ELIGIBILITY // REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200.334, Record retention requirements, establishes that: the recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. For awards that are renewed quarterly or annually, the recipient and subrecipient must retain records for three years from the date of submission of their quarterly or annual financial report, respectively. Records to be retained include but are not limited to financial records, supporting documentation, and statistical records. Further, in §200.337, Access to records, requires in (a) Records of recipients and subrecipients. The Federal agency or pass-through entity, Inspectors General, the Comptroller General of the United States, or any of their authorized representatives must have the right of access to any records of the recipient or subrecipient pertinent to the Federal award to perform audits, execute site visits, or for any other official use. This right also includes timely and reasonable access to the recipient's or subrecipient's personnel for the purpose of interviewing and discussion related to such documents or the Federal award in general. STATEMENT OF CONDITION As part of our audit procedures for eligibility requirements, we selected forty (40) participants from a population of 27,038 who were eligible for the crisis subsidy program. Of the sample of participants, only eight (8) files were submitted to us for evaluation. This represents a scope limitation. In relation to the requirement of Performance Reporting and Special reporting, we requested the applicable reports submitted during the fiscal year 2022-2023, the reports submitted for our review were applicable for the fiscal year 2023-2024. This represents a scope limitation. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This is a systemic deficiency. ADSEF was unable to demonstrate compliance with these compliance requirements. STATEMENT OF CAUSE ADSEF does not have an adequate process to identify participants' files within a reasonable timeframe for auditing. In addition, ADSEF does not have adequate controls and safeguards over the reports submitted to the Federal government. POSSIBLE ASSERTED EFFECT We were unable to obtain evidence of compliance with the eligibility and reporting requirements because the information in the files and applicable reports was not available for review. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish an appropriate mechanism to identify participants' files within a reasonable time. In addition, improve its system for filing reports submitted to the Federal government.
FINDING REFERENCE NUMBER 2023-049 (See Finding Reference Number 2023-020) FEDERAL PROGRAM (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE AWARD NUMBERS 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 211PR476V1003/4 – ARPA (Federal Award Years: March 11, 2021 through September 30, 2025) 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. In section (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): … (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 §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 two reports that closed during our fiscal year audit. With respect with the Grant Award 221PR426S7003 and 221PR426S7004 we noted the following deficiency: • The auditee was unable to provide supporting documentation for the administrative expenditures that reconcile the figures reported with the PRIFAS accounting system. • In addition, for all the Federal awards mentioned above, based on internal control interviews, we found that there is no designated individual responsible for independently reviewing the reports prior to submission to ensure accuracy and consistency with source data. 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, and the reconciliation of financial information reported to Federal agencies against the accounting records used to prepare financial statement 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 required 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. 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 establish written internal controls and specific procedures to ensure that all reported amounts are fully supported and reconciled with the PRIFAS accounting system and to assign responsibility to a designated official to review and approve all reports prior to submission to the Federal agency. Implement internal controls to maintain adequate documentation supporting all financial data reported.
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-052 FEDERAL PROGRAM (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING – PERFORMANCE TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA In accordance with 45 CFR, Subtitle B, Chapter II, Part 265.7, states that: (a) Each State's quarterly reports [the TANF Data Report, the TANF Financial Report (or Territorial Financial Report), the SSP-MOE Data Report, and the Work Outcomes of TANF Exciters Report] must be complete and accurate and filed by the due date. (b) For a disaggregated data report, “a complete and accurate report” means that: (1) The reported data accurately reflects information available to the State in case records, financial records, and automated data systems, and includes correction of the quarterly data by the end of the fiscal year reporting period; (2) The data are free from computational errors and are internally consistent (e.g., items that should add to totals do so); (3) The State reports data for all required elements (i.e., no data is missing); (4) (i) The State provides data on all families; or (ii) If the State opts to use sampling, the State reports data on all families selected in a sample that meets the specification and procedures in the TANF Sampling Manual (except for families listed in error); and (5) Where estimates are necessary (e.g., some types of assistance may require cost estimates), the State uses reasonable methods to develop these estimates. (c) For an aggregated data report, “a complete and accurate report” means that: (1) The reported data accurately reflects information available to the State in case records, financial records, and automated data systems; (2) The data are free from computational errors and are internally consistent (e.g., items that should add to totals do so); (3) The State reports data on all applicable elements; and (4) Monthly totals are unduplicated counts for all families (e.g., the number of families and the number of out-of-wedlock births are unduplicated counts). In addition, 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 section (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): (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 procedures for understanding internal controls for the preparation of ACF-199 reports, we request a procedures manual on how these reports are processed and the personnel responsible for each process. ADSEF did not provide us with a manual describing the data collection process, how the information provided by the regions is validated, and the individuals responsible for submitting the reports. To evaluate compliance with the reported data, the quarter ending June 2023 was selected. From this period, forty (40) participants were selected. ADSEF was required to provide us with the corresponding participant worksheet appendix and the physical file to corroborate the information included in the report. ADSEF provided us with evidence of the hand-completed forms; however, we were not provided with the physical files to validate the information included in each document. This represents a scope limitation. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This is a systemic deficiency. After sample selection, ADSEF did not demonstrate a control structure that would allow the files to be located within a reasonable period of time. STATEMENT OF CAUSE ADSEF does not maintain an internal control structure for participant files that allows each file to be located within a reasonable period of time. Additionally, they do not have internal control procedure manuals that allow for the validation of the process they carry out and the individuals responsible for compiling, validating, and submitting this report. POSSIBLE ASSERTED EFFECT ADSEF may be including data in this report that has not been corroborated with the participants' physical records. The lack of a uniform process for archiving participant records prevented them from providing us with evidence of the requested records. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish internal control procedures manuals that clearly outline the processes to be followed for data collection, recording, and reporting. Additionally, standardize the way documents related to participant files are filed.
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.
FINDING REFERENCE NUMBER 2023-060 FEDERAL PROGRAMS (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT SPECIAL TESTS & PROVISIONS – PENALTY FOR REFUSAL TO WORK / LACK OF CHILD CARE FOR SINGLE CUSTODIAL PARENT OF CHILD UNDER AGE SIX / PENALTY FOR FAILURE TO COMPLY WITH WORK VERIFICATION PLAN TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR 200.334, Record retention requirements, establishes that: the recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. For awards that are renewed quarterly or annually, the recipient and subrecipient must retain records for three years from the date of submission of their quarterly or annual financial report, respectively. Records to be retained include but are not limited to financial records, supporting documentation, and statistical records. Further, in §200.337, Access to records, requires in (a) Records of recipients and subrecipients. The Federal agency or pass-through entity, Inspectors General, the Comptroller General of the United States, or any of their authorized representatives must have the right of access to any records of the recipient or subrecipient pertinent to the Federal award to perform audits, execute site visits, or for any other official use. This right also includes timely and reasonable access to the recipient's or subrecipient's personnel for the purpose of interviewing and discussion related to such documents or the Federal award in general. STATEMENT OF CONDITION As part of our audit procedures for special tests and provisions, we selected twenty-five (25) participants from a population of 475 who had been penalized for failing to meet the work requirement or complying with the work verification plan. Of the sample of participants, only ten (10) files were submitted to us for evaluation. Related to the Lack of Child Care requirement for single Custodial Parent of Child Under Age Six, from a population of seven (7) participants identified with this requirement, we requested three (3) files for evaluation, however, we were only given one (1) file. This is a scope limitation. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This is a systemic deficiency. ADSEF was unable to demonstrate compliance with this compliance requirement. STATEMENT OF CAUSE ADSEF does not have an adequate process to identify participants' files within a reasonable timeframe for auditing. POSSIBLE ASSERTED EFFECT We were unable to obtain evidence of compliance with these Special Tests and Provisions because the information in the files was not available for review. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish an appropriate mechanism to identify participants' files within a reasonable time.
FINDING 2023-001 DOCUMENT RETENTION SIGNIFICANT DEFICIENCY Federal Program: Title I, Part A Assistance Listing Number: 84.010 Condition The Indiana Department of Education uses data on the poverty levels of students in determining funding amounts for the program. We selected a sample of forty students from the Real Time Data report used in making funding assessments for the year under audit. The School was unable to provide documentation to support the poverty levels of ten of those students. Criteria Per 7 CFR 200.334, “Financial records, supporting documents, statistical records, and all other non- Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.” Cause The School did not maintain poverty level documentation for all students reported. Effect We were unable to determine if the poverty levels of all students were properly reported. Funding amounts could have been incorrectly determined. Recommendation We recommend the School develop internal controls requiring the maintenance of student poverty level documentation. Views of Responsible Officials The School’s Corrective Action Plan is included on page 24.
FINDING 2023-001 DOCUMENT RETENTION SIGNIFICANT DEFICIENCY Federal Program: Title I, Part A Assistance Listing Number: 84.010 Condition The Indiana Department of Education uses data on the poverty levels of students in determining funding amounts for the program. We selected a sample of forty students from the Real Time Data report used in making funding assessments for the year under audit. The School was unable to provide documentation to support the poverty levels of ten of those students. Criteria Per 7 CFR 200.334, “Financial records, supporting documents, statistical records, and all other non- Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.” Cause The School did not maintain poverty level documentation for all students reported. Effect We were unable to determine if the poverty levels of all students were properly reported. Funding amounts could have been incorrectly determined. Recommendation We recommend the School develop internal controls requiring the maintenance of student poverty level documentation. Views of Responsible Officials The School’s Corrective Action Plan is included on page 24.
Assistance Listing Number(s): 10.553 and 10.555 Name of Federal Program or Cluster: Child Nutrition Cluster Name of Federal Agency: Department of Agriculture Name of Pass-through Entity: Wisconsin Department of Public Instruction Pass-through Entity Identifying Number(s): 2023-138142-DPI-SB-546, 2023-138005-DPI-SB-546, 2023-138005-DPI-NSL-547, and 2023-138005-DPI-SK_NSLAE-566 Award Period: July 1, 2022 through June 30, 2023 Criteria: According to 2 CFR, Part 200.334 of the Uniform Guidance, supporting documentation pertinent to a federal award must be retained for a period of three years from the date of submission of the expenditure. According to 2 CFR, Part 200.302(3) of the Uniform Guidance, records must be supported by source documentation. Condition: Supporting documentation for claims were not retained. Cause: Internal controls for funding claims have not been designed appropriately. Currently, there are no internal controls to ensure support for claims are retained in accordance with federal requirements. Questioned Costs: $344,674 Effect or Potential Effect: Incomplete or inaccurate information could be reported on funding claims. Context: A sample of 8 claims reports were selected from a population of 39. The testing found that supporting documentation for claims was not retained for any of the claims in the sample. Repeat Finding: No Recommendation: One City Schools, Inc. should design and implement appropriate internal controls for retaining support for claims in accordance with federal requirements. Views of Responsible Officials: One City Schools, Inc. agrees with the finding and are working on implementing internal controls for maintaining supporting documentation.
Assistance Listing Number(s): 10.553 and 10.555 Name of Federal Program or Cluster: Child Nutrition Cluster Name of Federal Agency: Department of Agriculture Name of Pass-through Entity: Wisconsin Department of Public Instruction Pass-through Entity Identifying Number(s): 2023-138142-DPI-SB-546, 2023-138005-DPI-SB-546, 2023-138005-DPI-NSL-547, and 2023-138005-DPI-SK_NSLAE-566 Award Period: July 1, 2022 through June 30, 2023 Criteria: According to 2 CFR, Part 200.334 of the Uniform Guidance, supporting documentation pertinent to a federal award must be retained for a period of three years from the date of submission of the expenditure. According to 2 CFR, Part 200.302(3) of the Uniform Guidance, records must be supported by source documentation. Condition: Supporting documentation for claims were not retained. Cause: Internal controls for funding claims have not been designed appropriately. Currently, there are no internal controls to ensure support for claims are retained in accordance with federal requirements. Questioned Costs: $344,674 Effect or Potential Effect: Incomplete or inaccurate information could be reported on funding claims. Context: A sample of 8 claims reports were selected from a population of 39. The testing found that supporting documentation for claims was not retained for any of the claims in the sample. Repeat Finding: No Recommendation: One City Schools, Inc. should design and implement appropriate internal controls for retaining support for claims in accordance with federal requirements. Views of Responsible Officials: One City Schools, Inc. agrees with the finding and are working on implementing internal controls for maintaining supporting documentation.
Assistance Listing Number(s): 10.553 and 10.555 Name of Federal Program or Cluster: Child Nutrition Cluster Name of Federal Agency: Department of Agriculture Name of Pass-through Entity: Wisconsin Department of Public Instruction Pass-through Entity Identifying Number(s): 2023-138142-DPI-SB-546, 2023-138005-DPI-SB-546, 2023-138005-DPI-NSL-547, and 2023-138005-DPI-SK_NSLAE-566 Award Period: July 1, 2022 through June 30, 2023 Criteria: According to 2 CFR, Part 200.334 of the Uniform Guidance, supporting documentation pertinent to a federal award must be retained for a period of three years from the date of submission of the expenditure. According to 2 CFR, Part 200.302(3) of the Uniform Guidance, records must be supported by source documentation. Condition: Supporting documentation for claims were not retained. Cause: Internal controls for funding claims have not been designed appropriately. Currently, there are no internal controls to ensure support for claims are retained in accordance with federal requirements. Questioned Costs: $344,674 Effect or Potential Effect: Incomplete or inaccurate information could be reported on funding claims. Context: A sample of 8 claims reports were selected from a population of 39. The testing found that supporting documentation for claims was not retained for any of the claims in the sample. Repeat Finding: No Recommendation: One City Schools, Inc. should design and implement appropriate internal controls for retaining support for claims in accordance with federal requirements. Views of Responsible Officials: One City Schools, Inc. agrees with the finding and are working on implementing internal controls for maintaining supporting documentation.
Assistance Listing Number(s): 10.553 and 10.555 Name of Federal Program or Cluster: Child Nutrition Cluster Name of Federal Agency: Department of Agriculture Name of Pass-through Entity: Wisconsin Department of Public Instruction Pass-through Entity Identifying Number(s): 2023-138142-DPI-SB-546, 2023-138005-DPI-SB-546, 2023-138005-DPI-NSL-547, and 2023-138005-DPI-SK_NSLAE-566 Award Period: July 1, 2022 through June 30, 2023 Criteria: According to 2 CFR, Part 200.334 of the Uniform Guidance, supporting documentation pertinent to a federal award must be retained for a period of three years from the date of submission of the expenditure. According to 2 CFR, Part 200.302(3) of the Uniform Guidance, records must be supported by source documentation. Condition: Supporting documentation for claims were not retained. Cause: Internal controls for funding claims have not been designed appropriately. Currently, there are no internal controls to ensure support for claims are retained in accordance with federal requirements. Questioned Costs: $344,674 Effect or Potential Effect: Incomplete or inaccurate information could be reported on funding claims. Context: A sample of 8 claims reports were selected from a population of 39. The testing found that supporting documentation for claims was not retained for any of the claims in the sample. Repeat Finding: No Recommendation: One City Schools, Inc. should design and implement appropriate internal controls for retaining support for claims in accordance with federal requirements. Views of Responsible Officials: One City Schools, Inc. agrees with the finding and are working on implementing internal controls for maintaining supporting documentation.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 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 annual data reports 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 complied, prepared, and submitted by the Assistant Superintendent of Schools without an oversight or review process in place to prevent, or detect and correct, errors. Furthermore, the reported data on two of the reports, as noted below, could not be traced back to records that accumulate or summarize the data; therefore, the accuracy and completeness of the reports could not be verified. ESSER I, Year 3 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was not able to be verified to the School Corporation's records. Additionally, the key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Benefits," was understated by $16. ESSER II, Year 2 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was understated by $288,199. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 17 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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, some data could not be traced back to the underlying records. INDIANA STATE BOARD OF ACCOUNTS 18 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds are accurate and complete. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 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 annual data reports 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 complied, prepared, and submitted by the Assistant Superintendent of Schools without an oversight or review process in place to prevent, or detect and correct, errors. Furthermore, the reported data on two of the reports, as noted below, could not be traced back to records that accumulate or summarize the data; therefore, the accuracy and completeness of the reports could not be verified. ESSER I, Year 3 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was not able to be verified to the School Corporation's records. Additionally, the key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Benefits," was understated by $16. ESSER II, Year 2 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was understated by $288,199. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 17 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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, some data could not be traced back to the underlying records. INDIANA STATE BOARD OF ACCOUNTS 18 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds are accurate and complete. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 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 annual data reports 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 complied, prepared, and submitted by the Assistant Superintendent of Schools without an oversight or review process in place to prevent, or detect and correct, errors. Furthermore, the reported data on two of the reports, as noted below, could not be traced back to records that accumulate or summarize the data; therefore, the accuracy and completeness of the reports could not be verified. ESSER I, Year 3 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was not able to be verified to the School Corporation's records. Additionally, the key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Benefits," was understated by $16. ESSER II, Year 2 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was understated by $288,199. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 17 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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, some data could not be traced back to the underlying records. INDIANA STATE BOARD OF ACCOUNTS 18 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds are accurate and complete. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 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 annual data reports 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 complied, prepared, and submitted by the Assistant Superintendent of Schools without an oversight or review process in place to prevent, or detect and correct, errors. Furthermore, the reported data on two of the reports, as noted below, could not be traced back to records that accumulate or summarize the data; therefore, the accuracy and completeness of the reports could not be verified. ESSER I, Year 3 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was not able to be verified to the School Corporation's records. Additionally, the key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Benefits," was understated by $16. ESSER II, Year 2 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was understated by $288,199. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 17 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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, some data could not be traced back to the underlying records. INDIANA STATE BOARD OF ACCOUNTS 18 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds are accurate and complete. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-001 Subject: COVID-19 - Education Stabilization Fund - Allowable Costs/Cost Principles 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: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 15 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The COVID-19 - Education Stabilization Fund established by the Coronavirus Aid, Relief, and Economic Security Act, and further funded by the Coronavirus Response and Relief Supplemental Appropriations Act and the American Rescue Plan Act, was for the purpose of preventing, preparing for, or responding to the novel coronavirus. A sample of 25 claims charged to the program was selected for testing to verify the expenditures were in conformance with the applicable cost principles. Of the 25 claims tested, 6 claims totaling $1,650, each of which paid an individual for work as a contracted security guard, were identified as not being in conformance with the applicable cost principles. Payment to the security guards was made based on an accounts payable voucher signed by the contractor; however, there was not an invoice, time sheet, or other supporting documentation that accompanied the accounts payable voucher. The ineffective internal controls and noncompliance were systemic issues throughout the audit period. 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." INDIANA STATE BOARD OF ACCOUNTS 16 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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, documentation could not be provided to support amounts charged to the grant. 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure time charged to the grant is properly supported, recorded, and approved.
FINDING 2023-001 Subject: COVID-19 - Education Stabilization Fund - Allowable Costs/Cost Principles 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: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 15 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The COVID-19 - Education Stabilization Fund established by the Coronavirus Aid, Relief, and Economic Security Act, and further funded by the Coronavirus Response and Relief Supplemental Appropriations Act and the American Rescue Plan Act, was for the purpose of preventing, preparing for, or responding to the novel coronavirus. A sample of 25 claims charged to the program was selected for testing to verify the expenditures were in conformance with the applicable cost principles. Of the 25 claims tested, 6 claims totaling $1,650, each of which paid an individual for work as a contracted security guard, were identified as not being in conformance with the applicable cost principles. Payment to the security guards was made based on an accounts payable voucher signed by the contractor; however, there was not an invoice, time sheet, or other supporting documentation that accompanied the accounts payable voucher. The ineffective internal controls and noncompliance were systemic issues throughout the audit period. 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." INDIANA STATE BOARD OF ACCOUNTS 16 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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, documentation could not be provided to support amounts charged to the grant. 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure time charged to the grant is properly supported, recorded, and approved.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Maters 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; however, a single employee prepared and submitted the reports without evidence of a review, or oversight process in place to prevent, or detect and correct, errors. INDIANA STATE BOARD OF ACCOUNTS 17 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, for the ESSER I, Year 2 report, the "Total Mandatory Subgrant Amount Expended in Current Reporting Period" was not supported by the School Corporation's records. Actual expenditures from a report provided by the School Corporation did not tie to the amount submitted for the Annual Performance Reporting. The key line item was determined to be overstated by $80,342. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 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." INDIANA STATE BOARD OF ACCOUNTS 18 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 amounts reported were 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the COVID-19 - Education Stabilization Fund program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Maters 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; however, a single employee prepared and submitted the reports without evidence of a review, or oversight process in place to prevent, or detect and correct, errors. INDIANA STATE BOARD OF ACCOUNTS 17 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, for the ESSER I, Year 2 report, the "Total Mandatory Subgrant Amount Expended in Current Reporting Period" was not supported by the School Corporation's records. Actual expenditures from a report provided by the School Corporation did not tie to the amount submitted for the Annual Performance Reporting. The key line item was determined to be overstated by $80,342. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 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." INDIANA STATE BOARD OF ACCOUNTS 18 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 amounts reported were 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the COVID-19 - Education Stabilization Fund program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Maters 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; however, a single employee prepared and submitted the reports without evidence of a review, or oversight process in place to prevent, or detect and correct, errors. INDIANA STATE BOARD OF ACCOUNTS 17 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, for the ESSER I, Year 2 report, the "Total Mandatory Subgrant Amount Expended in Current Reporting Period" was not supported by the School Corporation's records. Actual expenditures from a report provided by the School Corporation did not tie to the amount submitted for the Annual Performance Reporting. The key line item was determined to be overstated by $80,342. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 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." INDIANA STATE BOARD OF ACCOUNTS 18 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 amounts reported were 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the COVID-19 - Education Stabilization Fund program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Maters 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; however, a single employee prepared and submitted the reports without evidence of a review, or oversight process in place to prevent, or detect and correct, errors. INDIANA STATE BOARD OF ACCOUNTS 17 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, for the ESSER I, Year 2 report, the "Total Mandatory Subgrant Amount Expended in Current Reporting Period" was not supported by the School Corporation's records. Actual expenditures from a report provided by the School Corporation did not tie to the amount submitted for the Annual Performance Reporting. The key line item was determined to be overstated by $80,342. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 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." INDIANA STATE BOARD OF ACCOUNTS 18 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 amounts reported were 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the COVID-19 - Education Stabilization Fund program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Maters 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; however, a single employee prepared and submitted the reports without evidence of a review, or oversight process in place to prevent, or detect and correct, errors. INDIANA STATE BOARD OF ACCOUNTS 17 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, for the ESSER I, Year 2 report, the "Total Mandatory Subgrant Amount Expended in Current Reporting Period" was not supported by the School Corporation's records. Actual expenditures from a report provided by the School Corporation did not tie to the amount submitted for the Annual Performance Reporting. The key line item was determined to be overstated by $80,342. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 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." INDIANA STATE BOARD OF ACCOUNTS 18 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 amounts reported were 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the COVID-19 - Education Stabilization Fund program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) 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 compiled, prepared, and submitted by the Assistant Superintendent of Schools and reviewed by the Treasurer prior to submission. However, this review process was not effective and did not detect and allow correction of errors prior to submission. All six of the submitted reports were selected for testing. Four of the reports, ESSER I, Year 2; ESSER II, Year 1; ESSER II, Year 2; and ESSER III, Year 2, were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted in the reports; therefore, we could not determine the accuracy of the reports. 22 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the four reports identified above. 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." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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. 23 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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, reports submitted to the IDOE were not supported by the School Corporation's underlying accounting 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the ledgers or reports used to complete the report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) 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 compiled, prepared, and submitted by the Assistant Superintendent of Schools and reviewed by the Treasurer prior to submission. However, this review process was not effective and did not detect and allow correction of errors prior to submission. All six of the submitted reports were selected for testing. Four of the reports, ESSER I, Year 2; ESSER II, Year 1; ESSER II, Year 2; and ESSER III, Year 2, were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted in the reports; therefore, we could not determine the accuracy of the reports. 22 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the four reports identified above. 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." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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. 23 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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, reports submitted to the IDOE were not supported by the School Corporation's underlying accounting 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the ledgers or reports used to complete the report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) 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 compiled, prepared, and submitted by the Assistant Superintendent of Schools and reviewed by the Treasurer prior to submission. However, this review process was not effective and did not detect and allow correction of errors prior to submission. All six of the submitted reports were selected for testing. Four of the reports, ESSER I, Year 2; ESSER II, Year 1; ESSER II, Year 2; and ESSER III, Year 2, were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted in the reports; therefore, we could not determine the accuracy of the reports. 22 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the four reports identified above. 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." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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. 23 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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, reports submitted to the IDOE were not supported by the School Corporation's underlying accounting 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the ledgers or reports used to complete the report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) 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 compiled, prepared, and submitted by the Assistant Superintendent of Schools and reviewed by the Treasurer prior to submission. However, this review process was not effective and did not detect and allow correction of errors prior to submission. All six of the submitted reports were selected for testing. Four of the reports, ESSER I, Year 2; ESSER II, Year 1; ESSER II, Year 2; and ESSER III, Year 2, were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted in the reports; therefore, we could not determine the accuracy of the reports. 22 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the four reports identified above. 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." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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. 23 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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, reports submitted to the IDOE were not supported by the School Corporation's underlying accounting 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the ledgers or reports used to complete the report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) 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 compiled, prepared, and submitted by the Assistant Superintendent of Schools and reviewed by the Treasurer prior to submission. However, this review process was not effective and did not detect and allow correction of errors prior to submission. All six of the submitted reports were selected for testing. Four of the reports, ESSER I, Year 2; ESSER II, Year 1; ESSER II, Year 2; and ESSER III, Year 2, were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted in the reports; therefore, we could not determine the accuracy of the reports. 22 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the four reports identified above. 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." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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. 23 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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, reports submitted to the IDOE were not supported by the School Corporation's underlying accounting 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the ledgers or reports used to complete the report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) 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 compiled, prepared, and submitted by the Assistant Superintendent of Schools and reviewed by the Treasurer prior to submission. However, this review process was not effective and did not detect and allow correction of errors prior to submission. All six of the submitted reports were selected for testing. Four of the reports, ESSER I, Year 2; ESSER II, Year 1; ESSER II, Year 2; and ESSER III, Year 2, were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted in the reports; therefore, we could not determine the accuracy of the reports. 22 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the four reports identified above. 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." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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. 23 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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, reports submitted to the IDOE were not supported by the School Corporation's underlying accounting 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. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the ledgers or reports used to complete the report. 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 - Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Other Matters Condition and Context Construction contracts in excess of $2,000 financed by federal assistance funds must pay wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL) to its laborers and mechanics. Nonfederal entities are to include in its construction contracts subject to the Wage Rate Requirements a provision that the contractor or subcontractor comply with these requirements and the DOL regulations. This would include a requirement to submit a copy of the payroll and statement of compliance to the entity for each week in which contract work was performed. The School Corporation had not designed, nor implemented a system of internal controls to ensure that construction contracts in excess of $2,000 paid from federal grant funds included a prevailing wage rate clause and that a copy of the payroll was submitted for each week in which contract work was performed. Two construction projects were paid for from the Elementary and Secondary School Emergency Relief Fund grant funds during the audit period. Both contracts were tested. Both contracts contained the required prevailing wage rate clause; however, a copy of the payroll was not submitted for either contract for any week in which work was performed. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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). . . ." 29 CFR 5.5 states in part: "(a) The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in § 5.1, the following clauses. . . (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics. . . . (3) Payrolls and basic records. . . . (ii) (A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). The payrolls submitted shall set out accurately and completely all of the information required to be maintained under 29 CFR 5.5(a)(3)(i), except that full social security numbers and home addresses shall not be included on weekly transmittals. Instead the payrolls shall only need to include an individually identifying number for each employee (e.g., the last four digits of the employee's social security number). The required weekly payroll information may be submitted in any form desired. Optional Form WH-347 is available for this purpose from the Wage and Hour Division Web site at http://www.dol.gov/esa/whd/forms/wh347instr.htm or its successor site. The prime contractor is responsible for the submission of copies of payrolls by all subcontractors. . . ." 2 CFR 200 Appendix II states in part: "In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non- Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, 'Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction'). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week. . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. 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 control, 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, certified payrolls were not obtained by the School Corporation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls and ensure certified payrolls are obtained as required for all contracts. 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 - Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Other Matters Condition and Context Construction contracts in excess of $2,000 financed by federal assistance funds must pay wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL) to its laborers and mechanics. Nonfederal entities are to include in its construction contracts subject to the Wage Rate Requirements a provision that the contractor or subcontractor comply with these requirements and the DOL regulations. This would include a requirement to submit a copy of the payroll and statement of compliance to the entity for each week in which contract work was performed. The School Corporation had not designed, nor implemented a system of internal controls to ensure that construction contracts in excess of $2,000 paid from federal grant funds included a prevailing wage rate clause and that a copy of the payroll was submitted for each week in which contract work was performed. Two construction projects were paid for from the Elementary and Secondary School Emergency Relief Fund grant funds during the audit period. Both contracts were tested. Both contracts contained the required prevailing wage rate clause; however, a copy of the payroll was not submitted for either contract for any week in which work was performed. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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). . . ." 29 CFR 5.5 states in part: "(a) The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in § 5.1, the following clauses. . . (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics. . . . (3) Payrolls and basic records. . . . (ii) (A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). The payrolls submitted shall set out accurately and completely all of the information required to be maintained under 29 CFR 5.5(a)(3)(i), except that full social security numbers and home addresses shall not be included on weekly transmittals. Instead the payrolls shall only need to include an individually identifying number for each employee (e.g., the last four digits of the employee's social security number). The required weekly payroll information may be submitted in any form desired. Optional Form WH-347 is available for this purpose from the Wage and Hour Division Web site at http://www.dol.gov/esa/whd/forms/wh347instr.htm or its successor site. The prime contractor is responsible for the submission of copies of payrolls by all subcontractors. . . ." 2 CFR 200 Appendix II states in part: "In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non- Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, 'Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction'). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week. . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. 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 control, 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, certified payrolls were not obtained by the School Corporation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls and ensure certified payrolls are obtained as required for all contracts. 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 - Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Other Matters Condition and Context Construction contracts in excess of $2,000 financed by federal assistance funds must pay wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL) to its laborers and mechanics. Nonfederal entities are to include in its construction contracts subject to the Wage Rate Requirements a provision that the contractor or subcontractor comply with these requirements and the DOL regulations. This would include a requirement to submit a copy of the payroll and statement of compliance to the entity for each week in which contract work was performed. The School Corporation had not designed, nor implemented a system of internal controls to ensure that construction contracts in excess of $2,000 paid from federal grant funds included a prevailing wage rate clause and that a copy of the payroll was submitted for each week in which contract work was performed. Two construction projects were paid for from the Elementary and Secondary School Emergency Relief Fund grant funds during the audit period. Both contracts were tested. Both contracts contained the required prevailing wage rate clause; however, a copy of the payroll was not submitted for either contract for any week in which work was performed. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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). . . ." 29 CFR 5.5 states in part: "(a) The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in § 5.1, the following clauses. . . (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics. . . . (3) Payrolls and basic records. . . . (ii) (A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). The payrolls submitted shall set out accurately and completely all of the information required to be maintained under 29 CFR 5.5(a)(3)(i), except that full social security numbers and home addresses shall not be included on weekly transmittals. Instead the payrolls shall only need to include an individually identifying number for each employee (e.g., the last four digits of the employee's social security number). The required weekly payroll information may be submitted in any form desired. Optional Form WH-347 is available for this purpose from the Wage and Hour Division Web site at http://www.dol.gov/esa/whd/forms/wh347instr.htm or its successor site. The prime contractor is responsible for the submission of copies of payrolls by all subcontractors. . . ." 2 CFR 200 Appendix II states in part: "In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non- Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, 'Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction'). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week. . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. 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 control, 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, certified payrolls were not obtained by the School Corporation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls and ensure certified payrolls are obtained as required for all contracts. 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 - Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Other Matters Condition and Context Construction contracts in excess of $2,000 financed by federal assistance funds must pay wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL) to its laborers and mechanics. Nonfederal entities are to include in its construction contracts subject to the Wage Rate Requirements a provision that the contractor or subcontractor comply with these requirements and the DOL regulations. This would include a requirement to submit a copy of the payroll and statement of compliance to the entity for each week in which contract work was performed. The School Corporation had not designed, nor implemented a system of internal controls to ensure that construction contracts in excess of $2,000 paid from federal grant funds included a prevailing wage rate clause and that a copy of the payroll was submitted for each week in which contract work was performed. Two construction projects were paid for from the Elementary and Secondary School Emergency Relief Fund grant funds during the audit period. Both contracts were tested. Both contracts contained the required prevailing wage rate clause; however, a copy of the payroll was not submitted for either contract for any week in which work was performed. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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). . . ." 29 CFR 5.5 states in part: "(a) The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in § 5.1, the following clauses. . . (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics. . . . (3) Payrolls and basic records. . . . (ii) (A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). The payrolls submitted shall set out accurately and completely all of the information required to be maintained under 29 CFR 5.5(a)(3)(i), except that full social security numbers and home addresses shall not be included on weekly transmittals. Instead the payrolls shall only need to include an individually identifying number for each employee (e.g., the last four digits of the employee's social security number). The required weekly payroll information may be submitted in any form desired. Optional Form WH-347 is available for this purpose from the Wage and Hour Division Web site at http://www.dol.gov/esa/whd/forms/wh347instr.htm or its successor site. The prime contractor is responsible for the submission of copies of payrolls by all subcontractors. . . ." 2 CFR 200 Appendix II states in part: "In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non- Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, 'Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction'). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week. . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. 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 control, 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, certified payrolls were not obtained by the School Corporation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls and ensure certified payrolls are obtained as required for all contracts. 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 - Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Other Matters Condition and Context Construction contracts in excess of $2,000 financed by federal assistance funds must pay wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL) to its laborers and mechanics. Nonfederal entities are to include in its construction contracts subject to the Wage Rate Requirements a provision that the contractor or subcontractor comply with these requirements and the DOL regulations. This would include a requirement to submit a copy of the payroll and statement of compliance to the entity for each week in which contract work was performed. The School Corporation had not designed, nor implemented a system of internal controls to ensure that construction contracts in excess of $2,000 paid from federal grant funds included a prevailing wage rate clause and that a copy of the payroll was submitted for each week in which contract work was performed. Two construction projects were paid for from the Elementary and Secondary School Emergency Relief Fund grant funds during the audit period. Both contracts were tested. Both contracts contained the required prevailing wage rate clause; however, a copy of the payroll was not submitted for either contract for any week in which work was performed. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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). . . ." 29 CFR 5.5 states in part: "(a) The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in § 5.1, the following clauses. . . (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics. . . . (3) Payrolls and basic records. . . . (ii) (A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). The payrolls submitted shall set out accurately and completely all of the information required to be maintained under 29 CFR 5.5(a)(3)(i), except that full social security numbers and home addresses shall not be included on weekly transmittals. Instead the payrolls shall only need to include an individually identifying number for each employee (e.g., the last four digits of the employee's social security number). The required weekly payroll information may be submitted in any form desired. Optional Form WH-347 is available for this purpose from the Wage and Hour Division Web site at http://www.dol.gov/esa/whd/forms/wh347instr.htm or its successor site. The prime contractor is responsible for the submission of copies of payrolls by all subcontractors. . . ." 2 CFR 200 Appendix II states in part: "In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non- Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, 'Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction'). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week. . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. 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 control, 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, certified payrolls were not obtained by the School Corporation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls and ensure certified payrolls are obtained as required for all contracts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding: 2023-001 Document Retention Awarding Agency and Pass through Entity: U.S. Department of the Treasury, passed through Lane County (Contract 512211-285-3427062) Federal Award: Emergency Rent Assistance Program (ALN 21.023) Compliance Requirement: Eligibility Finding Type: Significant Deficiency in Internal Control Over Compliance. Criteria: 2 CFR 200.334 Retention requirements for records requires that documentation pertinent to the federal award be retained for a period of three years from the end of the program. Internal controls should be appropriately designed and implemented to ensure compliance with all applicable rules and regulations. Condition: 1 of 25 participant files could not be located. Checklists completed during file review to ensure participant files are complete and accurate were not retained after the review was performed. The program had 144 participants during fiscal year 2023. No questioned costs or potentially improper payments were noted. Cause: Employees did not follow the organization's document retention policy and certain records were not identified as needing to be retained. Effect: Not retaining documents as required could lead to questioned costs and the inability to demonstrate compliance with all applicable award terms and conditions, as well as not being able to demonstrate the operating effectiveness of internal controls over compliance. Recommendation: Internal controls and processes should be implemented to ensure all pertinent documentation is retained and the organization's record retention policy is followed by all employees. Management response: Management concurs with the finding. Corrective actions will be taken to ensure documentation is retained appropriately.
FINDING 2023-006 Subject: COVID-19 - Education Stabilization Fund - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Number and Year (or Other Identifying Number): S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context The Education Stabilization Fund (ESF) established by the Coronavirus Aid, Relief, and Economic Security (CARES) Act, and further funded by the Coronavirus Response and Relief Supplemental Appropriations Act (CRSSA) and the American Rescue Plan (ARP) Act, was for the purpose of preventing, preparing for, or responding to the novel coronavirus. A sample of 26 claims charged to the ESF program for which reimbursement was received during the audit period was selected for testing to verify the expenditures were in conformance with the applicable cost principles. Of the 26 claims tested, 5 were transfers of payroll expenses, totaling $179,625, into the Esser II fund (ESF fund) for Coronavirus related payroll expenses. Errors as described below were identified when testing the transfers. INDIANA STATE BOARD OF ACCOUNTS 22 LAKELAND SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation transferred employee's pay related to sick time due to COVID-19 from the paying funds to the ESF fund. Several employees' pay was not able to be recalculated. The School Corporation provided documentation supporting the employees' pay; however, the recalculation of that pay did not equal the amount transferred into the ESF Fund. The total calculated variances were $8,300. This amount was considered questioned costs. In addition, several employees' pay did not have appropriate supporting documentation to substantiate payment of their payroll with ESF funds. This included the payment of substitute teachers without documentation of the person paid and the payment of sick days when the school was closed. Total payroll that was not substantiated was $24,769. This amount was considered questioned costs. The ineffective internal controls were a systemic issue throughout the audit period. The noncompliance was isolated to the items noted above. 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 LAKELAND SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 control, 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, documentation could not be provided to support amounts charged to the grant. 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 Known questioned costs of $33,069 were identified as detailed in Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure amounts charged to the grant are properly recorded and approved to support the amounts paid from the COVID-19 - Education Stabilization Fund program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. INDIANA STATE BOARD OF ACCOUNTS 24