Finding 1227290 (2025-003)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-08-18

AI Summary

  • Core Issue: Inaccurate grant reporting due to misclassification of internal program transfers and lack of review.
  • Impacted Requirements: Federal reporting criteria not met, leading to discrepancies between the general ledger and required reports.
  • Recommended Follow-Up: Implement stronger internal controls, ensure proper training, and conduct thorough reviews of reports before submission.

Finding Text

2025-003 – Grant Reporting (repeat finding) Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds; U.S. Department of Treasury; ALN 21.027, Small Business Support Hubs Program passed through the Michigan Strategic Fund. Criteria. The federal reporting requirements for this program are only applicable to the primary recipient. However, the pass-through grant agreement stipulates that the following reports are required: (1) State Progress Report, Due October 10, (2) Federal Quarterly Reports, Due January 10, April 10, July 7 and October 10, and (3) Federal Annual Report, Due July 7. Condition. Reporting did not agree to the audited general ledger or to the schedule of expenditures of federal awards (SEFA) due to: 1) Management recording in the general ledger and reporting to the pass-through agency, amounts that were transfers to an internal program, the actual costs of which were being reported under a separate cost center. Because transfers to an internal program do not qualify as grant expenditures or, for that matter expenses in general, the amounts reported as cumulative expenditures of grant funds were reported inaccurately and required adjustment as part of the consolidated financial statement audit, and 2) Audit adjustments were necessary to adjust subrecipient expenses per the general ledger to actual costs per the subrecipient reporting and back up files. In the initial general ledger, the balance of advances from the prior year, plus advances paid to subrecipients during the year, were recorded as grant expenses. In addition, we noted that the reports did not appear to be reviewed for accuracy or completeness. Cause. The errors in the reporting were due to inadequate internal controls over the grant management process, including lack of proper training for personnel responsible for preparing and submitting the reports and lack of management oversight over this grant management process. Effect. As a result of this condition, the Organization reported inaccurate amounts to the grant pass-through agency. Questioned Costs. No costs were required to be questioned as a result of this finding inasmuch as our testing did not identify any unallowed costs. Recommendation. We recommend that management continue reviewing all refundable advances associated with revenues, and those made to subrecipients, particularly around year-end, to identify amounts that should be recorded as refundable advances and what amounts should be recorded as grant expenses. This is important because the general ledger can then be used as a base for all grant financial reporting. We further recommend that the reporting be reconciled to the schedule of expenditures of federal awards at year-end. In addition, all reports should be reviewed and approved by appropriate personnel prior to submission. View of Responsible Officials. Management accepts this finding and prepared a Corrective Action Plan.

Corrective Action Plan

Finding Type: Immaterial Noncompliance / Significant Deficiency in Internal Control over Compliance (Reporting). Program: Coronavirus State and Local Fiscal Recovery Funds; U.S. Department of Treasury; ALN 21.027, Small Business Support Hubs Program passed through the Michigan Strategic Fund. Auditor Description of Condition and Effect: Reporting did not agree to the audited general ledger or to the schedule of expenditures of federal awards (SEFA) due to: 1) Management recording in the general ledger and reporting to the pass-through agency, amounts that were transfers to an internal program, the actual costs of which were being reported under a separate cost center. Because transfers to an internal program do not qualify as grant expenditures or, for that matter expenses in general, the amounts reported as cumulative expenditures of grant funds were reported inaccurately, and 2) Audit adjustments were necessary to adjust subrecipient expenses per the general ledger to actual costs per the subrecipient reporting and back up files. In the initial general ledger, the balance of advances from the prior year, plus advances paid to subrecipients during the year, were incorrectly recorded as grant expenses. In addition, we noted that the reports did not appear to be reviewed for accuracy or completeness. As a result of this condition, the Organization reported inaccurate amounts to the grant pass-through agency. Questioned Costs: No costs were required to be questioned as a result of this finding inasmuch as our testing did not identify any unallowed costs. Auditor Recommendation: We recommend that management continue reviewing all transfers to an internal program, refundable advances associated with revenues, and those made to subrecipients, particularly around year-end, to identify amounts that should be recorded as refundable advances and what amounts should be recorded as grant expenses. This is important because the general ledger can then be used as a base for all grant financial reporting. We further recommend that the reporting be reconciled to the schedule of expenditures of federal awards at year-end. In addition, all reports should be reviewed and approved by appropriate personnel prior to submission. Management's Acknowledgment Management acknowledges that the root cause — the general ledger not serving as a clean, reliable basis for grant financial reporting without manual correction — reflects a structural accounting setup issue compounded by insufficient oversight of the reporting workflow. The core distinction between internal transfers, subrecipient advances, and actual incurred costs must be consistently reflected in GL coding from the point of transaction entry. The SOP's reporting and reconciliation provisions are only effective if the underlying GL data is structured correctly. Corrective Action Plan (see table)

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1227289 2025-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $1.49M
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $104,396