Finding 500932 (2023-001)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2024-09-30
Audit: 323235
Organization: Wabanaki Health and Wellness (ME)
Auditor: Wipfli LLP

AI Summary

  • Core Issue: There is a material weakness in internal control over compliance with major federal programs at Wabanaki Public Health and Wellness.
  • Impacted Requirements: This affects compliance with multiple federal awards related to substance abuse, public health, and biomedical research.
  • Recommended Follow-Up: Strengthen internal controls to ensure compliance with federal program requirements and prevent future weaknesses.

Finding Text

Finding Number 2023-001: Represents a material weakness in internal control over compliance with Wabanaki Public Health and Wellness, NPC’s major federal programs. Questioned Costs: None Major Programs: AL#93.243 - Substance Abuse and Mental Health Services – Direct Award (DHHS) – Award numbers: 1H79SM087536-01, 1H79SM087590-01, 5H79SP081724-04, 5H79SP081724-05, 5H79SM082160-04, 5H79SM082160-05, 5H79SP082229-02, 5H79SP082229-03, 1H79SM088765-01, 1H79TI085542-01, H79TI086128-01 and CD9-23-4425 AL#93.738 – PPHF: Racial and Ethnic Approaches to Community Health Program financed solely by Public Prevention and Health Funds – Direct Award (DHHS) – Award number: 5 NU58DP006960-02-00 and 6 NU58DP006960-01-01 AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023-01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 AL#93.788 – Opioid STR – Direct Award (DHHS) – Award numbers: 1H79TI083088-01, 5H79TI083088-02, 6H79TI085684-01M003 and CD9-23-4425 AL#93.859 – Biomedical Research and Research Training – Direct Award (DHHS) – Award numbers: 5S06GM142115-02 and 5S06GM142115-03

Corrective Action Plan

2023-001 - Material Weakness - Material Adjusting Journal Entries WPHW understands this finding and recognizes that corrections that were planned for FY23 did not come to fruition. WPHW was in the process of implementing a new financial management system, NetSuite. It was our plan to implement new processes that would have fully addressed prior concerns. It was our plan to have the FY23 audit completed in both NetSuite and QuickBooks. However, we encountered several issues with the implementation of the new system, which delayed prior year corrected actions. In May 2024, WPHW decide to no longer work with NetSuite, due to the number of issues with the system and the company. Since that time, we have fully committed to QuickBooks and have started engaging in systematic business process redesign of our financial system. At the time of the transition back to QuickBooks fully, we also made significant staff role changes. Our accounting department now has a Director of Accounting and two new managers, AR/AP Manager and Accounting Manager. With these new positions, we have developed the following procedures for adjusting journal entries: 1) Accounting Director, Accounting Manager or AR/AP Manager identifying need for a journal entry 2) Accounting Specialist or AR/AP Specialist pulls the supporting documentation for the required entry, creates journal entry template in Excel, and prepares journal entry packet with supporting documentation for entry into QB. 3) Accountant or Accounting Manager reviews packet and determines who can enter journal a. If reviewed by Accountant, entry is entered QuickBooks by Accounting Specialist b. If reviewed by Accounting Manager, entry is entered into QuickBooks by Accountant 4) Once journal entry is entered into QuickBooks, entry is printed from QB system and added to packet. The packet is returned to the preparer to ensure all elements were completed corrected and signed off on 5) Completed packet goes to filing and are scanned into our electronic file system All adjustments must go through three different individuals to ensure separation of duties. This process will be implemented during Q4 of FY24. The Director of Accounting will go back over all the journals completed before this date to review how each were completed and delegate additional review to the Accounting Manager and Accounting Specialist to ensure each journal entry had appropriate review and support. With this process in place, we anticipate this issue being fully resolved in FY25.

Categories

Material Weakness Internal Control / Segregation of Duties

