Net Metering Credit Carryover Forecaster

Stephanie Ben-Joseph headshot Stephanie Ben-Joseph

What this calculator does

This forecaster models a simple net metering “credit bank” over the next 12 months. You enter your expected monthly household electricity usage (kWh) and solar generation (kWh). The calculator then tracks how many kilowatt-hour credits you earn when you export energy to the grid, how many credits you spend when your usage exceeds generation, and how many credits expire under a rolling expiration window.

The output includes a month-by-month ledger (credits used, credits expired, ending balance, billable energy, and billable cost) plus a small scenario comparison (baseline, usage +10%, generation +10%). You can also download the monthly detail as a CSV for spreadsheet analysis.

Inputs, units, and assumptions

The model uses a first-in, first-out approach to minimize expirations: older credits are consumed before newer credits. This mirrors common utility accounting, but your utility may apply different rules (annual true-up, minimum bills, demand charges, time-of-use pricing, or wholesale payout for excess). Use this as a planning tool, not a substitute for your tariff.

Core formulas (plain language)

For each month m:

The balance identity is: End balance = Start balance + Credits earned − Credits used − Credits expired.

Worked example (quick)

Suppose your retail rate is $0.16/kWh, credits expire after 12 months, and you start with 180 kWh that expires in 6 months. If in April you use 600 kWh and generate 750 kWh, your net export is +150 kWh, so 150 kWh is added to your credit ledger. If in October you use 800 kWh and generate 500 kWh, your net export is −300 kWh; the calculator spends up to 300 kWh of your oldest credits. If you only have 220 kWh available, then 220 kWh is “credits used” and the remaining 80 kWh becomes billable energy (80 × $0.16 = $12.80).

Tips for better forecasts

Use your all-in energy rate if you want the bill estimate to match your statement (exclude fixed monthly fees if desired).

Example: 12 means credits earned this month expire after 12 months. Some utilities true-up annually instead.

If you have no existing credits, set this to 0.

Must be between 0 and the expiration window. Use 0 if your existing credits expire immediately.

Monthly consumption and generation

Enter expected household usage and on-site generation for each month. Values must be non-negative.

Provide usage and generation estimates to see how credits carry forward or expire.
Monthly credit activity
Month Usage (kWh) Generation (kWh) Net export Credits used Credits expired End balance Billable energy Billable cost
Scenario comparison
Scenario Year-end credit Credits expired Utility bill owed

Why track credit carryover?

Net metering programs reward solar households for exporting excess electricity to the grid, banking kilowatt-hour credits that offset consumption when the sun is weak. Yet utilities often clear remaining credits annually or after a fixed window, meaning poorly timed surpluses evaporate without delivering value. Homeowners may discover in April that the hefty bank of credits earned during summer has vanished just before the air-conditioning season begins. Utilities that true-up at wholesale rates rather than retail can erode savings further. A carryover forecaster clarifies how monthly usage, seasonal production, and credit expiration rules interact so families can plan major appliance upgrades, vehicle charging, or battery investments with clear financial expectations.

Many solar monitoring portals display production and net meter readings but fail to model future expirations. Some utilities also complicate matters by resetting the calendar year on the customer’s interconnection anniversary rather than December 31. Others offer monthly credits that expire individually after a set number of billing cycles. This planner lets users enter consumption and generation estimates for each month, specify the expiration window, and include any credits already banked. The result is a ledger showing which credits are used, which expire, and when bills are owed. Users can run alternate scenarios—such as shifting loads to winter or adding storage—to see how actions change the ledger.

How the forecast works

After you press the Forecast button, the script parses each month’s consumption and generation, confirming they are non-negative numbers. It converts the credit expiration window into a rolling ledger by storing each deposit’s future expiry month. Starting balances are treated as legacy deposits that already spent part of their lifespan; you specify how many months remain so the ledger knows when those credits disappear. For every month, the tool first removes any credits whose expiry date has arrived, then applies new deposits or draws down the balance to cover deficits. Billable energy appears only when monthly usage exceeds the sum of generation plus available credits.

The output table lists the net exports, credits used, expirations, ending balance, and billable cost at the entered retail rate. For utilities that settle excess credits annually at a wholesale rate, you can replace the retail rate with that settlement value to see how much cash payment to expect. The CSV export allows deeper analysis in spreadsheets—perhaps to compare with utility bills or to aggregate multi-year data. The scenario table demonstrates how modest changes in consumption or production reshape outcomes.

Scenario insights and planning strategies

Scenario comparisons help you see whether you are likely to end the year with unused credits, lose credits to expiration, or owe a bill during low-production months. If increasing consumption reduces expirations without creating a bill, you may be able to shift flexible loads (EV charging, water heating, dehumidification, pre-cooling) into months where credits would otherwise expire. If increasing generation increases expirations, it can be a sign that storage or load shifting would improve the value of additional solar.

Illustrative comparison of load-shifting strategies

The table below is an illustrative example of how different strategies can change year-end outcomes. Your results will depend on your own monthly inputs and your utility’s rules.

Year-end outcomes for different load-shifting choices
Strategy Credits expired Year-end balance Estimated savings at $0.16/kWh
No intervention 90 kWh 420 kWh $67
10 kWh battery shifting 200 kWh 20 kWh 260 kWh $115
Smart water heater absorbing 150 kWh 0 kWh 270 kWh $118

Limitations and assumptions

The forecast simplifies several real-world complexities. It assumes the utility applies credits strictly in first-in, first-out order and that monthly billing cycles align with calendar months. Some providers true-up annually regardless of credit age or pay out unused balances at wholesale rates. Others charge minimum fees or demand charges that persist even when credits cover all energy. The tool does not model time-of-use rates or demand charges, though you can run separate forecasts for peak and off-peak periods by splitting the year into multiple scenarios. Generation and consumption inputs are deterministic, yet weather can deviate significantly from averages. For high-stakes financial decisions, pair this planner with interval data from your utility or monitoring system.

Despite these limitations, the net metering credit carryover forecaster gives solar households a strategic advantage. It connects production forecasts, lifestyle choices, and utility rules into a single timeline. Users can align credit usage with electric vehicle charging plans, heat pump installations, or other electrification projects. Exporting the data supports conversations with installers, battery vendors, and financial planners. By refreshing the model after each billing cycle, homeowners can verify that utility statements match expectations and intervene early if credits risk expiring.

Embed this calculator

Copy and paste the HTML below to add the Net Metering Credit Carryover Forecaster | Solar Credit Expiration & Rollover Calculator to your website.