Audit 332183

FY End
2024-06-30
Total Expended
$4.23M
Findings
12
Programs
14
Year: 2024 Accepted: 2024-12-12

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
513971 2024-008 Significant Deficiency - L
513972 2024-004 Significant Deficiency Yes L
513973 2024-007 Significant Deficiency - L
513974 2024-006 Significant Deficiency Yes A
513975 2024-004 Significant Deficiency Yes L
513976 2024-005 Significant Deficiency Yes L
1090413 2024-008 Significant Deficiency - L
1090414 2024-004 Significant Deficiency Yes L
1090415 2024-007 Significant Deficiency - L
1090416 2024-006 Significant Deficiency Yes A
1090417 2024-004 Significant Deficiency Yes L
1090418 2024-005 Significant Deficiency Yes L

Contacts

Name Title Type
MZJMSZMXGQL5 Bradford Tuttle Auditee
6184985561 Daniel Phipps Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: Federal awards are accounted for using the cash basis of accounting. The Schedule reflects the cash basis of accounting in which revenues are recognized when received and expenditures are recognized when spent. De Minimis Rate Used: N Rate Explanation: The District did not elect to use the 10% de minimis indirect cost rate. The District elected to use the restricted indirect cost rate of 3.49% and unrestricted indirect cost rate of 17.44%. The accompanying Schedule of Expenditures of Federal Awards (the Schedule) summarizes the expenditures of Community Unit School District No. 100 under programs of the federal government for the fiscal year ended June 30, 2024. Because the Schedule presents only a selected portion of the operations of the District, it is not intended to and does not present the financial position, changes in fund balance, revenues and expenditures of the District. For purposes of the Schedule, federal awards include all grants, contracts and similar agreements entered into directly between the District and agencies and departments of the federal government and all sub-awards to the District by nonfederal organizations pursuant to federal grants, contracts and similar agreements. The schedule presents expenditures by federal agency for the District’s major and nonmajor programs in accordance with the provisions of the U.S. Office of Management and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance).
Title: SUBRECIPIENTS Accounting Policies: Federal awards are accounted for using the cash basis of accounting. The Schedule reflects the cash basis of accounting in which revenues are recognized when received and expenditures are recognized when spent. De Minimis Rate Used: N Rate Explanation: The District did not elect to use the 10% de minimis indirect cost rate. The District elected to use the restricted indirect cost rate of 3.49% and unrestricted indirect cost rate of 17.44%. None.
Title: NONMONETARY DISTRIBUTIONS Accounting Policies: Federal awards are accounted for using the cash basis of accounting. The Schedule reflects the cash basis of accounting in which revenues are recognized when received and expenditures are recognized when spent. De Minimis Rate Used: N Rate Explanation: The District did not elect to use the 10% de minimis indirect cost rate. The District elected to use the restricted indirect cost rate of 3.49% and unrestricted indirect cost rate of 17.44%. During the year ended June 30, 2024, the District received $96,681 in non-cash funding through the Illinois State Board of Education’s Child Nutrition program.
Title: INSURANCE Accounting Policies: Federal awards are accounted for using the cash basis of accounting. The Schedule reflects the cash basis of accounting in which revenues are recognized when received and expenditures are recognized when spent. De Minimis Rate Used: N Rate Explanation: The District did not elect to use the 10% de minimis indirect cost rate. The District elected to use the restricted indirect cost rate of 3.49% and unrestricted indirect cost rate of 17.44%. The District had no insurance as it relates to federal programs in effect for the year ended June 30, 2024.
Title: LOANS AND LOAN GURANTEES Accounting Policies: Federal awards are accounted for using the cash basis of accounting. The Schedule reflects the cash basis of accounting in which revenues are recognized when received and expenditures are recognized when spent. De Minimis Rate Used: N Rate Explanation: The District did not elect to use the 10% de minimis indirect cost rate. The District elected to use the restricted indirect cost rate of 3.49% and unrestricted indirect cost rate of 17.44%. The District had no outstanding loans or loan guarantees from federal sources as of June 30, 2024.

Finding Details

