Audit 307735

FY End
2023-06-30
Total Expended
$31.69M
Findings
4
Programs
26
Year: 2023 Accepted: 2024-05-31

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
399174 2023-001 Significant Deficiency - I
399175 2023-002 Significant Deficiency Yes L
975616 2023-001 Significant Deficiency - I
975617 2023-002 Significant Deficiency Yes L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $10.56M Yes 2
10.553 School Breakfast Program $760,832 - 0
10.555 National School Lunch Program $306,548 - 0
84.287 Twenty-First Century Community Learning Centers $295,144 - 0
84.027 Special Education_grants to States $196,018 Yes 0
10.559 Summer Food Service Program for Children $140,532 - 0
84.367 Improving Teacher Quality State Grants $105,110 - 0
84.010 Title I Grants to Local Educational Agencies $78,884 Yes 0
20.106 Airport Improvement Program $74,536 - 0
16.588 Violence Against Women Formula Grants $54,733 - 0
94.002 Retired and Senior Volunteer Program $45,729 - 0
20.600 State and Community Highway Safety $42,715 - 0
14.218 Community Development Block Grants/entitlement Grants $41,523 Yes 0
84.048 Career and Technical Education -- Basic Grants to States $39,610 - 0
10.582 Fresh Fruit and Vegetable Program $35,309 - 0
84.173 Special Education_preschool Grants $26,406 Yes 0
10.579 Child Nutrition Discretionary Grants Limited Availability $24,686 - 0
84.424 Student Support and Academic Enrichment Program $22,119 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $20,539 - 0
97.042 Emergency Management Performance Grants $20,150 - 0
15.153 Hurricane Sandy Disaster Relief Ð Coastal Resiliency Grants. $11,563 - 0
84.425 Education Stabilization Fund $3,900 Yes 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $3,000 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $2,379 - 0
84.365 English Language Acquisition State Grants $1,087 - 0
45.310 Grants to States $190 - 0

Contacts

Name Title Type
DG3AQ4WL5JW7 Matthew Kerwood Auditee
4134999466 Thomas J Scanlon JR Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City of Pittsfield, Massachusetts, did not use the de minimis cost rate. The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) includes the federal grant activity of the City of Pittsfield, Massachusetts, under programs of the federal government for the year ended June 30, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the City of Pittsfield, Massachusetts, it is not intended to and does not present the financial position, changes in net position, or cash flows of the City of Pittsfield, Massachusetts.
Title: Summary of Significant Accounting Policies Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City of Pittsfield, Massachusetts, did not use the de minimis cost rate. Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement.
Title: Indirect Costs Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City of Pittsfield, Massachusetts, did not use the de minimis cost rate. The City of Pittsfield, Massachusetts, did not use the de minimis cost rate.
Title: Food Distribution Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City of Pittsfield, Massachusetts, did not use the de minimis cost rate. The City of Pittsfield, Massachusetts, receives non-cash commodities from the U.S. Department of Agriculture as part of the National School Lunch program. The amounts reported as non-cash assistance represent the fair market value of these commodities received during the year. The amounts reported as cash assistance represent federal reimbursement for meals provided.

Finding Details

While the city follows state law regarding the procurement of engineering services, going forward the city follow Uniform Guidance 2CFR Section 200.319 for any new projects that require any engineering services, or any other services exempt from state procurement laws.
In working to resolve this continued variance issue, it was identified that wage rates used for the Treasury reports were lower than what is reflected on the General Ledger due to a slight discrepancy in the hourly rates used to calculate the wages for the Treasury Reports. Management intends to recreate the wage reports using the correct data and report this information in a future Treasury Report.
While the city follows state law regarding the procurement of engineering services, going forward the city follow Uniform Guidance 2CFR Section 200.319 for any new projects that require any engineering services, or any other services exempt from state procurement laws.
In working to resolve this continued variance issue, it was identified that wage rates used for the Treasury reports were lower than what is reflected on the General Ledger due to a slight discrepancy in the hourly rates used to calculate the wages for the Treasury Reports. Management intends to recreate the wage reports using the correct data and report this information in a future Treasury Report.