Payroll gross YTD not matching YTD

SUGGESTED

Through pay period ending 12-3-21 (checks issued 12-8-21) my payroll stubs reflect the same gross and year to date figures.  I don't know if this anything to do with it, but on 12-13 I did my year end closing so the open periods I have are 2021 and 2022.  I just ran payroll for week ending 12-10 and while my YTD figures are accurate the gross YTD figures are all over the place. I've double checked quarterly earning reports, tax liability reports, etc. and the figures appear to be ok. Can someone please explain this? 

  • 0
    SUGGESTED

    You have an addition issue in the background of your Sage 50 data. This can happen when Year End is run. Nothing to be greatly concerned about. You simply need to run a series of strategic Integrity Checks to correct this. BACKUP FIRST, then change back to Period 1. Click on Help and Support Utilities, then Integrity Check. Click the Continue button, then check mark the following options: (1) Under File Tests, check mark all three boxes, (2) Under Reindex File List, scroll down and highlight all choices that start with the word Employee, (3) Uncheck the Pause when error detected box, and last (4) Under Data Synchronization Tests, check mark Employee/JournalNOTE: You can check all of these in Integrity Check at the same time. Click OK to start the process. When done, change back to your current accounting period and pull up a previously entered Payroll Check (or create a dummy check) and verify that your Payroll Check Stubs are now calculating correctly. Backup again before allowing users back into the system. https://pcosupport.com 800-780-0700 / 954-961-0600 

  • 0 in reply to termerins

    The integrity checks corrected my issue.  Thank you so much!!!!

  • 0 in reply to LB0703

    Hi LB0703, if the above suggested answer helped, please do mark it as verified White check mark for the benefit of others in this forum :). Thank you!

     If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey

  • 0 in reply to termerins

    I have the same problem and ran the Integrity Check as stated above. This did not work for me. Any suggestions?

  • 0 in reply to Allysn

    I've never had a case where this didn't work until there are other issues in your system complicating this. I would suggest that you either reach out to Sage support (if you are current), or our company offers paid support assistance for this and any other Sage 50 issue. Please reach out to us if interested in working with us, https://pcosupport.com 800-780-0700 or 954-961-0600

  • 0 in reply to termerins

    We had the same issue beginning 01-01-2022. We noticed after we ran the first payroll of the year, that our balance sheet didn't balance, but just by a few cents. As of 08/31, the balance sheet difference had grown to $0.18. We compared the payroll reports to the G/L and everything was fine. By exporting the YTD check register to Excel and formatting the data to 3 decimal places, we saw that for each paycheck, gross pay wasn't rounding to 2 places. The sum of the YTD third-decimal amount totaled our balance sheet difference of $0.18. Today we ran the integrity check, suggested by termerins above from pcosupport.com, and resolved the issue. Great job, termerins!   

  • 0

    Our payroll checks are not calculating the year to date values.