Your hours. Your rules. Your sheet.

Hours and pay, in Excel or Google Sheets.

Hours & client-billing workbook available · Advanced overtime example is read-only.

Valio Hours & Pay.xlsx

Maya Chen / Warehouse A / USD

Sample workbook · read-only

HOURS & PAY · PAY-PERIOD SUMMARY

	A	C	D	E	G
1	HOURS & PAY · PAY-PERIOD SUMMARY
2	Worker	Maya Chen		Pay period	Aug 1–15, 2026
3	Job	Warehouse A		Pay schedule	Twice monthly
4
5	PAID HOURS	GROSS PAY · USD		OVERTIME WORKWEEK	RECORD STATUS
6	95h 30m	$2,556.00		Monday → Sunday	Filled example
7
8	PAY BREAKDOWN · each hour appears in one winning rate bucket
9	Pay category		Paid hours	Rate / hour	Gross amount
10	Base rate		73h	$24.00	$1,752.00
11	Overtime · 1.5×		18h 30m	$36.00	$666.00
12	Daily tier 2 · 2×		1h	$48.00	$48.00
13	Night rate · base + $6		3h	$30.00	$90.00
14	TOTAL GROSS · before deductions				$2,556.00
15
16	Payroll ends August 15. The overtime week continues through August 16; it does not reset at the payroll cutoff.
17	Rules used	Custom policy v0.1 · highest effective rate wins
18	Preview outputs are illustrative and do not run production spreadsheet formulas. Explore Settings & Rules to inspect the assumptions.

Pay-Period Summary · 18 rows · read-only example100% · preview only

Sample data, not live formulas.

Features

Hours and pay, together

Shifts, breaks and totals in one workbook.

See the rules behind the pay

See overtime and premiums behind each total.

Two familiar formats

Excel or Google Sheets. Five sheets to explore.

FAQs

Can I download a template?

Yes. Enter your email and we’ll send the hours and client-billing XLSX. Open it in Excel or import it into Google Sheets. The advanced overtime preview is separate.

Can I enter my own hours?

Enter your own net hours, minutes and client rates in the downloaded workbook. The browser overtime example remains read-only.

Does the example match my overtime rules?

The sample uses custom rules, not local payroll presets.

Guides