Finding 588823 (2022-008)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-01-05

AI Summary

  • Issue: Reimbursement requests were submitted late, with some being 80 days overdue, leading to inaccurate revenue records.
  • Requirements: Timely submission and reconciliation of reimbursements to the general ledger are essential for accurate financial reporting.
  • Follow-up: Review tracking spreadsheets for grant awards and expenditures with knowledgeable staff to ensure accurate reporting and reconciliation.

Finding Text

Condition: Requests for reimbursement were not submitted timely, with multiple months submitted 80 days after the expenditure had incurred. Amounts recorded for revenue did not accurately reflect final requested reimbursement. Criteria: Reimbursements should be submitted timely and should be provided and reconciled to financial data in general ledger by accounting team. Differences should be resolved, and reimbursement received should ultimately reflect total program revenue in general ledger. Cause: With turnover in staff during the year, items were not always available timely. In addition, management was not always aware of reporting requirements or aware of activity under program reimbursements. Effect: Errors in reporting could ultimately lead to differences in financial accounting vs program activity. Accurate and timely reporting and requests can improve cash flows and ensure program is able to meet funding needs. Recommendation: Additionally, spreadsheets used to track grant awards and program expenditures should be reviewed by someone with an understanding of the program such as the Behavioral Health Director or another individual in the finance department. These spreadsheets should ultimately identify amounts that were submitted for request for reimbursement and be recorded in the general ledger. Amounts recorded for revenue in the general ledger should agree between the two, with monthly or quarterly reconciliations performed to ensure financial reporting accurately reflects spending reimbursement activity.

Categories

Cash Management Reporting

Other Findings in this Audit

  • 12380 2022-007
    Material Weakness Repeat
  • 12381 2022-008
    Material Weakness
  • 588822 2022-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
14.231 Emergency Solutions Grant Program $1.52M
93.959 Block Grants for Prevention and Treatment of Substance Abuse $633,380
93.788 Opioid Str $630,075
93.498 Provider Relief Fund $272,008
14.267 Continuum of Care Program $225,796
93.958 Block Grants for Community Mental Health Services $151,047
84.181 Special Education-Grants for Infants and Families $71,572
93.150 Projects for Assistance in Transition From Homelessness (path) $42,363