Audit 305063

FY End
2023-06-30
Total Expended
$386.28M
Findings
54
Programs
27
Year: 2023 Accepted: 2024-04-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
395146 2023-003 Material Weakness - A
395147 2023-003 Material Weakness - A
395148 2023-003 Material Weakness - A
395149 2023-003 Material Weakness - A
395150 2023-003 Material Weakness - A
395151 2023-003 Material Weakness - A
395152 2023-003 Material Weakness - A
395153 2023-003 Material Weakness - A
395154 2023-003 Material Weakness - A
395155 2023-003 Material Weakness - A
395156 2023-003 Material Weakness - A
395157 2023-003 Material Weakness - A
395158 2023-003 Material Weakness - A
395159 2023-003 Material Weakness - A
395160 2023-003 Material Weakness - A
395161 2023-002 Significant Deficiency - N
395162 2023-002 Significant Deficiency - N
395163 2023-002 Significant Deficiency - N
395164 2023-002 Significant Deficiency - N
395165 2023-002 Significant Deficiency - N
395166 2023-002 Significant Deficiency - N
395167 2023-002 Significant Deficiency - N
395168 2023-002 Significant Deficiency - N
395169 2023-002 Significant Deficiency - N
395170 2023-002 Significant Deficiency - N
395171 2023-002 Significant Deficiency - N
395172 2023-002 Significant Deficiency - N
971588 2023-003 Material Weakness - A
971589 2023-003 Material Weakness - A
971590 2023-003 Material Weakness - A
971591 2023-003 Material Weakness - A
971592 2023-003 Material Weakness - A
971593 2023-003 Material Weakness - A
971594 2023-003 Material Weakness - A
971595 2023-003 Material Weakness - A
971596 2023-003 Material Weakness - A
971597 2023-003 Material Weakness - A
971598 2023-003 Material Weakness - A
971599 2023-003 Material Weakness - A
971600 2023-003 Material Weakness - A
971601 2023-003 Material Weakness - A
971602 2023-003 Material Weakness - A
971603 2023-002 Significant Deficiency - N
971604 2023-002 Significant Deficiency - N
971605 2023-002 Significant Deficiency - N
971606 2023-002 Significant Deficiency - N
971607 2023-002 Significant Deficiency - N
971608 2023-002 Significant Deficiency - N
971609 2023-002 Significant Deficiency - N
971610 2023-002 Significant Deficiency - N
971611 2023-002 Significant Deficiency - N
971612 2023-002 Significant Deficiency - N
971613 2023-002 Significant Deficiency - N
971614 2023-002 Significant Deficiency - N

Programs

ALN Program Spent Major Findings
10.555 National School Lunch Program $33.56M - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $9.51M Yes 0
10.553 School Breakfast Program $8.06M - 0
10.558 Child and Adult Care Food Program $3.68M - 0
10.582 Fresh Fruit and Vegetable Program $1.99M - 0
84.367 Supporting Effective Instruction $1.39M - 0
84.048 Career and Technical Education -- Basic Grants to States $1.38M - 0
10.559 Summer Food Service Program for Children $1.26M - 0
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $1.24M Yes 1
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $1.19M - 0
84.425 Covid-19 - Education Stabilization Fund $459,193 Yes 1
84.010 Title I Grants to Local Educational Agencies $238,405 Yes 1
84.027 Covid-19 - Special Education_grants to States $228,759 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $191,638 - 0
93.297 Teenage Pregnancy Prevention Program $190,916 - 0
93.575 Child Care and Development Block Grant $169,359 - 0
84.027 Special Education_grants to States $85,123 - 0
21.019 Coronavirus Relief Fund $65,790 - 0
84.365 English Language Acquisition State Grants $38,172 - 0
84.060 Indian Education_grants to Local Educational Agencies $16,248 - 0
84.173 Special Education_preschool Grants $13,446 - 0
84.411 Education Innovation and Research $11,653 - 0
84.424 Student Support and Academic Enrichment Program $6,990 Yes 0
84.196 Education for Homeless Children and Youth $4,045 - 0
84.287 Twenty-First Century Community Learning Centers $2,020 - 0
84.181 Special Education-Grants for Infants and Families $2,000 - 0
16.607 Bulletproof Vest Partnership Program $27 - 0

Contacts

Name Title Type
SGE3HCFU39H1 Sridevi Veeramachaneni Auditee
4437391373 Aires Coleman Auditor
No contacts on file

Notes to SEFA

Title: NOTE 2 RELATION TO FINANCIAL STATEMENTS AND FEDERAL FINANCIAL REPORTS Accounting Policies: The accompanying schedule of expenditures of federal awards presents the activity of all federal award programs of the Baltimore City Public School System (City Schools) for the year ended June 30, 2023. Basis of Accounting The accompanying schedule of expenditures of federal awards has been prepared using the modified accrual basis of accounting. This basis of accounting is fully described in Note 1 to the City Schools’ basic financial statements. De Minimis Rate Used: N Rate Explanation: City Schools did not elect the 10% de minimis indirect cost rate. The following schedule reconciles the amounts per the financial statements to the amounts per the schedule of expenditures of federal awards for the year ended June 30, 2023: Total federal expenditures reported in the Schedule $ 386,284,587 Federal revenues included in the basic financial statements that are not required to be included in the Schedule: Medicaid funds under contract for services 6,453,532 R.O.T.C. funds under contract for services 557,983 Impact aid 204,346 FEMA Reimbursement- (*) 23,781,711 IRS Bond Subsidy 1,540,061 Other adjustments (220) Total $ 418,822,000 Total federal revenues reported in the basic financial statements: Special Revenue Fund $ 330,891,000 Food Service Fund 52,340,000 General Fund 35,591,000 Total $ 418,822,000 (*) FEMA approved project worksheet is in process as of June 30, 2023

