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-054-2020, SAF-SWG-3-35-0055-054-2020, SAF-SWG-3-35-0037-057-2020, SAF-SWG-3-35-0037-060-2020, SAF-SWG-3-35-0037-062-2020, SAF-SWG-3-35-0037-063-2020, SAF-SWG-3-35-0037-065-2020 Federal Award Year: 2021, 2022, 2024 Condition: The City’s approved annual inventory was not complete. There was no information to identify the funding source of the equipment and/or property. Management’s Progress on Repeat Findings: The City did not make progress on this finding during FY25. Criteria: Per 2 CFR 200.303(a), the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.313(d)(1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Cause: Turnover in related positions resulted in delays in making revisions to the listing to incorporate information on Federal participation in the purchases. Questioned Cost: None. Effect: The City could dispose of federally funded equipment without following federal guidelines. Auditor recommendation: The auditor recommends the City enhance the design of its control activities and create a tool to assist in tracking and maintaining equipment purchased with federal funds. Additionally, the employees responsible for the inventory should be trained to ensure understanding of the Uniform Guidance requirements relevant to equipment and real property management. Periodic review should also be designed to evaluate compliance with relevant requirements. Views of Responsible Officials and Planned Corrective Action: The City agrees with this finding. In FY25, The City contracted with a vendor to assist the Airport with federal compliance and provide training for Airport staff on relevant Uniform Guidance requirements. The vendor’s scope of work included helping with developing and documenting policies and standard operating procedures related to equipment management. Additionally, in late FY25, the Airport Department added a Grant Accountant position which is responsible for reconciling grant expenditures monthly. The Grant Accountant is also tasked to work with the Airport Heavy Equipment Mechanic to ensure that the inventory listing includes the funding source used for the purchase (i.e. federal or non-federal). In CY26 the Finance Director, the Accounting Officer, and the Grants team will work with the Airport team to improve internal controls over equipment purchased with federal funds. Based on the policies developed for the Airport, additional tools will be developed to facilitate tracking and maintaining equipment purchased with federal funds. These tools will be developed to ensure that an accurate physical inventory contains the information required by the Uniform Guidance is conducted at year-end. Responsible Official: Finance Director, Airport Manager, Airport Heavy Equipment Mechanic, Accounting Officer, Grants Manager. Timeline and Estimated Completion Date: June 30, 2026
Equipment and Real Property Management (Material Weakness over Internal Controls over Compliance) (Repeated/Modified) The City agrees with this finding. In FY25, The City contracted with a vendor to assist the Airport with federal compliance and provide training for Airport staff on relevant Uniform Guidance requirements. The vendor’s scope of work included helping with developing and documenting policies and standard operating procedures related to equipment management. Additionally, in late FY25, the Airport Department added a Grant Accountant position which is responsible for reconciling grant expenditures monthly. The Grant Accountant is also tasked to work with the Airport Heavy Equipment Mechanic to ensure that the inventory listing includes the funding source used for the purchase (i.e. federal or non-federal). In CY26 the Finance Director, the Accounting Officer, and the Grants team will work with the Airport team to improve internal controls over equipment purchased with federal funds. Based on the policies developed for the Airport, additional tools will be developed to facilitate tracking and maintaining equipment purchased with federal funds. These tools will be developed to ensure that an accurate physical inventory contains the information required by the Uniform Guidance is conducted at year-end. Due Date of Completion: June 30, 2026 Responsible Official: Finance Director, Emily K. Oster; Airport Manager, Jimmy Gunn; Airport Heavy Equipment Mechanic (various staff members); Accounting Officer, Matthew Bonifer; Grants Manager, Erika Lujan.
2023-006
2024-003 – Reimbursement Requests (Significant Deficiency in Internal Controls over Compliance) Federal Program Information Federal Award Title and ALN: Federal Transit Cluster, 20.507, 20.526 Federal Awarding Agency: Department of Transportation Federal Award ID Number: N/A Federal Award Year: 2024 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-051-2020, SAF-SWG-3-35-0037-057-2021 Federal Award Year: 2024 Condition: The City submitted reimbursements for grants in an untimely fashion for multiple months at a time in the Federal Transit Cluster and only at year-end in the Airport Improvement Program. Criteria: Per 2 CFR 200.303(a), the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per Title 2 US Code of Federal Regulations Part 200.302b, the non-federal entity must provide for effective control over, and accountability for, all funds, property, and other assets. The non-federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. Cause: The City does not have sufficient controls in place to review and approve requests to submit as needed. Questioned Cost: None. Effect: The City’s financial position and cash balances were adversely affected due to the delay in requesting and receiving reimbursement for funds already disbursed. Significant time passing between disbursement of funds and preparation of reimbursement requests may increase the chance of errors.
Auditor recommendation: We recommend that the City establish policies and procedures for requesting reimbursement of grant expenditures on a monthly basis, including reconciliation of the expenditures and reimbursements under each grant. Views of Responsible Officials and Planned Correcve Acon: The City agrees with this finding. Vacancies in key posions including the Airport Manager and the Transit Director of Administraon meant that there was not sufficient experse in the program areas to ensure that reimbursement requests were prepared and submied mely. These key posions have now been filled. The City now has an Airport Manager with substanal experience managing municipal airports and overseeing federal funding for airports. The City also hired a Transit Director of Administraon with extensive federal and state grant management experience, and experse in Transit programs. The Accounng Officer, Grants Manager and Accounng Financial Analyst posions in the Finance Department have been filled, and the Grants Division is now fully staffed. More robust staffing is allowing Finance to perform more oversight in addion to working more closely with Transit and Airport program staff. Filling these key posions and retaining qualified staff is essenal to establishing a process for mely requests for reimbursement, and reconciliaon of expenditures and reimbursement under each grant. The Transit Division is working with a contractor provided by the FTA on establishing policies and procedures to ensure compliance with federal grant requirements. This contractor is also providing training and technical assistance to the Transit program. The scope of this work includes ensuring requests for reimbursement of grant expenditures are submied mely, and reconciliaons of grant expenditures and reimbursements are completed mely and accurately. The Airport Department is in the process of contracng with a vendor to assist with federal compliance and provide training for Airport staff on relevant Uniform Guidance requirements. The vendor’s scope of work will include helping with developing and documenng policies and standard operang procedures for requests for reimbursement, and reconciliaon of expenditures and reimbursements. Addionally, the Airport Department plans to create a Grant Accountant posion which will be responsible for reconciling grant expenditures monthly and processing reimbursement requests quarterly. In CY25 the City plans to provide Uniform Guidance training for staff which will include internal controls related to cash management. Responsible Official:Emily Oster, Finance Director, James Harris, Airport Manager, Airport Heavy Equipment Mechanic, Gabrielle Chavez, Transit Director of Administration, Matthew Bonifer, Accounting Officer, Erika Lujan, Grants Manager Timeline and Esmated Compleon Date: June 30, 2025
2024-004 (2023-004) – Activities Allowed, Allowable Costs over Payroll (Significant Deficiency 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-057-2021 Federal Award Year: 2024 Condition: Two payroll checks were duplicated and included in the request for reimbursement. These checks totaled $2,694, out of a total of $876,014 in payroll charged to the program. Management’s Progress on Repeat Findings: Some progress made from prior year. Criteria: Per 2 CFR 200.303(a), the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR section 200.430(f) – Factors affecting allowability of costs, costs charged to Federal programs may not be included as a cost or used to meet cost sharing or matching requirements of any other federally-financed program in either the current or a prior period. Cause: The City does not have sufficient controls in place to ensure the accuracy of the amounts listed on the general ledger as charged to the grant. Questioned Cost: Known and likely questioned costs of $2,694 Effect: The City requested and received reimbursement for duplicate transactions not properly allocable to the program in the amount of $2,694.
Auditor recommendation: The auditor recommends that the City implement a final review for potential duplicated costs prior to approving reimbursement requests, and adjust the general ledger for any such items noted. Views of Responsible Officials and Planned Correcve Acon: The City agrees with this finding. A reimbursement request was submied 3/18/24 in the amount of $634,532.45. It was later idenfied that the reimbursement request included duplicate payroll expenditures in the amount of $2,694. One of the duplicated items, totaling $1,115, was idenfied through internal review within the City of Santa Fe aer the reimbursement request was submied. A credit memo has been processed in the FAA’s Delphi system and the City has repaid the $1,115 amount that was duplicated. The other item, totaling $1,579, was idenfied through the external audit. The City will process an addional credit memo and repay the $1,579 amount promptly. The Finance Director, the Accounng Officer, and the Grants team are working with the Airport team to strengthen policies and procedures and ensure a full review of the general ledger for the federal program to ensure no duplicate costs are charged prior to reimbursement requests being submied. A secondary review by the Finance Department of all Airport requests for reimbursement is now occurring prior to submission to FAA. In addion, we have started using employee pay advices as addional supporng documentaon for reimbursement requests. In the past excel spreadsheets were used as supporng documentaon, and the Finance Department review somemes happened aer the reimbursement request was submied. Vacancies in key posions resulted in a lack of robust review of reimbursement requests prior to submission. These key posions have now been filled. The City now has an Airport Manager with substanal experience managing municipal airports and overseeing federal funding for airports. The Accounng Officer, Grants Manager and Accounng Financial Analyst posions in the Finance Department have been filled, and the Grants Division is now fully staffed. More robust staffing is allowing Finance to work more closely with the Airport team. One of the primary dues of the new Accounng Financial Analyst in the Grants Division is to support the administraon of Airport grants. The City is in the process of contracng with a vendor to assist the Airport with federal compliance and provide training for Airport staff on relevant Uniform Guidance requirements. The vendor’s scope of work will include helping with developing and documenng policies and standard operang procedures for requests for reimbursement. Addionally, the Airport Department plans to create a Grant Accountant posion which will be responsible for reconciling grant expenditures monthly and processing reimbursement requests quarterly. The Finance Department will connue to perform a secondary review of Airport requests for reimbursement prior to submission to FAA. In CY25 the City plans to provide Uniform Guidance training for staff which will include internal controls related to acvies allowed and allowable costs. Responsible Official: Emily Oster, Finance Director, James Harris, Airport Manager, Matthew Bonifer, Accounting Officer, Erika Lujan, Grants Manager Timeline and Esmated Compleon Date: June 30, 2025
2023-004
2024-005 (2023-006) – Equipment and Real Property Management (Material Weakness over 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-051-2020 Federal Award Year: 2024 Condition: The City’s approved annual inventory was not complete. There was no information to identify the funding source of the equipment and/or property. Management’s Progress on Repeat Findings: Some progress made from prior year. Criteria: Per 2 CFR 200.303(a), the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.313(d)(1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Cause: Turnover in related positions resulted in delays in making revisions to the listing to incorporate information on Federal participation in the purchases. Questioned Cost: None. Effect: The City could dispose of federally funded equipment without following federal guidelines.
Auditor recommendation: The auditor recommends the City enhance the design of its control activities and create a tool to assist in tracking and maintaining equipment purchased with federal funds. Additionally, the employees responsible for the inventory should be trained to ensure understanding of the Uniform Guidance requirements relevant to equipment and real property management. Periodic review should also be designed to evaluate compliance with relevant requirements. Views of Responsible Officials and Planned Correcve Acon: The City agrees with this finding. During FY24 the Airport Manager hired a Heavy Equipment Mechanic. This posion is responsible for tracking, maintaining, and repairing Airport equipment. Logbooks are now being kept for all equipment. In CY25 the Finance Director, the Accounng Officer, and the Grants team will work with the Airport team to improve internal controls over equipment purchased with federal funds. Policies and procedures will be developed to ensure that an accurate physical inventory that contains the informaon required by the Uniform Guidance is conducted at year-end. The City is in the process of contracng with a vendor to assist the Airport with federal compliance and provide training for Airport staff on relevant Uniform Guidance requirements. The vendor’s scope of work will include helping with developing and documenng policies and standard operang procedures related to equipment management. Tools will be developed to facilitate tracking and maintaining equipment purchased with federal funds. Addionally, the Airport Department plans to create a Grant Accountant posion which will be responsible for reconciling grant expenditures monthly. The Grant Accountant will also work with the Airport Heavy Equipment Mechanic to ensure that the inventory lisng includes the funding source used for the purchase (i.e. federal or non-federal). In CY25 the City plans to provide Uniform Guidance to staff which will include capital assets and equipment informaon, and the specific requirements for the year-end inventory. Responsible Official: Emily Oster, Finance Director, James Harris, Airport Manager, Airport Heavy Equipment Mechanic, Matthew Bonifer, Accounting Officer, Erika Lujan, Grants Manager Timeline and Esmated Compleon Date: June 30, 2025
2023-006
2024-006 – Subrecipient Monitoring (Significant Deficiency in Internal Controls over Compliance) Federal Program Information Federal Award Title and ALN: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds, 21.027 Federal Awarding Agency: Department of the Treasury Federal Award ID Number: N/A Federal Award Year: 2024 Condition: In 5 of 5 samples tested, there was no indication of the City review and approval on performance reports required of the subrecipient to submit for monitoring. Other monitoring activities were performed. One contract was reported as a subaward on the preliminary SEFA. 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.332e(1), in monitoring a subrecipient, a pass-through entity must review financial and performance reports. Cause: Inconsistent application of controls throughout the year and with different subrecipients and entities resulted in poor documentation of control activities, and misclassification of a contract as a subaward. Questioned Cost: None. Effect: Inconsistent application of controls can result in noncompliance due to errors or fraud not being prevented or detected by employees. The Uniform Guidance requires pass-through entities to review reports submitted by subrecipients, and the City was not able to substantiate compliance with this requirement.
Auditor recommendation: We recommend the City strengthen policies and procedures to ensure program directors are following procedures and documenting review and approval as part of monitoring of subrecipients, and that subawards reported on the SEFA are verified against the characteristics of the agreement and the relationship with the other entity. Views of Responsible Officials and Planned Corrective Action: The City agrees with this finding. Vacancies in key positions resulted in a lack of robust oversight of subrecipient monitoring during FY24. These key positions have now been filled. The Accounting Officer, Grants Manager and Accounting Financial Analyst positions in the Finance Department have been filled with qualified people who have extensive grant management experience, and the Grants Division is now fully staffed. More robust staffing is allowing Finance to work more closely with federal grant program managers throughout City government. During the second half of FY24 the Finance team worked with our accounting consulting firm to develop and deploy Uniform Guidance training to over 50 employees City-wide. The AGA Recipient checklist for determining if the entity receiving funds has a contractor or subrecipient relationship was discussed and provided during this training and some City departments are now using it as part of the process to develop agreements that use federal funds. The Finance Director’s review of proposed agreements now includes an evaluation of the reasonableness of the subrecipient or contractor determination prior to the Finance Director signing the agreement. In CY25 the Finance team will work to develop additional procedures to ensure that subawards reported on the SEFA are verified against the characteristics of the agreement and the relationship with the other entity. Additionally, the Finance Director, the Accounting Officer, and the Grants team will work to strengthen policies and procedures and deploy training to ensure program managers understand subrecipient monitoring procedures, including documenting review and approval as part of monitoring of subrecipients. The City plans to provide additional Uniform Guidance training for staff in CY25 which will include subrecipient monitoring requirements. Responsible Official: Emily Oster, Finance Director, Matthew Bonifer, Accounting Officer, Erika Lujan, Grants Manager Timeline and Estimated Completion Date: June 30, 2025
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.
Recommendation: We recommend the City strengthen the controls in place to provide assurance Federal Financial Reports are submitted accurately to the grantor agency and retain backup documentation to support amounts reported. Action Taken: The City agrees with this finding. In November 2022 the City hired a new Airport Manager with substantial experience managing municipal airports and federal funding for airports. Prior to the hire, the Airport Operations Manager was the acting Manager, but that position was vacated in FY23. In FY24 the Finance Director and the Grants Manager will continue to work with the Airport staff to implement controls and to provide assurance that Federal Financial Reports have adequate supporting documentation and are reviewed and approved prior to submission the grantor agency. Anticipated Completion Date: June 30, 2024 Responsible Official: Emily Oster-Finance Director, James Harries-Airport Manager, Cheryl James-Grants Manager
2021-009
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.
Recommendation: We recommend the City strengthen the controls in place to provide assurance that proper review occurs with someone knowledgeable with the grant and retain backup documentation to support amounts charged to grant. Action Taken: The City agrees with this finding. In September of 2022, the City hired a highly qualified Grants Manager who has been continuously working with City Departments that receive grant funding to raise awareness of requirements such as the need to ensure that grant-funded transactions are appropriately reviewed and approved by someone knowledgeable with the grant. Key vacancies and personnel changes at the Airport during FY22 resulted in insufficient staffing to allow for robust internal controls and separation of duties. During FY24 the Finance Director and the Grants Manager will work with the Airport team to develop a procedure to document controls performed to review and approve grant-funded transactions. In FY24 the Grants Manager will provide Uniform Guidance training to City staff which will include allowable costs and internal controls. Anticipated Completion Date: June 30, 2024 Responsible Official: Emily Oster-Finance Director, James Harris-Airport Manager, Airport Operations Manager (in‐process of hiring), Cheryl James-Grants Manager
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.
Recommendation: We recommend the City strengthen the controls in place to provide assurance reports are submitted timely. Action Taken: The City agrees with this finding. Key vacancies and personnel changes within the City’s Emergency Management Department and the Finance Department during FY22 resulted in delays in securing approvals of quarterly report required for timely submissions. Staffing issues were resolved in FY22 and FY23, and the Finance Director and the Grants Manager are working with the Emergency Management Department to ensure timely review, approval, and submission of the required quarterly reports. Anticipated Completion Date: December 31, 2023 Responsible Official: Emily Oster-Finance Director, Brian Williams-Emergency Management Director, Cheryl James-Grants Manager
2021-008 (previously 2020-015) ? Equipment and Real Property Management (Material Weakness) (repeated/modified) Federal Program Information Funding Agency: U.S. Department of Transportation ? Federal Aviation Administration Federal Award Agreement Number: SAF-SWG-3-35-0037-043-2016, SAF-SWG-3-35-007-49- 2019, SAF-SWG-3-35-0037-056-2021, SAF-SWG-3-35- 0037-052-2020, SAF-SWG-3-35-0037-053-2020 Award Year: 2021 Title: Airport Improvement Program Assistance Listing Number: 20.106 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition: The City was not able to provide an equipment listing tracking all items purchased with federal funding nor did the City conduct a physical inventory. Management?s Progress on Repeat Findings: ? No progress in FY2021. 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 2 CFR 200.313(d)(1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Per 2 CFR 200.313(d)(2), a physical inventory of program property must be taken and the results reconciled with the property records at least once every 2 years. Questioned costs: Not applicable Effect: The City could dispose of or lose federally funded equipment without following federal guidelines. Cause: The City is not following policy and procedures to ensure that equipment purchased with federal funds is maintained and tracked and the City performing a physical inventory at a minimum of every two years. Auditor recommendation: We recommend the City enhance the design of its control activities and policies and procedures should be developed to ensure physical inventories are taken at least once every two years and that they create a tool to assist in tracking and maintaining equipment purchased with federal funds. Views of Responsible Officials and Planned Corrective Action: The City agrees with this finding. In November 2022 the City hired a new Airport Manager with substantial experience managing municipal airports and federal funding for airports. During FY23 the long-time Administrative Manager at the Airport separated without notice from the City and other staff were unable to access needed files which included the equipment inventory. During FY24 the Finance Director, the Controller will work with the Airport Manager to improve the internal controls over equipment purchased with federal funds. Policies and procedures will be developed to ensure that a physical inventory is conducted at least once every two years. Tools will be developed to facilitate tracking and maintaining equipment purchased with federal funds. In FY24 the Grants Manager will provide Uniform Guidance training to City staff which will include capital assets and equipment information. Responsible Official: Finance Director, Airport Manager, Controller (in-process of hiring), Grants Manager Timeline and Estimated Completion Date: June 30, 2024
2021-008 (previously 2020-015) ? Equipment and Real Property Management (Material Weakness) (repeated/modified) Recommendation: We recommend the City enhance the design of its control activities and policies and procedures should be developed to ensure physical inventories are taken at least once every two years and that they create a tool to assist in tracking and maintaining equipment purchased with federal funds. Action Taken: The City agrees with this finding. In November 2022 the City hired a new Airport Manager with substantial experience managing municipal airports and federal funding for airports. During FY23 the long-time Administrative Manager at the Airport separated without notice from the City and other staff were unable to access needed files which included the equipment inventory. During FY24 the Finance Director, the Controller will work with the Airport Manager to improve the internal controls over equipment purchased with federal funds. Policies and procedures will be developed to ensure that a physical inventory is conducted at least once every two years. Tools will be developed to facilitate tracking and maintaining equipment purchased with federal funds. In FY24 the Grants Manager will provide Uniform Guidance training to City staff which will include capital assets and equipment information. Anticipated Completion Date: June 30, 2024 Responsible Official: Emily Oster - Finance Director, James Harris - Airport Manager, Controller (in-process of hiring), Cheryl James - Grants Manager
2020-015
2021-009 ? Matching and Financial Reporting (Material Noncompliance and Material Weakness) Federal Program Information Funding Agency: U.S. Department of Transportation ? Federal Aviation Administration Federal Award Agreement Number: SAF-SWG-3-35-0037-043-2016, SAF-SWG-3-35-007-49- 2019, SAF-SWG-3-35-0037-056-2021, SAF-SWG-3-35- 0037-052-2020, SAF-SWG-3-35-0037-053-2020 Award Year: 2021 Title: Airport Improvement Program Assistance Listing Number: 20.106 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition: The City did not submit FFR reports for 3 grants and for 1 grant the City submitted late with no supporting backup documentation to test accuracy of report. 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. Questioned costs: Not applicable Effect: Lack of proper review for accuracy and timeliness of reports can result in improper reporting which could lead to disallowed costs. However, our audit disclosed no instances of unallowable costs. Cause: The City did not have sufficient controls in place to review and approve reports ensuring accuracy and timeliness of reports to the grantor agency. Auditor recommendation: We recommend the City strengthen the controls in place to provide assurance Federal Financial Reports are submitted accurately an in a timely fashion to the grantor agency.Views of Responsible Officials and Planned Corrective Action: The City agrees with this finding. In November 2022 the City hired a new Airport Manager with substantial experience managing municipal airports and federal funding for airports. In FY2024 the Finance Director and the Grants Manager will work with the Airport Manager to implement controls to provide assurance that Federal Financial Reports are submitted accurately and in a timely fashion to the grantor agency. Responsible Official: Finance Director, Airport Manager, Grants Manager Timeline and Estimated Completion Date: June 30, 2024
2021-009 ? Matching and Financial Reporting (Material Noncompliance and Material Weakness) Recommendation: We recommend the City strengthen the controls in place to provide assurance Federal Financial Reports are submitted accurately an in a timely fashion to the grantor agency. Action Taken: The City agrees with this finding. In November 2022 the City hired a new Airport Manager with substantial experience managing municipal airports and federal funding for airports. In FY2024 the Finance Director and the Grants Manager will work with the Airport Manager to implement controls to provide assurance that Federal Financial Reports are submitted accurately and in a timely fashion to the grantor agency. Anticipated Completion Date: June 30, 2024 Responsible Official: Emily Oster - Finance Director, James Harris - Airport Manager, Cheryl James - Grants Manager
2021-010 ? Special Test and Provision, Wage Rate Requirement (Significant Deficiency) Federal Program Information Funding Agency: U.S. Department of Transportation ? Federal Aviation Administration Federal Award Agreement Number: SAF-SWG-3-35-0037-043-2016, SAF-SWG-3-35-007-49- 2019, SAF-SWG-3-35-0037-056-2021, SAF-SWG-3-35- 0037-052-2020, SAF-SWG-3-35-0037-053-2020 Award Year: 2021 Title: Airport Improvement Program Assistance Listing Number: 20.106 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition: The City contract to contractor Albuquerque Asphalt, Inc. did not provide the required clauses by the Wage Rate Requirement, previously known as the Davis-Bacon Act. 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 Appendix II to Part 200, all contracts made by the non-Federal entities under the federal award must contain provisions covering the following, (D) Davis-Bacon Act, as amended (40 U.S.C. 3141?3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non-Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141?3144, and 3146?3148) as supplemented by Department of Labor regulations (29 CFR Part 5, ?Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction?). Questioned costs: Not applicable Effect: The City could enter into a contract agreement with contractors who are not familiar with the Davis- Bacon act and not follow requirements to pay laborers a prevailing wage weekly. This could lead to disallowed costs charged to the grant and/or repayment to the Grantor agency. Cause: The City did not have sufficient controls in place to ensure the required clauses related to the Wage Rate requirement were listed in the contractor?s contract.Auditor recommendation: We recommend the City strengthen the controls in place to provide assurance that contract agreements entered into with subcontractors contain the required clauses set by the Davis- Bacon act. Views of Responsible Officials and Planned Corrective Action: The City agrees with this finding. In September of 2022, the City hired a highly qualified Grants Manager who has been continuously working with City Departments that receive grant funding to raise awareness of requirements such as the need to include specific contract clauses in agreements funded with federal dollars. In February 2023, the City hired a certified Chief Procurement Officer (CPO) with over ten years of experience in the State General Services Department?s State Purchasing Division. The CPO is working to increase awareness of the City?s Procurement policies and procedures through trainings for City departments and the development of checklists and guides to ensure compliance. During FY24 the Finance Director, the Grant Manager, and the Purchasing Officer will work with the Assistant City Attorney responsible for contract review to improve the internal controls over contracts funded with federal funds. Policies and procedures will be developed to ensure that all contract agreements entered into with federal funds contain the required clauses set by the Davis-Bacon act. Responsible Official: Finance Director, Grant Manager, Purchasing Officer, Assistant City Attorney Timeline and Estimated Completion Date: December 31, 2023
2021-010 ? Special Test and Provision, Wage Rate Requirement (Significant Deficiency) Recommendation: We recommend the City strengthen the controls in place to provide assurance that contract agreements entered into with subcontractors contain the required clauses set by the Davis- Bacon act. Action Taken: The City agrees with this finding. In September of 2022, the City hired a highly qualified Grants Manager who has been continuously working with City Departments that receive grant funding to raise awareness of requirements such as the need to include specific contract clauses in agreements funded with federal dollars. In February 2023, the City hired a certified Chief Procurement Officer (CPO) with over ten years of experience in the State General Services Department?s State Purchasing Division. The CPO is working to increase awareness of the City?s Procurement policies and procedures through trainings for City departments and the development of checklists and guides to ensure compliance. During FY24 the Finance Director, the Grant Manager, and the Purchasing Officer will work with the Assistant City Attorney responsible for contract review to improve the internal controls over contracts funded with federal funds. Policies and procedures will be developed to ensure that all contract agreements entered into with federal funds contain the required clauses set by the Davis-Bacon act. Anticipated Completion Date: December 31, 2023 Responsible Official: Emily Oster - Finance Director, Cheryl James - Grant Manager, Travis Dutton-Leyda - Purchasing Officer, Marcos Martinez - Assistant City Attorney
2021-011 ? Suspension and Debarment (Significant Deficiency) Federal Program Information Funding Agency: U.S. Department of Transportation Federal Award Agreement Number: NM-2020-011-00, NM-2020-012-00, NM-2020-013-00 Award Year: 2021 Title: Federal Transit Cluster Assistance Listing Number: 20.507 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition: The City does not maintain support that review for suspension and debarment was performed prior to execution of non-RFP awards. 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 2 CFR 180, non-federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred. In accordance with 2 CFR 200.303(a), nonfederal entities must establish and maintain effective internal controls over federal awards. Questioned costs: Not applicable Effect: Contracts could be entered into with vendors who are suspended or debarred without documented support that a review for suspension and debarment is performed prior to execution of the contracts. Cause: The City has not implemented controls to review suspension and debarment for all covered transactions. Auditor recommendation: We recommend the city document controls performed to review for suspension and debarment prior to execution of contracts.Views of Responsible Officials and Planned Corrective Action: The City agrees with this finding. In September of 2022, the City hired a highly qualified Grants Manager who has been continuously working with City Departments that receive grant funding to raise awareness of requirements such as the need to review for suspension and debarment prior to the execution of contracts. Additionally, in February 2023, the City hired a certified Chief Procurement Officer with over ten years of experience in the State General Services Department?s State Purchasing Division. The CPO is working to increase awareness of the City?s Procurement policies and procedures through trainings for City departments and the development of checklists and guides to ensure compliance. During FY24 the Transit Department will be recruiting for a Transit Grants Director position to assist with the administration of federal funding. In FY24 the Finance Director, the Purchasing Officer, and the Grants Manager will develop a procedure to document controls performed to review for suspension and debarment prior to execution of contracts. In FY24 the Grants Manager will provide Uniform Guidance training to City staff which will include suspension and debarment information. Responsible Official: Finance Director, Grants Manager, Purchasing Officer Timeline and Estimated Completion Date: March 31, 2024
2021-011 ? Suspension and Debarment (Significant Deficiency) Recommendation: We recommend the city document controls performed to review for suspension and debarment prior to execution of contracts. Action Taken: The City agrees with this finding. In September of 2022, the City hired a highly qualified Grants Manager who has been continuously working with City Departments that receive grant funding to raise awareness of requirements such as the need to review for suspension and debarment prior to the execution of contracts. Additionally, in February 2023, the City hired a certified Chief Procurement Officer with over ten years of experience in the State General Services Department?s State Purchasing Division. The CPO is working to increase awareness of the City?s Procurement policies and procedures through trainings for City departments and the development of checklists and guides to ensure compliance. During FY24 the Transit Department will be recruiting for a Transit Grants Director position to assist with the administration of federal funding. In FY24 the Finance Director, the Purchasing Officer, and the Grants Manager will develop a procedure to document controls performed to review for suspension and debarment prior to execution of contracts. In FY24 the Grants Manager will provide Uniform Guidance training to City staff which will include suspension and debarment information. Anticipated Completion Date: March 31, 2024 Responsible Official: Emily Oster - Finance Director, Cheryl James - Grants Manager, Travis Dutton-Leyda - Purchasing Officer
2021-012 ? Activities allowed, Allowable Costs, and Period of Performance Controls over Non-payroll (Material Weakness) Federal Program Information Funding Agency: U.S. Department of Transportation Federal Award Agreement Number: NM-2020-011-00, NM-2020-012-00, NM-2020-013-00 Award Year: 2021 Title: Federal Transit Cluster Assistance Listing Number: 20.507 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition: During our review of non-payroll related transactions, 19 out of 40 transactions tested did not include appropriate approval by the Program Director. 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). Questioned costs: Not applicable 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. Cause: The City is not following procedures to ensure the appropriate approvals by an individual knowledgeable of the federal program are being conducted on all purchases. Auditor recommendation: We recommend the City strengthen the controls in place to provide assurance that proper review occurs with someone knowledgeable with the grant. Views of Responsible Officials and Planned Corrective Action: The City agrees with this finding. In September of 2022, the City hired a highly qualified Grants Manager who has been continuously working with City Departments that receive grant funding to raise awareness of requirements such as the need to ensure that grant-funded transactions are appropriately reviewed and approved by someone knowledgeable with the grant. Key vacancies in the Transit Department during FY21 resulted in insufficient staffing to allow for robust internal controls and separation of duties. During FY24 the Transit Department will be recruiting for a Transit Grants Director position to assist with the administration of federal funding. During FY24 the Finance Director and the Grants Manager will work with the Transit team to develop a procedure to document controls performed to review and approve grant-funded transactions. In FY24 the Grants Manager will provide Uniform Guidance training to City staff which will include allowable costs and internal controls. Responsible Official: Finance Director, Grants Manager, Transit Director Timeline and Estimated Completion Date: March 31, 2024
2021-012 ? Activities allowed, Allowable Costs, and Period of Performance Controls over Non-payroll (Material Weakness) Recommendation: We recommend the City strengthen the controls in place to provide assurance that proper review occurs with someone knowledgeable with the grant. Action Taken: The City agrees with this finding. In September of 2022, the City hired a highly qualified Grants Manager who has been continuously working with City Departments that receive grant funding to raise awareness of requirements such as the need to ensure that grant-funded transactions are appropriately reviewed and approved by someone knowledgeable with the grant. Key vacancies in the Transit Department during FY21 resulted in insufficient staffing to allow for robust internal controls and separation of duties. During FY24 the Transit Department will be recruiting for a Transit Grants Director position to assist with the administration of federal funding. During FY24 the Finance Director and the Grants Manager will work with the Transit team to develop a procedure to document controls performed to review and approve grant-funded transactions. In FY24 the Grants Manager will provide Uniform Guidance training to City staff which will include allowable costs and internal controls. Anticipated Completion Date: March 31, 2024 Responsible Official: Emily Oster - Finance Director, Cheryl James - Grants Manager, Thomas Martinez - Transit Director
2021-013 ? Cash Management (Material Noncompliance and Material Weakness) Federal Program Information Funding Agency: U.S. Department of Transportation Federal Award Agreement Number: NM-2020-011-00, NM-2020-012-00, NM-2020-013-00 Award Year: 2021 Title: Federal Transit Cluster Assistance Listing Number: 20.507 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition: The City requested drawdowns at the end of the year which is not considered timely. In addition, drawdowns did not have detailed support to test the accuracy of amounts requested. 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). Questioned costs: Not applicable Effect: Lack of sufficient controls over drawdown requests resulted in requests not supported by backup documentation or requested timely. Cause: The City does not have the policy and procedures in place to reconcile grants monthly in order to submit requests timely nor is support being retained with drawdowns to ensure the accuracy of amounts. Auditor recommendation: We recommend strengthening controls in place to provide assurance that all grant drawdown requests are accurate and submitted timely and supported with detailed backup documentation.Views of Responsible Officials and Planned Corrective Action: The City agrees with this finding. In September of 2022, the City hired a highly qualified Grants Accounting Manager who has been continuously working with City Departments that receive grant funding to raise awareness of requirements such as the need ensure that grant drawdown requests are submitted timely and accurately and that detailed supporting documentation is maintained. Key vacancies in the Transit Department during FY21 resulted in insufficient staffing to allow the Department to submit drawdown requests timely and maintain appropriate supporting documentation. During FY24 the Transit Department will be recruiting for a Transit Grants Director position to assist with the administration of federal funding. During FY24 the Finance Director and the Grants Manager will work with the Transit Director to strengthen controls in place to provide assurance that all grant drawdown requests are accurate and submitted timely and supported with detailed backup documentation. In FY24 the Grants Manager will provide Uniform Guidance training to City staff which will include documentation and internal controls. Responsible Official: Finance Director, Grants Manager, Transit Director Timeline and Estimated Completion Date: June 30, 2024
2021-013 ? Cash Management (Material Noncompliance and Material Weakness) Recommendation: We recommend strengthening controls in place to provide assurance that all grant drawdown requests are accurate and submitted timely and supported with detailed backup documentation. Action Taken: The City agrees with this finding. In September of 2022, the City hired a highly qualified Grants Accounting Manager who has been continuously working with City Departments that receive grant funding to raise awareness of requirements such as the need ensure that grant drawdown requests are submitted timely and accurately and that detailed supporting documentation is maintained. Key vacancies in the Transit Department during FY21 resulted in insufficient staffing to allow the Department to submit drawdown requests timely and maintain appropriate supporting documentation. During FY24 the Transit Department will be recruiting for a Transit Grants Director position to assist with the administration of federal funding. During FY24 the Finance Director and the Grants Manager will work with the Transit Director to strengthen controls in place to provide assurance that all grant drawdown requests are accurate and submitted timely and supported with detailed backup documentation. In FY24 the Grants Manager will provide Uniform Guidance training to City staff which will include documentation and internal controls. Anticipated Completion Date: June 30, 2024 Responsible Official: Emily Oster - Finance Director, Cheryl James - Grants Manager, Thomas Martinez - Transit Director
2021-014 ? Activities allowed, Allowable Costs, and Period of Performance Controls over Non-payroll (Significant Deficiency) Federal Program Information Funding Agency: U.S. Department of Treasury Federal Award Agreement Number: Not Applicable Award Year: 2021 Title: COVID-19 Coronavirus Relief Fund Assistance Listing Number: 21.019 Pass-through Agency: NM Department of Finance and Administration Pass-through Identification Number: CARES-01001-CSF Condition: During our review of nonpayroll transactions, 2 out of 37 transactions tested did not include approval by the Program Director. 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). Questioned costs: Questioned costs of $22,227 and likely questioned costs of $121,600 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. Cause: The City is not following procedures to ensure the appropriate approvals are being conducted on all purchases. Auditor recommendation: We recommend that the City strengthen its policies and procedures to ensure all grant transactions are properly reviewed and approved by the Program Director who has knowledge over the grant. Views of Responsible Officials and Planned Corrective Action: The City agrees with this finding and notes that the likely questioned costs of $121,600 represent approximately 0.70% of the over $17.5 million in total Coronavirus Relief Fund funding received. Key vacancies in the Finance Department during FY21 resulted in the City relying on contractors to review and recommend approval of COVID-19 Coronavirus Relief Fund grant transactions. In September of 2022, the City hired a highly qualified Grants Accounting Manager who has been continuously working with City Departments that receive grant funding to raise awareness of requirements such as the need to ensure that grant transactions are properly reviewed and approved by someone who has knowledge over the grant, and that detailed supporting documentation is maintained. At the end of FY23 the Grants team within the Finance Department achieved full staffing, with four of four positions filled. All Grants team members and several City employees from other Departments participated in specialized federal grants training in April 2023 to develop more robust knowledge of grant compliance requirements. During FY24 the Finance Director and the Grants Manager will work to strengthen City policies and procedures and develop and deploy training City-wide to ensure grant transactions are properly reviewed and approved by the Program Director who has knowledge over the grant. In FY24 the Grants Manager will provide Uniform Guidance training to City staff, including agency-specific guidance such as requirements for CARES and ARPA fundings. Responsible Official: Finance Director, Grant Manager, Program Directors City-Wide Timeline and Estimated Completion Date: June 30, 2024
2021-014 ? Activities allowed, Allowable Costs, and Period of Performance Controls over Non-payroll (Significant Deficiency) Recommendation: We recommend that the City strengthen its policies and procedures to ensure all grant transactions are properly reviewed and approved by the Program Director who has knowledge over the grant. Action Taken: The City agrees with this finding and notes that the likely questioned costs of $121,600 represent approximately 0.70% of the over $17.5 million in total Coronavirus Relief Fund funding received. Key vacancies in the Finance Department during FY21 resulted in the City relying on contractors to review and recommend approval of COVID-19 Coronavirus Relief Fund grant transactions. In September of 2022, the City hired a highly qualified Grants Accounting Manager who has been continuously working with City Departments that receive grant funding to raise awareness of requirements such as the need to ensure that grant transactions are properly reviewed and approved by someone who has knowledge over the grant, and that detailed supporting documentation is maintained. At the end of FY23 the Grants team within the Finance Department achieved full staffing, with four of four positions filled. All Grants team members and several City employees from other Departments participated in specialized federal grants training in April 2023 to develop more robust knowledge of grant compliance requirements. During FY24 the Finance Director and the Grants Manager will work to strengthen City policies and procedures and develop and deploy training City-wide to ensure grant transactions are properly reviewed and approved by the Program Director who has knowledge over the grant. In FY24 the Grants Manager will provide Uniform Guidance training to City staff, including agency-specific guidance such as requirements for CARES and ARPA fundings. Anticipated Completion Date: June 30, 2024 Responsible Official: Emily Oster - Finance Director, Cheryl James - Grants Manager, Program Directors City-Wide
During our testing, we noted the City did not offset or return funds for a duplicate payment to the City in the previous year.
2020-014 Cash Management Federal Agency: U.S. Department of Transportation/Federal Aviation Administration (FAA) Federal Program: Airport Improvement Program (AIP) CFDA Number: 20.106 Award Period: Various Type of Finding: ? Significant Deficiency in Internal Control over Compliance ? Other Matters Corrective Action Plan: The City is in agreement with the finding and understands the need to resolve such errors expeditiously as well as maintain documentation thereof. The City?s policies and procedures will be updated to address this matter more specifically to eliminate this situation from occurring in the future. Person(s) Responsible, including Position Title: Clayton Pelletier, CPA, Controller, Grants Manager (in-process of hiring), Grants Financial Analyst (in-process of hiring) and Bobbi Huseman (Administrative Manager) Estimated Completion Date: February 1, 2022
2019-011
During our testing, we noted that there is not a process to track capital assets that have been purchased with federal funds.
2020-015 Property and Equipment Federal Agency: U.S. Department of Transportation/Federal Aviation Administration (FAA) Federal Program: Airport Improvement Program (AIP) CFDA Number: 20.106 Award Period: Various Type of Finding: ? Significant Deficiency in Internal Control over Compliance ? Other Matters Corrective Action Plan: The City agrees with the finding and will update its capital asset accounting policies, procedures and detailed records to identify the source of funding (including federal award identification number) and percentage of federal participation in any equipment and property purchases. Person(s) Responsible, including Position Title: Accounting Officer (in-process of hiring), Clayton Pelletier, CPA, Controller and Lisa M. Storey, Accounting Financial Analyst Estimated Completion Date: February 1, 2022
During our testing, we noted the City did not have adequate internal controls in place to ensure compliance with reporting.
2020-016 Reporting Federal Agency: U.S. Department of Housing and Urban Development (HUD)/Assistance Secretary for Community Planning and Development Federal Program: Community Development Block Grants/Entitlement Grants (CDBG) CFDA Number: 14.218 Award Period: 7/1/2019 ? 9/1/2026 Type of Finding: ? Significant Deficiency in Internal Control over Compliance ? Other Matters Corrective Action Plan: The City will enforce its currently established policies and procedures over CDBG federal reporting to ensure that all reports are properly prepared, supported by underlying records, timely and reviewed by the Housing Director prior to submission to the granting agency. In addition, the City will provide CDBG personnel training and oversight to ensure that this finding is not repeated in the future. Person(s) Responsible, including Position Title: Alexandra Ladd, Housing Director Estimated Completion Date: Immediately
During our testing, we noted the Project Administration Drawn Amount in the IDIS - PR05 Drawdown Report by Project and Activity for Program Year 2019 did not agree to the financial records. The Drawdown Report had an amount of $12,702 less than the financial records with $12,408 attributable to salaries and benefits.
2020-017 Allowable Activities and Costs ? Payroll Disbursements Federal Agency: U.S. Department of Housing and Urban Development (HUD)/Assistance Secretary for Community Planning and Development Federal Program: Community Development Block Grants/Entitlement Grants (CDBG) CFDA Number: 14.218 Award Period: 7/1/2019 ? 9/1/2026 Type of Finding: ? Significant Deficiency in Internal Control over Compliance ? Other Matters Corrective Action Plan: The City will enforce its currently established accounting policies and procedures over CDBG federal reporting to ensure that all reports are properly prepared, supported by underlying records, timely and reviewed prior to submission to the granting agency. In addition, the City will provide CDBG personnel training and oversight to ensure that this finding is not repeated in the future. Person(s) Responsible, including Position Title: Clayton Pelletier, CPA, Controller and Grants Manager (in-process of hiring), Grants Financial Analyst (in-process of hiring) and Alexandra Ladd, Housing Director Estimated Completion Date: Immediately
2019-013
? The City was unable to provide one of three subrecipient folders for us to test program income. ? For two of the five receipts and one of the draws with a corresponding receipt, we noted the subrecipient folder did contain the quarterly reports submitted by the subrecipient to the City. However, the folder did not contain other documentation as specified by HUD to verify that the amount of program income receipted and drawn corresponds to the information reported in the quarterly reports. ? The City did not record the program income amounts included in the IDIS - PR09 Program Income Details by Fiscal Year and Program for time period of 07-01-2019 to 06-30-2020 in the financial records. Total CDBG Receipts and Total CDBG Draws against Receipts of approximately $541,773 and $357,034, respectively. Of the approximate $541,773, local account receipts accounted for approximately $183,274. ? The City is not reporting program income in a timely manner to HUD in IDIS. Our review of subrecipient quarterly reports submitted to the City for the fiscal year end 6/30/2020 has total program income generated and used of approximately $487,735 and $509,137, respectively. The City reported program income for the fiscal year end 6/30/2019 in the IDIS - PR09 Program Income Details by Fiscal Year and Program for time period of 07-01-2019 to 06-30-2020.
2020-018 Program Income Federal Agency: U.S. Department of Housing and Urban Development (HUD)/Assistance Secretary for Community Planning and Development Federal Program: Community Development Block Grants/Entitlement Grants (CDBG) CFDA Number: 14.218 Award Period: 7/1/2019 ? 9/1/2026 Type of Finding: ? Material Weakness in Internal Control over Compliance ? Material Noncompliance (Modified Opinion) Corrective Action Plan: The CDBG Program Personnel will perform a complete inventory of all records pertaining to its subrecipients to compile a complete master listing of all subrecipients and will review all subrecipient folders from the master list to ascertain that all required documentation has been obtained and on file. Additionally, the Finance Department staff and CDBG Program staff will receive training on the reporting requirements for the federal reporting system. The City will perform periodic procedural reviews regarding the noted Program audit compliance issues. Person(s) Responsible, including Position Title: Alexandra Ladd, Housing Director, Clayton Pelletier, CPA, Controller and Grants Manager (inprocess of hiring), and Grants Financial Analyst (in-process of hiring) Estimated Completion Date: February 1, 2022
2019-015
During our testing, we noted the City made a duplicate reimbursement request of incurred expenditures. For one of one reimbursement requests tested, we noted the reimbursement request of $12,669 on 5/22/2019 was a duplicate of a reimbursement request made on 6/27/2018.
2019-011 Cash Management (Significant Deficiency and Other Matters) Federal Program: Airport Improvement Program (AIP) CFDA Number: 20.106 Recommendation We recommend the City design controls to ensure an adequate review process is in place related to reimbursement requests. The review process should include a reviewer that is independent of the preparer of the reimbursement request. Also, the review should include a review of previous reimbursement requests to ensure reimbursement requests are made only once for incurred expenditures. Explanation There is no disagreement with this audit finding. Action Plan The City concurs with the finding. The City of Santa Fe is in the process of implementing a Grants Management Division to oversee the financial and accounting management of all City federal grant programs and their awarded funds per 2 CFR 200 Uniform Administrative, Cost Principals, and Audit Requirements for Federal Awards, Federal Program Handbooks & Guidelines, and State & City policies and procedures in regards to grant financial management, government accounting standards, and required reports for submission. The newly created Grants Management Division will consist of an experienced and professional grant accounting staff that are knowledgeable with the Federal Grant Lifecycle (Pre-Award Phase, Award Phase, and Post Award Phase). The newly created Grants Management Division will prepare monthly grant fund reconciliations, track allowable grant expenditures and revenue reimbursements as it pertains to the grant?s period of performance, ensure federal compliance, and prepare timely required federal reports. The City of Santa Fe is also in the process of upgrading the current accounting, finance, and grant system. The upgrade of the Tyler Munis Financial system will provide much improved grant accounting tracking and reporting capabilities for all City federal programs and their funds. The Munis upgrade contains modules for project grant accounting, general billing/invoicing, and cash management. The new Grants Management Division will have internal controls and separation of duties in place regarding federal reimbursements and drawdowns which can be tracked in Munis Financials. This process will be documented in the City?s policies and procedures. The described process will be implemented by June 2021. Responsible Party (s) Regina Wheeler, Public Works Director, Mary McCoy, Finance Director, Debra Harris-Garmendia, Accounting Officer, Bradley Fluetsch, CFA, Financial Planning and Reporting Officer. Planned completion date June 2021
During our testing, we noted the City did not have adequate internal controls in place to ensure compliance with reporting. Specific details by Federal Program are in the Schedule of Findings and Questioned Costs.
2019-012 Reporting (Material Weakness Compliance and Material Noncompliance) Federal Program: Airport Improvement Program (AIP)/Community Development Block Grants/Entitlement Grants CFDA Number: 20.106/14.218 Recommendation We recommend the City review the FAA's AIP Grant Payment and Sponsor Financial Reporting Policy and the Compliance Supplement published by the Office of Management and Budget (OMB) to gain an understanding of the reports required to be submitted to the FAA. We recommend the City design controls to ensure an adequate process is in place to maintain reports submitted by the City to the Federal funding agency as well as the supporting documentation used to prepare the reports. The process should include the City to move towards maintaining the files in electronic form. Also, we recommend the City review 2 CFR Part 200 to gain an understanding of the Federal requirement to 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. Explanation There is no disagreement with this audit finding. Action Plan The City concurs with the finding. The City of Santa Fe is in the process of implementing a Grants Management Division to oversee the financial and accounting management of all City federal grant programs and their awarded funds per 2 CFR 200 Uniform Administrative, Cost Principals, and Audit Requirements for Federal Awards, Federal Program Handbooks & Guidelines, and State & City policies and procedures in regards to grant financial management, government accounting standards, and required reports for submission. The newly created Grants Division will consist of an experienced and professional grant accounting staff that are knowledgeable with the Federal Grant Lifecycle (Pre-Award Phase, Award Phase, and Post Award Phase). The newly created Grants Management Division will prepare monthly grant fund reconciliations, track allowable grant expenditures and revenue reimbursements as it pertains to the grant?s period of performance, ensure federal compliance, and prepare timely required federal reports. The City of Santa Fe is also in the process of upgrading their current accounting, finance, and grant system. The upgrade of the Tyler Munis Financial system will provide much improved grant accounting tracking and reporting capabilities for all City federal programs and their funds. The Munis upgrade contains modules for project grant accounting, general billing/invoicing, and cash management. The new Grants Management Division will have internal controls and separation of duties in place regarding federal reimbursements and drawdowns which can be tracked in Munis Financials. This process will be documented in the City?s policies and procedures. The described process will be implemented by June 2021. Responsible Party (s) Alexandra Ladd Affordable Housing Director, Regina Wheeler Public Works Director, Mary McCoy, Finance Director, Debra Harris-Garmendia, Accounting Officer, Bradley Fluetsch, CFA, Financial Planning and Reporting Officer. Planned completion date June 2021
During our testing, we noted one timesheet was not approved nor were the annual time certifications provided to us. For one of eight disbursements reviewed in an approximate amount of $1,369, we noted the timesheet was not approved by the Housing Director. The City did not provide the annual time certifications submitted to HUD by the program manager.
2019-013 Allowable Activities and Costs ? Payroll Disbursements (Significant Deficiency and Other Matters) Federal Program: Community Development Block Grants/Entitlement Grants (CDBG) CFDA Number: 14.218 Recommendation We recommend the City design controls to ensure an adequate review process is in place related to the payroll costs charged to the grants. Also, we recommend the City design controls to ensure an adequate process is in place to maintain time and effort certifications. The process should include the City to move towards maintaining the files in electronic form. Explanation There is no disagreement with this audit finding. Action Plan The City concurs with the finding. The City of Santa Fe is in the process of implementing a Grants Service Division to oversee the financial & accounting management of all City federal grant programs and their awarded funds per 2 CFR 200 Uniform Administrative, Cost Principals, and Audit Requirements for Federal Awards, Federal Program Handbooks & Guidelines, and State & City policies and procedures in regards to grant financial management, government accounting standards, and required reports for submission. The newly created Grants Division will consist of an experienced and professional grant accounting staff that are knowledgeable with the Federal Grant Lifecycle (Pre-Award Phase, Award Phase, and Post Award Phase). The newly created Grants Bureau will prepare monthly grant fund reconciliations, track allowable grant expenditures and revenue reimbursements as it pertains to the grant?s period of performance, ensure federal compliance, and prepare timely required federal reports. The City of Santa Fe is also in the process of upgrading their current accounting, finance, and grant system. The upgrade of the Tyler Munis Financial system will provide much improved grant accounting tracking and reporting capabilities for all City federal programs and their funds. The Munis upgrade contains modules for project grant accounting, general billing/invoicing, and cash management. The new Grants Division will have internal controls and separation of duties in place regarding federal reimbursements and drawdowns which can be tracked in Munis Financials. This process will be documented in the City?s policies and procedures. The described process will be implemented by June 2021. Responsible Party (s) Alexandra Ladd Affordable Housing Director, Regina Wheeler Public Works Director, Mary McCoy, Finance Director, Bradley Fluetsch, CFA, Financial Planning and Reporting Officer, Debra Harris-Garmendia, Accounting Officer. Planned completion date June 2021
During our testing, we noted costs charged to the grant prior to the start date of the award. Also, the annual time certifications were not provided to us. For one of three costs charged to the grant in the first month of the start of the grant, totaling an approximate amount of $507, we noted the costs incurred in June 2018, which is prior to the start date of the grant of 7/1/2018. The City did not provide the annual time certifications submitted to HUD by the program manager.
2019-014 Period of Performance (Significant Deficiency and Other Matters) Federal Program: Community Development Block Grants/Entitlement Grants (CDBG) CFDA Number: 14.218 Recommendation We recommend the City design controls to ensure an adequate review process is in place related to costs charged to the grant. The review process should include a review of cost incurred date to ensure costs charged to the grant are within the award's start and end date. Explanation There is no disagreement with this audit finding. Action Plan The City concurs with the finding. The City of Santa Fe is in the process of implementing a Grants Service Division to oversee the financial and accounting management of all City federal grant programs and their awarded funds per 2 CFR 200 Uniform Administrative, Cost Principals, and Audit Requirements for Federal Awards, Federal Program Handbooks & Guidelines, and State & City policies and procedures in regards to grant financial management, government accounting standards, and required reports for submission. The newly created Grants Division will consist of an experienced and professional grant accounting staff that are knowledgeable with the Federal Grant Lifecycle (Pre-Award Phase, Award Phase, and Post Award Phase). The newly created Grants Bureau will prepare monthly grant fund reconciliations, track allowable grant expenditures and revenue reimbursements as it pertains to the grant?s period of performance, ensure federal compliance, and prepare timely required federal reports. The City of Santa Fe is also in the process of upgrading their current accounting, finance, and grant system. The upgrade of the Tyler Munis Financial system will provide much improved grant accounting tracking and reporting capabilities for all City federal programs and their funds. The Munis upgrade contains modules for project grant accounting, general billing/invoicing, and cash management. The new Grants Division will have internal controls and separation of duties in place regarding federal reimbursements and drawdowns which can be tracked in Munis Financials. This process will be documented in the City?s policies and procedures. The described process will be implemented by June 2021. Responsible Party (s) Alexandra Ladd Affordable Housing Director, Regina Wheeler Public Works Director, Mary McCoy, Finance Director, Bradley Fluetsch, CFA, Financial Planning and Reporting Officer, Debra Harris-Garmendia, Accounting Officer. Planned completion date June 2021
During our testing, we noted the City did not have adequate internal controls in place to ensure compliance with program income. ? The City was unable to provide two of five subrecipient folders for us to test program income. ? For one of the draws with a corresponding receipt, we noted the subrecipient folder did contain the quarterly reports submitted by the subrecipient to the City. However, the folder did not contain other documentation as specified by HUD to verify that the amount of program income corresponds to the information reported in the quarterly reports. ? Three of three subrecipient folders did not contain evidence of an annual site visit of the subrecipient by the City. ? We were provided with a Program Income Report submitted by a subrecipient to the City noting program income amounts for quarters 3 and 4 totaling an approximate of $239,482 were not included in the IDIS - PR09 Program Income Details by Fiscal Year and Program for time period of 07-01-2018 to 06-30-2019. Also, we did not note the program income amounts included in the IDIS - PR09 Program Income Details by Fiscal Year and Program for time period of 07-01-2019 to 12-31-2019.
2019-015 Program Income (Material Weakness and Material Noncompliance) Federal Program: Community Development Block Grants/Entitlement Grants (CDBG) CFDA Number: 14.218 Recommendation We recommend the City review the HUD's Monitoring Correspondence to gain an understanding of HUD's requirements related to program income. We recommend the City design controls to ensure the City meets compliance with the HUD's requirements of program income. Explanation There is no disagreement with this audit finding. Action Plan The City concurs with the finding. The City of Santa Fe is in the process of implementing a Grants Service Division to oversee the financial and accounting management of all City federal grant programs and their awarded funds per 2 CFR 200 Uniform Administrative, Cost Principals, and Audit Requirements for Federal Awards, Federal Program Handbooks & Guidelines, and State & City policies and procedures in regards to grant financial management, government accounting standards, and required reports for submission. The newly created Grants Division will consist of an experienced and professional grant accounting staff that are knowledgeable with the Federal Grant Lifecycle (Pre-Award Phase, Award Phase, and Post Award Phase). The newly created Grants Bureau will prepare monthly grant fund reconciliations, track allowable grant expenditures and revenue reimbursements as it pertains to the grant?s period of performance, ensure federal compliance, and prepare timely required federal reports. The City of Santa Fe is also in the process of upgrading their current accounting, finance, and grant system. The upgrade of the Tyler Munis Financial system will provide much improved grant accounting tracking and reporting capabilities for all City federal programs and their funds. The Munis upgrade contains modules for project grant accounting, general billing/invoicing, and cash management. The new Grants Division will have internal controls and separation of duties in place regarding federal reimbursements and drawdowns which can be tracked in Munis Financials. This process will be documented in the City?s policies and procedures. The described process will be implemented by June 2021. Responsible Party (s) Alexandra Ladd Affordable Housing Director, Regina Wheeler Public Works Director, Mary McCoy, Finance Director, Bradley Fluetsch, CFA, Financial Planning and Reporting Officer, Debra Harris-Garmendia, Accounting Officer. Planned completion date June 2021
During our testing, we noted the City did not have adequate internal controls in place to ensure compliance with special tests and provisions. Citizen Participation Plan ? The City does not have a Citizen Participation Plan (the Plan). The City has a summary of and reference to the Plan in its 2018 ? 2022 Consolidated Plan. However, it does not have a separate written Citizen Participation Plan setting forth the City?s policies and procedures for citizen participation. Required Certifications and HUD Approvals ? For three of four projects, we were not provided with the Request for Release of Funds (RROF) or HUD's approval of the RROF. For one of four projects, we were provided with the RROF. However, we did not note HUD's approval on the RROF. Environmental Reviews ? For five of five subrecipient folders reviewed, we did not note a completed environmental review. We noted a reference to a 2018-2019 ERR Binder. However, the 2018-2019 ERR Binder was not provided to us. ? For five of five subrecipient folders reviewed, we did not note written documentation that the review was not required.
2019-016 Special Tests and Provisions (Material Weakness and Material Noncompliance) Federal Program: Community Development Block Grants/Entitlement Grants (CDBG) CFDA Number: 14.218 Recommendation We recommend the City review the Compliance Supplement published by the Office of Management and Budget (OMB) and referenced Federal regulations to gain an understanding of the Federal requirements related to applicable special tests and provisions. Explanation There is no disagreement with this audit finding. Action Plan The City concurs with the finding. The City of Santa Fe is in the process of implementing a Grants Service Division to oversee the financial and accounting management of all City federal grant programs and their awarded funds per 2 CFR 200 Uniform Administrative, Cost Principals, and Audit Requirements for Federal Awards, Federal Program Handbooks & Guidelines, and State & City policies and procedures in regards to grant financial management, government accounting standards, and required reports for submission. The newly created Grants Division will consist of an experienced and professional grant accounting staff that are knowledgeable with the Federal Grant Lifecycle (Pre-Award Phase, Award Phase, and Post Award Phase). The newly created Grants Bureau will prepare monthly grant fund reconciliations, track allowable grant expenditures and revenue reimbursements as it pertains to the grant?s period of performance, ensure federal compliance, and prepare timely required federal reports. The recommendation to review the Compliance Supplement for each program where available will be incorporated into the updated grant procedures. The City of Santa Fe is also in the process of upgrading their current accounting, finance, and grant system. The upgrade of the Tyler Munis Financial system will provide much improved grant accounting tracking and reporting capabilities for all City federal programs and their funds. The Munis upgrade contains modules for project grant accounting, general billing/invoicing, and cash management. The new Grants Division will have internal controls and separation of duties in place regarding federal reimbursements and drawdowns which can be tracked in Munis Financials. This process will be documented in the City?s policies and procedures. The described process will be implemented by June 2021. Responsible Party (s) Alexandra Ladd Affordable Housing Director, Regina Wheeler Public Works Director, Mary McCoy, Finance Director, Debra Harris-Garmendia, Accounting Officer. Planned completion date June 2021
GSA_MIGRATION
GSA_MIGRATION
GSA_MIGRATION
GSA_MIGRATION
GSA_MIGRATION
GSA_MIGRATION
Data source: This information comes from the Federal Audit Clearinghouse, the official repository of Single Audit data. All data is public domain. Verify this organization's audit history at fac.gov.
Track your findings and corrective action plans across audit cycles.
Start tracking findings →Monitor subrecipient audit findings and compliance status.
Start monitoring →Single Audit Intelligence is an independent tool powered by Federal Audit Clearinghouse data. Not affiliated with GSA, OMB, or any federal agency.