1 Reply Latest reply on Feb 12, 2009 6:42 AM by ninja

    How to auto enter Fed

    coolbaldguy

      Title

      How to auto enter Fed & State W/H

      Post

      Is it possible to enter the entire married and single tax tables and some how be able to preform a <> gross pay range or case calculation that relates to the employee w/h status that will auto enter the Federal and state withholdings in their corresponding fields. 

        • 1. Re: How to auto enter Fed & State W/H
          ninja
            

          Howdy coolbadguy,

           

          yes, of course it's possible...everything is possible (almost)...how bad do you want it?

           

          What you're looking at is a way nasty set of nested "If" statements or an "almost as nasty but not quite" Case() function in your calculated field.  If you're only doing yours, don't bother.  If you're writing an app for 1000's of folks...go for it.

           

          Yes, it's possible...not even very tricky...just plain old real, real LONG.

           

          have fun with it!

           

          Edit addition: It occurs to me that the tax tables are only one way to calculate tax, there is also a formula provided using a base rate and a percentage of income above a threshold.  Why would you want to use the tax tables?  Use the formula instead.  Please note that I am not an accountant or in any authoritative role related to taxation, I just pay 'em.