How to Track Construction Allowances: The Allowance Log
A construction allowance log is a running record of every allowance in a contract, showing the budgeted amount, what the client actually selected, the actual cost, and the difference. You track allowances by updating that log every time a selection is made, and by settling each overage or credit in writing at that moment instead of at the end of the job. One sheet, one row per allowance, updated as you go.
Allowances feel harmless when the contract is signed. Then twelve of them each run a little over, nobody adds it up, and the client meets the total for the first time at the final draw. That meeting is avoidable.
What is a construction allowance log?
It’s the scoreboard for the parts of the contract that weren’t fully decided at signing. An allowance is a placeholder dollar amount for an item the client hasn’t picked yet, like tile, lighting, or appliances. If you want the full definition, I covered it in what a construction allowance is.
The log lists all of those placeholders in one place and compares each one to reality as selections come in. You’ll also hear it called a construction allowance sheet or an allowance schedule. Same thing. What matters is that there’s only one, and both you and the client trust it.
What should a construction allowance sheet include?
A construction allowance sheet needs enough columns to answer one question at any time: where do we stand? I’d include these:
Allowance item. Plumbing fixtures, lighting, tile material, appliances, and so on.
What the allowance covers. Material only, or material and labor? Does it include tax, delivery, and your markup? Write it on the sheet so it never has to be debated.
Allowance amount. The number from the contract.
Selection made. A short description, with a reference to the signed selection sheet.
Actual cost. Calculated on the same basis as the allowance.
Variance. Actual minus allowance. Positive is an overage, negative is a credit.
Status. Not selected, selected, approved, ordered.
Change order number. The document that settled the variance.
Running total. The net of all variances so far.
The second column prevents more arguments than all the others combined. Most allowance disputes are about what the number was supposed to include.
How do you set up a construction allowance spreadsheet?
A construction allowance spreadsheet doesn’t need to be clever. It needs to be current. Setup takes four steps:
Pull every allowance from the contract and specifications. One row each. If an allowance lives only in someone’s head, it isn’t an allowance.
Add the columns above. Let the variance and running total calculate themselves.
Add a “remaining” view. A total of the allowances not yet selected, so the client can see what decisions are still open.
Share it. The client should be able to see the same sheet you see.
Here’s a simple worked example with round numbers. Say a contract has three allowances:
Lighting fixtures: $10,000 allowance, $12,500 selected. Overage of $2,500.
Tile material: $8,000 allowance, $7,200 selected. Credit of $800.
Appliances: $15,000 allowance, not selected yet.
The running net is $1,700 over, with $15,000 of allowances still open. That one line tells the client more than a stack of invoices does. It also tells them something useful before they walk into the appliance showroom.
How do you handle an allowance overage?
You handle an allowance overage when the selection is made, in writing, before anything is ordered. The process:
Price the selection on the same basis as the allowance.
Show the client the variance before they commit. People make different choices when they see the number.
Document it. A signed change order, or a signed allowance reconciliation if that’s what your contract calls for.
Collect according to your contract. I prefer overages paid when they’re approved. Rolling them all to the final payment puts your money in the check clients are most tempted to negotiate.
Update the log and send the client the new running total.
Credits get the same treatment. When a client comes in under, document it and show it on the log. It builds trust, and it gives them room for the overage that’s coming somewhere else. Whether your markup applies to overages and credits should be spelled out in the contract before the job starts. Pricing changes is its own subject, and I get into it in change order markup.
How often should the log be updated and shared?
Update it every time a selection is finalized, and share it on a regular rhythm. Tracking allowances once a quarter is the same as not tracking them.
At every selection. The row gets filled in the day the selection sheet is signed.
At every client meeting. Open with the running total. Thirty seconds, no drama.
With every draw request. Attach the current log so the client and the lender see the same picture.
At closeout. Every row should show a selection, an actual cost, and a document that settled it. No open rows.
The log works best alongside good selection sheets, since the sheet is where the actual choice and price come from. Our Selections Sheets Template gives you the sheets and the process for managing finish selections, which is the front half of this system.
How do you avoid allowance problems in the first place?
Set realistic allowances and have fewer of them. The log is a tool for managing uncertainty. The better move is to remove some of that uncertainty before the contract is signed.
Use real numbers. Base allowances on what clients at this level of house actually pick, not on what makes your bid look good. A lowball allowance is a delayed argument.
Select early. Every item chosen before contract becomes a specification instead of an allowance.
Define each one. Say exactly what’s covered.
Don’t confuse allowances with contingency. They do different jobs. See construction allowance vs. contingency.
Tie selections to deadlines. Late selections cost time, and time costs money. The custom home selections process covers how to run that.
Frequently asked questions
What is the difference between an allowance log and a selection sheet?
A selection sheet records what was chosen for each item. The allowance log compares the cost of those choices to the allowance amounts and keeps the running total.
Who pays for an allowance overage?
The client, in most contracts, since the allowance was a budget for their selection. Your contract should say how overages and credits are calculated and when they’re due.
What happens if a client spends less than the allowance?
The difference is typically credited back to the client, according to the contract terms. Document the credit the same way you’d document an overage.
Can I track allowances in a spreadsheet?
Yes. A simple spreadsheet with one row per allowance works well, as long as it’s updated at every selection and shared with the client.
BTW, if you want the selection sheets that feed your allowance log, along with the process to manage them, grab our Selections Sheets Template over at the Building Optimal Shop, where you can check out the rest of our swag to build a better business. Proceeds go to benefit, Exponencialistas, my non-profit investing in entrepreneurs transforming their communities in Latin America.