Constructelligence
Software by trade · civil and utility contractor

Civil and utility contractor software: heavy civil estimating, pay items, quantities and job cost

Heavy civil and utility work — water and sewer mains, storm drainage, conduit, roadwork, site utilities — is bid by pay item and paid on measured quantities. The contractor who knows, every day, how many feet went in the ground at what cost per foot can bill every unit it installed and see a bad production rate while there is still pipe left to lay. The one who finds out from the monthly pay estimate has already spent the margin. The software question is whether quantities, crews and equipment meet at the pay item.

Updated · 10 minute read

Key takeaways
  • Heavy civil and utility work is bid and paid by pay item — track installed quantity against bid quantity on every item, weekly.
  • Cost per unit decides the margin: crew-day cost ÷ units installed per day.
  • A quantity overrun changes revenue as well as cost; a differing site condition needs written notice before the work.
  • Certified payroll, DBE participation and the DOT's change process are part of the job, not paperwork after it.

Where civil and utility contractor jobs make and lose money

Mostly earthwork and site grading? The excavation and sitework software page covers production by cubic yard and equipment costing in more depth.

Key terms: Cost code · Productivity factor · Change order (CO) · Estimate at completion (EAC)

A worked example

2,400 linear feet of 8-inch water main bid at $142 per foot. The crew and equipment cost $4,150 a day, the bid assumed 120 feet a day, and pipe and fittings run $58 a foot. Rock shows up and the crew is laying 85 feet a day:

Crew cost per foot, bid = $4,150 ÷ 120$34.58
Crew cost per foot, actual = $4,150 ÷ 85$48.82
Days to finish, bid → actual20 → 28.2
Extra crew-days × $4,150$34,180
Margin per foot, bid → actual34.8% → 24.8%

If the contract has a rock excavation pay item, the measured rock is revenue — but only if someone records it daily. If it does not, it is a differing site condition, and the notice clock started the day the bucket hit it.

CalculatorCost per foot when production slips

The civil and utility contractor software stack

Most contractors in this trade run four or five systems. The names below are common examples, not a ranking.

Estimating
HCSS HeavyBidB2W
Trimble
Field time, quantities & equipment
HCSS HeavyJobRakentelematics from equipment makers
Survey, grade & quantities
Trimble Business CenterAGTEK
Scheduling
Primavera P6Microsoft Project
Accounting / ERP
Viewpoint VistaFoundationSage 300 CRESage Intacct Construction

From bid item to pay estimate

On unit-price work the same pay item runs through every system, and the money is lost wherever it changes name:

  1. Bid — each pay item estimated with its crew, equipment, production rate and material, and a unit price.
  2. Cost codes — one code per pay item (or a short list under it), so cost and quantity land on the same line.
  3. Field — the foreman records hours, equipment and installed quantity per pay item each day.
  4. Pay estimate — measured quantities agreed with the inspector, item by item, with certified payroll attached.
  5. Forecast — cost per unit to date × quantity remaining, per item, against the bid.

The common gap is between steps 3 and 4: quantity installed but not yet agreed with the inspector, which is work done and not yet billed. Track it as its own number — it is the unbilled revenue on a civil job.

A starter cost code list for civil and utility contractors

On unit-price work the cleanest structure is one cost code per pay item, so cost and quantity meet on the same line — with cost types for labor, equipment, material and subcontract under each.

CodeCoversUnitWhat to watch
0201Clearing & grubbingACCost per acre against the bid
0203Unclassified excavationCYCubic yards per crew-day
0204Rock excavation (if a pay item)CYMeasured daily — it is revenue
0610Water main, 8 in.LFFeet per crew-day, cost per foot
0620Sanitary sewer, 10 in.LFFeet per day, depth and dewatering
0630Storm drain & structuresLF / EAStructures set per day
0401Asphalt base & surfaceTONTons per day, yield
0101Mobilization & traffic controlLS / DAYDays against the schedule

Illustrative numbering — use your accounting system’s own format. What matters is that the estimate, the field and the job cost use the same list. The cost codes guide covers structure, cost types and how many codes is too many.

Bidpay items · unit pricesFieldquantities per itemPay estimatemeasured · certified payrollForecastcost per unit × remainingOne cost code at every step — e.g. 0610 Water main, 8 in.
If the estimate, the field and the job cost use different lists, nothing downstream can be compared with what was assumed. One list, every step.

The numbers worth tracking weekly

Five numbers, each with its formula and the reading that should start a conversation. Most can be pulled from the job cost and timecards you already have.

NumberHow to calculate itWarning signHow often
Cost per unit, per pay itemcost to date on the item ÷ quantity installedAbove the bid unit cost on a large itemWeekly
Units per crew-dayquantity installed ÷ crew-days workedBelow the bid rate two weeks runningDaily
Quantity against bid quantityinstalled + remaining ÷ bid quantityHeading past the contract's overrun or underrun thresholdWeekly
Installed, not yet billedinstalled quantity − quantity on pay estimates, × unit priceGrowing month to monthEach pay estimate
Equipment utilizationhours charged to jobs ÷ hours availableOwned machines idle while rentals runWeekly

What to run as a civil and utility contractor business grows

