Finding 572118 (2024-001)

Material Weakness Repeat Finding
Requirement
ABCEHI
Questioned Costs
-
Year
2024
Accepted
2025-07-29
Audit: 363263
Organization: Livingston Parish Council (LA)

AI Summary

  • Core Issue: The Parish failed to prepare a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) as required by federal regulations.
  • Impacted Requirements: The SEFA lacked necessary details such as total federal awards, Assistance Listing Numbers, and accurate expenditure reporting, leading to noncompliance with federal reporting standards.
  • Recommended Follow-Up: Improve policies for financial reporting, define roles clearly, implement monthly reconciliations, and ensure all journal entries are reviewed by management to prevent future errors.

Finding Text

Criteria: Per 2 CFR § 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. The SEFA must be complete and accurate and include the total federal awards expended, the Assistance Listing Numbers (ALNs), the name of the federal agency, and any amounts provided to subrecipients. Condition: The SEFA was not prepared as prescribed by 2CFR Part 200.510(b) of the Uniform Guidance. The Parish did not have adequate internal controls in place to ensure the accurate and complete preparation of the SEFA. Specifically, the federal expenditure data provided for audit omitted multiple federal awards, contained inaccuracies in reported expenditures for multiple programs, did not allocate the federal and local cost share accurately, and amounts reported did not adequately trace back to the Parish’s financial reporting system. Cause: The deficiencies were caused by a lack of updated formal policies and procedures for gathering and reconciling federal expenditures across departments. Additionally, there was insufficient review by management to ensure the completeness and accuracy of the SEFA. The Parish experienced turnover in several departments, including the finance director/chief financial officer position in 2024. During the time of the transition, there were various accounting issues identified that required a significant amount of time and resources to address. Parish administration and management were immediately tasked with enhancing operations related to procedural concerns from the prior administration and performing the accounting function without sufficient documentation on several balances and transactions. Effect: As a result, the Parish provided incomplete and inaccurate data when preparing the SEFA which resulted in the Parish excluding federal awards and misstating expenditures and being noncompliant with federal reporting requirements. These errors required material adjustments to be made during the audit process, increasing the risk of misreporting to oversight agencies. Recommendation: We recommend that the Parish enhance policies and procedures over financial reporting and preparation of the SEFA so that duties are well defined, and responsibilities are properly outlined to assist periods of transition or turnover of key employees, as well as identifying and correcting errors on a more frequent basis through a monthly reconciliation process for all material and/or significant account balances. Additionally, we recommend that all journal entries proposed are reviewed and approved by the chief financial officer or designee.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 572100 2024-001
    Material Weakness Repeat
  • 572101 2024-002
    Material Weakness Repeat
  • 572102 2024-003
    Significant Deficiency
  • 572103 2024-001
    Material Weakness Repeat
  • 572104 2024-002
    Material Weakness Repeat
  • 572105 2024-001
    Material Weakness Repeat
  • 572106 2024-002
    Material Weakness Repeat
  • 572107 2024-001
    Material Weakness Repeat
  • 572108 2024-002
    Material Weakness Repeat
  • 572109 2024-001
    Material Weakness Repeat
  • 572110 2024-002
    Material Weakness Repeat
  • 572111 2024-004
    Material Weakness
  • 572112 2024-001
    Material Weakness Repeat
  • 572113 2024-002
    Material Weakness Repeat
  • 572114 2024-001
    Material Weakness Repeat
  • 572115 2024-002
    Material Weakness Repeat
  • 572116 2024-001
    Material Weakness Repeat
  • 572117 2024-002
    Material Weakness Repeat
  • 572119 2024-002
    Material Weakness Repeat
  • 572120 2024-001
    Material Weakness Repeat
  • 572121 2024-002
    Material Weakness Repeat
  • 572122 2024-001
    Material Weakness Repeat
  • 572123 2024-002
    Material Weakness Repeat
  • 572124 2024-001
    Material Weakness Repeat
  • 572125 2024-002
    Material Weakness Repeat
  • 572126 2024-001
    Material Weakness Repeat
  • 572127 2024-002
    Material Weakness Repeat
  • 572128 2024-001
    Material Weakness Repeat
  • 572129 2024-002
    Material Weakness Repeat
  • 572130 2024-001
    Material Weakness Repeat
  • 572131 2024-002
    Material Weakness Repeat
  • 572132 2024-001
    Material Weakness Repeat
  • 572133 2024-002
    Material Weakness Repeat
  • 572134 2024-001
    Material Weakness Repeat
  • 572135 2024-002
    Material Weakness Repeat
  • 1148542 2024-001
    Material Weakness Repeat
  • 1148543 2024-002
    Material Weakness Repeat
  • 1148544 2024-003
    Significant Deficiency
  • 1148545 2024-001
    Material Weakness Repeat
  • 1148546 2024-002
    Material Weakness Repeat
  • 1148547 2024-001
    Material Weakness Repeat
  • 1148548 2024-002
    Material Weakness Repeat
  • 1148549 2024-001
    Material Weakness Repeat
  • 1148550 2024-002
    Material Weakness Repeat
  • 1148551 2024-001
    Material Weakness Repeat
  • 1148552 2024-002
    Material Weakness Repeat
  • 1148553 2024-004
    Material Weakness
  • 1148554 2024-001
    Material Weakness Repeat
  • 1148555 2024-002
    Material Weakness Repeat
  • 1148556 2024-001
    Material Weakness Repeat
  • 1148557 2024-002
    Material Weakness Repeat
  • 1148558 2024-001
    Material Weakness Repeat
  • 1148559 2024-002
    Material Weakness Repeat
  • 1148560 2024-001
    Material Weakness Repeat
  • 1148561 2024-002
    Material Weakness Repeat
  • 1148562 2024-001
    Material Weakness Repeat
  • 1148563 2024-002
    Material Weakness Repeat
  • 1148564 2024-001
    Material Weakness Repeat
  • 1148565 2024-002
    Material Weakness Repeat
  • 1148566 2024-001
    Material Weakness Repeat
  • 1148567 2024-002
    Material Weakness Repeat
  • 1148568 2024-001
    Material Weakness Repeat
  • 1148569 2024-002
    Material Weakness Repeat
  • 1148570 2024-001
    Material Weakness Repeat
  • 1148571 2024-002
    Material Weakness Repeat
  • 1148572 2024-001
    Material Weakness Repeat
  • 1148573 2024-002
    Material Weakness Repeat
  • 1148574 2024-001
    Material Weakness Repeat
  • 1148575 2024-002
    Material Weakness Repeat
  • 1148576 2024-001
    Material Weakness Repeat
  • 1148577 2024-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $7.67M
15.435 Gomesa $960,686
97.039 Hazard Mitigation Grant $511,594
20.509 Formula Grants for Rural Areas and Tribal Transit Program $289,035
97.029 Flood Mitigation Assistance $277,658
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $94,777
97.067 Homeland Security Grant Program $74,503
93.069 Public Health Emergency Preparedness $44,797
20.205 Highway Planning and Construction $16,735
97.042 Emergency Management Performance Grants $13,879
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $5,575
81.128 Energy Efficiency and Conservation Block Grant Program (eecbg) $1,777