Payroll Tax Withholding for the new 2020 W4

Hi guys,

I do have the most recent version of Sage 300 (18.4 Update 2) but I think I found an error with the Federal Tax Withholding calculations, unless I'm interpreting something very wrong.

Whenever the new year starts, I spot check tax withholding by calculating the tax withholding on a few checks manually. Everything is fine for people who are using an older W-4 form, but I have one employee who has submitted a new W4 and that's where the tax calculations seem off. 

My employee is Single and the total amount for Step 3 is $2,000. No other boxes are checked and no other fields have data. 

I did my manual calculation using the IRS worksheet and tables located in Publication 15-T, and I've attached the worksheet for reference. My calculations result in $99.38 to be withheld per weekly pay period, Sage comes up with $137.84. After trying a few different things, I figured out where we vary. I get the amount of Sage's withholding if I count the $2,000 as a DEDUCTION but the IRS considers it to be a tax CREDIT. Can someone confirm if that my understanding of the calculation is correct before I run off to Sage and tell them the error?

Thanks much!

1325.Tax Calculation 2020.pdf

Top Replies

  • Hi ,

     

    Since it looks like you are using Sage300CRE,

    I am going to move this post to that Support Group so that other users of this software will see it and can offer you their thoughts and insight…

  • 0

    Hi ,

     

    Since it looks like you are using Sage300CRE,

    I am going to move this post to that Support Group so that other users of this software will see it and can offer you their thoughts and insight.

     

    Thanks,

    Erzsi

  • 0

    Hi mec5700,

    This was brought to our attention earlier today on a previous post and we're currently looking in to it.

    We will have more information soon.

    Thanks!

  • 0

    I am seeing the same issue.  Even after installing 18.4 update 3 and updating the tax table again.  I just added a new employee using the new W-4 format and believe Federal Withholding is incorrect.  I did the calculation according to instruction by IRS 15-T publication and came up with a different number.  Called support yesterday and he couldn't find anything wrong with my calculations but sent me an excel spreadsheet that shows the amount Sage payroll is coming up with and told me it must be right.  I then contacted our accountant and gave them the figures and asked them to tell me what the federal withholding should be and they came up with the number I did.  

    Did they get things resolved for you?