Limited time only. 90% off QuickBooks for 6 months.
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
pclaessen-baxtec
Level 1

How can i find the vacation owing per employee as of a specific date?

The only response I can find to this is that I would have to open every individual pay stub from the last pay of our fiscal year end to find the individual amounts. Seriously?

1 Comment 1
Rusimyhr
QuickBooks Team

How can i find the vacation owing per employee as of a specific date?

Opening the individual pay cheques to view the stubs is the built-in way the system tracks past balances.
 
If you need to calculate historical balances for all employees without opening each pay stub, you can use a manual spreadsheet workaround. Go to the Reports menu, run the current Vacation and Sick Leave report, and export it to Excel.
 
Then, run Payroll Details report for the date range starting the day after your year-end up to today. By entering those into Excel, you can calculate today's balance by subtracting the vacation accrued since year-end, and adding back any vacation taken.
 
Let me know if you need anything else. 

Need to get in touch?

Contact us