Free template

Work report template

A work report for one job at a client, as Excel with formulas and as a PDF to print. With hours per person, work carried out, material, travel time and expenses, and room for both signatures.

Free and without sign-up. For Excel and LibreOffice, no macros, A4 print area.

Download the template

In other languages: German Excel, PDF; French Excel, PDF

Extract from the PDF template, with sample rows. In Excel, hours and amounts calculate by themselves.

How to fill in the work report

  1. Enter client, address, order or project number and the date of the job. The report number helps later with the invoice.
  2. Write start, end and break for each person. The Excel file calculates the hours per person and the total.
  3. Describe the work carried out so that the client still recognises it weeks later.
  4. Record the material used with quantity and unit, and a price if you like. Travel time, kilometres and expenses are optional.
  5. Have the client sign the report on site and sign it yourself. A copy goes to the client.

Have work reports signed digitally

With the Work reports module in Stunden you record work reports on the phone or tablet, from a report template with items if you like. The client signs directly on the screen. You take completed reports into the invoice if you also use the Invoices module.

Work reports: what they contain and why the signature counts

What belongs in a work report?

ItemPurpose
Client, address, order or projectLink to the quote and the invoice
Date, start, end and break per personBillable hours
Work carried outWhat was done, traceable for both sides
Material with quantity and unitBilling and stock
Travel time, kilometres, expensesBilling as agreed
Signatures of client and staff, place and dateConfirmation of the work

A work report, in Switzerland often called a Regierapport, records who worked at the client, when and for how long, what was done and which material was used. It is the basis for the invoice when work is billed by time and material. There is no statutory form; what it must contain follows from your contract with the client.

OR Art. 374 (contract for work billed by effort), OR Art. 394 (mandate)

Why the client signature matters

Whoever claims a debt has to prove it. A report signed by the client on the day of the job shows that the client took note of hours and material. Objections come early, not only with the invoice. Many contracts for work, for example under the SIA standard 118, provide that time and material reports are presented for signature on an ongoing basis.

ZGB Art. 8; SIA standard 118, where agreed

Work report and the working time of staff

The report shows the hours you bill to the client. The working time you must record as an employer under the Employment Act is often longer: trips between sites, preparation time and work at the premises count too. Keep a timesheet or time tracking in addition.

ArGV 1 Art. 13 and 73

Does travel time count?

If someone has to work somewhere other than the usual workplace and the journey there is longer than the usual commute, the additional travel time counts as working time. Whether you bill travel time to the client is set by your contract or quote. The template has a separate, optional field for it.

ArGV 1 Art. 13 Abs. 2

How long to keep it?

If a report serves as the basis for an invoice, it usually counts as an accounting voucher for businesses that must keep accounts, and accounting vouchers are kept for 10 years. If it contains the working time of your staff, at least 5 years apply to that. To meet both periods, keep work reports for 10 years.

OR Art. 958f; ArGV 1 Art. 73 Abs. 2

Paper, Excel or an app?

On paper the client signs at once, but the reports have to be retyped later for the invoice. Excel calculates hours and material but needs a printout for the signature. With an app, the report is recorded on site, signed on the screen and processed further without retyping. What fits depends on the number of jobs per week.

Practice

More free calculators and templates for working time, breaks, overtime and holidays: Free calculators

Frequently asked questions

Is the work report template free?

Yes. The Excel and PDF files are free and without sign-up, in German, French and English.

What is the difference between a work report and a Regierapport?

In daily use both mean the same: a record of work billed by time and material. Regierapport is common above all in construction, when work outside a fixed price is billed.

Does the client have to sign the work report?

There is no statutory duty, but many contracts require it. A signed report makes it much easier to prove hours and material if questions come up.

How many staff fit on one report?

The template has six rows for staff and eight rows for material. If you need more, use a second report with the same order number.

Does the template calculate work past midnight?

Yes. If the end is before the start, the Excel template treats it as a time on the next day. A row can hold less than 24 hours.

Does the work report replace time tracking?

Usually not. The report shows the hours billed to one client. As an employer you must also record the total working time per day and week (ArGV 1 Art. 73).

Can I add my logo?

Yes. In the Excel file you can add your logo and address at the top and rename columns. Do not overwrite the formulas in the hours and amount columns.