Free Employee Leave Tracker Template for South Africa (2026)
Most leave trackers you find online were built for American or British leave law, and they get South African entitlements wrong. That is how employers end up underpaying staff or losing a leave dispute at the CCMA. This tracker is built around the Basic Conditions of Employment Act (BCEA), it is free, and it works in both Microsoft Excel and Google Sheets. You can download the Excel and PDF versions, or copy the table straight into a blank sheet where the balances calculate themselves. Published 8 June 2026.
How to track employee leave in South Africa
To track employee leave in South Africa, create one row per employee and a block of columns for each leave type the law recognises: annual, sick, family responsibility, parental and unpaid. For each type you store an opening balance and the days taken, and a simple formula such as =Opening minus Taken works out the balance that remains. The real skill is getting the entitlements right, because South African leave does not behave the way most online templates assume. Sick leave runs over three years, not one. Family responsibility leave lapses at the end of each cycle. Parental leave changed in October 2025.
BCEA leave entitlements to build in
These are the statutory minimums for an employee on a 5-day week, verified for 2026. Your own policy can be more generous, but it can never offer less.
- Annual leave: 21 consecutive days per cycle, which equals 15 working days, accruing at 1.25 days per month. Untaken annual leave must be paid out when employment ends.
- Sick leave: 30 days across a rolling 36-month cycle, not per year. In the first 6 months of employment the entitlement is 1 day for every 26 days worked.
- Family responsibility leave: 3 days per annual cycle, available after 4 months service to employees who work at least 4 days a week. It does not carry over and lapses at the end of the cycle.
- Parental leave: 4 months and 10 days, shared between parents. The Constitutional Court confirmed the Van Wyk judgment on 3 October 2025, which removed the separate categories of maternity and paternity leave. All parents, whether biological, adoptive or through surrogacy, now share one parental leave pool.
- Public holidays: 12 paid days a year, paid when the holiday falls on a day the employee would ordinarily work.
If your current tracker still has a column labelled maternity leave of four months, it is out of date. Track parental leave as one shared entitlement.
The columns and formulas that do the work
A practical tracker has one row per employee and, for each leave type, an opening column, a taken column and a calculated remaining column. The remaining columns should never be typed by hand. Use =Opening minus Taken so the balance updates the moment you record a new request. To work out accrued annual leave to date, multiply the months employed this cycle by 1.25. Add a flag such as =IF(Remaining<0,"OVER TAKEN","OK") to catch the moment someone is booked off more leave than they have. Once the formulas are in, lock those cells and protect the sheet so a colleague cannot type over a formula and quietly break every balance below it.
Seven mistakes that cost employers money
- Treating sick leave as an annual allowance instead of a 30-day pool over 36 months.
- Forgetting to pay out accrued but untaken annual leave when an employee leaves.
- Carrying family responsibility leave over to the next cycle when it should lapse.
- Using an outdated maternity column instead of the single shared parental leave pool.
- Letting balances go negative without a flag to catch it.
- Keeping one shared file that everyone can edit, so nobody trusts the numbers.
- Not keeping leave records for three years, as Section 31 of the BCEA requires.
What the law requires you to keep
Leave tracking is a legal duty, not just good admin. Section 31 of the BCEA requires every employer to keep a written record of each employee, the time they work and the pay they receive, and to keep it for three years from the last entry. Leave records sit at the heart of this. If an employee claims they were never paid out for untaken leave, the record is your defence, but only if it is credible. An editable spreadsheet that anyone can change, with no history of who edited what and when, carries far less weight at the CCMA than a dated, permissioned system record.
Where a spreadsheet stops working
A spreadsheet is a fine place to start for a handful of staff. The problems are predictable as you grow: no self-service for employees, no approval trail, accrual drift from missed manual updates, no link to payroll, version chaos, and weak standing as evidence because any cell can be changed after the fact. Synthro tracks all 16 BCEA leave types automatically from R49.99 per user per month. Employees check their own balances and request leave from their phone, managers approve in a tap, the correct accrual rules including the 2025 parental leave change are built in, and every change is dated and kept for the defensible record the BCEA expects.
Full BCEA leave guide | See leave management | Book a free demo