Finding 25949 (2022-002)

-
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2022-11-28
Audit: 23636
Organization: Carroll County Commissioners (MD)
Auditor: Cohnreznick LLP

AI Summary

  • Core Issue: The County misreported grant revenue for fee-for-service grants due to inadequate internal controls.
  • Impacted Requirements: Financial reporting standards require timely detection and correction of material misstatements.
  • Recommended Follow-Up: Update grant procedures, implement a formal review process, and train staff to ensure accurate revenue recognition moving forward.

Finding Text

Condition: During the course of our audit we noted a material misstatement in the County?s recognition of grant revenue related to fee-for-service grants in the grant fund, a major governmental fund. Criteria: Internal controls over financial reporting should exist to ensure that material misstatements are detected and corrected by management in a timely manner. Effect or Potential Effect: Management may produce financial statements that are materially misstated. Cause: Management did not have controls over financial reporting specifically related to the recognition of revenue for fee-for-service grants. Recommendation: We recommend that the County update its formal documentation surrounding its procedures pertaining to grants. The policies and procedures should include a formal review process by a designated finance department employee with the proper subject matter expertise to help overcome the fact that grant administration is decentralized at the County. The process should include documentation of the procedures that are put in place so that the review can be reperformed. Views of Responsible Official(s) and Planned Corrective Actions: The Accounting office will take the lead in documenting the requirements of recognizing grant revenue related to fee-for-service grants to ensure the revenue is properly recorded. Revenue recognition is a generally accepted account principle (GAAP) that requires revenue to be recognized in the period when realized and earned. Accounting will work with the Grant Management Office, Budget Office, as well as various Grant Administrators to review and update our formal documentation: Carroll County Guide to Grants. Once updated in FY23 ? quarter three (3), we will train staff with fiscal responsibilities of managing and recording revenue and expenses to these grants. This topic will also be added to our FY23 current quarterly / monthly grant meeting with various departments. In addition, Accounting will review the internal controls for booking these entries into our Financial Management System (FMS) so that we have designed employees with the expertise to complete a formal review of revenue earned and unearned to ensure the financial data is properly recorded in the books and records of the County to prevent misstatements from occurring in FY23 and future fiscal years.

Corrective Action Plan

a. Comments on the Finding and Each Recommendation Management agrees with the finding and concurs with the recommendation. b. Action(s) Taken or Planned on the Finding The Accounting office will take the lead in documenting the requirements of recognizing grant revenue related to fee-for-service grants to ensure the revenue is properly recorded. Revenue recognition is a generally accepted accounting principle (GAAP) that requires revenue to be recognized in the period when realized and earned. Accounting will work with the Grant Management Office, Budget Office, as well as various Grant Administrators to review and update our formal documentation: Carroll County Guide to Grants. Once updated in FY23 - quarter three (3), we will train staff with the fiscal responsibilities of managing and recording revenue and expenses to these grants. This topic will also be added to our FY23 current quarterly / monthly grant meetings with various departments. In addition, Accounting will review the internal controls for booking these entries into our Financial Management System (FMS) so that we have designated employees with the expertise to complete a formal review of revenue earned and unearned to ensure the financial data is properly recorded in the books and records of the County to prevent misstatements from occurring in FY23 and future fiscal years.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
14.871 Section 8 Housing Choice Vouchers $6.08M
21.023 Emergency Rental Assistance Program $2.13M
20.507 Federal Transit_formula Grants $1.74M
14.228 Community Development Block Grants/state's Program $785,464
14.879 Mainstream Vouchers $753,675
20.205 Highway Planning and Construction $564,854
21.027 Coronavirus State and Local Fiscal Recovery Funds $548,367
14.231 Emergency Solutions Grant Program $480,712
17.278 Wioa Dislocated Worker Formula Grants $442,395
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $441,114
93.558 Temporary Assistance for Needy Families $394,306
97.067 Homeland Security Grant Program $376,264
20.106 Airport Improvement Program $367,798
17.259 Wioa Youth Activities $304,508
17.258 Wioa Adult Program $234,498
16.034 Coronavirus Emergency Supplemental Funding Program $222,056
21.019 Coronavirus Relief Fund $218,987
20.509 Formula Grants for Rural Areas and Tribal Transit Program $208,054
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $184,785
93.563 Child Support Enforcement $140,314
93.556 Promoting Safe and Stable Families $125,824
97.042 Emergency Management Performance Grants $125,725
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $118,174
93.778 Medical Assistance Program $102,997
16.738 Edward Byrne Memorial Justice Assistance Grant Program $84,976
95.001 High Intensity Drug Trafficking Areas Program $81,955
93.052 National Family Caregiver Support, Title Iii, Part E $80,559
10.916 Watershed Rehabilitation Program $63,174
14.896 Family Self-Sufficiency Program $61,922
16.588 Violence Against Women Formula Grants $55,482
84.126 Rehabilitation Services_vocational Rehabilitation Grants to States $37,273
16.922 Equitable Sharing Program $30,495
93.053 Nutrition Services Incentive Program $26,189
14.241 Housing Opportunities for Persons with Aids $25,319
93.324 State Health Insurance Assistance Program $23,491
66.466 Chesapeake Bay Program $21,793
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $21,700
14.267 Continuum of Care Program $16,307
20.616 National Priority Safety Programs $15,402
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $14,982
64.044 Vha Home Care $12,683
20.218 National Motor Carrier Safety $12,038
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $10,354
16.111 Joint Law Enforcement Operations $8,311
16.992 Federal Asset Forfeiture Grant $8,035
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $7,557
93.048 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $6,011
93.499 Low Income Household Water Assistance Program $5,809
93.071 Medicare Enrollment Assistance Program $4,732
20.600 State and Community Highway Safety $3,269
21.016 Equitable Sharing $3,142
93.041 Special Programs for the Aging_title Vii, Chapter 3_programs for Prevention of Elder Abuse, Neglect, and Exploitation $2,728
16.758 Improving the Investigation and Prosecution of Child Abuse and the Regional and Local Children's Advocacy Centers $187
16.575 Crime Victim Assistance $-1