Check a full year of electricity and water records for gaps
A household creates a simulated year of paired statements. Its main question is whether both utilities have a record for every month before making comparisons.
Open TrackerInputs and calculation
| Month | Utility | Usage | Bill | Budget | Variance | Month change |
|---|---|---|---|---|---|---|
| 2025-01 | electricity | 400 kWh | 100 | 100 | 0 | — |
| 2025-02 | electricity | 440 kWh | 110 | 100 | 10 | 10 (10%) |
| 2025-03 | electricity | 360 kWh | 90 | 100 | -10 | -20 (-18.1818%) |
| 2025-04 | electricity | 320 kWh | 80 | 100 | -20 | -10 (-11.1111%) |
| 2025-05 | electricity | 320 kWh | 80 | 100 | -20 | 0 (0%) |
| 2025-06 | electricity | 400 kWh | 100 | 100 | 0 | 20 (25%) |
| 2025-07 | electricity | 480 kWh | 120 | 100 | 20 | 20 (20%) |
| 2025-08 | electricity | 520 kWh | 130 | 100 | 30 | 10 (8.3333%) |
| 2025-09 | electricity | 400 kWh | 100 | 100 | 0 | -30 (-23.0769%) |
| 2025-10 | electricity | 320 kWh | 80 | 100 | -20 | -20 (-20%) |
| 2025-11 | electricity | 360 kWh | 90 | 100 | -10 | 10 (12.5%) |
| 2025-12 | electricity | 440 kWh | 110 | 100 | 10 | 20 (22.2222%) |
| 2025-01 | water | 10 m³ | 40 | 48 | -8 | — |
| 2025-02 | water | 10 m³ | 40 | 48 | -8 | 0 (0%) |
| 2025-03 | water | 11 m³ | 44 | 48 | -4 | 4 (10%) |
| 2025-04 | water | 12 m³ | 48 | 48 | 0 | 4 (9.0909%) |
| 2025-05 | water | 13 m³ | 52 | 48 | 4 | 4 (8.3333%) |
| 2025-06 | water | 14 m³ | 56 | 48 | 8 | 4 (7.6923%) |
| 2025-07 | water | 16 m³ | 64 | 48 | 16 | 8 (14.2857%) |
| 2025-08 | water | 15 m³ | 60 | 48 | 12 | -4 (-6.25%) |
| 2025-09 | water | 12 m³ | 48 | 48 | 0 | -12 (-20%) |
| 2025-10 | water | 11 m³ | 44 | 48 | -4 | -4 (-8.3333%) |
| 2025-11 | water | 10 m³ | 40 | 48 | -8 | -4 (-9.0909%) |
| 2025-12 | water | 10 m³ | 40 | 48 | -8 | 0 (0%) |
There are 12 months × 2 utilities = 24 records. August electricity variance is 130 − 100 = 30. August water variance is 60 − 48 = 12.
What the comparison shows
August combines to 190 versus 140 in January. If July water were missing, August water would have no comparable prior month while August electricity would still have one.
Assumptions and limits
A combined review is manual. Usage units differ, and amounts should only be added when they use the same currency.