Resources library
Commercial setup

Set up rate cards and itemised variation pricing

How to structure customer rates, units, field quantities and custom lines without exposing internal commercial information.

Guide details

For

Estimators, commercial managers and workspace owners

Reading time

8 minute read

What this guide covers

A rate card should make common work quicker to price without forcing every job into the wrong line. Keep descriptions and units clear, give field users a controlled list, and leave final commercial review with the office.

01

Decide how the catalogue will be organised

Use a structure that matches how your team searches for work. Too many nearly identical lines slow the field user down and make reporting less reliable.

  • Use recognisable item codes where your business already has them.
  • Write descriptions in terms the site and office teams both understand.
  • Choose a consistent unit such as hour, metre, item or day.
  • Keep customer-specific agreements in the correct rate card.
02

Check the customer-facing rate

The rate card should contain the selling information used to build the variation. Internal cost, margin and mark-up controls remain an office responsibility.

  • Confirm the rate and VAT treatment before release.
  • Make clear whether preliminaries, plant or attendance are separate items.
  • Avoid embedding several unrelated activities in one vague line.
  • Review expired or superseded rates before a new project begins.
03

Import the full approved catalogue

VariationDesk is designed for the office to load the real commercial catalogue rather than drip-feed a few items at a time. CSV, TSV, XLSX, ODS and other supported tabular files can be mapped during import, and there is no plan-based cap on individual rate-card items.

01

Upload the source file

Use the customer or company rate-card file your commercial team already maintains and map its item code, description, unit, rate and other useful columns.

02

Check a handful of rows

Review the detected worksheet, header row, item code, description, unit, rate and tax fields before confirming the full import.

03

Keep agreed rates separated when needed

Use a workspace-wide catalogue for standard pricing or associate separate customer/project rate cards where the agreed rates genuinely differ.

04

Control what happens in the field

Field users can select approved lines and enter quantities. They should not need to calculate margin or see internal commercial information to record the work accurately.

  • Search the approved rate card and select the line that matches the work.
  • Ask field users to enter measurable quantities and useful notes.
  • Allow custom lines only where the office has a clear review process.
  • Treat a field estimate as input to review, not an automatic final invoice value.
05

Review custom and unusual work

When the catalogue does not fit, a custom line is better than forcing the work into an incorrect item. The office should then standardise it if the same work starts appearing regularly.

  • Check the description and unit before approving the value.
  • Replace temporary wording with a customer-ready description.
  • Add a recurring item to the rate card after commercial approval.
  • Keep a history of why the unusual price was accepted.

Before you finish

Final check

5 checks
Descriptions and units are clear
Customer rates and VAT treatment checked
Full approved catalogue imported and spot-checked
Field users can enter quantities without internal pricing access
Custom lines have an office review route

Continue reading

Related VariationDesk guides

View library

Put it into practice

Bring one real rate card to the setup call

We can help you decide what belongs in the field catalogue and what should remain under office control during the pilot.

Apply for setup support