Finding 34669 (2022-003)

-
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-07-16
Audit: 34598
Organization: Boys & Girls Clubs in Tennessee (TN)
Auditor: Bdo USA P A

AI Summary

  • Core Issue: The SEFA was incomplete, missing a federal grant with expenditures for the year.
  • Impacted Requirements: Compliance with 2 CFR 200.502 for reporting total Federal awards and ensuring all necessary details are included.
  • Recommended Follow-Up: Improve procedures and internal controls for SEFA preparation, including a thorough comparison with the general ledger.

Finding Text

Program Information: The Tennessee COVID-19 Health Disparities Initiative (ALN #93.391) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting- The auditee must prepare a schedule of expenditures of Federal awards (the ?SEFA?) for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (?R&D?), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year. Cause: Administrative oversight with respect to preparation of the SEFA. Effect or Potential Effect: The original draft SEFA was incomplete. Questioned Costs: None. Context: The original draft SEFA was incomplete. Identification as a Repeat Finding: No similar findings noted in the prior year. Recommendation: We recommend that the Organization enhance its procedures and internal controls with respect to preparation and review of the SEFA including a comparison of the general ledger to the SEFA to assess completeness. Views of Responsible Officials and Planned Corrective Actions: Management will review grant agreements to confirm whether funding received from private entities are federal funds that should be reported on the SEFA.

Corrective Action Plan

Name of Responsible Individual(s): Jason Penegar, BGCA Vice President ? Controller Shelby Mahoney, Accounting Manager - State Alliances Corrective Action: Management will review grant agreements to confirm whether funding received from private entities are federal funds that should be reported on the SEFA. Anticipated Completion Date: December 31, 2023

Categories

Reporting Subrecipient Monitoring Internal Control / Segregation of Duties

Other Findings in this Audit

  • 34667 2022-002
    Significant Deficiency
  • 34668 2022-002
    Significant Deficiency
  • 611109 2022-002
    Significant Deficiency
  • 611110 2022-002
    Significant Deficiency
  • 611111 2022-003
    -

Programs in Audit

ALN Program Name Expenditures
84.287 Twenty-First Century Community Learning Centers $295,533
93.558 Temporary Assistance for Needy Families $237,814
93.235 Title V State Sexual Risk Avoidance Education Program $80,509
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $57,756
93.590 Community-Based Child Abuse Prevention Grants $24,819