Electrical supplies schedule of rates template

Electrical wholesalers usually price from a list with your account's discount taken off. A schedule of rates records the net price for the items you buy most, so each invoice can be checked line by line rather than trusted.

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-electrical.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	TPS cable 2.5 mm2 twin and earth, 100 m roll	roll	blank	blank
3	TPS cable 1.5 mm2 twin and earth, 100 m roll	roll	blank	blank
4	Rigid conduit 20 mm, 4 m length	length	blank	blank
5	Corrugated conduit 20 mm, 25 m roll	roll	blank	blank
6	Double GPO, 10 A	EA	blank	blank
7	Single GPO, 10 A	EA	blank	blank

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

What's in it

14 rows, priced in four units

Per roll: TPS cable 2.5 mm2 twin and earth, 100 m roll
TPS cable 1.5 mm2 twin and earth, 100 m roll
Corrugated conduit 20 mm, 25 m roll
Per length: Rigid conduit 20 mm, 4 m length
Each (EA): Double GPO, 10 A
Single GPO, 10 A
Light switch, 1 gang
LED downlight
Smoke alarm, 240 V with battery backup
Circuit breaker, 1 pole, 20 A
RCBO, 1 pole, 20 A
Switchboard enclosure
Junction box
Per pack: Cable ties 300 mm, pack of 100

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 electrical 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

Cable above your contract price per metreChecked
Cable billed per roll when you agreed per metreChecked
Conduit or fittings per pack against a price eachAsks you first
A quantity break not givenChecked
A new price file billed from the wrong dateChecked
Freight, small-order fees and card surchargesChecked
A price up on what you've paid beforeChecked, for you only
Copper or metal price adjustmentsNot checked

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

Filling it in and loading it

Put the net price you pay per unit, after any trade discount.

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