Bid Leveling Template: 5 Things It’s Missing and What to Use Instead

You’ve got four subcontractor proposals open, and one number sits well under the rest. Your template says it’s the winner. But does it say what that sub left out?

Most templates are built to compare totals. That’s the problem, because totals hide the exclusions that turn into change orders after award.

Here are five gaps worth checking in your own file, plus what a better setup looks like.

1. A Third Status for Scope: “Not Mentioned”

Most templates give you a checkbox. Either the sub included a line or they didn’t. That binary hides the most dangerous answer.

A sound matrix marks every scope line as Included, Excluded, or Not mentioned, with a proposal page reference. The page reference matters more than people think, because it forces you to find the sentence instead of assuming it.

Silence isn’t agreement. According to Provision’s buyout guidance, every blank needs written confirmation, a priced adder, or reassignment to another trade.

Watch for vague language too. “Per plans and specs” is flagged as an incomplete description because it never names the included work.

Estimators feel this first, since they’re the ones reading proposals line by line. Procurement teams feel it later, when a buyout stalls over a scope question nobody asked.

What to look for: three statuses per line, a page reference field, and a forced follow-up on every blank.

Read More – Bid Leveling: Build a Process That Catches Scope Gaps

2. Separate Rows for Base Bids, Alternates and Allowances

A single bid amount column is convenient. It’s also where apples get compared to oranges.

Better templates separate base bids, unit prices, alternates, allowances, and exclusions instead of folding them into one total. Otherwise you can’t tell what the number actually buys.

Allowances deserve special suspicion. Allowances and provisional sums can make a low bid look cheaper while leaving the final cost uncertain.

Say one sub carries a lighting allowance and another prices the full fixture package. Same trade, same plans, different risk. Your template should expose that at a glance.

The scope baseline matters here as well. Build it from the project’s drawings, specifications, and contracts, not from what subs usually include.

If you’re a GC carrying the risk, ask one question of every allowance: who pays when it’s wrong?

What to look for: distinct sections for each pricing type and a baseline column tied to the contract documents.

3. Plug Prices and a Real Leveled Total

Finding a gap is half the job. Pricing it is the other half, and plenty of templates stop at a red cell.

The standard practice is to add a plug price for every gap, using an estimate, another bidder’s price, or a documented allowance. Document where the number came from, because someone will ask later.

Then compare on the right figure. The leveled total, not the original submitted amount, is what belongs in the final comparison.

A template without adjustment rows pushes this math into side calculations. That’s where version errors creep in.

One available option supports up to 5 bidders and includes scope checklists, adjustment rows, and leveled totals. That’s a decent baseline, though it tells you where the ceiling sits.

What to look for: adjustment rows per bidder, a source note for every plug, and a leveled total that updates automatically.

Read More – Bid Leveling Template or AI Workers: What Really Saves Estimator Time

4. Tracking for “By Others” and Blanket Exclusions

This is the gap that costs real money. A line reading “by others” doesn’t remove the work. It moves it.

Per Buildern’s bid leveling guide, “by others,” owner-furnished items and blanket exclusions can push labor, materials, cleanup, protection, permits, or disposal costs back onto the general contractor. You’ll rarely see them on the bid form.

Your template needs a dedicated exclusions field that records the exact wording and names who absorbs the cost. Without it, the exclusion lives in a PDF nobody reopens.

Subcontractors should expect these questions. The sub that clarifies up front is easier to award than the one who answers after a dispute.

Which exclusions does your current sheet capture? If the answer is “whatever we typed in notes,” that’s your gap.

  • Exact exclusion wording, copied from the proposal
  • The party assumed to cover it
  • A priced adder or reassignment decision
  • Date the clarification was confirmed

What to look for: a structured exclusions log, not a free-text notes column.

5. Qualifications, Addenda and Schedule Assumptions

Price and scope aren’t the whole bid. A template that ignores the paperwork around them misses disqualifying problems.

A solid bid tab tracks addenda received, proposal date, revision, bid validity, bonding, insurance, warranties, schedule assumptions, and mobilization. A sub who priced before Addendum 3 isn’t bidding the same job.

