A schedule of rates holds the coded rates a council or organisation pays for each piece of work. Trades Panel keeps each one as a register. Once a register has rates, Add from SOR adds them to a quote, job or change order as priced line items.
Who can do this: owners and admins manage registers and rates. Anyone who can edit a quote or job can add rates to it.
Create a register
Use one register per council or organisation. Each register needs its own name, and two registers can use the same codes.
- Click your avatar in the top-right corner, then Settings. Under Pricing, open Schedule of Rates.
- Click New beside Registers.
- Enter a Name, such as the council and year. Council name, Reference and Edition are optional.
- Click Create register.
Click a register in the list to see its rates. The badge beside each register shows its version, which goes up by one every time you import into it.
Add a rate by hand
- Open the register and click Add rate.
- Enter the Code, Short description, Unit (sheet) and Sell rate (£). These are required. Long description (scope of works), Element, Section and Type are optional.
- Click Add rate.
Codes must be unique within a register. Type sets the unit the rate shows on a line item, such as m² or Lm. Leave it on Auto (per unit) unless the rate is priced by area, length, count or item.
Import a spreadsheet
The import accepts a .xlsx or .csv file up to 10 MB. This is separate from the price
list import for presets.
- Open the register and click Import sheet.
- Drop the file onto the upload box, or click to browse, then click Next: Choose tabs.
- Tick the tabs to import and click Next: Map columns. A CSV file has one tab.
- Check each column is matched to the right field. Code, Short description, Unit (UoM) and Sell rate must be mapped. Click Next: Review.
- Check the changes and click Import n changes.
The review shows how many codes are New, Updated, Deleted and Unchanged. Rates are matched on their code, so importing a newer edition of the same schedule updates the existing rates. Codes that are in the register but not in the file are kept.
A tab with "deleted" in its name is read as a list of codes to remove from the register. Columns with a % in the heading, such as uplifts, are imported as extra rates you can pick from when you add the code.
Add a rate to a quote, job or change order
Add from SOR sits beside Add Line Item in the line item editor:
- On a quote, in each quote item. See Create a Quote.
- On a job, while a job item is open for editing (Expand, then Edit). See Build a Job Up.
- On a change order, after you click Modify on a job item or add a new job item. See Create a Change Order.
- Click Add from SOR.
- Choose the Register. If you only have one, it is chosen for you, and otherwise the last one you used is remembered on that browser.
- Search by code or description and click Add beside the rate you want.
- Pick the Rate if the code has more than one, enter the Quantity and click Add line. Repeat for any other rates.
- Click Confirm, then save the quote, job item or change order as usual.
Each rate is added as a line item named with its code and short description, with the long description underneath. The price is the quantity times the rate, and the line has no cost, so its Margin % stays greyed out.
The rate is copied onto the line when you add it. Editing or deleting the rate in the register later does not change quotes and jobs that already use it. The code stays on the line when a quote is converted to a job, and shows on the job sheet in the mobile app.
A rate with the type Time cannot be added this way. Add that work as a labour row on the line item instead.
Add from SOR is not shown on a CrAIg proposal. Click Accept & Create Quote first, then add rates to the quote. See Draft a Quote with CrAIg.
Related articles
- Create a Quote - build the quote the rates go on
- Build a Job Up: Job Items and Line Items - add rates to a job
- Create a Change Order - add rates to agreed work
- Line Presets: Price a Repeatable Work Package - save your own packages of work
- Set Up Labour, Material and Plant Presets - your own saved rates and price list import
- Roles and What Each One Can See - who can change settings