Finding 480932 (2018-003)

Material Weakness Repeat Finding
Requirement
J
Questioned Costs
-
Year
2018
Accepted
2024-08-12
Audit: 317044
Organization: City of Compton (CA)

AI Summary

  • Core Issue: The City lacks a complete and accurate listing of loans and loan balances, leading to non-compliance with CDBG program income reporting requirements.
  • Impacted Requirements: Failure to maintain proper loan records affects compliance with OMB 2 CFR Part 200 and related program rules, risking incorrect debtor account credits and unauthorized write-offs.
  • Recommended Follow-Up: Implement stronger internal controls, provide staff training, and establish a regular schedule for updating loan records to ensure accurate tracking of program income.

Finding Text

Criteria: The Office of Management and Budget (OMB) 2 CFR Part 200, Appendix XI section 4-14.218- 9 states: "The grantee must accurately account for any program income generated from the use of CDBG funds and must treat such income as additional CDBG funds which are subject to all program rules. "Making loans and collecting the payments on those loans can be a significant source of program income for grantees. The use of program income derived from loan payments is subject to program requirements. This carries with it the responsibility for grantees to have a loan origination and servicing system in effect which assures that loans are properly authorized, receivables are properly established, earned income is properly recorded and used, and write-offs of uncollectible amounts are properly authorized (24 CFR sections 570.500 and 570.504)." Condition: The City does not have a complete listing of loans and loan balances subject to repayment. The City therefore does not have a working schedule that captures a complete listing of expected receipts that will prompt the recording of program income. In addition, the loan receivable listing does not agree with the general ledger balance. Cause: Lack of internal controls, implementation, and adequate staff training on the maintenance of a complete listing and schedule of issued loans and running loan balances related to CDBG. Effect or Potential Effect: The Grants Division is not in compliance with grant requirements and grant income has not been properly reported. In addition, there's a possibility that loan payments received may not be credited to the correct debtor's account or that write-offs are made without proper approval. Questioned Cost: None Context: The City appears to have a partial listing of outstanding loans and loan repayment schedules, however, the repayment schedules have not been updated on a regular and timely basis, loan balances are not reconciled to the general ledger, and loan repayments are not being reconciled to reported program income. The completeness of program income cannot be assured as long as the City does not have a complete tracking of CDBG Section 108 loans and HOME loans outstanding. The loans receivable general ledger balance does not appear to be updated when payments are received. The recorded balance at June 30, 2018 is the same as June 30, 2017 and 2016. Our review indicated that no CDBG program income was reported from FYE 2009 through FYE 2016. In FYE 2017, program income for FYE 2012 through FYE 2016 was reported as program income along with some, but not all of the FYE 2017 program income. No CDBG program income was reported in FYE 2018. Repeat of a Prior-Year Finding: 2017-003

Corrective Action Plan

Recommendation: We recommend the City maintain a complete listing of outstanding loans and prepare and regularly use a master CDBG-related loan repayment schedule detailing all loans issued to monitor and capture loan repayments that would prompt the recording of program income as repayments are received. In addition, loans receivable should be reconciled to the general ledger on a regular periodic basis. This addresses COSO's Control Activities, Principle 10: selects & develops control activities and Principle 12: deploys control activities through policies and procedures Management Response and Corrective Action Plan City's Response: The City concurs with the recommendation Corrective Action Plan: The Controller's office will work with the Grants Division to implement tracking procedures, recording procedures and processes, creation of a centralized database that clearly identifies program income including loan repayments and provide training to staff on how to track, record and report program income. This system will be communicated to all staff members within Grants Division, City Controller's Office and Treasury Department to ensure all parties have access to the database, policies and procedures so they are able to properly code each payment in order to monitor the payment type and record the payment in the correct fiscal year. The Grants Division will create a CDBG procedures manual that documents policies and procedures designed to serve as the system of internal controls required by OMB's Uniform Guidance (2 CFR 200). In the meantime, the Grants and City Controller's departments will take steps to address the specific finding noted above. Planned Implementation Date: June 30, 2021 Responsible Person: Aubrey Relf, Grants Manager and Rafaela King, Controller

Categories

Program Income Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 480930 2018-001
    Material Weakness Repeat
  • 480931 2018-002
    Material Weakness Repeat
  • 480933 2018-004
    Material Weakness
  • 480934 2018-005
    Material Weakness
  • 480935 2018-006
    Material Weakness Repeat
  • 480936 2018-007
    Material Weakness Repeat
  • 480937 2018-008
    Material Weakness Repeat
  • 480938 2018-009
    Significant Deficiency Repeat
  • 480939 2018-010
    Material Weakness Repeat
  • 1057372 2018-001
    Material Weakness Repeat
  • 1057373 2018-002
    Material Weakness Repeat
  • 1057374 2018-003
    Material Weakness Repeat
  • 1057375 2018-004
    Material Weakness
  • 1057376 2018-005
    Material Weakness
  • 1057377 2018-006
    Material Weakness Repeat
  • 1057378 2018-007
    Material Weakness Repeat
  • 1057379 2018-008
    Material Weakness Repeat
  • 1057380 2018-009
    Significant Deficiency Repeat
  • 1057381 2018-010
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
14.871 Section 8 Housing Choice Vouchers $8.17M
14.218 Community Development Block Grants/entitlement Grants $614,545
14.239 Home Investment Partnership Program $282,232
14.218 Community Development Block Grants/state's Program $12,142
14.231 Emergency Shelter Grants Program $10,091
16.738 Edward Byrne Memorial Justice Assistance Grant $6,227