Audit 15851

FY End
2023-08-31
Total Expended
$19.14M
Findings
2
Programs
29
Year: 2023 Accepted: 2024-02-06

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
11912 2023-001 Significant Deficiency - N
588354 2023-001 Significant Deficiency - N

Programs

ALN Program Spent Major Findings
84.425 Covid-19 Education Stabilization Fund (esser Ii) $7.26M Yes 1
84.425 Covid-19 Education Stabilization Fund (arp Esser Iii) $3.90M Yes 0
84.010 Title I Grants to Local Educational Agencies $2.51M Yes 0
10.555 National School Lunch Program - Cash Assistance $1.94M - 0
10.553 School Breakfast Program $753,502 - 0
84.027 Special Education_grants to States $653,467 - 0
10.558 Child and Adult Care Food Program $243,892 - 0
84.367 Supporting Effective Instruction State Grants $198,580 - 0
10.555 National School Lunch Program - Non-Cash Assistance $194,631 - 0
21.016 Equitable Sharing (task Force) $180,126 - 0
84.425 Covid-19 Education Stabilization Fund (tclas Esser Iii) $179,994 Yes 0
93.323 Covid-19 Epidemiology and Laboratory Capacity for Infectious Diseases (elc Covid-19 School Health Support Grant, Cycle 2) $134,416 - 0
84.334 Gaining Early Awareness and Readiness for Undergraduate Program $131,810 - 0
84.358 Rural Education $130,761 - 0
84.365 English Language Acquisition State Grants $117,369 - 0
84.424 Student Support and Academic Enrichment Program $101,748 - 0
10.555 National School Lunch Program - Sso $91,538 - 0
10.555 Supply Chain Assistance (sca) Food Commodities $83,401 - 0
84.048 Career and Technical Education -- Basic Grants to States $74,530 - 0
12.U01 Junior Reserve Officer Training Corps $66,048 - 0
84.011 Migrant Education_state Grant Program $52,117 - 0
84.027 Special Education_idea-B Formula - Arp $46,398 - 0
84.010 Title I Grants to Local Educational Agencies School Improvement Grant $43,000 Yes 0
84.173 Special Education_preschool Grants $10,209 - 0
84.173 Special Education_idea B Preschool - Arp $9,281 - 0
10.560 Nslp Contracted Warehouse Private Storage and Delivery Fees (non-Cash Assistance) $8,417 - 0
84.425 Covid-19 American Rescue Plan Homeless II $6,716 Yes 0
84.369 Grants for State Assessments and Related Activities $5,917 - 0
10.649 Covid-19 Pandemic (p-Ebt) Administrative Costs $3,135 - 0

Contacts

