Home Builder Selection Sheet: Track Allowances and Deadlines With AI

Give every selection its own row with five columns that matter: allowance, chosen price, needed-on-site date, supplier lead time and status. Work the decision deadline out backwards from the schedule, add a formula that flags any selection that is late or about to be, then paste the flagged rows into an AI assistant to draft a reminder for each client.

The pages that rank for this are fillable selection sheets, which record what a client chose. A builder's tracker answers a different question: which decisions are late, and what will each one cost the schedule? The deadline written in the contract is rarely the date that matters. The date that matters is the last day an order can be placed and still arrive when the trade needs it, and a spreadsheet can work that out for every row without anyone remembering to.

Follow me on Instagram@sagnikteaches

One row per decision: the columns and the formulas

Build this in Excel or Google Sheets; the formulas below work in both. Put the example row in as you read, using the exterior brick as the test case. Columns A to H are typed in, and I to O calculate themselves.

Connect on LinkedInSagnik Bhattacharya

The formulas for row 2 are below. Copy them down the column. Cells R1 and R2 hold two settings that come from your contract: your markup on overages, and whether an unused allowance is credited back. Leave the 12 per cent and the "Yes" as placeholders until you have read your own contract.

Subscribe on YouTube@sagnikteaches

I2  =F2-G2
J2  =I2-H2
K2  =J2-TODAY()
L2  =IF(OR(E2="Ordered",E2="Delivered"),"Done",IF(E2="Chosen",IF(I2<TODAY(),"ORDER NOW","Ready to order"),IF(K2<0,"OVERDUE",IF(K2<=14,"Due soon","On track"))))
M2  =IF(OR(E2="Ordered",E2="Delivered"),0,MAX(0,TODAY()-I2))
N2  =IF(D2="","",D2-C2)
O2  =IF(D2="","",IF(D2>C2,(D2-C2)*(1+$R$1),IF($R$2="Yes",D2-C2,0)))

