Income and investing
Worked Hours & Pay Tracker
Timesheet template and paystub checker for hourly workers paid every two weeks. Type the hours you work each day by type, and the workbook shows what your next paystub should be, so you can spot a short cheque in seconds.
C$9CAD
Secure checkout. Sales tax, VAT or GST is added at card checkout where it applies.
- Instant download, nothing shipped
- Excel 2016+ and Google Sheets
- Filled-in sample file included
- Damaged or not as described? Fixed or refunded within 60 days
Prefer Etsy? Buy this template in our Etsy shop.
What it does
- Daily hours by type: regular, overtime, double time, on-call, stat or floater, vacation and sick, plus an unpaid day off
- Each pay period shows what you earned in the 14 days, what carries to the next cheque after the payroll cutoff, and what should be on this cheque
- Paystub check: type the gross from your stub and the difference turns red if it doesn't match. Note the missing hours on the same block
- Raises mid-period: each day uses the rate in effect on that date, and carried hours keep the rate of the day you worked them
- Banked time: three banks (for example banked regular, OT and DT) with opening balance, hours added, hours used and closing balance
- Year-to-date summary at the top of every year tab: hours and gross earned, gross on cheques, today's rate and banked balances
- Periods are filed under the tax year their pay day falls in. Tabs for 2026 to 2030, plus a blank year you can copy
Fits your paystub
- Rename the seven hour types to match your stub (for example "Shift premium" or "Call-back") and set each pay multiplier and how many days carry to the next cheque
- Split your rate into base, premium and differential, or enter one number
- Good for trades crews (union or non-union), shift workers and on-call staff
What you get
- XLSXWorked-Hours-Pay-Tracker.xlsx. The 2026 tab is filled with an invented sample worker so you can see every feature (including one short paystub flagged red). Clear the sample cells to start; the 2027 to 2030 tabs are empty
- PDFQuick-start guide (PDF)
Please note
Bi-weekly (14-day) pay periods only; weekly and semi-monthly payrolls are not covered. A tracking tool, not payroll, tax or legal advice. Multipliers, cutoff days and the banked-time year-end rule are editable sample settings: your employment standards, contract or collective agreement decides the real rules. For personal use; please don't resell or share the file.
Disclaimer
This template is a planning tool and does not replace advice from a qualified or licensed professional (such as an accountant, financial advisor, lawyer or certified tradesperson). Check the results before you rely on them.
How it was made
Designed by VARS Digital with AI-assisted tools. Every formula is checked before release.
Questions
Email varsdigitals@gmail.com and we'll help you get set up.
