Audit 46185

FY End
2022-06-30
Total Expended
$2.69M
Findings
2
Programs
14
Organization: Beardstown Cusd #15 (IL)
Year: 2022 Accepted: 2022-12-12

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
43686 2022-002 - Yes B
620128 2022-002 - Yes B

Contacts

Name Title Type
NADWMMRG7JE3 Michael Smith Auditee
2173233099 Robin L Malloy Auditor
No contacts on file

Notes to SEFA

Title: Note 1 - Relationship to the District's Financial Statements Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal award programs of Beardstown Community Unit School District No. 15. Federal awards passed through other government agencies are included on the schedule. Such amounts received as pass-through awards are specifically identified on the Schedule of Expenditures of Federal Awards. The accompanying Schedule of Expenditures of Federal Awards is presented using the cash basis of accounting. Basis of accounting refers to when revenues received and expenditures disbursed are recognized in the accounts and how they are reported on the financial statements. The District maintains its accounting records for all funds and account groups on the cash basis of accounting under guidelines prescribed by the Illinois State Board of Education. Accordingly, revenues are recognized and recorded in the accounts which cash is received. In the same manner, expenditures are recognized and recorded upon the disbursement of cash. Assets of a fund are only recorded when a right to receive cash exists which arises from a previous cash transaction. Liabilities of a fund, similarly, result from previous cash transactions. Cash basis financial statements omit recognition of receivables and payables and other accrued and deferred items that do not arise from previous cash transactions. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. All Federal Programs: Federal awards received are reflected in the Districts financial statements in the Education Fund as revenue from federal sources. Federal expenditures are also recorded in this fund. Non-cash Awards: Beardstown Community Unit School District No. 15 received a non-cash federal award in the amount of $66,579 from U.S. Department of Agriculture Food Commodities Program, CFDA #10.555 and a non-cash federal award in the amount of $15,979 from the U.S. Department of Defense Fresh Fruits and Vegetables Program, CFDA #10.555 during the year ended June 30, 2022.
Title: Note 3 - Contigencies Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal award programs of Beardstown Community Unit School District No. 15. Federal awards passed through other government agencies are included on the schedule. Such amounts received as pass-through awards are specifically identified on the Schedule of Expenditures of Federal Awards. The accompanying Schedule of Expenditures of Federal Awards is presented using the cash basis of accounting. Basis of accounting refers to when revenues received and expenditures disbursed are recognized in the accounts and how they are reported on the financial statements. The District maintains its accounting records for all funds and account groups on the cash basis of accounting under guidelines prescribed by the Illinois State Board of Education. Accordingly, revenues are recognized and recorded in the accounts which cash is received. In the same manner, expenditures are recognized and recorded upon the disbursement of cash. Assets of a fund are only recorded when a right to receive cash exists which arises from a previous cash transaction. Liabilities of a fund, similarly, result from previous cash transactions. Cash basis financial statements omit recognition of receivables and payables and other accrued and deferred items that do not arise from previous cash transactions. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. The District receives awards under various federal grant programs which must be expended according to provisions established by the various grants. Compliance with the grant provisions are subject to audit by the various granting agencies which may impose sanctions in the event of non-compliance. Management believes they have complied with all aspects of the grant provisions and they feel the results of any adjustments would have an immaterial impact on the financial statements taken as a whole.
Title: Note 4 - Insurance, Loans and Loan Guarantees Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal award programs of Beardstown Community Unit School District No. 15. Federal awards passed through other government agencies are included on the schedule. Such amounts received as pass-through awards are specifically identified on the Schedule of Expenditures of Federal Awards. The accompanying Schedule of Expenditures of Federal Awards is presented using the cash basis of accounting. Basis of accounting refers to when revenues received and expenditures disbursed are recognized in the accounts and how they are reported on the financial statements. The District maintains its accounting records for all funds and account groups on the cash basis of accounting under guidelines prescribed by the Illinois State Board of Education. Accordingly, revenues are recognized and recorded in the accounts which cash is received. In the same manner, expenditures are recognized and recorded upon the disbursement of cash. Assets of a fund are only recorded when a right to receive cash exists which arises from a previous cash transaction. Liabilities of a fund, similarly, result from previous cash transactions. Cash basis financial statements omit recognition of receivables and payables and other accrued and deferred items that do not arise from previous cash transactions. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. As of June 30, 2022, there was no federal insurance in effect and no loans or loan guarantees outstanding.

Finding Details

FINDING NUMBER: 2022 - 002 THIS FINDING IS: X Repeat from Prior year? Year originally reported? 2020 Federal Program Name and Year: Elementary and Secondary School Emergency Relief Fund Project No.: 2022-4998 CFDA No.:84.425D Passed Through: Illinois State Board of Education Federal Agency: US Department of Education Criteria or specific requirement (including statutory, regulatory, or other citation) Allowable Costs & Reporting - Direct federal costs should be supported by adequate documentation, given consistent treatment, not be used as a cost or meet cost sharing requirements for other federal programs and be supported by audited accounting records. Condition - Cumulative expenditures reported to the granting agency to show use of funds could not be reconciled, by function & object, to detailed general ledger postings used to track allowable expenditures by funding type. Questioned Costs - N/A Context - Without proper controls over allowable costs and reporting, expenditures may be incorrectly reported to the granting agency as an allowable expenditure used to spend federal awards according to an approved award budget. Effect - Expenditures reported to the granting agency as allowable were not supported by actual general ledger postings by function & object, which could result in reported expenditures later to be deemed unallowable, resulting in unspent federal funds. Cause - Proper internal controls over allowable costs and reporting either do not adequately detail procedures to determine allowable costs used to prepare required reports or are not routinely being adhered to. Recommendation - Review all policies over allowable costs and reporting to determine if they provide adequate guidance. Revise policies if deemed necessary. Additionally make sure all responsible individuals are aware of such policies and that they are being adhered to. Management's response - Management is in agreement with this finding.
FINDING NUMBER: 2022 - 002 THIS FINDING IS: X Repeat from Prior year? Year originally reported? 2020 Federal Program Name and Year: Elementary and Secondary School Emergency Relief Fund Project No.: 2022-4998 CFDA No.:84.425D Passed Through: Illinois State Board of Education Federal Agency: US Department of Education Criteria or specific requirement (including statutory, regulatory, or other citation) Allowable Costs & Reporting - Direct federal costs should be supported by adequate documentation, given consistent treatment, not be used as a cost or meet cost sharing requirements for other federal programs and be supported by audited accounting records. Condition - Cumulative expenditures reported to the granting agency to show use of funds could not be reconciled, by function & object, to detailed general ledger postings used to track allowable expenditures by funding type. Questioned Costs - N/A Context - Without proper controls over allowable costs and reporting, expenditures may be incorrectly reported to the granting agency as an allowable expenditure used to spend federal awards according to an approved award budget. Effect - Expenditures reported to the granting agency as allowable were not supported by actual general ledger postings by function & object, which could result in reported expenditures later to be deemed unallowable, resulting in unspent federal funds. Cause - Proper internal controls over allowable costs and reporting either do not adequately detail procedures to determine allowable costs used to prepare required reports or are not routinely being adhered to. Recommendation - Review all policies over allowable costs and reporting to determine if they provide adequate guidance. Revise policies if deemed necessary. Additionally make sure all responsible individuals are aware of such policies and that they are being adhered to. Management's response - Management is in agreement with this finding.