mismatches between different widgets

[lupael]

After reviewing the dashboard data, I found a few significant mismatches between different widgets. These inconsistencies usually suggest that the "Billing" logic and the "Customer" status logic are not syncing correctly in the database.Here are the primary discrepancies:1. Billed Customers vs. Total ClientsThe Mismatch: Under Billing Statistics, it shows 2 Billed Customers. However, under ISP Information, it shows a Total of 1 Client.The Issue: You cannot have 2 unique customers with invoices if the system only recognizes 1 total client. This suggests there might be a "ghost" customer record or an invoice tied to a deleted/archived user.2. Collection Rate vs. Due AmountThe Mismatch: The Payment Collection section shows $0.00 Due, yet the Collection Rate is 0.0%.The Issue: Mathematically, if you have billed 1,525.00 and collected 0.00, your "Due" amount must be 1,525.00.Formula Check: $$\text{Billed} - \text{Collected} = \text{Due}$$$$1,525.00 - 0.00 \neq 0.00$$The "Due" field is failing to calculate the remaining balance.3. MRC Comparison DiscrepancyThe Mismatch: In the Revenue - Monthly Recurring Charge cards:Current MRC is 500.00.Last Month (Jan 2026) is 512.50.The Issue: If you look at the 3-Month MRC Comparison bar chart directly below it, the bar for Jan 2026 is labeled 513. While this might be a rounding preference, the decimal mismatch ($512.50$ vs $513$) between the card and the chart indicates inconsistent data formatting.