Structural steel schedule of rates template

A steel stockist sells sections by the metre, the length or the tonne, and charges per cut and per hole to process them; the galvaniser charges by the tonne. The same beam can be billed in more than one of those units, so a schedule of rates settles the unit for each item 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-structural-steel.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	Universal beam 200UB25.4, grade 300	m	blank	blank
3	Universal beam 310UB40.4, grade 300	m	blank	blank
4	Universal column 150UC30.0, grade 300	m	blank	blank
5	Parallel flange channel 150PFC, grade 300	m	blank	blank
6	Equal angle 75 x 75 x 6, grade 300	m	blank	blank
7	Square hollow section 100 x 100 x 4.0, C350, 8 m length	length	blank	blank

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

What's in it

19 rows, priced in seven units

Per metre (m): Universal beam 200UB25.4, grade 300
Universal beam 310UB40.4, grade 300
Universal column 150UC30.0, grade 300
Parallel flange channel 150PFC, grade 300
Equal angle 75 x 75 x 6, grade 300
Cold-formed purlin C15024, galvanised
Per length: Square hollow section 100 x 100 x 4.0, C350, 8 m length
Rectangular hollow section 150 x 50 x 3.0, C350, 8 m length
Flat bar 75 x 10, grade 300, 6 m length
Per tonne (t): Welded beam 700WB115, grade 300
Steel plate 10 mm, grade 250
Hot dip galvanising, structural sections
Per kilogram (kg): Steel plate 20 mm, grade 350, cut to size
Per sheet: Checker plate 5 mm, 2400 x 1200
Each (EA): Saw cut, sections up to 310 mm deep
Hole drilling, up to 22 mm diameter
Hot dip galvanising, minimum charge per batch
Chemical anchoring adhesive, 300 mL cartridge
Per box: Structural bolt set M20 x 60, 8.8/S galvanised, box of 50

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

Delivery or cartage, per load or by the tonne
Fuel levy
Small-order fee
Handling fees on cut-to-length steel

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

Beams agreed per metre, invoiced per tonne, or the reverseChecked
Hollow sections billed per metre when you agreed per lengthChecked
Plate billed per kilo against a price per tonneAsks you first
Sections above your agreed priceChecked
A price rise billed before it startsChecked
Cutting, drilling and galvanising above the agreed rateChecked
Cartage and fuel levies above what you agreedChecked
Tonnes billed against what was weighed or deliveredNot checked

What CostCode does about each, with a worked example: Invoice checking for structural steel fabricators and erectors

Filling it in and loading it

Put in the unit the invoices are billed in. Stockists often quote beams per tonne and invoice them per metre or per length; if yours does, ask for the price per metre as well, so the schedule and the invoice are in the same unit.

Galvanising is charged per tonne, but by which weight: the steel as it went in, or as it came out with the zinc on? Agree which, and write it into the row.

Steel prices follow the mills', and stockists pass rises on during a job more often than most trades do. Agree how much notice a rise needs, and when one comes, load the new rates as a new schedule from the date they start: it ends the old one the day before, and invoices dated earlier are still checked at the old rates.

Fabricated steelwork, cut, drilled, welded and painted to the shop drawings, is usually priced per job 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