Contractor Estimate Template Excel Free: The Payment Schedule Most Templates Skip

Download any contractor estimate template Excel free offers and you get the same thing: a header with your logo, a list of line items, a markup cell, a total, and one line near the bottom that says something like "50% deposit due at signing, balance due on completion." The math on the line items is usually fine. That last line is the problem. It is the only part of the estimate that decides how much of your own cash the job eats, and on a California home improvement job it is also a misdemeanor.

California Business and Professions Code section 7159.5 caps the down payment on a home improvement contract at $1,000 or 10 percent of the contract amount, whichever is less. It also says that apart from that down payment, you may "neither request nor accept payment that exceeds the value of the work performed or material delivered." Violating either rule is punishable by a fine of $100 to $5,000, up to a year in county jail, or both, and it is cause for license discipline.

So on a California remodel the free template's deposit line is illegal, and the legal replacement most contractors reach for, a small deposit plus "balance on completion," quietly turns them into the homeowner's lender. This article builds the part of a construction estimate that free templates skip: the progress payment schedule, generated from the same cost lines as the price, with the cash exposure calculated before you sign.

One Kitchen, Priced the Way Every Template Prices It

Here is the job we will run through the whole article: an eight-week kitchen remodel in California. The costs below are what the contractor pays out, in the week they go out the door. The cabinets are special order and the supplier wants payment when the order is placed, which is normal for semi-custom lines.

Priced with a 25 percent markup, the contract amount is =ROUND(51750*(1+0.25),0), or $64,688. Gross profit is $12,938, a 20.0 percent margin. If markup and margin still blur together for you, the profit margin calculator article separates them; for this piece the 25 percent is a fixed input.

Now look at week 1. Before the first cabinet box shows up, $17,250 has left your account, and $14,200 of it bought something the homeowner will not see for four weeks. Under section 7159.5 you cannot bill for those cabinets until they are delivered. That single line drives almost every number that follows.

Four Payment Schedules, Four Different Businesses

Same job, same price, same profit. The only thing that changes is the payment schedule written at the bottom of the estimate. Assume each progress bill is paid one week after you send it, and that costs go out during the week before any receipt lands. "Peak exposure" is the most of your own money sunk into the job at any point.

Three things in that table are worth stopping on.

First, even the illegal 50 percent deposit does not fund the job. Schedule A starts with $15,094 of the owner's money in your account after week 1, and by week 8 you are $19,406 underwater waiting for the final check. The deposit only moves the hole later.

Second, look at the interest column. At 10 percent, carrying schedule B for nine weeks costs $550.58. That is not why schedule B is dangerous. It is dangerous because $50,750 is 98 percent of the job's total cost and almost four times its gross profit. For eight weeks you have funded the whole kitchen, and on the day you finish the owner holds $63,688 of your money and every piece of leverage. The cost of B is the jobs you cannot take and the one owner who finds something to dispute.

Third, schedule C cuts peak exposure by $22,600 without asking the homeowner for a dollar more than the law allows. That is the schedule a contractor estimate should print, and it has to be calculated, not typed.

Build the Payment Schedule From the Cost Lines

The reason free templates default to "50% down" is that they have no way to know when value is delivered. The line items carry a description and a price, nothing else. Add two columns and the schedule writes itself.

The estimate sheet

Put each cost line in rows 5 through 24 with four columns:

• Column A: description
• Column B: your cost
• Column C: the week the cost is paid (drives your cash out)
• Column D: the week the work is performed or the material is delivered to the site (drives what you can bill)

For most lines C and D are the same week. For the cabinets, C is 1 and D is 5. For the countertop fabricator deposit, C is 5 and D is 6. Those two gaps are exactly where the law and your cash flow disagree, and a template without column D cannot see them.

Above the lines, three control cells:

• H2, markup: 25%
• H3, contract amount: =ROUND(SUM(B5:B24)*(1+H2),0) returns $64,688
• H4, down payment: =MIN(1000,0.1*H3) returns $1,000

H4 is the statute, written as a formula. Type 50% into it by habit and a check cell next to it should catch you: =IF(H4>MIN(1000,0.1*H3),"OVER CA CAP","OK").

The progress bill table

Pick milestones the homeowner can see and verify: rough-in inspected, floors down, cabinets set, counters in, final. For each milestone week in column K, the value delivered to date at contract price is:

=SUMIFS($B$5:$B$24,$D$5:$D$24,"<="&K8)*(1+$H$2)

That formula is the heart of the estimate. It sums cost only for lines delivered by that week, then prices them at the contract markup, which is what "value of the work performed or material delivered" means on a fixed-price job. The bill for each milestone is value to date minus everything already billed, deposit included: =ROUND(L8-SUM($M$7:M7),0), with M7 holding the deposit.

