The payroll reviewer at fictional Cedar Loom needs a reconciled workbook before the pay run closes. Use only the supplied amounts and policies. Carry the prior worksheet forward, add the next result and retain earlier formulas. The final checked calculation completes the workbook handoff. A reconciled number does not replace approval of the worker master data or bank details.
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.