Finding 586406 (2023-004)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-01-25

AI Summary

  • Core Issue: There is a lack of proper segregation of duties in cash handling and payroll processes, increasing the risk of errors and fraud.
  • Impacted Requirements: Effective internal controls require distinct roles for authorizing, recording, and safeguarding transactions to ensure checks and balances.
  • Recommended Follow-Up: Implement monthly reconciliations of bank balances to the general ledger, maintain a cash receipts log, and have the Superintendent review payroll changes and disbursement checks regularly.

Finding Text

Segregation of Duties Year ended June 30, 2023 Condition and Criteria: Although there is a limited number of personnel in the business office, we noted that different functions within the cash receipts, cash disbursements and payroll cycles, along with the preparation of bank reconciliations are not properly segregated. Effect: A fundamental element of an effective internal control system is the proper segregation of duties. Proper segregation of duties provides for a system of checks and balances and entails assigning responsibilities of authorizing and recording transactions among different people in the District. Generally, assigning different individuals the responsibilities of authorizing transactions, recording transactions, and maintaining the custody of the related assets reduces the opportunities for any individual to both perpetrate and conceal errors or fraud in the normal course of business. Auditor’s recommendation: We recognize that the District has attempted to mitigate the lack of segregation of duties by having other individuals perform certain ancillary duties of record-keeping including: opening the mail; signing of checks; distribution of payroll and vendor checks; and bank reconciliations. These duties could be enhanced by having the individual responsible for the preparation of bank reconciliations compare the reconciled bank balances to the District’s general ledger software on a monthly basis, as currently reconciliations are compared against manual worksheets. In addition, we recommend that the individual responsible for opening mail also maintain a cash receipts log, with someone independent of the cash receipts function reconciling the log to the general ledger and bank statements at certain times during the year. For mitigating controls over the District’s payroll, the District should consider having the Superintendent review a monthly change report showing any changes in pay rates or employees. Finally, for controls over cash disbursements, the Board should account for the sequence of checks for each disbursement register to ensure that all checks are being reviewed. In addition a report should be generated that documents any new vendors added to the payable module. This report could be approved monthly by the Superintendent. District’s Response: The District understands the importance of having strong segregation of duties and will attempt to separate certain responsibilities as outlined above.

Categories

Internal Control / Segregation of Duties

Other Findings in this Audit

  • 9941 2023-003
    Material Weakness Repeat
  • 9942 2023-004
    Material Weakness Repeat
  • 9943 2023-003
    Material Weakness Repeat
  • 9944 2023-004
    Material Weakness Repeat
  • 9945 2023-003
    Material Weakness Repeat
  • 9946 2023-004
    Material Weakness Repeat
  • 9947 2023-003
    Material Weakness Repeat
  • 9948 2023-004
    Material Weakness Repeat
  • 9949 2023-003
    Material Weakness Repeat
  • 9950 2023-004
    Material Weakness Repeat
  • 9951 2023-003
    Material Weakness Repeat
  • 9952 2023-004
    Material Weakness Repeat
  • 9953 2023-003
    Material Weakness Repeat
  • 9954 2023-004
    Material Weakness Repeat
  • 9955 2023-003
    Material Weakness Repeat
  • 9956 2023-004
    Material Weakness Repeat
  • 9957 2023-003
    Material Weakness Repeat
  • 9958 2023-004
    Material Weakness Repeat
  • 9959 2023-003
    Material Weakness Repeat
  • 9960 2023-004
    Material Weakness Repeat
  • 9961 2023-003
    Material Weakness Repeat
  • 9962 2023-004
    Material Weakness Repeat
  • 9963 2023-003
    Material Weakness Repeat
  • 9964 2023-004
    Material Weakness Repeat
  • 9965 2023-003
    Material Weakness Repeat
  • 9966 2023-004
    Material Weakness Repeat
  • 9967 2023-003
    Material Weakness Repeat
  • 9968 2023-004
    Material Weakness Repeat
  • 9969 2023-003
    Material Weakness Repeat
  • 9970 2023-004
    Material Weakness Repeat
  • 9971 2023-003
    Material Weakness Repeat
  • 9972 2023-004
    Material Weakness Repeat
  • 9973 2023-003
    Material Weakness Repeat
  • 9974 2023-004
    Material Weakness Repeat
  • 586383 2023-003
    Material Weakness Repeat
  • 586384 2023-004
    Material Weakness Repeat
  • 586385 2023-003
    Material Weakness Repeat
  • 586386 2023-004
    Material Weakness Repeat
  • 586387 2023-003
    Material Weakness Repeat
  • 586388 2023-004
    Material Weakness Repeat
  • 586389 2023-003
    Material Weakness Repeat
  • 586390 2023-004
    Material Weakness Repeat
  • 586391 2023-003
    Material Weakness Repeat
  • 586392 2023-004
    Material Weakness Repeat
  • 586393 2023-003
    Material Weakness Repeat
  • 586394 2023-004
    Material Weakness Repeat
  • 586395 2023-003
    Material Weakness Repeat
  • 586396 2023-004
    Material Weakness Repeat
  • 586397 2023-003
    Material Weakness Repeat
  • 586398 2023-004
    Material Weakness Repeat
  • 586399 2023-003
    Material Weakness Repeat
  • 586400 2023-004
    Material Weakness Repeat
  • 586401 2023-003
    Material Weakness Repeat
  • 586402 2023-004
    Material Weakness Repeat
  • 586403 2023-003
    Material Weakness Repeat
  • 586404 2023-004
    Material Weakness Repeat
  • 586405 2023-003
    Material Weakness Repeat
  • 586407 2023-003
    Material Weakness Repeat
  • 586408 2023-004
    Material Weakness Repeat
  • 586409 2023-003
    Material Weakness Repeat
  • 586410 2023-004
    Material Weakness Repeat
  • 586411 2023-003
    Material Weakness Repeat
  • 586412 2023-004
    Material Weakness Repeat
  • 586413 2023-003
    Material Weakness Repeat
  • 586414 2023-004
    Material Weakness Repeat
  • 586415 2023-003
    Material Weakness Repeat
  • 586416 2023-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.425 Covid-19 - Arp, Esser III $671,811
10.555 National School Lunch Program $233,870
84.425 Covid-19 - Esser II $174,586
84.010 Title I $122,312
84.027 Idea $109,570
10.553 National School Breakfast Program $88,839
32.004 Universal Service Fund - School and Libraries (e-Rate) $60,475
84.358 Small, Rural School Achievement Program $32,316
84.027 Covid-19, Arp - Idea $25,132
10.555 National School Lunch Program - Non-Cash Assistance $24,365
10.555 Covid-19 - Supply Chain Assistance $23,545
84.367 Title Iia - Improving Teacher Quality $15,854
84.425 Covid-19 - Arp, Esser 7% - Learning Loss $14,575
84.424 Title IV - Student Support & Academic Enrichment $10,888
84.425 Covid-19 - Arp, Esser 7% - Summer Enrichment $5,236
10.649 Covid-19 - P-Ebt Local Admin Funds $628