Audit 346469

FY End
2024-06-30
Total Expended
$8.45M
Findings
0
Programs
59
Organization: City of Hagerstown, Maryland (MD)
Year: 2024 Accepted: 2025-03-17
Auditor: Sb & Company LLC

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
23.009 Appalachian Regional Commission - Professional Boulevard Extension $1.25M Yes 0
21.027 American Rescue Plan Act of 2021 Trash Collection Totes $950,159 Yes 0
21.027 American Rescue Plan Act of 2021 Ww Pump Station 33 $822,751 Yes 0
21.027 American Rescue Plan Act of 2021 City Hall Annex Building $820,120 Yes 0
14.218 Expenditures Related to Program Income $704,098 - 0
21.027 American Rescue Plan Act of 2021 Hfd Fire Truck $467,664 Yes 0
21.027 American Rescue Plan Act of 2021 City Hall Elevator $338,469 Yes 0
14.218 Community Development Block Grant - Entitlement (07/01/2022) $282,566 - 0
14.218 Community Development Block Grant - Entitlement (07/01/2023) $251,813 - 0
23.009 Appalachian Regional Commission - Ww Collection System $200,000 Yes 0
21.027 American Rescue Plan Act of 2021 Hpd Cameras $191,731 Yes 0
21.027 American Rescue Plan Act of 2021 Hpd Axon Body Camera Contract $173,703 Yes 0
14.218 Community Development Block Grant - Entitlement (07/01/2021) $155,513 - 0
21.027 American Rescue Plan Act of 2021 Hagerstown Field House Stormwater $150,675 Yes 0
21.027 American Rescue Plan Act of 2021 Hfd Natural Gas Generator $132,533 Yes 0
21.027 American Rescue Plan Act of 2021 Trash Truck $121,875 Yes 0
21.027 American Rescue Plan Act of 2021 Public Facility Emergency Equipment $118,702 Yes 0
16.742 Coverdell Forensic Science Improvement Grant $105,562 - 0
21.027 American Rescue Plan Act of 2021 Artic Wolf Software $97,907 Yes 0
21.027 American Rescue Plan Act of 2021 Community Outreach Coordinator $94,451 Yes 0
14.218 Cares Act Funding: Cdbg Program Cdbg-Cv3 $87,781 - 0
21.027 American Rescue Plan Act of 2021 Microsoft Office 365 $79,957 Yes 0
21.027 American Rescue Plan Act of 2021 Grant Coordinator $59,142 Yes 0
20.600 Maryland Highway Safety Office Safe Streets and Roads for All $57,671 - 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Brooke's House $50,000 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Arc of Washington County $50,000 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Crs $49,000 Yes 0
21.027 American Rescue Plan Act of 2021 Community Outreach Vehicle $43,200 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Potomac Case $41,905 Yes 0
21.027 American Rescue Plan Act of 2021 Ww Pump Station 11 Generator $40,927 Yes 0
16.738 Edward J. Byrne Community Resource Officers $39,774 - 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Boys & Girls Club $36,822 Yes 0
20.205 Maryland Sha Transportation Alternatives Program $33,752 - 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Apples $27,691 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Community Free Clinic $25,799 Yes 0
21.027 American Rescue Plan Act of 2021 Brothers United Who Care $25,000 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Children in Need $24,733 Yes 0
21.027 American Rescue Plan Act of 2021 Convention/visitors Bureau $20,969 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Girls Inc. Education $20,894 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Hag Childrens $20,400 Yes 0
16.588 Lethality Assessment Coordinator $18,268 - 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Girls Inc. Mental Health $16,087 Yes 0
21.027 American Rescue Plan Act of 2021 Traffic Signals $14,602 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Head Start $13,782 Yes 0
21.027 American Rescue Plan Act of 2021 Hpd Range Security $12,659 Yes 0
21.027 American Rescue Plan Act of 2021 Gasboy Fleet System $12,575 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Library $12,000 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding the Mental Health $10,115 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Discovery Station $7,342 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Hha Trans $6,225 Yes 0
21.027 American Rescue Plan Act of 2021 Heart of the Art $5,700 Yes 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Gatekeepers $5,613 Yes 0
21.027 American Rescue Plan Act of 2021 Envy $4,982 Yes 0
16.000 Washington County Law Enforcement Assisted Diversion Lead Program $4,606 - 0
16.607 Bulletproof Vest Partnership Program $3,923 - 0
16.738 Lets-Crime Lab Bllodstain Examination Training $3,780 - 0
21.027 American Rescue Plan Act of 2021 Nonprofit Funding Hha Hud Reach $2,285 Yes 0
16.000 Washington/baltimore Hidta-Office of National Drug Control Policy $1,086 - 0
14.218 Community Development Block Grant - Entitlement (07/01/2016) $570 - 0

Contacts

Name Title Type
V9R8PB73N4G8 Michelle Hepburn Auditee
3017664160 Christopher Lehman Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: All Federal grant operations of the City of Hagerstown (the City) are included in the scope of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the Single Audit). The Single Audit was performed in accordance with the provisions of the OMB Compliance Supplement (the Compliance Supplement). Compliance testing of all requirements, as described in the Compliance Supplement, was performed for the major grant program noted below. The programs on the Schedule of Expenditures of Federal Awards (the Schedule) represent all Federal award programs and other grants with fiscal year 2024 cash or non-cash expenditure activities. For our single audit testing, we tested the Federal award program below with fiscal year 2024 cash and non-cash expenditures to ensure coverage of at least 20% of Federally granted funds. Our actual coverage was 79%. Expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the Uniform Guidance), wherein certain types of expenditures are not allowable or are limited as to reimbursement. The City has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Major Programs Federal Assistance Listing Number Federal Expenditures Appalachian Regional Commission 23.009 $ 1,450,000 Coronavirus State and Local Fiscal Recovery Funds 21.027 5,221,141 $ 6,671,141 De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The accompanying Schedule includes the Federal award activity of the City under programs of the Federal government for the year ended June 30, 2024, and is reported on the accrual basis of accounting. The information in the Schedule is presented in accordance with Uniform Guidance. Because the Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the City.
Title: LOAN OUTSTANDING Accounting Policies: All Federal grant operations of the City of Hagerstown (the City) are included in the scope of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the Single Audit). The Single Audit was performed in accordance with the provisions of the OMB Compliance Supplement (the Compliance Supplement). Compliance testing of all requirements, as described in the Compliance Supplement, was performed for the major grant program noted below. The programs on the Schedule of Expenditures of Federal Awards (the Schedule) represent all Federal award programs and other grants with fiscal year 2024 cash or non-cash expenditure activities. For our single audit testing, we tested the Federal award program below with fiscal year 2024 cash and non-cash expenditures to ensure coverage of at least 20% of Federally granted funds. Our actual coverage was 79%. Expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the Uniform Guidance), wherein certain types of expenditures are not allowable or are limited as to reimbursement. The City has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Major Programs Federal Assistance Listing Number Federal Expenditures Appalachian Regional Commission 23.009 $ 1,450,000 Coronavirus State and Local Fiscal Recovery Funds 21.027 5,221,141 $ 6,671,141 De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The drinking water loans made during the fiscal year are the amounts recorded on the Schedule. The prior loans do not have continuing compliance requirements other than repayment, therefore the outstanding loan balances as of the beginning of the year are not recorded on the Schedule. The City had the following loan balances outstanding as of June 30, 2024: Program Federal Assistance Listing Number Balance Outstanding Capitalization Loan A for Safe Drinking Water State Revolving Fund 66.468 $ 6,330,796 Total $ 6,330,796