Finding 1172767 (2024-005)

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

AI Summary

  • Core Issue: The Association failed to verify if costs in the financial system matched reimbursement invoices, raising questions about compliance with the period of performance.
  • Impacted Requirements: Noncompliance with 2 CFR 200.403(h) and 2 CFR 200.302 regarding cost tracking and record-keeping for federal funds.
  • Recommended Follow-Up: The Association should enhance its policies to ensure financial records can be reconciled with invoices and the Schedule of Expenditures of Federal Awards.

Finding Text

Finding 2024-005 – Period of Performance Federal Agency: U.S. Department of Treasury Federal Program: Coronavirus State and Local Fiscal Recovery Funds AL Number: 21.027 Pass-through: Community Shelter Board Award Number: YMCA-24-CSB and YMCA-25-CSB Award Year: 7/1/2023 – 6/30/2024 and 7/1/2024 – 6/30/2025 Type of Finding: Material Weakness and Noncompliance Criteria: 2 CFR 200.403(h): Administrative closeout costs may be incurred until the due date of the final report(s). If incurred, these costs must be liquidated prior to the due date of the final report(s) and charged to the final budget period of the award unless otherwise specified by the Federal agency. All other costs must be incurred during the approved budget period. 2 CFR 200.302: The recipient's and subrecipient's financial management system must provide for the following: Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. Condition: The Association was unable to verify whether costs recorded in the financial accounting system were included in invoices submitted for cost reimbursement. As such, auditors could not verify whether these costs were included in the appropriate period of performance. Context: Out of a sample of 40 transactions tested for compliance with period of performance requirements, 27 of them could not be traced to a reimbursement invoice. Most of these transactions were transfers of payroll costs from one program to another. Cause: The Association did not have a strong process to track program expenses with the financial accounting system and did not effectively reconcile expenditures between the general ledger and the Schedule of Expenditures of Federal Awards. In addition, the Association did not maintain support for expenditures charged to federal grants to be able to support whether they were within the allowable period of performance. Effect: The Association could not provide evidence of whether the transactions tested were within the period of performance. Questioned costs: $602,142 Identification of how questioned costs were computed: Known questioned costs were computed by summing the dollar amount of selections that were identified as errors which totaled $6,829. An error rate was calculated by taking the number of errors divided by the total sample size as described in the Context section. This error rate was then applied to the untested population to calculate projected questioned costs of $595,313. Repeat finding: Not applicable. Recommendation: The Association should review its policies and procedures to ensure costs recorded in the financial accounting system are able to be reconciled to invoices submitted for cost reimbursement as well as the Schedule of Expenditures of Federal Awards. Views of responsible officials: See Corrective Action Plan.

Corrective Action Plan

Finding Number: 2024-005 Anticipated Completion Date: March 31, 2026 Responsible Contact Person: Brad McCain, Chief Financial Officer Planned Corrective Action: Management is strengthening controls over tracking, documenting, and reconciling federal grant expenditures to ensure compliance with period of performance requirements. Actions include implementing improved grant-level tracking within the financial system, reconciling general ledger activity to reimbursement invoices and the SEFA on a routine basis, and retaining documentation to support the allowability and timing of costs charged to federal programs. Management will also formalize procedures for payroll reallocations across programs to ensure traceability and compliance with grant requirements. Documentation will be required to be attached to all journal transactions demonstrating the linkage between the underlying payroll records to the correct grant programs.

Categories

Allowable Costs / Cost Principles Subrecipient Monitoring Cash Management Material Weakness Period of Performance Reporting

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
  • 1172753 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

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