CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year. CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 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 sections 200.328 and 200.329 of the Uniform Guidance. EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above. QUESTIONED COST: None RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations. VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year. CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 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 sections 200.328 and 200.329 of the Uniform Guidance. EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above. QUESTIONED COST: None RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations. VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year. CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 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 sections 200.328 and 200.329 of the Uniform Guidance. EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above. QUESTIONED COST: None RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations. VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year. CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 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 sections 200.328 and 200.329 of the Uniform Guidance. EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above. QUESTIONED COST: None RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations. VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
CONDITION: The District did not properly record its federal program expenditures for the ESSER and ARP ESER federal grant programs using the various funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. This is a repeat finding from (2022-003) from the previous fiscal year. CRITERIA: The financial management system of the District must provide for 1) identification in it’s accounts, of all Federal awards received and expended and the Federal programs under which they were received, and 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 sections 200.328 and 200.329 of the Uniform Guidance. EFFECT: The District was not in compliance with the financial reporting requirements in the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations and well as Section 2 CFR 200.302(a) of the Uniform Guidance. CAUSE: The District experienced turnover in key business office personnel during the last two fiscal years, which resulted in errors in posting federal expenditures to the appropriate general ledger account codes. This further lead to inaccurate reporting as outlined above. QUESTIONED COST: None RECOMMENDATION: I recommend that the District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in 2 CFR Part 200 of the Uniform Guidance and PDE regulations. VIEW OF RESPONSIBLE OFFICIALS: See Correction Action Plan
Lack of Internal Controls and Noncompliance with Reporting Requirements Over Federal Grant Coronavirus State and Local Fiscal Recovery Funds PASS-THROUGH GRANTOR: Direct Grant FEDERAL AGENCY: U.S. Department of Treasury ASSISTANCE LISTING: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds FEDERAL AWARD YEAR: 2021 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $-0- Condition: The County has not established internal controls to ensure the correct expenditure category is used for reporting payments to subrecipients. The quarterly reports improperly classified payments totaling $1,600,000 to subrecipients as a ‘Revenue Replacement’ expense instead of using the ‘Infrastructure’ expense category. In addition, it was noted the 2nd Quarter Report was not timely submitted. Cause of Condition: Policies and procedures have not been designed and implemented to ensure federal expenditures are made in accordance with federal compliance requirements. Effect of Condition: This condition resulted in noncompliance with grant requirements. Recommendation: OSAI recommends the County gain an understanding of the requirements for this program and implement internal controls to ensure compliance with these requirements. Management Response: Chairman of the Board of County Commissioners: The Board of County Commissioners will take measures to ensure future compliance with all requirements of federal grants. Criteria: Title 2 CFR § 200.303(a) Internal Controls reads (a) reads as follows: The non-Federal entity must: 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 Controls Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds (10. Reporting.) reads as follows: All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. In addition, where appropriate, you organization needs to establish controls to ensure completion and timely submission of all mandatory performance and/or compliance reporting. Further, 2 CFR § 200.329 Monitoring and Reporting Program Performance (c)(1) reads as follows: The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes. Reports submitted annually by the non-Federal entity and/or pass-through entity 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. Alternatively, the Federal awarding agency or pass-through entity may require annual reports before the anniversary dates of multiple year Federal awards. The final performance report submitted by the non-Federal entity and/or pass-through entity must be due no later than 120 calendar days after the period of performance end date. A subrecipient must submit to the pass-through entity, no later than 90 calendar days after the period of performance end date, all final performance reports as required by the terms and conditions of the Federal award. See also § 200.344. If a justified request is submitted by a non-Federal entity, the Federal agency may extend the due date for any performance report.
FINDING 2023-011 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): S425D210013, S425U210013 Pass-Through Entity: Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 34 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 Director of Curriculum without oversight or review process in place to prevent, or detect and correct, errors. All six of the submitted reports were selected for testing. One of the reports, ESSER II, Year 2, was not supported by the School Corporation's records. The School Corporation had expenditures of $583,415 from the ESSER II grant which were not included in this report. The lack of internal controls was systemic throughout the audit period. The noncompliance was isolated to the ESSER II, Year 2 report. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." INDIANA STATE BOARD OF ACCOUNTS 35 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by the School Corporation's management. 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, a report submitted to the IDOE was 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. INDIANA STATE BOARD OF ACCOUNTS 36
FINDING 2023-011 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): S425D210013, S425U210013 Pass-Through Entity: Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 34 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 Director of Curriculum without oversight or review process in place to prevent, or detect and correct, errors. All six of the submitted reports were selected for testing. One of the reports, ESSER II, Year 2, was not supported by the School Corporation's records. The School Corporation had expenditures of $583,415 from the ESSER II grant which were not included in this report. The lack of internal controls was systemic throughout the audit period. The noncompliance was isolated to the ESSER II, Year 2 report. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." INDIANA STATE BOARD OF ACCOUNTS 35 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by the School Corporation's management. 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, a report submitted to the IDOE was 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. INDIANA STATE BOARD OF ACCOUNTS 36
FINDING 2023-011 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): S425D210013, S425U210013 Pass-Through Entity: Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 34 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 Director of Curriculum without oversight or review process in place to prevent, or detect and correct, errors. All six of the submitted reports were selected for testing. One of the reports, ESSER II, Year 2, was not supported by the School Corporation's records. The School Corporation had expenditures of $583,415 from the ESSER II grant which were not included in this report. The lack of internal controls was systemic throughout the audit period. The noncompliance was isolated to the ESSER II, Year 2 report. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." INDIANA STATE BOARD OF ACCOUNTS 35 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by the School Corporation's management. 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, a report submitted to the IDOE was 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. INDIANA STATE BOARD OF ACCOUNTS 36
FINDING 2023-011 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): S425D210013, S425U210013 Pass-Through Entity: Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 34 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 Director of Curriculum without oversight or review process in place to prevent, or detect and correct, errors. All six of the submitted reports were selected for testing. One of the reports, ESSER II, Year 2, was not supported by the School Corporation's records. The School Corporation had expenditures of $583,415 from the ESSER II grant which were not included in this report. The lack of internal controls was systemic throughout the audit period. The noncompliance was isolated to the ESSER II, Year 2 report. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." INDIANA STATE BOARD OF ACCOUNTS 35 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by the School Corporation's management. 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, a report submitted to the IDOE was 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. INDIANA STATE BOARD OF ACCOUNTS 36
Knott County Fiscal Court Did Not Maintain Proper FEMA Documentation Federal Program: Assistance Listing #97.036 FEMA Public Assistance Program Award Number and Year: FEMA-4663DRKYP00000001 2022 Name of Federal Agency and Pass-Thru Agency: U. S. Department of Homeland Security and State Department of Military Affairs Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Period of Performance Type of Finding: Material Weakness, Noncompliance Amount of Questioned Costs: $1,212,805 COVID Related: No Knott County had severe flooding in July of 2022. This event qualified Knott County Fiscal Court to receive federal funding to recover from the disaster. Paperwork is maintained to document and track work that is necessary and to determine the portion eligible for coverage by FEMA. The fiscal court did not maintain proper FEMA documentation. Out of 36 disbursements tested, 11 did not have any accompanying information that would detail the expected scope of work or cost. The 11 disbursements that did not have appropriate documentation totaled $1,212,805 in questioned cost. The fiscal court has not sufficiently overseen the expenditure of federal funds and did not prioritize the implementation of an effective internal control system. Tracking of the FEMA projects was consistently executed on completed projects but was not available for the in-progress projects that were tested. The lack of documentation to appropriately connect the disbursements to FEMA authorized work resulted in the determination that the county was not in compliance with the applicable attributes. An inaccurate implementation of controls and the lack of management oversight and involvement can cause noncompliance with federal requirements and jeopardize the fiscal court’s future funding. The lack of appropriate documentation also prevented the ability to rely on supplementary information, such as the Schedule of Expenditures of Federal Awards. 2 CFR part 200 Uniform Administrative Requirements, Cost Principles, And Audit Requirements For Federal Awards provides guidance on Federal regulations pertaining to Federal Awards. 2 CFR 200.306, regarding cost sharing or matching, states that any shared costs or matching funds must meet all of the following criteria: verifiable from the non-Federal entity’s records; not included as contributions for any other Federal award; necessary and reasonable for accomplishment of project or program objectives; allowable under subpart E of this part; not paid by the Federal Government under another Federal award except where allowed; provided for in the approved budget when required by the Federal awarding agency; and conform to other provisions of this part, as applicable. 2 CFR 200.318(i), regarding general procurement standards, requires Non-Federal entities to maintain records sufficient to detail the history of procurement. These records will include, but are not limited to, the rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. 2 CFR 200.329, concerning monitoring and reporting program performance, states that the non-Federal entity is responsible for oversight of the operations of the Federal award supported activities. The non-Federal entity must monitor its activities under Federal awards to assure compliance with applicable Federal requirements and performance expectations are being achieved. Monitoring by the non-Federal entity must cover each program, function, or activity. We recommend the Knott County Fiscal Court implement adequate internal controls to ensure federal compliance requirements are met. In addition, the fiscal court should maintain documentation for all project activity to effectively track work that is necessary and to determine the portion eligible for coverage under Federal programs.
Criteria: The CDBG program required monthly narrative reports as well as monthly beneficiary reports to be submitted. Financial reporting is required under 2 CFR 200.328 and program reporting is required under 2 CFR 200.329. 30 Condition: The required reporting requirements are not deemed to have been met. The reports cannot be located, and therefore it can not be determined if the reports were submitted as required. Cause: The YWCA New Hampshire has had significant turnover in management and administration in recent years. Whether or not such reports were submitted, the information could not be located for purposes of testing. Effect or potential effect: Internal control over the financial activities of the grants is weakened. A specific requirement for the grant was potentially not completed, which could result in required repayment of the grant funds or prevention of future awards. Questioned costs: Questioned costs are not applicable to this finding. Context: The YWCA New Hampshire expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2023 requiring a compliance audit in accordance with the Uniform Guidance. The organization has not required a compliance audit in previous years and management was not aware of the various requirements of the Uniform Guidance. Recommendation: It is recommended that grant activity be maintained in a dedicated file for future references. We recommend that any documentation related to the grant, including the application, award, requests for reimbursement, quarterly and annual filings, closing report, etc. all be retained in a central location and accessible by management. Views of Responsible Officials: YWCA New Hampshire’s management concurs with this audit finding.
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-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient's and subrecipient's financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.
FINDING REFERENCE NUMBER 2023-051 (See Finding Reference Number 2023-021) FEDERAL PROGRAM (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRLIEA (Federal Award Years: 2021 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR § 200.302, Financial Management, establishes that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450.) (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. … (6) Written procedures to implement the requirements of § 200.305 and (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION As part of our audit procedures over the reporting requirement for LIHEAP program, we selected two reports submitted during our fiscal year. We noted that the administrative expenditures do not reconcile with the accounting information from PRIFAS. In addition, for the amount of encumbrances of $11,032,784.51, the amount of $9,943,769.52 was not supported by a detail. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This is a systematic deficiency. Procedures and internal controls manuals should provide for and ensure the segregation of duties, and the reconciliation of financial information reported to federal agencies against the accounting records used to prepare financial statements and SEFA. ADSEF failure to support reported amounts with verifiable documentation and the absence of independent review increases the risk of inaccurate or misstated financial data being reported to the Federal awarding agency. STATEMENT OF CAUSE During our interviews and understanding of the internal controls over financial reporting, we noted that only one person prepares, submits and certifies the SF– 425 reports. No proper segregation of duties exists, that allows for validation of all accounting data before submitting the reports. In addition, the procedures manual for preparing reports does not establish a clear process for obtaining information, validating it, recording it, preparing it, and reporting it, as well as the responsibilities and segregation of duties to ensure that the reported information is consistent with ADSEF's accounting records. ADSEF lacks internal controls that allow for the timely validation and reconciliation of financial information. Furthermore, they lack a written procedures manual detailing the processes to follow in obtaining accounting data and reporting it to the Federal government, ensuring that the responsibility does not fall on a single individual. POSSIBLE ASSERTED EFFECT ADSEF does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports to the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend ADSEF to establish written procedures and internal controls manuals to provide and document the segregation of duties related to the reporting compliance requirement.
FINDING REFERENCE NUMBER 2023-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.
Condition: During the test of 100% of projects, thirty-five (35) projects, for the Coronavirus and Local Fiscal Recovery Funds, the following noncompliance with the Reporting compliance requirement was noted: • Eighteen (18) projects were coded as revenue loss and were a subrecipient relationship. • Seventeen (17) projects were coded as revenue loss and should have been coded to an Administrative code. • Four (4) projects were coded as a subrecipient and should not have been. After the review of the quarterly reports, the following exceptions were noted: • The second quarter report was over reported by $643,303, • 911 Trust Authority reported $195,398 in cumulative expenditures on the report; however, no disbursements were made in fiscal year 2022 or fiscal year 2023. • North West Rogers County Fire Protection District reported $171,219 in cumulative expenditures; however, no disbursements were made in fiscal year 2022 and fiscal year 2023. • Emergency Management reported $333,169 in cumulative expenditures; however, there were only expenditures totaling $18,313. • School Resource Officers reported $135,778 in cumulative expenditures; however, there were only expenditures totaled $41,447. • Expenditures for the jail security electronics upgrade was not reported; however, there were expenditures totaling $132,501. Cause of Condition: Policies and procedures have not been designed and implemented to ensure federal expenditures are properly reported in accordance with federal compliance requirements. Effect of Condition: This condition resulted in noncompliance with federal grant guidelines. Recommendation: OSAI recommends the County gain an understanding of the requirements for this program and implement internal controls to ensure compliance with these requirements. Management Response: Board of County Commissioners: The Board of County Commissioners is responsible for the overall fiscal concerns of the county. See OKLA. STAT. Title 19, § 345. The Board of County Commissioners, with the cooperation and participation of all elected officials, reviews, develops and implements policies and procedures to create a strong internal control environment. The Board of County Commissioners will work with all elected officials, the third-party administrator, and federal, state and local partners to develop policies, procedures, and internal controls designed to accurately track grants, including the application process, verification, oversight, and reporting of grant requirements. These policies and procedures will be designed to identify requirements for recipients and sub-recipients of grants, ensure accurate equipment and real property management, procurement, recipient and subrecipient monitoring and reporting. Further, policies will ensure a proper understanding of all grant requirements and compliance of the same. To assist in this process, the Board of County Commissioners engaged a third-party administrator to oversee the grant process, including application, eligibility, review, requirements, contracting, recipient tracking and oversight, and documentation and reporting. The Board of County Commissioners will work with the third-party administrator to ensure proper grant administration. Criteria: Accountability and stewardship should be overall goals in management’s accounting of federal funds. Internal controls should be designed to monitor compliance with laws and regulations pertaining to grant contracts. Title 2 CFR § 200.303(a) Internal Controls, reads as follows: The non-federal entity must: 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). Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds (10. Reporting) reads as follows: All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlines in Part 2 of this guidance. Expenditures may be reported on a cash of accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. In addition, where appropriate, your organization needs to establish internal controls to ensure completion and timely submission of all mandatory performance and/or compliance reporting. Further, 2 CFR 200.329-Monitoring and reporting Program Performance (c)(1) reads as follows: (c)(1) The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes. Reports submitted annually by the non-Federal entity and/or pass-through entity 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. Alternatively, the Federal awarding agency or pass-through entity may require annual reports before the anniversary dates of multiple year Federal awards. The final performance report submitted by the non-Federal entity and/or pass-through entity must be due no later than 120 calendar gays after the period of performance end date. A subrecipient must submit to the pass-through entity, no later than 90 calendar days after the period of performance end date, all final performance reports as required by the terms and conditions of the Federal award. See also §200.344. If a justified request is submitted by a non-Federal entity, the Federal agency may extend the due date for any performance report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were prepared by the Treasurer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction, of errors prior to submission. Due to the lack of effective internal controls, one of the six annual data reports was not supported by the School Corporation's records. For the ESSER III, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022, total expenses per the report were $688,778. However, the School Corporation's ledger had total expenses for the award, for that time period, of $784,638. INDIANA STATE BOARD OF ACCOUNTS 18 OAK HILL UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls and noncompliance were isolated to the ESSER III, Year 2 report. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the ESSER III, Year 2 report was not supported by the School Corporation's records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. 19 INDIANA STATE BOARD OF ACCOUNTS OAK HILL UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that all expenditures are reported on the reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were prepared by the Treasurer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction, of errors prior to submission. Due to the lack of effective internal controls, one of the six annual data reports was not supported by the School Corporation's records. For the ESSER III, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022, total expenses per the report were $688,778. However, the School Corporation's ledger had total expenses for the award, for that time period, of $784,638. INDIANA STATE BOARD OF ACCOUNTS 18 OAK HILL UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls and noncompliance were isolated to the ESSER III, Year 2 report. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the ESSER III, Year 2 report was not supported by the School Corporation's records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. 19 INDIANA STATE BOARD OF ACCOUNTS OAK HILL UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that all expenditures are reported on the reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Federal Agency: U.S. Department of Homeland Security Pass-Through Agency: Central Office of Recovery, Reconstruction and Resiliency of Puerto Rico (COR3) Program: Disaster Grants – Public Assistance (Presidentially-Declared Disaster) (ALN 97.036) Compliance Requirement: Reporting (L) Type of Finding: Significant Deficiency in Internal Control (SD), Instance of Noncompliance (NC) Statement of Condition In our Reporting Test, we evaluated the Quarterly Progress Reports of a total of five (5) projects for two quarters of fiscal year 2022-2023. Our audit procedures revealed that Quarterly Progress Reports were not submitted for one of the quarters for four of the five projects evaluated. Criteria 2 CFR 200.328 (c) states that the recipient or subrecipient must submit financial reports as required by the Federal award. […] Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. 2 CFR 200.329 (c) (1) states that the recipient or subrecipient must submit performance reports as required by the Federal award. […] Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. […] 2 CFR 200.332 (b) (3) states that any additional requirements that the pass-through entity imposes on the subrecipient for the pass-through entity to meet its responsibilities under the Federal award. This includes information and certifications […] required for submitting financial and performance reports that the pass-through entity must provide to the Federal agency. 44 CFR 206.204 (f) states that progress reports will be submitted by the recipient to the Regional Administrator quarterly. […] COR3, as a pass-through entity, requires Subrecipients to complete and submit a quarterly progress report for each Project Worksheet (“PW”) through the Disaster Recovery Solution (“DRS”) Platform. This information is then submitted to the Federal Emergency Management Agency (FEMA). Quarterly Progress Reports cannot be edited or submitted after the deadline. Cause of Condition The Municipality did not manage time effectively to complete the Quarterly Progress Reports as required by the Federal award. Effect of Condition The Municipality failed in the submission of Quarterly Progress Reports as required by the Federal award. Recommendation We recommend the Program Administrators manage time effectively to complete the Quarterly Progress Reports timely. Questioned Costs None. Views of Responsible Officials and Planned Corrective Action We will give instructions to the accounting staff in charge of the preparation of the quarterly progress reports of the Program, in order to comply with the FEMA reporting requirements. Responsible Official: Mrs. Irma M. Vargas Aguirre, Finance and Budget Director Implementation Date: December 31, 2025
Community Development Financial Institutions Rapid Response Program (CDFI RRP), Assistance Listing Number: 21.024 U.S. Department of the Treasury Program Year 2022 Criteria or specific requirement – Reporting (2 CFR section 200.328 and 200.329) Condition – The Credit Union reported the incorrect amount of cumulative awards expended in the 2022 Use of Awards Report. Cause – The Credit Union’s controls did not ensure the proper amounts were reported. Effect – The Credit Union reported the incorrect amount of awards expended during 2022. Questioned costs – N/A Context – The Credit Union is required to submit three reports for the year ended December 31, 2022. All of the required reports were tested. The 2022 Use of Awards report reported $828,265 as the cumulative use of award, rather than the actual total cumulative use of $1,826,265 that was actually expended during the year. Identification as a repeat finding, if applicable – N/A Recommendation – Management should review and update controls over federal grant reporting to ensure reports are prepared using complete and accurate information. Views of responsible officials and planned corrective actions – The input error was corrected prior to end of the audit. The credit union's CDFI analyst was contacted by the Chief Strategic Officer and the analyst opened the data field for editing in the AMIS system. The Chief Strategic Officer made the correction in the AMIS system and submitted the corrected information. The Chief Strategic Officer has assigned CDFI reporting responsibilities to the Director of Strategy. Future submissions will be performed by the Director of Strategy and reviewed by the Chief Strategic Officer prior to submission.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Criteria: In accordance with 2 CFR 200.328 and 2 CFR 200.329, the College is required to prepare and publicly post quarterly reports related to the student aid and institutional portions of HEERF expenditures. Condition: During our audit, we selected one of the four quarterly reports to test the accuracy of the reporting. Our testing indicated certain amounts on the quarterly report that did not agree to the expenditures for the quarter. Questioned Costs: None Effect: The College was not in compliance with HEERF reporting requirements. Cause: Certain HEERF I expenditures were improperly excluded from the report and some misunderstanding of requirements of certain items in the report. Recommendation: We recommend reconciliation of quarterly reports to related grant documentation and review of the reports by an appropriate team member to ensure accuracy. Views of responsible officials and planned corrective action: The College agrees with this finding and will adhere to the corrective action plan on page 34 in this audit report.