Flooring schedule of rates template

Flooring is sold by the square metre, the lineal metre off a roll, the carton and the bucket, and the same carpet can be quoted in more than one of them. A schedule of rates settles the unit each product is billed in along with its price, so the invoice for a job 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-flooring.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	Sheet vinyl 2 mm, commercial, 2 m wide	m2	blank	blank
3	Vinyl plank 2.5 mm, glue down	m2	blank	blank
4	Hybrid flooring plank 6.5 mm, click	m2	blank	blank
5	Engineered timber flooring 14 mm, oak	m2	blank	blank
6	Carpet tiles 500 x 500, loop pile	m2	blank	blank
7	Broadloom carpet, 3.66 m wide	m	blank	blank

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

What's in it

18 rows, priced in six units

Per square metre (m2): Sheet vinyl 2 mm, commercial, 2 m wide
Vinyl plank 2.5 mm, glue down
Hybrid flooring plank 6.5 mm, click
Engineered timber flooring 14 mm, oak
Carpet tiles 500 x 500, loop pile
Porcelain floor tile 600 x 600, matt
Per metre (m): Broadloom carpet, 3.66 m wide
Per roll: Carpet underlay 10 mm, foam
Floating floor underlay 2 mm
Vinyl welding rod, 50 m roll
Each (EA): Vinyl adhesive, 15 L bucket
Timber flooring adhesive, 15 kg bucket
Per bag: Self-levelling compound, 20 kg bag
Tile adhesive, cement based, 20 kg bag
Grout, cement based, 5 kg bag
Per length: Aluminium reducer trim, 2.7 m length
Aluminium stair nosing, 3.0 m length
Scotia moulding 18 mm, 2.4 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 flooring suppliers add on top

Delivery
Small-order fee, or a surcharge on cut lengths
Pallet deposits on tiles

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

Carpet billed per square metre against a broadloom metre price, or the reverseChecked
Tiles or planks billed per carton against a price per square metreAsks you first
Vinyl, planks or tiles above the agreed price per square metreChecked
Underlay billed per square metre when you agreed per rollChecked
Trims billed per length against a price eachAsks you first
Delivery, small-order fees and pallet depositsChecked
A price up on what you've paid beforeChecked, for you only
Square metres billed against your measureNot checked

What CostCode does about each, with a worked example: Invoice checking for flooring and tiling contractors

Filling it in and loading it

Carpet and sheet vinyl come off a roll of a set width and may be priced per square metre or per lineal metre of the roll. Carpet is often sold by the broadloom metre, a lineal metre off a 3.66 m roll, which is 3.66 square metres, so the two rates are far apart: put in the unit your supplier bills in.

Tiles and planks are packed by the carton but usually priced per square metre, so check the invoice bills square metres at the square-metre rate. A carton isn't a unit CostCode can compare, so a line billed per carton stays unverified, with the reason, never passed.

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