Builders' supplies schedule of rates template

A builder buys hundreds of different items from the timber and hardware yard. Start the schedule with the ones on every job: framing timber, sheet goods, fixings, bins and site hire. Rows can be added any time.

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-builders.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	Framing pine 90 x 45 MGP10	m	blank	blank
3	Framing pine 90 x 35 MGP10	m	blank	blank
4	Framing pine 70 x 35 MGP10	m	blank	blank
5	LVL beam 240 x 45	m	blank	blank
6	Structural plywood 17 mm, 2400 x 1200	sheet	blank	blank
7	Plasterboard 10 mm, 2400 x 1200	sheet	blank	blank

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

What's in it

15 rows, priced in five units

Per metre (m): Framing pine 90 x 45 MGP10
Framing pine 90 x 35 MGP10
Framing pine 70 x 35 MGP10
LVL beam 240 x 45
Per sheet: Structural plywood 17 mm, 2400 x 1200
Plasterboard 10 mm, 2400 x 1200
Each (EA): Construction adhesive, 375 g
Joist hanger, 45 mm
Skip bin 4 m3, general waste
Skip bin 6 m3, general waste
Per box: Framing nails 75 x 3.05 mm, 5 kg box
Batten screws 14g x 75 mm, box of 100
Per week: Temporary fence panel
Portable toilet, serviced
Site shed 6 x 3 m

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 builders suppliers add on top

Delivery
Small-order fee
Pallet deposits
Fuel 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

Framing timber above the agreed price per metreChecked
Timber billed per length when you agreed per lineal metreChecked
Frames and trusses above the quote for the jobChecked
Hire billed above the agreed rateChecked
Skip bins and delivery chargesChecked
An invoice addressed to the wrong one of your companiesChecked, for you only
More billed than you orderedChecked, for you only
Hire kept on after it went backNot checked

What CostCode does about each, with a worked example: Invoice checking for builders

Filling it in and loading it

Frames and trusses are usually priced per job from the plans rather than per unit. Load that quote against the job it's for: CostCode's importer takes a supplier's quote and the job it applies to, and checks that job's invoices against it until the quote's date.

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