Audit 16633

FY End
2022-06-30
Total Expended
$19.64M
Findings
10
Programs
17
Organization: Municipality of Aguadilla (PR)
Year: 2022 Accepted: 2023-08-22

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
12289 2022-001 Significant Deficiency Yes L
12290 2022-002 Significant Deficiency - L
12291 2022-002 Significant Deficiency - L
12292 2022-002 Significant Deficiency - L
12293 2022-002 Significant Deficiency - L
588731 2022-001 Significant Deficiency Yes L
588732 2022-002 Significant Deficiency - L
588733 2022-002 Significant Deficiency - L
588734 2022-002 Significant Deficiency - L
588735 2022-002 Significant Deficiency - L

Contacts

Name Title Type
FF4AZC42APP5 Betzaida Hernandez Auditee
7878911005 Mario Betancourt Pagan Auditor
No contacts on file

Notes to SEFA

Title: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Accounting Policies: BASIS OF PRESENTATION The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activities of the Autonomous Municipality of Aguadilla of the Commonwealth of Puerto Rico (Municipality) under programs of the Federal government for the fiscal year ended June 30, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Municipality, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Municipality. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The Municipality reporting entity is defined in Note (1) (A) to the basic financial statements. All federal financial awards received directly from federal agency as well as federal financial awards passed through other government agencies are included on the Schedule. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. A.Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in OMB Circular A-87, Cost Principles for State and Local Government or those contained in the Uniform Guidance, as applicable, wherein certain types of expenditures are not allowable or are limited as to reimbursement. B.Negative amounts, if any, shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. C.Pass-through entity identifying numbers are presented where available. D.The Municipality has not elected to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance.
Title: SCHEDULE NOT IN AGREEMENT WITH OTHER FEDERAL AWARD REPORTING Accounting Policies: BASIS OF PRESENTATION The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activities of the Autonomous Municipality of Aguadilla of the Commonwealth of Puerto Rico (Municipality) under programs of the Federal government for the fiscal year ended June 30, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Municipality, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Municipality. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The Municipality reporting entity is defined in Note (1) (A) to the basic financial statements. All federal financial awards received directly from federal agency as well as federal financial awards passed through other government agencies are included on the Schedule. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The information included in the Schedule may not fully agree with other federal award reports submitted directly to federal granting agencies.
Title: ASSISTANCE LISTING NUMBER Accounting Policies: BASIS OF PRESENTATION The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activities of the Autonomous Municipality of Aguadilla of the Commonwealth of Puerto Rico (Municipality) under programs of the Federal government for the fiscal year ended June 30, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Municipality, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Municipality. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The Municipality reporting entity is defined in Note (1) (A) to the basic financial statements. All federal financial awards received directly from federal agency as well as federal financial awards passed through other government agencies are included on the Schedule. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The ALN, Assistance listing numbers included in this Schedule are determined based on the program name, review of grant contract information and the Office of Management and Budget's Catalogue of Federal Domestic Assistance.
Title: RELATIONSHIP TO THE FINANCIAL STATEMENTS Accounting Policies: BASIS OF PRESENTATION The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activities of the Autonomous Municipality of Aguadilla of the Commonwealth of Puerto Rico (Municipality) under programs of the Federal government for the fiscal year ended June 30, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Municipality, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Municipality. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The Municipality reporting entity is defined in Note (1) (A) to the basic financial statements. All federal financial awards received directly from federal agency as well as federal financial awards passed through other government agencies are included on the Schedule. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Expenditures of federal awards are reported in the Municipalitys Statement of Revenues, Expenditures and Changes in Fund Balances Governmental Funds as follows: Head Start Fund $5,455,314, American Rescue Plan Act $9,127,309 and Other Governmental Funds (Including Transfer Out) $5,059,037.
Title: OUTSTANDING LOANS OF FEDERAL FUNDS Accounting Policies: BASIS OF PRESENTATION The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activities of the Autonomous Municipality of Aguadilla of the Commonwealth of Puerto Rico (Municipality) under programs of the Federal government for the fiscal year ended June 30, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Municipality, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Municipality. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The Municipality reporting entity is defined in Note (1) (A) to the basic financial statements. All federal financial awards received directly from federal agency as well as federal financial awards passed through other government agencies are included on the Schedule. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Federal funded loans provided under these programs are included as expenditure on the Schedule of Expenditure of Federal Awards. Per Uniform Guidance, loans proceed that were received and expended in prior years are not considered federal awards expended (and thus not shown on the Schedule of Expenditures of Federal Awards) as those loans do not include continuing compliance requirements other than repayment of the loans. The Municipality is required to identify in the notes to the Schedule of Expenditures of Federal Awards the balances outstanding at the end of the period. On June 30, 2022, there are not outstanding Loans for Federal Funds.
Title: GENERALLY ACCEPTED GOVERNMENTAL AUDIT STANDARD (GAGAS 2018 REVISION) Accounting Policies: BASIS OF PRESENTATION The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activities of the Autonomous Municipality of Aguadilla of the Commonwealth of Puerto Rico (Municipality) under programs of the Federal government for the fiscal year ended June 30, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Municipality, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Municipality. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The Municipality reporting entity is defined in Note (1) (A) to the basic financial statements. All federal financial awards received directly from federal agency as well as federal financial awards passed through other government agencies are included on the Schedule. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The Yellow Book is used by auditors of government entities, entities that receive government awards, and other audit organizations performing Yellow Book audits. It outlines the requirements for audit reports, professional qualifications for auditors, and audit organization quality control. Auditors of federal, state, and local government programs use these standards to perform their audits and produce their reports.

