Finding 620369 (2022-005)

Significant Deficiency
Requirement
AB
Questioned Costs
$1
Year
2022
Accepted
2023-09-18
Audit: 51738
Organization: County of Dane (WI)

AI Summary

  • Core Issue: Incorrect payroll information led to overcharging federal awards, specifically for Child Support Enforcement.
  • Impacted Requirements: Internal controls must ensure accurate reviews of payroll expenses as per 2 CFR section 200.430(i)(1)(viii)(C).
  • Recommended Follow-Up: Implement a review process for payroll calculations to ensure accuracy before submitting reimbursement requests.

Finding Text

Finding 2022-005 Assistance Listing and State ID Numbers: 93.563 and 437.7502 Program Titles: Child Support Enforcement and CS State GPR/PR Funding Allocation Award Number / Year: 437.7502 / 2022 Pass-Through Entity: Wisconsin Department of Children and Families Criteria: 2 CFR section 200.430(i)(1)(viii)(C) requires the system of internal controls to include processes to conduct after-the-fact reviews of interim charges made to federal awards based on budget estimates used to charge salaries and wages. All necessary adjustments must be made such that the final amount charged to the federal award is accurate, allowable, and properly allocated. Condition/Context: One of the thirty-seven payroll transactions tested was more than actual costs incurred due to incorrect payroll information being used to calculate the payroll expense. Our sample was not statistically valid. Cause: The payroll cost allocation spreadsheet was not properly reviewed against the payroll system. Effect: Payroll costs were overcharged to the award. Questioned Costs: Questioned costs of $269 related to excess payroll charges are reported in accordance with the thresholds of the Wisconsin State Single Audit Guidelines and relate to expenditures funded by both federal and state sources, specifically 93.563 Child Support Enforcement and 437.7502 CS State GPR/PR Funding Allocation. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes over payroll information used to calculate amounts claimed for grant reimbursement. Management's Response: The reimbursement reports prepared by the Clerk of Courts will be reviewed by a person other than the preparer to ensure accuracy. The review will be completed before the reimbursement request is submitted to Child Support.

Categories

Questioned Costs Subrecipient Monitoring Allowable Costs / Cost Principles Cash Management Internal Control / Segregation of Duties

Other Findings in this Audit

  • 43926 2022-002
    Significant Deficiency
  • 43927 2022-005
    Significant Deficiency
  • 620368 2022-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.023 Emergency Rental Assistance Program $22.55M
93.778 Medical Assistance Program $14.33M
20.106 Airport Improvement Program $7.07M
93.563 Child Support Enforcement $6.83M
21.027 Coronavirus State and Local Fiscal Recovery Funds $5.16M
93.658 Foster Care_title IV-E $4.23M
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $3.95M
93.667 Social Services Block Grant $1.52M
93.575 Child Care and Development Block Grant $1.51M
93.558 Temporary Assistance for Needy Families $1.47M
93.959 Block Grants for Prevention and Treatment of Substance Abuse $1.23M
14.267 Continuum of Care Program $1.14M
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $620,946
93.958 Block Grants for Community Mental Health Services $497,602
84.181 Special Education-Grants for Infants and Families $399,812
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $387,548
97.042 Emergency Management Performance Grants $373,492
93.659 Adoption Assistance $362,398
93.090 Guardianship Assistance $330,687
93.645 Stephanie Tubbs Jones Child Welfare Services Program $294,256
94.006 Americorps $287,339
93.052 National Family Caregiver Support, Title Iii, Part E $282,455
14.239 Home Investment Partnerships Program $256,401
93.788 Opioid Str $222,585
93.053 Nutrition Services Incentive Program $168,557
93.498 Provider Relief Fund $165,884
95.001 High Intensity Drug Trafficking Areas Program $150,000
14.218 Community Development Block Grants/entitlement Grants $131,760
20.616 National Priority Safety Programs $125,715
16.593 Residential Substance Abuse Treatment for State Prisoners $113,398
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $98,617
93.556 Promoting Safe and Stable Families $95,172
16.588 Violence Against Women Formula Grants $90,105
81.086 Conservation Research and Development $84,941
16.575 Crime Victim Assistance $82,144
93.767 Children's Health Insurance Program $76,368
20.600 State and Community Highway Safety $71,642
16.838 Comprehensive Opioid Abuse Site-Based Program $53,677
21.032 Latcf Arp Grant $50,000
93.324 State Health Insurance Assistance Program $39,716
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $39,136
16.554 National Criminal History Improvement Program (nchip) $37,704
97.039 Hazard Mitigation Grant $31,454
93.071 Medicare Enrollment Assistance Program $28,657
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $24,959
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $17,537
16.609 Project Safe Neighborhoods $16,911
93.242 Mental Health Research Grants $15,000
21.016 Equitable Sharing $10,894
15.631 Partners for Fish and Wildlife $10,050
97.067 Homeland Security Grant Program $9,894
16.710 Public Safety Partnership and Community Policing Grants $6,780
16.738 Edward Byrne Memorial Justice Assistance Grant Program $6,675
10.069 Conservation Reserve Program $3,388
93.747 Elder Abuse Prevention Interventions Program $950
10.GSA_MIGRATION Building Sustainable Relationships $800