Criteria or specific requirement: Reporting. Condition: The expenditure reports filed with the Illinois State Board of Education do not match the general ledger detail. Questioned Costs: None.. Context: The District reported $56,619 in total expenditures on its June 30, 2024 expenditure report, however the total expenditures in the general ledger as of June 30, 2024 was $55,674. Effect: The general ledger does not match the expenditure repo filed with the Illinois State Board of Education. Cause: The general ledger expenditure report used to prepare the June 30, 2024 quarterly expenditure report filing was ran through July 15, 2024. The general ledger report included $945 in expenditures that occurred in July 2024 and should not have been requested for reimbursement on the June 30, 2024 report filing. Since the expenditure was within the grant period (September 1, 2023 through August 31, 2024) just not within the District's fiscal year it will be considered an error in reporting but not a questioned cost. Recommendation: Project expenditure reports should be reviewed before being used to prepare quarterly expenditure report submissions for reimbursement. Management's response: The District will work to properly report transactions in the future.
Criteria or specific requirement: The District is required to report grant expenditures in accordance with the Illinois State Board of Education State and Federal Grant Administration Policy, Fiscal Requirements, and Procedures in accordance with the Grant Accountability and Transparency Act (GATA), 30 ILCS 708/1 et seq and Title 2 Code of Federal Regulations Part 200 — Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Per the State and Federal Grant Administration Policy, "all federal expenditure reports must be submitted on a cumulative (i.e., year-to-date), cash basis accounting method (i.e., expenses are recognized when they are paid). Outstanding obligations may be reported on June expenditure reports through the project end date – even if the project ends after June. As grantees report cumulative cash basis expenditures via the Electronic Expenditure Reporting system, ISBE will reimburse the expenditures accordingly on a weekly basis. Grantees that submit expenditures only under this traditional reimbursement method can submit as frequent as weekly, but at a minimum, quarterly." Additionally, "expenditure reports are due 20 calendar days after the expenditure through date. Reports not received by the due date will result in project funds being frozen until an acceptable report is submitted." Condition: Quarterly expenditure reports for the projects expenditures were not timely filed for ESSER II CP (1 of 1 quarters required) and ESSER II D2 (1 of 1 quarters required). Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER II CP (1 of 1 quarters required) and ESSER II D2 (1 of 1 quarters required). Effect: Projects may not be properly monitored and funding could be frozen if reports are not timely filed. Cause: Lack of monitoring due dates of required reports. Recommendation: The District should schedule the due dates of all project reports in order to avoid late filings. Management's response: The District will review procedures to determine if added steps are needed to ensure timely grant expenditure reporting.
Criteria or specific requirement: Reporting. Condition: The expenditure reports filed with the Illinois State Board of Education do not match the general ledger detail. Questioned Costs: $202. Context: The District reported $202 of expenditures for supplies in function 1000 object 400, however those same expenditures were already properly reported and reimbursed under ESSER III Digital Equity, project number 2024-4998-D3. Effect: Reimbursement was received for expenditures that were included in another federal program. Cause: Lack of monitoring grant expenditure accounts for proper federal program. Recommendation: Project expenditure reports should be reviewed before being used to prepare quarterly expenditure report submissions for reimbursement. Management's response: The District will work to properly report transactions in the future.
Criteria or specific requirement: The District is required to report grant expenditures in accordance with the Illinois State Board of Education State and Federal Grant Administration Policy, Fiscal Requirements, and Procedures in accordance with the Grant Accountability and Transparency Act (GATA), 30 ILCS 708/1 et seq and Title 2 Code of Federal Regulations Part 200—Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. According to the State and Federal Grant Administration Policy, "Amendments are required when: There is a significant change in program scope (e.g., adding a new component - summer school); or the grantee intends to budget for more available funds (i.e., federal carryover); or the expense expenditures exceed the ISBE expenditure variance of 10 percent or $1,000 per an object total, whichever is greater without going over the total budget; or the grantee adds a new expenditure item." Additionally stated in the document "grantees that submit a state or federal budget amendment between the project begin and end date are not allowed to begin an activity, obligate or expend funds prior to the date of receipt at ISBE, provided the scope or intent of the approved project has not changed." Lastly stated in the document, "any amount reported in an expenditure account (cell) not budgeted or not within the acceptable expenditure variance, will not be accepted. Failure to submit an acceptable report will result in the delay of current payments. Expenditures and obligations in excess of the total project budget will not be allowed." Condition: Expenditures claimed on the projects' quarterly reports were not included in the detailed budget approved by ISBE resulting in questioned costs for the projects. Questioned Costs: $1,215 Context: During detailed testing, there was one expenditure claimed in project 2023-4998-E2 for bus rider trips for summer school for $1,215 that was charged to function 1000 object 100. Per review of the detailed budget, summer school bus rider pay was not included in function 1000 object 100 nor any other budget line item. Effect: Reimbursement was received for expenditures that were not included in the detailed budget resulting in questioned costs. Cause: Lack of monitoring grant expenditure accounts for proper expenditure posting. Recommendation: Project expenditure reports should be compared to the program budget that has been submitted. Budget policies per the State and Federal Grant Administration Policy should be reviewed and followed accordingly. Management's response: The District will work to properly report transactions in the future and follow the guidelines set forth in the policy manual.
Criteria or specific requirement: The District is required to report grant expenditures in accordance with the Illinois State Board of Education State and Federal Grant Administration Policy, Fiscal Requirements, and Procedures in accordance with the Grant Accountability and Transparency Act (GATA), 30 ILCS 708/1 et seq and Title 2 Code of Federal Regulations Part 200 — Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Per the State and Federal Grant Administration Policy, "all federal expenditure reports must be submitted on a cumulative (i.e., year-to-date), cash basis accounting method (i.e., expenses are recognized when they are paid). Outstanding obligations may be reported on June expenditure reports through the project end date – even if the project ends after June. As grantees report cumulative cash basis expenditures via the Electronic Expenditure Reporting system, ISBE will reimburse the expenditures accordingly on a weekly basis. Grantees that submit expenditures only under this traditional reimbursement method can submit as frequent as weekly, but at a minimum, quarterly." Additionally, "expenditure reports are due 20 calendar days after the expenditure through date. Reports not received by the due date will result in project funds being frozen until an acceptable report is submitted." Condition: Quarterly expenditure reports for the projects expenditures were not timely filed for ESSER II CP (1 of 1 quarters required) and ESSER II D2 (1 of 1 quarters required). Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER II CP (1 of 1 quarters required) and ESSER II D2 (1 of 1 quarters required). Effect: Projects may not be properly monitored and funding could be frozen if reports are not timely filed. Cause: Lack of monitoring due dates of required reports. Recommendation: The District should schedule the due dates of all project reports in order to avoid late filings. Management's response: The District will review procedures to determine if added steps are needed to ensure timely grant expenditure reporting.
Criteria or specific requirement: The District is required to report grant expenditures in accordance with the Illinois State Board of Education State and Federal Grant Administration Policy, Fiscal Requirements, and Procedures in accordance with the Grant Accountability and Transparency Act (GATA), 30 ILCS 708/1 et seq and Title 2 Code of Federal Regulations Part 200 — Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Per the State and Federal Grant Administration Policy, "all federal expenditure reports must be submitted on a cumulative (i.e., year-to-date), cash basis accounting method (i.e., expenses are recognized when they are paid). Outstanding obligations may be reported on June expenditure reports through the project end date – even if the project ends after June. As grantees report cumulative cash basis expenditures via the Electronic Expenditure Reporting system, ISBE will reimburse the expenditures accordingly on a weekly basis. Grantees that submit expenditures only under this traditional reimbursement method can submit as frequent as weekly, but at a minimum, quarterly." Additionally, "expenditure reports are due 20 calendar days after the expenditure through date. Reports not received by the due date will result in project funds being frozen until an acceptable report is submitted." Condition: Quarterly expenditure reports for the projects expenditures were not timely filed for ESSER III D3 (2 of 4 quarters required). Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER III D3 (2 of 4 quarters required). Effect: Projects may not be properly monitored and funding could be frozen if reports are not timely filed. Cause: Lack of monitoring due dates of required reports. Recommendation: The District should schedule the due dates of all project reports in order to avoid late filings. Management's response: The District will review procedures to determine if added steps are needed to ensure timely grant expenditure reporting.
Criteria or specific requirement: Reporting. Condition: The expenditure reports filed with the Illinois State Board of Education do not match the general ledger detail. Questioned Costs: None.. Context: The District reported $56,619 in total expenditures on its June 30, 2024 expenditure report, however the total expenditures in the general ledger as of June 30, 2024 was $55,674. Effect: The general ledger does not match the expenditure repo filed with the Illinois State Board of Education. Cause: The general ledger expenditure report used to prepare the June 30, 2024 quarterly expenditure report filing was ran through July 15, 2024. The general ledger report included $945 in expenditures that occurred in July 2024 and should not have been requested for reimbursement on the June 30, 2024 report filing. Since the expenditure was within the grant period (September 1, 2023 through August 31, 2024) just not within the District's fiscal year it will be considered an error in reporting but not a questioned cost. Recommendation: Project expenditure reports should be reviewed before being used to prepare quarterly expenditure report submissions for reimbursement. Management's response: The District will work to properly report transactions in the future.
Criteria or specific requirement: The District is required to report grant expenditures in accordance with the Illinois State Board of Education State and Federal Grant Administration Policy, Fiscal Requirements, and Procedures in accordance with the Grant Accountability and Transparency Act (GATA), 30 ILCS 708/1 et seq and Title 2 Code of Federal Regulations Part 200 — Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Per the State and Federal Grant Administration Policy, "all federal expenditure reports must be submitted on a cumulative (i.e., year-to-date), cash basis accounting method (i.e., expenses are recognized when they are paid). Outstanding obligations may be reported on June expenditure reports through the project end date – even if the project ends after June. As grantees report cumulative cash basis expenditures via the Electronic Expenditure Reporting system, ISBE will reimburse the expenditures accordingly on a weekly basis. Grantees that submit expenditures only under this traditional reimbursement method can submit as frequent as weekly, but at a minimum, quarterly." Additionally, "expenditure reports are due 20 calendar days after the expenditure through date. Reports not received by the due date will result in project funds being frozen until an acceptable report is submitted." Condition: Quarterly expenditure reports for the projects expenditures were not timely filed for ESSER II CP (1 of 1 quarters required) and ESSER II D2 (1 of 1 quarters required). Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER II CP (1 of 1 quarters required) and ESSER II D2 (1 of 1 quarters required). Effect: Projects may not be properly monitored and funding could be frozen if reports are not timely filed. Cause: Lack of monitoring due dates of required reports. Recommendation: The District should schedule the due dates of all project reports in order to avoid late filings. Management's response: The District will review procedures to determine if added steps are needed to ensure timely grant expenditure reporting.
Criteria or specific requirement: Reporting. Condition: The expenditure reports filed with the Illinois State Board of Education do not match the general ledger detail. Questioned Costs: $202. Context: The District reported $202 of expenditures for supplies in function 1000 object 400, however those same expenditures were already properly reported and reimbursed under ESSER III Digital Equity, project number 2024-4998-D3. Effect: Reimbursement was received for expenditures that were included in another federal program. Cause: Lack of monitoring grant expenditure accounts for proper federal program. Recommendation: Project expenditure reports should be reviewed before being used to prepare quarterly expenditure report submissions for reimbursement. Management's response: The District will work to properly report transactions in the future.
Criteria or specific requirement: The District is required to report grant expenditures in accordance with the Illinois State Board of Education State and Federal Grant Administration Policy, Fiscal Requirements, and Procedures in accordance with the Grant Accountability and Transparency Act (GATA), 30 ILCS 708/1 et seq and Title 2 Code of Federal Regulations Part 200—Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. According to the State and Federal Grant Administration Policy, "Amendments are required when: There is a significant change in program scope (e.g., adding a new component - summer school); or the grantee intends to budget for more available funds (i.e., federal carryover); or the expense expenditures exceed the ISBE expenditure variance of 10 percent or $1,000 per an object total, whichever is greater without going over the total budget; or the grantee adds a new expenditure item." Additionally stated in the document "grantees that submit a state or federal budget amendment between the project begin and end date are not allowed to begin an activity, obligate or expend funds prior to the date of receipt at ISBE, provided the scope or intent of the approved project has not changed." Lastly stated in the document, "any amount reported in an expenditure account (cell) not budgeted or not within the acceptable expenditure variance, will not be accepted. Failure to submit an acceptable report will result in the delay of current payments. Expenditures and obligations in excess of the total project budget will not be allowed." Condition: Expenditures claimed on the projects' quarterly reports were not included in the detailed budget approved by ISBE resulting in questioned costs for the projects. Questioned Costs: $1,215 Context: During detailed testing, there was one expenditure claimed in project 2023-4998-E2 for bus rider trips for summer school for $1,215 that was charged to function 1000 object 100. Per review of the detailed budget, summer school bus rider pay was not included in function 1000 object 100 nor any other budget line item. Effect: Reimbursement was received for expenditures that were not included in the detailed budget resulting in questioned costs. Cause: Lack of monitoring grant expenditure accounts for proper expenditure posting. Recommendation: Project expenditure reports should be compared to the program budget that has been submitted. Budget policies per the State and Federal Grant Administration Policy should be reviewed and followed accordingly. Management's response: The District will work to properly report transactions in the future and follow the guidelines set forth in the policy manual.
Criteria or specific requirement: The District is required to report grant expenditures in accordance with the Illinois State Board of Education State and Federal Grant Administration Policy, Fiscal Requirements, and Procedures in accordance with the Grant Accountability and Transparency Act (GATA), 30 ILCS 708/1 et seq and Title 2 Code of Federal Regulations Part 200 — Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Per the State and Federal Grant Administration Policy, "all federal expenditure reports must be submitted on a cumulative (i.e., year-to-date), cash basis accounting method (i.e., expenses are recognized when they are paid). Outstanding obligations may be reported on June expenditure reports through the project end date – even if the project ends after June. As grantees report cumulative cash basis expenditures via the Electronic Expenditure Reporting system, ISBE will reimburse the expenditures accordingly on a weekly basis. Grantees that submit expenditures only under this traditional reimbursement method can submit as frequent as weekly, but at a minimum, quarterly." Additionally, "expenditure reports are due 20 calendar days after the expenditure through date. Reports not received by the due date will result in project funds being frozen until an acceptable report is submitted." Condition: Quarterly expenditure reports for the projects expenditures were not timely filed for ESSER II CP (1 of 1 quarters required) and ESSER II D2 (1 of 1 quarters required). Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER II CP (1 of 1 quarters required) and ESSER II D2 (1 of 1 quarters required). Effect: Projects may not be properly monitored and funding could be frozen if reports are not timely filed. Cause: Lack of monitoring due dates of required reports. Recommendation: The District should schedule the due dates of all project reports in order to avoid late filings. Management's response: The District will review procedures to determine if added steps are needed to ensure timely grant expenditure reporting.
Criteria or specific requirement: The District is required to report grant expenditures in accordance with the Illinois State Board of Education State and Federal Grant Administration Policy, Fiscal Requirements, and Procedures in accordance with the Grant Accountability and Transparency Act (GATA), 30 ILCS 708/1 et seq and Title 2 Code of Federal Regulations Part 200 — Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Per the State and Federal Grant Administration Policy, "all federal expenditure reports must be submitted on a cumulative (i.e., year-to-date), cash basis accounting method (i.e., expenses are recognized when they are paid). Outstanding obligations may be reported on June expenditure reports through the project end date – even if the project ends after June. As grantees report cumulative cash basis expenditures via the Electronic Expenditure Reporting system, ISBE will reimburse the expenditures accordingly on a weekly basis. Grantees that submit expenditures only under this traditional reimbursement method can submit as frequent as weekly, but at a minimum, quarterly." Additionally, "expenditure reports are due 20 calendar days after the expenditure through date. Reports not received by the due date will result in project funds being frozen until an acceptable report is submitted." Condition: Quarterly expenditure reports for the projects expenditures were not timely filed for ESSER III D3 (2 of 4 quarters required). Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER III D3 (2 of 4 quarters required). Effect: Projects may not be properly monitored and funding could be frozen if reports are not timely filed. Cause: Lack of monitoring due dates of required reports. Recommendation: The District should schedule the due dates of all project reports in order to avoid late filings. Management's response: The District will review procedures to determine if added steps are needed to ensure timely grant expenditure reporting.