Finding 401010 (2022-003)

Significant Deficiency Repeat Finding
Requirement
CL
Questioned Costs
-
Year
2022
Accepted
2024-06-17
Audit: 309064

AI Summary

  • Core Issue: Discrepancies between federal cash requests and actual disbursements due to misallocation of funds related to COVID-19 funding.
  • Impacted Requirements: Compliance with 2 CFR section 200.305(b) on minimizing time between fund receipt and disbursement.
  • Recommended Follow-Up: Ensure accurate recording of disbursements and align fund requests with actual expenditures in the job-costing system.

Finding Text

U.S. Department of Health and Human Services 2022-003 Cash Management/Reporting Program(s) Name of Federal Program (Assistance Listing Number) Urban Indian Health Services (93.193) Special Diabetes Program for Indians - Diabetes Prevention and Treatment Projects (93.237) Criteria - Recipients of federal awards must minimize the time elapsing between the receipt of funds from the U.S. Treasury and disbursement by the Organization set out at 2 CFR section 200.305(b). Context and Condition - We compared two quarterly Federal Cash Transaction Reports to total disbursements reported by these two programs in the Organization’s job-costing system. In both reports we found that the amounts requested did not match the amounts in the job-costing system. Cause - Due to increased funding the Organization received to address the impact of COVID-19, disbursements were not always correctly assigned to a program when incurred. Requests for federal funds were made based on those incomplete reports that were changed subsequently and no longer represent the amounts requested. The original reports were not maintained to support the requests made. Effect - A federal program could disburse funds prior to the disbursement by the Organization. We identified that both programs had requested funds in excess of disbursements. Questioned Costs - No costs were questioned. Repeat finding - Yes Statistically valid - Yes Recommendation - We recommend the Organization 1) maintains timely and accurate recording of disbursements in its job-costing system and 2) regularly request grant funds based on amounts expended as report in the Organization’s job-costing system. Views of responsible officials - The Organization is implementing a grant tracking system in addition to its job-costing system to better comply with these requirements. Together, these systems will be used to request only the amount attributable to the program for reimbursement.

Corrective Action Plan

Criteria: Recipients of federal awards must minimize the time elapsing between the receipt of funds from the U.S. Treasury and disbursement by the Organization set out at 2 CFR section 200.305(b). Audit Recommendation: We recommend that the Organization 1) maintains timely and accurate recording of disbursements in its job‐costing system and 2) regularly request grant funds based on amounts expended as report in the Organization’s job‐costing system. Auditee Response: The Organization is implementing a grant tracking system in addition to its job costing system to better comply with these requirements. Together, these systems will be used to request only the amount attributable to the program for reimbursement. Corrective Action Plan: (1) Records will be kept in a newly developed spend down report for each grant/contract and reviewed with Division Directors and DFO monthly. All transactions are now being logged in QuickBooks with respective grant codes and departments, will not be processed without. (2) Monthly and quarterly invoicing according to each grant / contract agreement will be enforced by the GDCM and DFO in compliance with 2 CFR section 200.305(b). (3) The Organization has enrolled with the Treasury’s Invoice Processing Platform (IPP) to ensure all future Invoicing and payments can be easily tracked to the program/grant. Person Responsible: Matt Poss, Director of Finance Operations Timeline: All expenses and disbursements being coded to proper Grant/Type in QuickBooks Online – January 2023 Treasury Invoice Processing Platform (IPP) Onboarded – April 18th, 2023 Invoicing Timeline Created per collaboration with GDCM and DFO – May 18th, 2023 Revenue Reconciliation and clearing out of uncollectible or overbooked revenue – June 30th, 2023

Categories

Cash Management Reporting

Other Findings in this Audit

  • 401009 2022-002
    Significant Deficiency
  • 401011 2022-002
    Significant Deficiency
  • 401012 2022-003
    Significant Deficiency Repeat
  • 977451 2022-002
    Significant Deficiency
  • 977452 2022-003
    Significant Deficiency Repeat
  • 977453 2022-002
    Significant Deficiency
  • 977454 2022-003
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
93.193 Urban Indian Health Services $318,559
93.237 Special Diabetes Program for Indians_diabetes Prevention and Treatment Projects $231,426
93.479 Good Health and Wellness in Indian Country (a) $178,278
93.310 Trans-Nih Research Support $173,442
93.665 Emergency Grants to Address Mental and Substance Use Disorders During Covid-19 $78,931
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $77,880
93.092 Affordable Care Act (aca) Personal Responsibility Education Program $34,752
21.019 Coronavirus Relief Fund $28,402
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $18,116