Problem
W-2
printing gives wrong maximum for social
security and medicare for employees earning more than
57,000 a year
using older W-2 Blank, FICA limits off
Diagnosis
they need to change the limit on the blank used
by MacNail construction
payroll software.
1. Open the Blank.
2. Go to Options menu and Unprotect document.
3. Go to cell E3.
4. The formula is now =MIN(E2,soc.sec.limit) change that to =MIN(E2, 62700) or whatever this year's limit
is
5. protect and save the blank.
6. Run W-2's again.
Solution
1995 LIMIT-- 61,200
1996 LIMIT-- 62,700 (use in Jan 97)
1997 LIMIT-- 65,400 (use in Jan 98)
ALTERNATE METHOD CHANGING DEFINED NAME:
1. Open the Blank.
2. Go to Options menu and Unprotect document.
3. Choose Defined Names from the Formula menu.
4. Scroll down to soc.sec.limit, click on it, and change the # in the Refers To box.
Comments
Entered 1/10/96 by Dennis. Updated 11/23/2010.
|
