Audit 2972

FY End
2023-06-30
Total Expended
$5.06M
Findings
20
Programs
15
Year: 2023 Accepted: 2023-11-13

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1703 2023-007 Significant Deficiency - A
1704 2023-007 Significant Deficiency - A
1705 2023-007 Significant Deficiency - A
1706 2023-006 Significant Deficiency - L
1707 2023-008 Significant Deficiency - A
1708 2023-004 Significant Deficiency Yes F
1709 2023-005 Significant Deficiency Yes L
1710 2023-005 Significant Deficiency Yes L
1711 2023-005 Significant Deficiency Yes L
1712 2023-006 Significant Deficiency - L
578145 2023-007 Significant Deficiency - A
578146 2023-007 Significant Deficiency - A
578147 2023-007 Significant Deficiency - A
578148 2023-006 Significant Deficiency - L
578149 2023-008 Significant Deficiency - A
578150 2023-004 Significant Deficiency Yes F
578151 2023-005 Significant Deficiency Yes L
578152 2023-005 Significant Deficiency Yes L
578153 2023-005 Significant Deficiency Yes L
578154 2023-006 Significant Deficiency - 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.68% and unrestricted indirect cost rate of 17.15%. 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, 2023. 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.68% and unrestricted indirect cost rate of 17.15%. 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.68% and unrestricted indirect cost rate of 17.15%. During the year ended June 30, 2023, the District received $71,232 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.68% and unrestricted indirect cost rate of 17.15%. The District had no insurance as it relates to federal programs in effect for the year ended June 30, 2023.
Title: LOANS AND LOAN GUARANTEES 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.68% and unrestricted indirect cost rate of 17.15%. The District had no outstanding loans or loan guarantees from federal sources as of June 30, 2023.

