Finding 508002 (2019-008)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2019
Accepted
2024-11-14

AI Summary

  • Core Issue: CHCC failed to maintain proper documentation for expenditures, leading to questioned costs of $452,311 and noncompliance with federal cost principles.
  • Impacted Requirements: Lack of necessary records for payments, travel, and payroll, as well as exceeding grant funding limits without proper documentation.
  • Recommended Follow-Up: Implement a robust recordkeeping system to ensure all transactions are documented and substantiated before approval.

Finding Text

Finding No.: 2019-008 Federal Agency: U.S. Department of Health and Human Services CFDA Program: 93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance Award Number: 5H79SM062879-02 and 6U79SP020710-04M001 Area: Allowable Costs/Cost Principles Questioned Costs: $452,311 Criteria: In accordance with 2 CFR Part 200, Subpart E, cost must be necessary and reasonable for the performance of the federal award and be allocable thereto. Further costs must conform to any limitations or exclusions and be adequately documented. Condition: Of sixty non-payroll expenditures tested, aggregating $88,128 of a total population of $1,284,340, the following deficiencies were noted: 1. For twenty (or 33%), payments comprised of various invoices for which payment details were not provided. Accordingly, CHCC was not able to substantiate payments made for the following expenditures agreed to the invoice amounts. Finding No.: 2019-008, continued Federal Agency: U.S. Department of Health and Human Services CFDA Program: 93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance Award Number: 5H79SM062879-02 and 6U79SP020710-04M001 Area: Allowable Costs/Cost Principles Questioned Costs: $452,311 Condition, continued: 2. For ten (or 17%), either the trip reports, travel vouchers, boarding passes and/or documentations supporting travel cash advances and perdiem calculations were not provided. 3. For nineteen (or 32%), check payments were not provided. Finding No.: 2019-008, continued Federal Agency: U.S. Department of Health and Human Services CFDA Program: 93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance Award Number: 5H79SM062879-02 and 6U79SP020710-04M001 Area: Allowable Costs/Cost Principles Questioned Costs: $452,311 Condition, continued: 4. For two (or 3%), invoices were not provided. No questioned costs are presented as amounts are questioned at Condition 3. Finding No.: 2019-008, continued Federal Agency: U.S. Department of Health and Human Services CFDA Program: 93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance Award Number: 5H79SM062879-02 and 6U79SP020710-04M001 Area: Allowable Costs/Cost Principles Questioned Costs: $452,311 Condition, continued: Of twenty-five payroll expenditures tested, aggregating $33,121 of a total population of $686,242, the following deficiency was noted. 5. For one (or 4%), payperiod ended 04/13/19 payroll register substantiating the payroll cost of $349 for Employee No. 403867 (Business Unit H9243B) was not provided, for which the amount is questioned. Test of grant awards noted the following: 6. Cumulative expenditures of $1,144,077 exceeded the grant award’s funding limit of $718,339 for Business Unit H9243B, resulting in an excess amount of $425,738. Documentation of any increase in funding limit was not provided, for which the excess amount of $425,738 is questioned. Cause: CHCC did not enforce recordkeeping controls in accordance with applicable allowable costs/cost principles requirements. Effect: CHCC is in noncompliance with allowable costs/cost principles requirements and questioned costs of $$452,311 result. Identification as a Repeat Finding: Finding No. 2018-015. Finding No.: 2019-008, continued Federal Agency: U.S. Department of Health and Human Services CFDA Program: 93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance Award Number: 5H79SM062879-02 and 6U79SP020710-04M001 Area: Allowable Costs/Cost Principles Questioned Costs: $452,311 Recommendation: The responsible personnel should establish a recordkeeping system whereby underlying support for each transaction is processed timely and filed accordingly for easy retrieval to substantiate costs. The responsible personnel should not approve program expenditures unless underlying support is provided for review. Views of Responsible Officials: CHCC’s Corrective Action Plan provides a detailed rationale for disagreement with the finding described in Conditions 1 to 6. Auditor Response: Condition 1 - Payment vouchers were not provided. Condition 2 - Underlying travel documentations were not provided. Condition 3 - Cancelled checks were not provided. Condition 4 - Of the $25,000 for Document Number 1452571, $2,079 was not supported with an invoice. In addition, the invoice for Document 1479633 was not provided. Condition 5 - The payroll register provided for PPE 04/13/19 did not reflect the employee’s payroll costs. Condition 6 - Grant awards provided only equates to $718,339. Grant award documentation of the increase in funding limit was not provided. In addition, initial draft reports were provided to CHCC on 09/06/24 and 09/24/24. It was also agreed during the 09/06/24 and 10/04/24 meetings for CHCC to provide corresponding underlying accounting records to resolve the finding; however, no documentations were provided within the agreed timeline. Accordingly, finding is sustained.

