Audit 49439

FY End
2022-06-30
Total Expended
$48.33M
Findings
0
Programs
72
Organization: Frederick County, Maryland (MD)
Year: 2022 Accepted: 2023-03-19
Auditor: Sb & Company LLC

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
14.871 Section 8 Housing Choice Voucher Program $6.91M Yes 0
97.083 Staffing for Adequate Fire and Emergency Response $1.62M - 0
21.023 Emergency Rental Assistance Program $1.33M Yes 0
20.507 Covid-19- Federal Transit_formula Grants- Mass Transit/capital Outlay $958,405 Yes 0
97.036 Covid-19- Disaster Grants-Public Assistance $819,321 - 0
14.228 Covid-19- Community Development Block Grant Program $593,563 - 0
93.498 Provider Relief Fund and American Rescue Plan (arp) Rural Distribution $485,063 - 0
93.268 Covid-19- Immunization Cooperative Agreements $418,089 - 0
93.563 Child Support Enforcement $234,821 - 0
20.509 Formula Grants for Rural Areas- Rural Public Transportation $204,528 Yes 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $196,218 Yes 0
14.856 Lower Income Housing Assistance Program- Section 8 Moderate Rehabilitation $183,801 - 0
93.575 Child Care and Development Block Grant $160,004 - 0
21.016 Equitable Sharing Program $143,907 - 0
17.270 Reentry Employment Opportunities $138,001 - 0
93.045 Covid-19-Title Iii, Part C- Nutrition Services $129,168 - 0
93.556 Promoting Safe and Stable Families $127,500 - 0
97.044 Covid-19-Assistance to Firefighters Grant $120,796 - 0
97.039 Hazard Mitigation Grant Program $108,765 - 0
21.019 Coronavirus Relief Fund $108,621 - 0
97.067 Homeland Security Grant Program $96,618 - 0
17.258 Wioa Adult Program $94,736 - 0
20.509 Covid-19- Formula Grants for Rural Areas- Rural Public Transportation $84,997 Yes 0
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $75,795 Yes 0
97.036 Disaster Grants-Public Assistance $62,530 - 0
17.259 Wioa Youth Activities $55,768 - 0
14.239 Home Investment Partnerships Program $55,453 - 0
20.507 Federal Transit_formula Grants- Mass Transit/capital Outlay $51,090 Yes 0
93.045 Title Iii, Part C- Nutrition Services $50,709 - 0
93.590 Community-Based Child Abuse Prevention Grant- Family Support Center $42,386 - 0
16.922 Equitable Sharing Program $30,943 - 0
16.575 Crime Victim Assistance $30,688 - 0
15.226 Payments in Lieu of Taxes $29,570 - 0
93.052 National Family Caregiver Support Title Iii, Part E $29,052 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $28,639 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $24,178 - 0
17.207 Employment Service/wagner-Peyser Funded Activities $22,735 - 0
93.324 State Health Insurance Assistance Program $20,122 - 0
93.052 Covid-19- National Family Caregiver Support Title Iii, Part E $18,630 - 0
45.310 State Library Program $17,429 - 0
84.181 Special Education- Grants for Infants and Families- Individuals Disabilities Education Act (idea Part C) $16,846 - 0
93.045 Covid- 19- Title Iii, Part C- Nutrition Services $16,775 - 0
20.205 Highway Planning and Construction- Bridge Projects $16,418 Yes 0
97.042 Covid-19 Emergency Management Performance Grant $15,453 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $14,299 - 0
93.044 Covid-19- Title Iii, Part B- Grants for Supportive Services and Senior Centers $10,083 - 0
84.173 Special Education- Preschool Grants- Individuals Disabilities Education Act (idea Part B 619) $10,000 - 0
93.563 Children's Justice Grants to States $8,579 - 0
93.042 Covid-19- Title Vii, Chapter 2- Long Term Care Ombudsman Services for Older Individuals $8,000 - 0
16.606 State Criminal Alien Assistance Program $7,554 - 0
14.228 Community Development Block Grant Program $7,167 - 0
93.048 Title IV and Title II- Discretionary Projects $6,988 - 0
93.053 Nutrition Services Incentive Program $5,913 - 0
17.278 Wioa Dislocated Workers $5,647 - 0
93.778 Medical Assistance Program $5,136 - 0
17.225 Unemployment Insurance $4,979 - 0
84.027 Special Education- Grant to States- Individuals Disabilities Education Act (idea Part B) $4,756 - 0
17.801 Disabled Veterans' Outreach Program $3,735 - 0
93.558 Temporary Assistance for Needy Families- Family Preservation/youth Summer Jobs $3,562 - 0
84.126 Rehabilitation Services- Dors Year Round $3,406 - 0
17.273 Temporary Labor Certification for Foreign Workers $3,040 - 0
97.042 Emergency Management Performance Grant $1,500 - 0
17.235 Senior Community Service Employment Program $1,244 - 0
80.002 Special Education- Grant to States- Individuals Disabilities Education Act (idea Part B) $1,244 - 0
84.048 Career and Technical Education- Basic Grants to States $1,244 - 0
93.071 Medicare Enrollment Assistance Program- Mippa $868 - 0
93.043 Title Iii, Part D- Disease Prevention and Health Promotion Services $835 - 0
93.044 Title Iii, Part B- Grants for Supportive Services and Senior Centers $790 - 0
17.245 Trade Adjustment Assistance $747 - 0
93.042 Title Vii, Chapter 2- Long Term Care Ombudsman Services for Older Individuals $690 - 0
93.041 Title Vii, Chapter 3- Programs for Prevention of Elder Abuse, Neglect, and Exploitation $221 - 0
16.758 Improving the Investigation and Prosecution of Child Abuse and the Regional and Local Children's Advocacy Centers $105 - 0

Contacts

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

Notes to SEFA

Title: 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 2022, 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 77%. The major programs tested are listed below.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 auditee did not use the de minimis cost rate. The accompanying Schedule includes the Federal award activity of the County under programs of the Federal government for the year ended June 30, 2022. 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: 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 2022, 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 77%. The major programs tested are listed below.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 auditee did not use the de minimis cost rate. 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 are 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, 2022 was $20,108,813. There were no draws on the loan during 2022.
Title: 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 2022, 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 77%. The major programs tested are listed below.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 auditee did not use the de minimis cost rate. Amounts reported in the accompanying Schedule do not agree with amounts reported on the Countys Annual Comprehensive Financial Report (ACFR). The reconciling items between ACFR and the Schedule are as follows: