Finding 946763 (2023-003)

Significant Deficiency
Requirement
C
Questioned Costs
-
Year
2023
Accepted
2024-02-23

AI Summary

  • Core Issue: CAP submitted reimbursement requests that exceeded actual expenditures by $9,473 due to a lack of reconciliation and oversight.
  • Impacted Requirements: Reimbursement requests must be supported by documentation and reflect costs paid prior to the request date.
  • Recommended Follow-up: CAP should enhance internal controls and review policies to ensure accurate reimbursement requests and proper reconciliation of expenditures.

Finding Text

2023-003 Cash Management Program: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) Federal Assistance Listing No: 93.224 County Recipient: Community Action Partnership of Natrona County Federal Agency: Department of Health and Human Services Grant year: 2022 Federal Award Identification: Unknown Applicable Pass-through Entity: None Criteria When non-federal entities are funded under the reimbursement method, expenditures included in reimbursement requests should have supporting documentation and the entity should have paid for the costs for which the reimbursement is requested prior to the date of the reimbursement request. Condition Community Action Partnership of Natrona County (CAP) submitted reimbursement requests in excess of actual expenditures. Cause Due to turnover in grant management, processes that had previously existed were overlooked. A reconciliation of grant expenditures to the amounts requested for reimbursement was not performed resulting in reimbursements that were greater than the actual grant expenditures. Effect or potential effect Without adequate review and reconciliations of reimbursement requests, an entity may submit inaccurate expenditure reimbursement requests. Questioned Cost None Context We tested 24 out of 26 reimbursement requests submitted during the grant period by comparing each reimbursement request to the actual expenditures in the CAP general ledger. Additionally, we reconciled total grant reimbursements to total grant expenditures. We noted that total grant reimbursement requests exceeded the total grant expenditures by $9,473. Identification as a repeat finding This is not a repeat finding Recommendation We recommend CAP review its policies and procedures related to the internal controls over reimbursement requests to assure reimbursement requests have supporting documentation and reconcile to actual expenditures incurred. Views of Responsible Officials CAPNC moved from an archaic, unsupported software system to Sage Intaact. This software provides the ability to modernize and deploy the levels of internal controls missing from previous fiscal personnel oversight and technical capability. Current staff have trained under Sage Intaact and Wipfli consultants to properly track A/P, A/R, payroll and grant management to ensure the integrity of data entry and compliance is observed. Board membership have access to accounting software through Board portal for further oversight. Payroll services were outsourced to ADP payroll services in order to provide real time features and accountability for time. This allows recording of time more accurate, reliable and allocable. Payroll records are reviewed and time studies are being performed for all staff to ensure allocation methodology, once selected is appropriate, consistent and in alignment with staff performance. Wipfli Consulting is providing technical assistance over a 10 month period to develop/deploy updated policies and procedures for fiscal area, in accordance with Uniform Guidance. Curriculum includes: All administrative leadership staff received, and will continue to receive annually, fiscal oversight training including but not limited to, Uniform Guidance training, grants management and compliance training. Allocations are reviewed regularly by leadership team to ensure that we have appropriate methodology and that we are consistent with grant expectations and regulations. See Corrective Action Plan

Categories

Allowable Costs / Cost Principles Cash Management Internal Control / Segregation of Duties Subrecipient Monitoring HUD Housing Programs Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 370319 2023-001
    Material Weakness
  • 370320 2023-002
    Material Weakness
  • 370321 2023-003
    Significant Deficiency
  • 370322 2023-002
    Material Weakness
  • 946761 2023-001
    Material Weakness
  • 946762 2023-002
    Material Weakness
  • 946764 2023-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.023 Emergency Rental Assistance Program $331,083
93.069 Public Health Emergency Preparedness $287,600
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $220,462
93.224 Consolidated Health Centers (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $200,815
93.977 Sexually Trnasmitted Diseases (std) Prevention and Control Grants $150,124
93.959 Block Grants for Prevention and Treatment of Substance Abuse $119,450
93.268 Immunization Cooperative Agreements $102,879
93.145 Hiv-Related Training and Technical Assistance $99,753
93.569 Community Services Block Grant $85,906
93.558 Temporary Assistance for Needy Families $82,236
14.231 Emergency Solutions Grant Program $68,301
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $63,589
14.267 Continuum of Care Program $60,290
95.001 High Intensity Drug Trafficking Areas Program $48,814
93.387 National and State Tobacco Control Program (b) $39,144
93.426 The National Cardiovascular Health Program $37,115
93.197 Childhood Lead Poisoning Prevention Projects_state and Local Childhood Lead Poisoning Prevention and Surveillance of Blood Lead Levels in Children $8,590
21.027 Coronavirus State and Local Fiscal Recovery Funds $5,901
16.582 Crime Victim Assistance/discretionary Grants $5,000
93.958 Block Grants for Community Mental Health Services $4,681
16.607 Bulletproof Vest Partnership Program $4,650
97.067 Homeland Security Grant Program $3,502
20.616 National Priority Safety Programs $3,316
93.150 Projects for Assistance in Transition From Homelessness (path) $3,087
93.008 Medical Reserve Corps Small Grant Program $2,244
97.012 Boating Safety Financial Assistance $217