Data integrity tells me I have an error between the Vacation pay balance and the vacation pay owed. I can't find the error and have no idea of where to look next. Can someone help me with this?
Data integrity tells me I have an error between the Vacation pay balance and the vacation pay owed. I can't find the error and have no idea of where to look next. Can someone help me with this?
Hi if you run an employees report showing vacation paid and vacation owed you should be able to see an employee with a balance. I would start there.
Also it is possible that a journal entry was made to adjust the vacation that did not go through payroll. Run the GL and see if you can see a manual journal entry. If this is the case then you need to enter it through payroll to fix the data integrity and delete the journal entry.
thank you very much; I have followed your advice and I found the error in under 5! I paid an employee 4% at his departure; however, I later noticed that my vacation payable acct was at a credit and realized that I hadn't accumulated vacation for this employee. In order to put this account at 0$ my accountant told me to do a journal entry with a credit to VP account and a debit to the vacation expense acct. This is definitely the error, but, other than deleting the journal entry, I don't know how to correct the original error from when I first made the check without having accumulated vacation for the employee. Can you help?
Hi you have to delete your journal entry and correct it through payroll or your data integrity will always be unbalanced. You have to go back to that employee and fix his payroll.
thanks, I've deleted the journal entry and my data integrity is fine now. I'm new at payroll this year, can anyone tell me how to correct the employee's payroll so that my vacation payable acct balances?
Is this employee terminated or still active?
terminated. The amount I paid was the 4% I owed him.
okay so you need to open that employees last payroll and go to the vacation tab on the left hand side at the top of the screen and enter the amount required that was not added as an accumulation. Re-Post. Then your data integrity and gl should be back in balance.
make sure that your net pay DOES NOT change before you post to ensure it doesn't change anything else.
thanks so much. I'll do this first thing tomorrow. I really appreciate your help.
you are very welcome anytime.:-)
I have just followed your instructions and this worked, my vacation payable account now balances and my data integrity is okay. I have to just say thank you again. My stress level has just gone down to zero...now it's time for T4 slips, lol! have a great day!
You are very welcome. If I can help you with anything else you can email me directly at [email protected]. Don't need that stress kicking in. :-)
Hi glad that it worked for you. No need to stress many here to help out. If you need help on anything else you can email me directly at [email protected]. Have an awesome day!
*Community Hub is the new name for Sage City