Civil and earthworks schedule of rates template

Civil work buys by the tonne and by the hour: quarry products from the pit, trucks and plant by the hour, and tipping by the tonne at the other end. Each comes with its own unit, and a schedule of rates is where the unit gets agreed along with the price.

Download (.xlsx)or as CSV

Free, with no account and no email. Item names and units are filled in; the rates are left blank for you and your supplier.

costcode-schedule-of-rates-civil-and-earthworks.xlsxRates left blank

The template's first 6 rows. Rate ex GST and GST free are blank for you and your supplier to fill in, and so is the product code column after them.
Row	Item description	Unit	Rate ex GST	GST free (Y/N)
2	Road base, 20 mm	t	blank	blank
3	Aggregate, 20 mm	t	blank	blank
4	Aggregate, 10 mm	t	blank	blank
5	Crusher dust	t	blank	blank
6	Recycled crushed concrete, 20 mm	t	blank	blank
7	Fill sand	t	blank	blank

Item and unit filled in. Rate, GST free and product code left blank.Rate, GST free and product code left blank.11 more rows, below

What's in it

17 rows, priced in three units

Per tonne (t): Road base, 20 mm
Aggregate, 20 mm
Aggregate, 10 mm
Crusher dust
Recycled crushed concrete, 20 mm
Fill sand
Tipping fee, clean fill
Tipping fee, mixed construction waste
Tipping fee, concrete and brick
Per hour: Tipper truck, wet hire
Truck and dog, wet hire
Excavator 5 t, wet hire
Excavator 20 t, wet hire
Skid steer loader, wet hire
Smooth drum roller, wet hire
Water cart, wet hire
Each (EA): Float, each way

Common items for the trade, not a recommendation. The rates are yours and your supplier's to agree.

Keep the unit the supplier bills in: CostCode checks the unit on each invoice line against the one agreed. A line billed in a unit that measures something else (per each where you agreed per metre, per tonne where you agreed per cubic metre) is held; one it can't compare, such as per day against per week, is left for a person to confirm, never converted.

Delete the rows you don't buy and add your own under them. Keep the first row as it is: it's how CostCode's importer knows which column is which, so there's nothing to match up by hand when you load it.

Charges civil and earthworks suppliers add on top

Cartage priced per tonne or per load, rather than by the truck hour
Waiting time
Fuel levy
Environmental levy

These aren't rows in the file. Agree them with the rates and record each as a charge agreement on the supplier in CostCode, where charge lines are checked against them. Why charges are kept apart

Where these invoices usually go wrong

Billed per cubic metre when you agreed per tonne, or the reverseChecked
Quarry products above the agreed rateChecked
Cartage and fuel levies above what you agreedChecked
Tipping fees and leviesChecked
Plant hire above the agreed rateChecked
One delivery docket on two invoicesChecked, for you only
More tonnes billed than you orderedChecked, for you only
Hours billed against your plant docketsNot checked

What CostCode does about each, with a worked example: Invoice checking for civil and earthworks contractors

Filling it in and loading it

Wet hire includes the operator and dry hire doesn't, and the two rates for the same machine are far apart. Say which in each row.

Fill in the items, send the file to the supplier to put in or confirm the rates, and load it into CostCode with the date it applies from.

How to use a template, step by step What each column is for

Got a supplier invoice handy? Check it now.

About ten seconds. No account. We don't keep the file.

Check my invoice

Or start free: 20 invoices a month, no card