Name Title Type
ETBEZZ9GGM47 Michelle Martinez Auditee
9564222832 Esmeralda Yniguez Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal spending of Zapata Independent School District (the "District"). 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. Expenditures reported in the Schedule are reported under the modified accrual basis of accounting. Because the schedule presents only a selected portion of the operations of the District, it is not intended to and does not represent the financial poistion of the District. De Minimis Rate Used: N Rate Explanation: The Uniform Guidance allows an organization to elect a 10% de minimis indirect cost rate. For the year ended August 31, 2023, the District did not elect to use this rate. The accompanying schedule of expenditures of federal awards includes the federal spending of Zapata Independent School District (the "District"). 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. Expenditures reported in the Schedule are reported under the modified accrual basis of accounting. Because the schedule presents only a selected portion of the operations of the District, it is not intended to and does not represent the financial position of the District.
Title: INDIRECT COST RATE Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal spending of Zapata Independent School District (the "District"). 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. Expenditures reported in the Schedule are reported under the modified accrual basis of accounting. Because the schedule presents only a selected portion of the operations of the District, it is not intended to and does not represent the financial poistion of the District. De Minimis Rate Used: N Rate Explanation: The Uniform Guidance allows an organization to elect a 10% de minimis indirect cost rate. For the year ended August 31, 2023, the District did not elect to use this rate. The Uniform Guidance allows an organization to elect a 10% de minimis indirect cost rate. For the year ended August 31, 2023, the District did not elect to use this rate.
Title: SUB-RECIPIENTS Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal spending of Zapata Independent School District (the "District"). 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. Expenditures reported in the Schedule are reported under the modified accrual basis of accounting. Because the schedule presents only a selected portion of the operations of the District, it is not intended to and does not represent the financial poistion of the District. De Minimis Rate Used: N Rate Explanation: The Uniform Guidance allows an organization to elect a 10% de minimis indirect cost rate. For the year ended August 31, 2023, the District did not elect to use this rate. During the year ended August 31, 2023, the District had no sub‐recipients.
Title: FEDERAL LOANS AND LOAN GUARANTEES Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal spending of Zapata Independent School District (the "District"). 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. Expenditures reported in the Schedule are reported under the modified accrual basis of accounting. Because the schedule presents only a selected portion of the operations of the District, it is not intended to and does not represent the financial poistion of the District. De Minimis Rate Used: N Rate Explanation: The Uniform Guidance allows an organization to elect a 10% de minimis indirect cost rate. For the year ended August 31, 2023, the District did not elect to use this rate. During the year ended August 31, 2023, the District had no outstanding federal loans payable or loan guarantees.
Title: FEDERALLY FUNDED INSURANCE Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal spending of Zapata Independent School District (the "District"). 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. Expenditures reported in the Schedule are reported under the modified accrual basis of accounting. Because the schedule presents only a selected portion of the operations of the District, it is not intended to and does not represent the financial poistion of the District. De Minimis Rate Used: N Rate Explanation: The Uniform Guidance allows an organization to elect a 10% de minimis indirect cost rate. For the year ended August 31, 2023, the District did not elect to use this rate. During the year ended August 31, 2023, the District had no federally funded insurance.
Title: NONCASH AWARDS Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal spending of Zapata Independent School District (the "District"). 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. Expenditures reported in the Schedule are reported under the modified accrual basis of accounting. Because the schedule presents only a selected portion of the operations of the District, it is not intended to and does not represent the financial poistion of the District. De Minimis Rate Used: N Rate Explanation: The Uniform Guidance allows an organization to elect a 10% de minimis indirect cost rate. For the year ended August 31, 2023, the District did not elect to use this rate. During the year ended August 31, 2023, the District received $194,631 as non ‐cash assistance under the National School Lunch Program (Assistance Listing Number 10.555), $8,417 as non‐cash assistance under the NSLP Contracted Warehouse Private Storeage and Delivery Fees Grant and $134,416 as non‐cash assistance under the Epidemiology and Laboratory Capacity for Infectious Diseases Program (Assistance Listing Number 93.323).
Title: CONTIGENCIES Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal spending of Zapata Independent School District (the "District"). 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. Expenditures reported in the Schedule are reported under the modified accrual basis of accounting. Because the schedule presents only a selected portion of the operations of the District, it is not intended to and does not represent the financial poistion of the District. De Minimis Rate Used: N Rate Explanation: The Uniform Guidance allows an organization to elect a 10% de minimis indirect cost rate. For the year ended August 31, 2023, the District did not elect to use this rate. Grant monies received and disbursed by the District are for specific purposes and are subject to review by the grantor agencies. Such audits may result in requests for reimbursement due to disallowed expenditures. Based upon experience, the District does not believe that such disallowance, if any, would have a material effect on the financial position of the District.
Title: FEDERAL PASS-THROUGH FUNDS Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal spending of Zapata Independent School District (the "District"). 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. Expenditures reported in the Schedule are reported under the modified accrual basis of accounting. Because the schedule presents only a selected portion of the operations of the District, it is not intended to and does not represent the financial poistion of the District. De Minimis Rate Used: N Rate Explanation: The Uniform Guidance allows an organization to elect a 10% de minimis indirect cost rate. For the year ended August 31, 2023, the District did not elect to use this rate. The District is also the sub‐recipient of federal funds that have been subjected to testing and are reported as expenditures and listed as federal pass‐through funds. Federal awards other than those indicated as pass‐through are considered to be direct.
Title: SPECIAL EDUCATION CLUSTER (IDEA) Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal spending of Zapata Independent School District (the "District"). 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. Expenditures reported in the Schedule are reported under the modified accrual basis of accounting. Because the schedule presents only a selected portion of the operations of the District, it is not intended to and does not represent the financial poistion of the District. De Minimis Rate Used: N Rate Explanation: The Uniform Guidance allows an organization to elect a 10% de minimis indirect cost rate. For the year ended August 31, 2023, the District did not elect to use this rate. Grants received under the Special Education Cluster (CFDA No. 84.027A and 84.173A) include funds passed through two (2) different pass‐through grantor agencies. The funds passed through from both agencies were combined for purposes of compliance with Uniform Guidance.
Title: RECONCILIATION FROM THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARS TO EXHIBIT C-3 Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal spending of Zapata Independent School District (the "District"). 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. Expenditures reported in the Schedule are reported under the modified accrual basis of accounting. Because the schedule presents only a selected portion of the operations of the District, it is not intended to and does not represent the financial poistion of the District. De Minimis Rate Used: N Rate Explanation: The Uniform Guidance allows an organization to elect a 10% de minimis indirect cost rate. For the year ended August 31, 2023, the District did not elect to use this rate. Total Federal Award Expended $19,144,177 Medicaid Administrative Claiming (MAC) $20,572 QSC Subsidy $305,513 SHARS $849,120 Exhibit C-3 $20,319,322

