Audit 1099

FY End
2023-06-30
Total Expended
$2.51M
Findings
4
Programs
14
Year: 2023 Accepted: 2023-10-24
Auditor: Scheffel Boyle

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
552 2023-001 Significant Deficiency - L
553 2023-002 Significant Deficiency - I
576994 2023-001 Significant Deficiency - L
576995 2023-002 Significant Deficiency - I

Contacts

Name Title Type
J6GWHNC7P224 Brian Charron Auditee
6189393453 Kieth Brinkmann Auditor
No contacts on file

Notes to SEFA

Title: Subrecipients Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Waterloo Community Unit School District #5 and is presented on the modified cash basis. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the Basic financial statements. De Minimis Rate Used: N Rate Explanation: Restricted indirect cost rate of 1.06%, unrestricted indirect cost rate of 17.75%. Of the federal expenditures presented in the schedule, Waterloo Community Unit School District #5 provided federal awards to subrecipients as follows: None
Title: Non Cash Assistance Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Waterloo Community Unit School District #5 and is presented on the modified cash basis. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the Basic financial statements. De Minimis Rate Used: N Rate Explanation: Restricted indirect cost rate of 1.06%, unrestricted indirect cost rate of 17.75%. The following amounts were expended in the form of non-cash assistance by Waterloo Community Unit School District #5 and should be included in the Schedule of Expenditures of Federal Awards: Non-Cash Commodities (AL 10.555) $164,545
Title: Other Information Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Waterloo Community Unit School District #5 and is presented on the modified cash basis. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the Basic financial statements. De Minimis Rate Used: N Rate Explanation: Restricted indirect cost rate of 1.06%, unrestricted indirect cost rate of 17.75%. Insurance coverage in effect paid with Federal funds during the fiscal year: No property, auto, general liability, workers compensation.
Title: Other Information Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Waterloo Community Unit School District #5 and is presented on the modified cash basis. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the Basic financial statements. De Minimis Rate Used: N Rate Explanation: Restricted indirect cost rate of 1.06%, unrestricted indirect cost rate of 17.75%. No loans or loan guarantees outstanding at June 30
Title: Other Information Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Waterloo Community Unit School District #5 and is presented on the modified cash basis. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the Basic financial statements. De Minimis Rate Used: N Rate Explanation: Restricted indirect cost rate of 1.06%, unrestricted indirect cost rate of 17.75%. The District did not have federal grants requiring matching expenditures

Finding Details

Criteria or specific requirement (including statutory, regulatory, or other citation): Reporting. The accounts used to record expenditures on the quarterly expenditure reports should match the general ledger accounts where the expenditures are reported. Condition: There were three inconsistencies in the accounts used to record the expenditures in the general ledger vs what was reported on the expenditure reports. Questioned Costs: None, just a classification issue. Context: Tied out all of the expenditure account numbers to the general ledger vs the expenditure reports and noted three inconsistencies. Effect: The expenditure was not recorded/reported consistently between the two reports (G/L vs expenditure report). Cause: The timesheets were coded incorrectly for the work performed. Recommendation: It is recommended that a check of account numbers is done quarterly when the reports are filed to ensure that the account numbers are consistent. Management's response: We will code timesheets correctly and check quarterly.
Criteria or specific requirement (including statutory, regulatory, or other citation): Procurement. The District should follow the procurement standards set out at 2 CFR sections 200.318 through 200.326. Condition: The District did not follow the small purchase method for procurement that is required for purchases made between $10,000 and $250,000. This method requires that price or rate quotations must be obtained from an adequate number of qualified sources (2 CFR section 200.320(b). Questioned Costs: None. Context: There was only one purchase over $10,000 made with these grants funds during the fiscal year and the required procurement method was not followed. Effect: The District did not comply with the required procurement standard. Cause: This purchase had to be made quickly so the District used their perferred vendor. Recommendation: We recommend that care is taken to ensure that all the procurement requirements are followed based on the amount of the purchase being made with the federal funds. Management's response: We will follow the procurement standard when not in urgent situations for the product or service we are seeking.
Criteria or specific requirement (including statutory, regulatory, or other citation): Reporting. The accounts used to record expenditures on the quarterly expenditure reports should match the general ledger accounts where the expenditures are reported. Condition: There were three inconsistencies in the accounts used to record the expenditures in the general ledger vs what was reported on the expenditure reports. Questioned Costs: None, just a classification issue. Context: Tied out all of the expenditure account numbers to the general ledger vs the expenditure reports and noted three inconsistencies. Effect: The expenditure was not recorded/reported consistently between the two reports (G/L vs expenditure report). Cause: The timesheets were coded incorrectly for the work performed. Recommendation: It is recommended that a check of account numbers is done quarterly when the reports are filed to ensure that the account numbers are consistent. Management's response: We will code timesheets correctly and check quarterly.
Criteria or specific requirement (including statutory, regulatory, or other citation): Procurement. The District should follow the procurement standards set out at 2 CFR sections 200.318 through 200.326. Condition: The District did not follow the small purchase method for procurement that is required for purchases made between $10,000 and $250,000. This method requires that price or rate quotations must be obtained from an adequate number of qualified sources (2 CFR section 200.320(b). Questioned Costs: None. Context: There was only one purchase over $10,000 made with these grants funds during the fiscal year and the required procurement method was not followed. Effect: The District did not comply with the required procurement standard. Cause: This purchase had to be made quickly so the District used their perferred vendor. Recommendation: We recommend that care is taken to ensure that all the procurement requirements are followed based on the amount of the purchase being made with the federal funds. Management's response: We will follow the procurement standard when not in urgent situations for the product or service we are seeking.