This is also the format section 7159.5 asks for. When a contract calls for payments before completion, it must include "a schedule of payments in dollars and cents specifically referencing the amount of work or services to be performed and any materials and equipment to be supplied." A percentage schedule does not meet that. The table above does, and it came out of the cost lines instead of out of your head.

Add a control that the payments sum back to the contract: =IF(ROUND(SUM(M7:M12)-H3,2)=0,"OK","SCHEDULE DOES NOT TIE"). Rounding each bill to the dollar can leave a few dollars stranded; put the remainder on the final payment, never on an early one.

If you already bill larger jobs against a schedule of values, this is the same idea at kitchen scale. The schedule of values template covers the commercial version, where the owner's lender approves each line.

Calculate Your Cash Exposure Before You Sign

The payment table tells the homeowner what they pay. You need the other side: what you are out of pocket, week by week. Build a ten-row block with the week number in column A starting at row 30.

• Cash out, column B: =SUMIFS($B$5:$B$24,$C$5:$C$24,A30)
• Cash in, column C: the progress payment from the milestone one week earlier (your collection lag), pulled with =SUMIFS($M$7:$M$12,$N$7:$N$12,A30), where column N holds each bill's expected pay week
• Low point during the week, column D: =E29-B30, previous balance minus this week's costs, before anything arrives
• Balance at week end, column E: =D30+C30

Start E29 at the down payment. Then one cell answers the question the whole estimate exists for: =-MIN(0,MIN(D30:D39)). On schedule C it returns $28,150, reached in week 3, the moment before the first progress payment lands. Half of that, $14,200, is the cabinet order.

Put a hard limit next to it. If your available cash plus unused credit line is $60,000 and two other jobs already need $30,000, this job gets $30,000: =IF(-MIN(0,MIN(D30:D39))>H6,"RESTRUCTURE BEFORE SIGNING","OK"), with H6 holding the cash you can assign to this job. Schedule C passes at $28,150. Schedule B fails by $20,750, and you find that out on the estimate instead of in week 6.

For the full picture across every open job, the per-job numbers roll into a company forecast; the construction cash flow forecast shows how to stack them.

What to Do About the Cabinets

On this job the special order is the problem. You cannot bill it until it is delivered, and you pay for it four weeks before that. Every fix changes a different number, so run them all on the same sheet before deciding.

Weekly billing buys only $2,812 of exposure relief over five milestones, because the cabinets still sit in week 1 either way. Billing frequency is not the lever on this job. The purchase terms are.

Option F halves exposure but costs $3,550 of profit, 27 percent of the job's margin, and hands the owner a supplier relationship you will have to coordinate around. It makes sense when you are close to your cash limit and the job is otherwise attractive. It does not make sense as a habit.

There is one more option the statute itself offers. A contractor who furnishes a performance and payment bond, or a bond equivalent or joint control approved by the registrar, is exempt from the down payment cap and the value-delivered rule. The statute also requires two years of active licensure before you can apply for the blanket bond. Price the bond premium against the $28,150 you are carrying before assuming it is too expensive.

A Payment Schedule Checklist for Every Estimate

Before an estimate leaves your office, the sheet should answer each of these without you doing arithmetic:

1. Down payment cell is a formula tied to the contract amount, not a typed percentage.
2. Every cost line has a paid week and a delivered week.
3. Progress payments are in dollars and cents, each tied to named work, and they sum to the contract amount.
4. No payment exceeds the value delivered to date. Add =IF(SUM($M$7:M8)-$M$7>L8,"OVER VALUE","OK") beside each bill.
5. Peak exposure is calculated and compared to the cash you can actually assign to this job.
6. Any line where the paid week comes well before the delivered week has a plan: supplier terms, owner purchase, or a bond.
7. Each progress payment triggers a lien release request, because the homeowner may withhold further payments until the releases are furnished. The lien waiver tracker keeps that from stalling your next draw.

Outside California the numbers change but the structure does not. Other states set their own deposit limits for home improvement work; look up yours and put it in H4 as a formula. Where no cap exists, schedule C is still the one that keeps you from funding the owner's kitchen.

If you also send formal bid packages on larger work, the bid proposal template covers the presentation side. This article is about the half of the estimate that decides whether winning the job is good news.

The Recommendation

Stop using a contractor estimate template that ends in a total and a typed deposit percentage. On this kitchen, that line either breaks California law by $31,344 or, written legally, ties up $50,750 of your cash to earn $12,938. The fix is two columns (paid week and delivered week) and one SUMIFS, and it drops the exposure to $28,150 on the same price and the same profit. Then work the biggest gap between paid and delivered, which on most remodels is special-order material, before the owner signs.

If you want this wired up without building it from scratch, the Construction Budget Tracker starts from your estimate broken down by line item, projects cash flow from your payment schedule, tracks every supplier and sub payment by due date, and prints summary sheets for clients and lenders. Add the paid-week and delivered-week columns to its estimate lines and the schedule above falls out of the same workbook you use to track the job.