Audit 14498

FY End
2022-06-30
Total Expended
$3.21M
Findings
14
Programs
21
Organization: City of Santa Fe (NM)
Year: 2022 Accepted: 2024-01-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
10837 2022-006 Material Weakness Yes GL
10838 2022-007 Material Weakness - AB
10839 2022-006 Material Weakness Yes GL
10840 2022-007 Material Weakness - AB
10841 2022-006 Material Weakness Yes GL
10842 2022-007 Material Weakness - AB
10843 2022-008 Significant Deficiency - L
587279 2022-006 Material Weakness Yes GL
587280 2022-007 Material Weakness - AB
587281 2022-006 Material Weakness Yes GL
587282 2022-007 Material Weakness - AB
587283 2022-006 Material Weakness Yes GL
587284 2022-007 Material Weakness - AB
587285 2022-008 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
20.106 Airport Improvement Program #52 $649,362 Yes 2
97.067 Homeland Security Grant Program $398,798 Yes 1
20.106 Airport Improvement Program #54 $392,629 Yes 2
14.218 Community Development Block Grants/entitlement Grants $299,484 - 0
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $267,514 - 0
20.106 Airport Improvement Program #53 $211,845 Yes 2
20.205 Highway Planning and Construction $176,895 - 0
93.053 Nutrition Services Incentive Program $109,484 - 0
93.045 Special Programs for the Aging_title Iii, Part C-1, Nutrition Services $96,279 - 0
93.788 Opioid Str $81,133 - 0
10.693 Watershed Restoration and Enhancement Agreement Authority $75,066 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $74,432 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $69,171 - 0
66.458 Capitalization Grants for Clean Water State Revolving Funds $62,936 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $50,749 - 0
20.507 Federal Transit_formula Grants $45,230 - 0
94.002 Retired and Senior Volunteer Program $37,587 - 0
93.045 Special Programs for the Aging_title Iii, Part C-2, Nutrition Services $32,418 - 0
94.011 Foster Grandparent Program $32,326 - 0
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $27,963 - 0
45.024 Promotion of the Arts_grants to Organizations and Individuals $15,000 - 0

Contacts

Name Title Type
QLN2YKMMJ8X6 Emily Oster Auditee
5059556171 Alan D. Bowers, Jr. Auditor
No contacts on file

Notes to SEFA

Title: Loans Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal grant activity of the City of Santa Fe. (The "City") and is presented on the modified accrual basis of accounting, which is the same basis as was used to prepare the fund financial statements. The information in this Schedule is presented in accordance with the requirements of Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, our used in the preparation of, the financial statements. De Minimis Rate Used: N Rate Explanation: The City did not elect to use the allowed 10% indirect cost rate. The City did not expend federal awards related to loans or loan guarantees during the year.
Title: Federally Funded Insurance Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal grant activity of the City of Santa Fe. (The "City") and is presented on the modified accrual basis of accounting, which is the same basis as was used to prepare the fund financial statements. The information in this Schedule is presented in accordance with the requirements of Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, our used in the preparation of, the financial statements. De Minimis Rate Used: N Rate Explanation: The City did not elect to use the allowed 10% indirect cost rate. The City has no federally funded insurance.
Title: Reconciliation of Schedule of Expenditures of Federal Awards to Financial Statements Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal grant activity of the City of Santa Fe. (The "City") and is presented on the modified accrual basis of accounting, which is the same basis as was used to prepare the fund financial statements. The information in this Schedule is presented in accordance with the requirements of Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, our used in the preparation of, the financial statements. De Minimis Rate Used: N Rate Explanation: The City did not elect to use the allowed 10% indirect cost rate. See table in report on page 211

Finding Details

