Finding Number: 2023-002 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing: 84.425 C,D,U,W Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201873-01 (3/13/20 – 9/30/22) 221869-01 (6/1/22 – 9/30/24) 201787-01 (3/13/20 – 9/30/22) 211956-01 (3/24/21 – 9/30/23) 202233-01 (3/13/20 – 9/30/22) 221568-01 (7/1/21 – 9/30/22) 221422-01 (7/1/21 – 9/30/23) 221894-01 (7/1/21 – 9/30/23) Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context For 2 out of 60 samples, the Board did not retain documentation supporting proper approval of the costs charged to the grant. Questioned Costs None noted. Cause The Board did not establish and maintain effective internal control over the Federal award in accordance with the COSO framework noted above for 2 out of 60 samples. Effect Failure to perform timely approvals of grant expenditures may result in the Board charging expenditures to the grant that are unallowable. Recommendation We recommend that the Board enhance its procedures and internal controls to ensure that it retains documentation of expenditure approvals and that this documentation is available for audit purposes. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-002 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing: 84.425 C,D,U,W Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201873-01 (3/13/20 – 9/30/22) 221869-01 (6/1/22 – 9/30/24) 201787-01 (3/13/20 – 9/30/22) 211956-01 (3/24/21 – 9/30/23) 202233-01 (3/13/20 – 9/30/22) 221568-01 (7/1/21 – 9/30/22) 221422-01 (7/1/21 – 9/30/23) 221894-01 (7/1/21 – 9/30/23) Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context For 2 out of 60 samples, the Board did not retain documentation supporting proper approval of the costs charged to the grant. Questioned Costs None noted. Cause The Board did not establish and maintain effective internal control over the Federal award in accordance with the COSO framework noted above for 2 out of 60 samples. Effect Failure to perform timely approvals of grant expenditures may result in the Board charging expenditures to the grant that are unallowable. Recommendation We recommend that the Board enhance its procedures and internal controls to ensure that it retains documentation of expenditure approvals and that this documentation is available for audit purposes. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-002 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing: 84.425 C,D,U,W Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201873-01 (3/13/20 – 9/30/22) 221869-01 (6/1/22 – 9/30/24) 201787-01 (3/13/20 – 9/30/22) 211956-01 (3/24/21 – 9/30/23) 202233-01 (3/13/20 – 9/30/22) 221568-01 (7/1/21 – 9/30/22) 221422-01 (7/1/21 – 9/30/23) 221894-01 (7/1/21 – 9/30/23) Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context For 2 out of 60 samples, the Board did not retain documentation supporting proper approval of the costs charged to the grant. Questioned Costs None noted. Cause The Board did not establish and maintain effective internal control over the Federal award in accordance with the COSO framework noted above for 2 out of 60 samples. Effect Failure to perform timely approvals of grant expenditures may result in the Board charging expenditures to the grant that are unallowable. Recommendation We recommend that the Board enhance its procedures and internal controls to ensure that it retains documentation of expenditure approvals and that this documentation is available for audit purposes. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-003 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: Title I, Part A Assistance Listing: 84.010 Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201310-01 (7/1/19 – 9/30/21) 231095-01 (7/1/22 – 9/30/24) 211116-01 (7/1/20 – 9/30/22) 211303-01 (7/1/20 – 9/30/22) 221499-01 (7/1/21 – 9/30/23) 221769-01 (7/1/21 – 9/30/22) Compliance Requirement: Special Test Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or Specific Requirement Compliance: Per section 1115(c) of the ESEA (20 USC 6315(c)), an LEA, after timely and meaningful consultation with private school officials, must provide equitable services to eligible private school children, their teachers, and their families. Eligible private school children are those who reside in a participating public school attendance area and have educational needs. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context The Board is required to verify the eligibility of private school children prior to providing equitable services under the grant. Eligible private school children are those who reside in a participating public school attendance area and have educational needs. We noted 1 out of 8 students tested where the student was ineligible to receive services per the limitations noted above. Questioned Costs Undeterminable. Cause The student participation process does not include matching the student’s address and current grade level to a Title I attendance area for eligibility determination. Effect Students could be included in the equitable services calculations that should be excluded based on their school attendance zone. Recommendation We recommend that the Board revises the Student Participation process to include a step that includes matching the student grade level to the corresponding school type and a step to include a second review of the Title I School eligibility address and school type by a second staff member. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-003 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: Title I, Part A Assistance Listing: 84.010 Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201310-01 (7/1/19 – 9/30/21) 231095-01 (7/1/22 – 9/30/24) 211116-01 (7/1/20 – 9/30/22) 211303-01 (7/1/20 – 9/30/22) 221499-01 (7/1/21 – 9/30/23) 221769-01 (7/1/21 – 9/30/22) Compliance Requirement: Special Test Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or Specific Requirement Compliance: Per section 1115(c) of the ESEA (20 USC 6315(c)), an LEA, after timely and meaningful consultation with private school officials, must provide equitable services to eligible private school children, their teachers, and their families. Eligible private school children are those who reside in a participating public school attendance area and have educational needs. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context The Board is required to verify the eligibility of private school children prior to providing equitable services under the grant. Eligible private school children are those who reside in a participating public school attendance area and have educational needs. We noted 1 out of 8 students tested where the student was ineligible to receive services per the limitations noted above. Questioned Costs Undeterminable. Cause The student participation process does not include matching the student’s address and current grade level to a Title I attendance area for eligibility determination. Effect Students could be included in the equitable services calculations that should be excluded based on their school attendance zone. Recommendation We recommend that the Board revises the Student Participation process to include a step that includes matching the student grade level to the corresponding school type and a step to include a second review of the Title I School eligibility address and school type by a second staff member. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-003 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: Title I, Part A Assistance Listing: 84.010 Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201310-01 (7/1/19 – 9/30/21) 231095-01 (7/1/22 – 9/30/24) 211116-01 (7/1/20 – 9/30/22) 211303-01 (7/1/20 – 9/30/22) 221499-01 (7/1/21 – 9/30/23) 221769-01 (7/1/21 – 9/30/22) Compliance Requirement: Special Test Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or Specific Requirement Compliance: Per section 1115(c) of the ESEA (20 USC 6315(c)), an LEA, after timely and meaningful consultation with private school officials, must provide equitable services to eligible private school children, their teachers, and their families. Eligible private school children are those who reside in a participating public school attendance area and have educational needs. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context The Board is required to verify the eligibility of private school children prior to providing equitable services under the grant. Eligible private school children are those who reside in a participating public school attendance area and have educational needs. We noted 1 out of 8 students tested where the student was ineligible to receive services per the limitations noted above. Questioned Costs Undeterminable. Cause The student participation process does not include matching the student’s address and current grade level to a Title I attendance area for eligibility determination. Effect Students could be included in the equitable services calculations that should be excluded based on their school attendance zone. Recommendation We recommend that the Board revises the Student Participation process to include a step that includes matching the student grade level to the corresponding school type and a step to include a second review of the Title I School eligibility address and school type by a second staff member. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-003 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: Title I, Part A Assistance Listing: 84.010 Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201310-01 (7/1/19 – 9/30/21) 231095-01 (7/1/22 – 9/30/24) 211116-01 (7/1/20 – 9/30/22) 211303-01 (7/1/20 – 9/30/22) 221499-01 (7/1/21 – 9/30/23) 221769-01 (7/1/21 – 9/30/22) Compliance Requirement: Special Test Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or Specific Requirement Compliance: Per section 1115(c) of the ESEA (20 USC 6315(c)), an LEA, after timely and meaningful consultation with private school officials, must provide equitable services to eligible private school children, their teachers, and their families. Eligible private school children are those who reside in a participating public school attendance area and have educational needs. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context The Board is required to verify the eligibility of private school children prior to providing equitable services under the grant. Eligible private school children are those who reside in a participating public school attendance area and have educational needs. We noted 1 out of 8 students tested where the student was ineligible to receive services per the limitations noted above. Questioned Costs Undeterminable. Cause The student participation process does not include matching the student’s address and current grade level to a Title I attendance area for eligibility determination. Effect Students could be included in the equitable services calculations that should be excluded based on their school attendance zone. Recommendation We recommend that the Board revises the Student Participation process to include a step that includes matching the student grade level to the corresponding school type and a step to include a second review of the Title I School eligibility address and school type by a second staff member. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-003 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: Title I, Part A Assistance Listing: 84.010 Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201310-01 (7/1/19 – 9/30/21) 231095-01 (7/1/22 – 9/30/24) 211116-01 (7/1/20 – 9/30/22) 211303-01 (7/1/20 – 9/30/22) 221499-01 (7/1/21 – 9/30/23) 221769-01 (7/1/21 – 9/30/22) Compliance Requirement: Special Test Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or Specific Requirement Compliance: Per section 1115(c) of the ESEA (20 USC 6315(c)), an LEA, after timely and meaningful consultation with private school officials, must provide equitable services to eligible private school children, their teachers, and their families. Eligible private school children are those who reside in a participating public school attendance area and have educational needs. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context The Board is required to verify the eligibility of private school children prior to providing equitable services under the grant. Eligible private school children are those who reside in a participating public school attendance area and have educational needs. We noted 1 out of 8 students tested where the student was ineligible to receive services per the limitations noted above. Questioned Costs Undeterminable. Cause The student participation process does not include matching the student’s address and current grade level to a Title I attendance area for eligibility determination. Effect Students could be included in the equitable services calculations that should be excluded based on their school attendance zone. Recommendation We recommend that the Board revises the Student Participation process to include a step that includes matching the student grade level to the corresponding school type and a step to include a second review of the Title I School eligibility address and school type by a second staff member. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-003 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: Title I, Part A Assistance Listing: 84.010 Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201310-01 (7/1/19 – 9/30/21) 231095-01 (7/1/22 – 9/30/24) 211116-01 (7/1/20 – 9/30/22) 211303-01 (7/1/20 – 9/30/22) 221499-01 (7/1/21 – 9/30/23) 221769-01 (7/1/21 – 9/30/22) Compliance Requirement: Special Test Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or Specific Requirement Compliance: Per section 1115(c) of the ESEA (20 USC 6315(c)), an LEA, after timely and meaningful consultation with private school officials, must provide equitable services to eligible private school children, their teachers, and their families. Eligible private school children are those who reside in a participating public school attendance area and have educational needs. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context The Board is required to verify the eligibility of private school children prior to providing equitable services under the grant. Eligible private school children are those who reside in a participating public school attendance area and have educational needs. We noted 1 out of 8 students tested where the student was ineligible to receive services per the limitations noted above. Questioned Costs Undeterminable. Cause The student participation process does not include matching the student’s address and current grade level to a Title I attendance area for eligibility determination. Effect Students could be included in the equitable services calculations that should be excluded based on their school attendance zone. Recommendation We recommend that the Board revises the Student Participation process to include a step that includes matching the student grade level to the corresponding school type and a step to include a second review of the Title I School eligibility address and school type by a second staff member. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-004 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: Title I, Part A Assistance Listing: 84.010 Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201310-01 (7/1/19 – 9/30/21) 231095-01 (7/1/22 – 9/30/24) 211116-01 (7/1/20 – 9/30/22) 211303-01 (7/1/20 – 9/30/22) 221499-01 (7/1/21 – 9/30/23) 221769-01 (7/1/21 – 9/30/22) Compliance Requirement: Special Test Type of Finding: Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context For 26 out of 40 samples tested, the Board did not maintain documentation to support the students’ withdrawal and/or evidence of the school’s review and approval of the student’s withdrawal that was reported to Maryland State Department of Education (MSDE). MSDE requires the Board to provide data for students that no longer attend a school in the district. The data is used to determine if the Board's graduation rate is affected because of the student’s departure. Questioned Costs Undeterminable. Cause The Board did not retain documentation supporting student withdrawal codes as required by the grant. Effect The Board's graduation rate may be improperly calculated if the data provided to the State is inaccurate. Recommendation We recommend that the Board enhance its procedures and internal controls to ensure that it retains documentation to support student withdrawals and that this documentation is available for audit purposes. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-004 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: Title I, Part A Assistance Listing: 84.010 Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201310-01 (7/1/19 – 9/30/21) 231095-01 (7/1/22 – 9/30/24) 211116-01 (7/1/20 – 9/30/22) 211303-01 (7/1/20 – 9/30/22) 221499-01 (7/1/21 – 9/30/23) 221769-01 (7/1/21 – 9/30/22) Compliance Requirement: Special Test Type of Finding: Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context For 26 out of 40 samples tested, the Board did not maintain documentation to support the students’ withdrawal and/or evidence of the school’s review and approval of the student’s withdrawal that was reported to Maryland State Department of Education (MSDE). MSDE requires the Board to provide data for students that no longer attend a school in the district. The data is used to determine if the Board's graduation rate is affected because of the student’s departure. Questioned Costs Undeterminable. Cause The Board did not retain documentation supporting student withdrawal codes as required by the grant. Effect The Board's graduation rate may be improperly calculated if the data provided to the State is inaccurate. Recommendation We recommend that the Board enhance its procedures and internal controls to ensure that it retains documentation to support student withdrawals and that this documentation is available for audit purposes. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-004 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: Title I, Part A Assistance Listing: 84.010 Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201310-01 (7/1/19 – 9/30/21) 231095-01 (7/1/22 – 9/30/24) 211116-01 (7/1/20 – 9/30/22) 211303-01 (7/1/20 – 9/30/22) 221499-01 (7/1/21 – 9/30/23) 221769-01 (7/1/21 – 9/30/22) Compliance Requirement: Special Test Type of Finding: Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context For 26 out of 40 samples tested, the Board did not maintain documentation to support the students’ withdrawal and/or evidence of the school’s review and approval of the student’s withdrawal that was reported to Maryland State Department of Education (MSDE). MSDE requires the Board to provide data for students that no longer attend a school in the district. The data is used to determine if the Board's graduation rate is affected because of the student’s departure. Questioned Costs Undeterminable. Cause The Board did not retain documentation supporting student withdrawal codes as required by the grant. Effect The Board's graduation rate may be improperly calculated if the data provided to the State is inaccurate. Recommendation We recommend that the Board enhance its procedures and internal controls to ensure that it retains documentation to support student withdrawals and that this documentation is available for audit purposes. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-004 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: Title I, Part A Assistance Listing: 84.010 Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201310-01 (7/1/19 – 9/30/21) 231095-01 (7/1/22 – 9/30/24) 211116-01 (7/1/20 – 9/30/22) 211303-01 (7/1/20 – 9/30/22) 221499-01 (7/1/21 – 9/30/23) 221769-01 (7/1/21 – 9/30/22) Compliance Requirement: Special Test Type of Finding: Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context For 26 out of 40 samples tested, the Board did not maintain documentation to support the students’ withdrawal and/or evidence of the school’s review and approval of the student’s withdrawal that was reported to Maryland State Department of Education (MSDE). MSDE requires the Board to provide data for students that no longer attend a school in the district. The data is used to determine if the Board's graduation rate is affected because of the student’s departure. Questioned Costs Undeterminable. Cause The Board did not retain documentation supporting student withdrawal codes as required by the grant. Effect The Board's graduation rate may be improperly calculated if the data provided to the State is inaccurate. Recommendation We recommend that the Board enhance its procedures and internal controls to ensure that it retains documentation to support student withdrawals and that this documentation is available for audit purposes. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-004 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: Title I, Part A Assistance Listing: 84.010 Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201310-01 (7/1/19 – 9/30/21) 231095-01 (7/1/22 – 9/30/24) 211116-01 (7/1/20 – 9/30/22) 211303-01 (7/1/20 – 9/30/22) 221499-01 (7/1/21 – 9/30/23) 221769-01 (7/1/21 – 9/30/22) Compliance Requirement: Special Test Type of Finding: Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context For 26 out of 40 samples tested, the Board did not maintain documentation to support the students’ withdrawal and/or evidence of the school’s review and approval of the student’s withdrawal that was reported to Maryland State Department of Education (MSDE). MSDE requires the Board to provide data for students that no longer attend a school in the district. The data is used to determine if the Board's graduation rate is affected because of the student’s departure. Questioned Costs Undeterminable. Cause The Board did not retain documentation supporting student withdrawal codes as required by the grant. Effect The Board's graduation rate may be improperly calculated if the data provided to the State is inaccurate. Recommendation We recommend that the Board enhance its procedures and internal controls to ensure that it retains documentation to support student withdrawals and that this documentation is available for audit purposes. Views of Responsible Officials Management agrees with the finding.
Finding Number: 2023-004 Prior Year Finding: No Federal Agency: U.S. Department of Education Federal Program: Title I, Part A Assistance Listing: 84.010 Pass-Through Entity: Maryland State Department of Education Pass-Through Award Number and Period: 201310-01 (7/1/19 – 9/30/21) 231095-01 (7/1/22 – 9/30/24) 211116-01 (7/1/20 – 9/30/22) 211303-01 (7/1/20 – 9/30/22) 221499-01 (7/1/21 – 9/30/23) 221769-01 (7/1/21 – 9/30/22) Compliance Requirement: Special Test Type of Finding: Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-federal entity must: Establish and maintain effective internal control 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 comply with the 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). Condition/Context For 26 out of 40 samples tested, the Board did not maintain documentation to support the students’ withdrawal and/or evidence of the school’s review and approval of the student’s withdrawal that was reported to Maryland State Department of Education (MSDE). MSDE requires the Board to provide data for students that no longer attend a school in the district. The data is used to determine if the Board's graduation rate is affected because of the student’s departure. Questioned Costs Undeterminable. Cause The Board did not retain documentation supporting student withdrawal codes as required by the grant. Effect The Board's graduation rate may be improperly calculated if the data provided to the State is inaccurate. Recommendation We recommend that the Board enhance its procedures and internal controls to ensure that it retains documentation to support student withdrawals and that this documentation is available for audit purposes. Views of Responsible Officials Management agrees with the finding.
FINDING 2023-003 Subject: Child Nutrition Cluster - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation entered into a cost reimbursement contract with a food service management company (FSMC). The FSMC incurred costs on behalf of the School Corporation and invoiced the School Corporation for reimbursement of those costs. INDIANA STATE BOARD OF ACCOUNTS 19 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation had not designed or implemented a system of internal controls to ensure that program costs incurred by the FSMC were supported by proper documentation and were allowable prior to payment. Due to the lack of internal controls, the following errors were noted: In a test of 44 transactions, 22 transactions (50%) totaling $6,641 did not have proper documentation to support that the expenses were for the benefit of the food service program and in conformance with the cost principles. 1. Of the 5 transactions totaling $764, were for food and supply purchases paid for by the FSMC and then invoiced to the School Corporation for reimbursement. The vendor invoices supporting these purchases could not be provided for audit. 2. Of the 15 transactions totaling $5,532, were for FSMC employee payroll, fringe benefits, stipends, and other miscellaneous expenses. Proper supporting documentation could not be provided for audit for these transactions. 3. Of the 2 transactions, were determined to be unallowable expenses, as noted below: a. An Amazon purchase of $27 was for decorations that were shipped to a home residence. The FSMC stated the decorations were for a ceremony for the opening of the School Corporation's weight room. b. The FSMC purchased Visa gift cards totaling $318 that were gifted to FSMC staff. The items noted above were all considered questioned costs. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." 7 CFR 210.21(f)(1) states in part: ". . . (ii) (A) The contractor must separately identify for each cost submitted for payment to the school food authority the amount of that cost that is allowable (can be paid from the nonprofit school food service account) and the amount that is unallowable (cannot be paid from the nonprofit school food service account); or INDIANA STATE BOARD OF ACCOUNTS 20 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (B) The contractor must exclude all unallowable costs from its billing documents and certify that only allowable costs are submitted for payment and records have been established that maintain the visibility of unallowable costs, including directly associated costs in manner suitable for contract cost determination and verification. (iii) The contractor's determination of its allowable costs must be made in compliance with the applicable Departmental and Program regulations and Office of Management and Budget cost circulars; . . . (vi) The contractor must maintain documentation of costs and discounts, rebates and other applicable credits, and must furnish such documentation upon request to the school food authority, the State agency, or the Department." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 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: (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. . . ." 2 CFR 200.445(a) states: "Costs of goods or services for personal use of the non-Federal entity's employees are unallowable regardless of whether the cost is reported as taxable income to the employees." 2 CFR 200.467 states: "Costs of selling and marketing any products or services of the non-Federal entity (unless allowed under § 200.421) are unallowable, except as direct costs, with prior approval by the Federal awarding agency when necessary for the performance of the Federal award." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, required supporting documentation could be provided to verify costs paid to the FSMC were allowable and in conformance with the cost principles. In addition, unallowable costs were paid. INDIANA STATE BOARD OF ACCOUNTS 21 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $6,641 were identified as explained in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all costs are adequately documented and for the benefit of the food service program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: Child Nutrition Cluster - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation entered into a cost reimbursement contract with a food service management company (FSMC). The FSMC incurred costs on behalf of the School Corporation and invoiced the School Corporation for reimbursement of those costs. INDIANA STATE BOARD OF ACCOUNTS 19 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation had not designed or implemented a system of internal controls to ensure that program costs incurred by the FSMC were supported by proper documentation and were allowable prior to payment. Due to the lack of internal controls, the following errors were noted: In a test of 44 transactions, 22 transactions (50%) totaling $6,641 did not have proper documentation to support that the expenses were for the benefit of the food service program and in conformance with the cost principles. 1. Of the 5 transactions totaling $764, were for food and supply purchases paid for by the FSMC and then invoiced to the School Corporation for reimbursement. The vendor invoices supporting these purchases could not be provided for audit. 2. Of the 15 transactions totaling $5,532, were for FSMC employee payroll, fringe benefits, stipends, and other miscellaneous expenses. Proper supporting documentation could not be provided for audit for these transactions. 3. Of the 2 transactions, were determined to be unallowable expenses, as noted below: a. An Amazon purchase of $27 was for decorations that were shipped to a home residence. The FSMC stated the decorations were for a ceremony for the opening of the School Corporation's weight room. b. The FSMC purchased Visa gift cards totaling $318 that were gifted to FSMC staff. The items noted above were all considered questioned costs. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." 7 CFR 210.21(f)(1) states in part: ". . . (ii) (A) The contractor must separately identify for each cost submitted for payment to the school food authority the amount of that cost that is allowable (can be paid from the nonprofit school food service account) and the amount that is unallowable (cannot be paid from the nonprofit school food service account); or INDIANA STATE BOARD OF ACCOUNTS 20 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (B) The contractor must exclude all unallowable costs from its billing documents and certify that only allowable costs are submitted for payment and records have been established that maintain the visibility of unallowable costs, including directly associated costs in manner suitable for contract cost determination and verification. (iii) The contractor's determination of its allowable costs must be made in compliance with the applicable Departmental and Program regulations and Office of Management and Budget cost circulars; . . . (vi) The contractor must maintain documentation of costs and discounts, rebates and other applicable credits, and must furnish such documentation upon request to the school food authority, the State agency, or the Department." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 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: (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. . . ." 2 CFR 200.445(a) states: "Costs of goods or services for personal use of the non-Federal entity's employees are unallowable regardless of whether the cost is reported as taxable income to the employees." 2 CFR 200.467 states: "Costs of selling and marketing any products or services of the non-Federal entity (unless allowed under § 200.421) are unallowable, except as direct costs, with prior approval by the Federal awarding agency when necessary for the performance of the Federal award." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, required supporting documentation could be provided to verify costs paid to the FSMC were allowable and in conformance with the cost principles. In addition, unallowable costs were paid. INDIANA STATE BOARD OF ACCOUNTS 21 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $6,641 were identified as explained in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all costs are adequately documented and for the benefit of the food service program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: Child Nutrition Cluster - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation entered into a cost reimbursement contract with a food service management company (FSMC). The FSMC incurred costs on behalf of the School Corporation and invoiced the School Corporation for reimbursement of those costs. INDIANA STATE BOARD OF ACCOUNTS 19 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation had not designed or implemented a system of internal controls to ensure that program costs incurred by the FSMC were supported by proper documentation and were allowable prior to payment. Due to the lack of internal controls, the following errors were noted: In a test of 44 transactions, 22 transactions (50%) totaling $6,641 did not have proper documentation to support that the expenses were for the benefit of the food service program and in conformance with the cost principles. 1. Of the 5 transactions totaling $764, were for food and supply purchases paid for by the FSMC and then invoiced to the School Corporation for reimbursement. The vendor invoices supporting these purchases could not be provided for audit. 2. Of the 15 transactions totaling $5,532, were for FSMC employee payroll, fringe benefits, stipends, and other miscellaneous expenses. Proper supporting documentation could not be provided for audit for these transactions. 3. Of the 2 transactions, were determined to be unallowable expenses, as noted below: a. An Amazon purchase of $27 was for decorations that were shipped to a home residence. The FSMC stated the decorations were for a ceremony for the opening of the School Corporation's weight room. b. The FSMC purchased Visa gift cards totaling $318 that were gifted to FSMC staff. The items noted above were all considered questioned costs. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." 7 CFR 210.21(f)(1) states in part: ". . . (ii) (A) The contractor must separately identify for each cost submitted for payment to the school food authority the amount of that cost that is allowable (can be paid from the nonprofit school food service account) and the amount that is unallowable (cannot be paid from the nonprofit school food service account); or INDIANA STATE BOARD OF ACCOUNTS 20 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (B) The contractor must exclude all unallowable costs from its billing documents and certify that only allowable costs are submitted for payment and records have been established that maintain the visibility of unallowable costs, including directly associated costs in manner suitable for contract cost determination and verification. (iii) The contractor's determination of its allowable costs must be made in compliance with the applicable Departmental and Program regulations and Office of Management and Budget cost circulars; . . . (vi) The contractor must maintain documentation of costs and discounts, rebates and other applicable credits, and must furnish such documentation upon request to the school food authority, the State agency, or the Department." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 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: (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. . . ." 2 CFR 200.445(a) states: "Costs of goods or services for personal use of the non-Federal entity's employees are unallowable regardless of whether the cost is reported as taxable income to the employees." 2 CFR 200.467 states: "Costs of selling and marketing any products or services of the non-Federal entity (unless allowed under § 200.421) are unallowable, except as direct costs, with prior approval by the Federal awarding agency when necessary for the performance of the Federal award." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, required supporting documentation could be provided to verify costs paid to the FSMC were allowable and in conformance with the cost principles. In addition, unallowable costs were paid. INDIANA STATE BOARD OF ACCOUNTS 21 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $6,641 were identified as explained in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all costs are adequately documented and for the benefit of the food service program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: Child Nutrition Cluster - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation entered into a cost reimbursement contract with a food service management company (FSMC). The FSMC incurred costs on behalf of the School Corporation and invoiced the School Corporation for reimbursement of those costs. INDIANA STATE BOARD OF ACCOUNTS 19 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation had not designed or implemented a system of internal controls to ensure that program costs incurred by the FSMC were supported by proper documentation and were allowable prior to payment. Due to the lack of internal controls, the following errors were noted: In a test of 44 transactions, 22 transactions (50%) totaling $6,641 did not have proper documentation to support that the expenses were for the benefit of the food service program and in conformance with the cost principles. 1. Of the 5 transactions totaling $764, were for food and supply purchases paid for by the FSMC and then invoiced to the School Corporation for reimbursement. The vendor invoices supporting these purchases could not be provided for audit. 2. Of the 15 transactions totaling $5,532, were for FSMC employee payroll, fringe benefits, stipends, and other miscellaneous expenses. Proper supporting documentation could not be provided for audit for these transactions. 3. Of the 2 transactions, were determined to be unallowable expenses, as noted below: a. An Amazon purchase of $27 was for decorations that were shipped to a home residence. The FSMC stated the decorations were for a ceremony for the opening of the School Corporation's weight room. b. The FSMC purchased Visa gift cards totaling $318 that were gifted to FSMC staff. The items noted above were all considered questioned costs. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." 7 CFR 210.21(f)(1) states in part: ". . . (ii) (A) The contractor must separately identify for each cost submitted for payment to the school food authority the amount of that cost that is allowable (can be paid from the nonprofit school food service account) and the amount that is unallowable (cannot be paid from the nonprofit school food service account); or INDIANA STATE BOARD OF ACCOUNTS 20 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (B) The contractor must exclude all unallowable costs from its billing documents and certify that only allowable costs are submitted for payment and records have been established that maintain the visibility of unallowable costs, including directly associated costs in manner suitable for contract cost determination and verification. (iii) The contractor's determination of its allowable costs must be made in compliance with the applicable Departmental and Program regulations and Office of Management and Budget cost circulars; . . . (vi) The contractor must maintain documentation of costs and discounts, rebates and other applicable credits, and must furnish such documentation upon request to the school food authority, the State agency, or the Department." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 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: (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. . . ." 2 CFR 200.445(a) states: "Costs of goods or services for personal use of the non-Federal entity's employees are unallowable regardless of whether the cost is reported as taxable income to the employees." 2 CFR 200.467 states: "Costs of selling and marketing any products or services of the non-Federal entity (unless allowed under § 200.421) are unallowable, except as direct costs, with prior approval by the Federal awarding agency when necessary for the performance of the Federal award." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, required supporting documentation could be provided to verify costs paid to the FSMC were allowable and in conformance with the cost principles. In addition, unallowable costs were paid. INDIANA STATE BOARD OF ACCOUNTS 21 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $6,641 were identified as explained in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all costs are adequately documented and for the benefit of the food service program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: Child Nutrition Cluster - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation entered into a cost reimbursement contract with a food service management company (FSMC). The FSMC incurred costs on behalf of the School Corporation and invoiced the School Corporation for reimbursement of those costs. INDIANA STATE BOARD OF ACCOUNTS 19 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation had not designed or implemented a system of internal controls to ensure that program costs incurred by the FSMC were supported by proper documentation and were allowable prior to payment. Due to the lack of internal controls, the following errors were noted: In a test of 44 transactions, 22 transactions (50%) totaling $6,641 did not have proper documentation to support that the expenses were for the benefit of the food service program and in conformance with the cost principles. 1. Of the 5 transactions totaling $764, were for food and supply purchases paid for by the FSMC and then invoiced to the School Corporation for reimbursement. The vendor invoices supporting these purchases could not be provided for audit. 2. Of the 15 transactions totaling $5,532, were for FSMC employee payroll, fringe benefits, stipends, and other miscellaneous expenses. Proper supporting documentation could not be provided for audit for these transactions. 3. Of the 2 transactions, were determined to be unallowable expenses, as noted below: a. An Amazon purchase of $27 was for decorations that were shipped to a home residence. The FSMC stated the decorations were for a ceremony for the opening of the School Corporation's weight room. b. The FSMC purchased Visa gift cards totaling $318 that were gifted to FSMC staff. The items noted above were all considered questioned costs. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." 7 CFR 210.21(f)(1) states in part: ". . . (ii) (A) The contractor must separately identify for each cost submitted for payment to the school food authority the amount of that cost that is allowable (can be paid from the nonprofit school food service account) and the amount that is unallowable (cannot be paid from the nonprofit school food service account); or INDIANA STATE BOARD OF ACCOUNTS 20 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (B) The contractor must exclude all unallowable costs from its billing documents and certify that only allowable costs are submitted for payment and records have been established that maintain the visibility of unallowable costs, including directly associated costs in manner suitable for contract cost determination and verification. (iii) The contractor's determination of its allowable costs must be made in compliance with the applicable Departmental and Program regulations and Office of Management and Budget cost circulars; . . . (vi) The contractor must maintain documentation of costs and discounts, rebates and other applicable credits, and must furnish such documentation upon request to the school food authority, the State agency, or the Department." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 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: (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. . . ." 2 CFR 200.445(a) states: "Costs of goods or services for personal use of the non-Federal entity's employees are unallowable regardless of whether the cost is reported as taxable income to the employees." 2 CFR 200.467 states: "Costs of selling and marketing any products or services of the non-Federal entity (unless allowed under § 200.421) are unallowable, except as direct costs, with prior approval by the Federal awarding agency when necessary for the performance of the Federal award." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, required supporting documentation could be provided to verify costs paid to the FSMC were allowable and in conformance with the cost principles. In addition, unallowable costs were paid. INDIANA STATE BOARD OF ACCOUNTS 21 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $6,641 were identified as explained in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all costs are adequately documented and for the benefit of the food service program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: Child Nutrition Cluster - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation entered into a cost reimbursement contract with a food service management company (FSMC). The FSMC incurred costs on behalf of the School Corporation and invoiced the School Corporation for reimbursement of those costs. INDIANA STATE BOARD OF ACCOUNTS 19 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation had not designed or implemented a system of internal controls to ensure that program costs incurred by the FSMC were supported by proper documentation and were allowable prior to payment. Due to the lack of internal controls, the following errors were noted: In a test of 44 transactions, 22 transactions (50%) totaling $6,641 did not have proper documentation to support that the expenses were for the benefit of the food service program and in conformance with the cost principles. 1. Of the 5 transactions totaling $764, were for food and supply purchases paid for by the FSMC and then invoiced to the School Corporation for reimbursement. The vendor invoices supporting these purchases could not be provided for audit. 2. Of the 15 transactions totaling $5,532, were for FSMC employee payroll, fringe benefits, stipends, and other miscellaneous expenses. Proper supporting documentation could not be provided for audit for these transactions. 3. Of the 2 transactions, were determined to be unallowable expenses, as noted below: a. An Amazon purchase of $27 was for decorations that were shipped to a home residence. The FSMC stated the decorations were for a ceremony for the opening of the School Corporation's weight room. b. The FSMC purchased Visa gift cards totaling $318 that were gifted to FSMC staff. The items noted above were all considered questioned costs. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." 7 CFR 210.21(f)(1) states in part: ". . . (ii) (A) The contractor must separately identify for each cost submitted for payment to the school food authority the amount of that cost that is allowable (can be paid from the nonprofit school food service account) and the amount that is unallowable (cannot be paid from the nonprofit school food service account); or INDIANA STATE BOARD OF ACCOUNTS 20 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (B) The contractor must exclude all unallowable costs from its billing documents and certify that only allowable costs are submitted for payment and records have been established that maintain the visibility of unallowable costs, including directly associated costs in manner suitable for contract cost determination and verification. (iii) The contractor's determination of its allowable costs must be made in compliance with the applicable Departmental and Program regulations and Office of Management and Budget cost circulars; . . . (vi) The contractor must maintain documentation of costs and discounts, rebates and other applicable credits, and must furnish such documentation upon request to the school food authority, the State agency, or the Department." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 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: (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. . . ." 2 CFR 200.445(a) states: "Costs of goods or services for personal use of the non-Federal entity's employees are unallowable regardless of whether the cost is reported as taxable income to the employees." 2 CFR 200.467 states: "Costs of selling and marketing any products or services of the non-Federal entity (unless allowed under § 200.421) are unallowable, except as direct costs, with prior approval by the Federal awarding agency when necessary for the performance of the Federal award." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, required supporting documentation could be provided to verify costs paid to the FSMC were allowable and in conformance with the cost principles. In addition, unallowable costs were paid. INDIANA STATE BOARD OF ACCOUNTS 21 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $6,641 were identified as explained in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all costs are adequately documented and for the benefit of the food service program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: Child Nutrition Cluster - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation entered into a cost reimbursement contract with a food service management company (FSMC). The FSMC incurred costs on behalf of the School Corporation and invoiced the School Corporation for reimbursement of those costs. INDIANA STATE BOARD OF ACCOUNTS 19 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation had not designed or implemented a system of internal controls to ensure that program costs incurred by the FSMC were supported by proper documentation and were allowable prior to payment. Due to the lack of internal controls, the following errors were noted: In a test of 44 transactions, 22 transactions (50%) totaling $6,641 did not have proper documentation to support that the expenses were for the benefit of the food service program and in conformance with the cost principles. 1. Of the 5 transactions totaling $764, were for food and supply purchases paid for by the FSMC and then invoiced to the School Corporation for reimbursement. The vendor invoices supporting these purchases could not be provided for audit. 2. Of the 15 transactions totaling $5,532, were for FSMC employee payroll, fringe benefits, stipends, and other miscellaneous expenses. Proper supporting documentation could not be provided for audit for these transactions. 3. Of the 2 transactions, were determined to be unallowable expenses, as noted below: a. An Amazon purchase of $27 was for decorations that were shipped to a home residence. The FSMC stated the decorations were for a ceremony for the opening of the School Corporation's weight room. b. The FSMC purchased Visa gift cards totaling $318 that were gifted to FSMC staff. The items noted above were all considered questioned costs. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." 7 CFR 210.21(f)(1) states in part: ". . . (ii) (A) The contractor must separately identify for each cost submitted for payment to the school food authority the amount of that cost that is allowable (can be paid from the nonprofit school food service account) and the amount that is unallowable (cannot be paid from the nonprofit school food service account); or INDIANA STATE BOARD OF ACCOUNTS 20 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (B) The contractor must exclude all unallowable costs from its billing documents and certify that only allowable costs are submitted for payment and records have been established that maintain the visibility of unallowable costs, including directly associated costs in manner suitable for contract cost determination and verification. (iii) The contractor's determination of its allowable costs must be made in compliance with the applicable Departmental and Program regulations and Office of Management and Budget cost circulars; . . . (vi) The contractor must maintain documentation of costs and discounts, rebates and other applicable credits, and must furnish such documentation upon request to the school food authority, the State agency, or the Department." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 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: (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. . . ." 2 CFR 200.445(a) states: "Costs of goods or services for personal use of the non-Federal entity's employees are unallowable regardless of whether the cost is reported as taxable income to the employees." 2 CFR 200.467 states: "Costs of selling and marketing any products or services of the non-Federal entity (unless allowed under § 200.421) are unallowable, except as direct costs, with prior approval by the Federal awarding agency when necessary for the performance of the Federal award." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, required supporting documentation could be provided to verify costs paid to the FSMC were allowable and in conformance with the cost principles. In addition, unallowable costs were paid. INDIANA STATE BOARD OF ACCOUNTS 21 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $6,641 were identified as explained in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all costs are adequately documented and for the benefit of the food service program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: Child Nutrition Cluster - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation entered into a cost reimbursement contract with a food service management company (FSMC). The FSMC incurred costs on behalf of the School Corporation and invoiced the School Corporation for reimbursement of those costs. INDIANA STATE BOARD OF ACCOUNTS 19 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation had not designed or implemented a system of internal controls to ensure that program costs incurred by the FSMC were supported by proper documentation and were allowable prior to payment. Due to the lack of internal controls, the following errors were noted: In a test of 44 transactions, 22 transactions (50%) totaling $6,641 did not have proper documentation to support that the expenses were for the benefit of the food service program and in conformance with the cost principles. 1. Of the 5 transactions totaling $764, were for food and supply purchases paid for by the FSMC and then invoiced to the School Corporation for reimbursement. The vendor invoices supporting these purchases could not be provided for audit. 2. Of the 15 transactions totaling $5,532, were for FSMC employee payroll, fringe benefits, stipends, and other miscellaneous expenses. Proper supporting documentation could not be provided for audit for these transactions. 3. Of the 2 transactions, were determined to be unallowable expenses, as noted below: a. An Amazon purchase of $27 was for decorations that were shipped to a home residence. The FSMC stated the decorations were for a ceremony for the opening of the School Corporation's weight room. b. The FSMC purchased Visa gift cards totaling $318 that were gifted to FSMC staff. The items noted above were all considered questioned costs. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." 7 CFR 210.21(f)(1) states in part: ". . . (ii) (A) The contractor must separately identify for each cost submitted for payment to the school food authority the amount of that cost that is allowable (can be paid from the nonprofit school food service account) and the amount that is unallowable (cannot be paid from the nonprofit school food service account); or INDIANA STATE BOARD OF ACCOUNTS 20 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (B) The contractor must exclude all unallowable costs from its billing documents and certify that only allowable costs are submitted for payment and records have been established that maintain the visibility of unallowable costs, including directly associated costs in manner suitable for contract cost determination and verification. (iii) The contractor's determination of its allowable costs must be made in compliance with the applicable Departmental and Program regulations and Office of Management and Budget cost circulars; . . . (vi) The contractor must maintain documentation of costs and discounts, rebates and other applicable credits, and must furnish such documentation upon request to the school food authority, the State agency, or the Department." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 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: (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. . . ." 2 CFR 200.445(a) states: "Costs of goods or services for personal use of the non-Federal entity's employees are unallowable regardless of whether the cost is reported as taxable income to the employees." 2 CFR 200.467 states: "Costs of selling and marketing any products or services of the non-Federal entity (unless allowed under § 200.421) are unallowable, except as direct costs, with prior approval by the Federal awarding agency when necessary for the performance of the Federal award." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, required supporting documentation could be provided to verify costs paid to the FSMC were allowable and in conformance with the cost principles. In addition, unallowable costs were paid. INDIANA STATE BOARD OF ACCOUNTS 21 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $6,641 were identified as explained in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all costs are adequately documented and for the benefit of the food service program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the monthly sponsor claims for reimbursement. School Food Authority's (SFA) and sponsors must submit monthly claims for reimbursement for meals and snacks served to eligible students within 60 days following the last day of the month covered by the claim. The Food Service Director prepared the monthly claim for reimbursement on the Indiana Department of Education Child Nutrition Program website based on meal count reports from the point-of-sale system. The School Corporation had not designed or implement a system of internal control to ensure what was claimed for reimbursement agreed to the point-of-sale system meal count reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 22 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Establish and maintain effective internal control 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). . . ." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the monthly sponsor claims for reimbursement. School Food Authority's (SFA) and sponsors must submit monthly claims for reimbursement for meals and snacks served to eligible students within 60 days following the last day of the month covered by the claim. The Food Service Director prepared the monthly claim for reimbursement on the Indiana Department of Education Child Nutrition Program website based on meal count reports from the point-of-sale system. The School Corporation had not designed or implement a system of internal control to ensure what was claimed for reimbursement agreed to the point-of-sale system meal count reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 22 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Establish and maintain effective internal control 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). . . ." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the monthly sponsor claims for reimbursement. School Food Authority's (SFA) and sponsors must submit monthly claims for reimbursement for meals and snacks served to eligible students within 60 days following the last day of the month covered by the claim. The Food Service Director prepared the monthly claim for reimbursement on the Indiana Department of Education Child Nutrition Program website based on meal count reports from the point-of-sale system. The School Corporation had not designed or implement a system of internal control to ensure what was claimed for reimbursement agreed to the point-of-sale system meal count reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 22 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Establish and maintain effective internal control 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). . . ." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the monthly sponsor claims for reimbursement. School Food Authority's (SFA) and sponsors must submit monthly claims for reimbursement for meals and snacks served to eligible students within 60 days following the last day of the month covered by the claim. The Food Service Director prepared the monthly claim for reimbursement on the Indiana Department of Education Child Nutrition Program website based on meal count reports from the point-of-sale system. The School Corporation had not designed or implement a system of internal control to ensure what was claimed for reimbursement agreed to the point-of-sale system meal count reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 22 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Establish and maintain effective internal control 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). . . ." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the monthly sponsor claims for reimbursement. School Food Authority's (SFA) and sponsors must submit monthly claims for reimbursement for meals and snacks served to eligible students within 60 days following the last day of the month covered by the claim. The Food Service Director prepared the monthly claim for reimbursement on the Indiana Department of Education Child Nutrition Program website based on meal count reports from the point-of-sale system. The School Corporation had not designed or implement a system of internal control to ensure what was claimed for reimbursement agreed to the point-of-sale system meal count reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 22 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Establish and maintain effective internal control 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). . . ." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the monthly sponsor claims for reimbursement. School Food Authority's (SFA) and sponsors must submit monthly claims for reimbursement for meals and snacks served to eligible students within 60 days following the last day of the month covered by the claim. The Food Service Director prepared the monthly claim for reimbursement on the Indiana Department of Education Child Nutrition Program website based on meal count reports from the point-of-sale system. The School Corporation had not designed or implement a system of internal control to ensure what was claimed for reimbursement agreed to the point-of-sale system meal count reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 22 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Establish and maintain effective internal control 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). . . ." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the monthly sponsor claims for reimbursement. School Food Authority's (SFA) and sponsors must submit monthly claims for reimbursement for meals and snacks served to eligible students within 60 days following the last day of the month covered by the claim. The Food Service Director prepared the monthly claim for reimbursement on the Indiana Department of Education Child Nutrition Program website based on meal count reports from the point-of-sale system. The School Corporation had not designed or implement a system of internal control to ensure what was claimed for reimbursement agreed to the point-of-sale system meal count reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 22 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Establish and maintain effective internal control 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). . . ." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch, Summer Food Service Program for Children, Fresh Fruit and Vegetable Program Assistance Listings Numbers: 10.553, 10.555, 10.559, 10.582 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the monthly sponsor claims for reimbursement. School Food Authority's (SFA) and sponsors must submit monthly claims for reimbursement for meals and snacks served to eligible students within 60 days following the last day of the month covered by the claim. The Food Service Director prepared the monthly claim for reimbursement on the Indiana Department of Education Child Nutrition Program website based on meal count reports from the point-of-sale system. The School Corporation had not designed or implement a system of internal control to ensure what was claimed for reimbursement agreed to the point-of-sale system meal count reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 22 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Establish and maintain effective internal control 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). . . ." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Title I Grants to Local Educational Agencies - Eligibility 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): S010A210014, SA10A200014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 23 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the enrollment and poverty data as reported by the Indiana Department of Education (IDOE) and the School Corporation in the Title I application. Public School (Local Educational Agency) Eligibility for Title I is determined on the Eligible School Summary of the Title I application. Enrollment and Poverty numbers for the public school district are automatically pulled from the IDOE's Official Pupil Enrollment (PE) count for each school into the Eligible School Summary page of the Title I application. These counts are based upon the School Corporation's records as of October of the prior fiscal year. The School Corporation had not established a process of review of the Eligibility Summary in the Title I application for the student enrollment and poverty counts. There was no documentation of the School Corporation verifying the enrollment and poverty counts in the Title I application. Nonpublic Schools Enrollment and poverty numbers for any non-public schools are manually entered into the application by the School Corporation. The School Corporation established a process to receive and review the listing of students from the nonpublic schools for enrollment and poverty counts to be entered into the Title I application. However, the internal controls were ineffective as the School Corporation requested to receive a listing of poverty student counts only; the list of enrolled students was not provided by the nonpublic schools. Therefore, we were unable to determine if the enrolled student count in the application was accurate. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." 34 CFR 200.78(a)(1) states: "After reserving funds, as applicable, under § 200.77, including funds for equitable services for private school students, their teachers, and their families, an LEA must allocate funds under this subpart to school attendance areas and schools, identified as eligible and selected to participate under section 1113(a) or (b) of the ESEA, in rank order on the basis of the total number of public school children from low-income families in each area or school." INDIANA STATE BOARD OF ACCOUNTS 24 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, documentation was not available to determine if the enrolled and poverty counts for the public and non-public data in the Title I application was accurate. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure documentation is retained to support information in the Title I application. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Title I Grants to Local Educational Agencies - Eligibility 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): S010A210014, SA10A200014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 23 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the enrollment and poverty data as reported by the Indiana Department of Education (IDOE) and the School Corporation in the Title I application. Public School (Local Educational Agency) Eligibility for Title I is determined on the Eligible School Summary of the Title I application. Enrollment and Poverty numbers for the public school district are automatically pulled from the IDOE's Official Pupil Enrollment (PE) count for each school into the Eligible School Summary page of the Title I application. These counts are based upon the School Corporation's records as of October of the prior fiscal year. The School Corporation had not established a process of review of the Eligibility Summary in the Title I application for the student enrollment and poverty counts. There was no documentation of the School Corporation verifying the enrollment and poverty counts in the Title I application. Nonpublic Schools Enrollment and poverty numbers for any non-public schools are manually entered into the application by the School Corporation. The School Corporation established a process to receive and review the listing of students from the nonpublic schools for enrollment and poverty counts to be entered into the Title I application. However, the internal controls were ineffective as the School Corporation requested to receive a listing of poverty student counts only; the list of enrolled students was not provided by the nonpublic schools. Therefore, we were unable to determine if the enrolled student count in the application was accurate. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." 34 CFR 200.78(a)(1) states: "After reserving funds, as applicable, under § 200.77, including funds for equitable services for private school students, their teachers, and their families, an LEA must allocate funds under this subpart to school attendance areas and schools, identified as eligible and selected to participate under section 1113(a) or (b) of the ESEA, in rank order on the basis of the total number of public school children from low-income families in each area or school." INDIANA STATE BOARD OF ACCOUNTS 24 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, documentation was not available to determine if the enrolled and poverty counts for the public and non-public data in the Title I application was accurate. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure documentation is retained to support information in the Title I application. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Title I Grants to Local Educational Agencies - Special Tests and Provisions - Annual Report Card, High School Graduation Rate 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): S010A210014, SA10A200014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Annual Report Card, High School Graduation Rate Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-003. INDIANA STATE BOARD OF ACCOUNTS 25 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance to ensure required documentation supporting the removal of a student from the high school graduation cohort for mobility reasons was prepared, reviewed, and retained. When a student is listed on the cohort report as having exited the cohort, the school should have documentation supporting the removal of those students. One individual was responsible for collecting and reviewing the documentation and then removing the student from the graduation cohort. There was no evidence of a second review by a knowledgeable individual to ensure all students removed from the cohort had the appropriate documentation. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 26 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Title I Grants to Local Educational Agencies - Special Tests and Provisions - Annual Report Card, High School Graduation Rate 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): S010A210014, SA10A200014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Annual Report Card, High School Graduation Rate Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-003. INDIANA STATE BOARD OF ACCOUNTS 25 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance to ensure required documentation supporting the removal of a student from the high school graduation cohort for mobility reasons was prepared, reviewed, and retained. When a student is listed on the cohort report as having exited the cohort, the school should have documentation supporting the removal of those students. One individual was responsible for collecting and reviewing the documentation and then removing the student from the graduation cohort. There was no evidence of a second review by a knowledgeable individual to ensure all students removed from the cohort had the appropriate documentation. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 26 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-007 Subject: COVID-19 - Education Stabilization Fund - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance to ensure adjustments for payroll were allowed and in conformance with the cost principles. Adjustments were made to payroll disbursement activity between Education Stabilization Fund (ESF) funds. Support for these adjustments was traced to the School Corporation's records to verify the gross payroll activity was properly moved. One adjustment, totaling $27,824, could not be verified. The supporting documentation for this adjustment exceeded the amount of the transaction. Inquiry with School Corporation officials and review of the documentation determined that the amount transferred was based on the remaining grant budget amounts instead of actual payroll disbursements. The $27,824 is considered questioned costs. The ineffective internal controls and noncompliance was limited to the item noted above for the S425D200013 grant award. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 27 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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: (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. . . ." 2 CFR 200.400 states in part: "The application of these cost principles is based on the fundamental premises that: . . . (d) The application of these cost principles should require no significant changes in the internal accounting policies and practices of the non-Federal entity. However, the accounting practices of the non-Federal entity must be consistent with these cost principles and support the accumulation of costs as required by the principles, and must provide for adequate documentation to support costs charged to the Federal award. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, a transfer adjustment was made from one Education Stabilization Fund to another without underlying supporting documentation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $27,824 were identified as detailed in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure costs are included in the approved budget, are only requested once, and are not retained if received in error. INDIANA STATE BOARD OF ACCOUNTS 28 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-007 Subject: COVID-19 - Education Stabilization Fund - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance to ensure adjustments for payroll were allowed and in conformance with the cost principles. Adjustments were made to payroll disbursement activity between Education Stabilization Fund (ESF) funds. Support for these adjustments was traced to the School Corporation's records to verify the gross payroll activity was properly moved. One adjustment, totaling $27,824, could not be verified. The supporting documentation for this adjustment exceeded the amount of the transaction. Inquiry with School Corporation officials and review of the documentation determined that the amount transferred was based on the remaining grant budget amounts instead of actual payroll disbursements. The $27,824 is considered questioned costs. The ineffective internal controls and noncompliance was limited to the item noted above for the S425D200013 grant award. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 27 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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: (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. . . ." 2 CFR 200.400 states in part: "The application of these cost principles is based on the fundamental premises that: . . . (d) The application of these cost principles should require no significant changes in the internal accounting policies and practices of the non-Federal entity. However, the accounting practices of the non-Federal entity must be consistent with these cost principles and support the accumulation of costs as required by the principles, and must provide for adequate documentation to support costs charged to the Federal award. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, a transfer adjustment was made from one Education Stabilization Fund to another without underlying supporting documentation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $27,824 were identified as detailed in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure costs are included in the approved budget, are only requested once, and are not retained if received in error. INDIANA STATE BOARD OF ACCOUNTS 28 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-008 Subject: COVID-19 - Education Stabilization Fund - Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance to ensure that construction contracts in excess of $2,000 paid from federal grant funds included a prevailing wage rate clause and that certified payrolls were obtained. Construction contracts in excess of $2,000 financed by federal assistance funds must pay wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL) to their laborers and mechanics. Nonfederal entities are to include in their construction contracts subject to the Wage Rate Requirements a provision that the contractor or subcontractor comply with these requirements and the DOL regulations. This would include a requirement to submit a copy of the payroll and statement of compliance to the entity for each week in which contract work was performed. One construction contract, totaling $4,000,000 was paid from the COVID-19 - Education Stabilization Fund grant funds during the audit period. The one construction contract was selected for testing. Upon review of the construction contract, it was determined the required prevailing wage rate clause was not properly included. Additionally, certified payrolls were not obtained until after the School Corporation was issued an ESSER Construction Monitoring Report in late 2023. The School Corporation only obtained a "sample" of certified payrolls and did not obtain all of the certified payrolls for the work performed within the grant period. The lack of internal controls and noncompliance was isolated to the contract noted above. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 29 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Establish and maintain effective internal control 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). . . ." 29 FR 5.5 states in part: "(a) The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in § 5.1, the following clauses . . . (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics. . . . (3) Payrolls and basic records. . . . (ii) (A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). . . ." 2 CFR 200 Appendix II states in part: "In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . INDIANA STATE BOARD OF ACCOUNTS 30 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non- Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, "Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction"). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, construction contracts entered into did not contain the required wage rate requirements clauses nor were certified payrolls timely obtained by the School Corporation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls and include the wage rate requirement clause in construction contracts. In addition, certified payrolls should be obtained as required. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-008 Subject: COVID-19 - Education Stabilization Fund - Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance to ensure that construction contracts in excess of $2,000 paid from federal grant funds included a prevailing wage rate clause and that certified payrolls were obtained. Construction contracts in excess of $2,000 financed by federal assistance funds must pay wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL) to their laborers and mechanics. Nonfederal entities are to include in their construction contracts subject to the Wage Rate Requirements a provision that the contractor or subcontractor comply with these requirements and the DOL regulations. This would include a requirement to submit a copy of the payroll and statement of compliance to the entity for each week in which contract work was performed. One construction contract, totaling $4,000,000 was paid from the COVID-19 - Education Stabilization Fund grant funds during the audit period. The one construction contract was selected for testing. Upon review of the construction contract, it was determined the required prevailing wage rate clause was not properly included. Additionally, certified payrolls were not obtained until after the School Corporation was issued an ESSER Construction Monitoring Report in late 2023. The School Corporation only obtained a "sample" of certified payrolls and did not obtain all of the certified payrolls for the work performed within the grant period. The lack of internal controls and noncompliance was isolated to the contract noted above. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 29 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Establish and maintain effective internal control 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). . . ." 29 FR 5.5 states in part: "(a) The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in § 5.1, the following clauses . . . (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics. . . . (3) Payrolls and basic records. . . . (ii) (A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). . . ." 2 CFR 200 Appendix II states in part: "In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . INDIANA STATE BOARD OF ACCOUNTS 30 LAKE RIDGE SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non- Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, "Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction"). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, construction contracts entered into did not contain the required wage rate requirements clauses nor were certified payrolls timely obtained by the School Corporation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls and include the wage rate requirement clause in construction contracts. In addition, certified payrolls should be obtained as required. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Federal agency: U.S. Department of Health and Human Services Federal program title: Block Grants for Community Mental Health Services Assistance Listing Number: 93.958 Pass-Through Agency: n/a Pass-Through Number(s): n/a Award Period9/30/21-9/29/24 Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Code of Federal Regulations (CFR) § 200.303(a) indicates non-federal entities must establish and maintain effective internal control 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). Condition: Inaccurate payroll allocation calculation by management when allocating payroll costs to the federal program. Questioned costs: $13 Context: For 1 of the 25 allowable cost transactions selected for testing, there was an error in an employee’s payroll allocation causing more payroll expense to be charged to the federal program expense than there should have been. Cause: Error by management in payroll allocation calculation. Effect: If payroll allocation costs are not reviewed and approved as being allowable, it could result in unallowable costs being charged to federal grants. Repeat Finding: N/A Recommendation: We recommend the organization enhance its internal controls to ensure payroll allocation costs are properly calculated and costs are charged to the federal program. Views of responsible officials: Management will enhance its internal controls to ensure payroll allocation costs are properly calculated and costs are charged to the federal program properly.
Program: AL 93.558 – Temporary Assistance for Needy Families; AL 93.563 – Child Support Enforcement; AL 93.568 – Low Income Home Energy Assistance (LIHEAP); AL 93.575 – Child Care and Development Block Grant; AL 93.658 – Foster Care Title IV-E; AL 93.778 – Medical Assistance Program; AL 10.561 – State Administrative Matching Grants for the Supplemental Nutrition Assistance Program – Allowable Costs/Cost Principles Grant Number & Year: 2001NETANF, FFY 2020; 2301NECSES, FFY 2023; 2301NELIEA, FFY 2023; 2301NECCDD, FFY 2023; 2301NEFOST, FFY 2023; 2305NE5ADM, FFY 2023; 233NE406S2514, FFY 2023 Federal Grantor Agency: U.S. Department of Health and Human Services and U.S. Department of Agriculture Criteria: 45 CFR § 75.405(a) (October 1, 2022) and 2 CFR § 200.405 (January 1, 2023) state, in part, the following: A cost is allocable to a particular Federal award or other cost objective if the goods or services involved are chargeable or assignable to that Federal award or cost objective in accordance with relative benefits received. 45 CFR § 75.403 (October 1, 2022) and 2 CFR § 200.403 (January 1, 2023) provide the following, in relevant part: Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. * * * * (g) Be adequately documented. See also §§ 75.300 through 75.309. Per 45 CFR § 75.303 (October 1, 2022) and 2 CFR § 200.303 (January 1, 2023), The non-Federal entity must: (a) Establish and maintain effective internal control 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. Title 45 CFR § 75.302 (October 1, 2022) and 2 CFR § 200.302 (January 1, 2023) require financial management systems of the State sufficient to permit preparation of required reports and permit the tracing of funds to expenditures adequate to establish the use of these funds were in accordance with applicable regulations. EnterpriseOne is the official accounting system for the State of Nebraska, and all expenditures are generated from it. Good internal control requires procedures to ensure that amounts charged to Federal funds are proper. Condition: Procedures to ensure journal entries and adjustments to the Public Assistance Cost Allocation Plan (PACAP) were not adequate, resulting in multiple Federal programs being overcharged. Repeat Finding: No Questioned Costs: $581,496 known See Schedule of Findings and Questioned Costs for chart/table. Statistical Sample: No Context: Each quarter, as the PACAP is prepared, the Agency makes multiple adjustments for costs that either were charged to Federal funds and should not have been, or costs that were not charged to Federal funds but are claimable to a Federal grant. We tested five adjustments between two quarters. One adjustment tested for the quarter ended December 31, 2022, was recorded to charge the Foster Care grant for allowable costs incurred by the Foster Care Review Office (FCRO), a separate agency. The amounts provided by FCRO erroneously included payroll charges from a previous quarter, inflating the amount charged. The FCRO later caught the mistake and adjusted the internal spreadsheet but did not alert the Agency to the error, so a correcting adjustment was never made to the PACAP. The amount charged was $353,984; however, the adjustment should have been $212,725, a difference of $141,259. Foster Care is matched at 50%, so the grant was overcharged $70,629, which are questioned costs. Due to this error, we reviewed a second Foster Care adjustment for the quarter ending March 31, 2023, and noted the Agency’s calculation included amounts for a State funded program that should have been removed, resulting in the grant being overcharged an additional $1,561. We also tested six journal entries that moved costs between cost centers to determine any impact on the PACAP and if those journal entries were appropriate. We noted three improper journal entries that the Agency had not corrected as of the end of the fiscal year: • A journal entry for $526,487 was performed in November 2022 to temporarily move postage costs of multiple programs from State funds to the Child Support Enforcement (CSE) grant until new coding could be created in the State’s accounting system to track expenses from one fiscal year to another. The intent was to reverse the entry as soon as the new coding was completed; however, the reversing entry was never performed. Since the Agency performs a quarterly adjustment for the CSE grant to charge indirect costs identified by the Agency’s PACAP to the grant, the CSE grant was overcharged a total of $263,628. No correcting entry had been made as of September 30, 2023. These are considered questioned costs. • A journal entry for $207,369 was performed in December 2022 to move expenses to allow payroll to post. The intent was to reverse the entry before the end of the fiscal year; however, that was not done. The expenses were moved from Medicaid administration and were charged to the Central Services and Supplies Cost Center, which is then allocated to numerous other Cost Centers that are further allocated or charged directly to Federal programs such as TANF and Child Care. Due to the intricacies of PACAP allocations, exact questioned costs are unknown. No correcting entry was made as of September 30, 2023. • A journal entry for $5,317,640 was done in February 2023 to move Premium Pay to the Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) grant as additional pay for certain job roles allowed under that grant. However, the entry performed included some lines that were miscoded, most significantly a line for $764,187 that was supposed to move money within the same Cost Center (CC 25C21910 – Field Office Administration); however, it pulled costs out of Cost Center 25C21780 - Protection and Safety Policy Chief instead. Additionally, we confirmed with the Agency that the costs charged to CC 25C21910 under the CSLFRF grant were also allocated to other Federal programs through the PACAP, essentially charging Federal programs twice. Due to the intricacies of the PACAP allocations, total questioned costs are unknown; however, we were able to determine that this error caused Medicaid to be overcharged $149,478, LIHEAP to be overcharged $33,447, SNAP to be overcharged $44,984, Child Care to be overcharged $10,412, and TANF to be overcharged $7,357. Cause: Inadequate procedures to ensure that adjustments to the PACAP are proper and that journal entries are appropriate for each program. Effect: Unallowable expenditures were charged to Federal funds and there is an increased risk for errors, fraud, and non-compliance with Federal regulations. Recommendation: We recommend the Agency strengthen procedures to ensure adjusting entries are complete and accurate. We further recommend the Agency strengthen procedures to ensure compliance with Federal regulations. Management Response: The Agency agrees.
Program: AL 93.658 - Foster Care Title IV-E; AL 10.561 - State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; AL 93.659 - Adoption Assistance – Allowable Costs/Cost Principles Grant Number & Year: 2301NEFOST, FFY 2023; 202323S251443, FFY 2023; 2301NEADPT, FFY 2023 Federal Grantor Agency: U.S. Department of Health and Human Services and U.S. Department of Agriculture Criteria: 45 CFR § 75.405(a) (October 1, 2022) and 2 CFR § 200.405 (January 1, 2023) state, in part, the following: A cost is allocable to a particular Federal award or other cost objective if the goods or services involved are chargeable or assignable to that Federal award or cost objective in accordance with relative benefits received. 45 CFR § 75.403 (October 1, 2022) and 2 CFR § 200.403 (January 1, 2023) provide the following, in relevant part: Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. * * * * (g) Be adequately documented. See also §§ 75.300 through 75.309. Per 45 CFR § 75.303 (October 1, 2022) and 2 CFR § 200.303 (January 1, 2023), The non-Federal entity must: (a) Establish and maintain effective internal control 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. Per the CAP’s RMTS Time Study Design/Coding Structure: [P]articipants are asked whether they are working on an activity that is client related. If they select “Yes” to this question, they are asked to identify the Case ID and type of case . . . . Per the CAP’s RMTS Survey Validation: The contractor and the NE DHHS staff review subsample responses to ensure the activity selected matches the description provided. If the activity and description do not match, the participant is notified and the moment is considered invalid. Per the CAP’s RMTS Response Time/Non-Responses: Participants have two (2) calendar days to respond to each moment. The two (2) day response time allows workers who may spend time outside of their office location and away from email the opportunity to respond to the moment before it expires. The two (2) day period is inclusive of calendar hours and not business days . . . . Good internal control and sound accounting practices require procedures to ensure that staff know how to complete accurate random moment time studies, which are used to allocate costs to Federal programs. Condition: The Agency did not have adequate procedures to ensure payroll charges were proper. Repeat Finding: 2022-024 Questioned Costs: $55,666 known See Schedule of Findings and Questioned Costs for chart/table. Statistical Sample: No Context: The Random Moment Time Study (RMTS) is conducted on an ongoing basis to provide data for the allocations of direct and indirect costs to various programs. The objective is to identify employee efforts directly related to programs administered by the Agency. We tested 55 RMTS surveys and noted 18 errors resulting in questioned costs as follows: • For 10 of 15 surveys tested, the workers erroneously reported they were working on a Foster Care IV-E (Federally funded) case when the survey should have been reported as Foster Care Non IV-E; therefore, Foster Care was overcharged. o For two surveys, the cases had previously been IV-E Foster Care cases but were changed to Non IV-E cases the month prior to the surveys submitted by the Child and Family Services Specialists. o For one survey, the worker completed the survey three calendar days after the RMTS was generated and the activity described on the survey form was for the date submitted, not when the RMTS was generated. • For 7 of 19 Supplemental Nutrition Assistance Program (SNAP) surveys tested, the RMTS survey form appeared to have been completed incorrectly. o For two surveys, the workers selected SNAP; however, per the case files, the case worker appeared to be working on Low Income Home Energy Assistance (LIHEAP) and not on SNAP. o For one survey, the worker stated on the survey form they were working on a case activity for SNAP; however, no case file name or identification case number was given to identify what case was being worked. o For three surveys, the workers selected the SNAP program; however, we could not confirm from the documentation on file what the worker was working on, and the questioned costs are unknown. o For one survey, the case worker selected the SNAP program; however, per the case files, the case worker appeared to be working on other programs along with SNAP at the time of the survey. • For one of seven Adoption IV-E surveys tested, the worker erroneously reported that they were working on an Adoption IV-E case when the survey should have been reported as Foster Care IV-E; therefore, Adoption IV-E was overcharged. Total known Federal payment errors, amount tested, error rate (amount of errors/amount tested), total dollars charged via RMTS, and potential dollars at risk (dollar rate multiplied by the population total dollars charged) are summarized below by program: See Schedule of Findings and Questioned Costs for chart/table. Cause: The Agency’s training of staff and supervisor reviews of RMTS surveys were not sufficient to ensure the surveys were accurately completed. Effect: Random moment sampling is based on the laws of probability, which state, in essence, that there is a high probability that a relatively small number of random surveys will yield an accurate depiction of the overall characteristics of the population for which the sample was taken. If RMTS surveys are not accurate, there is an increased risk costs will be allocated incorrectly between programs. Recommendation: We recommend the Agency improve procedures to ensure that random moment surveys are accurate and adequately reviewed. Management Response: The Agency agrees.
Program: AL 12.401 – National Guard Military Operations and Maintenance (O&M) Projects – Cash Management & Reporting Grant Number & Year: Appendices – W91243-21-2-1001, FFY 2021; W91243-22-2-1001, FFY 2022; W91243-22-2-1002, FFY 2022; W91243-22-2-1005, FFY 2022; W91243-22-2-1007, FFY 2022; W91243-22-2-1021, FFY 2022; W91243-22-2-1023, FFY 2022; W91243-22-2-1031, FFY 2022; W91243-23-2-1001, FFY 2023; W91243-23-2-1003, FFY 2023; W91243-23-2-1005, FFY 2023; W91243-23-2-1010, FFY 2023; W91243-23-2-1021, FFY 2023; W91243-23-2-1023, FFY 2023; W91243-23-2-1024, FFY 2023; W91243-23-2-1031, FFY 2023. Federal Grantor Agency: U.S. Department of Defense Criteria: Per 2 CFR § 1128.100 and 2 CFR § 1128.200 (January 1, 2023), the Department of Defense adopted the Uniform Administrative Requirements, Cost Principles, and Audit Requirements set forth at 2 CFR parts 200.302, 200.303, and 200.305. Per 2 CFR § 200.303 (January 1, 2023): The non-Federal entity must: (a) Establish and maintain effective internal control 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. Title 2 CFR § 200.302 (January 1, 2023) requires financial management systems of the State be sufficient to permit both the preparation of required reports and tracing of funds to expenditures adequate to establish that the use of these funds was in accordance with applicable regulations. EnterpriseOne is the official accounting system for the State of Nebraska, and all expenditures are generated from it. Title 2 CFR § 200.305(a) (January 1, 2023) states, in part, “For states, payments are governed by Treasury-State Cash Management Improvement Act (CMIA) agreements and default procedures codified at 31 CFR part 205 . . . .” Title 31 CFR Part 205 (July 1, 2022) implements the CMIA and requires State recipients to enter into agreements that document accepted funding techniques for Federal assistance programs. The CMIA Agreement between the State of Nebraska, Secretary of the Treasury, and U.S. Department of the Treasury, for the period July 1, 2022, through June 30, 2023, allows the program to request Federal funds in accordance with the monthly draw funding technique, which bases the amount requested on costs estimated to be incurred in the next month. Master Cooperative Agreement (October 2022), Article V – Payment, Section 503, Payment by Advance Method, states, “The advance payment method shall be according to procedures established in current NGB-AQ policy, NGR 5-1 Chapter 11 or successor CNGB I & M, and 2 CFR §200.305.” National Guard Policy (NG Policy) 5-1, National Guard Grants and Cooperative Agreements, Section 11-5, Advance Payment Method, Section (5), states, in part, “[T]he grantee agrees to minimize the time elapsing between the transfer of funds from the U.S. Treasury and their disbursement by the State. (no more than 45 days).” GCAPL 20-02 AQ-A Policy (February 4, 2020) turned NGR 5-1 into NG Policy 5-1. It generally maintained the principles and operational aspects of NGR 5-1, except as provisions of the document were adjusted in the AQ-A Policy. The AQ-A Policy did not make any changes to the 45-day requirement found in NGR 5-1. Instructions for OMB Standard Form 270 (REV. 1/2016) include the following for line 11a, “Enter program outlays to date (net of refunds, rebates, and discounts), in the appropriate columns. For requests prepared on a cash basis, outlays are the sum of actual cash disbursements for goods and services, the amount of indirect expenses charged, the value of in- kind contributions applied, and the amount of cash advances and payments made to subcontractors and subrecipients.” Title 2 CFR § 200.511(b) (January 1, 2023) states in relevant part, the following: The summary schedule of prior audit findings must report the status of all audit findings included in the prior audit’s schedule of findings and questioned costs. . . . * * * * (2) When audit findings were not corrected or were only partially corrected, the summary schedule must describe the reasons for the finding's recurrence and planned corrective action, and any partial corrective action taken. When corrective action taken is significantly different from corrective action previously reported in a corrective action plan or in the Federal agency's or pass-through entity's management decision, the summary schedule must provide an explanation. A good internal control plan would include procedures to ensure that the times between the drawdown of Federal funds and the disbursements thereof are minimized and in compliance with State of Nebraska CMIA Agreement and National Guard Regulations. Condition: The Agency was not in compliance with the Federal cash management requirements during the fiscal year and did not properly report program outlays on the OMB Standard Form (SF) 270. A similar finding was noted in the prior audit. Repeat Finding: 2022-050 Questioned Costs: None Statistical Sample: No Context: We tested 25 drawdowns of Federal funds to support the Agency’s operations and noted the following: • Eleven drawdowns were not in compliance with NG Policy 5-1. The draws were expended from 48 to 166 days after the drawdown of Federal funds. The table below provides a summary of the 11 draws: See Schedule of Findings and Questioned Costs for chart/table. • In addition, five draws were not in compliance with CMIA Agreement requirements. Advance amounts were requested based on estimated costs to be incurred during the month covered by the requests. To determine the reasonableness of the estimates, the APA determined the time it took the Agency to expend amounts advanced (without consideration of any cash on hand). Five draws were expended between 48 and 111 days after the drawdown of Federal funds. • For 23 of 25 SF-270’s tested, the Agency did not properly report total program outlays on the OMB SF-270 report. The Agency reported the total drawdowns for the program to date, rather than actual cash disbursements, as total program outlays. The variance between what was reported and what should have been reported ranged from an underreporting of $45,247 to an overreporting of $1,143,496, with a net total overreporting of expenditures by $5,104,828 for the 25 reports tested. A similar finding was noted during the previous audit. In the Summary Schedule of Prior Audit Findings, the Agency stated the following as a reason for the recurrence: The requirement per the CMIA Agreement which requires the program to request Federal funds in accordance with the pre-issuance funding technique and that such funds are to be requested and deposited in a state account not more than three business days prior to disbursement of funds is not a reasonable standard for the National Guard Military Operations and Maintenance Program. The Agency stated further that it will seek a modification to the CMIA Agreement. However, under the State’s fiscal year 2022 and 2023 CMIA Agreements, the program is no longer required to follow the pre-issuance funding technique and instead follows the monthly draw funding technique. Thus, the Summary Schedule of Prior Audit Findings is not accurate. Cause: Inadequate procedures for estimating cash needs for the upcoming month. Regarding SF-270 reporting, the Agency stated that it did not plan to implement corrective action until State fiscal year 2024. Effect: The Agency is not in compliance with Federal cash management and reporting requirements, which could result in sanctions. Additionally, there is an increased risk for the loss of Federal funding. Recommendation: We recommend the Agency ensure the amount of time between the Federal draw and the disbursement of funds by the State is minimized and in compliance with the State of Nebraska CMIA Agreement and National Guard requirements. We also recommend the Agency report total program outlays in compliance with Federal requirements. Management Response: The Agency agrees with the finding. The drawdown timeline is a partial result of the variances in federal reimbursement functionalities and advance state requirement functionalities. The State Services Support Division has simultaneously been prioritizing workloads due to staffing shortages persistent through the first quarter end of fiscal year 2023-2024.
Program: AL 93.558 – Temporary Assistance for Needy Families; AL 93.563 – Child Support Enforcement; AL 93.568 – Low Income Home Energy Assistance (LIHEAP); AL 93.575 – Child Care and Development Block Grant; AL 93.658 – Foster Care Title IV-E; AL 93.778 – Medical Assistance Program; AL 10.561 – State Administrative Matching Grants for the Supplemental Nutrition Assistance Program – Allowable Costs/Cost Principles Grant Number & Year: 2001NETANF, FFY 2020; 2301NECSES, FFY 2023; 2301NELIEA, FFY 2023; 2301NECCDD, FFY 2023; 2301NEFOST, FFY 2023; 2305NE5ADM, FFY 2023; 233NE406S2514, FFY 2023 Federal Grantor Agency: U.S. Department of Health and Human Services and U.S. Department of Agriculture Criteria: 45 CFR § 75.405(a) (October 1, 2022) and 2 CFR § 200.405 (January 1, 2023) state, in part, the following: A cost is allocable to a particular Federal award or other cost objective if the goods or services involved are chargeable or assignable to that Federal award or cost objective in accordance with relative benefits received. 45 CFR § 75.403 (October 1, 2022) and 2 CFR § 200.403 (January 1, 2023) provide the following, in relevant part: Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. * * * * (g) Be adequately documented. See also §§ 75.300 through 75.309. Per 45 CFR § 75.303 (October 1, 2022) and 2 CFR § 200.303 (January 1, 2023), The non-Federal entity must: (a) Establish and maintain effective internal control 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. Title 45 CFR § 75.302 (October 1, 2022) and 2 CFR § 200.302 (January 1, 2023) require financial management systems of the State sufficient to permit preparation of required reports and permit the tracing of funds to expenditures adequate to establish the use of these funds were in accordance with applicable regulations. EnterpriseOne is the official accounting system for the State of Nebraska, and all expenditures are generated from it. Good internal control requires procedures to ensure that amounts charged to Federal funds are proper. Condition: Procedures to ensure journal entries and adjustments to the Public Assistance Cost Allocation Plan (PACAP) were not adequate, resulting in multiple Federal programs being overcharged. Repeat Finding: No Questioned Costs: $581,496 known See Schedule of Findings and Questioned Costs for chart/table. Statistical Sample: No Context: Each quarter, as the PACAP is prepared, the Agency makes multiple adjustments for costs that either were charged to Federal funds and should not have been, or costs that were not charged to Federal funds but are claimable to a Federal grant. We tested five adjustments between two quarters. One adjustment tested for the quarter ended December 31, 2022, was recorded to charge the Foster Care grant for allowable costs incurred by the Foster Care Review Office (FCRO), a separate agency. The amounts provided by FCRO erroneously included payroll charges from a previous quarter, inflating the amount charged. The FCRO later caught the mistake and adjusted the internal spreadsheet but did not alert the Agency to the error, so a correcting adjustment was never made to the PACAP. The amount charged was $353,984; however, the adjustment should have been $212,725, a difference of $141,259. Foster Care is matched at 50%, so the grant was overcharged $70,629, which are questioned costs. Due to this error, we reviewed a second Foster Care adjustment for the quarter ending March 31, 2023, and noted the Agency’s calculation included amounts for a State funded program that should have been removed, resulting in the grant being overcharged an additional $1,561. We also tested six journal entries that moved costs between cost centers to determine any impact on the PACAP and if those journal entries were appropriate. We noted three improper journal entries that the Agency had not corrected as of the end of the fiscal year: • A journal entry for $526,487 was performed in November 2022 to temporarily move postage costs of multiple programs from State funds to the Child Support Enforcement (CSE) grant until new coding could be created in the State’s accounting system to track expenses from one fiscal year to another. The intent was to reverse the entry as soon as the new coding was completed; however, the reversing entry was never performed. Since the Agency performs a quarterly adjustment for the CSE grant to charge indirect costs identified by the Agency’s PACAP to the grant, the CSE grant was overcharged a total of $263,628. No correcting entry had been made as of September 30, 2023. These are considered questioned costs. • A journal entry for $207,369 was performed in December 2022 to move expenses to allow payroll to post. The intent was to reverse the entry before the end of the fiscal year; however, that was not done. The expenses were moved from Medicaid administration and were charged to the Central Services and Supplies Cost Center, which is then allocated to numerous other Cost Centers that are further allocated or charged directly to Federal programs such as TANF and Child Care. Due to the intricacies of PACAP allocations, exact questioned costs are unknown. No correcting entry was made as of September 30, 2023. • A journal entry for $5,317,640 was done in February 2023 to move Premium Pay to the Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) grant as additional pay for certain job roles allowed under that grant. However, the entry performed included some lines that were miscoded, most significantly a line for $764,187 that was supposed to move money within the same Cost Center (CC 25C21910 – Field Office Administration); however, it pulled costs out of Cost Center 25C21780 - Protection and Safety Policy Chief instead. Additionally, we confirmed with the Agency that the costs charged to CC 25C21910 under the CSLFRF grant were also allocated to other Federal programs through the PACAP, essentially charging Federal programs twice. Due to the intricacies of the PACAP allocations, total questioned costs are unknown; however, we were able to determine that this error caused Medicaid to be overcharged $149,478, LIHEAP to be overcharged $33,447, SNAP to be overcharged $44,984, Child Care to be overcharged $10,412, and TANF to be overcharged $7,357. Cause: Inadequate procedures to ensure that adjustments to the PACAP are proper and that journal entries are appropriate for each program. Effect: Unallowable expenditures were charged to Federal funds and there is an increased risk for errors, fraud, and non-compliance with Federal regulations. Recommendation: We recommend the Agency strengthen procedures to ensure adjusting entries are complete and accurate. We further recommend the Agency strengthen procedures to ensure compliance with Federal regulations. Management Response: The Agency agrees.
Program: AL 93.558 – Temporary Assistance for Needy Families; AL 93.563 – Child Support Enforcement; AL 93.568 – Low Income Home Energy Assistance (LIHEAP); AL 93.575 – Child Care and Development Block Grant; AL 93.658 – Foster Care Title IV-E; AL 93.778 – Medical Assistance Program; AL 10.561 – State Administrative Matching Grants for the Supplemental Nutrition Assistance Program – Allowable Costs/Cost Principles Grant Number & Year: 2001NETANF, FFY 2020; 2301NECSES, FFY 2023; 2301NELIEA, FFY 2023; 2301NECCDD, FFY 2023; 2301NEFOST, FFY 2023; 2305NE5ADM, FFY 2023; 233NE406S2514, FFY 2023 Federal Grantor Agency: U.S. Department of Health and Human Services and U.S. Department of Agriculture Criteria: 45 CFR § 75.405(a) (October 1, 2022) and 2 CFR § 200.405 (January 1, 2023) state, in part, the following: A cost is allocable to a particular Federal award or other cost objective if the goods or services involved are chargeable or assignable to that Federal award or cost objective in accordance with relative benefits received. 45 CFR § 75.403 (October 1, 2022) and 2 CFR § 200.403 (January 1, 2023) provide the following, in relevant part: Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. * * * * (g) Be adequately documented. See also §§ 75.300 through 75.309. Per 45 CFR § 75.303 (October 1, 2022) and 2 CFR § 200.303 (January 1, 2023), The non-Federal entity must: (a) Establish and maintain effective internal control 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. Title 45 CFR § 75.302 (October 1, 2022) and 2 CFR § 200.302 (January 1, 2023) require financial management systems of the State sufficient to permit preparation of required reports and permit the tracing of funds to expenditures adequate to establish the use of these funds were in accordance with applicable regulations. EnterpriseOne is the official accounting system for the State of Nebraska, and all expenditures are generated from it. Good internal control requires procedures to ensure that amounts charged to Federal funds are proper. Condition: Procedures to ensure journal entries and adjustments to the Public Assistance Cost Allocation Plan (PACAP) were not adequate, resulting in multiple Federal programs being overcharged. Repeat Finding: No Questioned Costs: $581,496 known See Schedule of Findings and Questioned Costs for chart/table. Statistical Sample: No Context: Each quarter, as the PACAP is prepared, the Agency makes multiple adjustments for costs that either were charged to Federal funds and should not have been, or costs that were not charged to Federal funds but are claimable to a Federal grant. We tested five adjustments between two quarters. One adjustment tested for the quarter ended December 31, 2022, was recorded to charge the Foster Care grant for allowable costs incurred by the Foster Care Review Office (FCRO), a separate agency. The amounts provided by FCRO erroneously included payroll charges from a previous quarter, inflating the amount charged. The FCRO later caught the mistake and adjusted the internal spreadsheet but did not alert the Agency to the error, so a correcting adjustment was never made to the PACAP. The amount charged was $353,984; however, the adjustment should have been $212,725, a difference of $141,259. Foster Care is matched at 50%, so the grant was overcharged $70,629, which are questioned costs. Due to this error, we reviewed a second Foster Care adjustment for the quarter ending March 31, 2023, and noted the Agency’s calculation included amounts for a State funded program that should have been removed, resulting in the grant being overcharged an additional $1,561. We also tested six journal entries that moved costs between cost centers to determine any impact on the PACAP and if those journal entries were appropriate. We noted three improper journal entries that the Agency had not corrected as of the end of the fiscal year: • A journal entry for $526,487 was performed in November 2022 to temporarily move postage costs of multiple programs from State funds to the Child Support Enforcement (CSE) grant until new coding could be created in the State’s accounting system to track expenses from one fiscal year to another. The intent was to reverse the entry as soon as the new coding was completed; however, the reversing entry was never performed. Since the Agency performs a quarterly adjustment for the CSE grant to charge indirect costs identified by the Agency’s PACAP to the grant, the CSE grant was overcharged a total of $263,628. No correcting entry had been made as of September 30, 2023. These are considered questioned costs. • A journal entry for $207,369 was performed in December 2022 to move expenses to allow payroll to post. The intent was to reverse the entry before the end of the fiscal year; however, that was not done. The expenses were moved from Medicaid administration and were charged to the Central Services and Supplies Cost Center, which is then allocated to numerous other Cost Centers that are further allocated or charged directly to Federal programs such as TANF and Child Care. Due to the intricacies of PACAP allocations, exact questioned costs are unknown. No correcting entry was made as of September 30, 2023. • A journal entry for $5,317,640 was done in February 2023 to move Premium Pay to the Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) grant as additional pay for certain job roles allowed under that grant. However, the entry performed included some lines that were miscoded, most significantly a line for $764,187 that was supposed to move money within the same Cost Center (CC 25C21910 – Field Office Administration); however, it pulled costs out of Cost Center 25C21780 - Protection and Safety Policy Chief instead. Additionally, we confirmed with the Agency that the costs charged to CC 25C21910 under the CSLFRF grant were also allocated to other Federal programs through the PACAP, essentially charging Federal programs twice. Due to the intricacies of the PACAP allocations, total questioned costs are unknown; however, we were able to determine that this error caused Medicaid to be overcharged $149,478, LIHEAP to be overcharged $33,447, SNAP to be overcharged $44,984, Child Care to be overcharged $10,412, and TANF to be overcharged $7,357. Cause: Inadequate procedures to ensure that adjustments to the PACAP are proper and that journal entries are appropriate for each program. Effect: Unallowable expenditures were charged to Federal funds and there is an increased risk for errors, fraud, and non-compliance with Federal regulations. Recommendation: We recommend the Agency strengthen procedures to ensure adjusting entries are complete and accurate. We further recommend the Agency strengthen procedures to ensure compliance with Federal regulations. Management Response: The Agency agrees.
Program: AL 93.558 – Temporary Assistance for Needy Families; AL 93.563 – Child Support Enforcement; AL 93.568 – Low Income Home Energy Assistance (LIHEAP); AL 93.575 – Child Care and Development Block Grant; AL 93.658 – Foster Care Title IV-E; AL 93.778 – Medical Assistance Program; AL 10.561 – State Administrative Matching Grants for the Supplemental Nutrition Assistance Program – Allowable Costs/Cost Principles Grant Number & Year: 2001NETANF, FFY 2020; 2301NECSES, FFY 2023; 2301NELIEA, FFY 2023; 2301NECCDD, FFY 2023; 2301NEFOST, FFY 2023; 2305NE5ADM, FFY 2023; 233NE406S2514, FFY 2023 Federal Grantor Agency: U.S. Department of Health and Human Services and U.S. Department of Agriculture Criteria: 45 CFR § 75.405(a) (October 1, 2022) and 2 CFR § 200.405 (January 1, 2023) state, in part, the following: A cost is allocable to a particular Federal award or other cost objective if the goods or services involved are chargeable or assignable to that Federal award or cost objective in accordance with relative benefits received. 45 CFR § 75.403 (October 1, 2022) and 2 CFR § 200.403 (January 1, 2023) provide the following, in relevant part: Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. * * * * (g) Be adequately documented. See also §§ 75.300 through 75.309. Per 45 CFR § 75.303 (October 1, 2022) and 2 CFR § 200.303 (January 1, 2023), The non-Federal entity must: (a) Establish and maintain effective internal control 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. Title 45 CFR § 75.302 (October 1, 2022) and 2 CFR § 200.302 (January 1, 2023) require financial management systems of the State sufficient to permit preparation of required reports and permit the tracing of funds to expenditures adequate to establish the use of these funds were in accordance with applicable regulations. EnterpriseOne is the official accounting system for the State of Nebraska, and all expenditures are generated from it. Good internal control requires procedures to ensure that amounts charged to Federal funds are proper. Condition: Procedures to ensure journal entries and adjustments to the Public Assistance Cost Allocation Plan (PACAP) were not adequate, resulting in multiple Federal programs being overcharged. Repeat Finding: No Questioned Costs: $581,496 known See Schedule of Findings and Questioned Costs for chart/table. Statistical Sample: No Context: Each quarter, as the PACAP is prepared, the Agency makes multiple adjustments for costs that either were charged to Federal funds and should not have been, or costs that were not charged to Federal funds but are claimable to a Federal grant. We tested five adjustments between two quarters. One adjustment tested for the quarter ended December 31, 2022, was recorded to charge the Foster Care grant for allowable costs incurred by the Foster Care Review Office (FCRO), a separate agency. The amounts provided by FCRO erroneously included payroll charges from a previous quarter, inflating the amount charged. The FCRO later caught the mistake and adjusted the internal spreadsheet but did not alert the Agency to the error, so a correcting adjustment was never made to the PACAP. The amount charged was $353,984; however, the adjustment should have been $212,725, a difference of $141,259. Foster Care is matched at 50%, so the grant was overcharged $70,629, which are questioned costs. Due to this error, we reviewed a second Foster Care adjustment for the quarter ending March 31, 2023, and noted the Agency’s calculation included amounts for a State funded program that should have been removed, resulting in the grant being overcharged an additional $1,561. We also tested six journal entries that moved costs between cost centers to determine any impact on the PACAP and if those journal entries were appropriate. We noted three improper journal entries that the Agency had not corrected as of the end of the fiscal year: • A journal entry for $526,487 was performed in November 2022 to temporarily move postage costs of multiple programs from State funds to the Child Support Enforcement (CSE) grant until new coding could be created in the State’s accounting system to track expenses from one fiscal year to another. The intent was to reverse the entry as soon as the new coding was completed; however, the reversing entry was never performed. Since the Agency performs a quarterly adjustment for the CSE grant to charge indirect costs identified by the Agency’s PACAP to the grant, the CSE grant was overcharged a total of $263,628. No correcting entry had been made as of September 30, 2023. These are considered questioned costs. • A journal entry for $207,369 was performed in December 2022 to move expenses to allow payroll to post. The intent was to reverse the entry before the end of the fiscal year; however, that was not done. The expenses were moved from Medicaid administration and were charged to the Central Services and Supplies Cost Center, which is then allocated to numerous other Cost Centers that are further allocated or charged directly to Federal programs such as TANF and Child Care. Due to the intricacies of PACAP allocations, exact questioned costs are unknown. No correcting entry was made as of September 30, 2023. • A journal entry for $5,317,640 was done in February 2023 to move Premium Pay to the Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) grant as additional pay for certain job roles allowed under that grant. However, the entry performed included some lines that were miscoded, most significantly a line for $764,187 that was supposed to move money within the same Cost Center (CC 25C21910 – Field Office Administration); however, it pulled costs out of Cost Center 25C21780 - Protection and Safety Policy Chief instead. Additionally, we confirmed with the Agency that the costs charged to CC 25C21910 under the CSLFRF grant were also allocated to other Federal programs through the PACAP, essentially charging Federal programs twice. Due to the intricacies of the PACAP allocations, total questioned costs are unknown; however, we were able to determine that this error caused Medicaid to be overcharged $149,478, LIHEAP to be overcharged $33,447, SNAP to be overcharged $44,984, Child Care to be overcharged $10,412, and TANF to be overcharged $7,357. Cause: Inadequate procedures to ensure that adjustments to the PACAP are proper and that journal entries are appropriate for each program. Effect: Unallowable expenditures were charged to Federal funds and there is an increased risk for errors, fraud, and non-compliance with Federal regulations. Recommendation: We recommend the Agency strengthen procedures to ensure adjusting entries are complete and accurate. We further recommend the Agency strengthen procedures to ensure compliance with Federal regulations. Management Response: The Agency agrees.
Program: AL 93.558 – Temporary Assistance for Needy Families; AL 93.563 – Child Support Enforcement; AL 93.568 – Low Income Home Energy Assistance (LIHEAP); AL 93.575 – Child Care and Development Block Grant; AL 93.658 – Foster Care Title IV-E; AL 93.778 – Medical Assistance Program; AL 10.561 – State Administrative Matching Grants for the Supplemental Nutrition Assistance Program – Allowable Costs/Cost Principles Grant Number & Year: 2001NETANF, FFY 2020; 2301NECSES, FFY 2023; 2301NELIEA, FFY 2023; 2301NECCDD, FFY 2023; 2301NEFOST, FFY 2023; 2305NE5ADM, FFY 2023; 233NE406S2514, FFY 2023 Federal Grantor Agency: U.S. Department of Health and Human Services and U.S. Department of Agriculture Criteria: 45 CFR § 75.405(a) (October 1, 2022) and 2 CFR § 200.405 (January 1, 2023) state, in part, the following: A cost is allocable to a particular Federal award or other cost objective if the goods or services involved are chargeable or assignable to that Federal award or cost objective in accordance with relative benefits received. 45 CFR § 75.403 (October 1, 2022) and 2 CFR § 200.403 (January 1, 2023) provide the following, in relevant part: Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. * * * * (g) Be adequately documented. See also §§ 75.300 through 75.309. Per 45 CFR § 75.303 (October 1, 2022) and 2 CFR § 200.303 (January 1, 2023), The non-Federal entity must: (a) Establish and maintain effective internal control 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. Title 45 CFR § 75.302 (October 1, 2022) and 2 CFR § 200.302 (January 1, 2023) require financial management systems of the State sufficient to permit preparation of required reports and permit the tracing of funds to expenditures adequate to establish the use of these funds were in accordance with applicable regulations. EnterpriseOne is the official accounting system for the State of Nebraska, and all expenditures are generated from it. Good internal control requires procedures to ensure that amounts charged to Federal funds are proper. Condition: Procedures to ensure journal entries and adjustments to the Public Assistance Cost Allocation Plan (PACAP) were not adequate, resulting in multiple Federal programs being overcharged. Repeat Finding: No Questioned Costs: $581,496 known See Schedule of Findings and Questioned Costs for chart/table. Statistical Sample: No Context: Each quarter, as the PACAP is prepared, the Agency makes multiple adjustments for costs that either were charged to Federal funds and should not have been, or costs that were not charged to Federal funds but are claimable to a Federal grant. We tested five adjustments between two quarters. One adjustment tested for the quarter ended December 31, 2022, was recorded to charge the Foster Care grant for allowable costs incurred by the Foster Care Review Office (FCRO), a separate agency. The amounts provided by FCRO erroneously included payroll charges from a previous quarter, inflating the amount charged. The FCRO later caught the mistake and adjusted the internal spreadsheet but did not alert the Agency to the error, so a correcting adjustment was never made to the PACAP. The amount charged was $353,984; however, the adjustment should have been $212,725, a difference of $141,259. Foster Care is matched at 50%, so the grant was overcharged $70,629, which are questioned costs. Due to this error, we reviewed a second Foster Care adjustment for the quarter ending March 31, 2023, and noted the Agency’s calculation included amounts for a State funded program that should have been removed, resulting in the grant being overcharged an additional $1,561. We also tested six journal entries that moved costs between cost centers to determine any impact on the PACAP and if those journal entries were appropriate. We noted three improper journal entries that the Agency had not corrected as of the end of the fiscal year: • A journal entry for $526,487 was performed in November 2022 to temporarily move postage costs of multiple programs from State funds to the Child Support Enforcement (CSE) grant until new coding could be created in the State’s accounting system to track expenses from one fiscal year to another. The intent was to reverse the entry as soon as the new coding was completed; however, the reversing entry was never performed. Since the Agency performs a quarterly adjustment for the CSE grant to charge indirect costs identified by the Agency’s PACAP to the grant, the CSE grant was overcharged a total of $263,628. No correcting entry had been made as of September 30, 2023. These are considered questioned costs. • A journal entry for $207,369 was performed in December 2022 to move expenses to allow payroll to post. The intent was to reverse the entry before the end of the fiscal year; however, that was not done. The expenses were moved from Medicaid administration and were charged to the Central Services and Supplies Cost Center, which is then allocated to numerous other Cost Centers that are further allocated or charged directly to Federal programs such as TANF and Child Care. Due to the intricacies of PACAP allocations, exact questioned costs are unknown. No correcting entry was made as of September 30, 2023. • A journal entry for $5,317,640 was done in February 2023 to move Premium Pay to the Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) grant as additional pay for certain job roles allowed under that grant. However, the entry performed included some lines that were miscoded, most significantly a line for $764,187 that was supposed to move money within the same Cost Center (CC 25C21910 – Field Office Administration); however, it pulled costs out of Cost Center 25C21780 - Protection and Safety Policy Chief instead. Additionally, we confirmed with the Agency that the costs charged to CC 25C21910 under the CSLFRF grant were also allocated to other Federal programs through the PACAP, essentially charging Federal programs twice. Due to the intricacies of the PACAP allocations, total questioned costs are unknown; however, we were able to determine that this error caused Medicaid to be overcharged $149,478, LIHEAP to be overcharged $33,447, SNAP to be overcharged $44,984, Child Care to be overcharged $10,412, and TANF to be overcharged $7,357. Cause: Inadequate procedures to ensure that adjustments to the PACAP are proper and that journal entries are appropriate for each program. Effect: Unallowable expenditures were charged to Federal funds and there is an increased risk for errors, fraud, and non-compliance with Federal regulations. Recommendation: We recommend the Agency strengthen procedures to ensure adjusting entries are complete and accurate. We further recommend the Agency strengthen procedures to ensure compliance with Federal regulations. Management Response: The Agency agrees.
Program: AL 93.558 – Temporary Assistance for Needy Families; AL 93.563 – Child Support Enforcement; AL 93.568 – Low Income Home Energy Assistance (LIHEAP); AL 93.575 – Child Care and Development Block Grant; AL 93.658 – Foster Care Title IV-E; AL 93.778 – Medical Assistance Program; AL 10.561 – State Administrative Matching Grants for the Supplemental Nutrition Assistance Program – Allowable Costs/Cost Principles Grant Number & Year: 2001NETANF, FFY 2020; 2301NECSES, FFY 2023; 2301NELIEA, FFY 2023; 2301NECCDD, FFY 2023; 2301NEFOST, FFY 2023; 2305NE5ADM, FFY 2023; 233NE406S2514, FFY 2023 Federal Grantor Agency: U.S. Department of Health and Human Services and U.S. Department of Agriculture Criteria: 45 CFR § 75.405(a) (October 1, 2022) and 2 CFR § 200.405 (January 1, 2023) state, in part, the following: A cost is allocable to a particular Federal award or other cost objective if the goods or services involved are chargeable or assignable to that Federal award or cost objective in accordance with relative benefits received. 45 CFR § 75.403 (October 1, 2022) and 2 CFR § 200.403 (January 1, 2023) provide the following, in relevant part: Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. * * * * (g) Be adequately documented. See also §§ 75.300 through 75.309. Per 45 CFR § 75.303 (October 1, 2022) and 2 CFR § 200.303 (January 1, 2023), The non-Federal entity must: (a) Establish and maintain effective internal control 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. Title 45 CFR § 75.302 (October 1, 2022) and 2 CFR § 200.302 (January 1, 2023) require financial management systems of the State sufficient to permit preparation of required reports and permit the tracing of funds to expenditures adequate to establish the use of these funds were in accordance with applicable regulations. EnterpriseOne is the official accounting system for the State of Nebraska, and all expenditures are generated from it. Good internal control requires procedures to ensure that amounts charged to Federal funds are proper. Condition: Procedures to ensure journal entries and adjustments to the Public Assistance Cost Allocation Plan (PACAP) were not adequate, resulting in multiple Federal programs being overcharged. Repeat Finding: No Questioned Costs: $581,496 known See Schedule of Findings and Questioned Costs for chart/table. Statistical Sample: No Context: Each quarter, as the PACAP is prepared, the Agency makes multiple adjustments for costs that either were charged to Federal funds and should not have been, or costs that were not charged to Federal funds but are claimable to a Federal grant. We tested five adjustments between two quarters. One adjustment tested for the quarter ended December 31, 2022, was recorded to charge the Foster Care grant for allowable costs incurred by the Foster Care Review Office (FCRO), a separate agency. The amounts provided by FCRO erroneously included payroll charges from a previous quarter, inflating the amount charged. The FCRO later caught the mistake and adjusted the internal spreadsheet but did not alert the Agency to the error, so a correcting adjustment was never made to the PACAP. The amount charged was $353,984; however, the adjustment should have been $212,725, a difference of $141,259. Foster Care is matched at 50%, so the grant was overcharged $70,629, which are questioned costs. Due to this error, we reviewed a second Foster Care adjustment for the quarter ending March 31, 2023, and noted the Agency’s calculation included amounts for a State funded program that should have been removed, resulting in the grant being overcharged an additional $1,561. We also tested six journal entries that moved costs between cost centers to determine any impact on the PACAP and if those journal entries were appropriate. We noted three improper journal entries that the Agency had not corrected as of the end of the fiscal year: • A journal entry for $526,487 was performed in November 2022 to temporarily move postage costs of multiple programs from State funds to the Child Support Enforcement (CSE) grant until new coding could be created in the State’s accounting system to track expenses from one fiscal year to another. The intent was to reverse the entry as soon as the new coding was completed; however, the reversing entry was never performed. Since the Agency performs a quarterly adjustment for the CSE grant to charge indirect costs identified by the Agency’s PACAP to the grant, the CSE grant was overcharged a total of $263,628. No correcting entry had been made as of September 30, 2023. These are considered questioned costs. • A journal entry for $207,369 was performed in December 2022 to move expenses to allow payroll to post. The intent was to reverse the entry before the end of the fiscal year; however, that was not done. The expenses were moved from Medicaid administration and were charged to the Central Services and Supplies Cost Center, which is then allocated to numerous other Cost Centers that are further allocated or charged directly to Federal programs such as TANF and Child Care. Due to the intricacies of PACAP allocations, exact questioned costs are unknown. No correcting entry was made as of September 30, 2023. • A journal entry for $5,317,640 was done in February 2023 to move Premium Pay to the Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) grant as additional pay for certain job roles allowed under that grant. However, the entry performed included some lines that were miscoded, most significantly a line for $764,187 that was supposed to move money within the same Cost Center (CC 25C21910 – Field Office Administration); however, it pulled costs out of Cost Center 25C21780 - Protection and Safety Policy Chief instead. Additionally, we confirmed with the Agency that the costs charged to CC 25C21910 under the CSLFRF grant were also allocated to other Federal programs through the PACAP, essentially charging Federal programs twice. Due to the intricacies of the PACAP allocations, total questioned costs are unknown; however, we were able to determine that this error caused Medicaid to be overcharged $149,478, LIHEAP to be overcharged $33,447, SNAP to be overcharged $44,984, Child Care to be overcharged $10,412, and TANF to be overcharged $7,357. Cause: Inadequate procedures to ensure that adjustments to the PACAP are proper and that journal entries are appropriate for each program. Effect: Unallowable expenditures were charged to Federal funds and there is an increased risk for errors, fraud, and non-compliance with Federal regulations. Recommendation: We recommend the Agency strengthen procedures to ensure adjusting entries are complete and accurate. We further recommend the Agency strengthen procedures to ensure compliance with Federal regulations. Management Response: The Agency agrees.
Program: AL 93.658 - Foster Care Title IV-E; AL 10.561 - State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; AL 93.659 - Adoption Assistance – Allowable Costs/Cost Principles Grant Number & Year: 2301NEFOST, FFY 2023; 202323S251443, FFY 2023; 2301NEADPT, FFY 2023 Federal Grantor Agency: U.S. Department of Health and Human Services and U.S. Department of Agriculture Criteria: 45 CFR § 75.405(a) (October 1, 2022) and 2 CFR § 200.405 (January 1, 2023) state, in part, the following: A cost is allocable to a particular Federal award or other cost objective if the goods or services involved are chargeable or assignable to that Federal award or cost objective in accordance with relative benefits received. 45 CFR § 75.403 (October 1, 2022) and 2 CFR § 200.403 (January 1, 2023) provide the following, in relevant part: Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. * * * * (g) Be adequately documented. See also §§ 75.300 through 75.309. Per 45 CFR § 75.303 (October 1, 2022) and 2 CFR § 200.303 (January 1, 2023), The non-Federal entity must: (a) Establish and maintain effective internal control 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. Per the CAP’s RMTS Time Study Design/Coding Structure: [P]articipants are asked whether they are working on an activity that is client related. If they select “Yes” to this question, they are asked to identify the Case ID and type of case . . . . Per the CAP’s RMTS Survey Validation: The contractor and the NE DHHS staff review subsample responses to ensure the activity selected matches the description provided. If the activity and description do not match, the participant is notified and the moment is considered invalid. Per the CAP’s RMTS Response Time/Non-Responses: Participants have two (2) calendar days to respond to each moment. The two (2) day response time allows workers who may spend time outside of their office location and away from email the opportunity to respond to the moment before it expires. The two (2) day period is inclusive of calendar hours and not business days . . . . Good internal control and sound accounting practices require procedures to ensure that staff know how to complete accurate random moment time studies, which are used to allocate costs to Federal programs. Condition: The Agency did not have adequate procedures to ensure payroll charges were proper. Repeat Finding: 2022-024 Questioned Costs: $55,666 known See Schedule of Findings and Questioned Costs for chart/table. Statistical Sample: No Context: The Random Moment Time Study (RMTS) is conducted on an ongoing basis to provide data for the allocations of direct and indirect costs to various programs. The objective is to identify employee efforts directly related to programs administered by the Agency. We tested 55 RMTS surveys and noted 18 errors resulting in questioned costs as follows: • For 10 of 15 surveys tested, the workers erroneously reported they were working on a Foster Care IV-E (Federally funded) case when the survey should have been reported as Foster Care Non IV-E; therefore, Foster Care was overcharged. o For two surveys, the cases had previously been IV-E Foster Care cases but were changed to Non IV-E cases the month prior to the surveys submitted by the Child and Family Services Specialists. o For one survey, the worker completed the survey three calendar days after the RMTS was generated and the activity described on the survey form was for the date submitted, not when the RMTS was generated. • For 7 of 19 Supplemental Nutrition Assistance Program (SNAP) surveys tested, the RMTS survey form appeared to have been completed incorrectly. o For two surveys, the workers selected SNAP; however, per the case files, the case worker appeared to be working on Low Income Home Energy Assistance (LIHEAP) and not on SNAP. o For one survey, the worker stated on the survey form they were working on a case activity for SNAP; however, no case file name or identification case number was given to identify what case was being worked. o For three surveys, the workers selected the SNAP program; however, we could not confirm from the documentation on file what the worker was working on, and the questioned costs are unknown. o For one survey, the case worker selected the SNAP program; however, per the case files, the case worker appeared to be working on other programs along with SNAP at the time of the survey. • For one of seven Adoption IV-E surveys tested, the worker erroneously reported that they were working on an Adoption IV-E case when the survey should have been reported as Foster Care IV-E; therefore, Adoption IV-E was overcharged. Total known Federal payment errors, amount tested, error rate (amount of errors/amount tested), total dollars charged via RMTS, and potential dollars at risk (dollar rate multiplied by the population total dollars charged) are summarized below by program: See Schedule of Findings and Questioned Costs for chart/table. Cause: The Agency’s training of staff and supervisor reviews of RMTS surveys were not sufficient to ensure the surveys were accurately completed. Effect: Random moment sampling is based on the laws of probability, which state, in essence, that there is a high probability that a relatively small number of random surveys will yield an accurate depiction of the overall characteristics of the population for which the sample was taken. If RMTS surveys are not accurate, there is an increased risk costs will be allocated incorrectly between programs. Recommendation: We recommend the Agency improve procedures to ensure that random moment surveys are accurate and adequately reviewed. Management Response: The Agency agrees.
Program: AL 93.658 - Foster Care Title IV-E; AL 10.561 - State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; AL 93.659 - Adoption Assistance – Allowable Costs/Cost Principles Grant Number & Year: 2301NEFOST, FFY 2023; 202323S251443, FFY 2023; 2301NEADPT, FFY 2023 Federal Grantor Agency: U.S. Department of Health and Human Services and U.S. Department of Agriculture Criteria: 45 CFR § 75.405(a) (October 1, 2022) and 2 CFR § 200.405 (January 1, 2023) state, in part, the following: A cost is allocable to a particular Federal award or other cost objective if the goods or services involved are chargeable or assignable to that Federal award or cost objective in accordance with relative benefits received. 45 CFR § 75.403 (October 1, 2022) and 2 CFR § 200.403 (January 1, 2023) provide the following, in relevant part: Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. * * * * (g) Be adequately documented. See also §§ 75.300 through 75.309. Per 45 CFR § 75.303 (October 1, 2022) and 2 CFR § 200.303 (January 1, 2023), The non-Federal entity must: (a) Establish and maintain effective internal control 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. Per the CAP’s RMTS Time Study Design/Coding Structure: [P]articipants are asked whether they are working on an activity that is client related. If they select “Yes” to this question, they are asked to identify the Case ID and type of case . . . . Per the CAP’s RMTS Survey Validation: The contractor and the NE DHHS staff review subsample responses to ensure the activity selected matches the description provided. If the activity and description do not match, the participant is notified and the moment is considered invalid. Per the CAP’s RMTS Response Time/Non-Responses: Participants have two (2) calendar days to respond to each moment. The two (2) day response time allows workers who may spend time outside of their office location and away from email the opportunity to respond to the moment before it expires. The two (2) day period is inclusive of calendar hours and not business days . . . . Good internal control and sound accounting practices require procedures to ensure that staff know how to complete accurate random moment time studies, which are used to allocate costs to Federal programs. Condition: The Agency did not have adequate procedures to ensure payroll charges were proper. Repeat Finding: 2022-024 Questioned Costs: $55,666 known See Schedule of Findings and Questioned Costs for chart/table. Statistical Sample: No Context: The Random Moment Time Study (RMTS) is conducted on an ongoing basis to provide data for the allocations of direct and indirect costs to various programs. The objective is to identify employee efforts directly related to programs administered by the Agency. We tested 55 RMTS surveys and noted 18 errors resulting in questioned costs as follows: • For 10 of 15 surveys tested, the workers erroneously reported they were working on a Foster Care IV-E (Federally funded) case when the survey should have been reported as Foster Care Non IV-E; therefore, Foster Care was overcharged. o For two surveys, the cases had previously been IV-E Foster Care cases but were changed to Non IV-E cases the month prior to the surveys submitted by the Child and Family Services Specialists. o For one survey, the worker completed the survey three calendar days after the RMTS was generated and the activity described on the survey form was for the date submitted, not when the RMTS was generated. • For 7 of 19 Supplemental Nutrition Assistance Program (SNAP) surveys tested, the RMTS survey form appeared to have been completed incorrectly. o For two surveys, the workers selected SNAP; however, per the case files, the case worker appeared to be working on Low Income Home Energy Assistance (LIHEAP) and not on SNAP. o For one survey, the worker stated on the survey form they were working on a case activity for SNAP; however, no case file name or identification case number was given to identify what case was being worked. o For three surveys, the workers selected the SNAP program; however, we could not confirm from the documentation on file what the worker was working on, and the questioned costs are unknown. o For one survey, the case worker selected the SNAP program; however, per the case files, the case worker appeared to be working on other programs along with SNAP at the time of the survey. • For one of seven Adoption IV-E surveys tested, the worker erroneously reported that they were working on an Adoption IV-E case when the survey should have been reported as Foster Care IV-E; therefore, Adoption IV-E was overcharged. Total known Federal payment errors, amount tested, error rate (amount of errors/amount tested), total dollars charged via RMTS, and potential dollars at risk (dollar rate multiplied by the population total dollars charged) are summarized below by program: See Schedule of Findings and Questioned Costs for chart/table. Cause: The Agency’s training of staff and supervisor reviews of RMTS surveys were not sufficient to ensure the surveys were accurately completed. Effect: Random moment sampling is based on the laws of probability, which state, in essence, that there is a high probability that a relatively small number of random surveys will yield an accurate depiction of the overall characteristics of the population for which the sample was taken. If RMTS surveys are not accurate, there is an increased risk costs will be allocated incorrectly between programs. Recommendation: We recommend the Agency improve procedures to ensure that random moment surveys are accurate and adequately reviewed. Management Response: The Agency agrees.