Finding Text
CONDITION: During the calendar year 2022, the City did not record the necessary adjustments to the various ‘Fund’ general ledgers of the City to properly reconcile the balance sheet accounts, such as cash, receivables, payables, and payroll-related liabilities to the underlying supporting documentation available at the City (which includes reconciliations of cash prepared independently by City personnel but do not agree to amounts reported in the various general ledgers). This included ‘Funds” containing significant federal funding such as the City’s Community Development Block Grant (CDBG) Program and American Rescue Plan Act (ARPA) funding known as the Coronavirus State and Local Fiscal Recovery Fund. As a result, the financial position and results of operations as shown throughout the calendar year were inaccurately stated. However, it should be noted that the Community Development Department of the City and other City personnel maintain separate financial reporting for these federal funds, independent of the aforementioned ‘Fund’ general ledgers sufficient to ascertain the revenues and expenditures of the federal programs. This is a repeat finding (2021-001) from the prior year.
CRITERIA: Prudent internal control procedures in the areas of general ledger management and financial reporting include the reconciliation of all general ledger account balances to underlying supporting documentation monthly with independent oversight and approval as part of the process.
In specific as it relates to federal programs, Section 2 CFR 200.403(g) of the Uniform Guidance requires that federal costs must be adequately documented which would include the applicable general ledgers of the City. EFFECT: The lack of procedures in place for reconciling balance sheet accounts throughout the calendar year, with independent oversight, 1) reduces the City’s internal control over the financial reporting processes, 2) exposes the City to inaccurate financial reporting to management for decision-making purposes, and 3) increases the potential for irregularities that may result (unintentional or otherwise) that are not detected in a timely manner. Had these reconciliations been performed, issues such as non-postings, and inaccurate postings to the City’s various general ledgers could have been detected and corrected in a timely manner to enhance internal controls and financial reporting in this important area of financial management. As a result, the City is not incompliance with Section 2 CFR 200.403(g) of the Uniform Guidance which requires federal costs to be adequately documented in the applicable general ledgers of the City.
CAUSE: City business office personnel perform a variety of duties such as accounting for deposits, invoice processing, reconciliation of cash (but not to the various general ledger accounts of the City), preparation of payroll, and posting of financial transactions to the City’s general ledgers. However, no one individual is responsible for managing and reconciling all of the aforementioned procedures to the various ‘Fund’ general ledgers at the City.
RECOMMENDATION: I am recommending that the management of the City establish written procedures for all accounting functions, but most notably for recording the necessary adjustments to the City’s general ledgers throughout the calendar year (monthly) to ensure that all balance sheet account balances are supported by the underlying documentation available at the City. It is anticipated that additional training will be required for in-house personnel to perform this function, or the City may want to consider contracting these services to a third-party professional with the expertise to perform these functions for the City on a monthly or quarterly basis throughout the year. These procedures should significantly enhance the internal control over the financial accounting and reporting process relative to the City’s general ledgers for each Fund.
VIEWS OF RESPONSIBLE OFFICIALS: The City concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.