Your question is Validate Monthly Financial Report Accuracy. Start with the requirements and the three tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |