Finding 1191734 (2025-003)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2025
Accepted
2026-03-28
Audit: 395531
Organization: Change, Inc. (MN)

AI Summary

  • Core Issue: The medical billing system is not integrated with the accounting system, leading to potential revenue misstatements.
  • Impacted Requirements: GAAP requires accurate financial records and effective internal controls, which are currently lacking due to no regular reconciliations.
  • Recommended Follow-Up: Implement formal monthly reconciliation procedures between the billing and accounting systems, with management review and prompt resolution of discrepancies.

Finding Text

2025-003 Medical Billing Revenue Recognition Internal Controls – Significant Deficiency Criteria – Generally accepted accounting principles (GAAP) and sound internal control practices require entities to maintain accurate and complete financial records and implement effective internal controls over revenue recognition. This includes requiring effective internal controls ensuring that revenue recorded in the accounting system is reconciled to subsidiary systems to ensure completeness and accuracy of financial reporting. Condition – During our audit, we noted that the Organization’s medical billing system, which tracks a significant portion of revenue, operates independently from the accounting system. The two systems are not integrated, and no regular reconciliation is performed between them. Revenue is recorded in the accounting system on a cash basis throughout the year, with monthly adjustments made to record receivable balances based on reports from the billing system. At year-end, the schedule provided from the billing software did not reconcile to the unadjusted trial balance. Significant time and effort by both the audit team and management was required to reconcile the billing schedule to the accounting system, with only an immaterial difference remaining after adjustments. Cause – The Organization has not established formal procedures or assigned responsibility for performing and documenting reconciliations between the billing and accounting systems. Effect – There is an increased risk that revenue may be misstated due to errors or omissions, and that misstatements or irregularities may not be detected and corrected in a timely manner. The lack of timely reconciliation also results in significant inefficiencies during the audit process and increases the risk of material misstatement in the financial statements. Recommendation – We recommend that the Organization develop and implement formal procedures to reconcile the billing system to the accounting system on a monthly basis. The reconciliation should be reviewed and approved by management, and any discrepancies should be investigated and resolved promptly. Auditee's comments and response – Management is in agreement with this finding. Change Inc. is developing formal procedures to include monthly reconciliation between accounting and billing systems. Responsible party for corrective action: Jill Johnson, Executive Director Repeat Finding: No

Corrective Action Plan

Finding 2025-003 Significant Deficiency Medical Billing Revenue Recognition Internal Controls Finding Summary: Regular reconciliation between the medical billing system and the accounting system was not conducted throughout the year, leading to a significant discrepancy between the end of year trail balance and the billing software report. Responsible Individuals: Jill Johnson, Executive Director Corrective Action Plan: We are developing formal procedures to include monthly reconciliation between accounting and billing systems. Anticipated Completion Date: March 31, 2026

Categories

Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1191681 2025-001
    Material Weakness Repeat
  • 1191682 2025-001
    Material Weakness Repeat
  • 1191683 2025-001
    Material Weakness Repeat
  • 1191684 2025-001
    Material Weakness Repeat
  • 1191685 2025-001
    Material Weakness Repeat
  • 1191686 2025-001
    Material Weakness Repeat
  • 1191687 2025-001
    Material Weakness Repeat
  • 1191688 2025-001
    Material Weakness Repeat
  • 1191689 2025-001
    Material Weakness Repeat
  • 1191690 2025-001
    Material Weakness Repeat
  • 1191691 2025-001
    Material Weakness Repeat
  • 1191692 2025-001
    Material Weakness Repeat
  • 1191693 2025-001
    Material Weakness Repeat
  • 1191694 2025-001
    Material Weakness Repeat
  • 1191695 2025-001
    Material Weakness Repeat
  • 1191696 2025-001
    Material Weakness Repeat
  • 1191697 2025-001
    Material Weakness Repeat
  • 1191698 2025-001
    Material Weakness Repeat
  • 1191699 2025-002
    Material Weakness Repeat
  • 1191700 2025-002
    Material Weakness Repeat
  • 1191701 2025-002
    Material Weakness Repeat
  • 1191702 2025-002
    Material Weakness Repeat
  • 1191703 2025-002
    Material Weakness Repeat
  • 1191704 2025-002
    Material Weakness Repeat
  • 1191705 2025-002
    Material Weakness Repeat
  • 1191706 2025-002
    Material Weakness Repeat
  • 1191707 2025-002
    Material Weakness Repeat
  • 1191708 2025-002
    Material Weakness Repeat
  • 1191709 2025-002
    Material Weakness Repeat
  • 1191710 2025-002
    Material Weakness Repeat
  • 1191711 2025-002
    Material Weakness Repeat
  • 1191712 2025-002
    Material Weakness Repeat
  • 1191713 2025-002
    Material Weakness Repeat
  • 1191714 2025-002
    Material Weakness Repeat
  • 1191715 2025-002
    Material Weakness Repeat
  • 1191716 2025-002
    Material Weakness Repeat
  • 1191717 2025-003
    Material Weakness Repeat
  • 1191718 2025-003
    Material Weakness Repeat
  • 1191719 2025-003
    Material Weakness Repeat
  • 1191720 2025-003
    Material Weakness Repeat
  • 1191721 2025-003
    Material Weakness Repeat
  • 1191722 2025-003
    Material Weakness Repeat
  • 1191723 2025-003
    Material Weakness Repeat
  • 1191724 2025-003
    Material Weakness Repeat
  • 1191725 2025-003
    Material Weakness Repeat
  • 1191726 2025-003
    Material Weakness Repeat
  • 1191727 2025-003
    Material Weakness Repeat
  • 1191728 2025-003
    Material Weakness Repeat
  • 1191729 2025-003
    Material Weakness Repeat
  • 1191730 2025-003
    Material Weakness Repeat
  • 1191731 2025-003
    Material Weakness Repeat
  • 1191732 2025-003
    Material Weakness Repeat
  • 1191733 2025-003
    Material Weakness Repeat
  • 1191735 2025-004
    Material Weakness Repeat
  • 1191736 2025-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $335,821
93.104 COMPREHENSIVE COMMUNITY MENTAL HEALTH SERVICES FOR CHILDREN WITH SERIOUS EMOTIONAL DISTURBANCES (SED) $297,229
94.006 AMERICORPS STATE AND NATIONAL 94.006 $187,685
17.259 WIA YOUTH ACTIVITIES $104,572
17.274 YOUTHBUILD $50,021
16.726 JUVENILE MENTORING PROGRAM $49,337
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $46,006
10.555 NATIONAL SCHOOL LUNCH PROGRAM $34,738
17.270 REENTRY EMPLOYMENT OPPORTUNITIES $32,960
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $24,868
93.958 BLOCK GRANTS FOR COMMUNITY MENTAL HEALTH SERVICES $22,247
10.553 SCHOOL BREAKFAST PROGRAM $8,491
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $6,931