TwoWorkSupport
← All categories

Vacation accounting

Keep Track of Your Employees' Vacation

We've created a simple and practical solution to help you maintain an overview of your employees' vacation days. With our vacation accounting Excel file, you get the complete overview of earned and taken vacation days.

TwoWork Vacation Accounting Excel File

To give you the complete overview, we've created a practical Excel template. The file makes it easy to track:

  • Vacation days carried over from last year
  • Monthly registration of vacation days taken
  • Automatic calculation of earned vacation days (2.08 days per month)
  • Running balance for each employee

Download Vacation Accounting 2026

How to Use the Excel File

  1. Download the template via the link above
  2. Replace employee names in the first column with your own employees
  3. Enter carried-over days from last year in the "From last year" column
  4. Register vacation days taken month by month
  5. See the automatic calculation of earned days and running balance

How It Works

  • The Excel file is a supplement to TwoWork - a simple tool to maintain overview
  • You update the file when employees take vacation
  • The file automatically calculates earned vacation days based on the current month
  • Save a new copy of the file for each year

Usage Tips

  • Update the file after each vacation to keep it current
  • Check the balance before approving new vacation requests
  • Save a backup of the file regularly

Register Vacation in TwoWork

Your employees can easily register their vacation days in TwoWork:

  1. Go to the "Hours" page
  2. Click "Add Hours"
  3. Select the vacation date
  4. Enter normal working hours
  5. Choose "Vacation" as Time Type
  6. Click "Add"

Why register vacation in TwoWork?

When your employees register vacation in TwoWork, the data never disappears. You can always find the registrations again, and when you export hours for payroll, you can easily see how many vacation hours each employee has taken. For example: 37 hours = 5 vacation days. You can then enter this number into the vacation accounting above.

Need Help?

Have questions about how to use the vacation accounting, or are you missing a specific feature? Write to us at support@twowork.app