Finding 370520 (2022-002)

Material Weakness
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2024-02-26
Audit: 292188
Organization: Leadership Memphis (TN)
Auditor: Watkins Uiberall

AI Summary

  • Core Issue: Expenditures for federal awards lacked a consistent and documented allocation methodology.
  • Impacted Requirements: Costs charged to federal programs must be reasonable, necessary, and supported by clear documentation.
  • Recommended Follow-Up: Establish a written allocation methodology for indirect costs and provide training on internal control requirements under Uniform Guidance.

Finding Text

Inadequate Controls Over Expenditure Allocations Condition: Expenditures allocated to federal awards were not based on rational and consistent allocation methodologies. Criteria: Expenditures charged to federal award programs should be reasonable and necessary. Those costs that are allocated should include documentation of the specific allocation methodologies used.Cause: The Organization obtained their first federal funding as a result of the COVID-19 pandemic. The Organization did not have an internal control system in place to meet the criteria required under the more robust internal control framework provided by the Uniform Guidance. As a result, even though audited allocated expenses appeared reasonable, a documented methodology was not in writing. Effect: Of the expenditures tested, most were initially allocated within the general ledger under a different methodology than was eventually expensed under the federal grant awards. Additionally, audit time and bookkeeping time was incurred to reconcile between the two allocation methodologies, and, in most cases, there was no documentation of the eventual allocation methodology. Many of the allocations reviewed relied on oral assertions of expenditures applicable to different Organization functions and federal award programs. In addition, although the allocations charged to the grants appeared to be consistent within a range, the initial assessment appeared to be based on budgetary concerns rather the use. Recommendation: Indirect costs, such as overhead and other split expenses, should be based on a written allocation methodology. For example, overhead expenses such as rent and utilities could be based on the square footage occupied by employees that provide services to specific Organization functions. Other expenses such as the purchase of supplies should be charged directly to the function or program utilizing the supplies or over rational basis of use if utilized under many functions or programs. Employee time should be allocated specifically based on the hours in the date spent towards achieving the goals of the Organization’s functions or programs. As a further recommendation, the Organization should obtain training to gain a full understanding of the internal control requirements under the Uniform Guidance internal control framework. Management’s Response: See management’s corrective action plan.

Corrective Action Plan

Corrective Action: Although we had a control process in place at that time, it was not sufficient to meet the standard of the single audit. We have improved our Internal Controls since the start of the audit. We have been using CBIZ, a CPA Firm, for our third-party accounting since June of 2023. Prior to expenditures being sent to CBIZ for posting to QuickBooks, the expenditures are reviewed by 4 staff members: the Director who initiated the purchase and adds the allocations codes to the invoice/bill/receipt, the Staff Accountant, the Director of Finance and Administration and the CEO for final approval who also initials the expenditure. Once the expenditure is approved, it is then added to our AP Log and/or CC log by our Staff Accountant and then the approved expenditures are scanned to CBIZ for posting to QuickBooks by one of their staff members. A manager with CBIZ will review it again when completing our monthly financials for accuracy. Once CBIZ posts our expenditures and deposits, they note on our SharePoint and OneDrive AP, CC logs and Weekly Income Reports that the work has been posted in QuickBooks. Due to the requirements of our current Grants, we have increased our internal controls, budget overviews and Director’s responsibilities to manage their events and expenses and code allocations per the budget so if reallocation of any kind is needed, it can be revised before it goes to the CPA. In addition, there is a 2nd review of the Grant Invoice and expenditure documentation by the Director and Finance and Administration and the CEO before the invoice is submitted to the Grant Administrator for reimbursement.

Categories

Procurement, Suspension & Debarment Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 370519 2022-001
    Material Weakness
  • 370521 2022-001
    Material Weakness
  • 370522 2022-002
    Material Weakness
  • 946961 2022-001
    Material Weakness
  • 946962 2022-002
    Material Weakness
  • 946963 2022-001
    Material Weakness
  • 946964 2022-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
14.269 Hurricane Sandy Community Development Block Grant Disaster Recovery Grants (cdbg-Dr) $134,468
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $98,125