vacations payable - and vacation forward amounts

Hi I how to fix vacation forward amounts for my employees.

the system keeps showing data inconsistency and I believe is because the forward amounts are not correct

thank you

Parents
  • Hi SC@bell,

    Do you mean the Year to Date Vacation amount of your employees is not correct and you need to make adjustment?

    Or your Vac. Pay Balance is not the same as the Vac. Pay Owed in the Integrity Summary?

     

     

Reply
  • Hi SC@bell,

    Do you mean the Year to Date Vacation amount of your employees is not correct and you need to make adjustment?

    Or your Vac. Pay Balance is not the same as the Vac. Pay Owed in the Integrity Summary?

     

     

Children
  • in reply to Keith L

    I ddin't put in the balance forward when i started doing the payroll, and the vacation owed is incorrect

  • in reply to Mary Martin

    Try this:

    1.  In payroll, do a dummy paycheque with nothing on it except for an entry to Vacation Earned for the amount of the missing balance forward.  This will make the vacation owed in the payroll system correct, which is good.

    Before you post this payroll, use the 'report - display journal entry' option to see exactly which accounts are being affected.

    It will also create a journal entry that debits wage expense and credits vacation payable, even though this opening balance amount was already built up, by a number of debits to wages and credits to vacation payable, before you started using Sage's payroll features.  The new journal entry created by the dummy paycheque is a duplicate journal entry.  This is not good.

    2.  If you are NOT using the accountant's version of Sage, go into Settings and find the linked account for Vacation Payable.  Note down what it is now, so you can put it back in later.  Then, delete the link to that account.  If you're using the accountant's version, you can skip this step because the accountant's version allows posting to 'blue' (linked) accounts.

    3.  Do a general journal entry to reverse the duplicate entry from step 1.  Credit wage expense, debit vacation payable.

    4.  Go back into Settings and restore the linked account for Vacation Payable.

    Check your data integrity - should be good now.

  • in reply to C White

    do i do this for each employee as that's where I noticed it

  • in reply to Mary Martin

    Yes, unfortunately you have to do step 1 for every employee with an error in their opening balance (as shown in Sage payroll).  Steps 2-4 can just be done once for the whole business.