Finding 504885 (2022-004)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
$1
Year
2022
Accepted
2024-11-07

AI Summary

  • Core Issue: The County lacks proper documentation for employee time and effort related to the CSLFRF program, impacting compliance with federal requirements.
  • Impacted Requirements: This affects the County's adherence to the Activities Allowed or Unallowed and Allowable Costs/Cost Principles for federally funded programs.
  • Recommended Follow-Up: Implement a timekeeping system to ensure all employees submit detailed time records for accurate salary allocation to grants and activities.

Finding Text

Material Weakness in Internal Control Over Activities, Allowed or Unallowed and Allowable Costs/Cost Principles Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is responsible for keeping an accurate accounting of all federal expenditures and maintaining all of the required documentation and reports in accordance with applicable federal regulations. Condition For AL No. 21.027, Coronavirus State and Local Fiscal Recovery Funds, a sample of employee payroll transactions were tested for Activities Allowed or Unallowed and Allowable Costs/Cost Principles. The County was not able to provide adequate supporting documentation of time and effort (e.g. timesheets or timecards) charged to the CSLFRF program. Cause The County does not have a consistent process for tracking and recording each employee’s time spent on various activities so that the portion of each employee’s salaries and wages allocated to each grant and/or activity can be calculated. Effect The County is not in compliance with the Activities Allowed or Unallowed and Allowable Costs/Cost Principles requirements of its federally funded programs. Questioned Costs See scope limitation. Repeat Finding Yes. This finding also occurred in 2020 (2020-002) and 2019 (2019-002). Recommendation We recommend that the County require that all employees submit time records that provide enough detail to allow for their salaries and wages to be allocated to grants and other activities based on actual reported time. We further recommend that these time records be maintained through a timekeeping software that has the capability of calculating such allocation percentages by employee. Views of Responsible Officials and Planned Corrective Actions See corrective action plan.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 504882 2022-004
    Material Weakness Repeat
  • 504883 2022-005
    Material Weakness Repeat
  • 504884 2022-006
    Material Weakness
  • 504886 2022-005
    Material Weakness Repeat
  • 504887 2022-006
    Material Weakness
  • 504888 2022-004
    Material Weakness Repeat
  • 504889 2022-005
    Material Weakness Repeat
  • 504890 2022-006
    Material Weakness
  • 504891 2022-004
    Material Weakness Repeat
  • 504892 2022-005
    Material Weakness Repeat
  • 504893 2022-006
    Material Weakness
  • 504894 2022-004
    Material Weakness Repeat
  • 504895 2022-005
    Material Weakness Repeat
  • 504896 2022-006
    Material Weakness
  • 504897 2022-004
    Material Weakness Repeat
  • 504898 2022-005
    Material Weakness Repeat
  • 504899 2022-006
    Material Weakness
  • 504900 2022-004
    Material Weakness Repeat
  • 504901 2022-005
    Material Weakness Repeat
  • 504902 2022-006
    Material Weakness
  • 504903 2022-004
    Material Weakness Repeat
  • 504904 2022-005
    Material Weakness Repeat
  • 504905 2022-006
    Material Weakness
  • 504906 2022-004
    Material Weakness Repeat
  • 504907 2022-005
    Material Weakness Repeat
  • 504908 2022-006
    Material Weakness
  • 504909 2022-004
    Material Weakness Repeat
  • 504910 2022-005
    Material Weakness Repeat
  • 504911 2022-006
    Material Weakness
  • 504912 2022-004
    Material Weakness Repeat
  • 504913 2022-005
    Material Weakness Repeat
  • 504914 2022-006
    Material Weakness
  • 504915 2022-004
    Material Weakness Repeat
  • 504916 2022-005
    Material Weakness Repeat
  • 504917 2022-006
    Material Weakness
  • 1081324 2022-004
    Material Weakness Repeat
  • 1081325 2022-005
    Material Weakness Repeat
  • 1081326 2022-006
    Material Weakness
  • 1081327 2022-004
    Material Weakness Repeat
  • 1081328 2022-005
    Material Weakness Repeat
  • 1081329 2022-006
    Material Weakness
  • 1081330 2022-004
    Material Weakness Repeat
  • 1081331 2022-005
    Material Weakness Repeat
  • 1081332 2022-006
    Material Weakness
  • 1081333 2022-004
    Material Weakness Repeat
  • 1081334 2022-005
    Material Weakness Repeat
  • 1081335 2022-006
    Material Weakness
  • 1081336 2022-004
    Material Weakness Repeat
  • 1081337 2022-005
    Material Weakness Repeat
  • 1081338 2022-006
    Material Weakness
  • 1081339 2022-004
    Material Weakness Repeat
  • 1081340 2022-005
    Material Weakness Repeat
  • 1081341 2022-006
    Material Weakness
  • 1081342 2022-004
    Material Weakness Repeat
  • 1081343 2022-005
    Material Weakness Repeat
  • 1081344 2022-006
    Material Weakness
  • 1081345 2022-004
    Material Weakness Repeat
  • 1081346 2022-005
    Material Weakness Repeat
  • 1081347 2022-006
    Material Weakness
  • 1081348 2022-004
    Material Weakness Repeat
  • 1081349 2022-005
    Material Weakness Repeat
  • 1081350 2022-006
    Material Weakness
  • 1081351 2022-004
    Material Weakness Repeat
  • 1081352 2022-005
    Material Weakness Repeat
  • 1081353 2022-006
    Material Weakness
  • 1081354 2022-004
    Material Weakness Repeat
  • 1081355 2022-005
    Material Weakness Repeat
  • 1081356 2022-006
    Material Weakness
  • 1081357 2022-004
    Material Weakness Repeat
  • 1081358 2022-005
    Material Weakness Repeat
  • 1081359 2022-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $499,973
20.106 Airport Improvement Program $45,000
20.205 Highway Planning and Construction $8,410
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $7,282
66.032 State Indoor Radon Grants $6,065
93.268 Immunization Cooperative Agreements $3,000
20.509 Formula Grants for Rural Areas and Tribal Transit Program $371