Roofing supplies schedule of rates template

Metal roof sheet is roll-formed to the lengths you order and priced per lineal metre, by profile, thickness and finish. Flashings are priced per metre by girth, capping and downpipe by the length, fixings by the box. A schedule of rates records each of those, with its unit, before the first order goes in.

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-roofing.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.
RowItem descriptionUnitRate ex GSTGST free (Y/N)
2Corrugated roof sheet 0.42 BMT, prepaintedmblankblank
3Corrugated roof sheet 0.42 BMT, zinc-aluminiummblankblank
4Trapezoidal roof sheet 0.48 BMT, prepaintedmblankblank
5Polycarbonate corrugated sheet, clearmblankblank
6Ridge capping, prepainted, 6 m lengthlengthblankblank
7Flashing 0.55 BMT, prepainted, girth up to 300 mmmblankblank

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

What's in it

16 rows, priced in five units

Per metre (m)
  • Corrugated roof sheet 0.42 BMT, prepainted
  • Corrugated roof sheet 0.42 BMT, zinc-aluminium
  • Trapezoidal roof sheet 0.48 BMT, prepainted
  • Polycarbonate corrugated sheet, clear
  • Flashing 0.55 BMT, prepainted, girth up to 300 mm
  • Flashing 0.55 BMT, prepainted, girth 300 to 600 mm
  • Quad gutter 115 mm, prepainted
  • Steel roof batten, top hat 40 mm
Per length
  • Ridge capping, prepainted, 6 m length
  • Rectangular downpipe 100 x 50, prepainted, 3 m length
Per roll
  • Reflective foil sarking, 1.35 x 30 m roll
  • Roof insulation blanket 55 mm, foil faced
Per box
  • Roofing screws 12-11 x 50 mm with seal, box of 500
  • Batten screws 14-10 x 65 mm, box of 500
Each (EA)
  • Wind-driven roof ventilator 300 mm
  • Roof loading by crane truck

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

  • Delivery
  • Small-order fee or minimum order charge
  • 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

  • Roof sheet above the agreed price per lineal metreChecked
  • A price rise billed before it startsChecked
  • Plain sheet billed at the prepainted priceChecked
  • Capping or flashings billed per length or each when you agreed per metreChecked
  • Sarking billed per square metre when you agreed per rollChecked
  • Roof loading above the agreed priceChecked
  • Delivery, small-order and minimum-order feesChecked
  • Metres billed against your cutting listNot checked

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

Filling it in and loading it

Sheet and flashings are cut to order and billed by the metre, not by the sheet. Agree the girth bands for flashings (the width of flat steel before it's folded) along with their prices, and keep each band as its own row.

Each finish and thickness is its own price: prepainted costs more than plain zinc-aluminium, and a heavier base metal thickness (BMT) more than a lighter one. Keep the profile, the BMT and the finish in every row.

Coil prices move, and roll-formers pass rises on. Agree how much notice a rise needs, and load the new rates as a new schedule from the date they start: it ends the old one the day before, so invoices dated earlier are still checked at the old rates.

Roof loading, when the supplier's crane truck lifts the bundles onto the roof, is usually billed per delivery like an item, so it's a row here rather than a charge.

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 stepWhat each column is for

Got a supplier invoice handy? Check it now.

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

Or start free: 20 invoices a month, no card