Finding 1176278 (2023-001)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2026-03-03
Audit: 390127
Organization: CITY OF FARRELL (PA)

AI Summary

  • Core Issue: The City failed to make necessary adjustments to general ledgers, leading to inaccurate financial statements for 2023.
  • Impacted Requirements: This lack of reconciliation violates prudent internal control practices and Section 2 CFR 200.403(g) regarding federal cost documentation.
  • Recommended Follow-Up: Establish written procedures for monthly reconciliations and consider training staff or hiring external experts to improve financial reporting and compliance.

Finding Text

CONDITION: During the calendar year 2023, the City did not record the necessary adjustments to the various ‘Fund’ general ledgers of the City to properly reconcile certain balance sheet accounts, such as interfund receivables and payables, and payroll-related liabilities to the underlying supporting documentation available at the City. This included the City’s Community Development Block Grant (CDBG) Program. As a result, the financial position and results of operations as shown throughout the calendar year were inaccurately stated. 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 City’s Federal Programs general ledger which accounts for the financial activity of the City’s Community Development Block Grant Program. 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, 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: During calendar year 2023, the City does not employ an in-house accountant with the requisite skills necessary to manage and reconcile the various interfund receivables and payables, and payroll-related liabilities to the underlying supporting documentation available 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.

Corrective Action Plan

CONDITION: During the calendar year 2023, the City did not record the necessary adjustments to the various ‘Fund’ general ledgers of the City to properly reconcile certain balance sheet accounts, such as interfund receivables and payables, and payroll-related liabilities to the underlying supporting documentation available at the City. This included the City’s Community Development Block Grant (CDBG) Program. As a result, the financial position and results of operations as shown throughout the calendar year were inaccurately stated. 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 City’s Federal Programs general ledger which accounts for the financial activity of the City’s Community Development Block Grant Program.MANAGEMENT’S CORRECTIVE ACTION PLAN: Management of the City is reviewing the options as presented by the Audit Firm’s recommendation for feasibility considering current manpower, expertise, and budgetary constraints. In addition, the City plans to ensure that written procedures for all accounting functions are implemented, reviewed and updated as necessary with the objective of ensuring that all applicable balance sheet account balances are accurate and supported by the underlying documentation available at the City. The City is currently in continuous communication with the Audit Firm for specific recommendations regarding the handling of interfund receivables and payables, and payroll-related liabilities, so as to ensure the accuracy of the City’s financial reporting. The timeframe for completion of this review will occur during the first six months of calendar year 2026 with the intention of having the City be in full compliance with Section 2 CFR 200.403(g) of the Uniform Guidance which requires federal costs to be adequately documented which would include the applicable general ledgers of the City.

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties Reporting

Other Findings in this Audit

  • 1176271 2023-001
    Material Weakness Repeat
  • 1176272 2023-001
    Material Weakness Repeat
  • 1176273 2023-001
    Material Weakness Repeat
  • 1176274 2023-001
    Material Weakness Repeat
  • 1176275 2023-001
    Material Weakness Repeat
  • 1176276 2023-001
    Material Weakness Repeat
  • 1176277 2023-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $62,231
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $51,133