Finding 480946 (2023-002)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-08-12
Audit: 317055
Organization: Town of Wilbraham, Ma (MA)
Auditor: Marcum LLP

AI Summary

  • Core Issue: The Town inaccurately reported $239,098 in expenditures for a project that occurred in a future fiscal year, violating federal reporting requirements.
  • Impacted Requirements: The Town failed to comply with OMB guidelines for annual performance reporting and internal controls over compliance.
  • Recommended Follow-Up: Implement reconciliation controls between the performance report and the general ledger before submission to ensure accuracy.

Finding Text

2023-002 Improve Oversight Over Reporting of Federal Awards (Significant Deficiency) Federal Agency: Department of the Treasury Cluster/Program: COVID-19 Coronavirus State and Local Fiscal Recovery Fund AL Number(s): 21.027 Award Year: 2023 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement A non-federal entity is required to submit a performance report annually using a form or format authorized by OMB (2 CFR section 200.329) based on expenditures reported in the Town’s general ledger. Management of the Town is also responsible for establishing and maintaining effective internal control over compliance with federal requirements that have a direct and material effect on a federal pro¬gram. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of per¬forming their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. Condition and Context In the March 2023 annual performance report, the Town reported expenditures of $239,098 for the MRHS switches project. These expenditures did not occur until fiscal year 2024 and should not have been reported.   2023-002 Improve Oversight Over Reporting of Federal Awards (Significant Deficiency) (Continued) Cause The Town has not established adequate procedures to ensure expenditures reported on the annual report agree with the Town’s general ledger. Effect or Potential Effect The Town is not in compliance with the Uniform Guidance requirements for reporting. Questioned Costs There are no questioned costs as a result of this finding, as these costs were allowable and did occur, but they were reported in the incorrect reporting period. Recommendation The Town should implement controls to ensure that reports are reconciled to the general ledger prior to submission. Views of Responsible Official Management agrees with the finding. Planned Corrective Action Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.

Corrective Action Plan

Audit Finding Reference: 2023-002 – Improve Oversight of Reporting of Federal Funds The March 2023 Annual Performance report showed an expense of $239,098 in FY2023 which was not actually expended until FY2024. The Town agrees with the finding. Planned Corrective Action: When the FY2023 report was filed, the expense in the wrong period was discovered. Efforts were made to try and correct this error prior to filing the FY2023 Report, but the system would not allow any corrections. The Town makes every effort to include the source documents that support the reports submitted, which is the way this was discovered prior to submitting the FY2023 report. The Town will continue this procedure to include the source documents (Trial Balances) which support the projects and amounts filed within the report. This will ensure that the General Ledger and the reports filed are in balance. The only corrective measure for this error will occur when the FY2024 Single Audit is prepared which shows the expense expended in FY2024.

Categories

Internal Control / Segregation of Duties Reporting Significant Deficiency Matching / Level of Effort / Earmarking

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.34M
97.044 Assistance to Firefighters Grant $110,131
97.083 Staffing for Adequate Fire and Emergency Response (safer) $86,096