Finding Details

Condition: The Municipality did not submit the June 30, 2022, fiscal year end GAAP-based unaudited financial information electronically to HUD. Context: The Municipality was required to submit to HUD unaudited financial information for the June 30, 2022, fiscal year end by August 30, 2022. The Municipality did not submit the June 30, 2022, unaudited financial information to HUD on or before August 30, 2022. Criteria: The Uniform Financial Reporting Standards (24 CFR section 5.801) require PHAs to submit timely GAAP-based unaudited financial information electronically to HUD. Unaudited financial statements are required 60 days after the PHA?s fiscal year end. The responsibility for the submission of the financial report due to HUD under this section rests with the PHA. Financial reporting requirements (24 CFR section 902.33) require PHAs to submit their unaudited financial data to HUD on an annual basis. The financial information must be prepared in accordance with Generally Accepted Accounting Principles (GAAP), as further defined by HUD in supplementary guidance and submitted electronically in the format prescribed by HUD using the Financial Data Schedule (FDS). The unaudited financial information must be submitted to HUD annually, no later than 2 months after the PHA?s fiscal year end. Cause: Although the Municipality was aware of the reporting requirement, management was not able to compile the necessary information for the electronic submission within the 60 days? timeframe. Effect: As per 24 CFR 902.62 if a PHA, without a finding of good cause by HUD, submits its unaudited year-end financial information more than 15 days past the due date, appropriate sanctions may be imposed, including a reduction of one point in the total PHAs score for each 15-day period past the due date. If the unaudited year-end financial information is not received within 3 months past the due date, or extended due date, the PHA will receive a presumptive rating of failure for its unaudited information and shall receive zero points for its unaudited financial information and the final financial condition indicator score. The subsequent timely submission of audited information does not negate the score of zero received for the unaudited year-end financial information submission. If a PHA does not submit its unaudited information, it will receive a zero for management operations. Auditor?s Recommendation: The Municipality should implement internal controls and procedures to ensure they submit unaudited financial information to HUD by the due date to minimize penalties and the reduction of points on program performance. The Municipality should train program employees to complete this required report.
Condition The Municipality did not submit the single audit report and reporting package for the year ended June 30, 2022, to the Federal Audit Clearinghouse during the required submission deadline period.Context: The Municipality was required to submit The Single Audit Report on or before March 31, 2023 (on or before 9 months after closing period). Criteria Title 2, Subtitle A, Chapter II, Part 200 named ?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards? Subpart F- Audit Requirements, under 200.512 ?Report Submission? states that the audit shall be completed and the Data Collection Form described in paragraph (b) of this section and reporting package described in paragraph (c) of this section shall be submitted to the Federal Clearinghouse designated by OMB within the earlier of 30 calendar days after receipt of the auditor's reports, or nine months after the end of the audit period. Cause Financial information contained in the Governmental-Wide and Governmental Funds Financial Statements was not available to comply with the March 31, 2023, deadline. Effect The Municipality may be subject to additional compliance requirements imposed by the federal government such as the preparation and monitoring of a detailed audit submission schedule when requesting new loans or grant awards. Questioned Costs None Identification of a repeat finding None Recommendation: We recommend that the Municipality should start the process of compiling and preparing the financial information to complete the Governmental-Wide and Governmental Funds Financial Statements and the Schedule of Expenditures of Federal Awards with enough time to assure that such information is available for the audit process, before March 31, and to provide it with enough time so the audit process can be completed before such due date.
Condition The Municipality did not submit the single audit report and reporting package for the year ended June 30, 2022, to the Federal Audit Clearinghouse during the required submission deadline period.Context: The Municipality was required to submit The Single Audit Report on or before March 31, 2023 (on or before 9 months after closing period). Criteria Title 2, Subtitle A, Chapter II, Part 200 named ?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards? Subpart F- Audit Requirements, under 200.512 ?Report Submission? states that the audit shall be completed and the Data Collection Form described in paragraph (b) of this section and reporting package described in paragraph (c) of this section shall be submitted to the Federal Clearinghouse designated by OMB within the earlier of 30 calendar days after receipt of the auditor's reports, or nine months after the end of the audit period. Cause Financial information contained in the Governmental-Wide and Governmental Funds Financial Statements was not available to comply with the March 31, 2023, deadline. Effect The Municipality may be subject to additional compliance requirements imposed by the federal government such as the preparation and monitoring of a detailed audit submission schedule when requesting new loans or grant awards. Questioned Costs None Identification of a repeat finding None Recommendation: We recommend that the Municipality should start the process of compiling and preparing the financial information to complete the Governmental-Wide and Governmental Funds Financial Statements and the Schedule of Expenditures of Federal Awards with enough time to assure that such information is available for the audit process, before March 31, and to provide it with enough time so the audit process can be completed before such due date.
Condition The Municipality did not submit the single audit report and reporting package for the year ended June 30, 2022, to the Federal Audit Clearinghouse during the required submission deadline period.Context: The Municipality was required to submit The Single Audit Report on or before March 31, 2023 (on or before 9 months after closing period). Criteria Title 2, Subtitle A, Chapter II, Part 200 named ?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards? Subpart F- Audit Requirements, under 200.512 ?Report Submission? states that the audit shall be completed and the Data Collection Form described in paragraph (b) of this section and reporting package described in paragraph (c) of this section shall be submitted to the Federal Clearinghouse designated by OMB within the earlier of 30 calendar days after receipt of the auditor's reports, or nine months after the end of the audit period. Cause Financial information contained in the Governmental-Wide and Governmental Funds Financial Statements was not available to comply with the March 31, 2023, deadline. Effect The Municipality may be subject to additional compliance requirements imposed by the federal government such as the preparation and monitoring of a detailed audit submission schedule when requesting new loans or grant awards. Questioned Costs None Identification of a repeat finding None Recommendation: We recommend that the Municipality should start the process of compiling and preparing the financial information to complete the Governmental-Wide and Governmental Funds Financial Statements and the Schedule of Expenditures of Federal Awards with enough time to assure that such information is available for the audit process, before March 31, and to provide it with enough time so the audit process can be completed before such due date.
Condition The Municipality did not submit the single audit report and reporting package for the year ended June 30, 2022, to the Federal Audit Clearinghouse during the required submission deadline period.Context: The Municipality was required to submit The Single Audit Report on or before March 31, 2023 (on or before 9 months after closing period). Criteria Title 2, Subtitle A, Chapter II, Part 200 named ?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards? Subpart F- Audit Requirements, under 200.512 ?Report Submission? states that the audit shall be completed and the Data Collection Form described in paragraph (b) of this section and reporting package described in paragraph (c) of this section shall be submitted to the Federal Clearinghouse designated by OMB within the earlier of 30 calendar days after receipt of the auditor's reports, or nine months after the end of the audit period. Cause Financial information contained in the Governmental-Wide and Governmental Funds Financial Statements was not available to comply with the March 31, 2023, deadline. Effect The Municipality may be subject to additional compliance requirements imposed by the federal government such as the preparation and monitoring of a detailed audit submission schedule when requesting new loans or grant awards. Questioned Costs None Identification of a repeat finding None Recommendation: We recommend that the Municipality should start the process of compiling and preparing the financial information to complete the Governmental-Wide and Governmental Funds Financial Statements and the Schedule of Expenditures of Federal Awards with enough time to assure that such information is available for the audit process, before March 31, and to provide it with enough time so the audit process can be completed before such due date.
Condition: The Municipality did not submit the June 30, 2022, fiscal year end GAAP-based unaudited financial information electronically to HUD. Context: The Municipality was required to submit to HUD unaudited financial information for the June 30, 2022, fiscal year end by August 30, 2022. The Municipality did not submit the June 30, 2022, unaudited financial information to HUD on or before August 30, 2022. Criteria: The Uniform Financial Reporting Standards (24 CFR section 5.801) require PHAs to submit timely GAAP-based unaudited financial information electronically to HUD. Unaudited financial statements are required 60 days after the PHA?s fiscal year end. The responsibility for the submission of the financial report due to HUD under this section rests with the PHA. Financial reporting requirements (24 CFR section 902.33) require PHAs to submit their unaudited financial data to HUD on an annual basis. The financial information must be prepared in accordance with Generally Accepted Accounting Principles (GAAP), as further defined by HUD in supplementary guidance and submitted electronically in the format prescribed by HUD using the Financial Data Schedule (FDS). The unaudited financial information must be submitted to HUD annually, no later than 2 months after the PHA?s fiscal year end. Cause: Although the Municipality was aware of the reporting requirement, management was not able to compile the necessary information for the electronic submission within the 60 days? timeframe. Effect: As per 24 CFR 902.62 if a PHA, without a finding of good cause by HUD, submits its unaudited year-end financial information more than 15 days past the due date, appropriate sanctions may be imposed, including a reduction of one point in the total PHAs score for each 15-day period past the due date. If the unaudited year-end financial information is not received within 3 months past the due date, or extended due date, the PHA will receive a presumptive rating of failure for its unaudited information and shall receive zero points for its unaudited financial information and the final financial condition indicator score. The subsequent timely submission of audited information does not negate the score of zero received for the unaudited year-end financial information submission. If a PHA does not submit its unaudited information, it will receive a zero for management operations. Auditor?s Recommendation: The Municipality should implement internal controls and procedures to ensure they submit unaudited financial information to HUD by the due date to minimize penalties and the reduction of points on program performance. The Municipality should train program employees to complete this required report.
Condition The Municipality did not submit the single audit report and reporting package for the year ended June 30, 2022, to the Federal Audit Clearinghouse during the required submission deadline period.Context: The Municipality was required to submit The Single Audit Report on or before March 31, 2023 (on or before 9 months after closing period). Criteria Title 2, Subtitle A, Chapter II, Part 200 named ?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards? Subpart F- Audit Requirements, under 200.512 ?Report Submission? states that the audit shall be completed and the Data Collection Form described in paragraph (b) of this section and reporting package described in paragraph (c) of this section shall be submitted to the Federal Clearinghouse designated by OMB within the earlier of 30 calendar days after receipt of the auditor's reports, or nine months after the end of the audit period. Cause Financial information contained in the Governmental-Wide and Governmental Funds Financial Statements was not available to comply with the March 31, 2023, deadline. Effect The Municipality may be subject to additional compliance requirements imposed by the federal government such as the preparation and monitoring of a detailed audit submission schedule when requesting new loans or grant awards. Questioned Costs None Identification of a repeat finding None Recommendation: We recommend that the Municipality should start the process of compiling and preparing the financial information to complete the Governmental-Wide and Governmental Funds Financial Statements and the Schedule of Expenditures of Federal Awards with enough time to assure that such information is available for the audit process, before March 31, and to provide it with enough time so the audit process can be completed before such due date.
Condition The Municipality did not submit the single audit report and reporting package for the year ended June 30, 2022, to the Federal Audit Clearinghouse during the required submission deadline period.Context: The Municipality was required to submit The Single Audit Report on or before March 31, 2023 (on or before 9 months after closing period). Criteria Title 2, Subtitle A, Chapter II, Part 200 named ?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards? Subpart F- Audit Requirements, under 200.512 ?Report Submission? states that the audit shall be completed and the Data Collection Form described in paragraph (b) of this section and reporting package described in paragraph (c) of this section shall be submitted to the Federal Clearinghouse designated by OMB within the earlier of 30 calendar days after receipt of the auditor's reports, or nine months after the end of the audit period. Cause Financial information contained in the Governmental-Wide and Governmental Funds Financial Statements was not available to comply with the March 31, 2023, deadline. Effect The Municipality may be subject to additional compliance requirements imposed by the federal government such as the preparation and monitoring of a detailed audit submission schedule when requesting new loans or grant awards. Questioned Costs None Identification of a repeat finding None Recommendation: We recommend that the Municipality should start the process of compiling and preparing the financial information to complete the Governmental-Wide and Governmental Funds Financial Statements and the Schedule of Expenditures of Federal Awards with enough time to assure that such information is available for the audit process, before March 31, and to provide it with enough time so the audit process can be completed before such due date.
Condition The Municipality did not submit the single audit report and reporting package for the year ended June 30, 2022, to the Federal Audit Clearinghouse during the required submission deadline period.Context: The Municipality was required to submit The Single Audit Report on or before March 31, 2023 (on or before 9 months after closing period). Criteria Title 2, Subtitle A, Chapter II, Part 200 named ?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards? Subpart F- Audit Requirements, under 200.512 ?Report Submission? states that the audit shall be completed and the Data Collection Form described in paragraph (b) of this section and reporting package described in paragraph (c) of this section shall be submitted to the Federal Clearinghouse designated by OMB within the earlier of 30 calendar days after receipt of the auditor's reports, or nine months after the end of the audit period. Cause Financial information contained in the Governmental-Wide and Governmental Funds Financial Statements was not available to comply with the March 31, 2023, deadline. Effect The Municipality may be subject to additional compliance requirements imposed by the federal government such as the preparation and monitoring of a detailed audit submission schedule when requesting new loans or grant awards. Questioned Costs None Identification of a repeat finding None Recommendation: We recommend that the Municipality should start the process of compiling and preparing the financial information to complete the Governmental-Wide and Governmental Funds Financial Statements and the Schedule of Expenditures of Federal Awards with enough time to assure that such information is available for the audit process, before March 31, and to provide it with enough time so the audit process can be completed before such due date.
Condition The Municipality did not submit the single audit report and reporting package for the year ended June 30, 2022, to the Federal Audit Clearinghouse during the required submission deadline period.Context: The Municipality was required to submit The Single Audit Report on or before March 31, 2023 (on or before 9 months after closing period). Criteria Title 2, Subtitle A, Chapter II, Part 200 named ?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards? Subpart F- Audit Requirements, under 200.512 ?Report Submission? states that the audit shall be completed and the Data Collection Form described in paragraph (b) of this section and reporting package described in paragraph (c) of this section shall be submitted to the Federal Clearinghouse designated by OMB within the earlier of 30 calendar days after receipt of the auditor's reports, or nine months after the end of the audit period. Cause Financial information contained in the Governmental-Wide and Governmental Funds Financial Statements was not available to comply with the March 31, 2023, deadline. Effect The Municipality may be subject to additional compliance requirements imposed by the federal government such as the preparation and monitoring of a detailed audit submission schedule when requesting new loans or grant awards. Questioned Costs None Identification of a repeat finding None Recommendation: We recommend that the Municipality should start the process of compiling and preparing the financial information to complete the Governmental-Wide and Governmental Funds Financial Statements and the Schedule of Expenditures of Federal Awards with enough time to assure that such information is available for the audit process, before March 31, and to provide it with enough time so the audit process can be completed before such due date.