R1 = 12%   (builder's markup on overages, from the contract)
R2 = Yes   (unused allowance is credited back, from the contract)

Read the flag formula as a decision tree. A selection that is ordered or delivered is done. One that the client has chosen but you have not ordered is either ready to order or, if the order-by date has passed, a problem on your side, labelled ORDER NOW so it cannot hide as a client delay. Anything else is a client decision outstanding. It is overdue if the deadline has passed, due soon if it is within 14 days, and otherwise on track. Change the 14 to 30 for slow items such as kitchen cabinets, which need a longer conversation than door hardware.

Two more set-up steps make the sheet usable. Add a drop-down list to the status column (Data, then Data validation, in both Excel and Sheets) so nobody types "choosen" and breaks the formulas. Then add conditional formatting to column L: red for OVERDUE and ORDER NOW, amber for Due soon, grey for Done. In Sheets it is under Format, then Conditional formatting; in Excel it is on the Home tab. A row-wide rule with a custom formula such as =$L2="OVERDUE" colours the whole line, which is easier to see on a phone.

Deadlines worked out backwards from the schedule

The key move is that the client's deadline comes from the build schedule, not from the date of the contract or the builder's convenience. Start at the date the trade needs the material on site. Take away the supplier's lead time, which gives the last safe order date. Take away a buffer for you to price the choice, get a written quote, confirm stock and raise the order, and you have the date the client must have decided.

Say it is 9 March, and the example house has ten selections on the sheet. The exterior brick is needed on site on 30 March for the bricklayers. The supplier needs 28 days, so the order-by date is 2 March. With a 7-day buffer the client needed to decide by 23 February. Today is 14 days past that, and 7 days past the order-by date, which means the schedule is already moving. Sorted by decision deadline, the full sheet reads as follows (illustrative dates and figures, as of 9 March).

Read the table the way a site manager would. One item is overdue and already costing days. One is due soon: the interior doors have exactly 14 days left, so the amber flag has just lit. The kitchen cabinets are flagged "On track" with 23 days to go, but they carry the biggest allowance, $14,000, and a 56-day lead time, so waiting for amber would be a mistake. Start that conversation now, and treat the flag as the backstop rather than the plan.

The dates you feed in are only as good as the schedule behind them. When a trade moves, update column F and every deadline below it moves too. If your programme lives somewhere else, the habits in the small builders' scheduling tutorial keep the needed-on-site dates honest.

Flags that show who is holding up the build

Put a few summary cells above the table so you can see the state of the job without scrolling. Each uses a single formula over the ten rows. On the example they return these values.

The undecided figure is your exposure. If the eight undecided selections were to land 8 per cent over their allowances, which is a what-if and not a forecast, that would be $4,768 of upgrade conversations. Having them early, with the numbers in front of the client, is much easier than having them in the week the order is due. The slip-days figure needs careful reading: it says that if the client chose today, the order would go in 7 days after the last safe date. Whether the bricklayers' start moves by 7 days, or less because the supplier can shorten the lead time, is for the site manager to confirm, and the sheet should never be quoted to a client as a promise.

A flag only helps if something happens when it changes. This ladder pairs each flag with an action and a person.

Allowances: over, under and the change form

An allowance is a budgeted amount for something the client has not chosen yet. If the choice costs more, the client pays the difference, often with a markup that your contract sets. If it costs less, the contract may credit the difference or may not. Your contract decides all of this, and the sheet only does the sums. Have a solicitor confirm how your contract treats overages and credits, because the two settings in R1 and R2 turn that wording into numbers.

Two rows on the example have a chosen price. The plumbing fixtures have a $3,600 allowance and the client chose $4,350, which is $750 over. With the 12 per cent markup in R1, the client pays $750 x 1.12 = $840. The lighting package has a $2,800 allowance and was ordered at $2,540, which is $260 under; with R2 set to "Yes", the client is credited $260. The net change so far is $840 - $260 = $580, which is the value in the summary cell.

Whenever a chosen price exceeds an allowance, the client should sign a change form before you order. The figures on the form come straight from columns N and O. An AI can lay out the wording, but it should never calculate, because an arithmetic slip on a signed form is a dispute waiting to happen. This is the form for the plumbing fixtures, with the numbers pasted from the sheet.

Selection change. Item: plumbing fixtures. Allowance in the contract: $3,600. Your selection: $4,350. Difference: $750. Our fee on the difference under clause [x] (12 per cent): $90. Amount added to the contract price: $840. By signing below you approve this change, and we will place the order by 11 May so the fixtures arrive for 25 May. [signature and date]

Check the arithmetic yourself: $750 x 0.12 = $90, and $750 + $90 = $840. The same discipline applies to pricing variations and change orders more widely. One more trap on the allowance column is per-unit allowances. If the contract says $60 per square metre for floor tile and there are 70 square metres, the allowance is $4,200, not $60. The sheet's allowance column holds the total, with the unit rate and the quantity in a note beside it.

Getting the allowance schedule out of the contract with AI

Typing ten to forty allowance lines by hand is slow and error-prone, and a table from a PDF is the kind of job an AI does quickly. It is also where quiet mistakes get in, so pair the extraction with a check. Paste only the allowance schedule, not the whole contract, which carries names, addresses and payment terms that the task does not need.

Below is the allowance schedule from a building contract. Output a table with these columns: Item | Area | Allowance ($) | Unit (lump sum / per square metre / each) | Quantity if stated | What the allowance covers (quote the words, e.g. supply only, supply and fit) | Clause number.
Do not add up any totals. If a figure is unclear, write [UNCLEAR]. At the end, list any line that mentions "allowance" or "provisional sum" that you did not put in the table.

Now check it. Add up the Allowance column in the sheet and compare it with the total the contract states. In the example, the contract's allowance total is $66,000, and the first table the AI produced summed to $60,660. The $5,340 gap hid two errors. The door hardware line ($1,200) sat in a footnote, and the AI skipped it. The floor tile appeared as 60, the per-square-metre rate, instead of $4,200, which accounts for the other $4,140. Both were found by the same two-minute check: sum the column, compare it with the contract, and read the unit column against the numbers. Do the sum in the spreadsheet, never in the chat, because chat arithmetic over a long list is not something to rely on.

Reminders that say what a late decision will cost

A reminder that says "please choose soon" gets ignored. One that says what the date protects and how many days are already lost gets answered. Paste the flagged row into the assistant with a tight instruction, and tell it not to do any maths, because the sheet has already done it.

You are drafting a short message from a home builder to a client about one selection. Use ONLY the figures and dates in the ROW below. Do not calculate, estimate or change any number or date. If a figure you need is missing, write [MISSING: name].

ROW: Item: Exterior brick | Flag: OVERDUE | Needed on site: 30 March | Supplier lead time: 28 days | Order-by date: 2 March | Slip days so far: 7 | Allowance: $11,000 | What it holds up: bricklayers' start, scaffold hire | Options already shown: three samples

TONE: warm, direct, no blame, no threats, no jargon. Under 110 words. One clear request with a date: [date to reply by]. Offer a call or a showroom visit. Explain what the delay does to the schedule using only the slip days and the "holds up" text. Do not mention penalties or the contract.

A message of this sort comes back, and you then edit and send it yourself.

Hi [first name], we still need your choice of exterior brick from the three samples we looked at. The supplier needs 28 days from the order, and to keep the bricklayers' start on 30 March the order had to go in by 2 March, so we are already 7 days behind on this item. Each further day of waiting moves the bricklayers' start, and the scaffold booking, back by about a day. Could you let me know by [date to reply by]? I can bring the samples round or we can talk it through by phone today. [your name]

Check two things before you send. "About a day for each day" is an inference from the slip rule, so confirm it with the site manager first, since a supplier may be able to shorten the lead time. And watch for consequences the AI adds that the row never mentioned, such as "this could delay completion by weeks". Delete them. Now the gentler version, for the interior doors, which are due soon.

Hi [first name], a heads-up on the interior doors and trim. We need your choice by 23 March, which is 14 days from now, so the order goes in by 30 March and the doors arrive for 20 April. The allowance is $5,400. I have put the three door styles and the trim profiles on one page so you can choose quickly: [link]. If you would like to see them in person, tell me a day that suits. [your name]

The first message asks for a decision that is already late, so it names the damage. The second asks early and names the benefit. Keep a column in the sheet for the date of the last reminder, so nobody sends the same nudge twice and the record shows a client was told on a given day. How AI helps with the wider job of client updates is covered in the tutorial on AI tools for home builders.

The Monday note for the site manager

Once a week, filter the sheet to every row whose flag is not Done or On track, paste those rows in, and ask for a one-paragraph note. Again the rule is that the AI reports and does not calculate.

Below are the rows from our selection tracker that are OVERDUE, Due soon, ORDER NOW or over allowance. Write a note of under 150 words for the site manager. Order the items by slip days, then by days left. For each item give: the item, what the flag means in plain words, what it holds up, and one action. Use ONLY the numbers in the rows. Do not add totals or estimates.

On the example data, the note reads like this. Check each figure against the table before you forward it.

Selections at risk, week of 9 March. 1. Exterior brick: overdue by 14 days against the decision deadline and 7 days past the last safe order date. It holds up the bricklayers' start on 30 March and the scaffold hire. Phone the client today. 2. Interior doors and trim: 14 days left (decide by 23 March, order by 30 March). Send the second reminder with the one-page options. 3. Plumbing fixtures: chosen at $4,350 against a $3,600 allowance, so $750 over and $840 with markup. Send the change form and order by 11 May. 4. Kitchen cabinets: on track on paper, but the largest allowance at $14,000 and a 56-day lead time. Get a choice before 1 April.

Three ways the sheet quietly goes wrong

Spreadsheets fail silently, which is why a tracker needs a few habits around it.

• Dates read the wrong way round. A date typed as 03/06 can be read as 6 March or 3 June, depending on the settings of the computer. If that happens, every deadline in the row is wrong and the flag still looks confident. Use the date picker or type dates in a fixed form, then test one row: put in a known date, add 1 day with a formula, and check the answer by eye.
• Lead times that were never updated. A supplier quotes 28 days in January and 42 in March, and column G still says 28. Update the lead time whenever a supplier gives a new figure, and add a "confirmed on" date beside it so a stale figure is visible.
• Old copies. The TODAY function recalculates when the file opens, so a screenshot or an export shows the day it was taken, not today. Send clients dated exports, keep one working sheet in one place with two people able to edit it, and protect the formula columns so nobody overtypes them.

One habit ties these together. Update the status column at the weekly site meeting, in the room, before anyone leaves. A flag is only as current as its last status change, and a status that nobody updates turns an alarm into wallpaper.

When a spreadsheet stops being enough

A sheet like this carries a small builder a long way, but it has limits: it has no client log-in, no signature capture and no automatic reminder, and two people editing at once can collide. Builder software covers those gaps. JobTread's selections page, for example, describes a status for each selection, overages and underages worked out against each allowance, change orders created for overages, choices made and signed in the customer portal, and an option to let clients move unused allowance to other items. It says nothing about decision deadlines worked back from the schedule, so ask to see how that would be handled in a demonstration before you pay. The page shows $199 a month with one internal user, extra internal users at $20 each on monthly billing for users 2 to 10 (20 per cent off on an annual plan, which brings the base to $159 a month), and says every plan includes unlimited customer and vendor portal users. Prices and features change, so treat those as a snapshot taken in November 2026.

The decision is simple arithmetic. One user on that plan comes to $199 x 12 = $2,388 a year at the monthly list price. If a week's slip on a build costs you $3,000 in idle trades and extended site costs (replace that with your own figure), then a year of software costs less than one such week. Move across when you have several active builds, more than two people editing, or clients who would rather choose and sign in a portal than by email. Until then, the sheet plus a Monday note is cheap and works. For how the app options compare, see AI software for custom home builders and JobTread pricing for a five-person builder. To set allowances properly before a build begins, see the custom home builder proposal tutorial.

Questions builders ask about selection trackers

Should clients be able to see this spreadsheet?

Not the working sheet. Share a read-only view or an exported list with the item, the choice, the deadline and the status. Keep lead times, buffers, slip days and your markup in a separate internal tab, because those columns invite arguments if clients read them without context.

How much buffer sits between the decision deadline and the order-by date?

Enough for you to price the choice, get a written quote, confirm stock and raise the order. For many builders that is about a week, but the right figure is in your own history: look at your last five orders, find the longest gap between a client choosing and the order being placed, and use that.

What if my contract does not mention selection deadlines?

Then the sheet is a planning tool, not a lever. Ask a solicitor to add a clause that ties late decisions to schedule changes and costs, and until then use the tracker for early warnings and polite reminders rather than penalties or threats.

Can I use the AI inside Excel or Google Sheets for the reminders?

Excel's COPILOT worksheet function was retired on 14 September 2026, though the Copilot side pane remains. Google Sheets has an AI function, but it needs a plan that includes Gemini in Sheets and its results do not refresh on their own. Pasting the flagged rows into your usual assistant is simpler and keeps you in control of every figure.

Further reads

• JobTread vs Buildertrend for a Small Builder: Price, AI and Fit — Compare two builder apps if the spreadsheet starts to strain.
• Writing Client Updates and Snag Lists With AI for Builders — Weekly client updates and snag lists written with AI.
• Remodelling Proposal Template: Scope, Allowances and Terms With AI — Set allowances and exclusions in the proposal itself.
• Builder Invoice Template: Stage Payment Requests Written With AI — Stage payment requests that carry the change-form amounts.
• AI Estimating Software for Small Builders: Six Options Compared — Six estimating tools compared, for the numbers behind allowances.
• 60 AI Prompts for Google Sheets That Actually Work (Copy, Paste, Automate) — Prompts for Sheets formulas, cleaning and summaries.
• Home Builders AI: Tools and Cost for Weekly Buyer Progress Updates — The tools and monthly cost behind weekly AI-written buyer updates for a small home builder, from a $20 assistant to a full portal, with the routine and checks.
• AI for Electrical Estimating: Set Fitting Allowances and Provisional Sums — Fitting allowances versus provisional sums in a domestic quote: how to set the amounts, who chooses, how to settle overspend, and where AI drafts the wording.
• Bathroom Renovation Scope of Work: Draft Room-by-Room Lines With AI — How to turn site notes into numbered scope lines for each bathroom, with exclusions, allowances and client-supplied item rules that prevent disputes.
• AI in Home Building: Buyer Enquiries, Warranty Calls and Handovers — Three jobs for a small home builder: replies to buyers, sorting warranty calls and finding gaps in handover packs, each with a named sign-off.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: JobTread pricing page and Selections and Allowances feature page; Microsoft Support notice on the retired COPILOT function; Google's help page on the AI function in Sheets; OpenAI and Anthropic business-plan data-use pages. Dates, prices and allowances in the example are illustrative.