Finding 583238 (2023-018)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2023-12-28

AI Summary

  • Core Issue: The District failed to record a June 2023 invoice of $1,620,380.99 for a ventilation project, leading to misstatements in financial reporting.
  • Impacted Requirements: This oversight violates Uniform Guidance §200.502 and GASB standards, resulting in understated expenditures in the Grants Fund and government-wide activities.
  • Recommended Follow-Up: Conduct thorough reviews of significant payments at fiscal year-end to ensure proper recording of liabilities and compliance with reporting requirements.

Finding Text

Condition - The District did not accrue a June 2023 invoice totaling $1,620,380.99 for a ventilation project at the Spaulding Union High School funded through a Federal Education Stabilization Fund grant at June 30, 2023. An audit adjustment was proposed to correct this misstatement. Criteria - Uniform Guidance §200.502 states that “the determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” For financial statement reporting in the fund financial statements as prescribed by the GASB “expenditures should be recognized in the accounting period in which the fund liability is incurred, if measurable.” Cause - This invoice was paid by the District on July 20, 2023 and was not recorded in the general ledger as a June 2023 expenditure but was instead recorded as a July 2023 expenditure. Effect - The Districts Grants Fund expenditures were understated by $1,620,380.99. The Schedule of Expenditures of Federal Awards presented for audit was also understated by $1,620,380.99. Lastly, capital assets in the government-wide governmental activities were understated by this same amount. Recommendation - We recommend a careful review of costs paid in the first quarter of a fiscal year or just prior to scheduled audit work. We would recommend that such a review include the review of significant amounts paid and verification that those costs are recorded in the proper fiscal year. The condition in this finding discussed previously was first identified by the auditor while performing a standard search for unrecorded liabilities by obtaining the subsequent year check register and reviewing invoice(s) supporting significant amounts paid and verifying that those costs were included in the proper period. Management’s response - In response to the finding indicated in the governance letter, management recognizes that the physical work performed for this expense occurred in FY23, but this is also an ongoing project and the period of performance for the ARP ESSER grant ends on 9/30/2024 not 6/30/23. Therefore, Management believes their interpretation is also correct. All federal and state grants with a period of performance ending 6/30/23 were accrued back to FY23 ensuring payments and receipts activities were in the correct time frame. Final reimbursement was requested, and the grants were closed out. The implementation of our new financial system also added an extra layer of complexity to our end of year accounting. Work in 2 different systems that do not work cohesively with each other was very challenging. We respect and appreciate the work of our auditors and understand that at times we will disagree and interpret things differently, which is what happened in regard to the expense for the HVAC project surrounding the "period of performance" language.

Categories

Reporting Cash Management Period of Performance

Other Findings in this Audit

  • 6796 2023-018
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425U Education Stabilization Program $3.63M
84.425D Education Stabilization Program $2.07M
84.010 Title I Grants to Local Educational Agencies $1.14M
84.424 Student Support and Academic Enrichment Program $376,632
84.367 Supporting Effective Instruction State Grant $307,700
10.553 School Breakfast Program $247,827
84.027 Special Education_grants to States $145,113
10.559 Summer Food Service Program for Children $94,335
10.555 National School Lunch Program $63,492
93.959 Block Grants for Prevention and Treatment of Substance Abuse $45,000
10.582 Fresh Fruit and Vegetable Program $44,624
12.U01 Junior Rotc - Salary Assistance $39,280
93.575 Child Care and Development Block Grant $21,229
84.425W Education Stabilization Program $17,358
84.173 Special Education_preschool Grants $13,379
10.649 Pandemic Ebt Administrative Costs $628