Finding 1172753 (2024-003)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2026-02-06

AI Summary

  • Core Issue: The Association submitted duplicate payroll costs totaling $107,668 across two invoices for reimbursement, violating federal cost principles.
  • Impacted Requirements: Costs must be necessary, reasonable, and not duplicated across federal programs as per 2 CFR 200.403.
  • Recommended Follow-up: The Association should review and improve its policies to prevent duplicate cost submissions in future invoices.

Finding Text

Finding 2024-003 – Allowable Costs Federal Agency: U.S. Department of Treasury Federal Program: Coronavirus State and Local Fiscal Recovery Funds AL Number: 21.027 Pass-through: City of Columbus Award Number: 2576-2021 Award Year: 10/18/2021 – 12/31/2026 Type of Finding: Material Weakness and Noncompliance Criteria: Per 2 CFR 200.403, Costs charged to federal awards must be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. In addition, they must not be included as a cost or used to meet cost-sharing requirements of any other federally-financed program in either the current or a prior period. Condition: The controls in place were not sufficient to ensure costs submitted for reimbursement were complete and accurate. Context: The Association included the same payroll costs to two different invoices (requests for cost reimbursement) for the ARPA Relocation subgrant passed through the City of Columbus. These two invoices were submitted and recorded as revenue in 2024 and consist of costs incurred in 2023 and 2024. The payroll costs submitted in the first invoice totaled $107,668 while the second invoice contained payroll costs of $119,120. The difference between those amounts represents additional payroll costs for one employee for pay dates between May and June 2024. Cause: The underlying cause was due to an oversight of the disbursement journal reviewer. Effect: The Association submitted a duplicate invoice for payroll expenditures that were already reimbursed. Questioned costs: $107,668 Identification of how questioned costs were computed: See explanation provided in the Context. Repeat finding: No. Recommendation: The Association should review its policies and procedures to ensure the same costs are not duplicated among different invoices submitted for cost reimbursement. Views of responsible officials: See Corrective Action Plan

Corrective Action Plan

Finding Number: 2024-003 Anticipated Completion Date: March 31, 2026 Responsible Contact Person: Brad McCain, Chief Financial Officer Planned Corrective Action: Management has reviewed and revised its reimbursement and reconciliation procedures for federal grants to prevent duplicate submission of costs. Enhanced controls include standardized invoice preparation checklists, segregation of duties between invoice preparation and review, and reconciliation of reimbursement requests to payroll registers and the general ledger prior to submission. Management will also provide targeted training to staff involved in grant billing and reimbursement processes. In coordination with the City of Columbus, the YMCA is updating and resubmitting a final report and invoice reflecting the removal of duplicated expenses and the inclusion of allowable actual expenses that had not previously been invoiced.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1172747 2024-003
    Material Weakness Repeat
  • 1172748 2024-003
    Material Weakness Repeat
  • 1172749 2024-003
    Material Weakness Repeat
  • 1172750 2024-003
    Material Weakness Repeat
  • 1172751 2024-003
    Material Weakness Repeat
  • 1172752 2024-003
    Material Weakness Repeat
  • 1172754 2024-004
    Material Weakness Repeat
  • 1172755 2024-004
    Material Weakness Repeat
  • 1172756 2024-004
    Material Weakness Repeat
  • 1172757 2024-004
    Material Weakness Repeat
  • 1172758 2024-004
    Material Weakness Repeat
  • 1172759 2024-004
    Material Weakness Repeat
  • 1172760 2024-004
    Material Weakness Repeat
  • 1172761 2024-005
    Material Weakness Repeat
  • 1172762 2024-005
    Material Weakness Repeat
  • 1172763 2024-005
    Material Weakness Repeat
  • 1172764 2024-005
    Material Weakness Repeat
  • 1172765 2024-005
    Material Weakness Repeat
  • 1172766 2024-005
    Material Weakness Repeat
  • 1172767 2024-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.600 HEAD START $4.92M
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $2.71M
84.181 SPECIAL EDUCATION-GRANTS FOR INFANTS AND FAMILIES $565,673
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $548,313
14.267 CONTINUUM OF CARE PROGRAM $342,415
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $158,743
16.575 CRIME VICTIM ASSISTANCE $82,612
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $73,141
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $47,485