Finding 570574 (2024-003)

Significant Deficiency
Requirement
B
Questioned Costs
$1
Year
2024
Accepted
2025-07-07
Audit: 361592
Organization: YWCA Madison, Inc. (WI)
Auditor: Wegner CPAS LLP

AI Summary

  • Core Issue: Depreciation expense was incorrectly charged to a federally funded program for a vehicle fully funded in a prior year.
  • Impacted Requirements: This violates 2 CFR §200.436(b)(1) regarding unallowable costs and 2 CFR §200.403 on allowable expenses.
  • Recommended Follow-Up: Management should implement a review process to ensure federally funded assets are excluded from future depreciation calculations.

Finding Text

Assistance Listing Number(s): 20.509 Name of Federal Program or Cluster: Formula Grants for Rural Areas and Tribal Transit Program Name of Federal Agency: Department of Transportation Federal Award Identification Number: CY2024 WETAP Federal Award Year: January 1, 2024 through December 31, 2024 Criteria: According to 2 CFR §200.436(b)(1), “The depreciation cost is not allowable for equipment that was paid for by the Federal Government either directly or through a non-federal entity's federal award.” Additionally, costs charged to a federal award must be allowable, allocable, and reasonable per 2 CFR §200.403. Condition: During the preliminary review of expenditures charged to federal programs, it was noted that depreciation expense was recorded for a vehicle that had been 100% federally funded in a prior year. The depreciation was charged to the major federal program in the current fiscal year. Cause: The depreciation was charged due to a lack of review procedures to ensure that federally funded assets are excluded from depreciation calculations allocated to federal awards. Effect or Potential Effect and Questioned Costs: As a result, unallowable costs were charged to the federal program, which may result in questioned costs and potential repayment to the federal agency, as well as noncompliance with federal cost principles. Context: The error was not a part of our sample. It was discovered as a year-end journal entry. Repeat Finding: No Recommendation: Management should conduct a review of depreciation charges for the current and future years to ensure that federally funded assets are excluded from depreciation allocations to federal programs.

Corrective Action Plan

YWCA Madison, Inc. respectfully submits the following corrective action plan for the year ended December 31, 2024. Name and address of independent public accounting firm: Wegner CPAs 2921 Landmark Place Suite 300 Madison, Wisconsin 53713 Audit period: January 1, 2024 – December 31, 2024 The findings from the December 31, 2024 schedule of findings and questioned costs are discussed below. The findings are numbered consistently with the numbers assigned in the schedule. FINANCIAL STATEMENT FINDINGS SIGNIFICANT DEFICIENCY 2024-001 Recommendation: Management should implement procedures to ensure continuity of key financial controls during periods of personnel transition. This includes assigning interim reviewers, establishing clear handover protocols, and enforcing timely documentation of reviews to maintain financial oversight. Action Taken: Under the leadership of our new fractional CFO and outsourced accounting firm, we have implemented an accounting close and financial reporting management system using ClickUp. Each task impacting key financial controls now has both a designated preparer and reviewer. The system automatically tracks and displays the completion status of each control. Further review of financial schedules is documented through Google Drive approvals. Transitioning from manual to system-driven documentation ensures that, during staffing changes, task reassignments are more visible to all responsible team members. It is important to note that, due to capacity constraints during the transition, immediate reassignment of responsibilities was not feasible. However, once new team members were onboarded, a cumulative review of the period was conducted to ensure the completeness and accuracy of the financial information—ultimately reflected in an unmodified financial audit opinion. MATERIAL WEAKNESS 2024-002 Recommendation: Assign clear responsibility for maintaining and reviewing the monitoring checklist. Management should establish a recurring schedule (e.g., monthly or quarterly) for checklist reviews and ensure the results are documented and retained for accountability and audit purposes. Action Taken: The new fractional CFO, Grants & Compliance Director, and CEO have revised the monitoring checklist to separate financial and compliance controls, as these operate on different schedules. Financial controls have been integrated into the financial management project system in ClickUp. Compliance controls will be maintained within the grant management system and embedded into the grant management and reporting processes. FEDERAL AWARD FINDINGS DEPARTMENT OF TRANSPORTATION STATE OF WISCONSIN DEPARTMENT OF TRANSPORTATION 2024-003 Formula Grants for Rural Areas and Tribal Transit Program — Assistance Listing No. 20.509 Recommendation: Management should conduct a review of depreciation charges for the current and future years to ensure that federally funded assets are excluded from depreciation allocations to federal programs. Action Taken: We have added a new depreciation expense account to distinguish between allowable and non-allowable depreciation expenses in grant expenditure allocations. If there are questions regarding this plan, please call Tania Ibarra, CPA, at 608.347.6747. Sincerely, Geraldine Paredes Vásquez CEO gpvasquez@ywcamadison.org

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1147016 2024-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.509 Formula Grants for Rural Areas and Tribal Transit Program $353,725
93.767 Children's Health Insurance Program $158,891
21.023 Emergency Rental Assistance Program $100,000
20.521 New Freedom Program $78,767
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $67,553
21.027 Coronavirus State and Local Fiscal Recovery Funds $56,147
14.218 Community Development Block Grants/entitlement Grants $39,408
93.558 Temporary Assistance for Needy Families $32,192
14.231 Emergency Solutions Grant Program $25,000
97.024 Emergency Food and Shelter National Board Program $15,000