Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
May 17, 2026
Question

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

  • May 17, 2026
  • 1 reply
  • 0 views

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 reply

QuickBooks Team
May 17, 2026
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.