Construction Allowance Template: Track Selections and Overages

A construction allowance template tracks the amount included for an unfinished selection, the price of the chosen item, and any adjustment that still needs approval. For a remodel, it should also tell you who must choose the product, when that decision is due, and whether the item has actually been ordered.

That last distinction matters. A homeowner can approve a faucet on Tuesday while the purchase order is still sitting in someone's inbox on Friday.

See the TGA + Kaliun remodeling case study for an actual selection workflow, including selected versus alternate materials and the distinction between selection completion and price approval. TGA and Kaliun share an owner.

Download the free construction allowance spreadsheet. It includes a blank tracker and a worked kitchen-and-bath example. No email required.

What the construction allowance template tracks

Use one row per allowance item. The workbook separates the money comparison from the approval and purchasing steps:

• Item and scope: the allowance reference, room, product, and what the amount covers.
• Original allowance: the amount included for that scope, using the pricing basis in your agreement.
• Selected amount: the comparable amount for the product the client is considering.
• Selection variance: selected amount minus original allowance. Positive means over the allowance; negative means under.
• Approved adjustment: the increase or credit actually documented through your project's approval process.
• Decision and delivery: selection deadline, responsible person, selected product, purchasing status, and approval reference.

The blank tab has 20 prepared rows. Yellow cells are inputs. The variance column calculates automatically. The example tab demonstrates an overage, a credit, and a selection that still needs a decision.

A blank selected amount stays unresolved. Entering zero means you have deliberately entered a zero-dollar selection; it does not mean the price is unknown.

Set the allowance's pricing basis before comparing numbers

An allowance is a placeholder for a defined part of the job whose final selection or price is not settled. The important question is what that placeholder includes.

For example, a $2,200 tile allowance might cover tile supply, delivery, and tax, with installation priced elsewhere. Another proposal might include installation in the same allowance. You cannot compare those allowances meaningfully until you separate the scope.

Buildertrend's selections documentation similarly distinguishes the allowance budget from the individual options a client chooses. The tracker here applies that distinction in a spreadsheet you can adapt to your own process.

Before filling in amounts, write down:

1. The quantity or area the allowance covers.
2. Whether material, labor, delivery, tax, and waste are included.
3. How overhead, profit, or other fees are treated under the agreement.
4. How an overage or credit is reviewed and documented.

Use the same basis in the original and selected amount columns. If the allowance already includes a markup, adding that markup again to the selected total will distort the comparison. If you need a refresher on the arithmetic, see markup versus margin for contractors.

Keep separate installation or scope changes outside a material-only allowance. They may belong in a related change, but they should remain visible as separate work.

Worked example: three selections, three different next steps

The following numbers are illustrative. They are not a customer case study, local price guide, or recommended allowance budget.

Assume each allowance covers supply, delivery, and applicable tax. Installation and any separate fee adjustment are excluded from this comparison. The selected amounts use that same basis.

The selected products are $260 above their combined allowances. The documented adjustments currently total a $60 credit because the $320 tile overage has not been approved.

Those are different figures answering different questions. One describes the current selections. The other describes the adjustments already documented. The workbook keeps both visible.

Cabinet hardware: approved does not mean ordered

The client approved the hardware and the $120 increase. Record the product model, finish, quantity, and approval reference. Purchasing still needs to place the order and check the supplier's confirmation.

Leave the purchasing status at Ready to order until the order is placed. A selection approval alone should not make the team assume the materials are on their way.

Bathroom tile: check the complete delivered amount

In this example, the tile quote is $2,300, delivery is $80, and the quoted tax is $140. The comparable total is $2,520. Comparing only the $2,300 product price with the $2,200 allowance would show a $100 overage and miss another $220.

The $140 is an illustrative quoted tax amount, not a tax-rate recommendation. Use the actual applicable amounts on the supplier quote.

Explain the $320 difference to the client, show the selected product, and offer an alternative within the allowance if one is available. Keep the approved adjustment empty until the required decision is documented. If the tile needs different preparation or installation work, price that scope separately.

