Glazing supplies schedule of rates template

Glass is priced per square metre by type and thickness, with edge work, holes and cut-outs on top, and aluminium, sealants and tapes come by the length, the cartridge and the roll. A schedule of rates records each of those with the unit it's billed in, so a glass merchant's invoice can be checked line by line.

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-glazing.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	Clear float glass 4 mm, cut to size	m2	blank	blank
3	Clear float glass 6 mm, cut to size	m2	blank	blank
4	Clear toughened glass 6 mm	m2	blank	blank
5	Clear toughened glass 10 mm	m2	blank	blank
6	Grade A laminated glass 6.38 mm, clear	m2	blank	blank
7	Grade A laminated glass 10.38 mm, clear	m2	blank	blank

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

What's in it

20 rows, priced in seven units

Per square metre (m2): Clear float glass 4 mm, cut to size
Clear float glass 6 mm, cut to size
Clear toughened glass 6 mm
Clear toughened glass 10 mm
Grade A laminated glass 6.38 mm, clear
Grade A laminated glass 10.38 mm, clear
Low-E laminated glass 6.38 mm
Double glazed unit 4-12-4 mm, clear
Silver mirror 6 mm, cut to size
Per metre (m): Edge work, flat polish
EPDM glazing wedge gasket
Each (EA): Hole drilled in glass, up to 25 mm diameter
Neutral cure silicone, clear, 300 mL cartridge
Structural glazing silicone, 600 mL sausage
Balustrade spigot, 316 stainless steel
Per length: Aluminium window frame section, powder coated, 6.5 m length
Aluminium glazing bead, powder coated, 6.5 m length
Per roll: Double-sided glazing tape 12 x 3 mm
Per pack: Glazing setting blocks, pack of 100
Per day: Glass vacuum lifter hire

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

Delivery, often priced per drop
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

Glass above the agreed price per square metreChecked
Glass billed per pane when you agreed per square metreChecked
Edge work, holes and cut-outs above the agreed rateChecked
Aluminium billed per metre when you agreed per lengthChecked
Setting blocks or fixings by the pack against a price eachAsks you first
Delivery and minimum-order chargesChecked
The same invoice sent twiceChecked
Square metres billed against the sizes you orderedNot checked

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

Filling it in and loading it

Each type and thickness is its own price: float, toughened, laminated, low-E and double glazed are separate rows, and so is each thickness. Keep both in every row, with the supplier's code where they have one.

Ask for glass invoiced in square metres, the unit the schedule is in. A line billed per each against a price per square metre is held as billed in a different unit, and CostCode doesn't work out a pane's area.

Many merchants bill a small pane at a minimum area rather than its real size. Agree the minimum along with the rates and keep it with the schedule: CostCode checks the rate per square metre, not the area a pane was billed at.

Edge work, holes and cut-outs are usually billed as lines of their own, by the lineal metre or each. Put the ones you're billed for on the schedule: a line with nothing to check against shows as Unverified, with the reason.

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