Audit 341823

FY End
2024-06-30
Total Expended
$34.23M
Findings
0
Programs
59
Organization: Frederick County, Maryland (MD)
Year: 2024 Accepted: 2025-02-10
Auditor: Sb & Company LLC

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
93.563 Child Support Enforcement $913,984 Yes 0
14.871 Section 8 Housing Choice Voucher Program $844,738 - 0
97.083 Staffing for Adequate Fire and Emergency Response $791,360 Yes 0
93.493 Congressional Directives $705,451 - 0
20.507 Covid-19- Federal Transit_formula Grants- Mass Transit/capital Outlay $420,000 - 0
97.039 Emergency Management Performance Grant $247,963 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $235,624 Yes 0
93.044 Title Iii, Part B- Grants for Supportive Services and Senior Centers $209,910 - 0
93.778 Medical Assistance Program $163,875 - 0
14.856 Lower Income Housing Assistance Program- Section 8 Moderate Rehabilitation $146,999 - 0
17.270 Reentry Employment Opportunities $144,794 - 0
93.045 Covid- 19- Title Iii, Part C- Nutrition Services $143,673 - 0
93.556 Promoting Safe and Stable Families $126,924 - 0
20.507 Federal Transit_formula Grants- Mass Transit/capital Outlay $123,650 - 0
20.509 Formula Grants for Rural Areas- Rural Public Transportation $121,528 - 0
84.027 Special Education- Grant to States- Individuals Disabilities Education Act (idea Part B) $97,966 - 0
17.259 Wioa Youth Activities $92,980 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $90,000 - 0
20.509 Covid-19- Formula Grants for Rural Areas- Rural Public Transportation $88,148 - 0
17.278 Wioa Dislocated Workers $79,153 - 0
16.540 Juvenile Justice and Delinquency Prevention $77,414 - 0
20.939 Safe Streets and Roads for All $59,840 - 0
84.181 Special Education- Grants for Infants and Families- Individuals Disabilities Education Act (idea Part C) $54,895 - 0
93.052 National Family Caregiver Support Title Iii, Part E $44,025 - 0
93.044 Covid-19- Title Iii, Part B- Grants for Supportive Services and Senior Centers $37,987 - 0
97.042 Emergency Management Performance Grant $37,826 - 0
17.207 Employment Service/wagner-Peyser Funded Activities $31,217 - 0
45.310 State Library Program $31,100 - 0
93.243 Substance Abuse and Mental Health Services $30,947 - 0
93.590 Community-Based Child Abuse Prevention Grant- Family Support Center $30,000 - 0
21.023 Emergency Rental Assistance Program $28,765 - 0
16.606 State Criminal Alien Assistance Program $28,306 - 0
15.904 Historical Preservation Funds- Grant in Aid $22,750 - 0
93.324 State Health Insurance Assistance Program $20,715 - 0
93.053 Nutrition Services Incentive Program $17,441 - 0
97.067 Homeland Security Grant Program $16,826 - 0
32.009 State Library Program $14,540 - 0
16.922 Equitable Sharing Program $13,896 - 0
21.016 Equitable Sharing Program $11,160 - 0
93.052 Covid-19- National Family Caregiver Support Title Iii, Part E $11,017 - 0
84.173 Special Education- Preschool Grants- Individuals Disabilities Education Act (idea Part B 619) $9,536 - 0
20.205 Highway Planning and Construction- Bridge Projects $8,824 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $7,302 - 0
93.042 Title Vii, Chapter 3- Programs for Prevention of Elder Abuse, Neglect, and Exploitation $6,153 - 0
93.048 Title IV and Title II- Discretionary Projects $5,554 - 0
66.312 Environmental Justice Government-to-Government (ejg2g) Program $5,159 - 0
93.043 Title Iii, Part D- Disease Prevention and Health Promotion Services $5,094 - 0
17.258 Wioa Adult Program $5,070 - 0
17.801 Disabled Veterans' Outreach Program $4,356 - 0
93.558 Temporary Assistance for Needy Families- Family Preservation/youth Summer Jobs $3,985 - 0
84.126 Rehabilitation Services- Dors Year Round $3,904 - 0
93.071 Medicare Enrollment Assistance Program- Mippa $2,357 - 0
17.225 Unemployment Insurance $1,420 - 0
17.235 Senior Community Service Employment Program $1,420 - 0
84.002 Adult Education - Basic Grants to States $1,420 - 0
84.048 Career and Technical Education- Basic Grants to States $1,420 - 0
93.041 Title Vii, Chapter 3- Programs for Prevention of Elder Abuse, Neglect, and Exploitation $1,258 - 0
93.045 Title Iii, Part C- Nutrition Services $953 - 0
17.245 Trade Adjustment Assistance $457 - 0

Contacts

Name Title Type
K9VMLKYJNYP7 Melanie Thom Auditee
3016002217 Christopher Lehman Auditor
No contacts on file

Notes to SEFA

