BLOG · TEMPLATES
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.