Audit 23980

FY End
2022-06-30
Total Expended
$7.89M
Findings
4
Programs
10
Year: 2022 Accepted: 2023-01-26

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
32916 2022-002 Material Weakness - B
32917 2022-002 Material Weakness - B
609358 2022-002 Material Weakness - B
609359 2022-002 Material Weakness - B

Programs

ALN Program Spent Major Findings
84.010 Title I Grants to Local Educational Agencies $1.26M - 0
10.555 National School Lunch Program $588,998 - 0
84.282 Charter Schools $430,615 - 0
32.009 Emergency Connectivity Fund Program $321,869 Yes 0
10.553 School Breakfast Program $279,488 - 0
84.367 Improving Teacher Quality State Grants $160,826 - 0
84.424 Student Support and Academic Enrichment Program $88,061 - 0
84.425 Covid-19 - Education Stabilization Fund $11,582 Yes 0
10.559 Summer Food Service Program for Children $2,000 - 0
10.649 Pandemic Ebt Administrative Costs $601 - 0

Contacts

Name Title Type
PMHARB4UNHJ4 Jenny Zambrano Auditee
9176564004 Jacqueline Lee Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of federal awards (the schedule) includes the federal grant activity of Public Prep Charter School Academies and is presented on the accrual basis of accounting. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) 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 the preparation of, the basic consolidated financial statements. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

