Finding 32682 (2022-001)

Significant Deficiency Repeat Finding
Requirement
A
Questioned Costs
-
Year
2022
Accepted
2023-06-29

AI Summary

  • Core Issue: Difficulty in obtaining accurate financial reports due to improper accounting setup.
  • Impacted Requirements: Non-compliance with 2 CFR 200.302, affecting the ability to trace funds and prepare required reports.
  • Recommended Follow-Up: Implement project codes, hire an experienced accountant for government grants, and establish monthly reconciliations with a review process.

Finding Text

Information on the Federal Program: Assistance Living Number 21.027 Criteria: Title 2 CFR 200 Section 200.302 establishes non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Condition: During the current year audit, we had difficulty obtaining the correct financial reports from the accounting software. Context: Fry was unable to extract the correct reports or prepare proper reports. These reports include the Schedule of Federal Expenditures (SEFA), program profit and loss statements, and the functional expense statement. Multiple version of all requested financial documents were provided. Cause: Fry's accounting is not set up properly to allow for easy and accurate record keeping. There is also no review and approval of transactions posted to the accounting software. Effect or Potential Effect: We were unable to trace revenue to the proper general ledger account. We could not trace salary allocations to the project. The major program profit and loss did not tie to the SEFA. Question Costs: None Identification of Repeat Finding: 2021-001 Recommendation: Fry should set up project/class codes for each program, fundraising, and general and administrative in the accounting software. We also recommend Fry hires someone with accounting experience in relation to government grants to assist in the setup and to help maintain records throughout the year. Accounts should be reconciled on a monthly basis and have a review and approval process for all accounts.

Corrective Action Plan

Views of Responsible Officials and Corrective Action: We are in the process of hiring a new bookkeeper/accountant to help manage these issues and develop policies to avoid future errors. We will also implement a process to make sure QuickBase and QuickBooks agree.

Categories

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

Other Findings in this Audit

  • 32683 2022-002
    Significant Deficiency Repeat
  • 32684 2022-001
    Significant Deficiency Repeat
  • 32685 2022-002
    Significant Deficiency Repeat
  • 609124 2022-001
    Significant Deficiency Repeat
  • 609125 2022-002
    Significant Deficiency Repeat
  • 609126 2022-001
    Significant Deficiency Repeat
  • 609127 2022-002
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $3.36M
93.568 Low-Income Home Energy Assistance $2.03M
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $492,081
81.042 Weatherization Assistance for Low-Income Persons $353,096