Finding 559934 (2023-001)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2025-05-08

AI Summary

  • Core Issue: There was a failure to provide timely year-end trial balances, leading to significant adjustments and inaccuracies in financial reporting.
  • Impacted Requirements: This situation violates U.S. GAAP and 2 CFR Section 200.512(a)(1), affecting the accuracy and compliance of financial statements.
  • Recommended Follow-Up: Implement a structured monthly closing process, ensure timely reconciliations, and consider staffing needs to support accurate accounting practices.

Finding Text

Finding #2023-001 – Material Weakness – Accounting Recordkeeping All Programs Other Criteria Accounting tasks such as timely monthly analysis, reconciliations and review of accounts play a key role in providing the accuracy of accounting data and information included in the interim and year-end financial statements. Trial balances should be maintained for the Organization continuously, in accordance with U.S. GAAP. Detailed supporting schedules should be maintained for all significant asset, liability, revenue and expense accounts. Reconciling items should be investigated and resolved in a timely manner. All of the forementioned items are essential to ensure that financial statements and data collection forms are submitted in conformance with 2 CFR Section 200.512(a)(1). Condition During the year ended June 30, 2023, management was unable to provide timely year-end trial balances in accordance with U.S. GAAP without significant adjusting journal entries required to accurately reflect the underlying accounting transactions. Cause The significant delay was caused primarily due to significant turnover in personnel within the accounting/finance department and efforts related to a merger between HopePHL and Youth Service, Inc., which resulted in a backlog of recording transactions, and in reconciliations not being performed timely. Effects Not performing timely and complete monthly and year-end account reconciliations and closing procedures leads to a continually and growing backlog of transactions and journal entries that are not posted to the accounting system, which renders the accounting information ineffective for making well-informed business decisions. This has led to the expenditure of significant time and effort by many to complete the required reconciliation procedures and prevented the timely delivery of financial statements to management, board members and funders. In addition, this led to the Organization to be noncompliant with required deadlines for Uniform Guidance and Data Collection Form submission. Questions Costs None. Perspective This audit finding is systematic. Statistical Sample A statistical sample is not applicable to this finding. Repeat Finding This audit finding is not a repeat finding. Recommendation We recommend that individuals overseeing the accounting and finance department continue to review the Organization's current accounting policies and update existing policies or implement new policies, as needed, to ensure that the trial balances are accurately maintained throughout the year, reconciliations are completed and reviewed monthly or quarterly, as appropriate, and the trial balances and related supporting schedules are prepared and reviewed timely after year-end. Views of Responsible Officials Management agrees with the finding. Management has implemented a structured monthly closing process to ensure timely and accurate recording of transactions. All balance sheet accounts will be reconciled by the 15th day of the following month. We will develop and implement a month-end and year-end closing checklist based on U.S. GAAP and, as necessary, any city, state, or federal reporting requirements. We are also evaluating current staffing levels to determine if there is a need to hire additional personnel or retain external accounting support during the year-end closing process. We will conduct a pre-closing review in the 4th quarter to identify and resolve discrepancies prior to year-end. We will also prepare a preliminary trial balance and draft financial statements by July 31 to allow sufficient time for audit fieldwork. The Finance Committee of the HopePHL Board of Directors will receive quarterly updates on the status of the monthly financial closing process.

Categories

Material Weakness Reporting

Other Findings in this Audit

  • 559920 2023-001
    Material Weakness
  • 559921 2023-001
    Material Weakness
  • 559922 2023-001
    Material Weakness
  • 559923 2023-001
    Material Weakness
  • 559924 2023-001
    Material Weakness
  • 559925 2023-001
    Material Weakness
  • 559926 2023-001
    Material Weakness
  • 559927 2023-001
    Material Weakness
  • 559928 2023-001
    Material Weakness
  • 559929 2023-001
    Material Weakness
  • 559930 2023-001
    Material Weakness
  • 559931 2023-001
    Material Weakness
  • 559932 2023-001
    Material Weakness
  • 559933 2023-001
    Material Weakness
  • 1136362 2023-001
    Material Weakness
  • 1136363 2023-001
    Material Weakness
  • 1136364 2023-001
    Material Weakness
  • 1136365 2023-001
    Material Weakness
  • 1136366 2023-001
    Material Weakness
  • 1136367 2023-001
    Material Weakness
  • 1136368 2023-001
    Material Weakness
  • 1136369 2023-001
    Material Weakness
  • 1136370 2023-001
    Material Weakness
  • 1136371 2023-001
    Material Weakness
  • 1136372 2023-001
    Material Weakness
  • 1136373 2023-001
    Material Weakness
  • 1136374 2023-001
    Material Weakness
  • 1136375 2023-001
    Material Weakness
  • 1136376 2023-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
14.267 Continuum of Care Program $1.14M
93.667 Social Services Block Grant $695,252
84.425 Education Stabilization Fund $166,363
14.231 Covid-19 - Emergency Solutions Grant Program $77,787
16.736 Transitional Housing Assistance for Victims of Domestic Violence, Dating Violence, Stalking, Or Sexual Assault $75,938
10.558 Child and Adult Care Food Program $45,450
97.024 Emergency Food and Shelter National Board Program $30,000
14.252 Section 4 Capacity Building for Community Development and Affordable Housing $17,000
14.218 Community Development Block Grants/entitlement Grants $14,612
45.024 Promotion of the Arts Grants to Organizations and Individuals $12,000