If you’re an HR manager, managing your team’s annual leave and vacation days can be a real headache. Receiving and approving vacation requests via email and manually entering or deleting dates from a spreadsheet is incredibly time-consuming and can lead to mistakes.Looking for an automated vacation tracking system? We’ve got a free Sheetgo template and a step-by-step guide to help you set up the system.
This way, there’s no need to buy any new software.
The template is ready to use — we’ve written the formulas for you.
How the vacation tracking system works:
- List all the employees and their opening leave balances
- Add all the holidays that you want to incorporte to the system
- Capture all the requests from your employees in a tab
- Track all the requests from the calendar view
Ready to automate annual leave requests and vacation tracking in your company?
Then here’s how to get started:
Step 1: Copy and configure the template
Get a copy of the Holiday tracking template. The template consists of a spreadsheet where you can accept or deny the holidays requested by your team members.
Inside the Employees tab, fill out the list of all your employees as well as the number of days off for that year.
In the Holidays tab, fill out the mandatory holidays for the company.
And that’s it! You have set up your template.
Step 2: Write down the requests from your employees
Every time you get a request, write it down in the Vacation request tab. If you have a small team, you can share the spreadsheet directly from there. Approve or reject as needed.
Sign up for Sheetgo and start tracking worked hours automatically
Step 3: Track all your requests from the Calendar tab
You can view the approved vacations, the total available as well. asthe calendar view marked with green when people are off.
Done — your holiday tracking system in Google is up and running!
Do you have a bigger team and don’t want to share the spreadsheet?
You can add a Sheetgo form, send automtic notifications via email or even connect the tracker to Google calendar.
English 
Español 
Português do Brasil 
Français