Skip to main content

How do I set up Schedule of Rates items and rate cards?

Set up SOR groups, subgroups, types and items, then customer and supplier rate cards with prices, and see how they're used on work orders.

SOR items are the priced tasks you claim on work orders. Set them up in Settings > SOR: first groups and subgroups, then types, then the SOR items themselves. Then set their prices in Settings > Rate Card: a customer rate card for what you charge, and a supplier rate card under it for what you pay each subcontractor.

This guide is for admins.

1. Set up SOR groups and subgroups

Open Settings from the gear icon at the top right and click SOR. The page opens on SOR Group.

The SOR Group tab with groups such as Copper, Civil Work and Fibre, their sub groups as chips, and the NEW button circled.

  1. Click NEW. A panel opens on the right.

  2. Type a Name and, if you want, a Description.

  3. Set Status to Active.

  4. In Add sub groups, type each subgroup and press Enter.

  5. Click Save.

The SOR Group panel with Name, Description, Status and Add sub groups, and Cancel and Save.

Subgroups are added here, inside their group. A subgroup that SOR items already use can't be removed. To change a group, click its name or ⋮ > Edit.

2. Add SOR types

Click the SOR Type tab, then NEW. Enter a Name, an optional Description and a Status, then click Save. Types describe the kind of item, for example labour or materials.

3. Add SOR items

Click the SOR tab, then NEW. Fill in:

  • Type: one of your SOR types.

  • Name: the SOR code people will see, for example CI-01-01-01.

  • Description: what the work is.

  • Sub Group: shown as Group | Subgroup.

  • UOM: the unit of measure, such as Hour, Metre or Each.

  • Status: Active, so it can be picked on work orders.

Click Save. You see SOR created successfully. To stop an item being used without deleting it, set its Status to Inactive.

4. Create a customer rate card

A customer rate card holds the prices you charge a customer in one service area.

The Rate card list with Active and Inactive filters, a search box and the NEW button, listing customer and supplier rate cards.

  1. In Settings, click Rate Card, then NEW.

  2. Under Rate Card Level, choose Customer. It starts on Supplier, so change it first: the level can't be changed after saving.

  3. Fill in Name, Status, Customer, Service Area and Start Date. Version Number and End Date are optional.

  4. Click Save & Continue. The Item Details tab opens. No message appears, but the card is saved.

On Create Ratecard, the Rate Card Level is switched from Supplier to Customer and the Supplier, Parent Rate Card and Global Adjustment fields disappear, then back to Supplier.

5. Add SOR items and prices

  1. On the Item Details tab, click Link SOR. The Add SOR Items panel opens.

  2. Pick a Category (SOR group), then a Subcategory.

  3. Tick each SOR item you want and type its rate in the $ box.

  4. Click Add. The items appear in the list.

The Add SOR Items panel with Category, Subcategory and SOR Items columns and a search box.

To change a price later, click the rate in the list (it has a pencil), type the new rate and press Enter. You see Rate updated. The Status column shows A for active and I for inactive.

The Item Details tab listing SOR codes with their description, unit, rate with a pencil icon, and status.

Click Save Ratecard to go back to the list. Prices are saved as you go.

6. Create a supplier rate card

A supplier rate card holds what you pay one supplier (subcontractor) for the same work. It sits under a customer rate card.

Create Ratecard at Supplier level, with Customer, Supplier, Parent Rate Card, Service Area, Start Date, End Date and Global Adjustment.

  1. Click NEW and leave Rate Card Level on Supplier.

  2. Choose the Customer, then the Supplier.

  3. Choose the Parent Rate Card: the customer rate card this one belongs to. Its service area and dates are copied in.

  4. Fill in Name and Status, and check the dates.

  5. Click Save & Continue, then add SOR items and prices on Item Details as in step 5.

How rate cards are used on work orders

  • On a work order, the Customer Rate Card list shows the customer cards for the project's customer in the work order's service area.

  • The Supplier Rate Card list shows supplier cards for the work order's supplier under that customer card. If only one matches, it's picked for you.

  • When SORs are added to the work order, each item's price comes from the customer rate card. An item that isn't on the card is priced at 0. See How to add SORs (Schedules of Rates) to a work order.

  • Supplier rate cards are used for bills to the supplier. See How claims work: create, submit, approve and revert.

Common questions

Why won't my rate card save?

A required field is empty, and you see Please fill in all required fields. On a supplier card, the Supplier and Parent Rate Card are both required.

Why is an SOR item missing when I add SORs to a work order?

Check it's Active in Settings > SOR, and that it's on the customer rate card for that work order's service area.

Can I delete a rate card?

Yes, from ⋮ > Delete in the list, unless it's used elsewhere. Then you see This record cannot be deleted as it is referenced by other records. Set it to Inactive instead.

Can I import SOR items or rates from a spreadsheet?

Not at the moment. Add them on screen.

Related articles

Did this answer your question?