Finding 597170 (2022-004)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-02-22

AI Summary

  • Core Issue: There was a significant discrepancy of approximately $13.3 million in the general fund and $14.2 million in the payroll account due to unrecorded transfers in the general ledger.
  • Impacted Requirements: Monthly bank reconciliations were not aligned with the general ledger, leading to potential reporting errors that could go unnoticed.
  • Recommended Follow-Up: Implement a process to complete bank reconciliations by the end of each month, ensuring discrepancies are investigated and reviewed by an independent party.

Finding Text

Reconciliation of Cash Year ended June 30, 2022 Conditions and criteria: At the commencement of the audit a difference existed between the general fund checking bank statement reconciliation and general ledger cash balance in the amount of approximately $13.3 million, while the payroll checking account did not reconcile by $14.2 million. The majority of the differences were interrelated and consisted of transfers from the general fund checking to the payroll checking account that were not reflected in the general ledger. Other differences were related to a transfer to the PLGIT account in the amount of approximately $.6 million that was not reflected in the general ledger and amounts related to accounts payable. Adjustments to correct these differences were made during the audit resulting in an unreconciled difference of approximately $70,000. Cause and Effect: Although bank reconciliations were being prepared on a monthly basis, such reconciliations of the general fund were not agreed to the District?s general fund cash balances within the general ledger software. The effect of not comparing bank reconciliations against the District?s general ledger balance is that reporting errors in posting cash receipts and cash disbursements can occur and not be detected or resolved in a timely manner. Auditors? Recommendation: We recommend that the District prepare general fund bank reconciliations soon after the end of each month. As part of the reconciliation process the District?s general ledger cash balances should be compared against the bank reconciliation, with any differences being immediately investigated. Once complete, the bank reconciliation should be reviewed by someone independent of the preparer. School District?s response: The Business Manager has established a reconciliation schedule and began changing the process of the reconciliation of cash. This has been a work in process with continued staff turnover and very limited business office staff. This new timeline requires reconciliations to be completed by the end of the following month, and we have additional staff members reviewing them within the limitations of the Financial Software and its double entry process.

Categories

Reporting

