Finding 1127872 (2024-005)

Significant Deficiency
Requirement
ABH
Questioned Costs
-
Year
2024
Accepted
2025-03-31

AI Summary

  • Core Issue: The Organization lacks adequate policies to ensure that rent and other cross-charges to federally funded programs are based on actual costs, not budgeted or market rates.
  • Impacted Requirements: This violates the Uniform Guidance, specifically regarding documentation of personnel expenses and allowable rental costs under federal awards.
  • Recommended Follow-Up: Implement procedures to reconcile and adjust rent charges to reflect actual expenditures, ensuring compliance with federal guidelines.

Finding Text

Federal Agencies: Department of the Treasury Federal Assistance Listing Numbers: 21.023, 21.027 Programs: COVID-19 Emergency Rental Assistance Program, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Award/Pass-Through Entity Identifying Numbers: COVID-19 HCS-21-37-2103-018(7), HCS-23-AR-2111-018, ARPA - HCS-22-AR-2104-018, COVID-19 - EL-22-AR-27-018, ARPA - EL-22-AR-35-018(1), ARPA - EL-21-AR-03-018(4), ARPA - EL-21-AR-04-018(5), ARPA - EL-22-AR-29-018(2), ARPA - HS-21-AR-01-018(2), BH-22-AR-02-018(1), HCS-23-67-2301-018, HCS-23-AR-2107-018, ARP – 19911, CRF-2024-01, Agreement, 3733, COVID-19 – Agreement, K501, K4893, K4786, K4560, K4862 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 2 CFR §200.430 Compensation – personal services: (g) Standards for Documentation of Personnel Expenses. (vii) “Budget estimates (meaning, estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient's or subrecipient's written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient's or subrecipient's system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Per 2 CFR §200.465 Rental Costs of Real Property and Equipment: (b) “Rental costs under ‘sale and lease back’ arrangements are allowable only up to the amount that would have been allowed if the recipient or subrecipient had continued to own the property. This amount would include expenses such as depreciation, maintenance, taxes, and insurance. (c) Rental costs under “less-than-arm's-length” leases are allowable only up to the amount described in paragraph (b) of this section. For this purpose, a less-than-arm's-length lease is one under which one party to the lease agreement can control or substantially influence the actions of the other...” Condition: Policies and procedures were not adequately established to ensure allowability of rent charges and other cross-charges to federally funded programs. We noted the Organization’s subsidiary charges rent to the Organization’s programs to utilize office spaces for their operations and cross-charges certain other miscellaneous costs. The rent and certain other costs are based on budgeted costs plus a market rate, which is an unallowable method under the Uniform Grant Guidance. Since these transactions are less-than-arm’s-length due to the Organization’s control and significant influence over its subsidiary, costs charged should be based on actual costs incurred. • For the COVID-19 Emergency Rental Assistance Program: o 1 out of 25 selections was charged based on a market rate and budgeted costs. This selection was for a rent expense. • Allocated cost pool of IT costs: o 2 out of 25 selections were charged based on a market rate and/or budgeted costs. One of the selections was for a rent expense and the other was for building maintenance performed by an employee. Cause: The Organization’s policies and procedures lacked a step to reconcile and/or true-up budget and market rates to actual expenditures. Effect or Potential Effect: Without adequate controls in place to ensure expenditures represent actual costs, the Organization could incorrectly charge expenditures to the Federal program, or not request the appropriate reimbursement the Organization is entitled to under the grant. Questioned Costs: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Organization’s compliance with specified requirements not using a statistically valid sample. • For the COVID-19 Emergency Rental Assistance Program, nonpayroll costs were $1,166,466 and rent charged to the program was $12,743. • IT costs are accumulated and allocated to grants on an allowable basis. The total IT cost pool was $759,731,which was allocated across all programs (federal and nonfederal). Identification as a Repeat Finding: No similar finding noted in the prior year. Recommendation: We recommend that the Organization implements policies and procedures to timely reconcile and, if necessary, true-up rent charges to actual expenditures incurred. Views of Responsible Officials: Management agrees with the finding. Management is updating procedures for how certain costs are cross-charged to federal programs.

Categories

Matching / Level of Effort / Earmarking Subrecipient Monitoring Equipment & Real Property Management

Other Findings in this Audit

  • 551396 2024-004
    Significant Deficiency Repeat
  • 551397 2024-004
    Significant Deficiency Repeat
  • 551398 2024-004
    Significant Deficiency Repeat
  • 551399 2024-004
    Significant Deficiency Repeat
  • 551400 2024-004
    Significant Deficiency Repeat
  • 551401 2024-004
    Significant Deficiency Repeat
  • 551402 2024-004
    Significant Deficiency Repeat
  • 551403 2024-004
    Significant Deficiency Repeat
  • 551404 2024-004
    Significant Deficiency Repeat
  • 551405 2024-004
    Significant Deficiency Repeat
  • 551406 2024-004
    Significant Deficiency Repeat
  • 551407 2024-004
    Significant Deficiency Repeat
  • 551408 2024-004
    Significant Deficiency Repeat
  • 551409 2024-004
    Significant Deficiency Repeat
  • 551410 2024-004
    Significant Deficiency Repeat
  • 551411 2024-004
    Significant Deficiency Repeat
  • 551412 2024-004
    Significant Deficiency Repeat
  • 551413 2024-004
    Significant Deficiency Repeat
  • 551414 2024-004
    Significant Deficiency Repeat
  • 551415 2024-004
    Significant Deficiency Repeat
  • 551416 2024-004
    Significant Deficiency Repeat
  • 551417 2024-004
    Significant Deficiency Repeat
  • 551418 2024-004
    Significant Deficiency Repeat
  • 551419 2024-004
    Significant Deficiency Repeat
  • 551420 2024-004
    Significant Deficiency Repeat
  • 551421 2024-004
    Significant Deficiency Repeat
  • 551422 2024-005
    Significant Deficiency
  • 551423 2024-005
    Significant Deficiency
  • 551424 2024-005
    Significant Deficiency
  • 551425 2024-005
    Significant Deficiency
  • 551426 2024-005
    Significant Deficiency
  • 551427 2024-005
    Significant Deficiency
  • 551428 2024-005
    Significant Deficiency
  • 551429 2024-005
    Significant Deficiency
  • 551430 2024-005
    Significant Deficiency
  • 551431 2024-005
    Significant Deficiency
  • 551432 2024-005
    Significant Deficiency
  • 551433 2024-005
    Significant Deficiency
  • 551434 2024-005
    Significant Deficiency
  • 551435 2024-005
    Significant Deficiency
  • 551436 2024-005
    Significant Deficiency
  • 551437 2024-005
    Significant Deficiency
  • 551438 2024-005
    Significant Deficiency
  • 551439 2024-005
    Significant Deficiency
  • 551440 2024-005
    Significant Deficiency
  • 551441 2024-005
    Significant Deficiency
  • 551442 2024-005
    Significant Deficiency
  • 551443 2024-005
    Significant Deficiency
  • 551444 2024-006
    Significant Deficiency
  • 551445 2024-006
    Significant Deficiency
  • 551446 2024-006
    Significant Deficiency
  • 551447 2024-006
    Significant Deficiency
  • 551448 2024-006
    Significant Deficiency
  • 551449 2024-006
    Significant Deficiency
  • 551450 2024-006
    Significant Deficiency
  • 551451 2024-006
    Significant Deficiency
  • 551452 2024-006
    Significant Deficiency
  • 551453 2024-006
    Significant Deficiency
  • 551454 2024-006
    Significant Deficiency
  • 551455 2024-006
    Significant Deficiency
  • 551456 2024-006
    Significant Deficiency
  • 551457 2024-006
    Significant Deficiency
  • 551458 2024-006
    Significant Deficiency
  • 551459 2024-006
    Significant Deficiency
  • 551460 2024-006
    Significant Deficiency
  • 551461 2024-006
    Significant Deficiency
  • 551462 2024-006
    Significant Deficiency
  • 551463 2024-006
    Significant Deficiency
  • 551464 2024-006
    Significant Deficiency
  • 1127838 2024-004
    Significant Deficiency Repeat
  • 1127839 2024-004
    Significant Deficiency Repeat
  • 1127840 2024-004
    Significant Deficiency Repeat
  • 1127841 2024-004
    Significant Deficiency Repeat
  • 1127842 2024-004
    Significant Deficiency Repeat
  • 1127843 2024-004
    Significant Deficiency Repeat
  • 1127844 2024-004
    Significant Deficiency Repeat
  • 1127845 2024-004
    Significant Deficiency Repeat
  • 1127846 2024-004
    Significant Deficiency Repeat
  • 1127847 2024-004
    Significant Deficiency Repeat
  • 1127848 2024-004
    Significant Deficiency Repeat
  • 1127849 2024-004
    Significant Deficiency Repeat
  • 1127850 2024-004
    Significant Deficiency Repeat
  • 1127851 2024-004
    Significant Deficiency Repeat
  • 1127852 2024-004
    Significant Deficiency Repeat
  • 1127853 2024-004
    Significant Deficiency Repeat
  • 1127854 2024-004
    Significant Deficiency Repeat
  • 1127855 2024-004
    Significant Deficiency Repeat
  • 1127856 2024-004
    Significant Deficiency Repeat
  • 1127857 2024-004
    Significant Deficiency Repeat
  • 1127858 2024-004
    Significant Deficiency Repeat
  • 1127859 2024-004
    Significant Deficiency Repeat
  • 1127860 2024-004
    Significant Deficiency Repeat
  • 1127861 2024-004
    Significant Deficiency Repeat
  • 1127862 2024-004
    Significant Deficiency Repeat
  • 1127863 2024-004
    Significant Deficiency Repeat
  • 1127864 2024-005
    Significant Deficiency
  • 1127865 2024-005
    Significant Deficiency
  • 1127866 2024-005
    Significant Deficiency
  • 1127867 2024-005
    Significant Deficiency
  • 1127868 2024-005
    Significant Deficiency
  • 1127869 2024-005
    Significant Deficiency
  • 1127870 2024-005
    Significant Deficiency
  • 1127871 2024-005
    Significant Deficiency
  • 1127873 2024-005
    Significant Deficiency
  • 1127874 2024-005
    Significant Deficiency
  • 1127875 2024-005
    Significant Deficiency
  • 1127876 2024-005
    Significant Deficiency
  • 1127877 2024-005
    Significant Deficiency
  • 1127878 2024-005
    Significant Deficiency
  • 1127879 2024-005
    Significant Deficiency
  • 1127880 2024-005
    Significant Deficiency
  • 1127881 2024-005
    Significant Deficiency
  • 1127882 2024-005
    Significant Deficiency
  • 1127883 2024-005
    Significant Deficiency
  • 1127884 2024-005
    Significant Deficiency
  • 1127885 2024-005
    Significant Deficiency
  • 1127886 2024-006
    Significant Deficiency
  • 1127887 2024-006
    Significant Deficiency
  • 1127888 2024-006
    Significant Deficiency
  • 1127889 2024-006
    Significant Deficiency
  • 1127890 2024-006
    Significant Deficiency
  • 1127891 2024-006
    Significant Deficiency
  • 1127892 2024-006
    Significant Deficiency
  • 1127893 2024-006
    Significant Deficiency
  • 1127894 2024-006
    Significant Deficiency
  • 1127895 2024-006
    Significant Deficiency
  • 1127896 2024-006
    Significant Deficiency
  • 1127897 2024-006
    Significant Deficiency
  • 1127898 2024-006
    Significant Deficiency
  • 1127899 2024-006
    Significant Deficiency
  • 1127900 2024-006
    Significant Deficiency
  • 1127901 2024-006
    Significant Deficiency
  • 1127902 2024-006
    Significant Deficiency
  • 1127903 2024-006
    Significant Deficiency
  • 1127904 2024-006
    Significant Deficiency
  • 1127905 2024-006
    Significant Deficiency
  • 1127906 2024-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.023 Emergency Rental Assistance Program $1.45M
10.569 Emergency Food Assistance Program (food Commodities) $1.32M
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $445,660
14.239 Home Investment Partnerships Program $317,473
93.958 Block Grants for Community Mental Health Services $211,702
93.959 Block Grants for Prevention and Treatment of Substance Abuse $182,900
14.218 Community Development Block Grants/entitlement Grants $157,494
10.182 Pandemic Relief Activities: Local Food Purchase Assistance Cooperative Agreement (lfpa) $154,450
93.137 Community Programs to Improve Minority Health $138,632
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $98,731
97.024 Emergency Food and Shelter National Board Program $81,030
10.558 Child and Adult Care Food Program $60,698
10.568 Emergency Food Assistance Program (administrative Costs) $56,541
93.493 Congressional Directives $44,461
93.575 Child Care and Development Block Grant $33,980
93.566 Refugee and Entrant Assistance State/replacement Designee Administered Programs $26,530
21.027 Coronavirus State and Local Fiscal Recovery Funds $20,001
10.187 The Emergency Food Assistance Program (tefap) Commodity Credit Corporation Eligible Recipient Funds $18,891
93.597 Grants to States for Access and Visitation Programs $14,491
14.231 Emergency Solutions Grant Program $4,552
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $4,127