Eskom statement tracker

v1.2.4
Demo data. These figures are invented so you can see how the dashboard works. Nothing here is saved.

Add statements

Drop the monthly Eskom PDFs, as many as you like at once. They are read inside your browser and are not uploaded anywhere. With the sheet connected, use this only for a statement the email check missed. Those stay in this browser.

Key dates

These drive the markers and the before and after comparison.

Read from your Google Sheet. Edit these in the Key dates and Issues tabs of the sheet, then press Refresh.

    Connect your Google Sheetnot connected

    This page connects to your sheet automatically on every device. You only need to change these boxes if you create a new web app or token.

    Electricity bought from the grid each month

    Lighter bars are estimated meter readings. The amber line is the three month average, drawn only where three months in a row are available. Bars sit side by side even when months are missing between them. Hover or tap any bar for the detail.

    Before and after

    What the numbers say

      Where each bill goes

      Every charge on the statement, in rand. Hover or tap a bar to see each item as a share of the bill. Click a name in the legend to hide it.

      What each unit really costs

      All in cost per kWh (charges plus VAT) against the energy rate alone. The gap is fixed charges.

      Billed, paid and owing

      Interest on overdue accounts shows up where payments trail the bill.

      Same month, different years

      The fairest solar test, because it compares like seasons. Winter months should sit well below earlier years if solar is working.

      Statements

      Reading log