========================================================== PAYROLL WITHHOLDING TAX CALCULATOR ========================================================== !!! SEE LEGAL NOTICE AT THE END OF THIS DOCUMENT !!! ========================================================== This program is NOT free and is NOT in the Public Domain. If you use it, you must pay >$25.00< per site. To register, send a check to: Stephen M. Dunn 15652 S.W. 16th Street Pembroke Pines, FL 33027 Email CIS: 75006,2430 Internet: 75006.2430@compuserve.com =========================================================== DESCRIPTION: ============ All companies process manual payroll checks. Even the largest, most highly automated companies do a surprising amount of manual checks. One of the most time-consuming tasks is to calculate the proper withholding amounts. An audit generally shows that a number of them were calculated wrong. No one knows until an irate employee (hopefully not a senior exec!) screams at tax time. This spreadsheet makes the calculations quick and easy! It faithfully reproduces the tax tables in "Circular E" while performing the calculations using the more accurate annual amount method. In addition, it can be easily updated to reflect any changes in limits and rates in the future. INSTRUCTIONS: ============= If you downloaded TAX_123.ZIP, it contains the following: Spreadsheet Program: Filenames ------------------- --------- Lotus v2.3 for DOS TAX_23.WK1 with WYSIWYG enabled TAX_23.FMT Lotus v3.1 for DOS TAX_31.WK3 with WYSIWYG enabled TAX_31.FM3 -------------------------------------- If you downloaded TAX_XL.ZIP, it contains the following: MS Excel v4.0 TAX_XL4.XLS MS Excel v5.0 TAX_XL5.XLS If you downloaded WITHHOLD.ZIP, it contains all of the above files. ---------------------------------------------------------- To use, just type in the amounts in the blue fields. GROSS PAY: This is gross pay LESS any pre-tax benefits such as medical insurance or 401(k). SINGLE/MARRIED: Enter S or M (or s or m), it is not case-sensitive. # of EXEMPTIONS: Enter up to a maximum of 10. CURRENT YTD EARNINGS: This is to see if Social Security should be withheld. PAYROLL PERIOD CODE: Choose a code from the table. It recalcs automatically, so the answer shown always uses the data shown on the screen. HELP SCREEN FOR LOTUS USERS: HELP can be found by pressing the F5 fuction key, then the ? (questions mark) and pressing ENTER. HELP SCREEN FOR EXCEL USERS: HELP can be found by pressing the F5 fuction key, then the letter H and pressing ENTER. The HELP screen shows the layout and how to update the spreadsheet for a new year's rates and limits. Press F5, then M and press ENTER to return to the Main Screen. The calculator does NOT use macros. This enables its use in other spreadsheet programs that can load Lotus or Excel files with only the loss of some screen formatting. ========================================================== !!! LEGAL NOTICE !!! ========================================================== This software is provided "AS IS", without warranty, either express or implied, regarding its merchantability, or its fitness for a particular purpose. In no event will Stephen M. Dunn be liable to you for any consequential, incidental, or indirect damages (including damages for loss of business profits, interruption, information, and the like) arising out of the use or inability to use the software even if Stephen M. Dunn has been advised of the possibility of such damages. ==========================================================