Finding 374330 (2023-006)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-03-07

AI Summary

  • Core Issue: Bank reconciliations for the general fund were not regularly matched with the general ledger, leading to potential reporting errors.
  • Impacted Requirements: Lack of independent review of reconciliations raises concerns about proper segregation of duties and accuracy in interfund accounts.
  • Recommended Follow-Up: Implement monthly reconciliations with independent reviews, ensuring all discrepancies are addressed promptly and documented with signatures.

Finding Text

Conditions and Criteria: During the audit we noticed that the bank reconciliations for the general fund checking account were not being reconciled against the District’s general ledger software on a regular basis. In addition, we noticed that the business manager prepares the bank reconciliations during the year, however, there is no evidence of review. During the year ended June 30, 2023, we noticed general ledgeraccounts, specifically interfund receivable and payable were not being reconciled on a regular basis. Differences that existed throughout the fiscal year were specifically related to payroll expenditures and withholdings related to the Food Service Fund and General Fund. Effect: The effect of not preparing bank reconciliations that are reconciled against the District’s general ledger is that reporting errors in the recording of cash receipts, cash disbursements and wire transfers can occur and not be detected or resolved in a timely manner. In addition, because the business manager has access to the general ledger throughout the year, evidence of a review is important to demonstrate proper segregation of duties. The effect of not reconciling interfund receivable and payable accounts for all governmental funds on a consistent basis allowed the accounts to not equal in the aggregate. Interfund receivable and payable accounts were reconciled at the time of the audit. Auditors’ Recommendation: We recommend that as part of preparing monthly bank reconciliations, the reconciliation with the balance from the general ledger should be performed. Any differences should be immediately investigated and corrected. Once completed, the reconciliation should be reviewed by someone independent of the preparer. Both, the individual preparing and reviewing the bank reconciliations should sign or initial and date the reconciliation when completed. We recommend that the District incorporate procedures to ensure that such general ledger accounts are reconciled on a monthly basis. It is important that a dual accounting system is utilized in each individual fund and transactions between funds should be booked through the interfund receivables and payables. School District’s Response: The District will ensure that bank reconciliations are prepared on a timely basis throughout the year, which includes a reconciliation to the general ledger. The District will have the Superintendent review bank reconciliations. Once completed, the preparer and reviewer will sign and date each reconciliation to evidence their completion. Lastly, the District will reconcile due to/due from accounts on a monthly basis.

Categories

Reporting School Nutrition Programs Internal Control / Segregation of Duties

