Audit 34655

FY End
2022-06-30
Total Expended
$1.46M
Findings
4
Programs
4
Organization: Village of Tijeras (NM)
Year: 2022 Accepted: 2023-05-22

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
39584 2022-005 Material Weakness - G
39585 2022-006 Significant Deficiency - L
616026 2022-005 Material Weakness - G
616027 2022-006 Significant Deficiency - L

Contacts

Name Title Type
U16GQL26VFW1 Audrey Caufield Auditee
5052811220 Scott Eliason Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) include the federal award activity of the Village of Tijeras (the Village) under programs of the federal government for the year ended June 30, 2022. The information in this Schedule is presented in accordance with the requirements of the Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Village, it is not intended to and does not present the financial position or changes in financial position of the Village. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, where in certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

2022-005 WATERSMART GRANT - MATCHING Federal Program Information Funding agency: U.S. Department of Interior, Bureau of Reclamation Title: Reclamation States Emergency Drought Relief ALN: 15.514 Award Year: 2021 Questioned Costs: None Type of Finding: Material Weakness, Material Non-Compliance Condition The grant agreement contained a cost-sharing requirement that the $748,980 Federal share not be expended in advance of the Village?s $825,920 non-Federal share of allowable costs. It was expected that expenditure of Federal and non-Federal funds, based upon estimated cost share percentages, would occur concurrently. The Village was entitled to be reimbursed for costs incurred after July 1, 2020, but prior to the date of the agreement. The Village incurred $248,174 in such pre-award costs and other non-Federal share costs concurrent with the Federal share during fiscal year 2022. However, the entire Federal share of $748,980 was incurred and drawn down during fiscal year 2022, in violation of the above cost-sharing requirement. The Village has been awarded two grants for Special Appropriation Program funds from the New Mexico Environment Department, which are sufficient to meet the matching requirements, and have obligated all such funding to the grant project. Construction related to these funds has experienced delays and is still ongoing after fiscal year 2022 year-end and the end of the period of performance. Project closeout for these grants are expected to be completed soon, within the next quarter based on provided milestones. Criteria The Federal government may require the recipient to provide contributions to cover a portion of that program?s operations, and may stipulate in the grant agreement if this should be required to be performed proportionately throughout the grant period. A system of internal control needs to provide reasonable assurance that objectives of internal control over compliance requirements relating to compliance with the terms and conditions of Federal awards will be achieved. Effect The Village is not in compliance with federal grant matching requirements. As matching funds have only been obligated but not necessarily expended, it is possible that matching requirements may not ultimately be met at the end of the project, in which case a portion of federal funding may need to be returned. Cause Due to turnover within the Village?s finance department, the Village was unaware of the grant requirements. The Village lacks controls over compliance in this area.
2022-006 WATERSMART GRANT - REPORTING Federal Program Information Funding agency: U.S. Department of Interior, Bureau of Reclamation Title: Reclamation States Emergency Drought Relief ALN: 15.514 Award Year: 2021 Questioned Costs: None Type of Finding: Significant Deficiency, Other Non-Compliance Condition We noted the Village is not in compliance with requirements related to the reporting of grants. During our test work, we noted the following exceptions: ? The Village did not complete the recipient share section of the federal financial reports for 1 of 2 reports tested. ? The Village did not submit semi-annual performance progress reports (PPRs) timely for 1 of the 2 reports tested. Criteria According to ?200.302 Financial management of 2 CFR Part 200, the state?s and the other non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Effect The Village is not in compliance with federal reporting requirements. Cause The Village lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete.
2022-005 WATERSMART GRANT - MATCHING Federal Program Information Funding agency: U.S. Department of Interior, Bureau of Reclamation Title: Reclamation States Emergency Drought Relief ALN: 15.514 Award Year: 2021 Questioned Costs: None Type of Finding: Material Weakness, Material Non-Compliance Condition The grant agreement contained a cost-sharing requirement that the $748,980 Federal share not be expended in advance of the Village?s $825,920 non-Federal share of allowable costs. It was expected that expenditure of Federal and non-Federal funds, based upon estimated cost share percentages, would occur concurrently. The Village was entitled to be reimbursed for costs incurred after July 1, 2020, but prior to the date of the agreement. The Village incurred $248,174 in such pre-award costs and other non-Federal share costs concurrent with the Federal share during fiscal year 2022. However, the entire Federal share of $748,980 was incurred and drawn down during fiscal year 2022, in violation of the above cost-sharing requirement. The Village has been awarded two grants for Special Appropriation Program funds from the New Mexico Environment Department, which are sufficient to meet the matching requirements, and have obligated all such funding to the grant project. Construction related to these funds has experienced delays and is still ongoing after fiscal year 2022 year-end and the end of the period of performance. Project closeout for these grants are expected to be completed soon, within the next quarter based on provided milestones. Criteria The Federal government may require the recipient to provide contributions to cover a portion of that program?s operations, and may stipulate in the grant agreement if this should be required to be performed proportionately throughout the grant period. A system of internal control needs to provide reasonable assurance that objectives of internal control over compliance requirements relating to compliance with the terms and conditions of Federal awards will be achieved. Effect The Village is not in compliance with federal grant matching requirements. As matching funds have only been obligated but not necessarily expended, it is possible that matching requirements may not ultimately be met at the end of the project, in which case a portion of federal funding may need to be returned. Cause Due to turnover within the Village?s finance department, the Village was unaware of the grant requirements. The Village lacks controls over compliance in this area.
2022-006 WATERSMART GRANT - REPORTING Federal Program Information Funding agency: U.S. Department of Interior, Bureau of Reclamation Title: Reclamation States Emergency Drought Relief ALN: 15.514 Award Year: 2021 Questioned Costs: None Type of Finding: Significant Deficiency, Other Non-Compliance Condition We noted the Village is not in compliance with requirements related to the reporting of grants. During our test work, we noted the following exceptions: ? The Village did not complete the recipient share section of the federal financial reports for 1 of 2 reports tested. ? The Village did not submit semi-annual performance progress reports (PPRs) timely for 1 of the 2 reports tested. Criteria According to ?200.302 Financial management of 2 CFR Part 200, the state?s and the other non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Effect The Village is not in compliance with federal reporting requirements. Cause The Village lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete.