30-min call with RobBook a proof-of-concept call
Job 02 · Project management and billing

// Sitework contractors · Unit price quantity sheets

Unit price quantity sheets, drafted item by item with the backup attached.

On a unit-price contract, you get paid for what you can show you put in the ground. A free AI proof of concept tries drafting that monthly sheet on copies of 20 to 30 sheets your team already turned in, with the daily reports, tickets and survey behind them. Your reviewer, whoever on your staff knows those sheets best, compares every draft line with what you actually submitted.

Book a proof-of-concept call30 minutes with Rob
Past sheets
20 to 30
Pay estimates touched
None
Quantities agreed with an owner
None

// The one job

From a month of field records to a sheet the owner can check

Each month somebody adds up what the field did: feet of pipe from daily reports, tons of stone and asphalt from load tickets, yards of cut and fill from the surveyor, and counts of manholes and inlets. They set that against the bid schedule, item by item, and work out what the month added, the quantity to date, and how close each item is to its bid quantity.

In the test, AI reads copies of those records and drafts the quantity sheet: each bid item with its unit, the quantity this period and to date, the documents behind it, and a mark on any item running past the bid quantity for your project manager. Nothing goes to an owner or into a pay estimate. Your reviewer checks the draft against the sheet you really sent.

Month's field recordsOne job
Daily reports
Load tickets
Survey
Bid schedule
Bid itemSourceQuantity
Illustration, not a real job
Added up
item by item
Quantity sheetDraft
Job
Period
Pay estimate no.
Project manager
To dateBid quantityBackup
Made-up sheet, for illustration

// What makes it hard

Where a quantity sheet stops adding up

Some bid items are never measured. Texas DOT's construction manual says an item marked as a plans quantity measurement item needs no field measurement: monthly estimates can rest on the plan quantity or an agreed formula, such as a portion of the plan quantity installed, and field checks may verify dimensions but shouldn't set the number. Florida's documentation manual gives the same warning and allows measurement only for field changes or plan errors. South Dakota's manual wants the reason for moving a plan quantity written into the change order, and rules out as-built and normal variation as reasons. A sheet built by adding up tickets gets those items wrong, so the draft reads each item's basis of payment before anything else.

Earthwork in progress is an estimate. South Dakota treats excavation as impractical to measure accurately while it's underway. Progress quantities are estimates with the method noted, and one final entry corrects the difference once the measured total is in. Cross sections and volume computations back that total, and a three-dimensional method or measurement in the hauling vehicle has to be accepted by the engineer and shown in the record. Your trucks carried loose yards, your surveyor measured in place, and the two won't agree without a shrink or swell factor your team chose. The draft labels each line as survey, ticket, count, dimension or estimate, and converts one into another only where your records show the factor.

Tickets rarely transfer straight across. In South Dakota's asphalt records, the quantity to the road is the ticket total minus whatever was entered as road waste. Salvaged mix stockpiled for later is measured in the pile and converted at a fixed factor of tons per cubic yard, and extra haul pays per ton-mile, with records of where the material came from and where it went. Washington's manual sets decimal places by the unit bid price and rounds at the first summation, a day's ticket total, instead of ticket by ticket. It also has an error on a signed source document fixed with a line through it, dated and initialed, while South Dakota corrects a paid quantity with a new entry for the difference. The draft follows your job's conventions and carries a correction forward as a correction.

An overrun is a contract event. Federal-aid contracts carry a standard clause, 23 CFR 635.109: a major item that grows past one and a quarter times its original quantity, or falls below three quarters of it, is a significant change, and any adjustment reaches only the portion beyond that line. Texas fixes its major items at bid, and its manual says neither a change order nor an overrun can make a bid item into one later. Federal construction contracts using the FAR clause on variation in estimated quantity set a narrower band, either side may demand an adjustment, and a time extension request is due in writing within 10 days of the start of the delay unless the contracting officer allows longer. Alabama's manual has project managers secure approval of an anticipated overrun before the work goes ahead, and reports quantity to date and percent complete by item each month. Every item at or past its bid quantity gets marked, and the clause stays for your project manager to read.

Your reviewer will read the backup column. Washington's manual says any payment has to be substantiated by project records at whatever stage the work has reached, and South Dakota asks for enough detail that someone unfamiliar with the project could follow how a quantity was arrived at. That is the standard your project manager will hold the draft to: does each line point to the daily report, ticket batch or survey file it came from, does last month plus this month equal the total, did idle items stay put, and did the draft hold any item it couldn't support?

// What you send

Sheets you already turned in, and what stood behind them

Several jobs and months
Copies only
01

20 to 30 past quantity sheets

Monthly sheets or pay estimate quantity pages from several unit-price jobs, with the owner's or engineer's revised version wherever it differed. One that got cut teaches more than a clean one.

02

The field records behind them

Daily reports, load ticket batches, survey quantity reports and any inspector-signed counts for those months, as they sat in the job files.

03

The bid schedule and its rules

Each job's bid schedule with units and bid quantities, the pages that say how items are measured and paid, and any change orders that added or moved items.

04

An NDA, or look-alike jobs

The NDA comes before anything moves. If job files have to stay put, we build look-alike jobs with your reviewer. We don't sign in to your job cost or accounting system or an owner's pay portal.

// Before it starts

Agreed before any job file moves

Quantity sheets are judged on the numbers and on the backup, so the owner settles how each one scores.

Terms for the quantity sheet testOwner signs off
Your reviewer
The owner's pick: usually the project manager or engineer who builds these sheets
Success criteria
Written first: quantity to date, backup cited, overruns marked
The jobs
Several, picked by your reviewer, with earthwork, pipe and paving items in the mix
Who decides
Your team, on every quantity billed and every talk with an owner
Price
A range for the live job, before day one
NDA
Signed before any job file is copied

// How the test is judged

Line by line against the sheet you submitted

Bid item by bid item
on the same months
On the same 20 to 30 sheetsThe sheet you submittedDraft from the test
Every bid item present, with the right unitFilled in on your sheetsFilled in on your sheets
Basis of payment read correctly, plan or measuredFilled in on your sheetsFilled in on your sheets
Quantity this period and quantity to dateFilled in on your sheetsFilled in on your sheets
Backup cited for each lineFilled in on your sheetsFilled in on your sheets
Items at or past the bid quantity markedFilled in on your sheetsFilled in on your sheets
Corrections carried over from earlier monthsFilled in on your sheetsFilled in on your sheets
Items held for a person, with the reasonFilled in on your sheetsFilled in on your sheets
Blank on purpose. No number goes in a cell until your own past sheets have run.Scoring and the verdict belong to your reviewer.

// After a yes

About 30 days on the next month's sheets

With your reviewer's yes, the next month's sheets get drafted the same way for about 30 days.

Each sheet waits for your project manager, who approves it before it goes to an owner, an engineer or a pay estimate.

Any conversation about quantities stays with your team. Whatever comes next is a separate decision with its own fixed price, and monthly support once it runs.

// Possible next jobs

After quantity sheets, if you want more

Ideas, not a plan
Each priced on its own
  1. 01

    Haul ticket reconciliation

    Trucking and quarry invoices matched to their tickets, on the same load records these sheets add up.

    Next
  2. 02

    Change order backup

    Daily reports and quantity records gathered beside a proposed change so your project manager can price it.

    Then
  3. 03

    Closeout quantity packets

    Final quantities and their supporting sheets assembled for the owner's final estimate, for your team to check.

    After that

// One hard limit

No quantity gets agreed by the AI.

The proof of concept reads copies and drafts a sheet. It never touches your job cost, ticketing or accounting system or a live invoice or pay estimate, never agrees a quantity with an owner, engineer or inspector, and never sends anything to one. A person checks every quantity sheet. Certified payroll stays out. The public rules on this page are here so you recognize them; your own contract controls, and nothing here is legal advice.

Priced per job. You get a range before the proof of concept and a fixed price before you sign.

Rob gives the range on the call, once he knows how many unit-price jobs bill each month and how many bid items a typical schedule carries.

// Questions

Quantity sheet questions

Does the AI decide what quantity we bill?
No. It adds up what your records show and cites them. Your project manager decides what goes on the sheet, and agreeing a quantity with the owner or engineer stays with your team.
How does it treat an item paid at plan quantity?
It reads the basis of payment from the pages you send. A plan quantity item is carried at the plan figure or your agreed formula, and field tickets don't move it. If a change order moved the quantity, the draft cites the change order.
Our surveyor sends volumes in their own format. Is that a problem?
No. Send the report as you received it. The draft carries the surveyor's number and date to the bid item and marks any item where the survey period doesn't line up with the billing period.
What if the project manager's estimate differs from the backup?
The draft shows both and marks the gap. Earthwork in progress is often an estimate, so a difference isn't automatically wrong. Your reviewer decides whether the draft handled it the way your team would.
Does this work on private site packages as well as public jobs?
Yes, if the contract pays by the unit. The measurement language comes from your own subcontract or owner agreement, so send those pages. The state and federal rules on this page only show the common patterns.
Rob Eason

Rob Eason, founder

// Book a proof of concept call

Bring last season's quantity sheets.

A 30-minute call with Rob about your open unit-price jobs, your role and how many bid items a typical sheet carries. Job files stay with you until the NDA is signed.

  • Co-owned a 60-employee financial services firm and sold his share to his partner.
  • Ran GOSO Technologies, a Boston solar company rated 5/5 across 24 Google reviews.
  • 5/5 across 83 reviews in HighLevel's Certified Admin Directory.
  • 4.3/5 from 6 Google reviews of Massmarket AI.
  • Every directory and Google review, critical ones included, is shown word for word at massmarket.ai/reviews.
  • Takes every proof-of-concept call himself.