The right stack depends on size more than on brand. Three stages, what each usually runs, and the sign that it is time to move up:

  1. 1
    Small utility contractor — a few crews

    Spreadsheets or a simple estimating tool, QuickBooks or a construction accounting package, quantities on paper tickets

    Time to move up when public work arrives with certified payroll and pay-item billing
  2. 2
    Growing — DOT and municipal work

    Heavy civil estimating (HCSS HeavyBid or B2W), field time and quantities by pay item (HCSS HeavyJob), a construction ERP with certified payroll (Foundation, Sage 300 CRE)

    Time to move up when owners require CPM schedules and the pay estimate takes days to assemble
  3. 3
    Established heavy civil contractor

    Estimating and field platforms joined to the ERP (Viewpoint Vista), survey and quantity tools (Trimble Business Center), Primavera P6, with cost per unit forecast weekly per item

How to choose civil and utility contractor software

Five questions to ask any vendor before a trial — each is about whether the software fits how this trade actually makes money.

  1. Can estimating work by pay item, with crews, equipment and production rates under each one?
  2. Can the field record installed quantity per pay item daily, not just hours?
  3. Does it produce the owner's pay estimate from measured quantities, and flag overruns against bid quantity?
  4. Does payroll handle certified payroll, prevailing wage classifications and DBE tracking?
  5. Can owned equipment be charged to pay items at internal rates, including idle time?

Then trial it on a finished job where you already know the answer. The construction tech stack guide covers how the pieces connect.

Where Constructelligence fits

Constructelligence sits on top of the accounting system you already run — Sage 300 CRE and QuickBooks Desktop are live today, with more ERPs and project platforms in build — and forecasts every job weekly by cost code, so a pay item running over its bid cost per unit shows up in the week it starts. It reads read-only, runs in Constructelligence Cloud (or on your own server on the Private tier) and replaces none of the tools above. See it in the demo.

Software for other trades

Checklist
Unit price quantity tracker in Excel, filled in with example rows — columns: Pay item, Description, Unit, Bid quantity, Unit price, Installed to date, On pay estimates to date, Not yet billed…
The unit price quantity tracker as it opens in Excel: example rows in italics, calculated columns shaded.
Free template · Unit price quantity tracker (Excel, PDF & CSV)An Excel workbook with drop-downs, validation and formulas built in (it opens in Google Sheets too), or a printable PDF: a blank form plus a filled-in example.
Download Excel (.xlsx)Printable PDF
What this template captures

Each pay item's bid quantity and unit price, installed and billed quantities with the unbilled balance and percent of bid quantity calculated, bid against actual units per day, and earned revenue.

12 columns: 9 you fill in and 3 calculated by formula and filled down 200 rows, so nothing is worked out by hand. In the Excel version, 7 columns reject entries of the wrong type (a date column only takes dates, an amount column only numbers), the header row stays frozen with filters on it, and the workbook opens on an Instructions sheet that lists every column below.

Every column, and how it is captured
ColumnTypeWhat goes in it
Pay itemNumberEnter a number.
DescriptionTextWhat the line is, in words the other party will recognise.
UnitTextUnit of measure (EA, LF, SF, CY, HR, LS).
Bid quantityNumberEnter a number.
Unit priceAmount ($)Enter the amount in dollars.
Installed to dateAmount ($)Enter the amount in dollars.
On pay estimates to dateAmount ($)Enter the amount in dollars.
Not yet billedCalculatedCalculated: [Installed to date] − [On pay estimates to date]
% of bid quantityCalculatedCalculated: [Installed to date] ÷ [Bid quantity] × 100
Bid units per dayNumberEnter a number.
Actual units per dayNumberEnter a number.
Earned to dateCalculatedCalculated: [Installed to date] × [Unit price]

See it on real-looking numbers

Constructelligence is a construction intelligence platform: it reads your ERP, project and field systems read-only and does this arithmetic every week, for every job. The demo runs it on a sample eight-job portfolio.

Try the demoJoin the private beta

Frequently asked questions

What software do heavy civil contractors use?

Most combine heavy civil estimating (HCSS HeavyBid or B2W are common examples) with field software that records time, equipment and installed quantities by pay item (such as HCSS HeavyJob), survey and quantity tools such as Trimble Business Center or AGTEK, a scheduler for owner-required CPM schedules, and a construction ERP — Viewpoint Vista, Foundation or Sage 300 CRE — for payroll, certified payroll and job cost.

What is the best software for utility contractors?

The one that records installed feet of pipe or conduit per pay item from the field every day and carries it to the pay estimate and job cost without retyping. Utility contractors running many small jobs often value fast field entry over a large ERP; contractors on DOT and municipal work need certified payroll and pay-item billing built in.

How do unit-price contracts handle quantity overruns?

The owner pays the bid unit price for the measured quantity installed. Many public contracts allow either party to ask for a new unit price when an item's quantity moves beyond a set percentage of the bid quantity — often 25% — so track installed against bid quantity on every item and raise it before the item is finished.

What is a pay item on a civil contract?

One line of the bid schedule — a quantity, a unit and a unit price, such as 2,400 LF of 8-inch ductile iron pipe at $142 per foot. On unit-price work the owner pays for the measured quantity actually installed, so tracking installed quantity per pay item is how the contractor gets paid.

How is heavy civil software different from excavation software?

They overlap — both estimate by crew, equipment and production rate. Heavy civil and utility contractors lean harder on bid-item tracking against measured quantities, DOT pay estimates, certified payroll and DBE reporting, and on linear work such as pipe, conduit and paving.

CI
Written by the Constructelligence teamConstruction finance and software. Worked examples use the sample demo portfolio; formulas are standard practice. Reviewed September 2026.

More in Software by trade

Free tools for this topic: Construction markup vs margin calculator · Fully burdened labor rate calculator for construction · Contractor overhead recovery and break-even calculator

All software by trade resources →