Audit 289401

FY End
2022-06-30
Total Expended
$29.63M
Findings
16
Programs
30
Organization: City of Warwick, Rhode Island (RI)
Year: 2022 Accepted: 2024-02-08

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
366549 2022-003 Significant Deficiency - L
366550 2022-003 Significant Deficiency - L
366551 2022-003 Significant Deficiency - L
366552 2022-003 Significant Deficiency - L
366553 2022-004 Significant Deficiency Yes AB
366554 2022-004 Significant Deficiency Yes AB
366555 2022-004 Significant Deficiency Yes AB
366556 2022-004 Significant Deficiency Yes AB
942991 2022-003 Significant Deficiency - L
942992 2022-003 Significant Deficiency - L
942993 2022-003 Significant Deficiency - L
942994 2022-003 Significant Deficiency - L
942995 2022-004 Significant Deficiency Yes AB
942996 2022-004 Significant Deficiency Yes AB
942997 2022-004 Significant Deficiency Yes AB
942998 2022-004 Significant Deficiency Yes AB

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $7.18M Yes 0
10.555 National School Lunch Program $3.16M - 0
84.027 Special Education_grants to States $2.84M - 0
84.010 Title I Grants to Local Educational Agencies $1.79M Yes 0
10.553 School Breakfast Program $1.06M - 0
14.218 Community Development Block Grants/entitlement Grants $806,579 - 0
84.371 Striving Readers $485,663 - 0
84.367 Improving Teacher Quality State Grants $465,496 - 0
32.009 Emergency Connectivity Fund Program $456,752 - 0
84.048 Career and Technical Education -- Basic Grants to States $315,529 - 0
84.424 Student Support and Academic Enrichment Program $306,206 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $292,485 - 0
97.044 Assistance to Firefighters Grant $186,550 - 0
20.616 National Priority Safety Programs $156,821 - 0
84.173 Special Education_preschool Grants $74,837 - 0
97.067 Homeland Security Grant Program $73,745 - 0
10.582 Fresh Fruit and Vegetable Program $61,050 - 0
16.922 Equitable Sharing Program $49,315 - 0
84.425 Education Stabilization Fund $43,275 Yes 2
16.U01 Cbp/ice Grant $39,807 - 0
10.558 Child and Adult Care Food Program $32,658 - 0
14.268 Rural Housing Stability Assistance Program $30,788 - 0
10.559 Summer Food Service Program for Children $25,380 - 0
84.365 English Language Acquisition State Grants $24,677 - 0
84.196 Education for Homeless Children and Youth $17,920 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $15,649 - 0
16.U03 FBI-Cetf $12,856 - 0
20.600 State and Community Highway Safety $11,505 - 0
16.U02 Dea Reimbursement $11,219 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $11,219 - 0

Contacts

Name Title Type
LJGHSDDENJU3 Lynne Prodger Auditee
4019219642 Jennifer Cook Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance. Under these principles, certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City of Warwick, Rhode Island did not elect to use the 10-percent de minimis indirect cost rate identified in §200.414 of the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of the City of Warwick, Rhode Island, under programs of the federal government for the year ended June 30, 2022. The information in this Schedule is presented in accordance with the requirements of 2 CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the City of Warwick, Rhode Island, it is not intended to and does not present the financial position, changes in net position, or cash flows of the City of Warwick, Rhode Island.
Title: U.S. Department of Agriculture Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance. Under these principles, certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City of Warwick, Rhode Island did not elect to use the 10-percent de minimis indirect cost rate identified in §200.414 of the Uniform Guidance. The amount reported for the National School Lunch Program – Non-Cash Assistance (Commodities) represents non-monetary assistance and is reported in the Schedule at the fair market value of the commodities received. The amounts reported for the Summer Food Service Program for Children, and Child and Adult Care Food Program are reported in the schedule based on federal reimbursements under the modified accrual basis of accounting.

Finding Details

