Fire protection supplies schedule of rates template

Fire protection is bought mostly by the each: sprinkler heads by type, response and temperature rating, fittings, valves, hose reels, extinguishers and fire collars, with pipe by the length. Items that look alike on an invoice line can be different prices, so a schedule of rates lists each one, with the supplier's code, alongside its 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-fire-protection.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	Sprinkler head, pendent, quick response, 68°C, K80	EA	blank	blank
3	Sprinkler head, upright, quick response, 68°C, K80	EA	blank	blank
4	Sprinkler head, sidewall, quick response, 68°C	EA	blank	blank
5	Sprinkler head, concealed pendent, with cover plate	EA	blank	blank
6	Recessed sprinkler escutcheon	EA	blank	blank
7	Flexible sprinkler drop 1.2 m, with ceiling bracket	EA	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 two units

Each (EA): Sprinkler head, pendent, quick response, 68°C, K80
Sprinkler head, upright, quick response, 68°C, K80
Sprinkler head, sidewall, quick response, 68°C
Sprinkler head, concealed pendent, with cover plate
Recessed sprinkler escutcheon
Flexible sprinkler drop 1.2 m, with ceiling bracket
Roll grooved coupling 50 mm
Galvanised threaded elbow 25 mm
Clevis pipe hanger 50 mm
Fire hose reel 36 m x 19 mm
Hydrant landing valve 65 mm, Storz outlet
Fire extinguisher, ABE dry chemical, 4.5 kg
Fire extinguisher, CO2, 3.5 kg
Fire blanket 1.2 x 1.8 m
Fire collar 100 mm, cast-in
Fire collar 100 mm, retrofit
Fire-rated sealant, 300 mL cartridge
Photoelectric smoke detector, addressable
Per length: Medium galvanised steel pipe 25 mm, 6.5 m length
Medium galvanised steel pipe 50 mm, 6.5 m length

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

Delivery
Small-order fee
Card surcharge

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

Sprinkler heads above the agreed priceChecked
One head billed at another head's priceChecked
Pipe billed per metre when you agreed per lengthChecked
Fittings or hangers by the box against a price eachAsks you first
A price rise billed before it startsChecked
Freight and small-order feesChecked
More heads or fittings billed than you orderedChecked, for you only
An item that isn't the one specifiedNot checked

What CostCode does about each, with a worked example: Invoice checking for fire protection contractors

Filling it in and loading it

One row per head. Pendent, upright, concealed and sidewall heads are separate prices, and so is each response, temperature rating and K-factor. Ask the supplier to put their code in each row, so an invoice line is matched to its head by the code, whatever the wording.

Pipe comes in lengths or cut to the metre. Put in the unit you're billed in: a line billed per metre against a price per length is held as billed in a different unit, not converted.

The schedule holds prices. Whether a head, collar, valve or extinguisher billed is the one the design specifies, or suits where it's installed, is for the designer and the certifier: CostCode checks the price and the unit, not compliance.

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