Savings calculator

How to Track Your Plug-In Solar Payback: A Month-by-Month Guide

Every pound your panels save you brings payback closer. Here’s a simple system for tracking your real-world savings month by month so you know exactly when you break even.

Person on a UK terrace house balcony with plug-in solar panels, golden hour light

There are two types of plug-in solar users.

The first type installs the panels, plugs them in, checks the app occasionally, and assumes everything is fine. They might be right. They might be leaving significant money on the table, or their panels might be underperforming without them knowing.

The second type tracks their generation, records their savings, and knows — within a reasonable margin — when their system will have paid for itself. They can also spot problems early: a panel that stops generating because the inverter has silently failed, or a self-consumption rate far below expectations because they are not running appliances during the generation window.

The second approach takes about ten minutes a month. Here is how to do it.


The three numbers you need each month

1. Monthly solar generation (kWh) — From your inverter app. This is the total electricity your panels produced during the month.

2. Monthly grid import (kWh) — From your smart meter reading or electricity bill. This is the total electricity you drew from the grid.

3. Your unit electricity rate (p/kWh) — From your tariff. If you are on a fixed tariff this is stable; if you are on Octopus Agile it varies, and you can use your average for the month.

With these three numbers, you can calculate your approximate monthly saving.


The calculation

The tricky part is that you cannot directly measure how much solar electricity you used yourself versus how much you exported to the grid for nothing. Without a whole-home energy monitor, you cannot split this precisely.

The approach I use is to compare my grid import this month to the same month last year (or to a comparable pre-solar month). The difference is approximately my solar saving — not exactly, because other factors change consumption (a holiday, a new appliance, a hot week requiring a fan), but close enough for tracking purposes.

Example calculation:
– December last year: 250 kWh grid import
– December this year (with solar): 220 kWh grid import
– Generation this December: 60 kWh
– Apparent saving: 30 kWh avoided grid electricity (250 − 220)
– Self-consumption rate implied: 30/60 = 50%
– Saving at 25p/kWh: 30 × 0.25 = £7.50 this month

£7.50 is a modest figure for December, which is expected — winter generation is low. In July you might see:
– July last year: 180 kWh
– July this year (solar): 120 kWh
– Generation: 160 kWh
– Apparent saving: 60 kWh
– Self-consumption: 37.5%
– Saving: 60 × 0.25 = £15

Running totals through the year build toward a year’s total saving.


The payback spreadsheet

I use a simple spreadsheet that I update on the first of each month. Here are the columns I track:

Month Generation (kWh) Grid import (kWh) Estimated saving (kWh) Value (£) Cumulative saving (£)
Oct 26 85 195 45 £11.25 £11.25
Nov 26 55 220 30 £7.50 £18.75
…

The “cumulative saving” column builds toward your total system cost. When cumulative saving equals what you paid for the system, you have broken even.

You can download a version of this spreadsheet from the savings calculator page on this site. The calculator lets you enter your system details and generates an annual projection; the month-by-month tracker sits alongside it for recording actuals.


Why the year-over-year comparison matters

Using last year’s grid import as a baseline is more useful than trying to calculate from theory, because it automatically accounts for your actual household consumption pattern.

Theory says: your 400W panel should generate about 400 kWh per year in central England. But theory does not know whether you work from home, run a chest freezer, or have a electric shower that runs for 15 minutes every morning. The year-over-year comparison captures all of that in the baseline.

The limitation is that consumption changes for other reasons too. A new appliance, a child leaving home, a different working pattern — all of these affect grid import independently of solar. After two years with solar, you can use the first year of solar as the baseline for the second year, which removes the pre-solar year’s irrelevant changes.


What good performance looks like

For a single south-facing 400W panel in the UK (average location, reasonable installation, no significant shading):

  • Winter months (December, January): 20 to 50 kWh generation
  • Spring/autumn (March, October): 40 to 80 kWh generation
  • Summer peak (June, July): 80 to 120 kWh generation
  • Annual total: 350 to 450 kWh

If your monthly numbers are significantly below these, it is worth investigating. Common causes include unexpected shading (a fence that was lower last year, a new structure nearby), a dirty panel reducing output, or a monitoring or inverter fault that is not showing up as an error.

The EcoFlow STREAM and Anker SOLIX apps both flag inverter faults as push notifications, which means you find out quickly if your system stops generating. Third-party inverters with cloud monitoring do the same. What these apps do not automatically flag is gradual underperformance — a panel that is generating 20% less than expected due to soiling will not trigger an alert; only your month-by-month tracking will show the trend.


The honest payback picture

Let me give you a real-world payback estimate based on a typical UK setup.

System: Single 400W panel and G98-certified micro-inverter, freestanding garden mount. Total cost including delivery: £450.

Annual generation: 400 kWh (central England average, south-facing).

Self-consumption rate: 50% (you are at home some of the time and run a few appliances during the generation window).

Units saved from grid per year: 400 × 50% = 200 kWh.

Value at 25p/kWh: 200 × £0.25 = £50 per year.

Payback: £450 ÷ £50 = 9 years.

Nine years is honest and slightly sobering. If you push self-consumption to 70% through active load management, that becomes:

Units saved: 280 kWh. Value: £70. Payback: 6.4 years.

If you add a second panel at £300, bringing the system to 800W:

Annual generation: 800 kWh. At 60% self-consumption: 480 kWh. Value: £120. Total system cost: £750. Payback: 6.25 years.

These are not dramatic returns on investment. They are solid, reliable, inflation-linked returns. And the system keeps generating for 25 years after payback — potentially generating £50 to £120 of free electricity per year indefinitely.

The purpose of tracking is not to find out the theory. It is to find out what your specific system is actually doing, in your specific location, with your specific household pattern, and to give you real data to make decisions about whether to expand, how to optimise, and when you actually hit break-even.


Beyond simple payback

Simple payback — total cost divided by annual saving — is the easiest metric. But it is not the only one worth calculating.

Levelised Cost of Energy (LCOE): The total cost of the system divided by the total electricity it will generate over its 25-year life. For a £450 system generating 10,000 kWh over 25 years (allowing for 5% degradation), the LCOE is 4.5p/kWh. Grid electricity at 25p/kWh is more than five times more expensive. That is the real economic case for solar.

Return on investment (ROI): The percentage return on your initial investment per year. For the single-panel example above (£50/year on a £450 investment), that is 11% per year — better than most savings accounts and many equity investments, with zero risk other than unexpected panel failure (covered by warranty for 25 years).

Neither of these replaces the month-by-month tracker for understanding your system’s real-world performance. But they give you a different perspective on the value of what you have installed.

Written by Karl Dyson

Karl started Hypermiler.co.uk in 2008 to cover EV efficiency and real-world energy data, and has contributed to BBC radio across several stations. He runs a plug-in solar system at his home in Stamford, so he writes about what these kits actually do in British weather. Every article is checked by Karl before it goes live.