Free Plumbing Energy Efficiency Incentive Tracker

Track rebates and federal energy credits on plumbing work without conflating the two. Add a row per measure — heat pump water heaters, gas tankless and storage water heaters, solar water heating, geothermal loops, pipe insulation and home energy audits — and the builder tests each one against the 12/31/2025 sunset that Public Law 119-21 put on IRC 25C and 25D, derives the claim deadline from the program's own submission window, and rolls the credit up per tax year and per cap bucket so you can see what the caps actually cost. PDF, Excel or Word.

Where should we send it?

Add your email to download this template. It is free, and you only have to do this once.

We use it to send you the occasional template and product update. See our privacy policy.

Build your incentive tracker

Log each measure once. Rebates and federal tax credits stay in separate totals, claim deadlines come from each program’s own submission window, and every row is checked against the 2025-12-31 federal sunset.

Energy Efficiency Incentive Tracker

Plumbing · as of 09/11/2026

Measures

1

Overdue claims

0

Blocked

0

No federal credit

0

Enter a program submission window to derive a deadline
1Property & customerThe credits attach to the taxpayer, not to the job — so who they are matters as much as what was installed.
Title
As of date
Customer
Prepared byoptional
Property address
Company detailsNothing set
2Measures installedOne row per item. The category you pick decides which annual cap bucket and sub-cap apply.
No federal residential credit is claimed for this measure — rebate tracking only.
3Program & submission trackingA rebate is money a program pays out. Enter each program's own submission window and the deadline is worked out for you.
Other measure — rebate only, no federal credit
Identified
Programoptional
Administratoroptional
Submission window (days)
Status
Rebate payable tooptional
Submittedoptional
Rebate requestedoptional
Rebate receivedoptional
Claim deadline
Enter an installation date and the program’s window in days.
4Federal credit eligibility & cap roll-upAuto-calculatedPer tax year, per cap bucket, with the amount lost to the caps. Nothing here is typed.

Nothing eligible yet. Add a measure with a credit category, a qualified cost and a placed-in-service date on or before 2025-12-31.

5Documentation checklistWhat a utility audit and a tax preparer each ask for. Remove anything a program does not want.
Itemised invoice separating equipment, labour and any non-qualifying work
Model numbers and the manufacturer performance certificate or AHRI certificate
Qualified Manufacturer ID (QMID) for each 25C item
6Notes & sign-offAnything the office, the customer or their tax preparer should know.
Notesoptional
SignatureNot signed

Signature style

Preview

Name

Add to your tracker:

Download your tracker:

Free · no signup · fully editable

What's included

  • A federal eligibility check on every row against the 2025-12-31 sunset that Public Law 119-21, 139 Stat. 72 (July 4, 2025) imposed on both IRC 25C and IRC 25D — with the reason and the date printed, not a silent zero
  • The IRC 25D nuance most trackers miss: the expenditure counts when the original installation is completed, so a deposit paid before the sunset on a job finished after it qualifies for nothing
  • A per-tax-year, per-bucket cap roll-up: the $1,200 general bucket, the separate $2,000 heat pump, heat pump water heater and biomass bucket, and the $3,200 combined ceiling
  • Every published per-item sub-cap applied in the right order: $600 per panelboard, air conditioner, furnace, boiler or fossil-fuel water heater; $250 per exterior door to $500 total; $600 for all windows and skylights; $150 for a home energy audit
  • The amount lost to the cap, stated as its own figure — because 25C was nonrefundable with no carryforward, so anything over a cap was lost permanently
  • Rebates and tax credits kept in separate totals that are never added together, with a rebate payee field for whether the program pays the customer or the contractor as an instant discount
  • A claim deadline derived from each program’s own submission window in days, never from an invented national figure, with overdue and due-soon flags
  • A blocked-row state for the expensive mistake: pre-approval required by the program, none recorded, and the measure already installed
  • Amounts requested against amounts received per row, with the variance, so a short-paid rebate is visible
  • Status per row through identified, pre-approval, submitted, approved, paid and denied
  • A product certification field for ENERGY STAR or a CEE performance tier, and a QMID field for the qualified-manufacturer requirement
  • A nine-point documentation checklist covering what a utility audit and a tax preparer each actually ask for
  • PDF, Excel (.xlsx) and Word (.docx) exports that all carry the not-tax-advice notice as visible text
  • Blank fields never print as dashes — a row you did not fill in simply does not appear

