Finding 48917 (2022-007)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
$1
Year
2022
Accepted
2023-03-30

AI Summary

  • Core Issue: Insufficient internal controls led to improper documentation of time and effort for federal grants, resulting in questioned costs exceeding $1 million.
  • Impacted Requirements: Compliance with 2 CFR 200.430 was not met, as records did not accurately reflect work performed and lacked necessary support.
  • Recommended Follow-Up: Management should reinforce internal controls and provide training to ensure consistent compliance moving forward.

Finding Text

2022 ? 007 ? Special Education Cluster (IDEA) Activities Allowed or Unallowed & Allowable Costs/Cost Principles Federal Agency: U.S. Department of Education Federal Program Title: Special Education Cluster (IDEA) Assistance Listing Number: 84.027/84.173 Federal Award Identification Number and Year: FY 21 and FY 22 Pass-Through Entity: Indiana Department of Education Pass-Through Entity Number: 21619-58-PN01, 22619-058-PN01, S010A190014, S010A200014, S010A210014 Award Period: July 1, 2020 through June 30, 2022 Type of Finding: ? Material Weakness in Internal Control over Compliance, Material Noncompliance (Modified Opinion) Criteria: Per 2 CFR 200.430, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (See paragraph (h)(1)(ii) above for treatment of incidental work for IHEs.); and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: During our testing we noted the internal control process in place during the majority of the period was insufficient to ensure proper time and effort reviews were performed and documented, and to ensure that all expenditures were supported as allowable activities and allowable costs for the program in the audit period. Questioned costs: Known - $150,392.06, Likely - $1,031,729.17. Known and questioned costs exceed program materiality. Context: In a statistically valid sample, 2 of 60 selections were not supported by appropriate documentation to support the amounts charged to the grants. 37 of 60 selections did not have adequate time and effort documentation. Cause: Crawfordsville Community School Corporation implemented a semi-annual certification for all employees in which the superintendent of schools reviews and approves each employee's semi-annual time and effort certification. This process was implemented in January, 2022, leaving 18 months of the audit period without proper controls. Other missing documentation likely was due to turnover in key positions, including the business manager. Effect: Activities or costs could be charged to a federal grant which do not meet the allowability standards, leading to noncompliance. Repeat Finding: Yes, prior year finding ? 2020-004. Recommendation: We recommend the management ensure controls are consistently in place. Training over the organization's controls may be beneficial. View of Responsible Officials: There is no disagreement with the audit finding.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 48257 2022-002
    Material Weakness
  • 48258 2022-003
    Significant Deficiency
  • 48259 2022-002
    Material Weakness
  • 48260 2022-003
    Significant Deficiency
  • 48261 2022-002
    Material Weakness
  • 48262 2022-003
    Significant Deficiency
  • 48263 2022-002
    Material Weakness
  • 48264 2022-003
    Significant Deficiency
  • 48265 2022-002
    Material Weakness
  • 48266 2022-003
    Significant Deficiency
  • 48267 2022-002
    Material Weakness
  • 48268 2022-003
    Significant Deficiency
  • 48269 2022-002
    Material Weakness
  • 48270 2022-003
    Significant Deficiency
  • 48271 2022-002
    Material Weakness
  • 48862 2022-003
    Significant Deficiency
  • 48863 2022-002
    Material Weakness
  • 48864 2022-003
    Significant Deficiency
  • 48914 2022-002
    Material Weakness
  • 48915 2022-003
    Significant Deficiency
  • 48916 2022-007
    Material Weakness Repeat
  • 48918 2022-007
    Material Weakness Repeat
  • 48919 2022-007
    Material Weakness Repeat
  • 48920 2022-007
    Material Weakness Repeat
  • 48921 2022-007
    Material Weakness Repeat
  • 48922 2022-007
    Material Weakness Repeat
  • 48923 2022-004
    Material Weakness
  • 48924 2022-005
    Material Weakness
  • 48925 2022-008
    Material Weakness
  • 48926 2022-004
    Material Weakness
  • 48927 2022-005
    Material Weakness
  • 48928 2022-008
    Material Weakness
  • 48929 2022-004
    Material Weakness
  • 48930 2022-005
    Material Weakness
  • 48931 2022-008
    Material Weakness
  • 48932 2022-004
    Material Weakness
  • 48933 2022-005
    Material Weakness
  • 48934 2022-008
    Material Weakness
  • 48935 2022-006
    Material Weakness
  • 48936 2022-009
    Material Weakness
  • 48937 2022-006
    Material Weakness
  • 48938 2022-009
    Material Weakness
  • 48939 2022-006
    Material Weakness
  • 49012 2022-009
    Material Weakness
  • 49013 2022-006
    Material Weakness
  • 49014 2022-009
    Material Weakness
  • 49736 2022-006
    Material Weakness
  • 49737 2022-009
    Material Weakness
  • 624699 2022-002
    Material Weakness
  • 624700 2022-003
    Significant Deficiency
  • 624701 2022-002
    Material Weakness
  • 624702 2022-003
    Significant Deficiency
  • 624703 2022-002
    Material Weakness
  • 624704 2022-003
    Significant Deficiency
  • 624705 2022-002
    Material Weakness
  • 624706 2022-003
    Significant Deficiency
  • 624707 2022-002
    Material Weakness
  • 624708 2022-003
    Significant Deficiency
  • 624709 2022-002
    Material Weakness
  • 624710 2022-003
    Significant Deficiency
  • 624711 2022-002
    Material Weakness
  • 624712 2022-003
    Significant Deficiency
  • 624713 2022-002
    Material Weakness
  • 625304 2022-003
    Significant Deficiency
  • 625305 2022-002
    Material Weakness
  • 625306 2022-003
    Significant Deficiency
  • 625356 2022-002
    Material Weakness
  • 625357 2022-003
    Significant Deficiency
  • 625358 2022-007
    Material Weakness Repeat
  • 625359 2022-007
    Material Weakness Repeat
  • 625360 2022-007
    Material Weakness Repeat
  • 625361 2022-007
    Material Weakness Repeat
  • 625362 2022-007
    Material Weakness Repeat
  • 625363 2022-007
    Material Weakness Repeat
  • 625364 2022-007
    Material Weakness Repeat
  • 625365 2022-004
    Material Weakness
  • 625366 2022-005
    Material Weakness
  • 625367 2022-008
    Material Weakness
  • 625368 2022-004
    Material Weakness
  • 625369 2022-005
    Material Weakness
  • 625370 2022-008
    Material Weakness
  • 625371 2022-004
    Material Weakness
  • 625372 2022-005
    Material Weakness
  • 625373 2022-008
    Material Weakness
  • 625374 2022-004
    Material Weakness
  • 625375 2022-005
    Material Weakness
  • 625376 2022-008
    Material Weakness
  • 625377 2022-006
    Material Weakness
  • 625378 2022-009
    Material Weakness
  • 625379 2022-006
    Material Weakness
  • 625380 2022-009
    Material Weakness
  • 625381 2022-006
    Material Weakness
  • 625454 2022-009
    Material Weakness
  • 625455 2022-006
    Material Weakness
  • 625456 2022-009
    Material Weakness
  • 626178 2022-006
    Material Weakness
  • 626179 2022-009
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.559 Summer School Food Service Program Fy20-Fy21 $1.58M
10.555 National School Lunch Program Fy21-Fy22 $1.27M
84.027 Special Education Grants to States Fy21-Fy22 $566,152
10.553 School Breakfast Program Fy21-Fy22 $546,825
84.027 Special Education Grants to States Fy20-Fy21 $540,031
84.425 Covid-19 Education Stabilization Fund Fy21-Fy22 $472,408
84.010 Title I Grants to Local Educational Agencies Fy21-Fy22 $446,016
84.010 Title I Grants to Local Educational Agencies Fy20-Fy21 $434,726
84.287 Twenty-First Century Community Learning Centers Fy21-Fy22 $217,610
84.287 Twenty-First Century Community Learning Centers Fy20-Fy21 $172,777
84.425 Covid-19 Education Stabilization Fund Fy20-Fy21 $160,053
10.555 Summer School Food Service Program Fy21-Fy22 $156,653
10.555 National School Lunch Program Fy20-Fy21 $127,354
93.778 Medical Assistance Program Fy20-Fy21 $116,090
97.036 Distaster Grants - Public Assisance Fy21-Fy22 $102,235
93.778 Medical Assistance Program Fy21-Fy22 $98,235
84.367 Improving Teacher Quality State Grants Fy20-Fy21 $81,183
84.367 Improving Teacher Quality State Grants Fy21-Fy22 $79,664
84.048 Career and Technical Education - Basic Grants to States Fy20-Fy21 $50,000
10.559 Summer School Food Service Program Fy21-Fy22 $42,238
84.424 Student Support and Academic Enrichment Program Fy21-Fy22 $41,540
10.553 School Breakfast Program Fy20-Fy21 $40,586
84.358 Rural Education Fy20-Fy21 $34,738
84.365 English Language Acquisition State Grants Fy21-Fy22 $27,884
84.365 English Language Acquisition State Grants Fy20-Fy21 $23,495
84.173 Special Ed Preschool Fy21-Fy22 $23,111
84.173 Special Ed Preschool Fy20-Fy21 $22,983
84.358 Rural Education Fy21-Fy22 $21,434
84.424 Student Support and Academic Enrichment Program Fy20-Fy21 $19,544
84.196 Education for Homeless Children and Youth Fy20-Fy21 $18,796
84.048 Covid Career and Technical Education - Basic Grants to States Fy20-Fy21 $17,706
84.196 Education for Homeless Children and Youth Fy21-Fy22 $6,318
84.048 Covid Career and Technical Education - Basic Grants to States Fy21-Fy22 $5,518
10.558 Child and Adult Food Program Fy21-Fy22 $4,112
10.558 Child and Adult Food Program Fy20-Fy21 $3,980
10.649 State Pandemic Electronic Benefit Transfer Admin Cost Grants Fy21-Fy22 $3,063
84.048 Career and Technical Education - Basic Grants to States Fy21-Fy22 $2,500
45.129 Promotion of the Humanitites -Federal/state Partnerships Fy21-Fy22 $1,273