Finding Details

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: $4,387.50; $1,485 for 2021-4998-E2 and $2,902.50 for 2023-4998-E2. Context: During detailed testing, there was one expenditure claimed in project 2021-4998-E2 for bus driver trips for summer school for $1,485 that was charged to function 1000 object 100. Per review of the detailed budget, summer school bus driver pay was not included in function 1000 object 100 nor any other budget line item. There were two expenditures claimed in project 2023-4998-E2 for bus driver trips for summer school for $2,902.50 that were charged to function 1000 object 100. Per review of the detailed budget, summer school bus driver pay was not included in function 1000 object 100 nor any other budget line item. Additionally, there was one expenditure coded in Skyward to function 2900 object 400, however there was no budget item for that function and object. Upon further review, the item should have been recorded in Skyward to function 1000 object 400 where it appropriately fits into the budgeted item. No questioned cost related to this error. 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. 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: $4,387.50; $1,485 for 2021-4998-E2 and $2,902.50 for 2023-4998-E2. Context: During detailed testing, there was one expenditure claimed in project 2021-4998-E2 for bus driver trips for summer school for $1,485 that was charged to function 1000 object 100. Per review of the detailed budget, summer school bus driver pay was not included in function 1000 object 100 nor any other budget line item. There were two expenditures claimed in project 2023-4998-E2 for bus driver trips for summer school for $2,902.50 that were charged to function 1000 object 100. Per review of the detailed budget, summer school bus driver pay was not included in function 1000 object 100 nor any other budget line item. Additionally, there was one expenditure coded in Skyward to function 2900 object 400, however there was no budget item for that function and object. Upon further review, the item should have been recorded in Skyward to function 1000 object 400 where it appropriately fits into the budgeted item. No questioned cost related to this error. 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. 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: $4,387.50; $1,485 for 2021-4998-E2 and $2,902.50 for 2023-4998-E2. Context: During detailed testing, there was one expenditure claimed in project 2021-4998-E2 for bus driver trips for summer school for $1,485 that was charged to function 1000 object 100. Per review of the detailed budget, summer school bus driver pay was not included in function 1000 object 100 nor any other budget line item. There were two expenditures claimed in project 2023-4998-E2 for bus driver trips for summer school for $2,902.50 that were charged to function 1000 object 100. Per review of the detailed budget, summer school bus driver pay was not included in function 1000 object 100 nor any other budget line item. Additionally, there was one expenditure coded in Skyward to function 2900 object 400, however there was no budget item for that function and object. Upon further review, the item should have been recorded in Skyward to function 1000 object 400 where it appropriately fits into the budgeted item. No questioned cost related to this error. 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. Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER III (2 of 4 quarters required) and ESSER III C3 (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. 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 project's quarterly reports were not included in the detailed budget approved by ISBE resulting in questioned costs for the projects. Questioned Costs: 9800. Context: During detailed testing, there were three expenditures charged to function 2210 object 300 that were not included in the detailed budget for function 2210 object 300 nor any other other budget line item. These items included $7,500 for literature blended coaching, $300 for a 6 month google certified coach cohort program, and $2,000 for an author visit to the school. 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: Equipment/Real Property Management. Condition: The District budgeted for and included items in capital outlay objects in both the general ledger and ISBE expenditure reports that were below the District's capitalization threshold of $5,000. Questioned Costs: None. Context: The ESSER III grant included items below the capitalization threshold of $5,000 in capital outlay objects. Effect: The District did not follow it's capitalization threshold as outlined in its Fixed Asset Policy. Cause: This was an oversight by management. Recommendation: The District should only include items greater than its $5,000 capitalization threshold in capital outlay objects in its general ledger, budgets, and expenditure reports filed with ISBE. Management's response: Management will communicate the District's capitalization policy and the proper recording of items that fall underneath the District's capitalization threshold with all District employees who are involved with grant writing, grant reporting, and posting to the general ledger system.
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 D2 (4 of 4 quarters required), ESSER I (1 of 1 quarters required), and ESSER II ST (1 of 1 quarters required). Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER II D2 (4 of 4 quarters required), ESSER I (1 of 1 quarters required), and ESSER II ST (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 II D2 (4 of 4 quarters required), ESSER I (1 of 1 quarters required), and ESSER II ST (1 of 1 quarters required). Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER II D2 (4 of 4 quarters required), ESSER I (1 of 1 quarters required), and ESSER II ST (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 II D2 (4 of 4 quarters required), ESSER I (1 of 1 quarters required), and ESSER II ST (1 of 1 quarters required). Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER II D2 (4 of 4 quarters required), ESSER I (1 of 1 quarters required), and ESSER II ST (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. Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER III (2 of 4 quarters required) and ESSER III C3 (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. 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: $4,387.50; $1,485 for 2021-4998-E2 and $2,902.50 for 2023-4998-E2. Context: During detailed testing, there was one expenditure claimed in project 2021-4998-E2 for bus driver trips for summer school for $1,485 that was charged to function 1000 object 100. Per review of the detailed budget, summer school bus driver pay was not included in function 1000 object 100 nor any other budget line item. There were two expenditures claimed in project 2023-4998-E2 for bus driver trips for summer school for $2,902.50 that were charged to function 1000 object 100. Per review of the detailed budget, summer school bus driver pay was not included in function 1000 object 100 nor any other budget line item. Additionally, there was one expenditure coded in Skyward to function 2900 object 400, however there was no budget item for that function and object. Upon further review, the item should have been recorded in Skyward to function 1000 object 400 where it appropriately fits into the budgeted item. No questioned cost related to this error. 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. 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: $4,387.50; $1,485 for 2021-4998-E2 and $2,902.50 for 2023-4998-E2. Context: During detailed testing, there was one expenditure claimed in project 2021-4998-E2 for bus driver trips for summer school for $1,485 that was charged to function 1000 object 100. Per review of the detailed budget, summer school bus driver pay was not included in function 1000 object 100 nor any other budget line item. There were two expenditures claimed in project 2023-4998-E2 for bus driver trips for summer school for $2,902.50 that were charged to function 1000 object 100. Per review of the detailed budget, summer school bus driver pay was not included in function 1000 object 100 nor any other budget line item. Additionally, there was one expenditure coded in Skyward to function 2900 object 400, however there was no budget item for that function and object. Upon further review, the item should have been recorded in Skyward to function 1000 object 400 where it appropriately fits into the budgeted item. No questioned cost related to this error. 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. 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: $4,387.50; $1,485 for 2021-4998-E2 and $2,902.50 for 2023-4998-E2. Context: During detailed testing, there was one expenditure claimed in project 2021-4998-E2 for bus driver trips for summer school for $1,485 that was charged to function 1000 object 100. Per review of the detailed budget, summer school bus driver pay was not included in function 1000 object 100 nor any other budget line item. There were two expenditures claimed in project 2023-4998-E2 for bus driver trips for summer school for $2,902.50 that were charged to function 1000 object 100. Per review of the detailed budget, summer school bus driver pay was not included in function 1000 object 100 nor any other budget line item. Additionally, there was one expenditure coded in Skyward to function 2900 object 400, however there was no budget item for that function and object. Upon further review, the item should have been recorded in Skyward to function 1000 object 400 where it appropriately fits into the budgeted item. No questioned cost related to this error. 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. Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER III (2 of 4 quarters required) and ESSER III C3 (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. 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 project's quarterly reports were not included in the detailed budget approved by ISBE resulting in questioned costs for the projects. Questioned Costs: 9800. Context: During detailed testing, there were three expenditures charged to function 2210 object 300 that were not included in the detailed budget for function 2210 object 300 nor any other other budget line item. These items included $7,500 for literature blended coaching, $300 for a 6 month google certified coach cohort program, and $2,000 for an author visit to the school. 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: Equipment/Real Property Management. Condition: The District budgeted for and included items in capital outlay objects in both the general ledger and ISBE expenditure reports that were below the District's capitalization threshold of $5,000. Questioned Costs: None. Context: The ESSER III grant included items below the capitalization threshold of $5,000 in capital outlay objects. Effect: The District did not follow it's capitalization threshold as outlined in its Fixed Asset Policy. Cause: This was an oversight by management. Recommendation: The District should only include items greater than its $5,000 capitalization threshold in capital outlay objects in its general ledger, budgets, and expenditure reports filed with ISBE. Management's response: Management will communicate the District's capitalization policy and the proper recording of items that fall underneath the District's capitalization threshold with all District employees who are involved with grant writing, grant reporting, and posting to the general ledger system.
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 D2 (4 of 4 quarters required), ESSER I (1 of 1 quarters required), and ESSER II ST (1 of 1 quarters required). Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER II D2 (4 of 4 quarters required), ESSER I (1 of 1 quarters required), and ESSER II ST (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 II D2 (4 of 4 quarters required), ESSER I (1 of 1 quarters required), and ESSER II ST (1 of 1 quarters required). Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER II D2 (4 of 4 quarters required), ESSER I (1 of 1 quarters required), and ESSER II ST (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 II D2 (4 of 4 quarters required), ESSER I (1 of 1 quarters required), and ESSER II ST (1 of 1 quarters required). Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER II D2 (4 of 4 quarters required), ESSER I (1 of 1 quarters required), and ESSER II ST (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. Questioned Costs: None. Context: Required expenditure reports for the projects expenditures were not timely filed for ESSER III (2 of 4 quarters required) and ESSER III C3 (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.