Finding 23877 (2022-003)

Material Weakness
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2022-11-21

AI Summary

  • Core Issue: The Association failed to provide adequate documentation for costs charged to the ARP program, risking noncompliance with federal regulations.
  • Impacted Requirements: Sections 200.403(g) and 200.302 of Title 2 U.S. Code require proper documentation and financial management for federal awards.
  • Recommended Follow-Up: Implement policies to ensure compliance with documentation and review processes to prevent potential funding loss.

Finding Text

Finding 2022-003 Federal Programs: Assistance Listing Number: 93.498 COVID 19: Provider Relief Funds and American Rescue Plan (ARP) Rural Distributions Criteria: Section 200.403(g) of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards, requires that costs be adequately documented. In addition, Section 200.302 requires that the financial management system of each non-Federal entity must provide for an identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received; an accurate, current, and complete disclosure of the financial results of each Federal award or program; and a comparison of expenditures with budget amounts for each Federal award. Condition: During our testing of internal controls associated with the ARP program, the Association was not able to provide evidence of the review of time records and invoices to ensure that allowable costs were charged to the program. In addition, management provided an excel spreadsheet to support the charges that were made to the program rather than reporting from their financial management system that is compliant with Section 200.302. Therefore, we could not substantiate whether the double-counting of expenses did not occur. Cause: Policies and procedures were not implemented to ensure that evidence of an appropriate level of review and approval was completed prior to charging costs to the federal programs. In addition, policies and procedures were not implemented to ensure that charges made to federal programs were properly captured in the financial management system as required in order to demonstrate that double counting did not occur. Effect: An ineffective internal control system related to approval of costs to ensure allowability can lead to noncompliance with laws and regulations and possible loss of funding. In addition, an ineffective financial management system, could lead to noncompliance with laws and regulations and possible loss of funding. Specifically, it could lead to an incorrect identification of costs charged to a federal program and an inability to substantiate that double-charging did not occur. Questioned Cost: Could not be determined Context: A total of 40 payroll and 40 non payroll transactions, associated with the Association?s major programs, were selected from a sample of charges made to each respective program. Of this sample, 20 payroll and 20 non payroll transactions associated with the Provider Relief Funds and American Rescue Plan (ARP) Rural Distributions program were selected for testing. During our testing of internal controls, in 10 out of 20 payroll transactions associated with the ARP program, the Association was not able to provide evidence for the review of time records to ensure that allowable costs were charged to the program. During our testing of internal controls, in 20 out of 20 non payroll transactions associated with the ARP program, the Association was not able to provide evidence for the review of invoices to ensure that allowable costs were charged to the program. In addition, management provided an excel spreadsheet to support the charges that were made to the program rather than reporting from their financial management system that is compliant with Section 200.302. Recommendations: We recommend that policies and procedures be implemented to ensure compliance with sections 200.403(g) and 200.302 of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards, in order to ensure compliance with laws and regulations associated with Uniform Guidance. View of Responsible Officials: Management concurs with this recommendation. See page 44 for Corrective Action Plan.

Corrective Action Plan

Identifying Number: Finding 2022-003 Finding: During our testing of internal controls associated with the ARP program, the Association was not able to provide evidence of the review of time records and invoices to ensure that allowable costs were charged to the program. In addition, management provided an excel spreadsheet to support the charges that were made to the program rather than reporting from their financial management system that is compliant with Section 200.302. Therefore, we could not substantiate the double-counting of expenses did not occur. Corrective Action Taken or Planned: We assert that we exercised significant diligence and oversight over the handling of the federal dollars associated with the ARP funding (ALN 93.498) to ensure that such expenditures were (i) for allowable activities and consisted of allowable costs, (ii) tracked in an Excel spreadsheet that was compiled from support such as invoices and payroll records; and (iii) were not applied against other sources of funding. This was accomplished through the following: ? All invoices submitted against the ARP program were required and did have signature approval of the purchaser and supervisor ? Documentation of all activity was managed from all ARP sources, across all internal department and cost centers through a highly detailed excel spreadsheet managed by a third party contractor. This data was then reviewed by the agency Controller, CFO, and CEO regularly for accuracy against regular updates from the federal government regarding program reporting requirements and issued clarifications from the federal government. While we assert that proper oversight of this program was exercised, we understand that the auditors were not able to view evidence of such review via sign-offs. We will update our policies and procedures to require evidence of our oversight responsibilities be required by means such as sign-offs, email approvals, etc. Further, we will work to adapt our accounting system to be able to track activity related to federal grants within its own cost center (or sub cost center) so as to minimize the need for external financial management systems such as Excel spreadsheets. Name of contact person and title: William Bode, Controller Anticipated completion date: Immediately

Categories

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

Other Findings in this Audit

  • 23876 2022-002
    Material Weakness
  • 23878 2022-005
    Material Weakness
  • 23879 2022-004
    Significant Deficiency
  • 23880 2022-002
    Material Weakness
  • 23881 2022-002
    Material Weakness
  • 23882 2022-002
    Material Weakness
  • 23883 2022-002
    Material Weakness
  • 23884 2022-002
    Material Weakness
  • 23885 2022-002
    Material Weakness
  • 23886 2022-002
    Material Weakness
  • 23887 2022-002
    Material Weakness
  • 23888 2022-002
    Material Weakness
  • 23889 2022-002
    Material Weakness
  • 23890 2022-002
    Material Weakness
  • 23891 2022-002
    Material Weakness
  • 23892 2022-002
    Material Weakness
  • 23893 2022-002
    Material Weakness
  • 600318 2022-002
    Material Weakness
  • 600319 2022-003
    Material Weakness
  • 600320 2022-005
    Material Weakness
  • 600321 2022-004
    Significant Deficiency
  • 600322 2022-002
    Material Weakness
  • 600323 2022-002
    Material Weakness
  • 600324 2022-002
    Material Weakness
  • 600325 2022-002
    Material Weakness
  • 600326 2022-002
    Material Weakness
  • 600327 2022-002
    Material Weakness
  • 600328 2022-002
    Material Weakness
  • 600329 2022-002
    Material Weakness
  • 600330 2022-002
    Material Weakness
  • 600331 2022-002
    Material Weakness
  • 600332 2022-002
    Material Weakness
  • 600333 2022-002
    Material Weakness
  • 600334 2022-002
    Material Weakness
  • 600335 2022-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.498 Covid 19: Provider Relief Funds and American Rescue Plan (arp) Rural Distributions $361,134
93.470 Alzheimer's Disease Program Initiative (adpi) $313,103
21.019 Covid 19: Coronavirus Relief Fund $53,256
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $34,792
14.267 Continuum of Care Program $26,131
16.575 Crime Victim Assistance $24,230
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $18,967
16.588 Violence Against Women Formula Grants $17,447
16.738 Edward Byrne Memorial Justice Assistance Grant Program $11,364