People template
Attendance / timesheet: free Excel workbook
The attendance / timesheet is a free, multi-sheet Excel workbook for a Kenyan business: hours worked per day, feeding payroll and job costing.
Hours worked are argued over at month end because nobody wrote them down as they happened.
What is in the workbook
Start here
What the workbook is for, how to fill it, and the colour key.
Attendance timesheet
The register: the right columns, dropdowns, and live totals. Type in the gold cells.
Dashboard
Your numbers added up as you go, with a simple bar view.
Lists
The dropdown options, so your data stays tidy and consistent.
Settings
The reporting currency, and where figures come from.
Next step
How SawaAfrik does this automatically from your real records.
The columns it includes
How to use it
- 1Download the workbook and open the "Attendance timesheet" sheet.
- 2Fill one row per entry. Type only in the gold cells; the white cells and the totals work themselves out.
- 3Where a cell has a dropdown, pick from the list instead of typing.
- 4Use the Dashboard to see your entries counted and summarised.
- 5When you outgrow the file, bring it into SawaAfrik, where it fills from your real records and the tax figures are computed for you.
Questions
- Does this feed payroll?
- It records regular and overtime hours per person per day. Those hours are what overtime pay and job costing are built from, so capturing them daily settles the argument before it starts.
- Is the attendance / timesheet free?
- Yes. Download the attendance / timesheet as a ready-to-use Excel workbook, with no sign-in and no payment. It is yours to keep and edit.
- What is inside the attendance / timesheet workbook?
- Six sheets: a Start Here guide, the Attendance timesheet register (Date, Employee, Project/Site, Start Time, End Time, Break Hours, and more), a Dashboard that adds everything up, a Lists sheet for the dropdowns, a Settings sheet, and a Next step sheet. It opens in Excel, Google Sheets or WPS, with no macros.
- Does it work in Google Sheets and on my phone?
- Yes. The workbook opens in Excel, Google Sheets or WPS. There are no macros, so it works on a phone or a laptop. Keep your own copy before you share it.
- How do I keep the attendance / timesheet consistent?
- Use the dropdowns where they appear, and fill one row per entry. The Dashboard counts and summarises your entries, so you can see the picture at a glance without a formula.
- How is this different from the SawaAfrik app?
- A workbook is a file you fill in yourself. Inside a free SawaAfrik workspace the same shape fills from your real records, invoices, payroll and expenses flow in once and appear everywhere, deadlines remind you before they are due, and statutory figures are computed with their source and date. The workbook is the start; the app is when you stop retyping.
Related workbooks
- View
Employee register
Every employee: IDs, KRA PIN, NSSF/SHA numbers, pay and status.
- View
Payroll register
Monthly pay inputs per employee: basic, allowances, deductions.
- View
Payroll statutory check
PAYE, NSSF, SHA and AHL per employee, reviewed before filing.
- View
Leave register
Leave entitlement, taken and balance per employee.
Want it built to your exact workflow, in your branding? We make custom workbooks, documents and software on the same registry-backed, audited platform.
Work with us