Holiday and Absence Planner Excel Template | Absence Log, Holiday Entitlement and Live Balances

For small employers who track staff holiday and time off. Every day off goes on one log, with who, when and what kind. Entitlement balances update live for each person, so you can check before you say yes. Set your lists once and the dropdowns do the rest.

What it covers

• Absence log for every day off, who, when and what kind
• Live holiday entitlement balances per person
• Set your lists once and every dropdown uses them
• Goals and targets with dates
• Weekly and monthly review tabs
• Notes and actions tab so follow ups get done

Who it is for

Suits small businesses, trade firms, shops, offices and team leaders managing staff leave.

What is inside

• Easy Setup, your lists in one place so every dropdown matches how you work
• How To Use and Quick Start guides, from download to working in ten minutes
• Absence Log
• Entitlement
• Notes and Actions, Log and Diary, Goals and Targets, Weekly Review and Monthly Review tabs

How it works

Open the file in Microsoft Excel and start on the Easy Setup tab. Swap the sample lists for your own and every dropdown in the workbook updates. White cells are yours to type in and blue tinted cells calculate themselves, so there are no formulas to write. The example rows show every feature working, overtype them with your own figures and the totals and charts update as you go.

What you get

• One editable Excel (.xlsx) workbook with 10 tabs
• Built for Microsoft Excel, no macros and no formulas for you to write
• Example rows included so you can see every feature working
• Commercial licence, use in your own business, not for resale
• Instant digital download, no physical item shipped

Small print

Template only. The names, jobs and figures shown in the product images and in the example rows are examples only, overtype them with your own. A planning and record keeping aid, not professional advice, so check big decisions with the relevant professional.