Finding 15944 (2022-003)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-07-25

AI Summary

  • Core Issue: The grant receivables subsidiary ledger has not been updated since September 2022, leading to incorrect cash receipt applications and inaccurate balances for grantors.
  • Impacted Requirements: Proper revenue recognition for Community Development Block Grant and Prevention and Treatment of Substance Abuse relies on accurate grant receivables and deferred revenue management.
  • Recommended Follow-Up: Maintain and regularly review the grants receivable subsidiary ledger to ensure correct matching of cash receipts and proper management of deferred revenue.

Finding Text

2022-003 Application of Cash Receipts Criteria: Grant receivables in the consolidated statement of financial position should be properly supported by a grant receivables subsidiary ledger by grantor/funder. Condition: The grant receivables subsidiary ledger had not been updated since September 2022, and that cash receipts had been applied directly to the grants receivable general ledger. This methodology resulted in the incorrect application of cash receipts to debtors/grantors which resulted in incorrect balances for individual grantors listed under grants receivable and deferred revenue. The correct application of cash receipts to individual grantors in order to correctly reflect grants receivable balances and deferred revenue balances is important to proper revenue recognition for Community Development Block Grant (Assistance Listing Number 14.218) and the Prevention and Treatment of Substance Abuse (Assistance Listing Number 93.959). This finding is considered a significant deficiency. Balances were corrected by the conclusion of the audit. Cause: The staffing changes in the Facility?s finance department directly impacted the proper accounting over grants receivable and deferred revenue. Effect: Grant receivables and deferred revenue composed of various grantors/funders and the Facility should be aware of the balances due, collected and received in advance at any point in time. These balances have a direct impact on the revenue generated by the Facility for the provision of program services. Recommendation: The Facility should continue to utilize the grants receivable subsidiary ledger and correctly match cash receipts to the appropriate grant receivable funder and utilize any deferred revenue from the respective funder where appropriate. Proper management of receivables and deferred revenue is necessary for proper revenue recognition and cash management. Views of Responsible Official and Planned Corrective Action: The Chief Executive Officer and Chief Financial Officer will ensure that a complete and accurate grant receivables subsidiary ledger and detailed deferred revenue is maintained and reviewed regularly throughout the year.

Categories

Cash Management Significant Deficiency

Other Findings in this Audit

  • 15938 2022-001
    Material Weakness Repeat
  • 15939 2022-002
    Significant Deficiency
  • 15940 2022-003
    Significant Deficiency
  • 15941 2022-004
    -
  • 15942 2022-001
    Material Weakness Repeat
  • 15943 2022-002
    Significant Deficiency
  • 15945 2022-004
    -
  • 592380 2022-001
    Material Weakness Repeat
  • 592381 2022-002
    Significant Deficiency
  • 592382 2022-003
    Significant Deficiency
  • 592383 2022-004
    -
  • 592384 2022-001
    Material Weakness Repeat
  • 592385 2022-002
    Significant Deficiency
  • 592386 2022-003
    Significant Deficiency
  • 592387 2022-004
    -

Programs in Audit

ALN Program Name Expenditures
14.218 Community Development Block Grants/entitlement Grants $444,565
16.575 Crime Victim Assistance $185,170
93.959 Block Grants for Prevention and Treatment of Substance Abuse $161,642
93.926 Healthy Start Initiative $135,140
93.778 Medical Assistance Program $123,734
17.259 Wia Youth Activities $62,113
14.252 Section 4 Capacity Building for Community Development and Affordable Housing $35,765
93.940 Hiv Prevention Activities_health Department Based $30,970
93.994 Maternal and Child Health Services Block Grant to the States $23,977