Finding 504146 (2022-003)

Significant Deficiency Repeat Finding
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2024-10-30

AI Summary

  • Core Issue: The Association failed to recognize revenues and receivables accurately for reimbursement-based programming, leading to potential misstatements.
  • Impacted Requirements: This violates U.S. GAAP, which mandates revenue recognition when products/services are delivered and amounts are determinable.
  • Recommended Follow-Up: Implement controls for timely recording of receivables and ensure advance funds are recognized as revenue when earned.

Finding Text

Criteria: Accounting principles generally accepted in the United States of America require that amounts be recognized as revenues, with corresponding receivables if applicable, when the product or service has been delivered to a customer and when the dollar amount is readily determinable. Additionally, standards require that advanced payments of funds received, but which are unearned, be recognized as deferred revenue on the statements of financial position. Condition: The Association’s controls were not effective to ensure it was recognizing revenues, receivables, and deferred revenue for reimbursement-based programming in the same period the expenditure occurred. This internal control deficiency is considered to be a significant deficiency. Context: Procedures included examining subsequent cash receipts and vouching to expenditures made during the fiscal year, identifying several such receipts that should have been posted as receivables as of December 31, 2022 but were not. Additionally, we examined general ledger detail and grant agreements related to advanced funding received, but not yet expended, in determining whether or not a liability for unearned revenue existed. Cause: The Association typically records cash receipts on a cash basis instead of accrual basis as stipulated in U.S. GAAP. Effect: By not recording receivables in the correct period, revenues from reimbursement-based awards could be materially misstated. Repeat finding: This finding is a repeat finding in the immediately prior year. Prior year finding number was 2021-003. Recommendation: The Association establish controls that allow for the timely and accurate recording of grants and contracts receivable from reimbursement-based awards in the same period as their corresponding expenditures. Additionally, we recommend the Association establish controls to ensure that funds received from advance awards are recognized as revenue when earned. View of Responsible Officials: There is no disagreement with this audit finding.

Corrective Action Plan

Recommendation: The Association establish controls that allow for the timely and accurate recording of grants and contracts receivable from reimbursement-based awards in the same period as their corresponding expenditures. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: Containment Through this audit process and staff turnover, tasks have been distributed and processes have been implemented immediately to meet the expectations that an AR transaction be entered into the fiscal system within a timely manner of one week or sooner. Root Cause Due to a lack of knowledge of the new software system. Not all information was migrated into the new software system in a timely manner, making it difficult to use at its full potential. OCCDA had a large turnover in the fiscal team during the audit process. The transition to the new fiscal software was during the height of the COVID-19 pandemic, making it difficult to complete training and migration of the new system. Action Taken Immediately in 2023, the fiscal team implemented adding reports/documentation to all requests for funding to allow for better tracking and record keeping. Newly hired staff have established a clear understanding of the naming conventions for clarity and accurate reporting. Tasks have been realigned to specific positions so that all duties are covered and responsibilities are defined. This will ensure that all fiscal tasks are completed timely and accurately establishing controls for reimbursement funding. Training has been provided for the fiscal team on the internal processes and procedures to ensure the timely entry of all data and the importance of accurate monthly reports. We have reorganized the chart of accounts in support of the software consultants, we have added additional program numbers to track grants separately by funding year to allow us to close each grant yearly. Our Fiscal Assistant has been trained to complete all accounts receivable. Receivable billings are completed in the month that they are performed. All receipts are recorded in the month they are received. Monthly reports continue to be sent out each month for the Leadership team to review, allowing for transparency and additional reviews and accuracy. Name(s) of contact person(s) responsible for corrective action: Fiscal Manager Planned completion date for corrective action plan: Completed

Categories

Internal Control / Segregation of Duties Cash Management Significant Deficiency

Other Findings in this Audit

  • 504141 2022-001
    Material Weakness Repeat
  • 504142 2022-007
    Significant Deficiency Repeat
  • 504143 2022-008
    Significant Deficiency
  • 504144 2022-009
    Significant Deficiency
  • 504145 2022-002
    Significant Deficiency Repeat
  • 504147 2022-004
    Significant Deficiency
  • 504148 2022-005
    Significant Deficiency
  • 504149 2022-006
    Significant Deficiency
  • 504150 2022-001
    Material Weakness Repeat
  • 504151 2022-007
    Significant Deficiency Repeat
  • 504152 2022-008
    Significant Deficiency
  • 504153 2022-009
    Significant Deficiency
  • 504154 2022-002
    Significant Deficiency Repeat
  • 504155 2022-003
    Significant Deficiency Repeat
  • 504156 2022-004
    Significant Deficiency
  • 504157 2022-005
    Significant Deficiency
  • 504158 2022-006
    Significant Deficiency
  • 504159 2022-001
    Material Weakness Repeat
  • 504160 2022-007
    Significant Deficiency Repeat
  • 504161 2022-008
    Significant Deficiency
  • 504162 2022-009
    Significant Deficiency
  • 504163 2022-002
    Significant Deficiency Repeat
  • 504164 2022-003
    Significant Deficiency Repeat
  • 504165 2022-004
    Significant Deficiency
  • 504166 2022-005
    Significant Deficiency
  • 504167 2022-006
    Significant Deficiency
  • 1080583 2022-001
    Material Weakness Repeat
  • 1080584 2022-007
    Significant Deficiency Repeat
  • 1080585 2022-008
    Significant Deficiency
  • 1080586 2022-009
    Significant Deficiency
  • 1080587 2022-002
    Significant Deficiency Repeat
  • 1080588 2022-003
    Significant Deficiency Repeat
  • 1080589 2022-004
    Significant Deficiency
  • 1080590 2022-005
    Significant Deficiency
  • 1080591 2022-006
    Significant Deficiency
  • 1080592 2022-001
    Material Weakness Repeat
  • 1080593 2022-007
    Significant Deficiency Repeat
  • 1080594 2022-008
    Significant Deficiency
  • 1080595 2022-009
    Significant Deficiency
  • 1080596 2022-002
    Significant Deficiency Repeat
  • 1080597 2022-003
    Significant Deficiency Repeat
  • 1080598 2022-004
    Significant Deficiency
  • 1080599 2022-005
    Significant Deficiency
  • 1080600 2022-006
    Significant Deficiency
  • 1080601 2022-001
    Material Weakness Repeat
  • 1080602 2022-007
    Significant Deficiency Repeat
  • 1080603 2022-008
    Significant Deficiency
  • 1080604 2022-009
    Significant Deficiency
  • 1080605 2022-002
    Significant Deficiency Repeat
  • 1080606 2022-003
    Significant Deficiency Repeat
  • 1080607 2022-004
    Significant Deficiency
  • 1080608 2022-005
    Significant Deficiency
  • 1080609 2022-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.870 Maternal, Infant and Early Childhood Homevisiting Grant Program $107,617
93.600 Head Start $107,048
93.590 Community-Based Child Abuse Prevention Grants $28,710
10.558 Child and Adult Care Food Program $17,968