Criteria: Requirements per section 2 CFR Part 200 Subpart E of the Uniform Guidance state that costs charged to federal awards must be determined in accordance with GAAP, be adequately documented, and be allocable to the federal award, and be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition: During our audit procedures, we reviewed the grant schedules prepared by the outsourced financial consulting firm and noted they did not properly reconcile to the grant activity as recorded. Consequently, we proposed significant adjustments to properly record the grant activity. We consider this to be a material weakness in internal control over compliance in the area of allowable costs/cost principles. Cause: During the 2022 fiscal year, the outsourced financial consulting firm did not identify expenditures of federal funds on a timely or consistent basis throughout the year, resulting in significant effort to properly identify and reflect allowable expenditures of federal funds at year-end. Effect or Potential Effect: If expenditures of federal funds are not properly tracked throughout the year, management may not fully utilize grant funds during the grant period or may improperly identify unallowable costs as federal expenditures under the applicable grants. This could result in disallowance of grant expenditures. Questioned Costs: N/A Context: The outsourced financial consulting firm estimated amounts of federal grant expenditures throughout the year but did not have a process in place to reconcile the estimated amounts to the specific expenditures. As a result, the outsourced financial consulting firm went through multiple iterations of preparing the federal expenditure details. Recommendation: We recommend the Organization transfer the day-to-day finance operations to the expanded internal finance team to reduce reliance on the outsourced financial consulting firm. This will allow the Organization to devote the necessary resources to managing the finance and accounting function, including tracking of expenditures of federal funds, on a more accurate and timely basis. Federal grant revenues and expenditures should be reconciled on a monthly basis to ensure charges are in accordance with GAAP, adequately documented, and allocable to the federal award. Views of responsible officials: Public Prep agrees with the audit finding and acknowledges our responsibility for the design, implementation and reviews of internal controls related to financial reporting on Federal awards.
Criteria: Requirements per section 2 CFR Part 200 Subpart E of the Uniform Guidance state that costs charged to federal awards must be determined in accordance with GAAP, be adequately documented, and be allocable to the federal award, and be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition: During our audit procedures, we reviewed the grant schedules prepared by the outsourced financial consulting firm and noted they did not properly reconcile to the grant activity as recorded. Consequently, we proposed significant adjustments to properly record the grant activity. We consider this to be a material weakness in internal control over compliance in the area of allowable costs/cost principles. Cause: During the 2022 fiscal year, the outsourced financial consulting firm did not identify expenditures of federal funds on a timely or consistent basis throughout the year, resulting in significant effort to properly identify and reflect allowable expenditures of federal funds at year-end. Effect or Potential Effect: If expenditures of federal funds are not properly tracked throughout the year, management may not fully utilize grant funds during the grant period or may improperly identify unallowable costs as federal expenditures under the applicable grants. This could result in disallowance of grant expenditures. Questioned Costs: N/A Context: The outsourced financial consulting firm estimated amounts of federal grant expenditures throughout the year but did not have a process in place to reconcile the estimated amounts to the specific expenditures. As a result, the outsourced financial consulting firm went through multiple iterations of preparing the federal expenditure details. Recommendation: We recommend the Organization transfer the day-to-day finance operations to the expanded internal finance team to reduce reliance on the outsourced financial consulting firm. This will allow the Organization to devote the necessary resources to managing the finance and accounting function, including tracking of expenditures of federal funds, on a more accurate and timely basis. Federal grant revenues and expenditures should be reconciled on a monthly basis to ensure charges are in accordance with GAAP, adequately documented, and allocable to the federal award. Views of responsible officials: Public Prep agrees with the audit finding and acknowledges our responsibility for the design, implementation and reviews of internal controls related to financial reporting on Federal awards.
Criteria: Requirements per section 2 CFR Part 200 Subpart E of the Uniform Guidance state that costs charged to federal awards must be determined in accordance with GAAP, be adequately documented, and be allocable to the federal award, and be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition: During our audit procedures, we reviewed the grant schedules prepared by the outsourced financial consulting firm and noted they did not properly reconcile to the grant activity as recorded. Consequently, we proposed significant adjustments to properly record the grant activity. We consider this to be a material weakness in internal control over compliance in the area of allowable costs/cost principles. Cause: During the 2022 fiscal year, the outsourced financial consulting firm did not identify expenditures of federal funds on a timely or consistent basis throughout the year, resulting in significant effort to properly identify and reflect allowable expenditures of federal funds at year-end. Effect or Potential Effect: If expenditures of federal funds are not properly tracked throughout the year, management may not fully utilize grant funds during the grant period or may improperly identify unallowable costs as federal expenditures under the applicable grants. This could result in disallowance of grant expenditures. Questioned Costs: N/A Context: The outsourced financial consulting firm estimated amounts of federal grant expenditures throughout the year but did not have a process in place to reconcile the estimated amounts to the specific expenditures. As a result, the outsourced financial consulting firm went through multiple iterations of preparing the federal expenditure details. Recommendation: We recommend the Organization transfer the day-to-day finance operations to the expanded internal finance team to reduce reliance on the outsourced financial consulting firm. This will allow the Organization to devote the necessary resources to managing the finance and accounting function, including tracking of expenditures of federal funds, on a more accurate and timely basis. Federal grant revenues and expenditures should be reconciled on a monthly basis to ensure charges are in accordance with GAAP, adequately documented, and allocable to the federal award. Views of responsible officials: Public Prep agrees with the audit finding and acknowledges our responsibility for the design, implementation and reviews of internal controls related to financial reporting on Federal awards.
Criteria: Requirements per section 2 CFR Part 200 Subpart E of the Uniform Guidance state that costs charged to federal awards must be determined in accordance with GAAP, be adequately documented, and be allocable to the federal award, and be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition: During our audit procedures, we reviewed the grant schedules prepared by the outsourced financial consulting firm and noted they did not properly reconcile to the grant activity as recorded. Consequently, we proposed significant adjustments to properly record the grant activity. We consider this to be a material weakness in internal control over compliance in the area of allowable costs/cost principles. Cause: During the 2022 fiscal year, the outsourced financial consulting firm did not identify expenditures of federal funds on a timely or consistent basis throughout the year, resulting in significant effort to properly identify and reflect allowable expenditures of federal funds at year-end. Effect or Potential Effect: If expenditures of federal funds are not properly tracked throughout the year, management may not fully utilize grant funds during the grant period or may improperly identify unallowable costs as federal expenditures under the applicable grants. This could result in disallowance of grant expenditures. Questioned Costs: N/A Context: The outsourced financial consulting firm estimated amounts of federal grant expenditures throughout the year but did not have a process in place to reconcile the estimated amounts to the specific expenditures. As a result, the outsourced financial consulting firm went through multiple iterations of preparing the federal expenditure details. Recommendation: We recommend the Organization transfer the day-to-day finance operations to the expanded internal finance team to reduce reliance on the outsourced financial consulting firm. This will allow the Organization to devote the necessary resources to managing the finance and accounting function, including tracking of expenditures of federal funds, on a more accurate and timely basis. Federal grant revenues and expenditures should be reconciled on a monthly basis to ensure charges are in accordance with GAAP, adequately documented, and allocable to the federal award. Views of responsible officials: Public Prep agrees with the audit finding and acknowledges our responsibility for the design, implementation and reviews of internal controls related to financial reporting on Federal awards.