Finding 1092671 (2024-006)

Material Weakness
Requirement
A
Questioned Costs
$1
Year
2024
Accepted
2024-12-20

AI Summary

  • Core Issue: The District reported budgeted costs instead of actual expenditures for ESSER II, leading to inaccuracies in the final expenditure report.
  • Impacted Requirements: The submission of $7,875 in questioned costs raises the risk of repayment due to non-compliance with allowable costs reporting.
  • Recommended Follow-Up: Reconcile budgeted amounts with general ledger totals and ensure accuracy in expenditure reports before future submissions.

Finding Text

Criteria: Allowable Costs/Activites Allowed. The District is required to report allowable costs/activities allowed based on the grant, the grant budget and for the period of the grant. Condition: The District submitted budgeted expenditures for reimbursement instead of actual expenditures for ESSER II. Questioned Costs: The questioned cost is $7,875: $3,598 in 2540-300 and $4,277 in 2540-500. Context: The District budgeted $32,380 for 27 camera licenses in 2540-300 and $27,317 for 17 indoor cameras, 11 outdoor cameras, and $488 shipping and handling in 2540-500 for a total of $59,697. These budgeted items were present on one invoice. The actual total on the invoice was $51,822, as the District only purchased 24 camera licenses, 17 indoor cameras, 9 outdoor cameras, and the shipping and handling was only $408. The cost as estimated on the budget was the amount reported as of the 11/30/23 expenditure report, which is the final report. Effect: There is an increased risk that these funds will be subject to repayment as they were incorrectly submitted for reimbursement. The District did not file an accurate final expenditure report at 11/30/23. Cause: The District purchased less cameras and licenses than budgeted, but mistakenly picked up the budgeted total on the 11/30/23 expenditure report. Recommendation: We recommend reconciling the budgeted amount to the general ledger totals and reconciling those to expenditure reports before submitting. Management's Response: The District will review the budgeted cost of items and the amount recorded in the general ledger against the expenditure reports before submitting.

Categories

Questioned Costs Procurement, Suspension & Debarment Allowable Costs / Cost Principles Cash Management

Other Findings in this Audit

  • 516225 2024-008
    Significant Deficiency Repeat
  • 516226 2024-009
    Significant Deficiency Repeat
  • 516227 2024-009
    Significant Deficiency Repeat
  • 516228 2024-005
    Material Weakness Repeat
  • 516229 2024-006
    Material Weakness
  • 516230 2024-008
    Significant Deficiency Repeat
  • 516231 2024-009
    Significant Deficiency Repeat
  • 516232 2024-010
    Significant Deficiency
  • 516233 2024-007
    Significant Deficiency Repeat
  • 516234 2024-008
    Significant Deficiency Repeat
  • 516235 2024-009
    Significant Deficiency Repeat
  • 516236 2024-003
    Material Weakness
  • 516237 2024-002
    - Repeat
  • 516238 2024-002
    - Repeat
  • 516239 2024-004
    Material Weakness
  • 516240 2024-002
    - Repeat
  • 516241 2024-002
    - Repeat
  • 1092667 2024-008
    Significant Deficiency Repeat
  • 1092668 2024-009
    Significant Deficiency Repeat
  • 1092669 2024-009
    Significant Deficiency Repeat
  • 1092670 2024-005
    Material Weakness Repeat
  • 1092672 2024-008
    Significant Deficiency Repeat
  • 1092673 2024-009
    Significant Deficiency Repeat
  • 1092674 2024-010
    Significant Deficiency
  • 1092675 2024-007
    Significant Deficiency Repeat
  • 1092676 2024-008
    Significant Deficiency Repeat
  • 1092677 2024-009
    Significant Deficiency Repeat
  • 1092678 2024-003
    Material Weakness
  • 1092679 2024-002
    - Repeat
  • 1092680 2024-002
    - Repeat
  • 1092681 2024-004
    Material Weakness
  • 1092682 2024-002
    - Repeat
  • 1092683 2024-002
    - Repeat

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $454,562
84.010 Title I Grants to Local Educational Agencies $233,568
10.553 National School Lunch Program $64,248
93.778 Medical Assistance Program $30,354
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $26,707
84.424 Student Support and Academic Enrichment Program $26,457
84.027 Special Education Grants to States $25,236
84.358 Rural Education $19,957
10.555 National School Lunch Program $14,676
84.173 Special Education Preschool Grants $2,558
10.649 Pandemic Ebt Administrative Costs $653
84.048 Career and Technical Education -- Basic Grants to States $325