Client timesheet template for sign-off

Send a client the hours you worked. They type the hours they approve on each line, add a comment, and sign. The difference and an approval status work themselves out.

  • No email needed
  • Last reviewed 15 November 2026

For Google Sheets, download the .xlsx and open it with File > Import.

More about each format: Excel, PDF, Word

What it's for

  • Agencies, consultants and contractors who need a client to approve hours before invoicing.
  • Keeping a record of what the client agreed to, and what they changed.
  • Clients who want to check hours line by line.

What's inside

How to use
Short instructions and the colour key.
Timesheet
Supplier, client, project or purchase order and period; 30 rows with hours submitted, hours approved, the difference and a client comment; totals, lines awaiting review, lines changed by the client and a status; and an approval block with name, position, date, signature and comments.

Preview

Worked example: the client has reviewed two of three lines
Date Person Description Submitted Approved Difference
1 Mar 2027 Sam Wireframes 6.00 6.00 0.00
2 Mar 2027 Priya Content outline 5.00 4.50 -0.50
2 Mar 2027 Sam Wireframes 2.00 (not reviewed)

Submitted: 13.00 hours. Approved so far: 10.50. One line is awaiting review, so the status reads "Awaiting review". When the client types 2.00 on the last line the status becomes "Approved with changes: 1 line", because Priya's line was cut by 0.50.

How to use it

  1. Type your company, the client, the project or purchase order number and the period.
  2. Add a row for each piece of work with the hours you submit, as decimals.
  3. Send the file to the client. They type the approved hours on each line and a comment where they changed it.
  4. Check the status: Awaiting review, All hours approved, or Approved with changes and how many lines.
  5. The client fills in the approval block with their name, position, date and signature, or you print it for them to sign.

The formulas, explained

Difference
=IF(OR(D10="",E10=""),"",E10-D10)

Approved hours minus submitted hours for the line. Blank until the client types the approved hours.

Lines awaiting review
=SUMPRODUCT((D10:D39<>"")*(E10:E39=""))

Counts lines that have submitted hours but no approved hours yet.

Lines changed by the client
=SUMPRODUCT((E10:E39<>"")*(D10:D39<>E10:E39))

Counts lines where the approved hours are typed and differ from the submitted hours, so two lines that swap 5 and 6 still count as changed. Approved hours on a line with no submitted hours count too.

Status
=IF(D40+E40=0,"",IF(D41>0,"Awaiting review",IF(D42>0,"Approved with changes: "&D42&IF(D42=1," line"," lines"),"All hours approved")))

Awaiting review until every line is reviewed, then approved in full, or approved with changes and the number of lines changed.

Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.

Questions

Is a typed name a signature?

Whether a typed name or a drawn one counts as a signature depends on your contract and your country. For anything that matters, print it and sign it, or use the signing method your contract names.

What if the client changes the hours?

They type their figure in Hours approved and a reason in the comment. The difference and the status update, and you have a record of what was agreed.

Does it include rates or money?

No. It is hours only, so the client signs off the time, and you invoice from the approved hours.

Can a client approve in Jasper HQ?

No. Jasper HQ timesheets are approved by a manager inside your own organisation. This file is for clients, who are outside it.

Does it work in Google Sheets?

Yes. Upload it with File > Import in Google Sheets. It only uses functions both programs have (IF, OR, SUM and SUMPRODUCT). It also opens in LibreOffice.

About this template

Last reviewed 15 November 2026.

Changes: 15 November 2026: first published.

Free to use and change in your own business. Please don't resell the files or publish them as your own. More free templates.

Track this in Jasper

Log hours by client and project, approve timesheets and follow retainer hours, next to your team chat.

Want this by email?

Entirely optional. Everything on this page works without an email address.

Sent by Shakewell Agency Pty Ltd, Sydney, Australia. Every email has an unsubscribe link. Privacy policy.