Finding 524947 (2024-001)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-02-28

AI Summary

  • Core Issue: The Agency incorrectly reported the SF 425 Federal Financial Report as accrual-based when it was actually cash-based, leading to an understatement of expenditures by about $630,000.
  • Impacted Requirements: The SF 425 instructions require accurate reporting based on the correct accounting basis, which was not followed in this instance.
  • Recommended Follow-Up: Implement stronger controls and review processes to ensure financial reports accurately reflect the accounting basis used by the Agency.

Finding Text

Assistance Listing, Federal Agency, and Program Name - 93.493 U.S. Department of Health and Human Services, Congressional Directives - Community Project Funding/Congressionally Directed Spending - Construction Federal Award Identification Number and Year - 1 CE1HS47212 01 00, 2022 Pass through Entity - N/A Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - The SF 425 Federal Financial Report instructions require recipients to indicate whether the report is prepared on the accrual basis of accounting or the cash basis of accounting and should follow an organization’s normal accounting basis. Condition The Agency’s controls in place for financial reporting submissions did not identify that the SF 425 Federal Financial Report (“FFR”) submitted for the annual reporting period ending August 31, 2023, indicated that the report was prepared on the accrual basis of accounting when the report was actually prepared on the cash basis of accounting. The report filed did not reflect the accrued expenditures for the program. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A – refer to context below for additional information. Context - During the annual period ended August 31, 2023, the Agency incurred $1,939,218 in matching expenditures for actual construction during the period. During the same period, the Agency made $1,308,829 in cash payments on invoices received from the general contractor for work performed on the project. The amount reported by the Agency on line 10.j—Recipient share of expenditures of the FFR was $1,308,829, which represents the amount of cash basis expenditures for the period. The Agency had indicated on the FFR that the report had been prepared on the accrual basis of accounting, which is consistent with the Agency’s normal financial reporting basis of account, and thus the $1,939,218 amount of actual expenditures incurred during the period should have been reported on line 10.j—Recipient share of expenditures. Cause and Effect - The total of construction invoices received from the general contractor for actual work performed through May 2023 amounted to $1,308,829, and all such invoices were paid prior to August 31, 2023. The construction invoice for work performed during the period from June 2023 through August 31, 2023 amounted to $630,439, and this invoice was received by the Agency in October 2023. Upon receipt, the invoice was recorded in the accounting records with an effective date of October 31, 2023. As the Agency prepared the FFR using the general ledger activity for construction invoices recorded with effective dates through August 31, 2023, the activity did not include the $630,439 invoice which was not received until October 2023 but which related to expenditures incurred during the reporting period. The result was line 10.j—Recipient share of expenditures was understated by approximately $630,000. Recommendation - We recommend that the Agency implement controls, including levels of review, to ensure that the basis of accounting indicated on required financial report submissions accurately reflects the basis of accounting used by the Agency. Views of Responsible Officials and Corrective Action Plan - The Agency agrees and will add additional review over future construction expenditures.

Corrective Action Plan

Condition: The Agency’s controls in place for financial reporting submissions did not identify that the SF-425 Federal Financial Report (“FFR”) submitted for the annual reporting period ending August 31, 2023, indicated that the report was prepared on the accrual basis of accounting when the report was actually prepared on the cash basis of accounting. The report filed did not reflect the accrued expenditures for the program. Planned Corrective Action: Thresholds current policy is as follows. For purposes of financial reporting on federal awards, financial reports will be prepared by the grant accountant (or other appropriate party) and reviewed by the Senior Director of Grants Accounting (or their designee). Unfortunately, this policy did not identify this mistake, because these payments came from a construction escrow account and did not go through the normal accounts payable process. We will add additional requirements for any accounting entry resulting from construction escrow payments. Namely, we will scrutinize and verify the accrual period(s) for such escrow expenditures before posting the accounting entry. Contact person responsible for corrective action: Al Shoreibah, Chief Financial Officer Anticipated Completion Date: 03/01/2025

Categories

Reporting

Other Findings in this Audit

  • 1101389 2024-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.958 Block Grants for Community Mental Health Services $1.68M
93.493 Congressional Directives $1.00M
93.150 Projects for Assistance in Transition From Homelessness (path) $882,945
14.181 Supportive Housing for Persons with Disabilities $812,589
14.195 Project-Based Rental Assistance (pbra) $510,563
93.136 Injury Prevention and Control Research and State and Community Based Programs $420,687
93.696 Certified Community Behavioral Health Clinic Expansion Grants $375,153
14.157 Supportive Housing for the Elderly $364,709
21.027 Coronavirus State and Local Fiscal Recovery Funds $197,110
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $149,431
93.433 Acl National Institute on Disability, Independent Living, and Rehabilitation Research $114,373
14.267 Continuum of Care Program $112,279
14.218 Community Development Block Grants/entitlement Grants $92,560
64.033 Va Supportive Services for Veteran Families Program $80,908
93.959 Block Grants for Prevention and Treatment of Substance Abuse $56,184
93.242 Mental Health Research Grants $12,119