I have been using the program for many years and, I agree, this is very frustrating. I have used many of the methods described above. I would love to be able to produce a report that lists the vacation payable, per employee, at any specific time which reconciles with the trial balance amount. This would save me a lot of time and headaches.
Go to reports, payroll, employee. Choose ""custom reporting column settings"". Look in the left-hand column for ""report Columns"" - scroll down in the Column Name for ""Vacation Paid"" and ""Vacation Earned"".
When I am trying to reconcile vacation paid account (and employee loans/advances), I export the employee list (including all inactive employees) into Excel with their name and date of hire & termination (which may not be filled in). Then I set all employees to active, pretend I am paying them a paycheque and manually record any monies owed to or from each employee on my spreadsheet. The inactive employees have to be reset to being inactive once all my information has balanced. Watch that you are not accruing any new vacation pay for this ""pretend"" payroll. Is this a lot of work? Absolutely!
This is all fine and well for employees hired after the furthest recoverable date. However, in the case of long term employees where the most ""discrepancies"" lie because they may not ask for their entire vacation pay balance at any given time, this becomes impossible. As I am only going through my second year end with this particular company and the reconciliations were not done previously, I am at a loss to recreate accurate historical records.
Were I to ""rebuild"" from scratch I don't even know how far back in the archives I would need to go.