Finding 2143 (2023-003)

Significant Deficiency Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2023-11-20

AI Summary

  • Core Issue: The District lacks effective internal controls to ensure the accuracy of the schedule of expenditures of federal awards.
  • Impacted Requirements: Management is responsible for preparing this schedule in line with the modified cash basis of accounting, which is currently not being met.
  • Recommended Follow-Up: Management should review auditor adjustments, ensure proper disclosures, and apply analytical procedures to the draft financial statements.

Finding Text

INTERNAL CONTROL OVER SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS PREPARATION AND REVIEW Criteria: As described in our engagement letter, management is responsible for establishing and maintaining internal controls, including monitoring, and for the fair presentation of the schedule of expenditures of federal awards, including the notes to the schedule of expenditures of federal awards, in conformity with the modified cash basis of accounting. Condition: The District does not have a system of internal control that would provide management with reasonable assurance that the District's schedule of expenditures of federal awards and related disclosures are complete and presented in accordance with the modified cash basis of accounting. As such, management requested us to compile the trial balance from the general ledger and prepare a draft of the schedule of expenditures of federal awards, including the related note disclosures. Cause: Management does not prepare the schedule of expenditures of federal awards in accordance with the modified cash basis of accounting. Potential Effect: The potential exists that a material misstatement of the schedule of expenditures of federal awards could occur and not be prevented or detected by the District's internal control. Recommendation: We recommend that the District review and approve the proposed auditor adjusting entries and the adequacy of schedule of the expenditures of federal awards disclosures prepared by the auditors and apply analytic procedures to the draft financial statements, among other procedures as considered necessary by management.

Corrective Action Plan

ESTABLISH INTERNAL CONTROL OVER FINANCIAL STATEMENT PREPARATION AND REVIEW Recommendation: The District should review and approve the proposed auditor adjusting entries and the adequacy of schedule of the expenditures of federal awards disclosures prepared by the auditors and apply analytic procedures to the draft financial statements, among other procedures as considered necessary by management. Action Taken: The District will prepare of schedule of federal expenditures based on expenditure categories as found in the District's general ledger and value of commodities for lunch program. This will be prepared using an excel spreadsheet. The District will review the audit adjustments as presented by the external auditors including those related to the federal expenditures and the related worksheet. We will ensure the adjustments made to federal award expenditures are appropriate by examining the nature and amount of the adjustments. Questionable items will be discussed and agreed upon between the District and the auditors. After review and approval of the entries, they will be input into the District's general ledger and the SEFA spreadsheet will be updated. This will be compared to the SEFA that is included in the audit report and if they are in agreement, this will be approved by management. All variances will be addressed prior to finalization of the audit report and submission to the Nebraska. If the Nebraska Department of Education has questions regarding this plan, please call Dr. Heather Nebesniak at 308.728.5013. Department of Education as well as to the Federal Audit Clearinghouse.

Categories

Subrecipient Monitoring Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 2144 2023-003
    Significant Deficiency Repeat
  • 2145 2023-003
    Significant Deficiency Repeat
  • 2146 2023-003
    Significant Deficiency Repeat
  • 2147 2023-003
    Significant Deficiency Repeat
  • 2148 2023-003
    Significant Deficiency Repeat
  • 2149 2023-003
    Significant Deficiency Repeat
  • 2150 2023-003
    Significant Deficiency Repeat
  • 2151 2023-003
    Significant Deficiency Repeat
  • 2152 2023-003
    Significant Deficiency Repeat
  • 2153 2023-003
    Significant Deficiency Repeat
  • 2154 2023-003
    Significant Deficiency Repeat
  • 2155 2023-003
    Significant Deficiency Repeat
  • 578585 2023-003
    Significant Deficiency Repeat
  • 578586 2023-003
    Significant Deficiency Repeat
  • 578587 2023-003
    Significant Deficiency Repeat
  • 578588 2023-003
    Significant Deficiency Repeat
  • 578589 2023-003
    Significant Deficiency Repeat
  • 578590 2023-003
    Significant Deficiency Repeat
  • 578591 2023-003
    Significant Deficiency Repeat
  • 578592 2023-003
    Significant Deficiency Repeat
  • 578593 2023-003
    Significant Deficiency Repeat
  • 578594 2023-003
    Significant Deficiency Repeat
  • 578595 2023-003
    Significant Deficiency Repeat
  • 578596 2023-003
    Significant Deficiency Repeat
  • 578597 2023-003
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $405,310
84.027 Special Education_grants to States $149,462
84.010 Title I Grants to Local Educational Agencies $100,105
84.358 Rural Education $37,089
10.555 National School Lunch Program $30,498
93.778 Medical Assistance Program $27,962
10.553 School Breakfast Program $24,898
84.367 Improving Teacher Quality State Grants $20,430
10.559 Summer Food Service Program for Children $10,948
84.173 Special Education_preschool Grants $3,237
10.574 Team Nutrition Grants $2,633