How to use this template

  1. 1

    Enter the property and who the taxpayer is

    Customer, property address, and whether it is their principal residence. The federal credits attached to the taxpayer, not to the job — which is why the credit side of this document is an estimate for their return and the rebate side is money that actually moves.

  2. 2

    Add one row per measure installed

    Pick the measure from the suggestions for your trade and the builder assigns the right credit category, cap bucket and sub-cap. Enter the qualified cost and the date the item was placed in service — that date is the one the whole eligibility test turns on.

  3. 3

    Enter each program’s own submission window

    There is no national deadline, so the builder never assumes one. Look up the window in the program rules — DSIRE catalogues them by state and utility — enter it as a number of days, and the deadline is derived from the installation date. Overdue and due-soon rows are flagged, and a row where pre-approval was required but never obtained is flagged as blocked.

  4. 4

    Read the federal eligibility verdict on every row

    Any row placed in service after 2025-12-31 comes back ineligible with the reason and the statute, because Public Law 119-21, 139 Stat. 72 (July 4, 2025) terminated both residential credits. Pre-sunset rows compute normally — 2025 jobs are still being reconciled.

  5. 5

    Check the cap roll-up, not the column total

    The roll-up groups every eligible row by tax year and by cap bucket, applies the per-item and per-category sub-caps, then the annual bucket caps, and prints the amount lost to the cap. That last figure is the one a plain sum hides. The 25C ceiling in a single year was $3,200 and nothing over it carried forward.

  6. 6

    Work the documentation checklist

    Itemised invoice, model numbers and performance certificate, QMID for each 25C item, pre-approval number dated before installation, nameplate photos, permit sign-off, W-9 for whoever the rebate is payable to. From tax year 2025 an item with no qualified manufacturer ID got no 25C credit at all.

  7. 7

    Sign it and export

    PDF for the customer file, Excel to keep working the claims, Word if a program wants an editable summary. All three print the rebate total and the credit estimate as separate figures and carry the not-tax-advice notice.

The federal energy credits ended on December 31, 2025 — and the date that matters is not the one you think

Both residential federal energy credits are gone. Public Law 119-21, 139 Stat. 72 (July 4, 2025) — the reconciliation act — terminated them early, years ahead of the schedule the Inflation Reduction Act had set. The IRS states it plainly: the IRC 25C Energy Efficient Home Improvement Credit "will not be allowed for any property placed in service after December 31, 2025", and the IRC 25D Residential Clean Energy Credit "will not be allowed for any expenditures made after December 31, 2025". Nothing replaced either one at the federal residential level. Every rebate tracker still in circulation with a "30% federal tax credit" column now produces a false promise on the contractor's letterhead, and the customer only finds out at filing time. This builder checks the placed-in-service date on every row against that sunset and marks the row ineligible with the statute and the date, rather than quietly computing a number nobody can claim.

The 25D nuance is the one that catches people who thought they had beaten the deadline. It is easy to assume that paying in 2025 locked the credit in. It did not. The IRS treats a 25D expenditure as made "when the original installation of the item is completed" — the payment date does not control. A customer who signed and paid a deposit in December 2025 on a solar array or a geothermal loop energised in February 2026 gets nothing. 25C works the other way round, on placed-in-service, which lands in the same place for most installs but for different reasons. The builder uses one date per row for exactly this reason and labels it as both, so the row cannot be right for one statute and wrong for the other.

The arithmetic is where a spreadsheet quietly overstates the benefit, and it is the reason this tracker exists rather than a rebate column in your CRM. For the years 25C was available, the caps stacked in three stages, per taxpayer per tax year. First a sub-cap: $600 per item of qualified energy property — a panelboard, sub-panelboard, branch circuit, feeder, central air conditioner, furnace, boiler or fossil-fuel water heater — $250 per exterior door to a $500 total, $600 for all windows and skylights together, $150 for a home energy audit. Then the annual bucket: $1,200 across all of that, plus a separate $2,000 for heat pumps, heat pump water heaters, biomass stoves and biomass boilers, which sat on top rather than inside, for a $3,200 combined ceiling. Then the taxpayer's own liability. And here is the part a total row hides: 25C was nonrefundable with no carryforward — the IRS is explicit that "you can't apply any excess credit to future tax years" — so anything above a cap was lost permanently. 25D, by contrast, does carry forward. This builder rolls up per year and per bucket and prints the amount lost to the caps as its own line.

A heat pump water heater drew on the $2,000 annual bucket. A gas water heater drew on the $1,200 one and was capped at $600 per item. Two water heaters, two completely different credit ceilings — which is exactly the distinction a single rebate column erases.

A rebate is not a tax credit, and treating them as one line item is the field problem this document is really aimed at. A rebate is money a program pays out — sometimes to the customer, sometimes to you as a midstream or instant discount at the distributor, which changes who signs the W-9 and who gets the 1099. A tax credit is claimed by the taxpayer on their own return and never reaches the contractor at all. The two are tracked in separate totals here and are never summed. The other half of the rebate side is the deadline, and there is no national one to hardcode: every utility, state and co-op program sets its own submission window, and many run first-come until the funds are exhausted. So the window is a number of days you enter from the program's own rules — DSIRE, run by the N.C. Clean Energy Technology Center, is the place to look them up — and the deadline is derived from the installation date. Programs also commonly require an ENERGY STAR certified product or one meeting a published CEE performance tier, and many require pre-approval before you install, which is its own blocking state on the row: pre-approval required, none recorded, equipment already in the wall.

