Let staff punch in and out by project, then total approved hours and pay per person using their hourly rate.
Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.
Category
Tables
Employees, Time entries
Fields
19
Views
grid, calendar, form, dashboard
The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.
6 fields · 3 sample rows
| EmployeeText | DepartmentSingle select | Hourly rateCurrency | Time entriesLink to another table | Total hoursRollup | Approved payRollup |
|---|---|---|---|---|---|
| Zoya Khan | Engineering | ₹1,200 | 17 Nov 2026, 18 Nov 2026 | 12.25 | ₹9,900 |
| Ethan Clarke | Marketing | ₹950 | 17 Nov 2026, 19 Nov 2026 | 10 | ₹6,175 |
| Lakshmi Narayan | Support | ₹600 | 18 Nov 2026, 19 Nov 2026 | 13.50 | ₹4,800 |
13 fields · 6 sample rows
| DateDate | EmployeeLink to another table | ProjectSingle select | Clock inDuration | Clock outDuration | Break (min)Number | HoursFormula | RateLookup | AmountFormula | BillableCheckbox | ApprovedCheckbox | Approved amountFormula | Work doneLong text |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17 Nov 2026 | Zoya Khan | Client – Acme Retail | 9:30 | 18:30 | 45 | 8.25 | ₹1,200 | ₹9,900 | Yes | Yes | ₹9,900 | Inventory sync API |
| 17 Nov 2026 | Ethan Clarke | Client – Zenith Bank | 10:00 | 17:00 | 30 | 6.50 | ₹950 | ₹6,175 | Yes | Yes | ₹6,175 | |
| 18 Nov 2026 | Lakshmi Narayan | Admin | 8:00 | 16:30 | 30 | 8 | ₹600 | ₹4,800 | Yes | ₹4,800 | ||
| 18 Nov 2026 | Zoya Khan | Internal tools | 9:15 | 13:15 | 0 | 4 | ₹1,200 | ₹4,800 | ₹0 | |||
| 19 Nov 2026 | Ethan Clarke | Client – Acme Retail | 9:00 | 12:45 | 15 | 3.50 | ₹950 | ₹3,325 | Yes | ₹0 | ||
| 19 Nov 2026 | Lakshmi Narayan | Client – Zenith Bank | 13:00 | 19:00 | 30 | 5.50 | ₹600 | ₹3,300 | Yes | ₹0 |
Form view “Log your hours” asks for: Date, Employee, Project, Clock in, Clock out, Break (min), Billable, Work done.
Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.
Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.
Record daily check-ins per employee and get each person’s attendance rate and hours worked automatically.
2 tables · 17 fieldsEmployee Info SheetOne clean record per employee — role, contact, emergency details, documents and tenure — in a searchable staff directory.
1 table · 17 fieldsRecruitment TrackerManage open roles and every applicant against them — source, stage, interviews, ratings and expected pay — with a live hiring funnel.
2 tables · 30 fieldsCOVID-19 Quarantine TrackerLog each employee who is isolating, their test results and symptoms, and see exactly when they are cleared to return.
1 table · 14 fieldsEmployee Onboarding TemplateRun every new hire through a shared plan — before day one to the 90-day mark — with owners, due dates and live progress per person.
2 tables · 23 fieldsEmployee Referral TrackingCollect referrals from staff, move candidates through the hiring stages and keep referral bonuses straight per employee.
2 tables · 24 fields