Title: 2. BASIS OF PRESENTATION Accounting Policies: All Federal grant operations of Frederick County, Maryland (the County) are included in the scope of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirement, Cost Principles, and Audit Requirements for Federal Awards (the Single Audit). The Single Audit was performed in accordance with the provisions of the U.S. Office of Management and Budget (OMB) Compliance Supplement (the Compliance Supplement). Compliance testing of all requirements, as described in the Compliance Supplement, was performed for the grant programs noted below. The programs on the Schedule of expenditures of Federal awards (the Schedule) represent all Federal award programs with fiscal year 2024, cash or non-cash expenditure activities. For single audit testing, we tested to ensure coverage of at least 20% of Federally granted funds. Actual coverage was 44%. The major programs tested are listed below. Major ProgramsCoronavirus State and Local Fiscal Recovery Funds21.027 $ 9,265,127 Child Support Enforcement93.563 1,222,656 Staffing for Adequate Fire and Emergency Response 97.0834,552,478 15,040,261$ Federal Assistance Listing NumberFederal Expenditures Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such 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. Expenditures are also subject to audit by the relevant Federal agency. In the opinion of management, disallowed costs, if any, from such audits will not have a material effect on this Schedule or the financial position of the County. De Minimis Rate Used: N Rate Explanation: The County 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 County under programs of the Federal government for the year ended June 30, 2024. The information in the Schedule is presented in accordance with the requirements of the Uniform Guidance. Because the Schedule presents only a selected portion of the operations of the County, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the County.
Title: 3. LOAN PROGRAM Accounting Policies: All Federal grant operations of Frederick County, Maryland (the County) are included in the scope of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirement, Cost Principles, and Audit Requirements for Federal Awards (the Single Audit). The Single Audit was performed in accordance with the provisions of the U.S. Office of Management and Budget (OMB) Compliance Supplement (the Compliance Supplement). Compliance testing of all requirements, as described in the Compliance Supplement, was performed for the grant programs noted below. The programs on the Schedule of expenditures of Federal awards (the Schedule) represent all Federal award programs with fiscal year 2024, cash or non-cash expenditure activities. For single audit testing, we tested to ensure coverage of at least 20% of Federally granted funds. Actual coverage was 44%. The major programs tested are listed below. Major ProgramsCoronavirus State and Local Fiscal Recovery Funds21.027 $ 9,265,127 Child Support Enforcement93.563 1,222,656 Staffing for Adequate Fire and Emergency Response 97.0834,552,478 15,040,261$ Federal Assistance Listing NumberFederal Expenditures Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such 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. Expenditures are also subject to audit by the relevant Federal agency. In the opinion of management, disallowed costs, if any, from such audits will not have a material effect on this Schedule or the financial position of the County. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The County administers a loan under Capitalization Grants for Clean Water State Revolving Funds from the Maryland Department of the Environment (Assistance Listing Number 66.458) without continuing compliance requirements and therefore the loan is not presented in the Schedule. The loan was used for municipal wastewater treatment plant and landfill cell lining and capping. The outstanding balance of the loan as of June 30, 2024 was $17,919,826. There were no draws on the loan during 2024.
Title: 4. RECONCILIATION TO BASIC FINANCIAL STATEMENTS Accounting Policies: All Federal grant operations of Frederick County, Maryland (the County) are included in the scope of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirement, Cost Principles, and Audit Requirements for Federal Awards (the Single Audit). The Single Audit was performed in accordance with the provisions of the U.S. Office of Management and Budget (OMB) Compliance Supplement (the Compliance Supplement). Compliance testing of all requirements, as described in the Compliance Supplement, was performed for the grant programs noted below. The programs on the Schedule of expenditures of Federal awards (the Schedule) represent all Federal award programs with fiscal year 2024, cash or non-cash expenditure activities. For single audit testing, we tested to ensure coverage of at least 20% of Federally granted funds. Actual coverage was 44%. The major programs tested are listed below. Major ProgramsCoronavirus State and Local Fiscal Recovery Funds21.027 $ 9,265,127 Child Support Enforcement93.563 1,222,656 Staffing for Adequate Fire and Emergency Response 97.0834,552,478 15,040,261$ Federal Assistance Listing NumberFederal Expenditures Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such 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. Expenditures are also subject to audit by the relevant Federal agency. In the opinion of management, disallowed costs, if any, from such audits will not have a material effect on this Schedule or the financial position of the County. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Amounts reported in the accompanying Schedule do not agree with amounts reported on the County’s Annual Comprehensive Financial Report (ACFR). The reconciling items between ACFR and the Schedule are as follows: Federal grant revenues per ACFR:Statement of Revenues, Expenditures and Changes in Fund Balances - Governmental Funds31,209,354$ Statement of Revenues, Expenses and Changes in Net Position - Library Fund45,640 31,254,994 Reconciling items:Federal expenditures related to loss of revenue previously recognized in the financial statements7,937,833 Federal reimbursements not subject to Single Audit(4,983,813) Other25,055 2,979,075 Total Expenditures of Federal Awards34,234,069