Validate January 2024 posted revenue reports by comparing each Sunshine Health business unit's reported amount to the sum of underlying revenue ledger entries. Return the reported amount, calculated amount, variance, and a status that distinguishes exact matches, mismatches, and missing ledger support.
| Column | Type | Description |
|---|---|---|
| report_id | ||
| report_month | ||
| business_unit | ||
| reported_revenue | ||
| status |
| Column | Type | Description |
|---|---|---|
| entry_id | ||
| posted_date | ||
| business_unit | ||
| account_code | ||
| amount |
| Column | Type | Description |
|---|---|---|
| account_code | ||
| account_category |
| 2 | 2024-01-05 | Medicare | 4000 | 1000.00 |
| 3 | 2024-01-10 | Medicare | 4010 | 500.00 |
| 5 | 2024-01-18 | Marketplace | 5000 | -50.00 |
| 4000 | Revenue |
| 4010 | Revenue |
| 5000 | Expense |
| 101 | 2024-01-01 | Medicare | 1500.00 | POSTED |
| 102 | 2024-01-01 | Marketplace | 1200.00 | POSTED |
| 104 | 2024-01-01 | Specialty | 700.00 | POSTED |