Audit 317065

FY End
2021-06-30
Total Expended
$2.62M
Findings
4
Programs
10
Organization: Luna County (NM)
Year: 2021 Accepted: 2024-08-12
Auditor: Cordova CPAS LLC

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
480951 2021-006 Significant Deficiency Yes L
480952 2021-004 Significant Deficiency Yes A
1057393 2021-006 Significant Deficiency Yes L
1057394 2021-004 Significant Deficiency Yes A

Contacts

Name Title Type
SFBFXJFCCEB3 Joanne Hethcox Auditee
5755460494 Rufino Rodriguez Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal grant activity of Luna County and is presented on the modified accrual basis of accounting, which is the same basis as was used to prepare the fund financial statements. The information in this Schedule is presented in accordance with the requirements of Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of the financial statements. De Minimis Rate Used: N Rate Explanation: The County did not elect to use the allowed 10% indirect cost rate.

Finding Details

2021‐006 (2019‐006) — SF‐425 Reports (Significant Deficiency) (Repeat/Modified) Federal program information: Funding agency: U.S. Department Homeland Security Title: Operation Stonegarden Federal Assistance number: 97.067 Compliance Requirement Reporting Award Period: July 1, 2020 to June 30, 2021 Condition: During our testwork of the Stonegarden program we noted the following:  For the 2019 and 2018 grants, there were two quarterly reports out of six that were not submitted by the due date required.  The quarterly report’s expenditures did not match the expenditures of the general ledger in total for a variance of $13,619.  The program’s revenues were $12,540 more than the expenditures on the trial balance. The County made progress in filing SF-425’s during fiscal year 2021. However, will implement additional internal controls to ensure reports are complete and accurate. Criteria: The SF-425 quarterly reports should be submitted within the required time period after the end of the reporting period, which is 30 days, and should agree to the general ledger. Grant accounting requires the program revenues to equal the program’s expenditures. Questioned Costs: None. Effect: SF-425 reports for the Stonegarden program were not submitted by the required due dates and some of the amounts reported were not correctly matching the general ledger amounts. Cause: The County had turnover in the management of this program and the position wasn’t filled until the middle of the previous fiscal year and the program manager had to go through the documents to know what amounts needed to be reported and as the County was far behind on their reporting it took multiple months for the County to catch up which resulted in the two late reports in the current fiscal year; one for grant 2019 and one for grant 2018. For the amounts reported not matching the general ledger and revenue not equaling expenditures, the reason for this is both a timing issue and there not being a proper reconciliation process in place when report amounts are submitted to the granting agency and when recording amounts in the general ledger. Auditor’s Recommendations: We recommend that there be a reconciliation with the Stonegarden program and with Finance to ensure that the amounts reported in the quarterly reports match the amounts reported on the general ledger and that the County cross-train someone to ensure that if there is turnover again for the program, there is someone who can submit the reports until someone else has been hired to fill the position. Agency’s Response: Luna County continues to improve grant management of these funds and in getting billing and reporting done on a consistent and timely basis. Reporting is currently being prepared and submitted on a quarterly basis for each grant cycle we have open. Reporting is also being prepared throughout the grant cycle to include modifications of Ops Orders, RFA’s and grant progress and closing reports. We are also reviewing a cross-training implementation to ensure that should we have turnover within that department there will be someone able to pick up the grant to continue to monitor and work it without delays. The finance department will be responsible for this issue and internal controls will be implemented in fiscal year 2022. 140
2021‐004 (2020‐005) — High Intensity Drug Trafficking Areas (HIDTA) Overtime Violation (Significant Deficiency) (Repeated) Condition: During the fiscal year June 30, 2021, the County had one employee who was paid more than the allowed amount of overtime per the HIDTA Maximum Overtime amounts requirement. This individual was paid a total of $30,941 in overtime from multiple programs, however this is more than the allowed amount of $21,720 which is 25% of the maximum amount of a GS-12’s salary of $86,881. There was no management progress during fiscal year 2021. Criteria: The HIDTA Program Policy and Budget Guidance and their Office of National Drug Control Policy 7.12.2 Maximum Overtime Amounts states that: “HIDTA-funded annual overtime for individual state, local, and tribal law enforcement officers and uniformed Federal agents shall not exceed the lower of: (1) applicable state, local, and tribal regulations of officer’s parent agency; or (2) 25 percent of the Federal GS-12, Step 1 level pay scale for “Rest of U.S.” in the law enforcement general schedule (GS) in effect at the beginning of the calendar year (CY), the parent agency’s FY, or other 12-month period selected by the parent agency. In addition, this reimbursable overtime rate is the maximum that an officer can receive during the current year, fiscal year, or other 12-month period from all Federal funding sources combined. As the cap on overtime from all Federal sources is imposed by other Federal agencies, including the Department of Justice (DOJ) and Department of Homeland Security (DHS), ONDCP has no authority to waive or increase Federal overtime authorized for HIDTA task force officers who will exceed the limit. Effect: The County is in violation of the HIDTA Overtime requirement. Cause: The County was not keeping track of the overtime being done in total for the HIDTA program. Auditor’s Recommendation: We recommend that the County implement a system to ensure that all law enforcement employees not have overtime pay over the required amount for each fiscal year Agency’s Response: Luna County management along with the Program Commander and Luna County Sheriff will monitor OT more closely to ensure that no employee exceeds the maximum allowable earnings. Luna County will be monitoring closely all Federal programs to ensure compliance with contract/award guidelines on combined OT limits. In addition, the one employee this affected is no longer an employee, however Luna County will continue due diligence to ensure that OT limits are strictly adhered to. Internal controls will be implemented during fiscal year 2022.
2021‐006 (2019‐006) — SF‐425 Reports (Significant Deficiency) (Repeat/Modified) Federal program information: Funding agency: U.S. Department Homeland Security Title: Operation Stonegarden Federal Assistance number: 97.067 Compliance Requirement Reporting Award Period: July 1, 2020 to June 30, 2021 Condition: During our testwork of the Stonegarden program we noted the following:  For the 2019 and 2018 grants, there were two quarterly reports out of six that were not submitted by the due date required.  The quarterly report’s expenditures did not match the expenditures of the general ledger in total for a variance of $13,619.  The program’s revenues were $12,540 more than the expenditures on the trial balance. The County made progress in filing SF-425’s during fiscal year 2021. However, will implement additional internal controls to ensure reports are complete and accurate. Criteria: The SF-425 quarterly reports should be submitted within the required time period after the end of the reporting period, which is 30 days, and should agree to the general ledger. Grant accounting requires the program revenues to equal the program’s expenditures. Questioned Costs: None. Effect: SF-425 reports for the Stonegarden program were not submitted by the required due dates and some of the amounts reported were not correctly matching the general ledger amounts. Cause: The County had turnover in the management of this program and the position wasn’t filled until the middle of the previous fiscal year and the program manager had to go through the documents to know what amounts needed to be reported and as the County was far behind on their reporting it took multiple months for the County to catch up which resulted in the two late reports in the current fiscal year; one for grant 2019 and one for grant 2018. For the amounts reported not matching the general ledger and revenue not equaling expenditures, the reason for this is both a timing issue and there not being a proper reconciliation process in place when report amounts are submitted to the granting agency and when recording amounts in the general ledger. Auditor’s Recommendations: We recommend that there be a reconciliation with the Stonegarden program and with Finance to ensure that the amounts reported in the quarterly reports match the amounts reported on the general ledger and that the County cross-train someone to ensure that if there is turnover again for the program, there is someone who can submit the reports until someone else has been hired to fill the position. Agency’s Response: Luna County continues to improve grant management of these funds and in getting billing and reporting done on a consistent and timely basis. Reporting is currently being prepared and submitted on a quarterly basis for each grant cycle we have open. Reporting is also being prepared throughout the grant cycle to include modifications of Ops Orders, RFA’s and grant progress and closing reports. We are also reviewing a cross-training implementation to ensure that should we have turnover within that department there will be someone able to pick up the grant to continue to monitor and work it without delays. The finance department will be responsible for this issue and internal controls will be implemented in fiscal year 2022. 140
2021‐004 (2020‐005) — High Intensity Drug Trafficking Areas (HIDTA) Overtime Violation (Significant Deficiency) (Repeated) Condition: During the fiscal year June 30, 2021, the County had one employee who was paid more than the allowed amount of overtime per the HIDTA Maximum Overtime amounts requirement. This individual was paid a total of $30,941 in overtime from multiple programs, however this is more than the allowed amount of $21,720 which is 25% of the maximum amount of a GS-12’s salary of $86,881. There was no management progress during fiscal year 2021. Criteria: The HIDTA Program Policy and Budget Guidance and their Office of National Drug Control Policy 7.12.2 Maximum Overtime Amounts states that: “HIDTA-funded annual overtime for individual state, local, and tribal law enforcement officers and uniformed Federal agents shall not exceed the lower of: (1) applicable state, local, and tribal regulations of officer’s parent agency; or (2) 25 percent of the Federal GS-12, Step 1 level pay scale for “Rest of U.S.” in the law enforcement general schedule (GS) in effect at the beginning of the calendar year (CY), the parent agency’s FY, or other 12-month period selected by the parent agency. In addition, this reimbursable overtime rate is the maximum that an officer can receive during the current year, fiscal year, or other 12-month period from all Federal funding sources combined. As the cap on overtime from all Federal sources is imposed by other Federal agencies, including the Department of Justice (DOJ) and Department of Homeland Security (DHS), ONDCP has no authority to waive or increase Federal overtime authorized for HIDTA task force officers who will exceed the limit. Effect: The County is in violation of the HIDTA Overtime requirement. Cause: The County was not keeping track of the overtime being done in total for the HIDTA program. Auditor’s Recommendation: We recommend that the County implement a system to ensure that all law enforcement employees not have overtime pay over the required amount for each fiscal year Agency’s Response: Luna County management along with the Program Commander and Luna County Sheriff will monitor OT more closely to ensure that no employee exceeds the maximum allowable earnings. Luna County will be monitoring closely all Federal programs to ensure compliance with contract/award guidelines on combined OT limits. In addition, the one employee this affected is no longer an employee, however Luna County will continue due diligence to ensure that OT limits are strictly adhered to. Internal controls will be implemented during fiscal year 2022.