Plumbing supplies schedule of rates template

Plumbing supplies are bought by the length, the roll and the each, and the same pipe can be priced per metre or per 6 m length. A schedule of rates settles the unit and the price for the items you buy most, so an invoice line can be checked against it.

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-plumbing.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	PVC DWV pipe 100 mm, 6 m length	length	blank	blank
3	PVC DWV pipe 50 mm, 6 m length	length	blank	blank
4	PVC DWV bend 100 mm	EA	blank	blank
5	PVC DWV junction 100 mm	EA	blank	blank
6	PVC stormwater pipe 90 mm, 6 m length	length	blank	blank
7	PVC solvent cement 500 mL	EA	blank	blank

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

What's in it

12 rows, priced in three units

Per length: PVC DWV pipe 100 mm, 6 m length
PVC DWV pipe 50 mm, 6 m length
PVC stormwater pipe 90 mm, 6 m length
Copper tube 15 mm, type B, 6 m length
Each (EA): PVC DWV bend 100 mm
PVC DWV junction 100 mm
PVC solvent cement 500 mL
PVC priming fluid 500 mL
Ball valve 15 mm
Floor waste grate 100 mm
Electric hot water unit, 250 L
Per roll: PEX pipe 16 mm, 50 m roll

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

Delivery
Small-order fee
Pallet deposits

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

Your trade discount not appliedChecked
Pipe billed per length when you agreed per metreChecked
Fittings by the box against a price eachAsks you first
A hot water unit above the agreed priceChecked
Freight and delivery feesChecked
The same invoice sent twiceChecked
A discount taken off the whole invoiceNot checked

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

Filling it in and loading it

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