Finding 517161 (2023-002)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-12-30
Audit: 335122
Organization: County of Caldwell (TX)

AI Summary

  • Core Issue: Revenue is being recorded incorrectly in a general receivable account instead of the appropriate revenue account.
  • Impacted Requirements: This misposting leads to inaccurate financial statements, resulting in understated revenues reported to the Commissioners’ Court.
  • Recommended Follow-Up: The County Treasurer should ensure proper posting of revenues, improve staff training, and enhance segregation of duties to minimize errors.

Finding Text

Criteria - A primary control over accurate financial statements is the timely and accurate recording of each receipt of revenue to the appropriate revenue account within the accounting software. Condition – The Treasurer’s Deputy Clerk posts the daily receipts to a general receivable account in the accounting software rather than the appropriate revenue account in the accounting software. The County Auditor’s department then allocates the revenue to the appropriate account by journal entry. Effect – Inaccurate financial information was provided to Commissioners’ Court as revenue was recorded to the accounts receivable account rather than the revenue account in the accounting software system. Therefore, revenues were understated throughout the year. Cause – The Treasurer is recording the revenue as a receivable in the balance sheet account rather than a revenue in the Statement of Revenues and Expenditures. The County Auditor is then correcting the entries at a later date. Recommendation – The County Treasurer should be posting all revenues to the appropriate accounts on the Statement of Revenues and Expenditures. They should only post to the Balance Sheet accounts when transactions are directly related. Segregation of duties should be improved and staff should be appropriately trained to avoid excessive journal entries. The auditor’s office should be auditing these transactions not performing them. The County Treasurer and assistants should receive additional training in recording revenue (with continued support from outside professionals, if necessary), until revenue is recorded correctly within the software system.

Corrective Action Plan

An action plan includes the County Auditor’s office/System Administrator streamlining the revenue coding and creating a template for a more user friendly format and cross training purposes. The County Auditor’s office/System Administrator is working with the software company to interface the system into the main software to have less data entry by the County Treasurer’s office, thus preventing errors. The County Auditor’s office has met with the Departments as well as the County Treasurer’s office to develop a “revenue sheet” for each department which has each revenue and liability with the corresponding general ledger account numbers. Each department will fill this in and send to the Treasurer’s office. This will be directly recorded by the County Treasurer’s office. The County Auditor’s office is also looking into the ability to upload data from the other departments.

Categories

Internal Control / Segregation of Duties

Other Findings in this Audit

  • 517160 2023-001
    Material Weakness Repeat
  • 517162 2023-003
    Material Weakness
  • 517163 2023-004
    Significant Deficiency Repeat
  • 1093602 2023-001
    Material Weakness Repeat
  • 1093603 2023-002
    Material Weakness Repeat
  • 1093604 2023-003
    Material Weakness
  • 1093605 2023-004
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.39M
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $394,165
16.593 Residential Substance Abuse Treatment for State Prisoners $34,550
90.404 Hava Election Security Grants $16,823
16.606 State Criminal Alien Assistance Program $6,666