Free Timesheet & PTO Tracker for Small Teams
Clockbay Lite is a free timesheet and PTO tracker spreadsheet for up to 5 employees. Log daily clock in and clock out times with unpaid breaks, see regular and overtime hours for any workweek with a gross pay estimate, and keep a simple PTO and sick balance for each person.
What’s included
- Start Here tab with quick start steps and license
- Dashboard with 4 KPI tiles, an hours-by-week chart and PTO left by person
- Employees (5) with hourly rate and yearly PTO and sick allowances
- Time Log with 300 rows, automatic hours and checks
- Weekly Summary with regular hours, overtime and gross estimate
- Leave Log with 40 rows and approval status
Excel-format .xlsx for Microsoft Excel; tested in LibreOffice Calc; built with standard functions that also work when you open it in Google Sheets. Estimates only: check your local labor laws.
How it works
Type your business name, currency symbol, the first day of your workweek and your overtime limit on the Settings tab. Add up to five people with their hourly rate and yearly PTO and sick allowances. Then log one row per shift on the Time Log and one row per day off on the Leave Log. Hours, overtime, balances and the dashboard update automatically, and the Check column points out missing times or unknown names.
What the full version adds
The full Clockbay PTO Tracker & Employee Timesheet adds 25 employees, 6,600 time rows with lunch in/out, weekly or biweekly pay periods with a payroll-hours summary, daily overtime, PTO and sick accrual policies with caps and carryover, paid and floating holidays, a color-coded leave calendar, a Who’s Out view, a printable timesheet with signature lines, a 400-row leave request log and a full dashboard with 4 charts, plus a Word user guide.
How to download
Downloading needs a free Taskdale account, and free downloads are limited to 3 per day. Free for personal use in one business; you may not resell, share or redistribute the file.
Reviews
There are no reviews yet.