Plumbing fixtures: record the credit as carefully as the overage

The chosen fixtures total $1,620 against a $1,800 allowance. For this example, the agreement allows a $180 credit and it has been documented.

Retain that negative adjustment in the tracker and carry it through the relevant billing record. Do not silently use the credit to cover another selection unless that treatment is agreed and recorded. Your agreement determines how unused allowance amounts are handled.

Work backward from installation to set the decision date

A selection deadline should give the team time to check the specification, obtain approval, order, receive, and inspect the material.

For an illustrative schedule, suppose hardware is needed on October 26. Allow two weeks for the supplier, one week for receiving and resolving problems, and one week to finalize the selection and place the order. That puts the client decision date on September 28 and the order target on October 5.

Use the supplier's current lead time and the project's actual working calendar. Confirm whether quoted lead times are calendar weeks or business days. A custom product can need a very different schedule.

Put the selection decision on the project schedule alongside the installation activity. The construction Gantt chart guide shows how to connect tasks and dependencies instead of keeping dates in separate lists.

Run a short selection review each week

Open the tracker with whoever owns purchasing and client decisions. Review the rows with the earliest deadlines first.

• No selection yet: confirm who is choosing and what information they need.
• Selected, price incomplete: obtain the complete quote on the agreed scope basis.
• Variance awaiting approval: document the increase or credit before treating it as approved.
• Ready to order: assign purchasing and confirm the order date.
• Ordered: check the acknowledgment, quantity, finish, and expected delivery.
• Received: inspect what arrived and record any shortage or mismatch.

Keep approval records and supplier documents under stable references. If the client changes a selection later, preserve the earlier decision and record the revision rather than making the history disappear.

The spreadsheet is a working record. It does not replace the approval requirements in the project agreement or prove that an amount has been invoiced or paid.

Common mistakes the tracker helps expose

Counting unknown selections as savings. An empty price cell means the selection is unresolved. The workbook reports missing selected amounts separately, and its net variance includes only rows with both amounts entered.

Mixing the client's allowance with the contractor's purchase cost. A customer-facing allowance may use a different pricing basis from an internal supplier cost. Make the basis explicit before comparing them. Keep confidential internal pricing in the appropriate internal record.

Adding the same change twice. An approved adjustment recorded here still needs to be reconciled with the project billing record. Do not add it again just because the selection appears in another list.

Treating a receipt as the end of the process. Materials can arrive with the wrong finish or missing pieces. Inspect them while there is still time to correct the order.

For the wider cost picture, the contractor job costing guide explains why budget, committed expenses, and payments need separate attention.

Frequently asked questions

Is an allowance the same as a contingency?

An allowance usually identifies a defined item or scope that still needs a selection or final price. A contingency is generally a reserve for uncertainty elsewhere in the project. Keep them separately labeled so an unresolved selection does not quietly consume the contingency. Procore's GMP contract guide discusses both within that contract context.

Does an allowance include labor and tax?

It depends on the allowance's written scope. Record the inclusions and exclusions beside the amount. Compare the selected total using those same inclusions. This template does not assume that all construction allowances follow one pricing convention.

Is an allowance overage automatically a change order?

The variance calculation identifies a difference; it does not authorize a charge. Follow the process in your agreement for documenting an adjustment. Record the resulting reference and amount separately from the selection variance.

Can I use the spreadsheet in Google Sheets?

The download is an Excel workbook using ordinary cell formulas. You can import it into Google Sheets, then check the formulas and formatting before using it on a job. Keep one working copy per project so different jobs' selections do not get mixed together.

Keep selections connected to the job

A spreadsheet is a useful starting point. As more people handle proposals, purchasing, and client decisions, keeping those records connected becomes more important.

Kaliun's selections and allowances tools organize project options and client selections. Its job costing tools help you review the project's costs alongside those decisions.

Book a Kaliun demo to walk through a selection and its effect on a project. Bring an example allowance from your own workflow so the conversation is concrete.