Other Findings in this Audit

  • 20703 2022-003
    Material Weakness Repeat
  • 20704 2022-004
    Material Weakness Repeat
  • 20705 2022-003
    Material Weakness Repeat
  • 20706 2022-004
    Material Weakness Repeat
  • 20707 2022-003
    Material Weakness Repeat
  • 20708 2022-004
    Material Weakness Repeat
  • 20709 2022-003
    Material Weakness Repeat
  • 20710 2022-004
    Material Weakness Repeat
  • 20711 2022-003
    Material Weakness Repeat
  • 20712 2022-004
    Material Weakness Repeat
  • 20713 2022-003
    Material Weakness Repeat
  • 20714 2022-004
    Material Weakness Repeat
  • 20715 2022-003
    Material Weakness Repeat
  • 20716 2022-004
    Material Weakness Repeat
  • 20717 2022-003
    Material Weakness Repeat
  • 20718 2022-004
    Material Weakness Repeat
  • 20719 2022-003
    Material Weakness Repeat
  • 20720 2022-004
    Material Weakness Repeat
  • 20721 2022-003
    Material Weakness Repeat
  • 20722 2022-004
    Material Weakness Repeat
  • 20723 2022-003
    Material Weakness Repeat
  • 20724 2022-004
    Material Weakness Repeat
  • 20725 2022-003
    Material Weakness Repeat
  • 20726 2022-004
    Material Weakness Repeat
  • 20727 2022-003
    Material Weakness Repeat
  • 20728 2022-004
    Material Weakness Repeat
  • 20729 2022-003
    Material Weakness Repeat
  • 20730 2022-004
    Material Weakness Repeat
  • 20731 2022-003
    Material Weakness Repeat
  • 20732 2022-004
    Material Weakness Repeat
  • 26121 2022-003
    Material Weakness Repeat
  • 26122 2022-004
    Material Weakness Repeat
  • 26123 2022-003
    Material Weakness Repeat
  • 26124 2022-004
    Material Weakness Repeat
  • 26125 2022-003
    Material Weakness Repeat
  • 26126 2022-004
    Material Weakness Repeat
  • 26127 2022-003
    Material Weakness Repeat
  • 26128 2022-004
    Material Weakness Repeat
  • 26129 2022-003
    Material Weakness Repeat
  • 26130 2022-004
    Material Weakness Repeat
  • 26131 2022-003
    Material Weakness Repeat
  • 26132 2022-004
    Material Weakness Repeat
  • 597145 2022-003
    Material Weakness Repeat
  • 597146 2022-004
    Material Weakness Repeat
  • 597147 2022-003
    Material Weakness Repeat
  • 597148 2022-004
    Material Weakness Repeat
  • 597149 2022-003
    Material Weakness Repeat
  • 597150 2022-004
    Material Weakness Repeat
  • 597151 2022-003
    Material Weakness Repeat
  • 597152 2022-004
    Material Weakness Repeat
  • 597153 2022-003
    Material Weakness Repeat
  • 597154 2022-004
    Material Weakness Repeat
  • 597155 2022-003
    Material Weakness Repeat
  • 597156 2022-004
    Material Weakness Repeat
  • 597157 2022-003
    Material Weakness Repeat
  • 597158 2022-004
    Material Weakness Repeat
  • 597159 2022-003
    Material Weakness Repeat
  • 597160 2022-004
    Material Weakness Repeat
  • 597161 2022-003
    Material Weakness Repeat
  • 597162 2022-004
    Material Weakness Repeat
  • 597163 2022-003
    Material Weakness Repeat
  • 597164 2022-004
    Material Weakness Repeat
  • 597165 2022-003
    Material Weakness Repeat
  • 597166 2022-004
    Material Weakness Repeat
  • 597167 2022-003
    Material Weakness Repeat
  • 597168 2022-004
    Material Weakness Repeat
  • 597169 2022-003
    Material Weakness Repeat
  • 597171 2022-003
    Material Weakness Repeat
  • 597172 2022-004
    Material Weakness Repeat
  • 597173 2022-003
    Material Weakness Repeat
  • 597174 2022-004
    Material Weakness Repeat
  • 602563 2022-003
    Material Weakness Repeat
  • 602564 2022-004
    Material Weakness Repeat
  • 602565 2022-003
    Material Weakness Repeat
  • 602566 2022-004
    Material Weakness Repeat
  • 602567 2022-003
    Material Weakness Repeat
  • 602568 2022-004
    Material Weakness Repeat
  • 602569 2022-003
    Material Weakness Repeat
  • 602570 2022-004
    Material Weakness Repeat
  • 602571 2022-003
    Material Weakness Repeat
  • 602572 2022-004
    Material Weakness Repeat
  • 602573 2022-003
    Material Weakness Repeat
  • 602574 2022-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.425 Covid-19 Arp, Esser III $936,653
10.555 Covid-19 - National School Lunch Program - Seamless Summer Option $530,010
84.425 Covid-19 Esser II $475,564
84.010 Title I Part A $323,724
84.027 Idea 611 $295,249
10.553 Covid-19 - National School Breakfast Program - Seamless Summer Option $215,465
10.555 Covid-19 - Snp Emergency Operating Costs $56,772
84.367 Title Iia $45,470
10.555 School Lunch Program - Non-Cash Assistance $35,834
84.425 Covid-19 Arp, Esser 7% - Learning Loss $35,566
10.555 Covid-19 - Supply Chain Assistance $28,607
84.425 Covid-19 Esser1 $25,028
84.424 Title IV $24,386
93.778 Medical Assistance Administration $14,605
84.425 Covid-19 Arp, Esser 7% - Afterschool Programs $5,403
84.027 Covid-19 Secim $3,000
84.173 Idea 619 $2,030
84.425 Covid-19 Arp, Esser 7% - Summer Enrichment $1,565
10.649 Covid-19 - P-Ebt Local Admin Funds $614