2022-003 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4672-10502-101, 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Reporting Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund I, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 9/30/2020 through 9/30/2022. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2022. Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund III, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 3/31/2022 through 9/30/2024. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2024. 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: Expenditures reported in the quarterly financial status reports did not agree to supporting documentation. Questioned Costs: None. Context: For the ESSER I quarterly financial status report for the quarter ending 9/30/2021, expenditures reported did not agree to supporting schedules. For the ESSER III quarterly financial status report for the quarter ending 6/30/2022, expenditures reported did not agree to supporting schedules. Cause: The City's procedures were not sufficient to ensure that reports were submitted accurately and proper documentation maintained. Effect: Reported expenditures were not properly supported. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that all reports are prepared and reviewed for accuracy and supporting documentation maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-003 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4672-10502-101, 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Reporting Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund I, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 9/30/2020 through 9/30/2022. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2022. Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund III, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 3/31/2022 through 9/30/2024. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2024. 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: Expenditures reported in the quarterly financial status reports did not agree to supporting documentation. Questioned Costs: None. Context: For the ESSER I quarterly financial status report for the quarter ending 9/30/2021, expenditures reported did not agree to supporting schedules. For the ESSER III quarterly financial status report for the quarter ending 6/30/2022, expenditures reported did not agree to supporting schedules. Cause: The City's procedures were not sufficient to ensure that reports were submitted accurately and proper documentation maintained. Effect: Reported expenditures were not properly supported. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that all reports are prepared and reviewed for accuracy and supporting documentation maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-003 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4672-10502-101, 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Reporting Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund I, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 9/30/2020 through 9/30/2022. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2022. Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund III, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 3/31/2022 through 9/30/2024. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2024. 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: Expenditures reported in the quarterly financial status reports did not agree to supporting documentation. Questioned Costs: None. Context: For the ESSER I quarterly financial status report for the quarter ending 9/30/2021, expenditures reported did not agree to supporting schedules. For the ESSER III quarterly financial status report for the quarter ending 6/30/2022, expenditures reported did not agree to supporting schedules. Cause: The City's procedures were not sufficient to ensure that reports were submitted accurately and proper documentation maintained. Effect: Reported expenditures were not properly supported. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that all reports are prepared and reviewed for accuracy and supporting documentation maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-003 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4672-10502-101, 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Reporting Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund I, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 9/30/2020 through 9/30/2022. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2022. Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund III, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 3/31/2022 through 9/30/2024. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2024. 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: Expenditures reported in the quarterly financial status reports did not agree to supporting documentation. Questioned Costs: None. Context: For the ESSER I quarterly financial status report for the quarter ending 9/30/2021, expenditures reported did not agree to supporting schedules. For the ESSER III quarterly financial status report for the quarter ending 6/30/2022, expenditures reported did not agree to supporting schedules. Cause: The City's procedures were not sufficient to ensure that reports were submitted accurately and proper documentation maintained. Effect: Reported expenditures were not properly supported. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that all reports are prepared and reviewed for accuracy and supporting documentation maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-004 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR § 200.430 (a), costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non- Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. Per 2 CFR § 200.430 (i), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:  Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated,  Be incorporated into the official records of the non-Federal entity,  Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities,  Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy,  Comply with the established accounting policies and practices of the non-Federal entity,  Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 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: Payroll costs charged to the grant showed no evidence of approval. Questioned Costs: Below the reportable limit. Context: For 16 out of 60 payroll costs charged to the grant, time sheets or other documentation was not available to support evidence of approval for time worked. Cause: The City's procedures were not sufficient to ensure that payroll charges were appropriately approved and documented. Effect: Payroll costs charged to the grant may not be allowable. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that approval for payroll charges is documented and maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-004 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR § 200.430 (a), costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non- Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. Per 2 CFR § 200.430 (i), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:  Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated,  Be incorporated into the official records of the non-Federal entity,  Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities,  Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy,  Comply with the established accounting policies and practices of the non-Federal entity,  Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 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: Payroll costs charged to the grant showed no evidence of approval. Questioned Costs: Below the reportable limit. Context: For 16 out of 60 payroll costs charged to the grant, time sheets or other documentation was not available to support evidence of approval for time worked. Cause: The City's procedures were not sufficient to ensure that payroll charges were appropriately approved and documented. Effect: Payroll costs charged to the grant may not be allowable. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that approval for payroll charges is documented and maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-004 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR § 200.430 (a), costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non- Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. Per 2 CFR § 200.430 (i), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:  Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated,  Be incorporated into the official records of the non-Federal entity,  Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities,  Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy,  Comply with the established accounting policies and practices of the non-Federal entity,  Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 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: Payroll costs charged to the grant showed no evidence of approval. Questioned Costs: Below the reportable limit. Context: For 16 out of 60 payroll costs charged to the grant, time sheets or other documentation was not available to support evidence of approval for time worked. Cause: The City's procedures were not sufficient to ensure that payroll charges were appropriately approved and documented. Effect: Payroll costs charged to the grant may not be allowable. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that approval for payroll charges is documented and maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-004 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR § 200.430 (a), costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non- Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. Per 2 CFR § 200.430 (i), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:  Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated,  Be incorporated into the official records of the non-Federal entity,  Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities,  Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy,  Comply with the established accounting policies and practices of the non-Federal entity,  Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 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: Payroll costs charged to the grant showed no evidence of approval. Questioned Costs: Below the reportable limit. Context: For 16 out of 60 payroll costs charged to the grant, time sheets or other documentation was not available to support evidence of approval for time worked. Cause: The City's procedures were not sufficient to ensure that payroll charges were appropriately approved and documented. Effect: Payroll costs charged to the grant may not be allowable. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that approval for payroll charges is documented and maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-003 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4672-10502-101, 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Reporting Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund I, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 9/30/2020 through 9/30/2022. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2022. Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund III, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 3/31/2022 through 9/30/2024. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2024. 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: Expenditures reported in the quarterly financial status reports did not agree to supporting documentation. Questioned Costs: None. Context: For the ESSER I quarterly financial status report for the quarter ending 9/30/2021, expenditures reported did not agree to supporting schedules. For the ESSER III quarterly financial status report for the quarter ending 6/30/2022, expenditures reported did not agree to supporting schedules. Cause: The City's procedures were not sufficient to ensure that reports were submitted accurately and proper documentation maintained. Effect: Reported expenditures were not properly supported. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that all reports are prepared and reviewed for accuracy and supporting documentation maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-003 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4672-10502-101, 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Reporting Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund I, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 9/30/2020 through 9/30/2022. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2022. Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund III, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 3/31/2022 through 9/30/2024. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2024. 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: Expenditures reported in the quarterly financial status reports did not agree to supporting documentation. Questioned Costs: None. Context: For the ESSER I quarterly financial status report for the quarter ending 9/30/2021, expenditures reported did not agree to supporting schedules. For the ESSER III quarterly financial status report for the quarter ending 6/30/2022, expenditures reported did not agree to supporting schedules. Cause: The City's procedures were not sufficient to ensure that reports were submitted accurately and proper documentation maintained. Effect: Reported expenditures were not properly supported. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that all reports are prepared and reviewed for accuracy and supporting documentation maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-003 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4672-10502-101, 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Reporting Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund I, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 9/30/2020 through 9/30/2022. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2022. Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund III, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 3/31/2022 through 9/30/2024. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2024. 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: Expenditures reported in the quarterly financial status reports did not agree to supporting documentation. Questioned Costs: None. Context: For the ESSER I quarterly financial status report for the quarter ending 9/30/2021, expenditures reported did not agree to supporting schedules. For the ESSER III quarterly financial status report for the quarter ending 6/30/2022, expenditures reported did not agree to supporting schedules. Cause: The City's procedures were not sufficient to ensure that reports were submitted accurately and proper documentation maintained. Effect: Reported expenditures were not properly supported. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that all reports are prepared and reviewed for accuracy and supporting documentation maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-003 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4672-10502-101, 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Reporting Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund I, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 9/30/2020 through 9/30/2022. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2022. Per the Rhode Island Department of Elementary and Secondary Education Grant Award Notification, specifically related to ESSER Fund III, Special Grant Award Conditions, "Interim financial status reports are due quarterly for the periods ending 3/31/2022 through 9/30/2024. Final financial status reports are due 15 days after the liquidation of all obligations, but no later than 11/15/2024. 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: Expenditures reported in the quarterly financial status reports did not agree to supporting documentation. Questioned Costs: None. Context: For the ESSER I quarterly financial status report for the quarter ending 9/30/2021, expenditures reported did not agree to supporting schedules. For the ESSER III quarterly financial status report for the quarter ending 6/30/2022, expenditures reported did not agree to supporting schedules. Cause: The City's procedures were not sufficient to ensure that reports were submitted accurately and proper documentation maintained. Effect: Reported expenditures were not properly supported. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that all reports are prepared and reviewed for accuracy and supporting documentation maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-004 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR § 200.430 (a), costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non- Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. Per 2 CFR § 200.430 (i), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:  Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated,  Be incorporated into the official records of the non-Federal entity,  Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities,  Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy,  Comply with the established accounting policies and practices of the non-Federal entity,  Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 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: Payroll costs charged to the grant showed no evidence of approval. Questioned Costs: Below the reportable limit. Context: For 16 out of 60 payroll costs charged to the grant, time sheets or other documentation was not available to support evidence of approval for time worked. Cause: The City's procedures were not sufficient to ensure that payroll charges were appropriately approved and documented. Effect: Payroll costs charged to the grant may not be allowable. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that approval for payroll charges is documented and maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-004 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR § 200.430 (a), costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non- Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. Per 2 CFR § 200.430 (i), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:  Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated,  Be incorporated into the official records of the non-Federal entity,  Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities,  Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy,  Comply with the established accounting policies and practices of the non-Federal entity,  Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 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: Payroll costs charged to the grant showed no evidence of approval. Questioned Costs: Below the reportable limit. Context: For 16 out of 60 payroll costs charged to the grant, time sheets or other documentation was not available to support evidence of approval for time worked. Cause: The City's procedures were not sufficient to ensure that payroll charges were appropriately approved and documented. Effect: Payroll costs charged to the grant may not be allowable. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that approval for payroll charges is documented and maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-004 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR § 200.430 (a), costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non- Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. Per 2 CFR § 200.430 (i), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:  Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated,  Be incorporated into the official records of the non-Federal entity,  Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities,  Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy,  Comply with the established accounting policies and practices of the non-Federal entity,  Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 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: Payroll costs charged to the grant showed no evidence of approval. Questioned Costs: Below the reportable limit. Context: For 16 out of 60 payroll costs charged to the grant, time sheets or other documentation was not available to support evidence of approval for time worked. Cause: The City's procedures were not sufficient to ensure that payroll charges were appropriately approved and documented. Effect: Payroll costs charged to the grant may not be allowable. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that approval for payroll charges is documented and maintained. Views of Responsible Officials: There is no disagreement with the audit finding.
2022-004 Federal Agency: U.S. Department of Education Federal Programs: Education Stabilization Fund Assistance Listing Number: 84.425U Pass-Through Agency: Rhode Island Department of Elementary and Secondary Education Pass-Through Number: 4872-505020-201 Award Period: July 1, 2021 – June 30, 2022 Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR § 200.430 (a), costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non- Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. Per 2 CFR § 200.430 (i), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:  Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated,  Be incorporated into the official records of the non-Federal entity,  Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities,  Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy,  Comply with the established accounting policies and practices of the non-Federal entity,  Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 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: Payroll costs charged to the grant showed no evidence of approval. Questioned Costs: Below the reportable limit. Context: For 16 out of 60 payroll costs charged to the grant, time sheets or other documentation was not available to support evidence of approval for time worked. Cause: The City's procedures were not sufficient to ensure that payroll charges were appropriately approved and documented. Effect: Payroll costs charged to the grant may not be allowable. Recommendation: We recommend the City review and enhance internal controls and procedures to ensure that approval for payroll charges is documented and maintained. Views of Responsible Officials: There is no disagreement with the audit finding.