Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Local Tax Calculation incorrect in Payroll 2019

  • 1.  Local Tax Calculation incorrect in Payroll 2019

    Posted 11-15-2019 15:16
    The tax amount is not calculating correctly for a local tax. I cannot see anything wrong in the tax profile I created, and it's only one of the local taxes that is not calculating correctly.

    ------------------------------
    Jane Scanlan
    Partner, Next Level Manufacturing Consulting Group
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------


  • 2.  RE: Local Tax Calculation incorrect in Payroll 2019

    Posted 11-15-2019 15:18
    I had this happen for MI local tax.  Had to download the tax update that kept popping up and I found the legacy payroll had the wrong rate for the local tax.  So 2.19.4 was correct, old 2017 was incorrect.​

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------



  • 3.  RE: Local Tax Calculation incorrect in Payroll 2019

    Posted 11-15-2019 15:23
    Nancy, this tax is a simple calculation of 2.2% of gross wages, and it was correct in legacy payroll.  I wish I could get at the magical Tax Group setup to see what rate it is using.  If I back calculate what percent it is using it is 1.45%.  The tax rule for that jurisdiction is plain old 2.2%.

    ------------------------------
    Jane Scanlan
    Partner, Next Level Manufacturing Consulting Group
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------

    Original Message


  • 4.  RE: Local Tax Calculation incorrect in Payroll 2019

    Posted 11-15-2019 15:25
    any deductions being subtracted first, all tax tables downloaded?​

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------

    Original Message


  • 5.  RE: Local Tax Calculation incorrect in Payroll 2019

    Posted 11-15-2019 15:37
    If there is more than one Tax Profile, did you check that Tax Profile assigned to each earnings code to ensure local tax is set to calculate?

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------

    Original Message


  • 6.  RE: Local Tax Calculation incorrect in Payroll 2019

    Posted 11-15-2019 16:10
    Employee only has one tax profile. There is no such thing as a Tax Profile to assign to an earning code, so I'm not sure what you meant (maybe you meant Tax Rule) - the Tax Rule is assigned correctly.

    ------------------------------
    Jane Scanlan
    Partner, Next Level Manufacturing Consulting Group
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------

    Original Message


  • 7.  RE: Local Tax Calculation incorrect in Payroll 2019

    Posted 11-15-2019 16:09
    Tax tables are up to date.  Tax group logic is wrong.  It is supposed to be calculating on gross wages, but instead it is calculating on the net check amount (just figured this out).  I had to call Sage support and they verified that it is not working right.  UGH.  So now this employee does a weekly payroll and for these employees they are going to have to have their tax manually calculated.

    ------------------------------
    Jane Scanlan
    Partner, Next Level Manufacturing Consulting Group
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------

    Original Message


  • 8.  RE: Local Tax Calculation incorrect in Payroll 2019

    Posted 11-15-2019 16:11
    And I did ask Sage how to get to the Wizard of Tax Group in the magic cloud.  :(

    ------------------------------
    Jane Scanlan
    Partner, Next Level Manufacturing Consulting Group
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------

    Original Message


  • 9.  RE: Local Tax Calculation incorrect in Payroll 2019

    Posted 11-15-2019 16:13
    In Sage's case it's more like smog...

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 10.  RE: Local Tax Calculation incorrect in Payroll 2019

    Posted 11-15-2019 16:14
    Referring to the Tax Group Details in the Tax Profile


    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------

    Original Message


  • 11.  RE: Local Tax Calculation incorrect in Payroll 2019

    Posted 11-15-2019 16:15
    Yes, everything is correct there.  Sage has verified that this tax calculation is not working right as I got off the phone with them a few mins ago.

    ------------------------------
    Jane Scanlan
    Partner, Next Level Manufacturing Consulting Group
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------

    Original Message


  • 12.  RE: Local Tax Calculation incorrect in Payroll 2019

    Posted 11-18-2019 16:29

    Local taxes have been horrible for us.  One client has a new locality and the local tax went into effect in August.  After multiple calls to Sage, the tax "should" be included in an update in December. 

     

    What a cluster.

    Pam

     

    Sent from Mail for Windows 10

     



    ------Original Message------

    Tax tables are up to date.  Tax group logic is wrong.  It is supposed to be calculating on gross wages, but instead it is calculating on the net check amount (just figured this out).  I had to call Sage support and they verified that it is not working right.  UGH.  So now this employee does a weekly payroll and for these employees they are going to have to have their tax manually calculated.

    ------------------------------
    Jane Scanlan
    Partner, Next Level Manufacturing Consulting Group
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------


Related Content