Finding 553860 (2022-007)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2025-04-03
Audit: 352548
Organization: So Consortium (OH)

AI Summary

  • Core Issue: Quarterly financial reports were filed late and lacked proper documentation, raising concerns about accuracy.
  • Impacted Requirements: Compliance with 2 CFR § 200.332(a)(3) and Ohio Admin. Code 5101:9-7-29 regarding timely submissions and financial reconciliations.
  • Recommended Follow-Up: Implement procedures to ensure reports are filed on time and supported by accurate accounting data.

Finding Text

2 CFR § 2900.4 gives regulatory effect to the U.S. Department of Labor for 2 CFR § 200.332(a)(3) which requires a pass-through entity to impose any additional requirements on the subrecipient necessary in order for the pass-through entity to meet its own responsibility to the Federal awarding agency including identification of any required financial and performance reports. Additionally, Ohio Admin. Code 5101:9-7-29 (D)(2)(c) requires WIOA local area fiscal agents to submit the completed quarterly financial statement to the Bureau of County Finance and Technical Assistance (BCFTA) no later than the tenth calendar day of the second month following the quarter the report represents. Ohio Admin. Code § 5101:9-7-29(D)(1)(b)(i) further requires the fiscal agent, when reviewing the quarterly financial data, to reconcile any difference between the WIOA local area's financial records and financial data submitted to BCFTA via CFIS. Ohio Admin Code § 5101:9-7-04(E) states in part that as expenditures are incurred, they become accrued expenses and shall be reported as accruals. Ohio Admin Code § 5101:9-7-04(F) provides that the WIOA local area shall maintain documentation in accordance with the records retention requirements in rule 5101:9-9-21 of the Administrative Code. This documentation may be subject to inspection, monitoring, and audit by ODJFS and the Ohio auditor of state. Due to the lack of effect control procedures over reporting, the following issues were noted related to the quarterly submissions: 1. The quarterly financial certification for the third quarter of calendar year 2021 was not filed until December 1, 2021, the fourth quarter of calendar year 2021 was not filed until February 14, 2022, the second quarter of calendar year 2022 was not filed until August 12, 2022, the third quarter of calendar year 2022 was not filed until November 16, 2022, the fourth quarter of calendar year 2022 was not filed until February 13, 2023. These were considered late filings. 2. The fiscal agent did not maintain quarterly certification on file for the first quarter of calendar year 2022. Copies had to be obtained from CFIS and those copies were not the originals signed by approving authorities. 3. For all submissions, the fiscal agent was unable to provide system reports from their accounting system that reconciled to the actual financial data (i.e. beginning balances, revenues, expenses, ending balances) submitted to BCFTA via CFIS. 4. For all submissions, the fiscal agent was unable to provide any support for the amounts they reported as accruals on the certifications. 5. The ending balance reported on the quarterly financial certification for the second quarter of calendar year 2022 did not agree to the beginning balance reported for the third quarter of calendar year 2022, the ending balance reported on the quarterly financial certification for the second quarter of calendar year 2021 does not agree to the beginning balance of the third quarter of calendar year 2021, the ending balance reported on the quarterly financial certification for the 4th quarter of calendar year 2021 did not agree to the beginning balance of the first quarter of calendar year 2022. 6. For the fourth quarter of 2021, the month to month beginning and ending balances do not agree. This could lead to questions regarding accuracy of the amounts reported to the Ohio Department of Job and Family Services. The Consortium should develop and implement procedures to ensure quarterly reports are filed no later than the tenth calendar day of the second month following the quarter the report represents. In addition, all data reported thru these quarterly reports should be supported by the accounting system of the Fiscal Agent.

Categories

Subrecipient Monitoring Reporting

Other Findings in this Audit

  • 553843 2022-004
    Material Weakness Repeat
  • 553844 2022-004
    Material Weakness Repeat
  • 553845 2022-004
    Material Weakness Repeat
  • 553846 2022-004
    Material Weakness Repeat
  • 553847 2022-004
    Material Weakness Repeat
  • 553848 2022-004
    Material Weakness Repeat
  • 553849 2022-005
    Material Weakness Repeat
  • 553850 2022-005
    Material Weakness Repeat
  • 553851 2022-005
    Material Weakness Repeat
  • 553852 2022-005
    Material Weakness Repeat
  • 553853 2022-005
    Material Weakness Repeat
  • 553854 2022-006
    Material Weakness Repeat
  • 553855 2022-007
    Material Weakness Repeat
  • 553856 2022-007
    Material Weakness Repeat
  • 553857 2022-007
    Material Weakness Repeat
  • 553858 2022-007
    Material Weakness Repeat
  • 553859 2022-007
    Material Weakness Repeat
  • 553861 2022-008
    Material Weakness
  • 553862 2022-008
    Material Weakness
  • 553863 2022-008
    Material Weakness
  • 553864 2022-008
    Material Weakness
  • 553865 2022-008
    Material Weakness
  • 553866 2022-008
    Material Weakness
  • 1130285 2022-004
    Material Weakness Repeat
  • 1130286 2022-004
    Material Weakness Repeat
  • 1130287 2022-004
    Material Weakness Repeat
  • 1130288 2022-004
    Material Weakness Repeat
  • 1130289 2022-004
    Material Weakness Repeat
  • 1130290 2022-004
    Material Weakness Repeat
  • 1130291 2022-005
    Material Weakness Repeat
  • 1130292 2022-005
    Material Weakness Repeat
  • 1130293 2022-005
    Material Weakness Repeat
  • 1130294 2022-005
    Material Weakness Repeat
  • 1130295 2022-005
    Material Weakness Repeat
  • 1130296 2022-006
    Material Weakness Repeat
  • 1130297 2022-007
    Material Weakness Repeat
  • 1130298 2022-007
    Material Weakness Repeat
  • 1130299 2022-007
    Material Weakness Repeat
  • 1130300 2022-007
    Material Weakness Repeat
  • 1130301 2022-007
    Material Weakness Repeat
  • 1130302 2022-007
    Material Weakness Repeat
  • 1130303 2022-008
    Material Weakness
  • 1130304 2022-008
    Material Weakness
  • 1130305 2022-008
    Material Weakness
  • 1130306 2022-008
    Material Weakness
  • 1130307 2022-008
    Material Weakness
  • 1130308 2022-008
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
17.258 Wia Adult Program $2.31M
17.277 Workforce Investment Act (wia) National Emergency Grants $1.22M
17.278 Wia Dislocated Worker Formula Grants $1.10M
17.259 Wia Youth Activities $477,315
93.788 Opioid Str $178,115
17.225 Unemployment Insurance $101,963
17.207 Employment Service/wagner-Peyser Funded Activities $9,589
17.245 Trade Adjustment Assistance $1,497