← Back to resources

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.

Estimators, commercial managers and workspace owners8 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.

1

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.
2

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.
3

Import carefully

A CSV import is useful for a larger catalogue, but it can also multiply a mistake quickly. Test a small file before loading the full rate card.

1

Use the sample format

Start from the VariationDesk sample CSV so headers and values are in the expected structure.

2

Check a handful of rows

Review item code, description, unit, rate and any tax fields before the full import.

3

Remove duplicates

Make sure the same item has not been imported under slightly different spelling or codes.

4

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.

  • Assign the correct project and available rate card.
  • 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.
5

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

Descriptions and units are clear
Customer rates and VAT treatment checked
Small import tested before bulk upload
Field users can enter quantities without internal pricing access
Custom lines have an office review route

Continue reading

Related VariationDesk guides

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