Audit 300605

FY End
2023-06-30
Total Expended
$2.91M
Findings
4
Programs
7
Year: 2023 Accepted: 2024-03-29
Auditor: Drs CPA PLLC

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
389693 2023-002 Material Weakness - AB
389694 2023-003 Significant Deficiency - N
966135 2023-002 Material Weakness - AB
966136 2023-003 Significant Deficiency - N

Programs

ALN Program Spent Major Findings
84.041 Impact Aid $2.65M Yes 2
84.425 Education Stabilization Fund $137,920 - 0
10.553 School Breakfast Program $27,465 - 0
84.060 Indian Education_grants to Local Educational Agencies $27,073 - 0
10.558 Child and Adult Care Food Program $8,711 - 0
10.555 National School Lunch Program $7,002 - 0
10.559 Summer Food Service Program for Children $925 - 0

Contacts

Name Title Type
QRLJSJRA5JN8 Rocio Humphreys Auditee
9283342226 Dallas Siler Auditor
No contacts on file

Notes to SEFA

Title: SIGNIFICANT ACCOUNTING POLICIES USED IN PREPARING THE SEFA Accounting Policies: Modified accrual basis of accounting De Minimis Rate Used: N Rate Explanation: N/A The accompanying Schedule of Expenditures of Federal Awards (SEFA) includes the McNary Elementary School District No. 23's (the District) federal grant activity under federal programs for the year ended June 30, 2023. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Expenditures reported on the schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the financial statements. Because the Schedule presents only a selected portion of the operations of the School, it is not intended to and does not present the financial position or changes in fund balance or net position of the District.
Title: ASSISTANCE LISTINGS NUMBERS Accounting Policies: Modified accrual basis of accounting De Minimis Rate Used: N Rate Explanation: N/A The program titles and assistance listings numbers were obtained from the federal or pass-through grantor or SAM.gov.
Title: INDIRECT COST RATE Accounting Policies: Modified accrual basis of accounting De Minimis Rate Used: N Rate Explanation: N/A The District did not elect to use the 10 percent de minimis indirect cost rate as covered in 2 CFR §200.414.
Title: NON-CASH ASSISTANCE Accounting Policies: Modified accrual basis of accounting De Minimis Rate Used: N Rate Explanation: N/A Food donations as reported for the Child Nutrition Cluster represents the amount of donated food used during the fiscal year. Commodities are valued at fair value at the time of donation.

Finding Details

Condition  For three of 40 general expenditures tested, totaling $156,144, the District did not retain a vendor invoice to support the disbursement of funds.  For one of five travel reimbursements selected, the District did not retain supporting documentation for the amounts paid.  For 12 of 40 expenditures tested, the District issued the purchase orders between one to 83 days after receipt of the invoice.  For five of 25 invoices selected for federal compliance, the District could not provide documentation to support the expenditure. Criteria Arizona Revised Statutes 15-271 states: "A. The auditor general shall determine the accounting systems, accounting methods and accounting procedures for school districts to use. B. The auditor general in conjunction with the department of education shall prescribe a uniform system of financial records (USFR) for all school districts to use each fiscal year." USFR VI-B Source documents states: "Source documents are used to initiate accounting transactions and should be retained to support each entry recorded in the accounting records." Uniform Guidance §200.333 Retention requirements for records states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report..." Cause Internal controls were not developed to ensure new staff was properly trained to maintain accounting records in a complete manner. In addition, controls were not monitored to ensure complete documentation was retained. Effect Financial information the District uses to make decisions and reports provided to the state for oversight could have been materially misstated throughout the fiscal year. Recommendation The District should procure a consultant or modify the organizational chart of the District Finance Office to ensure individuals with the skills, knowledge and expertise prepare, review and retain required source documentation. In addition, material transactions of the fiscal year should be reviewed and replacement documentation should be obtained to replace missing invoice information.
Condition The District did not retain documentation sufficient to determine that the Davis-Bacon compliance clause was included in advertised specifications. In addition, the District did not receive weekly certified payrolls from three contractors who were working on projects funded with Impact Aid construction awards. Criteria 40 USC 3142(a): "The advertised specifications for every contract in excess of $2,000, to which the Federal Government ... is a party, for construction ... of public buildings and public works of the Government .... that are located in a State ... which requires or involves the employment of mechanics or laborers shall contain a provision meeting stating the minimum wages to be paid various classes of laborers and mechanics. 40 USC 3145(a): " ... each contractor and subcontractor each week must furnish a statement on the wages paid each employee during the prior week." Cause The District did not have internal controls sufficient to ensure compliance. Effect The District is not in compliance with federal regulations. Recommendation We recommend that the District develop internal controls to ensure advertised solicitations contain the required clause. We further recommend that the District obtain certified payrolls for all construction projects funded with Federal Impact Aid awards.
Condition  For three of 40 general expenditures tested, totaling $156,144, the District did not retain a vendor invoice to support the disbursement of funds.  For one of five travel reimbursements selected, the District did not retain supporting documentation for the amounts paid.  For 12 of 40 expenditures tested, the District issued the purchase orders between one to 83 days after receipt of the invoice.  For five of 25 invoices selected for federal compliance, the District could not provide documentation to support the expenditure. Criteria Arizona Revised Statutes 15-271 states: "A. The auditor general shall determine the accounting systems, accounting methods and accounting procedures for school districts to use. B. The auditor general in conjunction with the department of education shall prescribe a uniform system of financial records (USFR) for all school districts to use each fiscal year." USFR VI-B Source documents states: "Source documents are used to initiate accounting transactions and should be retained to support each entry recorded in the accounting records." Uniform Guidance §200.333 Retention requirements for records states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report..." Cause Internal controls were not developed to ensure new staff was properly trained to maintain accounting records in a complete manner. In addition, controls were not monitored to ensure complete documentation was retained. Effect Financial information the District uses to make decisions and reports provided to the state for oversight could have been materially misstated throughout the fiscal year. Recommendation The District should procure a consultant or modify the organizational chart of the District Finance Office to ensure individuals with the skills, knowledge and expertise prepare, review and retain required source documentation. In addition, material transactions of the fiscal year should be reviewed and replacement documentation should be obtained to replace missing invoice information.
Condition The District did not retain documentation sufficient to determine that the Davis-Bacon compliance clause was included in advertised specifications. In addition, the District did not receive weekly certified payrolls from three contractors who were working on projects funded with Impact Aid construction awards. Criteria 40 USC 3142(a): "The advertised specifications for every contract in excess of $2,000, to which the Federal Government ... is a party, for construction ... of public buildings and public works of the Government .... that are located in a State ... which requires or involves the employment of mechanics or laborers shall contain a provision meeting stating the minimum wages to be paid various classes of laborers and mechanics. 40 USC 3145(a): " ... each contractor and subcontractor each week must furnish a statement on the wages paid each employee during the prior week." Cause The District did not have internal controls sufficient to ensure compliance. Effect The District is not in compliance with federal regulations. Recommendation We recommend that the District develop internal controls to ensure advertised solicitations contain the required clause. We further recommend that the District obtain certified payrolls for all construction projects funded with Federal Impact Aid awards.