I have the same problem! Have you found a way around this or help with this? 

The short answer is no.

The longer answer...

We decided that it was impractical to put in so many new formulas and so made the decision to only tax two payrates - our regular and incentive pay.  I followed the directions from Sage to input the formula for two pay rates only.  We will miss out taxing holiday and vacation pay, but the difference will be made up when our employees file tax returns next year, and we figured up they will only be off around $50 or so in tax.  We did it this way because what we class as "incentive" pay makes up a large part of our hourly employee's pay.   

Really, the only other way I can see getting around this is to just tax the OT pay, and let them make it up next year doing their taxes.  Most of our employees would rather have the break now though.

Just out of curiosity, did you ever call Sage support? I don't usually get the most helpful answers from them and avoid calling them at all costs, but I think I may have to in order to try and find a solution. We have regular billable, OT billable, regular non-billable, OT non-billable, personal leave, holiday and bonus/incentive pay types for our hourly employees. Not to mention all our employees hourly pay rates are not the same. It is just crazy to me that their solution is based off companies only have 2-3 pay types, 2 pay rates or consistant pay rates among all employees. 

No, I never called them.  I just chatted online with an agent (after I got past the computer assistant).  I also avoid calling them at all costs.  The agent online is the one that told me I would have to set up a different formula for each pay rate.  Okay...I have a different and much smaller company where that worked because I only have 2 hourly employees.  But anymore than 10, and that's too much to keep track of, especially for an exemption that's only supposed to last 18 months.  I agree it's a weird fix.  

We have 18 positions with 7 pay tiers. What they were telling me to do was input a formula for every pay tier plus the different pay rates for each position for each filing status. That would end up with something in the 100s and I will have to edit them every time someone gets a raise or changes positions. It's ludicrous that we have to program the program ourselves!! AND the formulas they gave us don't help the employees that get reg rate pay but over 40 in 7. Doesn't take into account that vac/sick time is separate from working hours. It's such a mess and Sage is totally unhelpful. I just want to make sure my people aren't stuck paying at the end of the year at this point. But how can I make sure of that when the system won't let me keep an accurate record?

I feel your pain.  I got the same response from Sage, which is just crazy to me.  If you don't want your employees to have to pay in at the end of the year, you could always just tax the OT as normal and let them figure out their refund at the end of the year.  But then they aren't getting the advantage of more money in their pockets now. I really don't know which way is worse.