Finding 1092012 (2023-005)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-12-18
Audit: 333283
Organization: Unity Health Care, Inc. (MD)
Auditor: Bdo USA PC

AI Summary

  • Core Issue: All 174 salary transactions charged to Federal awards lacked adequate documentation, relying on estimated allocations instead of actual work performed.
  • Impacted Requirements: Non-compliance with 2 CFR Section 200.430.8(i) and (viii) regarding the need for accurate records and internal controls for salary charges.
  • Recommended Follow-Up: Implement internal controls to track actual time spent on Federal programs, including regular time and effort reports reviewed by management.

Finding Text

Criteria: In accordance with 2 CFR Section 200.430.8(i), charges to Federal awards for salaries and wages must be based on records that reflect the actual work performed. The charges must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated, and must be incorporated into the official records of the non-Federal entity. In addition, 2 CFR Section 200.430.8(i)(viii) states that budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting, provided certain additional internal controls are implemented. Condition: During our testing of salaries and wages, we noted that all 174 sampled transactions did not have adequate supporting documentation. Charges to Federal awards for salaries and wages were based on estimated allocations, rather than use of a system of internal controls that accounts for actual time and effort allocations. Cause: While there is a time keeping system implemented to track daily hours worked by employees, the Corporation’s current internal control system does not allow for specific coding for time actually spent on each federally funded program that would support the amount charged to the Federal award. Effect or Potential Effect: We were unable to determine whether charges to Federal awards for salaries and wages reflect specific time worked or amounts allocated by employee to specific Federal programs. Allowable costs incurred by the Corporation exceeded the amount of approved grant funding, therefore no questioned costs are reported. Questioned costs: Unknown Context: We selected 174 salary transactions charged to the Federal programs to test controls over allowable costs. All transactions charged to the Federal programs were based on budgeted Full Time Equivalents (FTE), and not actual hours employees worked for each Federal program. No analysis or true-up was performed to determine the accuracy of employee titles or amounts charged versus actual time and effort incurred. This is a condition identified per review of the Corporation’s compliance with specified requirements using a statistically valid sample. Repeat finding: This is a repeat finding from prior year. This was reported as finding 2022-005 in the 2022 report. Recommendation: We recommend the Corporation develop and incorporate internal controls in order to track specific time spent on each Federal program. This can include, time and effort reports completed on a routine basis, such as monthly, and adjust program expenditures as needed to properly reflect actual work performed. Completed time and effort reports should be reviewed and verified by management for accuracy. View of Responsible Officials: Due to turnover of several key financial executives and personnel, the Corporation did not maintain evidence of approval of salary and wage allocations.

Categories

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

Other Findings in this Audit

  • 515547 2023-004
    Material Weakness Repeat
  • 515548 2023-005
    Material Weakness Repeat
  • 515549 2023-006
    Material Weakness Repeat
  • 515550 2023-007
    Significant Deficiency Repeat
  • 515551 2023-004
    Material Weakness Repeat
  • 515552 2023-005
    Material Weakness Repeat
  • 515553 2023-006
    Material Weakness Repeat
  • 515554 2023-007
    Significant Deficiency Repeat
  • 515555 2023-004
    Material Weakness Repeat
  • 515556 2023-005
    Material Weakness Repeat
  • 515557 2023-006
    Material Weakness Repeat
  • 515558 2023-009
    Significant Deficiency Repeat
  • 515559 2023-004
    Material Weakness
  • 515560 2023-007
    Significant Deficiency
  • 515561 2023-004
    Material Weakness Repeat
  • 515562 2023-005
    Material Weakness Repeat
  • 515563 2023-006
    Material Weakness Repeat
  • 515564 2023-009
    Significant Deficiency Repeat
  • 515565 2023-004
    Material Weakness Repeat
  • 515566 2023-005
    Material Weakness Repeat
  • 515567 2023-006
    Material Weakness Repeat
  • 515568 2023-009
    Significant Deficiency Repeat
  • 515569 2023-004
    Material Weakness Repeat
  • 515570 2023-005
    Material Weakness Repeat
  • 515571 2023-006
    Material Weakness Repeat
  • 515572 2023-007
    Significant Deficiency Repeat
  • 515573 2023-008
    Significant Deficiency Repeat
  • 515574 2023-009
    Significant Deficiency Repeat
  • 1091989 2023-004
    Material Weakness Repeat
  • 1091990 2023-005
    Material Weakness Repeat
  • 1091991 2023-006
    Material Weakness Repeat
  • 1091992 2023-007
    Significant Deficiency Repeat
  • 1091993 2023-004
    Material Weakness Repeat
  • 1091994 2023-005
    Material Weakness Repeat
  • 1091995 2023-006
    Material Weakness Repeat
  • 1091996 2023-007
    Significant Deficiency Repeat
  • 1091997 2023-004
    Material Weakness Repeat
  • 1091998 2023-005
    Material Weakness Repeat
  • 1091999 2023-006
    Material Weakness Repeat
  • 1092000 2023-009
    Significant Deficiency Repeat
  • 1092001 2023-004
    Material Weakness
  • 1092002 2023-007
    Significant Deficiency
  • 1092003 2023-004
    Material Weakness Repeat
  • 1092004 2023-005
    Material Weakness Repeat
  • 1092005 2023-006
    Material Weakness Repeat
  • 1092006 2023-009
    Significant Deficiency Repeat
  • 1092007 2023-004
    Material Weakness Repeat
  • 1092008 2023-005
    Material Weakness Repeat
  • 1092009 2023-006
    Material Weakness Repeat
  • 1092010 2023-009
    Significant Deficiency Repeat
  • 1092011 2023-004
    Material Weakness Repeat
  • 1092013 2023-006
    Material Weakness Repeat
  • 1092014 2023-007
    Significant Deficiency Repeat
  • 1092015 2023-008
    Significant Deficiency Repeat
  • 1092016 2023-009
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $5.29M
93.224 Community Health Centers $2.85M
93.788 Opioid Str $2.05M
93.217 Family Planning Services $1.47M
93.914 Hiv Emergency Relief Project Grants $1.34M
93.526 Fip Verification $898,419
93.527 Affordable Care Act (aca) Grants for New and Expanded Services Under the Health Center Program $862,759
93.918 Grants to Provide Outpatient Early Intervention Services with Respect to Hiv Disease $459,480
93.837 Cardiovascular Diseases Research $410,473
93.917 Hiv Care Formula Grants $409,149
93.994 Maternal and Child Health Services Block Grant to the States $328,090
93.427 Provision of Technical Assistance and Training Activities to Assure Comprehensive Cancer Control Outcomes. $113,387
93.426 The National Cardiovascular Health Program $102,468
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $102,041
93.855 Allergy and Infectious Diseases Research $7,112