Proof of Hours Worked Template for Excel and Google Sheets

In short: An proof of hours worked (hours record) documents working time over a fixed period, often a month or pay cycle. Unlike a single-day slip, the focus is traceability, totals, and the question: How many hours actually occurred in this period, including break logic? The free Ordio proof of hours worked template in Excel and Google Sheets gives you that structure without building formulas from scratch.

Further reading: Timesheet calculator.

Many searches mix timesheets, proof of hours workeds, and broader time-tracking templates. A clear split helps you choose the right file:

If you need many days in one block with monthly totals, this template is built for that. For definitions and practice questions, see the proof of hours worked overview on our templates hub.

Why use an proof of hours worked template in Excel or Google Sheets?

Practical value: A template saves layout and formula work. You enter date, start, end, break, and day type, the sheet calculates net hours and rolls up the period on an overview tab. That reduces common errors (wrong SUM ranges, missing break fields) when you prepare proof for a manager, client, or payroll.

• Template is often enough: Few employees, predictable months, you want structure before buying tools.
• Software makes sense: Multiple sites, shift swaps, approvals, payroll interfaces, then digital time tracking like Ordio collects and evaluates hours centrally.
• Combination: Many teams start in Excel and move when manual upkeep becomes costly.

The workbook includes a short guide sheet so fields are self-explanatory. Proof stays readable for people who were not at the shift.

Enter times daily or weekly. Use the notes column for exceptions (training, travel). Use separate files per employer if someone has two jobs. Before submitting, sanity-check calendar days, breaks, and duplicate dates. For one-off hour checks, try the working time calculator; the template remains your period log.

For planning alongside documentation, see employee scheduling the proof of hours worked template stays the lightweight record for what was worked.

Excel, Word, and timesheet templates: common search questions

People often ask whether an proof of hours worked is the same as a timesheet in Excel or Word. Yes, many providers offer hour logs; quality and formulas vary. If you need day-by-day capture with breaks, the timesheet Excel template may fit better. This page focuses on monthly proofs and totals; you can use both, but submit the document your payroll process expects.

An proof of hours worked is the summary of what someone actually worked in a period. In practice it is requested in four situations:

• Payroll for hourly staff. In the UK, when pay depends on time worked, the payslip has to show the hours paid (Employment Rights Act 1996, s. 8(2)(e)). The proof of hours worked is the source for that figure.
• Agency and client work. A temp or freelancer has the client sign the hours so the agency can invoice and pay.
• Disputes about pay or rest. In Ireland, an employer who has no records of working time has to prove compliance itself (Organisation of Working Time Act 1997, s. 25).
• A second job. Young workers' limits in the UK (8 hours a day, 40 a week) count hours for every employer together (WTR reg. 5A).

Worked example: a student on the National Living Wage

Sam is 21, works in a café and is paid £12.71 an hour, the National Living Wage from 1 April 2026. In May Sam records 62 hours on the hours record. Gross pay is 62 × £12.71 = £788.02. If Sam's payslip shows fewer hours or a lower rate, the proof of hours worked is the evidence for the correction.

How long to keep it

Getting the hours signed off

1. Close the period on the same day each month, for example the last working day.
2. Check that the "Running balance" makes sense, and that days with ⚠ have an explanation in the notes.
3. Save the month as a PDF and get it signed by the worker and by the manager or client.
4. Send it to payroll in the same way every month and keep the signed copy.

Where proof of hours workeds go wrong

• Breaks are left blank. The proof then shows the whole time on site as working time.
• Short paid breaks are deducted for US staff. Rest breaks of about 5 to 20 minutes count as hours worked under the FLSA (29 CFR § 785.18).
• A shift past midnight is split across two days by hand and counted twice.
• The worker signs, but nobody on the employer side does. A one-sided proof carries less weight if the hours are questioned.