Schedule terms bite after award. Overtime exclusions, escalation clauses, lead-time assumptions, and mobilization limits can create costs once the contract is signed.

Bonding and insurance gaps can also lead to surety trouble or a pulled award. Check them before the number gets attention, not after.

Is a spreadsheet enough? For a small job with three bidders, probably. For complex projects, a basic spreadsheet is a poor fit when you have frequent revisions, many alternates or cross-trade gaps.

Looking ahead, AI parsing is starting to read proposals and flag missing items, but it still needs a good baseline and an estimator’s judgment on every plug.

What to look for: a qualifications section with addenda acknowledgment, validity dates and schedule terms beside the price.

Read More – Bid Leveling Software Features Construction Teams Should Check

A Worked Example: When the Cheapest Bid Isn’t

Picture a drywall package with three bidders. Bidder A comes in lowest. Its proposal says “per plans and specs” and carries a blanket exclusion for cleanup and protection.

That wording is exactly what gets flagged as an incomplete bid description. It names no specific included work, so you can’t confirm what the price covers.

Bidder B lists every wall type by sheet reference. Bidder C includes a finish allowance. Now you’re comparing three different documents, not three prices.

Start by marking each line on your baseline as Included, Excluded or Not mentioned. Every Not mentioned cell on Bidder A gets a call or an email before anything else happens.

Next, price what stays open. Use an estimate, another bidder’s price, or a documented allowance as the plug, and write down which one you used.

The cleanup exclusion matters most here. As Buildern’s guide points out, blanket exclusions can shift cleanup, protection and disposal costs back to the GC. That cost lands on your general conditions, not on the sub.

Bidder C’s allowance is a different animal. According to SMA Estimating, allowances can make a bid look cheaper while the final cost stays uncertain, so you’d carry a documented figure for the real finish scope.

Once the plugs are in, compare on the leveled total. Often the ranking flips, and the original low bidder ends up second or third.

Who’s affected? The estimator does the plugging.

The preconstruction lead signs off on the assumptions. The sub who wrote the clean, specific proposal finally gets credit for it.

A template that can’t hold this chain of status, plug and source is really just a list of totals.

Quick Answers Before You Rebuild Your Template

New to the terms? Bid leveling is the process of adjusting subcontractor bids to a common scope so the numbers compare fairly. A bid tab records what each sub submitted, and leveling is what you do with it afterward.

To compare bids fairly, start with one scope baseline and hold every bidder to it. Then fill every gap with a documented plug.

Handling exclusions follows the same rule. Confirm in writing, price an adder, or reassign the work to another trade.

Frequently Asked Questions

What should be included in a bid leveling sheet?

Scope lines marked Included, Excluded or Not mentioned, with page references. Add separate rows for base bids, alternates and allowances, plus plug prices and a leveled total.

How do you handle exclusions in subcontractor bids?

Get written confirmation, price an adder, or reassign the work to another trade. Never treat a blank as an inclusion.

What’s the difference between a bid tab and bid leveling?

A bid tab records what each sub submitted. Leveling adjusts those bids to a common scope so you can compare them fairly.

Is a spreadsheet template enough for bid leveling?

For small jobs with few bidders, yes. Once you’ve got many bidders, frequent revisions or cross-trade gaps, it gets error-prone fast.

How many bidders can a free template handle?

One available template supports up to 5 bidders. Beyond that you’ll be adding columns and fixing formulas by hand.

How Palcode.ai Can Solve It

Palcode.ai offers a Bid Leveling AI Worker that parses subcontractor proposals, maps them to a common scope and flags inclusions, exclusions and gaps. Estimators review the flagged lines instead of retyping every proposal into a sheet.

Check Your Template Against a Live Bid Set

Bring a recent set of subcontractor proposals and see how Palcode.ai levels them against your scope. It’s a quick way to find out what your current template misses.

Check Your Template Against a Live Bid Set

About the Author

Written by the Palcode team, builders of AI Workers for commercial construction estimators.

Report on AI- Thinking : The Future of Construction Leadership! Get your free copy now

X
Scroll to Top