Other Findings in this Audit

  • 500933 2023-002
    Material Weakness Repeat
  • 500934 2023-003
    Significant Deficiency Repeat
  • 500935 2023-008
    Significant Deficiency
  • 500936 2023-001
    Material Weakness Repeat
  • 500937 2023-002
    Material Weakness Repeat
  • 500938 2023-003
    Significant Deficiency Repeat
  • 500939 2023-008
    Significant Deficiency
  • 500940 2023-001
    Material Weakness Repeat
  • 500941 2023-002
    Material Weakness Repeat
  • 500942 2023-003
    Significant Deficiency Repeat
  • 500943 2023-007
    Material Weakness Repeat
  • 500944 2023-008
    Significant Deficiency
  • 500945 2023-001
    Material Weakness Repeat
  • 500946 2023-002
    Material Weakness Repeat
  • 500947 2023-003
    Significant Deficiency Repeat
  • 500948 2023-008
    Significant Deficiency
  • 500949 2023-009
    Significant Deficiency
  • 500950 2023-001
    Material Weakness Repeat
  • 500951 2023-002
    Material Weakness Repeat
  • 500952 2023-003
    Significant Deficiency Repeat
  • 500953 2023-008
    Significant Deficiency
  • 500954 2023-009
    Significant Deficiency
  • 500955 2023-010
    Significant Deficiency
  • 500956 2023-006
    Significant Deficiency
  • 500957 2023-001
    Material Weakness Repeat
  • 500958 2023-002
    Material Weakness Repeat
  • 500959 2023-003
    Significant Deficiency Repeat
  • 500960 2023-008
    Significant Deficiency
  • 500961 2023-001
    Material Weakness Repeat
  • 500962 2023-002
    Material Weakness Repeat
  • 500963 2023-003
    Significant Deficiency Repeat
  • 500964 2023-008
    Significant Deficiency
  • 500965 2023-001
    Material Weakness Repeat
  • 500966 2023-002
    Material Weakness Repeat
  • 500967 2023-003
    Significant Deficiency Repeat
  • 500968 2023-007
    Material Weakness Repeat
  • 500969 2023-008
    Significant Deficiency
  • 500970 2023-001
    Material Weakness Repeat
  • 500971 2023-002
    Material Weakness Repeat
  • 500972 2023-003
    Significant Deficiency Repeat
  • 500973 2023-008
    Significant Deficiency
  • 500974 2023-009
    Significant Deficiency
  • 1077374 2023-001
    Material Weakness Repeat
  • 1077375 2023-002
    Material Weakness Repeat
  • 1077376 2023-003
    Significant Deficiency Repeat
  • 1077377 2023-008
    Significant Deficiency
  • 1077378 2023-001
    Material Weakness Repeat
  • 1077379 2023-002
    Material Weakness Repeat
  • 1077380 2023-003
    Significant Deficiency Repeat
  • 1077381 2023-008
    Significant Deficiency
  • 1077382 2023-001
    Material Weakness Repeat
  • 1077383 2023-002
    Material Weakness Repeat
  • 1077384 2023-003
    Significant Deficiency Repeat
  • 1077385 2023-007
    Material Weakness Repeat
  • 1077386 2023-008
    Significant Deficiency
  • 1077387 2023-001
    Material Weakness Repeat
  • 1077388 2023-002
    Material Weakness Repeat
  • 1077389 2023-003
    Significant Deficiency Repeat
  • 1077390 2023-008
    Significant Deficiency
  • 1077391 2023-009
    Significant Deficiency
  • 1077392 2023-001
    Material Weakness Repeat
  • 1077393 2023-002
    Material Weakness Repeat
  • 1077394 2023-003
    Significant Deficiency Repeat
  • 1077395 2023-008
    Significant Deficiency
  • 1077396 2023-009
    Significant Deficiency
  • 1077397 2023-010
    Significant Deficiency
  • 1077398 2023-006
    Significant Deficiency
  • 1077399 2023-001
    Material Weakness Repeat
  • 1077400 2023-002
    Material Weakness Repeat
  • 1077401 2023-003
    Significant Deficiency Repeat
  • 1077402 2023-008
    Significant Deficiency
  • 1077403 2023-001
    Material Weakness Repeat
  • 1077404 2023-002
    Material Weakness Repeat
  • 1077405 2023-003
    Significant Deficiency Repeat
  • 1077406 2023-008
    Significant Deficiency
  • 1077407 2023-001
    Material Weakness Repeat
  • 1077408 2023-002
    Material Weakness Repeat
  • 1077409 2023-003
    Significant Deficiency Repeat
  • 1077410 2023-007
    Material Weakness Repeat
  • 1077411 2023-008
    Significant Deficiency
  • 1077412 2023-001
    Material Weakness Repeat
  • 1077413 2023-002
    Material Weakness Repeat
  • 1077414 2023-003
    Significant Deficiency Repeat
  • 1077415 2023-008
    Significant Deficiency
  • 1077416 2023-009
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.859 Biomedical Research and Research Training $1.42M
93.772 Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement $644,028
93.933 Demonstration Projects for Indian Health $513,651
93.872 Tribal Maternal, Infant, and Early Childhood Home Visiting $394,448
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $264,082
93.493 Community Project Funding/congressionally Directed Spending ‐ Construction $243,060
93.738 Pphf: Racial and Ethnic Approaches to Community Health Program Financed Solely by Public Prevention and Health Funds $191,341
93.665 Emergency Grants to Address Mental and Substance Use Disorders During Covid-19 $177,747
93.762 A Comprehensive Approach to Good Health and Wellness in Indian County Ð Financed Solely by Prevention and Public Health $163,601
15.144 Indian Child Welfare Act_title II Grants $140,841
10.225 Community Food Projects $132,008
93.558 Temporary Assistance for Needy Families $100,070
21.027 Coronavirus State and Local Fiscal Recovery Funds $100,000
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $87,682
93.912 Rural Health Care Services Outreach, Rural Health Network Development and Small Health Care Provider Quality Improvement $85,832
66.306 Environmental Justice Collaborative Problem-Solving Cooperative Agreement Program $83,810
93.587 Promote the Survival and Continuing Vitality of Native American Languages $62,409
93.959 Block Grants for Prevention and Treatment of Substance Abuse $55,929
93.268 Immunization Cooperative Agreements $54,486
93.788 Opioid Str $52,890
93.958 Block Grants for Community Mental Health Services $47,549
93.011 National Organizations of State and Local Officials $40,523
15.032 Indian Economic Development $25,043
10.766 Community Facilities Loans and Grants $23,007
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $11,697
10.568 Emergency Food Assistance Program (administrative Costs) $10,554
93.270 Adult Viral Hepatitis Prevention and Control $10,341
93.940 Hiv Prevention Activities_health Department Based $9,665
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $2,472