Finding 393695 (2023-003)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
-
Year
2023
Accepted
2024-04-18

AI Summary

  • Core Issue: Cost allocations in grant reports did not match the underlying accounting records.
  • Impacted Requirements: Costs must be based on a cost allocation plan and align with accounting records for reimbursement.
  • Recommended Follow-Up: Implement controls to ensure all grant reports reconcile with accounting records.

Finding Text

2023-003 REPORTING ALLOWABLE/ALLOCABLE COSTS Grantors: U.S Department of Housing and Urban Development Award Names: Emergency Solutions Grant /Community Development Block Grant /Continuum of Care Award Year: Various Award Numbers: Various Assistance Listing Numbers: 14.231 / 14.228 / 14.267 Criteria: Costs reported and submitted for reimbursement should be based on a cost allocation plan and agree to the underlying accounting records. Condition: During our audit testing, we noted cost allocations included on submitted grant reports did not reconcile directly back to what was allocated in the underlying accounting records (general ledger). Cause: No individuals at the Center were periodically performing reconciling and other activities which would have served to ensure the cost allocation plan and underlying accounting records were in line and consistent with what was being reported to grantors. Effect: The amount of allocated costs reported and reimbursed by grantors could not be readily traced back to the underlying accounting records (general ledger). Questioned Costs: None noted. Recommendation: The Center should implement controls to ensure all reporting and requests for reimbursements submitted to grantors reconcile with the underlying accounting records as allocated. Management’s Views and Corrective Action Plan: Management agrees with this finding and has outlined its resulting actions in a separately issued Corrective Action Plan.

Corrective Action Plan

Finding 2023-003 REPORTING ALLOWABLE/ALLOCABLE COSTS We have made progress in allocating allowable costs to specific contracts in our accounting system. Last year we implemented a detailed customer/job tracking capacity in QuickBooks and have created a coding system to match all income, payroll costs and most other types of spending to specific customer/jobs. As the audit indicated, however, we continue to face challenges in properly assigning some shared costs (such as fringe benefits and utilities in shared facilities) to specific contracts in our accounting system. Costs were incurred and supported the operation of the contracts reviewed but we recognize that we need further improvement in how we allocate these costs to individual contracts in our accounting records. We will modify our financial procedures to document our allocation approach for fringe benefits and shared cost. We will also and put new controls in place to monitor cost allocation by contract (where required) on a quarterly basis. All improvements in accounting by customer/job will be implemented for the full fiscal year ended June 30, 2024. Finding 2023-

Categories

Allowable Costs / Cost Principles Cash Management Reporting

Other Findings in this Audit

  • 393696 2023-004
    Material Weakness Repeat
  • 393697 2023-003
    Material Weakness Repeat
  • 393698 2023-004
    Material Weakness Repeat
  • 393699 2023-003
    Material Weakness Repeat
  • 393700 2023-004
    Material Weakness Repeat
  • 970137 2023-003
    Material Weakness Repeat
  • 970138 2023-004
    Material Weakness Repeat
  • 970139 2023-003
    Material Weakness Repeat
  • 970140 2023-004
    Material Weakness Repeat
  • 970141 2023-003
    Material Weakness Repeat
  • 970142 2023-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
14.231 Emergency Solutions Grant Program $487,189
64.024 Va Homeless Providers Grant and Per Diem Program $248,819
21.026 Homeowner Assistance Fund $179,505
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $133,606
93.667 Social Services Block Grant $113,318
21.023 Emergency Rental Assistance Program $61,000
97.024 Emergency Food and Shelter National Board Program $46,000
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $44,550
21.027 Coronavirus State and Local Fiscal Recovery Funds $33,457
93.150 Projects for Assistance in Transition From Homelessness (path) $33,360
14.871 Section 8 Housing Choice Vouchers $30,178
16.736 Transitional Housing Assistance for Victims of Domestic Violence, Dating Violence, Stalking, Or Sexual Assault $1,800
14.267 Continuum of Care Program $213