2022-006 (originally 2021-009) – Matching and Financial Reporting (Material Weakness in Internal Controls over Compliance) (repeated/modified) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-052-2020; SAF-SWG-3-35-0037-053-2020; SAF-SWG-3-35-0037-054-2021 Federal Award Year: 2020, 2021 Condition: The City submitted 9 financial reports not approved by the Airport Manager and did not provide supporting backup documentation to test accuracy on 3 of the financial reports. Management’s Progress on Repeat Findings: The 2021 audit was completed in June of 2023. As such, the City was unable to take corrective action during fiscal year 2022 that would result in progress towards resolving this finding. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per Title 2 US Code of Federal Regulations Part 200.508(d), the Auditee must provide the auditor with access to books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by grant agreements and part 200.306(b), for all federal awards, any matching funds, must be accepted as part of the non-Federal entities matching when the following criteria is met (1) Are verifiable from the non-Federal entities records. Cause: The City did not have sufficient controls in place to review and approve reports ensuring accuracy of reports to the grantor agency. Questioned Cost: None Effect: Lack of proper review for accuracy of reports can result in improper reporting which could lead to disallowed costs. However, our audit disclosed no instances of unallowable costs.
2022-007 – Activities allowed, Allowable Costs over Non-Payroll (Material Weakness over Internal Controls over Compliance, Other Noncompliance) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-052-2020; SAF-SWG-3-35-0037-053-2020; SAF-SWG-3-35-0037-054-2021 Federal Award Year: 2020, 2021 Condition: During our review of non-payroll related transactions, 14 out of 18 transactions tested did not include appropriate approval by the Airport Manager, 3 out of 18 transactions did not include a date of approval by the Airport Manager, and 1 out of 18 transactions did not include supporting documentation or purchase order information on the GL. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per Title 2 US Code of Federal Regulations Part 200.403g, costs must be adequately documented to be allowable under Federal awards. Cause: The City is not following procedures to ensure the appropriate approvals are being conducted on all purchases or retaining the supporting documentation to ensure purchase is allowable. Questioned Cost: Known and likely questioned costs of $35,021 Effect: The City may unintentionally charge expenses to the program that do not qualify and in turn lead to questioned costs and/or repayment of funds to the Grantor agency.
2022-006 (originally 2021-009) – Matching and Financial Reporting (Material Weakness in Internal Controls over Compliance) (repeated/modified) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-052-2020; SAF-SWG-3-35-0037-053-2020; SAF-SWG-3-35-0037-054-2021 Federal Award Year: 2020, 2021 Condition: The City submitted 9 financial reports not approved by the Airport Manager and did not provide supporting backup documentation to test accuracy on 3 of the financial reports. Management’s Progress on Repeat Findings: The 2021 audit was completed in June of 2023. As such, the City was unable to take corrective action during fiscal year 2022 that would result in progress towards resolving this finding. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per Title 2 US Code of Federal Regulations Part 200.508(d), the Auditee must provide the auditor with access to books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by grant agreements and part 200.306(b), for all federal awards, any matching funds, must be accepted as part of the non-Federal entities matching when the following criteria is met (1) Are verifiable from the non-Federal entities records. Cause: The City did not have sufficient controls in place to review and approve reports ensuring accuracy of reports to the grantor agency. Questioned Cost: None Effect: Lack of proper review for accuracy of reports can result in improper reporting which could lead to disallowed costs. However, our audit disclosed no instances of unallowable costs.
2022-007 – Activities allowed, Allowable Costs over Non-Payroll (Material Weakness over Internal Controls over Compliance, Other Noncompliance) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-052-2020; SAF-SWG-3-35-0037-053-2020; SAF-SWG-3-35-0037-054-2021 Federal Award Year: 2020, 2021 Condition: During our review of non-payroll related transactions, 14 out of 18 transactions tested did not include appropriate approval by the Airport Manager, 3 out of 18 transactions did not include a date of approval by the Airport Manager, and 1 out of 18 transactions did not include supporting documentation or purchase order information on the GL. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per Title 2 US Code of Federal Regulations Part 200.403g, costs must be adequately documented to be allowable under Federal awards. Cause: The City is not following procedures to ensure the appropriate approvals are being conducted on all purchases or retaining the supporting documentation to ensure purchase is allowable. Questioned Cost: Known and likely questioned costs of $35,021 Effect: The City may unintentionally charge expenses to the program that do not qualify and in turn lead to questioned costs and/or repayment of funds to the Grantor agency.
2022-006 (originally 2021-009) – Matching and Financial Reporting (Material Weakness in Internal Controls over Compliance) (repeated/modified) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-052-2020; SAF-SWG-3-35-0037-053-2020; SAF-SWG-3-35-0037-054-2021 Federal Award Year: 2020, 2021 Condition: The City submitted 9 financial reports not approved by the Airport Manager and did not provide supporting backup documentation to test accuracy on 3 of the financial reports. Management’s Progress on Repeat Findings: The 2021 audit was completed in June of 2023. As such, the City was unable to take corrective action during fiscal year 2022 that would result in progress towards resolving this finding. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per Title 2 US Code of Federal Regulations Part 200.508(d), the Auditee must provide the auditor with access to books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by grant agreements and part 200.306(b), for all federal awards, any matching funds, must be accepted as part of the non-Federal entities matching when the following criteria is met (1) Are verifiable from the non-Federal entities records. Cause: The City did not have sufficient controls in place to review and approve reports ensuring accuracy of reports to the grantor agency. Questioned Cost: None Effect: Lack of proper review for accuracy of reports can result in improper reporting which could lead to disallowed costs. However, our audit disclosed no instances of unallowable costs.
2022-007 – Activities allowed, Allowable Costs over Non-Payroll (Material Weakness over Internal Controls over Compliance, Other Noncompliance) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-052-2020; SAF-SWG-3-35-0037-053-2020; SAF-SWG-3-35-0037-054-2021 Federal Award Year: 2020, 2021 Condition: During our review of non-payroll related transactions, 14 out of 18 transactions tested did not include appropriate approval by the Airport Manager, 3 out of 18 transactions did not include a date of approval by the Airport Manager, and 1 out of 18 transactions did not include supporting documentation or purchase order information on the GL. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per Title 2 US Code of Federal Regulations Part 200.403g, costs must be adequately documented to be allowable under Federal awards. Cause: The City is not following procedures to ensure the appropriate approvals are being conducted on all purchases or retaining the supporting documentation to ensure purchase is allowable. Questioned Cost: Known and likely questioned costs of $35,021 Effect: The City may unintentionally charge expenses to the program that do not qualify and in turn lead to questioned costs and/or repayment of funds to the Grantor agency.
2022-008 – Reporting (Significant Deficiency over Internal Controls over Compliance) Federal Program Information Federal Award Title and ALN: Hazard Mitigation Grant Program, 97.067 Federal Awarding Agency: Department of Homeland Security Pass-Through Agency: NM Department of Homeland Security and Emergency Management Federal Award ID Number: EMW-2019-SS-00083-S01-02; EMW-2020-SS-00127-S01-01 Federal Award Year: 2019, 2020 Condition: The City is not submitting financial and performance reports to the pass through entity on a timely basis. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per sub-recipient grant agreements, EMW-2019-SS-00083-S01 and EMW-2020-SS-0127-S01, from the State of New Mexico Department of Homeland Security, the City shall submit quarterly reports by the 30th of the month following the quarter end. Cause: The City did not have sufficient controls in place to ensure the timeliness of reports being submitted to the pass through entity. Questioned Cost: None Effect: Lack of proper review for timeliness of reports can result in improper reporting which could lead to disallowed costs. However, our audit disclosed no instances of unallowable costs.
2022-006 (originally 2021-009) – Matching and Financial Reporting (Material Weakness in Internal Controls over Compliance) (repeated/modified) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-052-2020; SAF-SWG-3-35-0037-053-2020; SAF-SWG-3-35-0037-054-2021 Federal Award Year: 2020, 2021 Condition: The City submitted 9 financial reports not approved by the Airport Manager and did not provide supporting backup documentation to test accuracy on 3 of the financial reports. Management’s Progress on Repeat Findings: The 2021 audit was completed in June of 2023. As such, the City was unable to take corrective action during fiscal year 2022 that would result in progress towards resolving this finding. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per Title 2 US Code of Federal Regulations Part 200.508(d), the Auditee must provide the auditor with access to books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by grant agreements and part 200.306(b), for all federal awards, any matching funds, must be accepted as part of the non-Federal entities matching when the following criteria is met (1) Are verifiable from the non-Federal entities records. Cause: The City did not have sufficient controls in place to review and approve reports ensuring accuracy of reports to the grantor agency. Questioned Cost: None Effect: Lack of proper review for accuracy of reports can result in improper reporting which could lead to disallowed costs. However, our audit disclosed no instances of unallowable costs.
2022-007 – Activities allowed, Allowable Costs over Non-Payroll (Material Weakness over Internal Controls over Compliance, Other Noncompliance) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-052-2020; SAF-SWG-3-35-0037-053-2020; SAF-SWG-3-35-0037-054-2021 Federal Award Year: 2020, 2021 Condition: During our review of non-payroll related transactions, 14 out of 18 transactions tested did not include appropriate approval by the Airport Manager, 3 out of 18 transactions did not include a date of approval by the Airport Manager, and 1 out of 18 transactions did not include supporting documentation or purchase order information on the GL. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per Title 2 US Code of Federal Regulations Part 200.403g, costs must be adequately documented to be allowable under Federal awards. Cause: The City is not following procedures to ensure the appropriate approvals are being conducted on all purchases or retaining the supporting documentation to ensure purchase is allowable. Questioned Cost: Known and likely questioned costs of $35,021 Effect: The City may unintentionally charge expenses to the program that do not qualify and in turn lead to questioned costs and/or repayment of funds to the Grantor agency.
2022-006 (originally 2021-009) – Matching and Financial Reporting (Material Weakness in Internal Controls over Compliance) (repeated/modified) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-052-2020; SAF-SWG-3-35-0037-053-2020; SAF-SWG-3-35-0037-054-2021 Federal Award Year: 2020, 2021 Condition: The City submitted 9 financial reports not approved by the Airport Manager and did not provide supporting backup documentation to test accuracy on 3 of the financial reports. Management’s Progress on Repeat Findings: The 2021 audit was completed in June of 2023. As such, the City was unable to take corrective action during fiscal year 2022 that would result in progress towards resolving this finding. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per Title 2 US Code of Federal Regulations Part 200.508(d), the Auditee must provide the auditor with access to books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by grant agreements and part 200.306(b), for all federal awards, any matching funds, must be accepted as part of the non-Federal entities matching when the following criteria is met (1) Are verifiable from the non-Federal entities records. Cause: The City did not have sufficient controls in place to review and approve reports ensuring accuracy of reports to the grantor agency. Questioned Cost: None Effect: Lack of proper review for accuracy of reports can result in improper reporting which could lead to disallowed costs. However, our audit disclosed no instances of unallowable costs.
2022-007 – Activities allowed, Allowable Costs over Non-Payroll (Material Weakness over Internal Controls over Compliance, Other Noncompliance) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-052-2020; SAF-SWG-3-35-0037-053-2020; SAF-SWG-3-35-0037-054-2021 Federal Award Year: 2020, 2021 Condition: During our review of non-payroll related transactions, 14 out of 18 transactions tested did not include appropriate approval by the Airport Manager, 3 out of 18 transactions did not include a date of approval by the Airport Manager, and 1 out of 18 transactions did not include supporting documentation or purchase order information on the GL. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per Title 2 US Code of Federal Regulations Part 200.403g, costs must be adequately documented to be allowable under Federal awards. Cause: The City is not following procedures to ensure the appropriate approvals are being conducted on all purchases or retaining the supporting documentation to ensure purchase is allowable. Questioned Cost: Known and likely questioned costs of $35,021 Effect: The City may unintentionally charge expenses to the program that do not qualify and in turn lead to questioned costs and/or repayment of funds to the Grantor agency.
2022-006 (originally 2021-009) – Matching and Financial Reporting (Material Weakness in Internal Controls over Compliance) (repeated/modified) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-052-2020; SAF-SWG-3-35-0037-053-2020; SAF-SWG-3-35-0037-054-2021 Federal Award Year: 2020, 2021 Condition: The City submitted 9 financial reports not approved by the Airport Manager and did not provide supporting backup documentation to test accuracy on 3 of the financial reports. Management’s Progress on Repeat Findings: The 2021 audit was completed in June of 2023. As such, the City was unable to take corrective action during fiscal year 2022 that would result in progress towards resolving this finding. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per Title 2 US Code of Federal Regulations Part 200.508(d), the Auditee must provide the auditor with access to books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by grant agreements and part 200.306(b), for all federal awards, any matching funds, must be accepted as part of the non-Federal entities matching when the following criteria is met (1) Are verifiable from the non-Federal entities records. Cause: The City did not have sufficient controls in place to review and approve reports ensuring accuracy of reports to the grantor agency. Questioned Cost: None Effect: Lack of proper review for accuracy of reports can result in improper reporting which could lead to disallowed costs. However, our audit disclosed no instances of unallowable costs.
2022-007 – Activities allowed, Allowable Costs over Non-Payroll (Material Weakness over Internal Controls over Compliance, Other Noncompliance) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-052-2020; SAF-SWG-3-35-0037-053-2020; SAF-SWG-3-35-0037-054-2021 Federal Award Year: 2020, 2021 Condition: During our review of non-payroll related transactions, 14 out of 18 transactions tested did not include appropriate approval by the Airport Manager, 3 out of 18 transactions did not include a date of approval by the Airport Manager, and 1 out of 18 transactions did not include supporting documentation or purchase order information on the GL. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per Title 2 US Code of Federal Regulations Part 200.403g, costs must be adequately documented to be allowable under Federal awards. Cause: The City is not following procedures to ensure the appropriate approvals are being conducted on all purchases or retaining the supporting documentation to ensure purchase is allowable. Questioned Cost: Known and likely questioned costs of $35,021 Effect: The City may unintentionally charge expenses to the program that do not qualify and in turn lead to questioned costs and/or repayment of funds to the Grantor agency.
2022-008 – Reporting (Significant Deficiency over Internal Controls over Compliance) Federal Program Information Federal Award Title and ALN: Hazard Mitigation Grant Program, 97.067 Federal Awarding Agency: Department of Homeland Security Pass-Through Agency: NM Department of Homeland Security and Emergency Management Federal Award ID Number: EMW-2019-SS-00083-S01-02; EMW-2020-SS-00127-S01-01 Federal Award Year: 2019, 2020 Condition: The City is not submitting financial and performance reports to the pass through entity on a timely basis. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entities 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). Per sub-recipient grant agreements, EMW-2019-SS-00083-S01 and EMW-2020-SS-0127-S01, from the State of New Mexico Department of Homeland Security, the City shall submit quarterly reports by the 30th of the month following the quarter end. Cause: The City did not have sufficient controls in place to ensure the timeliness of reports being submitted to the pass through entity. Questioned Cost: None Effect: Lack of proper review for timeliness of reports can result in improper reporting which could lead to disallowed costs. However, our audit disclosed no instances of unallowable costs.