Other Findings in this Audit

  • 374298 2023-004
    Material Weakness Repeat
  • 374299 2023-004
    Material Weakness Repeat
  • 374300 2023-004
    Material Weakness Repeat
  • 374301 2023-004
    Material Weakness Repeat
  • 374302 2023-004
    Material Weakness Repeat
  • 374303 2023-004
    Material Weakness Repeat
  • 374304 2023-004
    Material Weakness Repeat
  • 374305 2023-004
    Material Weakness Repeat
  • 374306 2023-004
    Material Weakness Repeat
  • 374307 2023-004
    Material Weakness Repeat
  • 374308 2023-004
    Material Weakness Repeat
  • 374309 2023-004
    Material Weakness Repeat
  • 374310 2023-004
    Material Weakness Repeat
  • 374311 2023-004
    Material Weakness Repeat
  • 374312 2023-004
    Material Weakness Repeat
  • 374313 2023-005
    Material Weakness Repeat
  • 374314 2023-005
    Material Weakness Repeat
  • 374315 2023-005
    Material Weakness Repeat
  • 374316 2023-005
    Material Weakness Repeat
  • 374317 2023-005
    Material Weakness Repeat
  • 374318 2023-005
    Material Weakness Repeat
  • 374319 2023-005
    Material Weakness Repeat
  • 374320 2023-005
    Material Weakness Repeat
  • 374321 2023-005
    Material Weakness Repeat
  • 374322 2023-005
    Material Weakness Repeat
  • 374323 2023-005
    Material Weakness Repeat
  • 374324 2023-005
    Material Weakness Repeat
  • 374325 2023-005
    Material Weakness Repeat
  • 374326 2023-005
    Material Weakness Repeat
  • 374327 2023-005
    Material Weakness Repeat
  • 374328 2023-006
    Material Weakness Repeat
  • 374329 2023-006
    Material Weakness Repeat
  • 374331 2023-006
    Material Weakness Repeat
  • 374332 2023-006
    Material Weakness Repeat
  • 374333 2023-006
    Material Weakness Repeat
  • 374334 2023-006
    Material Weakness Repeat
  • 374335 2023-006
    Material Weakness Repeat
  • 374336 2023-006
    Material Weakness Repeat
  • 374337 2023-006
    Material Weakness Repeat
  • 374338 2023-006
    Material Weakness Repeat
  • 374339 2023-006
    Material Weakness Repeat
  • 374340 2023-006
    Material Weakness Repeat
  • 374341 2023-006
    Material Weakness Repeat
  • 374342 2023-006
    Material Weakness Repeat
  • 950740 2023-004
    Material Weakness Repeat
  • 950741 2023-004
    Material Weakness Repeat
  • 950742 2023-004
    Material Weakness Repeat
  • 950743 2023-004
    Material Weakness Repeat
  • 950744 2023-004
    Material Weakness Repeat
  • 950745 2023-004
    Material Weakness Repeat
  • 950746 2023-004
    Material Weakness Repeat
  • 950747 2023-004
    Material Weakness Repeat
  • 950748 2023-004
    Material Weakness Repeat
  • 950749 2023-004
    Material Weakness Repeat
  • 950750 2023-004
    Material Weakness Repeat
  • 950751 2023-004
    Material Weakness Repeat
  • 950752 2023-004
    Material Weakness Repeat
  • 950753 2023-004
    Material Weakness Repeat
  • 950754 2023-004
    Material Weakness Repeat
  • 950755 2023-005
    Material Weakness Repeat
  • 950756 2023-005
    Material Weakness Repeat
  • 950757 2023-005
    Material Weakness Repeat
  • 950758 2023-005
    Material Weakness Repeat
  • 950759 2023-005
    Material Weakness Repeat
  • 950760 2023-005
    Material Weakness Repeat
  • 950761 2023-005
    Material Weakness Repeat
  • 950762 2023-005
    Material Weakness Repeat
  • 950763 2023-005
    Material Weakness Repeat
  • 950764 2023-005
    Material Weakness Repeat
  • 950765 2023-005
    Material Weakness Repeat
  • 950766 2023-005
    Material Weakness Repeat
  • 950767 2023-005
    Material Weakness Repeat
  • 950768 2023-005
    Material Weakness Repeat
  • 950769 2023-005
    Material Weakness Repeat
  • 950770 2023-006
    Material Weakness Repeat
  • 950771 2023-006
    Material Weakness Repeat
  • 950772 2023-006
    Material Weakness Repeat
  • 950773 2023-006
    Material Weakness Repeat
  • 950774 2023-006
    Material Weakness Repeat
  • 950775 2023-006
    Material Weakness Repeat
  • 950776 2023-006
    Material Weakness Repeat
  • 950777 2023-006
    Material Weakness Repeat
  • 950778 2023-006
    Material Weakness Repeat
  • 950779 2023-006
    Material Weakness Repeat
  • 950780 2023-006
    Material Weakness Repeat
  • 950781 2023-006
    Material Weakness Repeat
  • 950782 2023-006
    Material Weakness Repeat
  • 950783 2023-006
    Material Weakness Repeat
  • 950784 2023-006
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.425 Covid-19 - Arp - Esser III $771,933
84.425 Covid-19 - Crrsa - Esser II $500,897
10.555 National School Lunch Program $171,791
84.010 Title I Part A $135,509
84.027 Idea Section 611 $68,355
10.553 National School Breakfast Program $56,173
84.358 Small Rural School Achievement Program $21,503
10.555 Covid-19 National School Lunch Program - Supply Chain Assistance $18,209
84.367 Title II - Improving Teacher Quality $14,188
10.555 School Lunch Program - Donated Commodities $13,190
84.027 Covid-19 - Arp -Idea Section 611 $12,139
84.424 Title IV - Student Support and Academic Enrichment $10,533
84.173 Idea Section 619 $840
10.649 Covid-19 - P-Ebt Administration Funds $628