Related templates

More free downloads for your PLUMBING template library.

Energy Efficiency Incentive Tracker FAQs

Can my customer still claim the 25C energy efficient home improvement credit in 2026?

No. Public Law 119-21, 139 Stat. 72 (July 4, 2025) terminated the credit early, and the IRS states that it "will not be allowed for any property placed in service after December 31, 2025". There is no federal residential successor credit. If you have a 2026 installation, the honest answer to the customer is that the federal credit is gone and the remaining money is whatever their utility, state energy office or co-op still runs. This builder flags any post-sunset row as ineligible for exactly that reason — quoting a dead credit is worse than quoting none.

For the 25D Residential Clean Energy Credit, no. The IRS treats an expenditure as made "when the original installation of the item is completed", so the payment date does not control — a 2025 deposit on a 2026 commissioning qualifies for nothing. For 25C the test is when the property was placed in service, which for practical purposes also means the 2026 install fails. This is the single most common way a contractor and a customer end up with different expectations, so record the completion date accurately rather than the invoice date.

30% of qualified expenses, subject to a $1,200 aggregate annual limit covering building envelope components, qualified energy property and home energy audits, plus a separate $2,000 annual limit for qualified heat pumps, heat pump water heaters, biomass stoves and biomass boilers. The second sat on top of the first, so the combined ceiling in one tax year was $3,200. Inside the $1,200 bucket there were per-item sub-caps: $600 per item of qualified energy property, $250 per exterior door and $500 for all doors, $600 for windows and skylights, and $150 for a home energy audit. The limits were annual and per taxpayer, not per job.

Because they are two different kinds of money and the credit side is capped. A rebate is paid out by a program with no federal cap. A federal credit is 30% of qualified cost, then reduced by a per-item sub-cap, then by an annual bucket cap, then by the taxpayer’s own liability. Two $600-per-item measures in one year cannot both produce $600 if the $1,200 bucket also holds a door and a window. The builder shows you the raw figure, the allowed figure, and the difference as an amount lost to the cap — which for 25C was lost for good, since the credit was nonrefundable and nothing carried forward.

For property placed in service on or before 2025-12-31, yes — panelboards, sub-panelboards, branch circuits and feeders were qualified energy property under 25C, capped at $600 per item inside the $1,200 annual bucket. The IRS FAQs do not publish an amperage threshold for the category, so this builder does not assert one; check the qualified-manufacturer documentation for the specific panelboard instead of relying on a number a template made up. For anything placed in service after the sunset the answer is no, regardless of the panel.

A Qualified Manufacturer Identification Number. From tax year 2025 the IRS allowed no 25C credit for an item of qualifying property unless it was produced by a qualified manufacturer and the QMID for that item was reported on the taxpayer’s return. That means a 2025 installation with perfect paperwork everywhere else still got nothing if the QMID was never captured. It is on the documentation checklist here for that reason — it is the field most likely to be missing when a customer’s preparer comes back asking for it months later.

From the program itself. There is no national deadline and this builder deliberately does not default one — utility, state and co-op programs each set their own submission window, and many are first-come until the annual funds run out, which is a harder deadline than any published date. DSIRE, maintained by the N.C. Clean Energy Technology Center at N.C. State, catalogues incentives and their rules by state and utility and is the right starting point. Enter the window in days on the row and the tracker derives the deadline from the installation date, then flags the row when it is due soon or overdue.

It depends on the program, which is why it is a field rather than an assumption. A downstream consumer rebate is paid to the customer. A midstream or instant-discount program pays the distributor or the contractor and the customer sees a lower invoice instead. That choice decides who signs the program application and the W-9, who receives any 1099, and how the job should be invoiced. What is never in question is the tax credit: the taxpayer claims it on their own return, and no program pays it to the contractor. Mixing the two is how a customer comes to believe you owe them a cheque.

No, and every export says so in plain text. Whether a customer can actually use a federal credit depends on their own tax situation — 25C was nonrefundable with no carryforward, so it could not exceed their liability and any excess was lost, and 25D carries forward but still depends on their return. The figures here are estimates from the amounts you enter, produced so that you and the customer have the same understanding of what is being claimed and by whom. Confirm eligibility with a tax professional and against the IRS pages for 25C and 25D, and confirm program rules with the program administrator.

You chase the rebate paperwork. Larry answers the phone while you do.

We will run your numbers on the call and tell you if the maths does not work for a shop your size. That happens, and it is a cheaper conversation than finding out three months in.

Get a demo