Finding Details

2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-003 Allowable Costs: Payroll Costs Federal Agency: U.S. Department of Education Federal Program Name: Coronavirus State and Local Fiscal Relief Fund (CSLFRF), Education Stabilization Fund (ESF) and Student Support and Academic Enrichment Program (Title IV) Assistance Listing Number: 21.027, 84.425 C, D, U,W and 84.424 Federal Award Identification Number and Year (s): CSLFRF: none and 3/2021-12/31/2024, ESF: S425D20005, S425C200002, S425U200002, S425W200002 and 3/13/2020-9/30/2023, Title IV: S424A200021 and Fiscal years 2021-2025 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): CSLFRF: 211770, 211821, 211903, 211889, 211904, 21188 ESF: 201766, 201878, 202134, 202126, 211958, 221569, 221864, 222038, 221360, Title IV: 211382, 221548, 23253 Award Period (s): CSLFRF: 3/2021-12/31/2024, ESF: 3/13/2020-9/30/2023, Title IV: Fiscal years 2021-2025 Type of Finding: Material Non-Compliance, Material Weakness in Internal Control Criteria or specific requirement: Compliance: For an employee who works in part on the consolidated administrative cost objective and in part on a Federal program whose administrative funds have not been consolidated or on activities funded from other revenue sources, an SEA or LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: • The consolidated cost objective, and • Each program or other cost objective supported by non-consolidated Federal funds or other revenue sources. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Time and effort documentation did not support the employee’s payroll costs charged to the grant. In addition, payroll testing for the Education Stabilization Funds grant, we identified the following: 1. Employee’s time and effort documentation was not provided. 2. Documentation to support the employees’ gross pay or hourly rate was not provided. As a result, the auditor was unable to support the accuracy of the employee's pay charged to the grant. 3. Employees were included in the grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Replacement samples were not selected and deemed ineffective as the population did not clearly identify which employee’s payroll costs were removed from the grant. Questioned costs: Time and effort documentation did not support the employee’s payroll costs charged to the grant. CSLFRF: $6,087.16, ESF: $3,807.00, Title IV: $6,097.07 ESF: a. $18,256.60- employees time and effort and/or support for salary or hourly rate was not provided b. $ 6,150.10 - employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant Context: Time and effort did not support payroll costs charged to the grant: c. CSLFRF 8 out of 60 transactions tested d. ESF: 3 out of 60 transactions tested e. Title IV: 12 out of 40 transactions tested ESF: f. 6 out of 60 employees time and effort and/or support for salary or hourly rate was not provided. g. 4 out of 60 employees were included in grant expenditure population, after inquiry from the auditor, City Schools stated that the employee’s salary was no longer charged to the grant. Cause: City Schools did not have documentation to support payroll costs charged to the grant readily available for the audit. Effect: City Schools is unable to support payroll costs charged to the grant. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained and readily available to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.
2023-002 Special Tests: Graduation Cohort Federal Agency: U.S. Department of Education Federal Program Name: Title I Assistance Listing Number: 84.010 Federal Award Identification Number and Year: A010A200020 and fiscal years 2019-2022 Pass-Through Agency: Maryland State Department of Education Pass-Through Number(s): 200091, 211083, 221498, 231248, 201469, 211311, 221770, 231256, 201704, 211289, 221674, 231035 Award Period (s): Fiscal years 2019-2022 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per ESEA sections 1111(h)(1)(C)(iii)(II) and 8101(23), (25) (20 USC 6311(h)(1)(C)(iii)(II) and 7801(23), (25))), in order to remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, transferred to a prison or juvenile facility, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a GED program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: City Schools did not obtain and/or maintain documentation to support students’ the withdrawal code reported to Maryland State Department of Education (MSDE). MSDE requires City Schools to provide data for students that no longer attend a school in the district. The data is used to determine if City Schools’s graduation rate is affected because of the student’s departure. We identified 3 students whose withdrawal code was not supported by documentation for more than a year after the student’s departure from the district. 2 of the 3 students, 2 students attended other schools and 1 student no longer lived in the United States. In all 3 errors, the student was identified as reported as attending a school within the district without adequate documentation Questioned costs: None Context: For 2 out of 40 students tested, City Schools did not obtain documentation to support the student’s transfer to another school prior to the auditor’s inquiry. The school reported that student as attending another school without documentation the transfer. For 1 out of 40 students tested, the student no longer lived in the United States and did not attend school for school years 2019-2020 and 2020-2021. The school reported the student as attending school for both school years before learning that the student was no longer in the country. Cause: City Schools did not consistently follow the established procedures related to student withdrawal codes. Effect: MSDE data was not correct and City Schools’ graduation rate may be incorrect. Repeat Finding: No Recommendation: We recommend that the schools develop internal controls and procedures to ensure the documentation is consistently maintained to support compliance with grantor’s requirements. Views of responsible officials: There is no disagreement with the audit finding.