Sage 100

 View Only

  • 1.  NonResident vs Resident Wage Report

    Posted 02-09-2021 10:28
    I feel like I may be missing something.  Trying to put together a custom report that separates Resident and Non-Resident wages and taxes.  The standard Quarterly Tax Report will not work because everything shows under the same Tax Location Code - there's no differentiation between Resident and Non-Res wages/taxes.  I thought I had it using the PayrollHistoryHeader, PayrollHistoryDetail, PayrollHistoryTaxDetail BUT when there are multiple earnings lines on the check, the amounts are overstated.  I can't be the only one needing something like this.  Specifically, this is for Philadelphia wages.  The client is required to report res and non-res earnings/taxes separately.  Anyone else dealing with something similar?  I hope I'm just overthinking this because right now, I'm stuck.  Thanks so much!

    ------------------------------
    Dawn Kulbacki
    Capitol Computer Systems, Inc.
    ------------------------------


  • 2.  RE: NonResident vs Resident Wage Report

    Posted 02-09-2021 10:34
    Are you using different tax profiles for the appropriate earnings lines?  Have you looked at PR_EmployeeTaxHistory?

    ------------------------------
    Mary Jo Krueger
    Senior Software Consultant
    CLA (CliftonLarsonAllen LLP)
    Appleton WI
    920-996-1176
    ------------------------------



  • 3.  RE: NonResident vs Resident Wage Report

    Posted 02-09-2021 10:45
    Yes, there are separate tax profiles for resident and non-resident wages and they do select the appropriate profile when entering the earnings.  The issue is that Sage isn't storing tax info by 'profile' but by 'tax location code' and the tax location code is the same for both types of wages.  The only way to know the difference is by looking at the tax profile.  That field is only available in the PayrollHistoryDetail file.  The PR_EmployeeTaxHistory only has the tax location code.

    ------------------------------
    Dawn Kulbacki
    Capitol Computer Systems, Inc.
    ------------------------------

    Original Message


Related Content