Free template for ID, renovation and D&B firms

Free variation order template for renovation and D&B firms.

A variation order turns a change agreed on site into a priced, signed record before the work is done. This free Excel template covers additions and omissions, GST, the revised contract sum and the effect on the completion date, with a register that tracks every VO on the job.

Get the free template All free templates

What a variation order must contain

A VO is short, but it has to stand on its own. Anyone reading it months later, in your office or the client's, should see what changed, why, what it costs and who agreed. Include:

  • A VO number, in order for the job, and the quotation or contract it changes.
  • The date the change was asked for, who asked, and the reason: a client request, a site condition, a design change or an authority requirement.
  • What is changing, in plain words, with each item marked as an addition or an omission.
  • The quantity, unit, rate and amount for each item, and the net change.
  • GST on the change if your firm is GST-registered.
  • The original contract sum, the VOs approved before this one, and the revised contract sum.
  • Any extra time needed and the revised completion date.
  • Signatures from the client and your firm, dated, before the work starts.

If your contract sets out its own variation procedure or form, follow the contract. The template gives you a clear layout to work within it.

What is in the template

Three sheets. The Variation order sheet is the document the client signs. The VO register lists every VO on the job with its status and the claim it was billed in. The How to use sheet explains each part. Pale yellow cells are for your details; amounts, GST and the revised contract sum calculate.

VO register columnWhat it is for
VO no.The number on the signed VO
Date raisedWhen the change was written up
DescriptionOne line on what changed
Amount before GSTThe net change from the VO
StatusDraft, Sent, Approved or Rejected
Date approvedWhen the client signed
Billed in claim no.The progress claim that includes it
RemarksAnything else worth noting

At the top, the register adds up the approved VOs and the approved VOs not yet billed in any claim, which is the figure to check before every progress claim.

How to fill it in

From a site change to a signed VO

Five steps. Write it up while the details are fresh, and get it signed before the work.

1

Write it up the same day

Use one VO per change, numbered in order. Fill in the reason and who asked for the change while everyone still remembers.

2

List additions and omissions

Mark each item Add or Omit. Omitted items reduce the amount automatically, so the client sees the true net change.

3

Show the effect on the contract

Enter the original contract sum and the VOs approved so far. The revised contract sum and GST calculate.

4

Get it signed before the work

Send the VO and get the client's signature before the change is carried out. Note any extra days on the programme.

5

Record it on the register

Mark the VO approved, and when you bill it, write the claim number. Approved VOs with no claim number are money still to collect.

Common variation order mistakes

  • Agreeing the change in the WhatsApp group and writing the VO weeks later, when nobody remembers the details.
  • Starting the work before the client signs. If the client disputes the VO, the work is already done.
  • Pricing additions but forgetting omissions, or the other way round, so the net change is wrong.
  • Not showing the revised contract sum, so the client is surprised by the final claim.
  • Signed VOs that never make it into a progress claim.
  • No reason recorded, which makes it hard to show later that a change came from the client or from the site.

Get the free variation order template

An Excel file with the variation order itself, a VO register for the whole job, and instructions. Fill in the form and the download appears straight away.

Your template is ready

An Excel file you can fill in straight away. It also opens in Google Sheets and Numbers.

Download the variation order template

More free templates

    When the spreadsheet is not enough

    The hard part of a VO is not the layout. It is noticing that a change happened, pricing it, and getting it signed before the work. Lynqra builds systems that pick up a change from the site team's message, draft the VO with your rates and send it to you for approval. Nothing goes to the client until a person in your firm approves the price, and signed VOs are listed for the next progress claim.

    See quotation and variation order automation, or read our guide to the variation order approval workflow.

    FAQ

    Variation order template questions

    Is a VO the same as a change order?

    Yes. Variation order, change order and VO all mean a written, priced change to the original scope.

    Should omissions go on a VO too?

    Yes. An omission reduces the contract sum, and the client should see and sign it like any other change.

    Can I use it for design-and-build projects?

    Yes. The layout works for residential renovation and for design-and-build work. Where your contract has its own variation procedure, follow it.

    Is the template really free?

    Yes. Fill in the short form and the download appears straight away. You can use and change the file for your own firm's jobs.

    Does it work in Google Sheets?

    Yes. Upload the file to Google Drive and open it with Google Sheets, or open it in Numbers. The formulas and drop-down lists work in both.

    Start with one workflow

    Bring the quotation, VO, claim or update that takes your team the longest. There is no commitment, and a person in your firm stays on prices, payments and customer commitments.

    Book a free consult