Open calculator ↗

Net metering billing period credit reconciliation · Calculation guide

Estimate bill payable using your figures.

Calculation guide

Use a monetary credit bank. Credits offset only imported energy charges; unused credit carries fully to the next bill. Fixed charges remain payable.

bill = fixed+max(0,imp*buy-opening-exp*sell); ending = max(0,opening+exp*sell-imp*buy); used = min(imp*buy,opening+exp*sell)

Inputs

Imported kWh

Example entry 400.

Exported kWh

Example entry 250.

Import price per kWh

Example entry .25 (in the selected currency).

Export credit per kWh

Example entry .12 (in the selected currency).

Opening monetary credit

Example entry 80 (in the selected currency).

Non-creditable charges

Example entry 15 (in the selected currency).

Worked example

InputValue
Imported kWh400
Exported kWh250
Import price per kWh0.25
Export credit per kWh0.12
Opening monetary credit80
Non-creditable charges15
ResultValue
Bill payable15
Credit carried forward10
Credits applied100

Calculation steps

Bill payable = (Non-creditable charges + max(0, (((Imported kWh × Import price per kWh) − Opening monetary credit) − (Exported kWh × Export credit per kWh))))

(15 + max(0, (((400 × 0.25) − 80) − (250 × 0.12)))) = 15

Credit carried forward = max(0, ((Opening monetary credit + (Exported kWh × Export credit per kWh)) − (Imported kWh × Import price per kWh)))

max(0, ((80 + (250 × 0.12)) − (400 × 0.25))) = 10

Credits applied = min((Imported kWh × Import price per kWh), (Opening monetary credit + (Exported kWh × Export credit per kWh)))

min((400 × 0.25), (80 + (250 × 0.12))) = 100

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Imported kWh400440Credit carried forward100
Exported kWh250275Credit carried forward1013
Import price per kWh0.251.25Bill payable15405
Export credit per kWh0.121.12Credit carried forward10260
Opening monetary credit8088Credit carried forward1018
Non-creditable charges1517Bill payable1517
Net metering billing period credit reconciliation →

Sources