In today's computerized environment, many vacation accrual calculations are made automatically in the organization's human resources software program. However, not all companies use such a software program. Instead, they may use a vacation accrual spreadsheet in a program such as Excel to track the vacation each employee has earned. The calculations should be verified to ensure employees get the correct amount of vacation hours and that the company only pays for the correct number of hours.
Things You'll Need
- Vacation accrual policy
- Vacation accrual spreadsheet
- Calculator (if desired)
Review your organization's vacation accrual policies. Determine whether accrued vacation can be carried over from previous years and if so, whether there is a limit. Determine how much vacation is earned per pay period and whether an employee's length of employment has any impact on the amount of vacation that is earned.
Verify that the spreadsheet includes carried over vacation hours in the accrual.
Check the calculation for the accrual of vacation based on the proper amount accrued per pay period for each employee. For example, an employee who earns 10 vacation days a year earns 10 times the number of hours worked each day. So if you work 8 hours a day, the employee earns 80 hours of vacation time each year. If you work 7.5 hours a day, the employee earns 75 hours of vacation time each year.
Calculate the amount of vacation hours that should be accrued each pay period. For example, if your employees are paid bi-weekly, there are 26 pay periods in a year. 80 hours of vacation time earned over 26 pay periods means that the employee should accrue 3.077 hours of vacation time per pay period (80 divided by 26 is 3.077).
Verify that the spreadsheet subtracts vacation hours that are used in a pay period. For example, the employee may earn 3.077 hours of vacation pay in a pay period but use 8 hours of vacation pay in that pay period. The spreadsheet should show a "credit" of 3.077 vacation hours and a "debit" of 8 vacation hours for a total accrual for that pay period of -4.923 vacation hours. The spreadsheet should keep a running tally so that you and the employee know how many vacation hours the employee has available at any time.
- Photo Credit calculator image by Szymon Apanowicz from Fotolia.com
Federal Employee Vacation Policy
The federal government competes for workers not only by offering good pay but good benefits, including the vacation package. All federal workers...
Accounting for Vacation Accrual
Employers who offer vacation and sick leave incur a financial liability whenever employees accrue leave time. Accounting practices vary, but there is...
How to Calculate Annual Leave Entitlement
Human Resources benefits professionals and relationship managers typically must understand how to calculate annual leave entitlements. Having this knowledge as an individual...
How to Track Employee Vacation & Sick Leave
Most companies provide employees with a certain amount of vacation and sick leave to use throughout the year. There are a number...
How to Calculate Vacation Pay in B.C.
In British Columbia and other Canadian provinces and territories, employees earn a bonus in addition to their hourly wage called vacation pay....
How to Create an Excel Spreadsheet to Figure Out Sick Leave
Microsoft Excel can replace mundane tasks with formulas and functions. One task that can streamline any manager or supervisor's job is to...
How to Calculate PTO
You can calculate paid time off with straightforward formulas, but you may need to consider which formula works best for your employees.
How to Calculate Vacation Time Earned in Work Businesses
Some states regulate vacation pay, classifying the time as wages and subjecting vacation accrual to the same regulations as wage payments. For...