CivilManual
Menu

Daywork Sheet and Time and Materials Sheet Template

Record instructed work that is paid on time and materials, and the calculator prices labor, plant (equipment) and materials with the percentage additions from your contract. The same sheet comes as a blank Excel template with signature fields.

Calculator

Inputs
Labor

No rows yet.

Plant and equipment

No rows yet.

Materials

No rows yet.

Percentage additions

example, change per contract

example, change per contract

example, change per contract

Enter the rate if tax is shown on this document; 0 leaves it out.

The address bar keeps your numbers (no descriptions), so you can bookmark or share the link. Descriptions are not kept in the link; the Excel and PDF files include them.

Result

Add the first row and the result appears here.

Download this calculation

This tool is an aid. It does not replace the contract, the regulations or the supervising engineer.

Blank daywork sheet (T&M ticket)

Three tables for labor, plant and materials, totals by formula rounded to cents, a tax line you fill in yourself, and signature fields for the contractor and the client side.

Download the daywork sheet (.xlsx)

File: daywork-sheet-template.xlsx. Excel workbook (.xlsx) with formulas and no macros; it opens in Excel, LibreOffice and Google Sheets.

The tools and templates are aids for planning and record keeping. They do not replace your contract, the applicable regulations or the supervising engineer.

Worked example: an extra drainage trench

Two laborers and a foreman, an excavator for five hours and four pipes, with example additions of 15 % on labor and 10 % on plant and materials. Replace the additions with your contract figures.

  1. Labor: 2 workers × 8 h × 25.00 = 400.00, plus 1 foreman × 6 h × 28.00 = 168.00, subtotal 568.00; addition 15 % = 85.20.
  2. Plant: 1 excavator × 5 h × 65.00 = 325.00; addition 10 % = 32.50.
  3. Materials: 4 pipes × 110.00 = 440.00; addition 10 % = 44.00.
  4. Subtotal of all groups: 568.00 + 325.00 + 440.00 = 1,333.00; additions: 85.20 + 32.50 + 44.00 = 161.70.

Total before tax: 1,333.00 + 161.70 = 1,494.70. Tax is 0 until you enter the VAT or sales tax rate that applies to your work.

How the daywork sheet is calculated

Each group is priced line by line, then its own percentage addition is applied; tax comes last.

Line amount
a = number × hours × rate (labor, plant) or quantity × unit price (materials)

Each line is rounded to cents, so the printed sheet always adds up.

Group total
G = Σ a + addition, addition = Σ a × addition % / 100

Labor, plant and materials each have their own percentage, rounded to cents per group.

Total
T = Σ G + tax, tax = Σ G × tax % / 100

The tax rate is your entry; the English pages have no default rate.

Structure of a daywork valuation

The worked example by group.

GroupSubtotalAddition (example)With addition
Labor568.0015 % = 85.20653.20
Plant325.0010 % = 32.50357.50
Materials440.0010 % = 44.00484.00
Total before tax1,333.00161.701,494.70
  • The percentages are example inputs, not market rates. Use the additions in your contract, daywork schedule or tender.

Guide

Daywork and T&M: what the contract decides

Daywork in the UK and time and materials in the US describe the same idea: work that cannot be measured or priced in advance is paid on the labor, plant and materials actually used, plus agreed percentage additions. Whether a piece of work may be valued this way, and at which rates, is set by your contract and the instruction for that work, not by the sheet.

On UK building contracts, daywork is commonly valued under the RICS Definition of Prime Cost of Daywork carried out under a Building Contract, now in its third edition (2007). The definition sets out what counts as the prime cost of labor, materials and plant; the contract or the contractor's tender then adds percentages for overheads and profit. According to a summary published by Building magazine, the third edition lets labor be priced either as prime cost plus a percentage addition or at hourly rates that already include overheads and profit. We describe the structure only and do not reproduce the definition.

In the US, a T&M ticket records the same three groups. Markups, who signs the ticket and how quickly it must be submitted come from the contract or its change order procedure; we do not cite rules or typical percentages. Our sheet is a daily ticket, not a time and material contract template: the contract itself has to come from your own agreement.

Australian contracts also use the term daywork sheet. Whatever the market, good practice is a written instruction before the work starts and a signed sheet before the next shift.

How to record daywork so it gets paid

Start with the instruction. Write its number and a short description of the work at the top of the sheet, so every sheet points to the instruction that authorized it.

Fill in the sheet on the day the work is done. List each trade with the number of workers, the hours worked and the hourly rate; each item of plant with its number, hours and rate; and each material with quantity, unit and unit price. Keep the delivery tickets for the materials.

Enter the percentage additions from your contract for each group. The calculator starts with example figures of 15 % on labor, 10 % on plant and 10 % on materials and marks them as contract parameters: change them before you rely on the total.

Enter the VAT or sales tax rate if the sheet should show tax. The English pages have no default rate, because tax differs between the UK, the US, Australia, Canada and Ireland and between types of work.

Get the sheet signed by the client representative who instructed the work, ideally the same day. A signed sheet records the resources used; on its own it is not agreement that the work is a variation, so keep the instruction with it.

Additions, rounding and common mistakes

Each labor or plant line is number × hours × rate, and each material line is quantity × unit price. Lines are rounded to cents and added up per group, and the group addition is applied to that subtotal. In the worked example, 568.00 of labor at 15 %, 325.00 of plant at 10 % and 440.00 of materials at 10 % give 1,333.00 plus 161.70 of additions, 1,494.70 before tax.

  • Adding the percentage twice: if your hourly rates are all-in rates that already include overheads and profit, set the labor addition to 0.
  • One percentage for everything: your contract may set different additions for labor, plant and materials, so the calculator keeps three fields.
  • Tax before the additions: tax applies to the total of all groups including additions.
  • Large additions: the calculator accepts additions above 100 % and does not judge whether a percentage is reasonable; that is for the contract.
  • Mixing currencies: the symbol you pick is a label, and amounts are never converted.

Questions about daywork sheets

What is a daywork sheet?

A daywork sheet records work that is paid on the resources actually used instead of a measured price: the workers and their hours, the plant and its hours, and the materials. It is filled in on the day, priced with the rates and percentage additions in the contract, and signed by the client representative who instructed the work.

Is daywork the same as time and materials?

They follow the same logic. Daywork is the usual UK and Australian term, and in the UK it is commonly valued under the RICS definition of prime cost. Time and materials, or T&M, is the US term for the ticket and for contracts paid this way. Both price labor, plant and materials with agreed additions, so one sheet works for either.

Are the default percentage additions a standard rate?

No. They are example inputs so the calculator shows a result, and the page marks them as contract parameters. Replace them with the additions in your contract, daywork schedule or tender. We do not publish typical percentages, because we have no source for one figure that would fit every contract, trade and market.

When should a daywork sheet be signed?

As soon as possible, ideally on the day and before the next shift, while the client representative can still see the work and check the hours. Your contract may set a deadline for submitting sheets; follow it. A sheet submitted weeks later without a signature is much easier to dispute than one signed on site.

Can I add VAT or sales tax?

Yes. Enter the rate that applies to your work and the calculator adds tax to the total of all groups, rounded to cents. There is no default rate on the English pages, because the tax that applies differs between the UK, the US, Australia, Canada and Ireland, and sometimes between types of work in the same country.

Other tools