Separate vacation and sick allowances per employee, with every absence logged and both balances recalculated automatically.
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, Absences
Fields
20
Views
grid, calendar, kanban, 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.
9 fields · 4 sample rows
| EmployeeText | DepartmentSingle select | Vacation allowanceNumber | Sick allowanceNumber | AbsencesLink to another table | Vacation usedRollup | Sick usedRollup | Vacation leftFormula | Sick leftFormula |
|---|---|---|---|---|---|---|---|---|
| Ananya Iyer | Engineering | 18.0 | 8.0 | 20 Oct 2026, 10 Nov 2026 | 4 | 1 | 14 | 7 |
| Daniel Okafor | Sales | 15.0 | 10.0 | 5 Nov 2026, 17 Nov 2026 | 0 | 4 | 15 | 6 |
| Sana Mirza | People | 18.0 | 8.0 | 15 Nov 2026 | 0 | 0.5 | 18 | 7.5 |
| Wei Zhang | Finance | 14.0 | 14.0 | 29 Nov 2026 | 5 | 0 | 9 | 14 |
11 fields · 6 sample rows
| FromDate | EmployeeLink to another table | ToDate | TypeSingle select | Half dayCheckbox | DaysFormula | Vacation daysFormula | Sick daysFormula | ApprovedCheckbox | Medical noteAttachment | NotesLong text |
|---|---|---|---|---|---|---|---|---|---|---|
| 20 Oct 2026 | Ananya Iyer | 24 Oct 2026 | Vacation | 4 | 4 | 0 | Yes | |||
| 10 Nov 2026 | Ananya Iyer | 10 Nov 2026 | Sick | 1 | 0 | 1 | Yes | Migraine | ||
| 5 Nov 2026 | Daniel Okafor | 7 Nov 2026 | Sick | 2 | 0 | 2 | Yes | |||
| 15 Nov 2026 | Sana Mirza | 15 Nov 2026 | Doctor appointment | Yes | 0.5 | 0 | 0.5 | Yes | ||
| 29 Nov 2026 | Wei Zhang | 6 Dec 2026 | Vacation | 5 | 5 | 0 | Lunar New Year planning | |||
| 17 Nov 2026 | Daniel Okafor | 18 Nov 2026 | Family care | 2 | 0 | 2 | Yes |
Form view “Report time off” asks for: Employee, Type, From, To, Half day, Medical note, Notes.
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