Finding Details

Section III- Federal Award Findings and Questioned Costs 2023-001 Wage Rate Requirements (Significant Deficiency in Internal Controls over Compliance, Noncompliance, and Questioned Costs greater than $25k) Funding Agency: United State Department of Education Federal Award Agreement Number: N/A Award Year: 2023 Title: Education Stabilization Fund, ESSER II Assistance Listing Number: 84.425D Pass-through Agency: Texas Education Agency Pass-through Identification Number: 20521001253901 Questioned Costs: $428,498 Condition: The District did not obtain weekly certified payrolls for laborers and mechanics employed by contractors to work on construction contracts in excess of $2,000 financed by federal assistance funds. The computed likely questioned costs were determined per review of invoices and inquiries with contractor. One invoice identified labor costs of $50,880. A second invoice of $1,258,528 did not have labor costs broken out. Per further inquiries with contractor, 30% of that invoices was estimated to represent labor cost ($377,618). Out of the total program expenditures, these were the only two invoices that were subject to this compliance requirement. Criteria: The Compliance Supplement for this program includes N. Special Tests and Provisions: 1. Wage Rate Requirements. Per 2 CFR Part 176, Subpart C, non‐Federal entities are required to obtain from contractors a copy of payroll and a statement of compliance (certified payrolls) for each week in which any contract work is performed. Cause: The contractor did not submit weekly certified payroll to the District when construction work was performed. Effect: The District could be using federal funding for construction work where wages to laborers and mechanics may be less than those established for the locality of the project (prevailing wage rates) by the Department of Labor. Auditors’ Recommendation: The Auditor recommends that the District obtain certified payroll on a weekly basis from contractor while construction is occurring and maintain records to show the District reviewed prior to payment to contractor for invoices. Management Response: Management agrees with the finding. See corrective action plan on page 139.
Section III- Federal Award Findings and Questioned Costs 2023-001 Wage Rate Requirements (Significant Deficiency in Internal Controls over Compliance, Noncompliance, and Questioned Costs greater than $25k) Funding Agency: United State Department of Education Federal Award Agreement Number: N/A Award Year: 2023 Title: Education Stabilization Fund, ESSER II Assistance Listing Number: 84.425D Pass-through Agency: Texas Education Agency Pass-through Identification Number: 20521001253901 Questioned Costs: $428,498 Condition: The District did not obtain weekly certified payrolls for laborers and mechanics employed by contractors to work on construction contracts in excess of $2,000 financed by federal assistance funds. The computed likely questioned costs were determined per review of invoices and inquiries with contractor. One invoice identified labor costs of $50,880. A second invoice of $1,258,528 did not have labor costs broken out. Per further inquiries with contractor, 30% of that invoices was estimated to represent labor cost ($377,618). Out of the total program expenditures, these were the only two invoices that were subject to this compliance requirement. Criteria: The Compliance Supplement for this program includes N. Special Tests and Provisions: 1. Wage Rate Requirements. Per 2 CFR Part 176, Subpart C, non‐Federal entities are required to obtain from contractors a copy of payroll and a statement of compliance (certified payrolls) for each week in which any contract work is performed. Cause: The contractor did not submit weekly certified payroll to the District when construction work was performed. Effect: The District could be using federal funding for construction work where wages to laborers and mechanics may be less than those established for the locality of the project (prevailing wage rates) by the Department of Labor. Auditors’ Recommendation: The Auditor recommends that the District obtain certified payroll on a weekly basis from contractor while construction is occurring and maintain records to show the District reviewed prior to payment to contractor for invoices. Management Response: Management agrees with the finding. See corrective action plan on page 139.