In this simplified case, Box 1 excludes the traditional 401(k) deferral. Boxes 3 and 5 include it, subject to the Social Security cap for Box 3 only.
Read the case before entering a formula. The workbook separates input amounts from the result so a reviewer can trace your calculation. Use references rather than typing the displayed total. A hidden copy changes the inputs and checks that your approach still works. Compare the result with the stated period and wage base, then examine any cap or zero balance. A blank cell and a zero result mean different things. Keep the sign on reconciliation differences so another reviewer can tell whether the register is higher or lower.
In this simplified case, Box 1 excludes the traditional 401(k) deferral. Boxes 3 and 5 include it, subject to the Social Security cap for Box 3 only.