Browse By Tags

  • How to fix issues with Payroll Tax Formulas

    I am in the process of setting up Payroll in a new company. We already have payroll set up in another company and are trying to recreate their settings in the new one. I tried using import/export, but for various reasons 98% of the information wouldn…
  • How do I change payroll deductions for employee based on percentage

    I am needing to change the percentage of a deduction for an employee. How can this be done? The deduction is a state retirement fund that is not listed under the benefits tab. It is being paid by both the employee and employer. The percentage is increasing…
  • Cities that have their own sick leave requirements in addition to what the state requires?

    How do you deal with multiple cities that have their own sick leave requirements in addition to what the state requires? The state has provisions to put in a lump sum and not accrue or roll over but we are starting to do business in certain municipalities…
  • Pay ID Formula

    Is there a way to setup a payroll formula to set up a new Pay ID that adds a premium to regular rate for a shift differential? We do not want to add the shift column to our time entry since we use hh2 and it would cause changes in how we import time from…
  • Not Calculating Fringes Correctly

    We are running Sage 18.4.1. We just went live a couple weeks ago and noticed something was off with our fringe calculations. In the Union set up the pays and fringes are set to total hours as the calc method. The fringes should be only calculated based…
  • Formula MAX Pay Period End Date

    Looking for a formulaa to simply look into the PR-Check table and return to me an employees maximum date within the Pay Period End Date field . As the help file suggests, the MAX function is only used for numbers and Sage doesnt like it when I try to…
  • PR formula to lookup employee rate

    We are trying to create a formula that will provide the hourly rate for an employee that can then be used in fringe calculation formulas. I can use a basic LOOKUP if there are only 2 Pay IDs. We have 4 different Pay IDs under two Pay Groups that we need…
  • Trying to setup an Accrual formula that "resets" on the anniversary of an employees hire date

    I am trying to create a formula that will "reset" the number of hours an employee has accrued on the anniversary of their hire date. For example, if I have 56 hours of sick & my hire date is 9/5/2016, I want it to "reset" to 40 on 9/5/2017. If I only…
  • not greater than formula

    Can I set up a payroll formula for my employer portion of Simple IRA to say 3% but not greater than the employees contribution? I have a few EEs who contribute a flat rate and I am not sure how to get them to calculate the 3% and then one who is paid…
  • Over Time formula for payroll

    Help with Over Time formula.