Finding 391446 (2023-002)

-
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-04-01

AI Summary

  • Core Issue: The Board's records for personnel expenses did not meet the requirements of 2 CFR section 200.430 (i), specifically regarding salary allocation and documentation.
  • Impacted Requirements: The lack of proper documentation for salary distribution among activities and reliance on budget estimates without adequate internal controls led to non-compliance.
  • Recommended Follow-Up: The Board should establish procedures to ensure personnel cost allocations are supported by accurate internal data tracking.

Finding Text

Criteria: The requirements for documentation of personnel expenses are contained in 2 CFR section 200.430 (i). Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. The records must meet certain identified guidelines within 2 CFR section 200.430 (i). Condition: Board records did not comply with 2 CFR section 200.430 (i) (vii) or (viii) which is detailed below: (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim charges made to a Federal award based on budget estimates. All necessary adjustment must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.Cause/Effect: The Board did not have records that complied with guidelines for entries that moved salary costs totaling $175,585 to this program. Additionally, the Board did not have a system in place that provided support for the allocation that was used for certain employee personnel costs during the year. Auditor's Recommendation: The Board should implement procedures so that the allocation of personnel costs is supported by data that has been tracked internally. Management Response: The Board agrees with this recommendation and will review internal procedures relating to data that will support the allocation of personnel costs.

Categories

Questioned Costs Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
93.926 Healthy Start Initiative $1.31M
93.940 Hiv Prevention Activities_health Department Based $1.16M
93.268 Immunization Cooperative Agreements $867,954
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $858,313
93.558 Temporary Assistance for Needy Families $809,051
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $230,413
84.181 Special Education-Grants for Infants and Families $184,338
93.495 Community Health Workers for Public Health Response and Resilient $146,790
93.069 Public Health Emergency Preparedness $107,859
93.889 National Bioterrorism Hospital Preparedness Program $104,981
93.136 Injury Prevention and Control Research and State and Community Based Programs $100,209
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $73,000
93.994 Maternal and Child Health Services Block Grant to the States $68,547
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $45,995
93.387 National and State Tobacco Control Program (b) $34,887
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $26,000
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $25,000
93.166 Tuberculosis Elimination & Labratory Cooperative Agreement $17,493
93.991 Preventive Health and Health Services Block Grant $7,336