FINDING 2023-004 Subject: Twenty-First Century Community Learning Centers - Cash Management, Program Income and Reporting Federal Agency: Department of Education Federal Program: Twenty-First Century Community Learning Centers Assistance Listings Number: 84.287 Federal Award Numbers and Years (or Other Identifying Numbers): A58-1-21DL-0153, A58-1-21DL-5176, A58-2-22DL-0018, A58-3-23DL-0027 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Cash Management, Program Income, and Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation utilized grant funds to operate an After School Care Safe Harbor Program. As part of the programs, the students were charged monthly fees to help cover the related costs. Per the grant guidelines, families cannot be turned away for nonpayment of fees, and any fees collected are to be reinvested into the programs. Reimbursement requests are to deduct the program income received from allowable costs prior to claiming reimbursement. During the audit period, the School Corporation collected fees for the Before School Care Program and the After School Care Safe Harbor Program in the same manner. Fees collected for both programs were collected and receipted into the After School fund. For the years ended June 30, 2022, and June 30, 2023, the School Corporation receipted a total of $45,723 and $41,513, respectively, into the After School fund. Cash Management The School Corporation submitted 18 reimbursement requests in the audit period. Costs were paid prior to requesting reimbursement as required; however, due to the lack of adequate program income records the reimbursements were not reduced by the program income received. INDIANA STATE BOARD OF ACCOUNTS 26 MICHIGAN CITY AREA SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Program Income Although the School Corporation received approval from the grantor agency to collect program income, the School Corporation did not properly track students' attendance and payments, both if paid and how much paid; therefore, we were unable to determine the amount of program income related to each program. Additionally, the School Corporation did not maintain program income in a separate fund but comingled it with other nongrant funded program revenues. Finally, the School Corporation did not deduct program income from allowable costs prior to claiming reimbursement. Reporting Reimbursement Requests The School Corporation submitted 18 reimbursement requests in the audit period. Of those, 3 reimbursement requests were selected for testing. Of the 3 reimbursement requests inspected, none were reduced by program income received, and 1 was not properly supported by School Corporation records. The reimbursement was overstated by $14,700 when compared to the ledger. Based on additional procedures performed, the total requested reimbursements for the audit period were understated by $32,605 when compared to the ledger. Year End Reports End of Year reports are to be submitted within 60 days of the contract end date. A total of four End of Year Reports were submitted in the audit period and two were selected for testing. Of the two End of Year reports selected for testing, neither properly included program income received during the year due to inadequate tracking of program income. The lack of controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.305(b)(5) states in part: "To the extent available, the non-Federal entity must disburse funds available from program income (including repayments to a revolving fund), rebates, refunds, contract settlements, audit recoveries, and interest earned on such funds before requesting additional cash payments." INDIANA STATE BOARD OF ACCOUNTS 27 MICHIGAN CITY AREA SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.307 states in part: "(a) General. Non-Federal entities are encouraged to earn income to defray program costs where appropriate. . . . (e) Use of program income. If the Federal awarding agency does not specify in its regulations or the terms and conditions of the Federal award, or give prior approval for how program income is to be used, paragraph (e)(1) of this section must apply. For Federal awards made to IHEs and nonprofit research institutions, if the Federal awarding agency does not specify in its regulations or the terms and conditions of the Federal award how program income is to be used, paragraph (e)(2) of this section must apply. In specifying alternatives to paragraphs (e)(1) and (2) of this section, the Federal awarding agency may distinguish between income earned by the recipient and income earned by subrecipients and between the sources, kinds, or amounts of income. When the Federal awarding agency authorizes the approaches in paragraphs (e)(2) and (3) of this section, program income in excess of any amounts specified must also be deducted from expenditures. (1) Deduction. Ordinarily program income must be deducted from total allowable costs to determine the net allowable costs. Program income must be used for current costs unless the Federal awarding agency authorizes otherwise. Program income that the non- Federal entity did not anticipate at the time of the Federal award must be used to reduce the Federal award and non- Federal entity contributions rather than to increase the funds committed to the project. (2) Addition. With prior approval of the Federal awarding agency (except for IHEs and nonprofit research institutions, as described in this paragraph (e)) program income may be added to the Federal award by the Federal agency and the non-Federal entity. The program income must be used for the purposes and under the conditions of the Federal award. (3) Cost sharing or matching. With prior approval of the Federal awarding agency, program income may be used to meet the cost sharing or matching requirement of the Federal award. The amount of the Federal award remains the same. . . ." 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 28 MICHIGAN CITY AREA SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal 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, program income was not properly documented resulting in noncompliance with the Cash Management, Program Income, and Reporting compliance requirements. 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 by 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 strengthen its policies and procedures to ensure proper tracking of program income to ensure all activity and reports submitted on behalf of the Twenty-First Century Community Learning Centers program funds are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Twenty-First Century Community Learning Centers - Cash Management, Program Income and Reporting Federal Agency: Department of Education Federal Program: Twenty-First Century Community Learning Centers Assistance Listings Number: 84.287 Federal Award Numbers and Years (or Other Identifying Numbers): A58-1-21DL-0153, A58-1-21DL-5176, A58-2-22DL-0018, A58-3-23DL-0027 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Cash Management, Program Income, and Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation utilized grant funds to operate an After School Care Safe Harbor Program. As part of the programs, the students were charged monthly fees to help cover the related costs. Per the grant guidelines, families cannot be turned away for nonpayment of fees, and any fees collected are to be reinvested into the programs. Reimbursement requests are to deduct the program income received from allowable costs prior to claiming reimbursement. During the audit period, the School Corporation collected fees for the Before School Care Program and the After School Care Safe Harbor Program in the same manner. Fees collected for both programs were collected and receipted into the After School fund. For the years ended June 30, 2022, and June 30, 2023, the School Corporation receipted a total of $45,723 and $41,513, respectively, into the After School fund. Cash Management The School Corporation submitted 18 reimbursement requests in the audit period. Costs were paid prior to requesting reimbursement as required; however, due to the lack of adequate program income records the reimbursements were not reduced by the program income received. INDIANA STATE BOARD OF ACCOUNTS 26 MICHIGAN CITY AREA SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Program Income Although the School Corporation received approval from the grantor agency to collect program income, the School Corporation did not properly track students' attendance and payments, both if paid and how much paid; therefore, we were unable to determine the amount of program income related to each program. Additionally, the School Corporation did not maintain program income in a separate fund but comingled it with other nongrant funded program revenues. Finally, the School Corporation did not deduct program income from allowable costs prior to claiming reimbursement. Reporting Reimbursement Requests The School Corporation submitted 18 reimbursement requests in the audit period. Of those, 3 reimbursement requests were selected for testing. Of the 3 reimbursement requests inspected, none were reduced by program income received, and 1 was not properly supported by School Corporation records. The reimbursement was overstated by $14,700 when compared to the ledger. Based on additional procedures performed, the total requested reimbursements for the audit period were understated by $32,605 when compared to the ledger. Year End Reports End of Year reports are to be submitted within 60 days of the contract end date. A total of four End of Year Reports were submitted in the audit period and two were selected for testing. Of the two End of Year reports selected for testing, neither properly included program income received during the year due to inadequate tracking of program income. The lack of controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.305(b)(5) states in part: "To the extent available, the non-Federal entity must disburse funds available from program income (including repayments to a revolving fund), rebates, refunds, contract settlements, audit recoveries, and interest earned on such funds before requesting additional cash payments." INDIANA STATE BOARD OF ACCOUNTS 27 MICHIGAN CITY AREA SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.307 states in part: "(a) General. Non-Federal entities are encouraged to earn income to defray program costs where appropriate. . . . (e) Use of program income. If the Federal awarding agency does not specify in its regulations or the terms and conditions of the Federal award, or give prior approval for how program income is to be used, paragraph (e)(1) of this section must apply. For Federal awards made to IHEs and nonprofit research institutions, if the Federal awarding agency does not specify in its regulations or the terms and conditions of the Federal award how program income is to be used, paragraph (e)(2) of this section must apply. In specifying alternatives to paragraphs (e)(1) and (2) of this section, the Federal awarding agency may distinguish between income earned by the recipient and income earned by subrecipients and between the sources, kinds, or amounts of income. When the Federal awarding agency authorizes the approaches in paragraphs (e)(2) and (3) of this section, program income in excess of any amounts specified must also be deducted from expenditures. (1) Deduction. Ordinarily program income must be deducted from total allowable costs to determine the net allowable costs. Program income must be used for current costs unless the Federal awarding agency authorizes otherwise. Program income that the non- Federal entity did not anticipate at the time of the Federal award must be used to reduce the Federal award and non- Federal entity contributions rather than to increase the funds committed to the project. (2) Addition. With prior approval of the Federal awarding agency (except for IHEs and nonprofit research institutions, as described in this paragraph (e)) program income may be added to the Federal award by the Federal agency and the non-Federal entity. The program income must be used for the purposes and under the conditions of the Federal award. (3) Cost sharing or matching. With prior approval of the Federal awarding agency, program income may be used to meet the cost sharing or matching requirement of the Federal award. The amount of the Federal award remains the same. . . ." 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 28 MICHIGAN CITY AREA SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal 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, program income was not properly documented resulting in noncompliance with the Cash Management, Program Income, and Reporting compliance requirements. 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 by 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 strengthen its policies and procedures to ensure proper tracking of program income to ensure all activity and reports submitted on behalf of the Twenty-First Century Community Learning Centers program funds are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
2023-006 - Cash Management Federal Program Information: ALN - 66.458 - Clean Water State Revolving Funds Criteria: The following CFR(s) apply to this finding: 2 CFR section 200.302(b)(6)) & 2 CFR section 200.305(b) (3). Condition: During audit procedures, it was identified that the Town did not have a cash management policy in place. Cause: The Town has experienced turnover in the Treasurer’s position over the past few years, which has delayed the policy implementation. Effect: The Town may not have adequate policy and procedures in place to safeguard its most liquid assets. Identification of Questioned Costs: None identified. Context: The population consisted of 6 out of 10 pay requisites deposit of reimbursements from the fiscal year were examined. Out of the 6 selections all 6 were not properly recorded. Repeat Finding: This is a repeat finding of 2022-007. Recommendation: It is recommended that the Town adopt a cash management policy that follows the Uniform Guidance and that the Town implement internal control processes and procedures to ensure that the adopted policy is followed. Views of Responsible Officials and Corrective Action Plan: Client agrees with finding and a version of their response can be found in the Corrective Action Plan. Please see the Corrective Action Plan issued by the Town of Livermore Falls.
2023-006 - Cash Management Federal Program Information: ALN - 66.458 - Clean Water State Revolving Funds Criteria: The following CFR(s) apply to this finding: 2 CFR section 200.302(b)(6)) & 2 CFR section 200.305(b) (3). Condition: During audit procedures, it was identified that the Town did not have a cash management policy in place. Cause: The Town has experienced turnover in the Treasurer’s position over the past few years, which has delayed the policy implementation. Effect: The Town may not have adequate policy and procedures in place to safeguard its most liquid assets. Identification of Questioned Costs: None identified. Context: The population consisted of 6 out of 10 pay requisites deposit of reimbursements from the fiscal year were examined. Out of the 6 selections all 6 were not properly recorded. Repeat Finding: This is a repeat finding of 2022-007. Recommendation: It is recommended that the Town adopt a cash management policy that follows the Uniform Guidance and that the Town implement internal control processes and procedures to ensure that the adopted policy is followed. Views of Responsible Officials and Corrective Action Plan: Client agrees with finding and a version of their response can be found in the Corrective Action Plan. Please see the Corrective Action Plan issued by the Town of Livermore Falls.
2023-006 - Cash Management Federal Program Information: ALN - 66.458 - Clean Water State Revolving Funds Criteria: The following CFR(s) apply to this finding: 2 CFR section 200.302(b)(6)) & 2 CFR section 200.305(b) (3). Condition: During audit procedures, it was identified that the Town did not have a cash management policy in place. Cause: The Town has experienced turnover in the Treasurer’s position over the past few years, which has delayed the policy implementation. Effect: The Town may not have adequate policy and procedures in place to safeguard its most liquid assets. Identification of Questioned Costs: None identified. Context: The population consisted of 6 out of 10 pay requisites deposit of reimbursements from the fiscal year were examined. Out of the 6 selections all 6 were not properly recorded. Repeat Finding: This is a repeat finding of 2022-007. Recommendation: It is recommended that the Town adopt a cash management policy that follows the Uniform Guidance and that the Town implement internal control processes and procedures to ensure that the adopted policy is followed. Views of Responsible Officials and Corrective Action Plan: Client agrees with finding and a version of their response can be found in the Corrective Action Plan. Please see the Corrective Action Plan issued by the Town of Livermore Falls.
2023-006 - Cash Management Federal Program Information: ALN - 66.458 - Clean Water State Revolving Funds Criteria: The following CFR(s) apply to this finding: 2 CFR section 200.302(b)(6)) & 2 CFR section 200.305(b) (3). Condition: During audit procedures, it was identified that the Town did not have a cash management policy in place. Cause: The Town has experienced turnover in the Treasurer’s position over the past few years, which has delayed the policy implementation. Effect: The Town may not have adequate policy and procedures in place to safeguard its most liquid assets. Identification of Questioned Costs: None identified. Context: The population consisted of 6 out of 10 pay requisites deposit of reimbursements from the fiscal year were examined. Out of the 6 selections all 6 were not properly recorded. Repeat Finding: This is a repeat finding of 2022-007. Recommendation: It is recommended that the Town adopt a cash management policy that follows the Uniform Guidance and that the Town implement internal control processes and procedures to ensure that the adopted policy is followed. Views of Responsible Officials and Corrective Action Plan: Client agrees with finding and a version of their response can be found in the Corrective Action Plan. Please see the Corrective Action Plan issued by the Town of Livermore Falls.
Condition: The Organization’s written policies and procedures related to financial management and procurement do not meet the requirements of 2 CFR 200, Subpart D and Subpart E. Criteria: According to 2 CFR Section 200.302.b and 2 CFR Section 200.305 of the Uniform Guidance, the Organization is required to have a written financial management policy. Additionally, according to 2 CFR Section 200.317 – 200.326, the Organization is required to have a written procurement policy. Cause: The Organization was unaware of requirements regarding policies and procedures outlined in the Uniform Guidance. Effect: Written policies necessary for non-Federal entities receiving federal funds were not in place. Repeat Finding: No Questioned Costs: None reported Recommendation: We recommend that the Organization update their written policies and procedures that meet the requirements of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Views of Responsible Officials and Planned Corrective Action: We concur with the auditor’s finding and will update the Organization’s written policies and procedures for the Uniform Guidance requirements.
Condition: The Organization’s written policies and procedures related to financial management and procurement do not meet the requirements of 2 CFR 200, Subpart D and Subpart E. Criteria: According to 2 CFR Section 200.302.b and 2 CFR Section 200.305 of the Uniform Guidance, the Organization is required to have a written financial management policy. Additionally, according to 2 CFR Section 200.317 – 200.326, the Organization is required to have a written procurement policy. Cause: The Organization was unaware of requirements regarding policies and procedures outlined in the Uniform Guidance. Effect: Written policies necessary for non-Federal entities receiving federal funds were not in place. Repeat Finding: No Questioned Costs: None reported Recommendation: We recommend that the Organization update their written policies and procedures that meet the requirements of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Views of Responsible Officials and Planned Corrective Action: We concur with the auditor’s finding and will update the Organization’s written policies and procedures for the Uniform Guidance requirements.
Condition: The Organization’s written policies and procedures related to financial management and procurement do not meet the requirements of 2 CFR 200, Subpart D and Subpart E. Criteria: According to 2 CFR Section 200.302.b and 2 CFR Section 200.305 of the Uniform Guidance, the Organization is required to have a written financial management policy. Additionally, according to 2 CFR Section 200.317 – 200.326, the Organization is required to have a written procurement policy. Cause: The Organization was unaware of requirements regarding policies and procedures outlined in the Uniform Guidance. Effect: Written policies necessary for non-Federal entities receiving federal funds were not in place. Repeat Finding: No Questioned Costs: None reported Recommendation: We recommend that the Organization update their written policies and procedures that meet the requirements of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Views of Responsible Officials and Planned Corrective Action: We concur with the auditor’s finding and will update the Organization’s written policies and procedures for the Uniform Guidance requirements.
Finding 2023-005: Cash Management (Material Weakness) Information on the Federal Programs: Assistance Listing Number 98.001 Criteria: According to Uniform Guidance (2 CFR 200.305(b)), Federal funds must be managed in a way that minimizes the time elapsing between the transfer of funds and the Organization’s disbursement of those funds for program purposes. Additionally, internal controls over cash management should ensure that all drawdowns are approved by designated personnel to prevent improper or premature use of Federal funds. Condition: During our review of Federal grant drawdowns, it was noted that several drawdowns were processed without obtaining the required internal approvals as outlined in Astraea's cash management policies and procedures. Cause: Astraea’s cash management procedures were not consistently followed, leading to missed approvals for certain drawdowns. Effect: Drawdowns without proper internal approval increase the risk of non-compliance with Federal cash management requirements and could result in unauthorized or inaccurate fund usage. Questioned Costs: None noted. Identification as a Repeat Finding, if Applicable: Finding 2022-007 Recommendation: Astraea should reinforce cash management controls by ensuring all Federal drawdowns obtain the appropriate internal approvals before processing. This can be achieved by implementing a checklist or automated workflow to verify compliance with approval requirements.
FA 2023-003 Improve Controls over Cash Management Compliance Requirement: Cash Management Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Number and Title: COVID-19 – 84.425U – American Rescue Plan Elementary and Secondary School Emergency Relief Fund Federal Award Number: S425U210012 (Year: 2021) Questioned Costs: None Identified Description: The School District made cash drawdowns in excess of immediate cash needs for the Elementary and Secondary School Emergency Relief Fund program. Background Information: The School District may request Elementary and Secondary Emergency Relief (ESSER) Fund program funds from the Georgia Department of Education (GaDOE) once per month. GaDOE requires the School District to submit DE-0147 – Requests for Reimbursement of Monthly Cash Disbursements through the Grants Accounting Online Reporting System to receive program funds. When a DE-0147 request is submitted and approved, the funds are typically disbursed to the School District through an electronic payment process the next week. The School District submitted DE-0147 requests to receive a total of $3,636,320 in ESSER funds from GaDOE during the fiscal year under review. Criteria: As a recipient of federal awards, the Institution is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance Section 200.305(b) state that “For non-Federal entities other than states, payment methods must minimize the time elapsing between the transfer of funds…the pass-through entity and the disbursement by the non-Federal entity.” In addition, the Uniform Guidance Section 200.302(b)(6) requires the entity to develop written cash management procedures. Condition: A review of all cash drawdowns and disbursements related to the ESSER program was performed to determine if any excessive cash balances were maintained during the fiscal year under review. Cash balances in excess of program materiality were maintained for the ESSER program for 37 days. Additionally, it was noted that the School District did not have appropriate internal controls in place over the cash drawdown process. Cause: In discussing this issue with the School District, they indicated that the lack of review of federal grants resulted in excess cash drawdown requests. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. In addition, the School District could potentially accrue an interest liability that would be owed back to the federal government. Furthermore, when the School District cannot meet the requirement to minimize the time elapsing between the transfer of funds and disbursement of those funds, provisions included in the Uniform Guidance allow GaDOE to change the method by which the School District is transferred funds and delay the School District’s receipt of these funds. This may include a requirement by GaDOE to submit invoices prior to being reimbursed for program expenditures. Recommendation: The School District should establish procedures to accurately forecast the cash needs of the ESSER program and minimize the time elapsing between the transfer of funds from GaDOE and the disbursement of such funds by the School District. In addition, these procedures should be documented in writing in accordance with the Uniform Guidance Section 200.302(b)(6). Furthermore, management should develop and implement a monitoring process to ensure that these procedures are followed. Views of Responsible Officials: We concur with this finding.
FA 2023-003 Improve Controls over Cash Management Compliance Requirement: Cash Management Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: 84.010 - Title I Grants to Local Educational Agencies Federal Award Numbers: S010A210010-21A (Year: 2022), SO10A220010 (Year: 2023) Questioned Costs: None Identified Repeat of Prior Year Findings: FA 2022-003, FA 2021-001, FA 2020-001, FA 2019-001, FA 2018-001, FA 2017-002, FA 2016-001, FA 2015-002, FA 2014-003 Description: The School District made cash drawdowns in excess of immediate cash needs for the Title I Grants to Local Educational Agencies program. Background Information: The School District may request Title I Grants to Local Educational Agencies program funds from the Georgia Department of Education (GaDOE) once per month. GaDOE requires the School District to submit DE-0147 – Requests for Reimbursement of Monthly Cash Disbursements through the Grants Accounting Online Reporting System to receive program funds. When a DE-0147 request is submitted and approved, the funds are typically disbursed to the School District through an electronic payment process the next week. The School District submitted DE-0147 requests to receive a total of $426,546 in Title I funds from GaDOE during the fiscal year under review. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance Section 200.305(b) state that “For non-Federal entities other than states, payment methods must minimize the time elapsing between the transfer of funds…the pass-through entity and the disbursement by the non-Federal entity.” In addition, the Uniform Guidance Section 200.302(b)(6) requires the entity to develop written cash management procedures. Further, as noted in the Uniform Guidance Section 200.511, management is responsible for implementing reported corrective action to findings from previous audits. lll FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Condition: A review of all cash drawdowns and disbursements related to the Title I program was performed to determine if any excessive cash balances were maintained during the fiscal year under review. Cash balances in excess of program materiality were maintained for the Title I program for 273 days. Additionally, it was noted that the School District did not have appropriate internal controls in place over the cash drawdown process. Cause: In discussing this issue with the School District, they indicated that the lack of review of Federal grants resulted in excess cash drawdown request. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. In addition, the School District could potentially accrue an interest liability that would be owed back to the federal government. Furthermore, when the School District cannot meet the requirement to minimize the time elapsing between the transfer of funds and disbursement of those funds, provisions included in the Uniform Guidance allow GaDOE to change the method by which the School District is transferred funds and delay the School District’s receipt of these funds. This may include a requirement by GaDOE to submit invoices prior to being reimbursed for program expenditures. Recommendation: The School District should establish procedures to accurately forecast the cash needs of the Title I program and minimize the time elapsing between the transfer of funds from GaDOE and the disbursement of such funds by the School District. In addition, these procedures should be documented in writing in accordance with the Uniform Guidance Section 200.302(b)(6). Furthermore, management should develop and implement a monitoring process to ensure that these procedures are followed. Views of Responsible Officials: We concur with this finding.
FA 2023-003 Improve Controls over Cash Management Compliance Requirement: Cash Management Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: 84.010 - Title I Grants to Local Educational Agencies Federal Award Numbers: S010A210010-21A (Year: 2022), SO10A220010 (Year: 2023) Questioned Costs: None Identified Repeat of Prior Year Findings: FA 2022-003, FA 2021-001, FA 2020-001, FA 2019-001, FA 2018-001, FA 2017-002, FA 2016-001, FA 2015-002, FA 2014-003 Description: The School District made cash drawdowns in excess of immediate cash needs for the Title I Grants to Local Educational Agencies program. Background Information: The School District may request Title I Grants to Local Educational Agencies program funds from the Georgia Department of Education (GaDOE) once per month. GaDOE requires the School District to submit DE-0147 – Requests for Reimbursement of Monthly Cash Disbursements through the Grants Accounting Online Reporting System to receive program funds. When a DE-0147 request is submitted and approved, the funds are typically disbursed to the School District through an electronic payment process the next week. The School District submitted DE-0147 requests to receive a total of $426,546 in Title I funds from GaDOE during the fiscal year under review. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance Section 200.305(b) state that “For non-Federal entities other than states, payment methods must minimize the time elapsing between the transfer of funds…the pass-through entity and the disbursement by the non-Federal entity.” In addition, the Uniform Guidance Section 200.302(b)(6) requires the entity to develop written cash management procedures. Further, as noted in the Uniform Guidance Section 200.511, management is responsible for implementing reported corrective action to findings from previous audits. lll FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Condition: A review of all cash drawdowns and disbursements related to the Title I program was performed to determine if any excessive cash balances were maintained during the fiscal year under review. Cash balances in excess of program materiality were maintained for the Title I program for 273 days. Additionally, it was noted that the School District did not have appropriate internal controls in place over the cash drawdown process. Cause: In discussing this issue with the School District, they indicated that the lack of review of Federal grants resulted in excess cash drawdown request. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. In addition, the School District could potentially accrue an interest liability that would be owed back to the federal government. Furthermore, when the School District cannot meet the requirement to minimize the time elapsing between the transfer of funds and disbursement of those funds, provisions included in the Uniform Guidance allow GaDOE to change the method by which the School District is transferred funds and delay the School District’s receipt of these funds. This may include a requirement by GaDOE to submit invoices prior to being reimbursed for program expenditures. Recommendation: The School District should establish procedures to accurately forecast the cash needs of the Title I program and minimize the time elapsing between the transfer of funds from GaDOE and the disbursement of such funds by the School District. In addition, these procedures should be documented in writing in accordance with the Uniform Guidance Section 200.302(b)(6). Furthermore, management should develop and implement a monitoring process to ensure that these procedures are followed. Views of Responsible Officials: We concur with this finding.
Finding 2023-001 Lack of Internal Controls over Cash Management Federal Agency: U.S. Department of the Treasury Federal Programs: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Assistance Listing Numbers: 21.027 Award Number: SLFRP3171/4774 Award Years: 2021 Type of Finding: Material weakness in internal control over compliance and material noncompliance. Criteria: The requirement for cash management as contained in 2 CFR 200.305, which states advanced cash payments must be used only for applicable grant programs. Condition and Context: Procedures related to cash management were inadequate to ensure that funds drawn down were not used for other grant expenditures. The Village’s cash balances for all governmental funds amounted to $3,569,292 at September 30, 2023. The unearned revenues were $3,789,475 which resulted in a shortfall of $220,183. The unearned revenue for the CSLFRF Fund was $2,941,712. Cause: Lack of internal controls over cash management. Effect: The Village requested and received advances for various federal programs to cover expenditures. Deposits were used to fund other programs of the Village. Questioned Costs: $220,183, which is the shortfall between cash and investment balances and the unearned revenue balances. Repeat Finding: This is a repeat of finding 2022-001, and since this is a repeat finding we believe this to be a systemic issue. Recommendation: We recommend that the Village monitor grant budgets and drawdowns throughout the year and ensure that program funds are not being lent or borrowed between programs in an effort to ensure that unearned revenue balances do not exceed total cash and investments. Management’s Response: Management concurs with this finding. See corrective action plan.
Finding 2023-003 - Material Weakness in Internal Control over Compliance and Material Noncompliance (Qualified Opinion) - Inadequate Tracking of Expenditures and Retention of Documentation: Activities Allowed or Unallowed: Allowable Costs/Cost Principles and Reporting (A/B/L) for Assistance Listing Number 19.510 and 93.567 Criteria: The Code of Federal Regulations (CFR) Section 200.510(b) states in part, “The auditee must also prepare a schedule of federal expenditures for the period covered by the auditee’s consolidated financial statements which must include the total Federal awards expended as determined in accordance with 200.502.” Also, in accordance with CFR Section 200.302(b) - Financial Management, the auditees financial management system must provide 1) identification of all federal awards received and expended; 2) accurate, current, and complete disclosure of the financial results of each federal award or program; 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; 5) comparison of expenditures with budget amounts for each Federal award; 6) written procedures to implement the requirements of section 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. Recipients of federal awards must submit accurate, complete and timely financial and performance reports. The Organization should have internal controls designed to ensure compliance with those provisions. The Organization should retain sufficient documentation such as invoice and allocation support for expenditures to retain documentation for audit purposes. Condition: During detail testing of expenditures, it was noted that the Organization did not maintain adequate documentation to support how certain costs were allocated to the federal program. Several transactions lacked sufficient detail, such as invoice or expense reimbursement form. Several expenditures selected for testing did not obtain sufficient approval by an individual at the Organization. It was noted that quarterly reports provided to the federal program were not reviewed by an individual at the Organization prior to submission to ensure accurate report of expenditures. Cause: The Organization does not have an adequate system in place to ensure quarterly reports have sufficient supporting documentation, proper approval/review, and accurate reporting prior to submission. Responsibilities for expenditure tracking were not clearly assigned, and there was no formal review process in place. The Organization is not following their Document Retention Policy. Effect: The effect of this condition increases the possibility that quarterly financial reports are misstated or inaccurate and increase the risk of noncompliance with federal requirements. The effect of this condition also increases the risk that expenditures are unallowable per the grant, federal regulations, or cost principles due to the insufficient support of proper approval retained. Questioned costs: None Repeat Finding: Yes - 2022-004 Recommendation: Policies and procedures should be in place to ensure quarterly financial reports are properly supported, accurately reported, and adequately approved and reviewed. A formal review process should be established to ensure compliance. The Organization should following the Document Retention Policy that was put in place and required by law. Views of Responsible Officials: Management agrees with this finding and their response is included in the Corrective Action Plan.
Finding 2023-003 - Material Weakness in Internal Control over Compliance and Material Noncompliance (Qualified Opinion) - Inadequate Tracking of Expenditures and Retention of Documentation: Activities Allowed or Unallowed: Allowable Costs/Cost Principles and Reporting (A/B/L) for Assistance Listing Number 19.510 and 93.567 Criteria: The Code of Federal Regulations (CFR) Section 200.510(b) states in part, “The auditee must also prepare a schedule of federal expenditures for the period covered by the auditee’s consolidated financial statements which must include the total Federal awards expended as determined in accordance with 200.502.” Also, in accordance with CFR Section 200.302(b) - Financial Management, the auditees financial management system must provide 1) identification of all federal awards received and expended; 2) accurate, current, and complete disclosure of the financial results of each federal award or program; 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; 5) comparison of expenditures with budget amounts for each Federal award; 6) written procedures to implement the requirements of section 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. Recipients of federal awards must submit accurate, complete and timely financial and performance reports. The Organization should have internal controls designed to ensure compliance with those provisions. The Organization should retain sufficient documentation such as invoice and allocation support for expenditures to retain documentation for audit purposes. Condition: During detail testing of expenditures, it was noted that the Organization did not maintain adequate documentation to support how certain costs were allocated to the federal program. Several transactions lacked sufficient detail, such as invoice or expense reimbursement form. Several expenditures selected for testing did not obtain sufficient approval by an individual at the Organization. It was noted that quarterly reports provided to the federal program were not reviewed by an individual at the Organization prior to submission to ensure accurate report of expenditures. Cause: The Organization does not have an adequate system in place to ensure quarterly reports have sufficient supporting documentation, proper approval/review, and accurate reporting prior to submission. Responsibilities for expenditure tracking were not clearly assigned, and there was no formal review process in place. The Organization is not following their Document Retention Policy. Effect: The effect of this condition increases the possibility that quarterly financial reports are misstated or inaccurate and increase the risk of noncompliance with federal requirements. The effect of this condition also increases the risk that expenditures are unallowable per the grant, federal regulations, or cost principles due to the insufficient support of proper approval retained. Questioned costs: None Repeat Finding: Yes - 2022-004 Recommendation: Policies and procedures should be in place to ensure quarterly financial reports are properly supported, accurately reported, and adequately approved and reviewed. A formal review process should be established to ensure compliance. The Organization should following the Document Retention Policy that was put in place and required by law. Views of Responsible Officials: Management agrees with this finding and their response is included in the Corrective Action Plan.
FINDING REFERENCE NUMBER 2023-029 (See Finding Reference Number 2023-001) FEDERAL PROGRAM (ALN – 10.542) PANDEMIC EBT FOOD BENEFITS (P-EBT) U.S. DEPARTMENT OF AGRICULTURE AWARD NUMBERS 221PR456S9032; 2301PR456S9032 (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ACTIVITIES ALLOWED OR UNALLOWED // REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. … (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION As part of our internal control procedures for the financial management system, allowable activities and reporting requirements, we found the following deficiencies: • Of ten (10) expenditure accounting transactions, three (3) were selected for documentation review. It was found that a transaction posted in August 2022 for $193,642,697.32 included $54,195,406.92, corresponding to benefit payrolls for May 2022, which had previously been claimed in June 2022. They subsequently adjusted the expenditure reported for this amount. • All expenditure transactions are coded under the ID number PANDEMICEBT-B22; although, in the SF-778 report for the quarter ended June 30, 2023, for the grant award period for 2023, expenditures in the amount of $29,606,939 were reported as incurred. This data does not agree with the accounting information of PRIFAS. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This is a systematic deficiency. After conducting several interviews, we were able to identify the staff responsible for validating the benefit payrolls. This person told us these benefit payrolls were processed via email, which indicated that the information submitted was preliminary. However, the finance staff proceeded with the adjustment in the accounting system. We conducted interviews to determine if anything had been modified in the benefit payroll processing process. To prevent this situation from happening again, they told us it wasn't necessary because it hasn't happened again. Procedures and internal controls manuals should provide for and ensure the segregation of duties, and the reconciliation of financial information reported to federal agencies against the accounting records used to prepare financial statements and SEFA. ADSEF failure to support reported amounts with verifiable documentation and the absence of independent review increases the risk of inaccurate or misstated financial data being reported to the federal awarding agency. STATEMENT OF CAUSE ADSEF has not established an adequate control procedure to identify duplicate claims before they are filed and recorded. During our interviews and understanding of the internal controls over financial reporting, we noted that only one person prepares, submits and certifies the SF-425 reports. No proper segregation of duties exists, that allows for validation of all accounting data before submitting the reports. In addition, the procedures manual for preparing reports does not establish a clear process for obtaining information, validating it, recording it, preparing it, and reporting it, as well as the responsibilities and segregation of duties to ensure that the reported information is consistent with ADSEF's accounting records. ADSEF lacks internal controls that allow for the timely validation and reconciliation of financial information. Furthermore, they lack a written procedures manual detailing the processes to follow in obtaining accounting data and reporting it to the federal government, ensuring that the responsibility does not fall on a single individual. POSSIBLE ASSERTED EFFECT The failure to have an internal control procedure that identifies standard documentation or forms, personnel responsible for validating the information included, and controls payroll and benefit expenses and other previously claimed expenses allowed for the recognition and claim of an expense incurred twice. ADSEF is not ensuring that the reports are accurate and traceable to the accounting database used to prepare their financial reports to the Federal Agencies and their financial statements. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish an adequate internal controls process that identifies documentation, personnel responsible, authorizations, and validations that can prevent this situation from recurring. In addition, we recommend management to establish written procedures and internal controls manuals to provide and document the segregation of duties related to the reporting compliance requirement.
FINDING REFERENCE NUMBER 2023-032 (See Finding Reference Number 2023-004) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 211PR426S7003/4; 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) 2022G9922PT; 2301PRTABD (Federal Award Years: 2022 through 2023) 2201PRLIEA; 2301PRLIEA (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award.” STATEMENT OF CONDITION As part of our audit procedures, we conducted an analysis of the process used to distribute administrative costs among the various programs administered by ADSEF. Administrative expenses are distributed based on a methodology called "Random Moment Sampling" (RMS). We identified the following deficiencies in the implementation and execution of this process: i. There is no written procedure that outlines the process for applying this formula for distributing administrative expenses. ii. There is no standardized monitoring or communication to ensure that employees who are required to complete this form are fully assigned to the roles subject to this process. In other words, the Human Resources Department or the Appointments Office do not communicate periodically or whenever a staff change occurs, in order to adjust the population subject to this questionnaire. iii. Among the options provided for responding to the RMS survey, three options are not assigned to a Federal program. These options include licenses; other types of work not directly tied to a Federal program function for which administrative expenses can be allocated. According to the State Plan, 3,300 questionnaires will be administered for functions performed by employees who are not at the central level, and 300 for employees who are at the central level. Two quarters of the Fiscal Year 2022-2023 were observed, in which these three options represented between 33% and 22% for local offices and 29% at the central level. Because these options are not tied to a Federal program function, they reduce the percentage to zero and redistribute the percentage among Federal programs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. This allocation of administrative expenses is made quarterly; however, the adjustment in the accounting system (PRIFAS) is not necessarily made in the same period. The administrative expenses of each program contain the redistribution of expenses not assigned to a Federal program. STATEMENT OF CAUSE ADSEF does not have a written procedure establishing the process for implementing and monitoring the execution of this methodology. Additionally, among the responses regarding functions performed, time may be allocated to functions not related to Federal programs. POSSIBLE ASSERTED EFFECT They lack a standardized process that ensures that the methodology used allocates reasonable administrative costs among Federal programs, ensures that the distribution base is complete, and is periodically monitored. Furthermore, by redistributing the percentage of responses not directly related to a Federal program function, administrative costs could be claimed from Federal programs that should likely be allocated to state funds. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish a written internal control procedure that provides certainty, monitoring frequency, data validation, and responsibilities for those responsible for executing this process. Additionally, it should be considered that there are functions performed by the personnel in charge of answering the RMS that are not directly linked to a Federal program and should be assigned to state funds.
FINDING REFERENCE NUMBER 2023-032 (See Finding Reference Number 2023-004) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 211PR426S7003/4; 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) 2022G9922PT; 2301PRTABD (Federal Award Years: 2022 through 2023) 2201PRLIEA; 2301PRLIEA (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award.” STATEMENT OF CONDITION As part of our audit procedures, we conducted an analysis of the process used to distribute administrative costs among the various programs administered by ADSEF. Administrative expenses are distributed based on a methodology called "Random Moment Sampling" (RMS). We identified the following deficiencies in the implementation and execution of this process: i. There is no written procedure that outlines the process for applying this formula for distributing administrative expenses. ii. There is no standardized monitoring or communication to ensure that employees who are required to complete this form are fully assigned to the roles subject to this process. In other words, the Human Resources Department or the Appointments Office do not communicate periodically or whenever a staff change occurs, in order to adjust the population subject to this questionnaire. iii. Among the options provided for responding to the RMS survey, three options are not assigned to a Federal program. These options include licenses; other types of work not directly tied to a Federal program function for which administrative expenses can be allocated. According to the State Plan, 3,300 questionnaires will be administered for functions performed by employees who are not at the central level, and 300 for employees who are at the central level. Two quarters of the Fiscal Year 2022-2023 were observed, in which these three options represented between 33% and 22% for local offices and 29% at the central level. Because these options are not tied to a Federal program function, they reduce the percentage to zero and redistribute the percentage among Federal programs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. This allocation of administrative expenses is made quarterly; however, the adjustment in the accounting system (PRIFAS) is not necessarily made in the same period. The administrative expenses of each program contain the redistribution of expenses not assigned to a Federal program. STATEMENT OF CAUSE ADSEF does not have a written procedure establishing the process for implementing and monitoring the execution of this methodology. Additionally, among the responses regarding functions performed, time may be allocated to functions not related to Federal programs. POSSIBLE ASSERTED EFFECT They lack a standardized process that ensures that the methodology used allocates reasonable administrative costs among Federal programs, ensures that the distribution base is complete, and is periodically monitored. Furthermore, by redistributing the percentage of responses not directly related to a Federal program function, administrative costs could be claimed from Federal programs that should likely be allocated to state funds. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish a written internal control procedure that provides certainty, monitoring frequency, data validation, and responsibilities for those responsible for executing this process. Additionally, it should be considered that there are functions performed by the personnel in charge of answering the RMS that are not directly linked to a Federal program and should be assigned to state funds.
FINDING REFERENCE NUMBER 2023-032 (See Finding Reference Number 2023-004) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 211PR426S7003/4; 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) 2022G9922PT; 2301PRTABD (Federal Award Years: 2022 through 2023) 2201PRLIEA; 2301PRLIEA (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award.” STATEMENT OF CONDITION As part of our audit procedures, we conducted an analysis of the process used to distribute administrative costs among the various programs administered by ADSEF. Administrative expenses are distributed based on a methodology called "Random Moment Sampling" (RMS). We identified the following deficiencies in the implementation and execution of this process: i. There is no written procedure that outlines the process for applying this formula for distributing administrative expenses. ii. There is no standardized monitoring or communication to ensure that employees who are required to complete this form are fully assigned to the roles subject to this process. In other words, the Human Resources Department or the Appointments Office do not communicate periodically or whenever a staff change occurs, in order to adjust the population subject to this questionnaire. iii. Among the options provided for responding to the RMS survey, three options are not assigned to a Federal program. These options include licenses; other types of work not directly tied to a Federal program function for which administrative expenses can be allocated. According to the State Plan, 3,300 questionnaires will be administered for functions performed by employees who are not at the central level, and 300 for employees who are at the central level. Two quarters of the Fiscal Year 2022-2023 were observed, in which these three options represented between 33% and 22% for local offices and 29% at the central level. Because these options are not tied to a Federal program function, they reduce the percentage to zero and redistribute the percentage among Federal programs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. This allocation of administrative expenses is made quarterly; however, the adjustment in the accounting system (PRIFAS) is not necessarily made in the same period. The administrative expenses of each program contain the redistribution of expenses not assigned to a Federal program. STATEMENT OF CAUSE ADSEF does not have a written procedure establishing the process for implementing and monitoring the execution of this methodology. Additionally, among the responses regarding functions performed, time may be allocated to functions not related to Federal programs. POSSIBLE ASSERTED EFFECT They lack a standardized process that ensures that the methodology used allocates reasonable administrative costs among Federal programs, ensures that the distribution base is complete, and is periodically monitored. Furthermore, by redistributing the percentage of responses not directly related to a Federal program function, administrative costs could be claimed from Federal programs that should likely be allocated to state funds. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish a written internal control procedure that provides certainty, monitoring frequency, data validation, and responsibilities for those responsible for executing this process. Additionally, it should be considered that there are functions performed by the personnel in charge of answering the RMS that are not directly linked to a Federal program and should be assigned to state funds.
FINDING REFERENCE NUMBER 2023-032 (See Finding Reference Number 2023-004) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 211PR426S7003/4; 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) 2022G9922PT; 2301PRTABD (Federal Award Years: 2022 through 2023) 2201PRLIEA; 2301PRLIEA (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award.” STATEMENT OF CONDITION As part of our audit procedures, we conducted an analysis of the process used to distribute administrative costs among the various programs administered by ADSEF. Administrative expenses are distributed based on a methodology called "Random Moment Sampling" (RMS). We identified the following deficiencies in the implementation and execution of this process: i. There is no written procedure that outlines the process for applying this formula for distributing administrative expenses. ii. There is no standardized monitoring or communication to ensure that employees who are required to complete this form are fully assigned to the roles subject to this process. In other words, the Human Resources Department or the Appointments Office do not communicate periodically or whenever a staff change occurs, in order to adjust the population subject to this questionnaire. iii. Among the options provided for responding to the RMS survey, three options are not assigned to a Federal program. These options include licenses; other types of work not directly tied to a Federal program function for which administrative expenses can be allocated. According to the State Plan, 3,300 questionnaires will be administered for functions performed by employees who are not at the central level, and 300 for employees who are at the central level. Two quarters of the Fiscal Year 2022-2023 were observed, in which these three options represented between 33% and 22% for local offices and 29% at the central level. Because these options are not tied to a Federal program function, they reduce the percentage to zero and redistribute the percentage among Federal programs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. This allocation of administrative expenses is made quarterly; however, the adjustment in the accounting system (PRIFAS) is not necessarily made in the same period. The administrative expenses of each program contain the redistribution of expenses not assigned to a Federal program. STATEMENT OF CAUSE ADSEF does not have a written procedure establishing the process for implementing and monitoring the execution of this methodology. Additionally, among the responses regarding functions performed, time may be allocated to functions not related to Federal programs. POSSIBLE ASSERTED EFFECT They lack a standardized process that ensures that the methodology used allocates reasonable administrative costs among Federal programs, ensures that the distribution base is complete, and is periodically monitored. Furthermore, by redistributing the percentage of responses not directly related to a Federal program function, administrative costs could be claimed from Federal programs that should likely be allocated to state funds. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish a written internal control procedure that provides certainty, monitoring frequency, data validation, and responsibilities for those responsible for executing this process. Additionally, it should be considered that there are functions performed by the personnel in charge of answering the RMS that are not directly linked to a Federal program and should be assigned to state funds.
FINDING REFERENCE NUMBER 2023-033 (See Finding Reference Number 2023-005) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 211PR426S7003/4; 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 2021G990229 (TANF – COVID-19) (Federal Award Year: 2021) 2022G996117; 2023996117 (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. … (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award.” In addition, 45 CFR 260.31 (b)(1), defines what non-recurrent, short-term (NRST) benefits are. In relation to Pandemic Emergency Assistance Fund (PEAF), the regulation establishes that: “NRST benefits, like all NRSTs under TANF, must: be designed to deal with a specific crisis situation or episode of need; not be intended to meet on-going needs; and not extend beyond four months; and (as explained in the instructions for reporting on line 15 of the ACF-196R) NRSTs paid for with PEAF funds: must only include expenditures such as emergency assistance and diversion payments, emergency housing and short-term homelessness assistance, emergency food aid, short-term utilities payments, burial assistance, clothing allowances, and back-to-school payments; and may not include tax credits, child care, transportation, or short-term education and training.” STATEMENT OF CONDITION As part of our audit procedures over transactions related to emissions of benefits for the TANF program, we selected five (5) transactions, from a population of fifty-three (53) emissions made during the fiscal year. We noted the following deficiencies: i. An emission of benefits for $16,236,447.24 related to PEAF funding was made. We request evidence of an established manual or guide that defines or identifies the need that would be addressed with the issuance of these funds, and the subsequent monitoring of the usage. ii. An emission of benefits for $3,633,800 was made related to a bonus. The documentation for this issuance includes an authorization letter establishing a benefit of $800 per child between the ages of 5 and 17 years and 11 months, serving a population of 4,492 participants, for a total of $3,593,600. Later, another authorization letter added $37,000 but did not specify the number of children included in this amendment. The sum of both authorizations is $3,630,600; however, the amount reflected in PRIFAS is $3,633,800. According to the EBT document related to this issuance, the amount issued was $3,596,800 and indicates that the number of participants benefited was 4,974, giving an average benefit of $723.12. In this EBT document, beneficiaries are distributed by region; however, there are 5 beneficiaries who are not assigned to a region, for a total of $4,000. iii. An emission of $1,988,000 was made related to an incentive for some beneficiaries. In accordance with an authorization letter, the benefit included $3,500 per participants who worked or participated in an activity leading to employment for 3 months or more. In accordance with the State Plan, active recipients may receive a 6-months period Work Incentive Bonus payment. Per the authorization letter the benefit of $3,500 was issued to 522 participants, for a total of $1,827,000; another authorization letter increased $3,500 in funds. This amount does not agree with the PRIFAS amount of $1,988,000. ADSEF is allowed to claim 16.80% of indirect costs. As part of our audit procedures over the Nutrition Assistance for Puerto Rico and TANF program, we selected some transactions to evaluate the compliance with the indirect costs claims. The TANF program reported four (4) transactions related to indirect costs, and for the Nutrition Assistance for Puerto Rico five (5) transactions were reported. We requested evidence of two (2) transactions for the TANF program and one (1) for the Nutrition Assistance for Puerto Rico, no evidence of class object was provided in order to ascertain that only allowable expenditure transactions were considered in the calculation and claim of indirect costs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. There are no processes to reconcile PRIFAS information with emissions reported in EBT, nor to claim indirect costs. STATEMENT OF CAUSE ADSEF does not have a process for validating EBT issuances with PRIFAS, and this reconciliation is not performed periodically to detect any errors or missing information when accounting for transactions. POSSIBLE ASSERTED EFFECT The PRIFAS accounting system is not reconciled with EBT reports. This process is not stipulated as part of the internal controls required to ensure that the records used to prepare the financial statement, SEFA, and Federal reports are reconciled, and any discrepancies are identified. In addition, indirect costs calculation may include unallowable costs and not be detected timely. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish internal control processes to reconcile PRIFAS and the various sources of information used for reporting. Additionally, maintain clear records of indirect costs claimed and awarded.
FINDING REFERENCE NUMBER 2023-033 (See Finding Reference Number 2023-005) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 211PR426S7003/4; 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 2021G990229 (TANF – COVID-19) (Federal Award Year: 2021) 2022G996117; 2023996117 (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. … (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award.” In addition, 45 CFR 260.31 (b)(1), defines what non-recurrent, short-term (NRST) benefits are. In relation to Pandemic Emergency Assistance Fund (PEAF), the regulation establishes that: “NRST benefits, like all NRSTs under TANF, must: be designed to deal with a specific crisis situation or episode of need; not be intended to meet on-going needs; and not extend beyond four months; and (as explained in the instructions for reporting on line 15 of the ACF-196R) NRSTs paid for with PEAF funds: must only include expenditures such as emergency assistance and diversion payments, emergency housing and short-term homelessness assistance, emergency food aid, short-term utilities payments, burial assistance, clothing allowances, and back-to-school payments; and may not include tax credits, child care, transportation, or short-term education and training.” STATEMENT OF CONDITION As part of our audit procedures over transactions related to emissions of benefits for the TANF program, we selected five (5) transactions, from a population of fifty-three (53) emissions made during the fiscal year. We noted the following deficiencies: i. An emission of benefits for $16,236,447.24 related to PEAF funding was made. We request evidence of an established manual or guide that defines or identifies the need that would be addressed with the issuance of these funds, and the subsequent monitoring of the usage. ii. An emission of benefits for $3,633,800 was made related to a bonus. The documentation for this issuance includes an authorization letter establishing a benefit of $800 per child between the ages of 5 and 17 years and 11 months, serving a population of 4,492 participants, for a total of $3,593,600. Later, another authorization letter added $37,000 but did not specify the number of children included in this amendment. The sum of both authorizations is $3,630,600; however, the amount reflected in PRIFAS is $3,633,800. According to the EBT document related to this issuance, the amount issued was $3,596,800 and indicates that the number of participants benefited was 4,974, giving an average benefit of $723.12. In this EBT document, beneficiaries are distributed by region; however, there are 5 beneficiaries who are not assigned to a region, for a total of $4,000. iii. An emission of $1,988,000 was made related to an incentive for some beneficiaries. In accordance with an authorization letter, the benefit included $3,500 per participants who worked or participated in an activity leading to employment for 3 months or more. In accordance with the State Plan, active recipients may receive a 6-months period Work Incentive Bonus payment. Per the authorization letter the benefit of $3,500 was issued to 522 participants, for a total of $1,827,000; another authorization letter increased $3,500 in funds. This amount does not agree with the PRIFAS amount of $1,988,000. ADSEF is allowed to claim 16.80% of indirect costs. As part of our audit procedures over the Nutrition Assistance for Puerto Rico and TANF program, we selected some transactions to evaluate the compliance with the indirect costs claims. The TANF program reported four (4) transactions related to indirect costs, and for the Nutrition Assistance for Puerto Rico five (5) transactions were reported. We requested evidence of two (2) transactions for the TANF program and one (1) for the Nutrition Assistance for Puerto Rico, no evidence of class object was provided in order to ascertain that only allowable expenditure transactions were considered in the calculation and claim of indirect costs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. There are no processes to reconcile PRIFAS information with emissions reported in EBT, nor to claim indirect costs. STATEMENT OF CAUSE ADSEF does not have a process for validating EBT issuances with PRIFAS, and this reconciliation is not performed periodically to detect any errors or missing information when accounting for transactions. POSSIBLE ASSERTED EFFECT The PRIFAS accounting system is not reconciled with EBT reports. This process is not stipulated as part of the internal controls required to ensure that the records used to prepare the financial statement, SEFA, and Federal reports are reconciled, and any discrepancies are identified. In addition, indirect costs calculation may include unallowable costs and not be detected timely. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish internal control processes to reconcile PRIFAS and the various sources of information used for reporting. Additionally, maintain clear records of indirect costs claimed and awarded.
FINDING REFERENCE NUMBER 2023-034 (See Finding Reference Number 2023-006) FEDERAL PROGRAMS (ALN – 93.556) MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.556) COVID-19 – MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.667) SOCIAL SERVICES BLOCK GRANT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRFPSS; 2101PRFPSC; 2101PRFPCV; 2202PRFPCV; 2203PRFPSS (Federal Award Years: 2021 through 2023) 2111PRSOSR; 2211PRSOSR (Federal Award Years: 2021 through 2023) ADMINISTRATION ADMINISTRATION FOR FAMILIES AND CHILDREN (ADFAN, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES // CASH MANAGEMENT TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): … (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award.” STATEMENT OF CONDITION As part of our audit procedures, we verified the requirements for the written procedures policies, and we didn’t obtain by ADFAN the required documentation. This represents a scope limitation. QUESTIONED COSTS None. PERSPECTIVE INFORMATION This deficiency is a systemic problem that is related to lack of proper training, segregation of duties and written policies and procedures. STATEMENT OF CAUSE ADFAN has not established a work plan to maintain the written procedures policies required by the Uniform Guidance. POSSIBLE ASSERTED EFFECT The absence of written procedures may lead to inconsistent program implementation, unclear assignment of responsibilities, and inadequate oversight. This increases the risk of noncompliance with applicable regulations, inefficiencies in operations, and reduced effectiveness in achieving program objectives. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that ADFAN develop, formalize, and implement comprehensive written procedures for the programs to comply with the Uniform Guidance. These procedures should clearly define roles and responsibilities, establish operational workflows, and include mechanisms for monitoring and compliance. Doing so will help ensure consistency in program execution, accountability, and alignment with regulatory and performance requirements.
FINDING REFERENCE NUMBER 2023-034 (See Finding Reference Number 2023-006) FEDERAL PROGRAMS (ALN – 93.556) MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.556) COVID-19 – MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.667) SOCIAL SERVICES BLOCK GRANT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRFPSS; 2101PRFPSC; 2101PRFPCV; 2202PRFPCV; 2203PRFPSS (Federal Award Years: 2021 through 2023) 2111PRSOSR; 2211PRSOSR (Federal Award Years: 2021 through 2023) ADMINISTRATION ADMINISTRATION FOR FAMILIES AND CHILDREN (ADFAN, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES // CASH MANAGEMENT TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): … (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award.” STATEMENT OF CONDITION As part of our audit procedures, we verified the requirements for the written procedures policies, and we didn’t obtain by ADFAN the required documentation. This represents a scope limitation. QUESTIONED COSTS None. PERSPECTIVE INFORMATION This deficiency is a systemic problem that is related to lack of proper training, segregation of duties and written policies and procedures. STATEMENT OF CAUSE ADFAN has not established a work plan to maintain the written procedures policies required by the Uniform Guidance. POSSIBLE ASSERTED EFFECT The absence of written procedures may lead to inconsistent program implementation, unclear assignment of responsibilities, and inadequate oversight. This increases the risk of noncompliance with applicable regulations, inefficiencies in operations, and reduced effectiveness in achieving program objectives. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that ADFAN develop, formalize, and implement comprehensive written procedures for the programs to comply with the Uniform Guidance. These procedures should clearly define roles and responsibilities, establish operational workflows, and include mechanisms for monitoring and compliance. Doing so will help ensure consistency in program execution, accountability, and alignment with regulatory and performance requirements.
FINDING REFERENCE NUMBER 2023-034 (See Finding Reference Number 2023-006) FEDERAL PROGRAMS (ALN – 93.556) MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.556) COVID-19 – MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.667) SOCIAL SERVICES BLOCK GRANT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRFPSS; 2101PRFPSC; 2101PRFPCV; 2202PRFPCV; 2203PRFPSS (Federal Award Years: 2021 through 2023) 2111PRSOSR; 2211PRSOSR (Federal Award Years: 2021 through 2023) ADMINISTRATION ADMINISTRATION FOR FAMILIES AND CHILDREN (ADFAN, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES // CASH MANAGEMENT TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): … (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award.” STATEMENT OF CONDITION As part of our audit procedures, we verified the requirements for the written procedures policies, and we didn’t obtain by ADFAN the required documentation. This represents a scope limitation. QUESTIONED COSTS None. PERSPECTIVE INFORMATION This deficiency is a systemic problem that is related to lack of proper training, segregation of duties and written policies and procedures. STATEMENT OF CAUSE ADFAN has not established a work plan to maintain the written procedures policies required by the Uniform Guidance. POSSIBLE ASSERTED EFFECT The absence of written procedures may lead to inconsistent program implementation, unclear assignment of responsibilities, and inadequate oversight. This increases the risk of noncompliance with applicable regulations, inefficiencies in operations, and reduced effectiveness in achieving program objectives. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that ADFAN develop, formalize, and implement comprehensive written procedures for the programs to comply with the Uniform Guidance. These procedures should clearly define roles and responsibilities, establish operational workflows, and include mechanisms for monitoring and compliance. Doing so will help ensure consistency in program execution, accountability, and alignment with regulatory and performance requirements.
FINDING REFERENCE NUMBER 2023-035 (See Finding Reference Number 2023-007) FEDERAL PROGRAMS (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE (ALN – 93.568) COVID-19 – LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRLIEA; 2201PRLIEA; 2301PRLIEA; 2001PRLIEA; 2001PRE5C3 (Federal Award Years: 2020 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT CASH MANAGEMENT TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200.302, requires recipient's and subrecipient's financial management system must provide for the following: (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; and (6) written procedures to implement the requirements of § 200.305. 2 CFR 200.305, Federal Payments, establishes that: (a) payments for States are governed by Treasury-State Cash Management Improvement Act (CMIA) agreements and default procedures codified at 31 CFR part 205 and Treasury Financial Manual (TFM) 4A-2000, “Overall Disbursing Rules for All Federal Agencies”; (b) for recipients and subrecipients other than States, payment methods must minimize the time elapsing between the transfer of funds from the Federal agency or the pass-through entity and the disbursement of funds by the recipient or subrecipient regardless of whether the payment is made by electronic funds transfer or by other means. See § 200.302(b)(6). Except as noted in this part, the Federal agency must require recipients to use only OMB-approved, government-wide information collections to request payment. STATEMENT OF CONDITION As part of our understanding of internal controls and compliance regarding cash management, we obtained a procedures manual. We found the following deficiencies: 1. The effective date is April 2024. 2. In the section describing the LIHEAP process, the US Department of Agriculture is mentioned instead of the US Department of Health and Human Services. 3. It does not identify the personnel responsible for the processes to establish segregation of duties. 4. In our interviews it was noted that only one person is in charge of all drawdowns, and no proper supervision or review of the documentation is performed. In addition, a detail of the requests related to the program was obtained; however, this request information does not reconcile with the revenue recognized in PRIFAS. The following deficiencies were identified: 1. The document includes amounts identified as LIHEAP, which belong to another Federal program, the Low-Income Household Water Assistance Program (ALN 93.499), in the amount of $4,590,528. 2. The amount of $306,483.12 is presented twice and is only recognized in PRIFAS once. 3. PRIFAS includes revenue of $3,900,000 related to the COVID-19 portion of funds, which is not included in the breakdown. From a population of fifty-seven (57) revenue transactions, six (6) transactions were selected to ensure that the correct amounts were requested from the Federal program and that the documents indicated in the manual were included with each petition. The following deficiencies were observed: 1. The documents included do not contain signatures from the personnel who perform each process. 2. The documentation included in the manual does not match the documentation included in the documents submitted with each petition. 3. In an emission of ARPA funding through LUMA, part of the documentation provided was document EMISM210, which stated that the authorized amount was $16,014,374. In a recap made in the document (not signed), the amount of $4,181 was adjusted in the petition, indicating that this amount was rejected by LUMA. In a letter from LUMA, they certified that the total cases reported were 327,499 for a total amount of $16,010,193. A detail of participants was provided, and the total was 327,498, although the benefits were $16,010,193. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This deficiency is a systemic problem, lack of proper training and updated information to all personnel with the responsibility of determining, supervising, and monitoring the eligibility determinations and follow-up. The sampling was a statistical valid sample. STATEMENT OF CAUSE ADSEF does not have a procedures manual that clearly establishes a segregation of duties, demonstrating compliance with the required internal control components. POSSIBLE ASSERTED EFFECT This is a systematic deficiency. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish a written internal controls process that demonstrates compliance with cash management requirements and appropriate segregation of duties.
FINDING REFERENCE NUMBER 2023-035 (See Finding Reference Number 2023-007) FEDERAL PROGRAMS (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE (ALN – 93.568) COVID-19 – LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRLIEA; 2201PRLIEA; 2301PRLIEA; 2001PRLIEA; 2001PRE5C3 (Federal Award Years: 2020 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT CASH MANAGEMENT TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR 200.302, requires recipient's and subrecipient's financial management system must provide for the following: (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; and (6) written procedures to implement the requirements of § 200.305. 2 CFR 200.305, Federal Payments, establishes that: (a) payments for States are governed by Treasury-State Cash Management Improvement Act (CMIA) agreements and default procedures codified at 31 CFR part 205 and Treasury Financial Manual (TFM) 4A-2000, “Overall Disbursing Rules for All Federal Agencies”; (b) for recipients and subrecipients other than States, payment methods must minimize the time elapsing between the transfer of funds from the Federal agency or the pass-through entity and the disbursement of funds by the recipient or subrecipient regardless of whether the payment is made by electronic funds transfer or by other means. See § 200.302(b)(6). Except as noted in this part, the Federal agency must require recipients to use only OMB-approved, government-wide information collections to request payment. STATEMENT OF CONDITION As part of our understanding of internal controls and compliance regarding cash management, we obtained a procedures manual. We found the following deficiencies: 1. The effective date is April 2024. 2. In the section describing the LIHEAP process, the US Department of Agriculture is mentioned instead of the US Department of Health and Human Services. 3. It does not identify the personnel responsible for the processes to establish segregation of duties. 4. In our interviews it was noted that only one person is in charge of all drawdowns, and no proper supervision or review of the documentation is performed. In addition, a detail of the requests related to the program was obtained; however, this request information does not reconcile with the revenue recognized in PRIFAS. The following deficiencies were identified: 1. The document includes amounts identified as LIHEAP, which belong to another Federal program, the Low-Income Household Water Assistance Program (ALN 93.499), in the amount of $4,590,528. 2. The amount of $306,483.12 is presented twice and is only recognized in PRIFAS once. 3. PRIFAS includes revenue of $3,900,000 related to the COVID-19 portion of funds, which is not included in the breakdown. From a population of fifty-seven (57) revenue transactions, six (6) transactions were selected to ensure that the correct amounts were requested from the Federal program and that the documents indicated in the manual were included with each petition. The following deficiencies were observed: 1. The documents included do not contain signatures from the personnel who perform each process. 2. The documentation included in the manual does not match the documentation included in the documents submitted with each petition. 3. In an emission of ARPA funding through LUMA, part of the documentation provided was document EMISM210, which stated that the authorized amount was $16,014,374. In a recap made in the document (not signed), the amount of $4,181 was adjusted in the petition, indicating that this amount was rejected by LUMA. In a letter from LUMA, they certified that the total cases reported were 327,499 for a total amount of $16,010,193. A detail of participants was provided, and the total was 327,498, although the benefits were $16,010,193. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This deficiency is a systemic problem, lack of proper training and updated information to all personnel with the responsibility of determining, supervising, and monitoring the eligibility determinations and follow-up. The sampling was a statistical valid sample. STATEMENT OF CAUSE ADSEF does not have a procedures manual that clearly establishes a segregation of duties, demonstrating compliance with the required internal control components. POSSIBLE ASSERTED EFFECT This is a systematic deficiency. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish a written internal controls process that demonstrates compliance with cash management requirements and appropriate segregation of duties.
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-049 (See Finding Reference Number 2023-020) FEDERAL PROGRAM (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE AWARD NUMBERS 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 211PR476V1003/4 – ARPA (Federal Award Years: March 11, 2021 through September 30, 2025) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR § 200.302, Financial Management, establishes that (a) each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. See § 200.450. In section (b), the recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): … (6) written procedures to implement the requirements of § 200.305 and (7) written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. The 2 CFR §200.303 (a) establishes that the recipient and subrecipient must: establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should align with the guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control-Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). STATEMENT OF CONDITION As part of our audit procedures over internal controls and compliance for reporting requirements, we selected two reports that closed during our fiscal year audit. With respect with the Grant Award 221PR426S7003 and 221PR426S7004 we noted the following deficiency: • The auditee was unable to provide supporting documentation for the administrative expenditures that reconcile the figures reported with the PRIFAS accounting system. • In addition, for all the Federal awards mentioned above, based on internal control interviews, we found that there is no designated individual responsible for independently reviewing the reports prior to submission to ensure accuracy and consistency with source data. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This deficiency is a systemic problem. Procedures and internal controls manuals should provide for and ensure the segregation of duties, and the reconciliation of financial information reported to Federal agencies against the accounting records used to prepare financial statement and SEFA. ADSEF failure to support reported amounts with verifiable documentation and the absence of independent review increases the risk of inaccurate or misstated financial data being reported to the Federal awarding agency. STATEMENT OF CAUSE During our interviews and understanding of the internal controls over financial reporting, we noted that only one person prepares, submits and certifies the required reports. No proper segregation of duties exists, that allows for validation of all accounting data before submitting the reports. In addition, the procedures manual for preparing reports does not establish a clear process for obtaining information, validating it, recording it, preparing it, and reporting it, as well as the responsibilities and segregation of duties to ensure that the reported information is consistent with ADSEF's accounting records. Furthermore, they lack a written procedures manual detailing the processes to follow in obtaining accounting data and reporting it to the Federal government, ensuring that the responsibility does not fall on a single individual. POSSIBLE ASSERTED EFFECT ADSEF does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports to the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend ADSEF establish written internal controls and specific procedures to ensure that all reported amounts are fully supported and reconciled with the PRIFAS accounting system and to assign responsibility to a designated official to review and approve all reports prior to submission to the Federal agency. Implement internal controls to maintain adequate documentation supporting all financial data reported.
FINDING REFERENCE NUMBER 2023-051 (See Finding Reference Number 2023-021) FEDERAL PROGRAM (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRLIEA (Federal Award Years: 2021 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR § 200.302, Financial Management, establishes that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450.) (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. … (6) Written procedures to implement the requirements of § 200.305 and (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION As part of our audit procedures over the reporting requirement for LIHEAP program, we selected two reports submitted during our fiscal year. We noted that the administrative expenditures do not reconcile with the accounting information from PRIFAS. In addition, for the amount of encumbrances of $11,032,784.51, the amount of $9,943,769.52 was not supported by a detail. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This is a systematic deficiency. Procedures and internal controls manuals should provide for and ensure the segregation of duties, and the reconciliation of financial information reported to federal agencies against the accounting records used to prepare financial statements and SEFA. ADSEF failure to support reported amounts with verifiable documentation and the absence of independent review increases the risk of inaccurate or misstated financial data being reported to the Federal awarding agency. STATEMENT OF CAUSE During our interviews and understanding of the internal controls over financial reporting, we noted that only one person prepares, submits and certifies the SF– 425 reports. No proper segregation of duties exists, that allows for validation of all accounting data before submitting the reports. In addition, the procedures manual for preparing reports does not establish a clear process for obtaining information, validating it, recording it, preparing it, and reporting it, as well as the responsibilities and segregation of duties to ensure that the reported information is consistent with ADSEF's accounting records. ADSEF lacks internal controls that allow for the timely validation and reconciliation of financial information. Furthermore, they lack a written procedures manual detailing the processes to follow in obtaining accounting data and reporting it to the Federal government, ensuring that the responsibility does not fall on a single individual. POSSIBLE ASSERTED EFFECT ADSEF does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports to the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend ADSEF to establish written procedures and internal controls manuals to provide and document the segregation of duties related to the reporting compliance requirement.
FINDING REFERENCE NUMBER 2023-052 FEDERAL PROGRAM (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING – PERFORMANCE TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA In accordance with 45 CFR, Subtitle B, Chapter II, Part 265.7, states that: (a) Each State's quarterly reports [the TANF Data Report, the TANF Financial Report (or Territorial Financial Report), the SSP-MOE Data Report, and the Work Outcomes of TANF Exciters Report] must be complete and accurate and filed by the due date. (b) For a disaggregated data report, “a complete and accurate report” means that: (1) The reported data accurately reflects information available to the State in case records, financial records, and automated data systems, and includes correction of the quarterly data by the end of the fiscal year reporting period; (2) The data are free from computational errors and are internally consistent (e.g., items that should add to totals do so); (3) The State reports data for all required elements (i.e., no data is missing); (4) (i) The State provides data on all families; or (ii) If the State opts to use sampling, the State reports data on all families selected in a sample that meets the specification and procedures in the TANF Sampling Manual (except for families listed in error); and (5) Where estimates are necessary (e.g., some types of assistance may require cost estimates), the State uses reasonable methods to develop these estimates. (c) For an aggregated data report, “a complete and accurate report” means that: (1) The reported data accurately reflects information available to the State in case records, financial records, and automated data systems; (2) The data are free from computational errors and are internally consistent (e.g., items that should add to totals do so); (3) The State reports data on all applicable elements; and (4) Monthly totals are unduplicated counts for all families (e.g., the number of families and the number of out-of-wedlock births are unduplicated counts). In addition, 2 CFR § 200.302 (a) establishes that each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. See § 200.450. In section (b) the recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (6) written procedures to implement the requirements of § 200.305 and (7) written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION As part of our procedures for understanding internal controls for the preparation of ACF-199 reports, we request a procedures manual on how these reports are processed and the personnel responsible for each process. ADSEF did not provide us with a manual describing the data collection process, how the information provided by the regions is validated, and the individuals responsible for submitting the reports. To evaluate compliance with the reported data, the quarter ending June 2023 was selected. From this period, forty (40) participants were selected. ADSEF was required to provide us with the corresponding participant worksheet appendix and the physical file to corroborate the information included in the report. ADSEF provided us with evidence of the hand-completed forms; however, we were not provided with the physical files to validate the information included in each document. This represents a scope limitation. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This is a systemic deficiency. After sample selection, ADSEF did not demonstrate a control structure that would allow the files to be located within a reasonable period of time. STATEMENT OF CAUSE ADSEF does not maintain an internal control structure for participant files that allows each file to be located within a reasonable period of time. Additionally, they do not have internal control procedure manuals that allow for the validation of the process they carry out and the individuals responsible for compiling, validating, and submitting this report. POSSIBLE ASSERTED EFFECT ADSEF may be including data in this report that has not been corroborated with the participants' physical records. The lack of a uniform process for archiving participant records prevented them from providing us with evidence of the requested records. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that management establish internal control procedures manuals that clearly outline the processes to be followed for data collection, recording, and reporting. Additionally, standardize the way documents related to participant files are filed.
FINDING REFERENCE NUMBER 2023-054 (See Finding Reference Number 2023-023) FEDERAL PROGRAMS (ALN – 93.556) MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.667) SOCIAL SERVICES BLOCK GRANT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRFPSS (Federal Award Years: 2021 through 2022) 2211PRSOSR (Federal Award Years: 2021 through 2022) ADMINISTRATION ADMINISTRATION FOR FAMILIES AND CHILDREN (ADFAN, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR § 200.302 (a) establishes that each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. See § 200.450. In addition, the SF-425 Federal Financial Report requires the reporting of financial activities related to Federal awards. The accounting basis used for reporting expenditures (whether cash or accrual) must align with the accounting system employed by the recipient organization. The 2 CFR § 200.302 (b), establish that the recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (6) written procedures to implement the requirements of § 200.305 and (7) written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. The 2 CFR section 200.328(c) establishes that the recipient or subrecipient must submit financial reports as required by the Federal award. Reports submitted annually by the recipient or subrecipient must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. The 2 CFR §200.303 (a) establishes that the recipient and subrecipient must: establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should align with the guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control-Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). STATEMENT OF CONDITION As part of our audit procedures over internal controls and compliance for reporting requirements, we selected the Grants Awards 2101PRFPSS and 2111PRSOSR, which closes in the audit period from July 2022 to June 2023, to validate the recorded amounts. Upon evaluating the report for the Grant Award 2101PRFPSS, we found the following deficiencies: (1) The total Federal expenditure reported on line (e) does not match the database provided by the PRDF. (2) The matching expenditure on line (j) does not match the database provided by the PRDF, and (3) The report was not submitted within the established deadline, and an extension was granted to settle and report the funds until March 31, 2023, and they submitted on August 10, 2023. For both Grants Awards we found the following deficiencies: (4) The accounting basis should be Cash Basis instead of Accrual Basis, according to the accounting system used. Additionally, they provided a Procedures Manual for the Finance and Budget Divisions, approved in 2009 and delivered in Word format, which states that the accounting basis is “accrual”, even though their current system operates on a cash basis. (5) During the internal control’s interviews, we found that there is no designated person responsible for reviewing the information entered by the preparer. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This deficiency is a systemic problem. Procedures and internal controls manuals should provide for and ensure the segregation of duties, training, and the reconciliation of financial information reported to Federal agencies against the accounting records used to prepare financial statement and SEFA. STATEMENT OF CAUSE ADFAN does not have internal controls to effectively review the process and comply with the reporting requirements. The absence of effective internal controls at ADFAN to review processes and ensure compliance with reporting requirements can be attributed to inadequate organizational structure and insufficiently defined roles and responsibilities. There is no designated individual or team responsible for overseeing the accuracy and completeness of financial data entered reports. As mentioned above in the statement of condition, this responsibility falls under one person and does not have segregation of duties. This gap in accountability stems from a lack of internal review and insufficient oversight mechanisms, which restrains the organization's ability to ensure that reports are fully aligned with the required compliance standards. Additionally, there is a lack of training or resources dedicated to maintaining and monitoring compliance which contributes to the failure in reporting requirements. POSSIBLE ASSERTED EFFECT ADFAN does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports for the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that ADFAN ensures the SF– 425 is completed using the appropriate accounting basis consistent with the organization’s financial system. Additionally, ADFAN should establish and implement internal control procedures that include formal review process to verify the accuracy and completeness of the reported information and designate responsible personnel for the review and approval of reports prior to submission to ensure compliance with Federal reporting requirements.
FINDING REFERENCE NUMBER 2023-054 (See Finding Reference Number 2023-023) FEDERAL PROGRAMS (ALN – 93.556) MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.667) SOCIAL SERVICES BLOCK GRANT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2101PRFPSS (Federal Award Years: 2021 through 2022) 2211PRSOSR (Federal Award Years: 2021 through 2022) ADMINISTRATION ADMINISTRATION FOR FAMILIES AND CHILDREN (ADFAN, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA Uniform Guidance at 2 CFR § 200.302 (a) establishes that each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. See § 200.450. In addition, the SF-425 Federal Financial Report requires the reporting of financial activities related to Federal awards. The accounting basis used for reporting expenditures (whether cash or accrual) must align with the accounting system employed by the recipient organization. The 2 CFR § 200.302 (b), establish that the recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (6) written procedures to implement the requirements of § 200.305 and (7) written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. The 2 CFR section 200.328(c) establishes that the recipient or subrecipient must submit financial reports as required by the Federal award. Reports submitted annually by the recipient or subrecipient must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. The 2 CFR §200.303 (a) establishes that the recipient and subrecipient must: establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should align with the guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control-Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). STATEMENT OF CONDITION As part of our audit procedures over internal controls and compliance for reporting requirements, we selected the Grants Awards 2101PRFPSS and 2111PRSOSR, which closes in the audit period from July 2022 to June 2023, to validate the recorded amounts. Upon evaluating the report for the Grant Award 2101PRFPSS, we found the following deficiencies: (1) The total Federal expenditure reported on line (e) does not match the database provided by the PRDF. (2) The matching expenditure on line (j) does not match the database provided by the PRDF, and (3) The report was not submitted within the established deadline, and an extension was granted to settle and report the funds until March 31, 2023, and they submitted on August 10, 2023. For both Grants Awards we found the following deficiencies: (4) The accounting basis should be Cash Basis instead of Accrual Basis, according to the accounting system used. Additionally, they provided a Procedures Manual for the Finance and Budget Divisions, approved in 2009 and delivered in Word format, which states that the accounting basis is “accrual”, even though their current system operates on a cash basis. (5) During the internal control’s interviews, we found that there is no designated person responsible for reviewing the information entered by the preparer. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This deficiency is a systemic problem. Procedures and internal controls manuals should provide for and ensure the segregation of duties, training, and the reconciliation of financial information reported to Federal agencies against the accounting records used to prepare financial statement and SEFA. STATEMENT OF CAUSE ADFAN does not have internal controls to effectively review the process and comply with the reporting requirements. The absence of effective internal controls at ADFAN to review processes and ensure compliance with reporting requirements can be attributed to inadequate organizational structure and insufficiently defined roles and responsibilities. There is no designated individual or team responsible for overseeing the accuracy and completeness of financial data entered reports. As mentioned above in the statement of condition, this responsibility falls under one person and does not have segregation of duties. This gap in accountability stems from a lack of internal review and insufficient oversight mechanisms, which restrains the organization's ability to ensure that reports are fully aligned with the required compliance standards. Additionally, there is a lack of training or resources dedicated to maintaining and monitoring compliance which contributes to the failure in reporting requirements. POSSIBLE ASSERTED EFFECT ADFAN does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports for the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend that ADFAN ensures the SF– 425 is completed using the appropriate accounting basis consistent with the organization’s financial system. Additionally, ADFAN should establish and implement internal control procedures that include formal review process to verify the accuracy and completeness of the reported information and designate responsible personnel for the review and approval of reports prior to submission to ensure compliance with Federal reporting requirements.
FINDING REFERENCE NUMBER 2023-056 (See Finding Reference Number 2023-025) FEDERAL PROGRAMS (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2021G996117; 2022G996117; 2023996117 (Federal Award Years: 2021 through 2023) 2022G9922PT; 2301PRTABD (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING – FINANCIAL TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA The 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. See § 200.450. (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. … (6) Written procedures to implement the requirements of § 200.305 and (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION As part of our audit procedures over the reporting requirement for TANF and Payment to Territories – Adult programs, we selected two reports submitted during our fiscal year. We found the following deficiencies: i. Administrative expenditures related to both programs are recorded under the same accounting account number, and the assistance listing number of TANF. That is, in PRIFAS, the administrative expenditures of both programs are not segregated by grant award and assistance listing number. ii. The ACF-196TR reports report expenditures under both programs that are not reconciled with the PRIFAS accounting system, specifically in administrative expenditures. We requested evidence of the expenditures incurred or details that were used to prepare the reports; this information was not available, and it was generated upon our request. iii. In both reports evaluated, the amounts reported on lines 2 and 3, related to the amounts that the TANF program transfers to two other federal programs, are recorded inconsistently. During the quarters from October to June, these lines report the amount of the budget that is allowed to be transferred, without validating whether the Federal programs incurred any expenditures. In the quarterly report of September, the expenditure for these lines is reported based on the amount of drawdowns incurred. This practice is inconsistent and does not reflect the actual expenditure incurred. iv. In the quarterly report of June 2023, an expenditure of $3,733,668 was reported on line 5(a). According to PRIFAS, the reported expenditure was $1,988,000. QUESTIONED COSTS Undetermined. PERSPECTIVE INFORMATION This is a systematic deficiency. Procedures and internal controls manuals should provide for and ensure the segregation of duties, and the reconciliation of financial information reported to federal agencies against the accounting records used to prepare financial statements and SEFA. In addition, the financial management system should provide to account separately the administrative expenditures incurred among all Federal programs administered. ADSEF failure to support reported amounts with verifiable documentation and the absence of independent review increases the risk of inaccurate or misstated financial data being reported to the federal awarding agency. STATEMENT OF CAUSE During our interviews and understanding of the internal controls over financial reporting, we noted that only one person prepares, submits and certifies the ACF-196TR reports. No proper segregation of duties exists, that allows for validation of all accounting data before submitting the reports. In addition, the procedures manual for preparing reports does not establish a clear process for obtaining information, validating it, recording it, preparing it, and reporting it, as well as the responsibilities and segregation of duties to ensure that the reported information is consistent with ADSEF's accounting records. PRIFAS accounting data base as configured, does not provide for the administrative expenditures incurred from the TANF and Payment to Territories – Adult program to be segregated. ADSEF lacks internal controls that allow for the timely validation and reconciliation of financial information. Furthermore, they lack a written procedures manual detailing the processes to follow in obtaining accounting data and reporting it to the federal government, ensuring that the responsibility does not fall on a single individual. POSSIBLE ASSERTED EFFECT ADSEF does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports to the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend ADSEF to establish written procedures and internal controls manuals to provide and document the segregation of duties related to the reporting compliance requirement. Additionally, work with the Puerto Rico Department of the Treasury to provide accounting records to segregate the administrative expenditures of both programs.