Get a price

Window estimate template for window and door makers (copy into Excel or Google Sheets)

A good window estimate gives every opening its own line, and that line carries everything the factory needs to build the right unit: where it goes, which size, how it opens, the glass, both colors, the hardware and the price. If a field is missing, someone guesses it later, and a wrong guess comes back as a remake.

Below is the template, laid out so you can copy each table into Excel or Google Sheets, then notes on the fields that cause trouble when they are left blank.

Part 1: header and customer

Field What goes in it
Estimate number and date One number per estimate, new number per revision
Valid until Date, usually 30 days out
Sales rep Who wrote it
Customer Name, phone, email
Site address Where the units go, if not the billing address
Job type New build or replacement
Measured by, on Who took the sizes, and the date

Part 2: the opening schedule

This is the heart of the estimate. One row per opening, numbered to match a sketch of the house.

# Location Product Size and size type Operation and handing Frame and colors Glass Grilles Hardware Screen U-factor / SHGC Qty Unit price Line total
1 Kitchen, over sink Casement, 2 lites 48 × 36 in, frame size Left fixed, right opens out, hinged right (from outside) Vinyl, white in, black out Double, low-E, argon None Crank, black Yes 1
2 Front entry Entry door + 1 sidelight Door 36 × 80 in, sidelight 12 in Inswing, hinges left (from outside) Fiberglass, stained oak in, red out Decorative, tempered None Handle set and deadbolt, black No 1
3 Back patio Sliding patio door, 2 panels 72 × 80 in, rough opening XO (from outside) Vinyl, white both sides Double, low-E, tempered Between the glass, colonial Handle with key lock, white Yes 1

The rows show the layout. Your products, codes and prices go in their place.

Part 3: installation and other work

Line Unit
Remove and dispose of old unit per opening
Install window per opening, by type
Install door per opening, by type
Exterior trim or capping per opening or per foot
Interior trim per opening
Repair of rotten framing found on removal per hour or per foot, at a stated rate

Part 4: totals and terms

Line
Products subtotal
Installation subtotal
Discount
Tax
Total
Deposit percent and amount
Balance when it is due

Terms, one line each: lead time and when it starts, final measure before ordering, validity date, payment schedule, how changes are priced, warranty on product and on install, and what is not included (interior painting, plaster repair, alarm sensors, blinds).

The fields that cause trouble

Size, and which size

"48 × 36" means little until it says what was measured: the rough opening, the frame, or the existing window. Put the size type in the same cell as the size, and the name of the person who measured. If sizes are from the buyer, write "subject to final measure" and say that the price can change with the size.

Handing, from one side

Left and right flip depending on where you stand. Pick one side, say it on every line, and use it on the drawing. Many makers read handing from outside: Andersen, for example, hands its gliding patio doors from the exterior (Andersen). For sliders, X marks the panel that moves and O the fixed one, so XO has the moving panel on the left, seen from outside.

Two colors

Many frames come in one color inside and another outside. Give both, every time, even when they match.

Glass, in full

Number of panes, low-E coating, gas fill, and any tempered, laminated or obscure glass. Mark the units that need safety glass under local code; in the 2021 IRC that includes glass in doors and many panes next to doors (Boulder County summary).

The ratings buyers compare

US buyers compare quotes with the NFRC label: U-factor, solar heat gain coefficient (SHGC), visible transmittance, air leakage and condensation resistance. ENERGY STAR certification uses only U-factor and SHGC (ENERGY STAR), so those two go on the line.

Check old templates for a tax credit line. The federal tax credit for energy-efficient windows and doors covered units placed in service from 2023 through 2025 (IRS), so that line comes off estimates for 2026 and later installs. This is a summary, not legal advice.

Door lines need four more fields

A door line also needs the wall thickness (so the jamb fits), prehung or slab, the sill or threshold, and the lock prep: single bore, deadbolt or multipoint. Sidelights and transoms get their own sizes on the same line.

Where a configurator fits

Every field in Part 2 is a choice the buyer can make on your website: product, size, how it opens, colors, glass, grilles and hardware. A configurator asks those questions in order, shows only the options your factory builds, draws the window or door in 3D and adds up the price as they go. The estimate arrives with the opening schedule already filled in, and your team checks the sizes instead of typing them. For the buyer's side of this, see what buyers search before they order windows, and for the software behind the estimate, window and door quoting software compared.