Finding 480934 (2018-005)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2018
Accepted
2024-08-12
Audit: 317044
Organization: City of Compton (CA)

AI Summary

  • Core Issue: The City lacks adequate documentation and tracking for IDIS drawdown requests, leading to discrepancies in reported expenditures.
  • Impacted Requirements: Compliance with OMB 2 CFR Part 200, which mandates proper documentation and tracking of federal award costs.
  • Recommended Follow-Up: Implement stronger internal controls for logging and reconciling drawdowns to ensure compliance and prevent unallowed transactions.

Finding Text

Criteria: The Office of Management and Budget (OMB) 2 CFR Part 200, Appendix XI, Compliance Supplement 2017, sections 3.2-B-12 and 3.2-B-14, respectively, state: "The individual State/local government/Indian tribe departments or agencies (also known as "operating agencies") are responsible for the performance or administration of Federal awards. In order to receive cost reimbursement under Federal awards, the department or agency usually submits claims asserting that allowable and eligible costs (direct and indirect) have been incurred in accordance with 2 CFR part 200, subpart E." "Costs did not consist of improper payments, including (1) payments that should not have been made or that were made in incorrect amounts (including overpayments and underpayments) under statutory, contractual, administrative, or other legally applicable requirements" and "costs were adequately documented." Condition: The City does not maintain adequate supporting documentation for its IDIS drawdown requests to explain and support program reimbursement requests. The City does not have a system in place for the ongoing tracking of drawdowns in line with a regular review and reconciliation of the general ledger. We noted a difference of $84,286 between City recorded expenditures per the general ledger and the total drawdowns for the current program year in IDIS. Upon further review, we noted a difference of $33,086 between the IDIS drawdowns and the total award expenditures per the general ledger that could not be reconciled. In addition, the City was not able to provide adequate documentation for administrative costs of $37,727. Cause: Lack of internal controls over the logging of drawdown records prior to processing the vouchers for reimbursement in IDIS. Effect or Potential Effect: The oversight of the drawn voucher in IDIS for Federal grant reimbursement exposes the City to underlying implications that such transactions may get through without appropriate review and authorization. This may lead to the posting of unallowed transactions that would be noncompliant to the program requirements. Questioned Cost: CDBG Administration drawdown of $70,813. Context: Upon the review of the current year IDIS drawdowns to the actual award expenditures per the general ledger, an irreconcilable difference of $33,086 was noted related to administrative costs. Further review led to a voucher submitted to IDIS for administrative costs that did not get recorded in the City's internal running log of drawdowns and did not have supporting documentation. A form of support was provided not in a timely manner, i.e. a month after initial request, indicating a lack of internal controls over the maintenance and reconciliation of actual IDIS drawdowns and the running drawdown log. Repeat of a Prior-Year Finding: No

Corrective Action Plan

Recommendation: We recommend the City maintain complete and accurate supporting documentation for IDIS drawdowns to provide support that only allowable costs are being claimed for reimbursement. This addresses COSO's Control Activities, Principle 12: deploys through policies & procedures and Information & Communication, Principle 13: obtains and uses quality information, Principle 15: communicates externally. Corrective Action Plan: The Controller's office will work with the Grants Division to implement tracking procedures, recording accounting procedures and processes, monthly IDIS reconciliation process and creation of a centralized database that tracks all IDIS drawdown requests. The Grants Division will incorporate this new procedure and process into a new CDBG procedures manual. The City will create a 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, City Grants Manager and Rafaela King, Controller

Categories

Questioned Costs Cash Management Internal Control / Segregation of Duties

Other Findings in this Audit

  • 480930 2018-001
    Material Weakness Repeat
  • 480931 2018-002
    Material Weakness Repeat
  • 480932 2018-003
    Material Weakness Repeat
  • 480933 2018-004
    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