Corrective Action Plan

Finding No.: 2019-008 Federal Agency: U.S. Department of Health and Human Services CFDA Program: 93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance Award Number: 5H79SM062879-02 and 6U79SP020710-04M001 Area: Allowable Costs/Cost Principles Questioned Costs: $452,311 Contact Persons: Perlie Santos, Chief Financial Officer; Reyna Saures, CGC Director; Vincent Camacho, Grants Administrator. Corrective Action: Condition 1 CHCC does not concur with the findings and the questioned costs. The payment vouchers supporting the breakdown of the checks that agree to the selected samples are readily available. 2019-008 Condition 1. In the prior years’ audits, CHCC provided auditors with read only access to our financial information system, wherein they will be able to view the “Payment with its Voucher Match”. Although the scanned copies of the “Payment with Voucher Match” were not timely provided, internal controls are in place in the financial information system, wherein the CHCC treasurer is not able to prepare any check payment without the matching payment voucher. Hence the likelihood of the condition stated is mitigated by the system controls. Finding No.: 2019-008 Continued Condition 2 CHCC does not concur with the findings and the questioned costs. Although not timely scanned and sent electronically to the Auditors, the supporting documents from Travel Authorization to Travel Voucher are readily available for testing 2019-008 Condition 2. With the implementation of the Munis Financial Information System in January 2023, CHCC is now able to electronically attach scanned supporting documents to the vouchers through the Tyler Content Manager (TCM). This will allow for audit testing to be done by providing auditors view only access to CHCC Financial Information System. Condition 3 CHCC does not concur with the findings and the questioned costs. All the copies of the cleared checks were provided to the Auditors. They were not able to match the provided check to the invoice as the check vouchers were not attached to the cleared checks. 2019-008 Condition 3 With the implementation of the Munis Financial Information System in January 2023, CHCC is now able to electronically attach electronic images of the checks issued. The Check is linked to the invoices paid through the Tyler Content Manager (TCM). This will allow for audit testing to be done by providing auditors view only access to CHCC Financial Information System. Condition 4 CHCC does not concur with the findings and the questioned costs. The invoices indicated as “not provided” were provided to the auditors since December 12, 2022. 2019-008 Condition 4 With the implementation of the Munis Financial Information System in January 2023, CHCC is now able to electronically attach scanned supporting documents to the vouchers through the Tyler Content Manager (TCM). This will allow for audit testing to be done by providing auditors view only access to CHCC Financial Information System. Condition 5 CHCC does not concur with the findings and the questioned costs. The payroll register was provided for testing. Finding No.: 2019-008 Continued Condition 6 CHCC does not concur with the findings and the $425,738 questioned costs. The auditor cited that CHCC expended more than the Grant award. Total expenditure reported and referenced by the auditor is correctly stated at $1,144,077. This does not exceed the cumulative award for this grant that is $1,304,330. The auditor may have erroneously referenced the additional funding for year 5, that is $718,339 as the total grant award. The Payment Management System, wherein drawdowns are made will not allow for drawdown to exceed the awarded amounts. This documentation was submitted on 5/22/2024 XH1 93.243 - Additional grant award documents. Furthermore, FFR’s are reported as cumulative amounts for the total project period. Proposed Completion Date: Not applicable as CHCC does not concur with the findings.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 507998 2019-004
    Material Weakness Repeat
  • 507999 2019-005
    Material Weakness Repeat
  • 508000 2019-006
    Material Weakness Repeat
  • 508001 2019-007
    Material Weakness Repeat
  • 508003 2019-009
    Material Weakness
  • 508004 2019-010
    Material Weakness
  • 508005 2019-011
    Material Weakness Repeat
  • 508006 2019-012
    Material Weakness Repeat
  • 508007 2019-013
    Material Weakness Repeat
  • 508008 2019-014
    Material Weakness
  • 508009 2019-015
    Material Weakness
  • 508010 2019-016
    Material Weakness Repeat
  • 1084440 2019-004
    Material Weakness Repeat
  • 1084441 2019-005
    Material Weakness Repeat
  • 1084442 2019-006
    Material Weakness Repeat
  • 1084443 2019-007
    Material Weakness Repeat
  • 1084444 2019-008
    Material Weakness Repeat
  • 1084445 2019-009
    Material Weakness
  • 1084446 2019-010
    Material Weakness
  • 1084447 2019-011
    Material Weakness Repeat
  • 1084448 2019-012
    Material Weakness Repeat
  • 1084449 2019-013
    Material Weakness Repeat
  • 1084450 2019-014
    Material Weakness
  • 1084451 2019-015
    Material Weakness
  • 1084452 2019-016
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $3.68M
93.268 Immunization Cooperative Agreements $3.36M
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $1.97M
93.870 Maternal, Infant and Early Childhood Homevisiting Grant Program $865,589
93.104 Comprehensive Community Mental Health Services for Children with Serious Emotional Disturbances (sed) $763,992
93.982 Mental Health Disaster Assistance and Emergency Mental Health $613,302
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $589,264
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $544,042
15.875 Economic, Social, and Political Development of the Territories $533,528
97.032 Crisis Counseling $501,942
93.074 Hospital Preparedness Program (hpp) and Public Health Emergency Preparedness (phep) Aligned Cooperative Agreements $494,660
93.994 Maternal and Child Health Services Block Grant to the States $452,851
93.236 Grants to States to Support Oral Health Workforce Activities $331,358
93.217 Family Planning Services $272,252
93.251 Universal Newborn Hearing and Screening $269,168
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $258,698
93.959 Block Grants for Prevention and Treatment of Substance Abuse $233,626
93.165 Grants to States for Loan Repayment $125,000
93.945 Assistance Programs for Chronic Disease Prevention and Control $120,169
93.917 Hiv Care Formula Grants $115,562
93.958 Block Grants for Community Mental Health Services $110,106
93.110 Maternal and Child Health Federal Consolidated Programs $89,729
93.644 Adult Medicaid Quality: Improving Maternal and Infant Health Outcomes in Medicaid and Chip $86,496
93.069 Public Health Emergency Preparedness $69,626
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $66,588
93.377 Prevention and Control of Chronic Disease and Associated Risk Factors in the U.s. Affiliated Pacific Islands, U.s. Virgin Islands, and P. R. $65,865
93.314 Early Hearing Detection and Intervention Information System (ehdi-Is) Surveillance Program $64,766
93.504 Family-To-Family Health Information Centers $63,569
93.788 Opioid Str $57,326
93.150 Projects for Assistance in Transition From Homelessness (path) $53,208
93.912 Rural Health Care Services Outreach, Rural Health Network Development and Small Health Care Provider Quality Improvement $46,310
93.991 Preventive Health and Health Services Block Grant $39,096
93.889 National Bioterrorism Hospital Preparedness Program $32,585
93.073 Birth Defects and Developmental Disabilities - Prevention and Surveillance $16,318
97.088 Disaster Assistance Projects $12,625
10.855 Distance Learning and Telemedicine Loans and Grants $6,162
93.817 Hospital Preparedness Program (hpp) Ebola Preparedness and Response Activities $4,921
93.103 Food and Drug Administration Research $4,911
10.578 Wic Grants to States (wgs) $3,323
16.575 Crime Victim Assistance $1,379