Free templates
Free schedule of rates templates, by trade
A schedule of rates is the list of prices you and a supplier have agreed: each item, the unit it's billed in and the rate, ex GST. Pick the closest trade, fill it in with your supplier, and check their invoices against it.
Start here
Every other trade
Other free templates
How to use a template
Fill it in
List the items you buy from the supplier, in their words, with the unit each is billed in, and delete the rows you don't buy. Keep the first row as it is: it tells CostCode's importer which column is which.Agree it with the supplier
Send it to them to put in or confirm the rates, their product codes and the dates. A schedule both sides have agreed is one you can hold an invoice to.Load it into CostCode
On Rate agreements, choose the file, the supplier and the dates, and look over every row before you confirm. A row without a rate is left out, never loaded as a guess. Load only rates the supplier has agreed: a query quotes them, and nothing goes to a supplier unless a person sends it.
Questions
Are the templates free?
Yes. Every template downloads as Excel or CSV with no account and no email address.
Why are the rates blank?
Because the rate is for you and your supplier to agree. The files hold item names and units only, so nothing in them can be read as a market price.
Why is there no date column?
The dates apply to the whole schedule. You enter the date it applies from, and the date it ends if it has one, when you load the file into CostCode, and each invoice is checked against the schedule in force on its date. Settle the dates with the supplier and keep them with the file: the covering email is enough. Agree too whether prices can change during the term (rise and fall) and how much notice the supplier gives, and get any new rates in writing before they reach an invoice.
Where do delivery fees and fuel levies go?
Not in the file. Delivery and freight, fuel and environmental levies, waiting time, minimum-load and small-order fees and pallet deposits are checked against the charge agreements on the supplier's page in CostCode, not against the schedule, so a charge loaded as a row would check nothing. Agree them at the same time and add each one there when you load the schedule: a flat amount, a percentage of the goods (a fuel levy, say) or a price per unit, with the dates it applies. A charge with nothing agreed stays unverified, never passed.
What if we haven't agreed rates yet?
Build a first draft from the invoices you've already paid, then send it to the supplier to confirm. Until they do, it's your record of what you've paid, not their agreement, and CostCode checks against it without ever quoting it to the supplier.
Can I use a template without CostCode?
Yes. It's an ordinary spreadsheet: agree it with your supplier and check their invoices against it by hand. Its columns are named so CostCode's importer maps them on its own if you load it later.
Got a supplier invoice handy? Check it now.
About ten seconds. No account. We don't keep the file.
Or start free: 20 invoices a month, no card