Finding 397998 (2023-009)

Material Weakness
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-05-20
Audit: 306700
Auditor: Wegner CPAS

AI Summary

  • Core Issue: 8 out of 30 disbursements lacked proper documentation for review and approval, risking compliance with federal requirements.
  • Impacted Requirements: Failure to meet 2 CFR section 200.303(a) on internal controls over federal awards may lead to undetected noncompliance.
  • Recommended Follow-up: Implement additional procedures for reviewing allowable costs and modify accounting systems to ensure segregation of duties and monthly reviews of journal entries.

Finding Text

Assistance Listing Number(s): 21.027 Name of Federal Program or Cluster: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Name of Federal Agency: Department of the Treasury Name of Pass-through Entity: City of Madison, City of Sun Prairie, Wisconsin Department of Workforce Development Award Period: January 1, 2022 through December 31, 2022; September 22, 2021 through December 31, 2024; June 20, 2022 through June 30, 2025 Criteria or Specific Requirement: 2 CFR section 200.303(a) requires a non-federal entity to establish and maintain effective internal control over federal awards that provides reasonable assurance that the nonfederal entity is managing federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition: 8 out of 30 disbursements charged to the federal award were not documented as reviewed and approved. 3 of the 8 were modified or entered by journal entry and reviewed by the same individual. 5 out of 8 were the result of the accounts payable bills module not configured to set up controls to review and approve transactions. Cause: Edits and journal entries by accounting personnel were not subject to review. The accounts payable bills module was not configured for a review and approval process. Effect or Potential Effect: Noncompliance with federal statutes, regulations, and the terms and conditions of the federal award may not be prevented or detected and corrected. Questioned Costs: None. Context: 30 disbursement items out of 149 were tested. Repeat Finding: No. Recommendation: Additional procedures should be designed, implemented, and documented for allowable costs to ensure documentation of review and approval of allowable costs to be charged to the federal award. The accounting system configurations should be modified to require segregation of duties for all transactions. For journal entries, a documented review and approval should be performed by a finance committee member on a monthly basis. Views of Responsible Officials: Boys and Girls Club of Dane County, Inc. agrees with the finding and is implementing a review process over accounts payable and journal entries.

Categories

Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties Subrecipient Monitoring Allowable Costs / Cost Principles

Other Findings in this Audit

  • 397982 2023-005
    Material Weakness
  • 397983 2023-006
    Material Weakness
  • 397984 2023-007
    Material Weakness
  • 397985 2023-008
    Material Weakness
  • 397986 2023-009
    Material Weakness
  • 397987 2023-010
    Significant Deficiency
  • 397988 2023-005
    Material Weakness
  • 397989 2023-006
    Material Weakness
  • 397990 2023-007
    Material Weakness
  • 397991 2023-008
    Material Weakness
  • 397992 2023-009
    Material Weakness
  • 397993 2023-010
    Significant Deficiency
  • 397994 2023-005
    Material Weakness
  • 397995 2023-006
    Material Weakness
  • 397996 2023-007
    Material Weakness
  • 397997 2023-008
    Material Weakness
  • 397999 2023-010
    Significant Deficiency
  • 974424 2023-005
    Material Weakness
  • 974425 2023-006
    Material Weakness
  • 974426 2023-007
    Material Weakness
  • 974427 2023-008
    Material Weakness
  • 974428 2023-009
    Material Weakness
  • 974429 2023-010
    Significant Deficiency
  • 974430 2023-005
    Material Weakness
  • 974431 2023-006
    Material Weakness
  • 974432 2023-007
    Material Weakness
  • 974433 2023-008
    Material Weakness
  • 974434 2023-009
    Material Weakness
  • 974435 2023-010
    Significant Deficiency
  • 974436 2023-005
    Material Weakness
  • 974437 2023-006
    Material Weakness
  • 974438 2023-007
    Material Weakness
  • 974439 2023-008
    Material Weakness
  • 974440 2023-009
    Material Weakness
  • 974441 2023-010
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $798,720
93.558 Temporary Assistance for Needy Families $91,755
17.261 Wia Pilots, Demonstrations, and Research Projects $68,787
84.425 Education Stabilization Fund $29,384
94.006 Americorps $26,125
14.218 Community Development Block Grants/entitlement Grants $18,750
93.268 Immunization Cooperative Agreements $10,954
16.726 Juvenile Mentoring Program $5,901