Contracts & Change Orders Kit

When to use it

When scope changes: record quantity, rate and approval before adding a change to the original contract.

Change order: an approved scope or contract-value adjustment; an unapproved request is not a guaranteed receivable.

What you get after purchase

  • Interactive variation register: quantity, rate, status (approved/pending/rejected) and time impact for each change.
  • Revised contract value and change percentage, with a warning when the contractual re-rating threshold is passed.
  • 38 certificate and collection inputs: frozen history, period deductions and caps, approved release, eligible materials and tax, partial receipts, balances and overdue, with three charts.
  • 38 inputs separate approved/pending/rejected changes, frozen history, period deductions, authorized release and partial collections. Six metrics, three tables and three charts show variation status, payable/collected/balance and deductions; EOT is separate and the percentage is only a review flag. History is never repriced at current rates.
  • Bilingual Excel file: variation register with status lists and automatic totals, a cumulative measurement sheet (previous/this period/cumulative) that flags over-contract quantities, an interim certificate fed from the measurement, and a certificate and payment history with outstanding amounts.
  • Gift book: Contract Management & Claims Book.

A fixed-number teaching example, open to everyone before purchase, so you can see how it works.

Supporting your chances of success

This kit combines precise calculations with guidance and organisation to help you work towards your goal. We help you organise inputs, understand options and assess strengths and risks, then suggest practical steps suited to its subject — such as pricing, cash flow or marketing.

Guidance supports decisions, not guaranteed success; estimates depend on the accuracy of your inputs.

Understand the kit step by step

The kit links variations, measurement, certification and collections. Approved, pending and rejected changes remain separate; previous certification is retained as issued rather than recalculating its retention or tax at today’s rates. A certificate is an assessed financial entitlement, not collected cash or automatic time approval.

What to prepare before starting

Prepare the authoritative paid advance (percentage is reference only), contract, variations and approval references, prior/current measurement, and work, materials, retention, recovery, net and tax from the last approved certificate. Prepare receipt transactions, due dates and approved release. Materials and tax require a reviewed contractual/local basis, not a universal assumption.

From information to a decision

  1. Record four changes with quantities, rates and financial approval; only approved changes revise the contract. Separate requested impact from approved EOT.
  2. Measure prior and period work per item. Eligible site materials remain separate and must not be duplicated inside work value.
  3. Reconcile prior net = prior gross − frozen retention − frozen recovery. Never substitute paid cash for certification.
  4. Calculate only period deductions within the retention cap and advance still outstanding, then add authorized release once.
  5. Calculate period tax on the basis you reviewed; do not reprice historical tax.
  6. Record every partial receipt by certificate, reference and day; review balances, overdue and excess.

A simple example to explain the idea

Original contract2,000,000; approved changes21,600 and57,000, pending85,000 and rejected40,000. Revised value2,078,600. Prior: work600,000 − retention60,000 − recovery120,000 = net420,000, with frozen tax21,000. Current cumulative work900,000; period300,000 − retention30,000 − recovery60,000 = net210,000. Illustrative5% tax10,500 gives payable220,500. Prior receipts300,000 leave141,000; current receipts100,000 leave120,500; combined balance261,500. Review day45 versus due day30 gives15 overdue days. Retention held90,000, advance remaining20,000; approved EOT zero despite5 requested impact days.

These figures are illustrative, not approved prices or guaranteed forecasts; they may differ from the worked example below.

How to interpret and use the result

Certification is not collection; advance is not a certificate receipt. The cap limits new retention but does not automatically release old retention. Rate changes never rewrite history. Charts show variation status, payable/collected/balance and period deductions. Excel supports50 changes,40 measurement items,40 certificates and200 receipt transactions.

A common mistake to avoid

An educational model, not legal/tax advice or late-interest calculation. Re-rating percentage is a review flag, not automatic entitlement. Time impacts can overlap; financial approval does not establish EOT. This simplified model rejects work reductions below prior certification or negative period net; cancellation adjustments need professional assessment. Freeze an approved copy before changing period; the file is not an immutable audit ledger.

Reading the detailed operating plan

38 inputs separate approved/pending/rejected changes, frozen history, period deductions, authorized release and partial collections. Six metrics, three tables and three charts show variation status, payable/collected/balance and deductions; EOT is separate and the percentage is only a review flag. History is never repriced at current rates.

Gift book with the kit

Contract Management & Claims Book

After payment you choose the book edition — bilingual or English — and it is added to your library with the kit.

Have a quotation or claim?

Check it with the quote and claim checker before you sign.

Open the checker