Finding 84712 (2022-005)

Material Weakness
Requirement
AB
Questioned Costs
$1
Year
2022
Accepted
2023-03-28

AI Summary

  • Core Issue: The School Corporation lacked an effective system of internal controls, leading to non-compliance with grant requirements and insufficient documentation for audit.
  • Impacted Requirements: Compliance with 2 CFR 200.303, 200.333, and 200.403 regarding internal controls, documentation retention, and allowable costs.
  • Recommended Follow-Up: Management should implement a robust internal control system to ensure proper documentation is maintained and available for audits related to grant activities and costs.

Finding Text

FINDING 2022-005 Subject: Title I Grants to Local Educational Agencies - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A190014, S010A200014, S010A210014 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 30 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context An effective system of internal controls was not designed nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Activities Allowed or Unallowed and the Allowable Costs/Cost Principles compliance requirements. The School Corporation had not established an effective system of internal controls to ensure that proper documentation was retained for audit. The School Corporation was unable to provide supporting documentation for one of five of the journal entries tested. For the one journal entry, we were unable to determine if the Title I fund transfers in, totaling $13,434, and transfers out, totaling $95,115, were for allowable activities and costs for the program. The lack of effective internal controls and the failure to retain supporting documentation was isolated to the transfers noted above. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal controls over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government" issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.333 (Uniform Guidance) states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass through entity in the case of a subrecipient. . . ." 2 CFR 200.334 (Revised Uniform Guidance) states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: INDIANA STATE BOARD OF ACCOUNTS 31 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . (g) Be adequately documented. . . ." Cause Management had not established an effective system of internal controls that would have ensured compliance, or that supporting documentation would have been maintained and made available for audit, related to the grant agreements and the Activities Allowed or Unallowed and the Allowable Costs/Cost Principles compliance requirements. Effect The failure to establish an effective system of internal controls and to retain and provide appropriate supporting documentation prevented the determination of the School Corporation's compliance with compliance requirements listed above. Questioned Costs Known questioned costs of $108,549 were identified, as detailed in Condition and Context. Recommendation We recommended that the School Corporation's management establish an effective system of internal controls to ensure documentation be maintained and made available for audit related to the grant agreement and the Activities Allowed or Unallowed and the Allowable Costs/Cost Principles compliance requirements. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Corrective Action Plan

FINDING 2022-005 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Instead of utilizing journal entries for corrections or adjustments in generic form, corrections to large or for multiple disbursements or receipts should be completed by reversing the action within the financial software and then correctly processing the disbursements or receipts. The on-going training and the related corrective actions which ensure more frequent and more in-depth reviews of reports on a monthly basis will also reduce the need for corrections in general. However, in the event there must be journal entries for corrections, documentation supporting and related to any journal entry will be input into the financial management software, as will any related notes, and any journal entry will have documented approval contained in that software, all completed by separate people ? the Treasurer and CFO. Additional, related training will also be sought to ensure related processes and controls are understood and followed. Anticipated Completion Date: May 2023

Categories

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring

Other Findings in this Audit

  • 84273 2022-003
    Material Weakness
  • 84274 2022-004
    Material Weakness Repeat
  • 84275 2022-003
    Material Weakness
  • 84276 2022-004
    Material Weakness Repeat
  • 84277 2022-003
    Material Weakness
  • 84278 2022-004
    Material Weakness Repeat
  • 84279 2022-003
    Material Weakness
  • 84280 2022-004
    Material Weakness Repeat
  • 84281 2022-003
    Material Weakness
  • 84282 2022-004
    Material Weakness Repeat
  • 84283 2022-003
    Material Weakness
  • 84284 2022-004
    Material Weakness Repeat
  • 84285 2022-003
    Material Weakness
  • 84286 2022-004
    Material Weakness Repeat
  • 84287 2022-003
    Material Weakness
  • 84288 2022-004
    Material Weakness Repeat
  • 84289 2022-003
    Material Weakness
  • 84290 2022-004
    Material Weakness Repeat
  • 84291 2022-010
    Material Weakness
  • 84292 2022-011
    Material Weakness
  • 84293 2022-012
    Material Weakness Repeat
  • 84294 2022-010
    Material Weakness
  • 84708 2022-011
    Material Weakness
  • 84709 2022-010
    Material Weakness
  • 84710 2022-011
    Material Weakness
  • 84711 2022-012
    Material Weakness Repeat
  • 84713 2022-006
    Material Weakness Repeat
  • 84714 2022-007
    Material Weakness
  • 84715 2022-008
    Material Weakness Repeat
  • 84716 2022-009
    Material Weakness Repeat
  • 84717 2022-005
    Material Weakness
  • 84718 2022-006
    Material Weakness Repeat
  • 84719 2022-007
    Material Weakness
  • 84720 2022-008
    Material Weakness Repeat
  • 84721 2022-009
    Material Weakness Repeat
  • 84722 2022-013
    Material Weakness
  • 84723 2022-014
    Material Weakness
  • 84724 2022-015
    Material Weakness
  • 84725 2022-016
    Material Weakness
  • 84726 2022-013
    Material Weakness
  • 84727 2022-014
    Material Weakness
  • 84728 2022-015
    Material Weakness
  • 84729 2022-016
    Material Weakness
  • 84730 2022-013
    Material Weakness
  • 84731 2022-014
    Material Weakness
  • 84732 2022-015
    Material Weakness
  • 84733 2022-016
    Material Weakness
  • 84734 2022-013
    Material Weakness
  • 84735 2022-014
    Material Weakness
  • 84736 2022-015
    Material Weakness
  • 84737 2022-016
    Material Weakness
  • 660715 2022-003
    Material Weakness
  • 660716 2022-004
    Material Weakness Repeat
  • 660717 2022-003
    Material Weakness
  • 660718 2022-004
    Material Weakness Repeat
  • 660719 2022-003
    Material Weakness
  • 660720 2022-004
    Material Weakness Repeat
  • 660721 2022-003
    Material Weakness
  • 660722 2022-004
    Material Weakness Repeat
  • 660723 2022-003
    Material Weakness
  • 660724 2022-004
    Material Weakness Repeat
  • 660725 2022-003
    Material Weakness
  • 660726 2022-004
    Material Weakness Repeat
  • 660727 2022-003
    Material Weakness
  • 660728 2022-004
    Material Weakness Repeat
  • 660729 2022-003
    Material Weakness
  • 660730 2022-004
    Material Weakness Repeat
  • 660731 2022-003
    Material Weakness
  • 660732 2022-004
    Material Weakness Repeat
  • 660733 2022-010
    Material Weakness
  • 660734 2022-011
    Material Weakness
  • 660735 2022-012
    Material Weakness Repeat
  • 660736 2022-010
    Material Weakness
  • 661150 2022-011
    Material Weakness
  • 661151 2022-010
    Material Weakness
  • 661152 2022-011
    Material Weakness
  • 661153 2022-012
    Material Weakness Repeat
  • 661154 2022-005
    Material Weakness
  • 661155 2022-006
    Material Weakness Repeat
  • 661156 2022-007
    Material Weakness
  • 661157 2022-008
    Material Weakness Repeat
  • 661158 2022-009
    Material Weakness Repeat
  • 661159 2022-005
    Material Weakness
  • 661160 2022-006
    Material Weakness Repeat
  • 661161 2022-007
    Material Weakness
  • 661162 2022-008
    Material Weakness Repeat
  • 661163 2022-009
    Material Weakness Repeat
  • 661164 2022-013
    Material Weakness
  • 661165 2022-014
    Material Weakness
  • 661166 2022-015
    Material Weakness
  • 661167 2022-016
    Material Weakness
  • 661168 2022-013
    Material Weakness
  • 661169 2022-014
    Material Weakness
  • 661170 2022-015
    Material Weakness
  • 661171 2022-016
    Material Weakness
  • 661172 2022-013
    Material Weakness
  • 661173 2022-014
    Material Weakness
  • 661174 2022-015
    Material Weakness
  • 661175 2022-016
    Material Weakness
  • 661176 2022-013
    Material Weakness
  • 661177 2022-014
    Material Weakness
  • 661178 2022-015
    Material Weakness
  • 661179 2022-016
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund Fy 22 $3.37M
10.555 National School Lunch Program Fy 22 $1.35M
10.555 National School Lunch Program Fy 21 $706,165
84.027 Special Education_grants to States Fy 21 $643,609
84.010 Title I Grants to Local Educational Agencies Fy 22 $556,128
84.010 Title I Grants to Local Educational Agencies Fy 21 $525,380
84.027 Special Education_grants to States Fy 22 $472,800
10.553 School Breakfast Program Fy 22 $348,509
94.006 Americorps Fy 22 $205,555
10.553 School Breakfast Program Fy 21 $199,694
94.006 Americorps Fy 21 $151,960
93.778 Medical Assistance Program Fy 22 $119,430
10.559 Summer Food Service Program for Children Fy 22 $115,185
84.367 Improving Teacher Quality State Grants Fy 21 $93,813
93.778 Medical Assistance Program Fy 21 $87,163
84.367 Improving Teacher Quality State Grants Fy 22 $62,499
84.425 Education Stabilization Fund Fy 21 $61,881
84.358 Rural Education Fy 21 $36,737
84.173 Special Education_preschool Grants Fy 21 $35,011
84.424 Student Support and Academic Enrichment Program Fy 21 $26,273
10.579 Child Nutrition Discretionary Grants Limited Availability Fy 21 $12,466
10.579 Child Nutrition Discretionary Grants Limited Availability Fy 22 $8,690
10.649 Pandemic Ebt Administrative Costs Fy 22 $3,063
10.559 Summer Food Service Program for Children Fy 21 $1,334