What formulas are commonly used on a W-2 or T4 Slip?

Common formulas used on a W-2 or T4

The following formulas are commonly used on W-2s or T4s to combine more than one tax, pay, fringe, or deduction in a single box:
Notes:

For details on how to create a new formula, select the link below.
You must modify these formulas to match your company tax or pay IDs.
To use a formula on W-2s, it must have PR Employee as the driving record and be a Public Formula.
If you print W-2s based on prior year amounts, you must modify these formulas to reflect prior year totals. Select the link below for details on how to create a prior year W-2 formula.
In the Formula examples below, select fields from records where appropriate instead of typing the field and record names. For example, in "LOOKUP (YTD Deductions [PR Employee Deduct]...", YTD Deduction is a field you select from the PR Employee Deduct record. For assistance with creating formulas, refer to the "How to create a formula" attachment below or read Help topics about formulas.

Formula ID

Formula

Notes

YTD Deduction

Prior YTD Deduction

LOOKUP (YTD Deduction [PR Employee Deduct], Employee [PR Employee], "401K" ) + LOOKUP (YTD Deduction [PR Employee Deduct], Employee [PR Employee], "401K2" )

LOOKUP (Prior Year Deduction [PR Employee Deduct], Employee [PR Employee], "401K" ) + LOOKUP (Prior Year Deduction [PR Employee Deduct], Employee [PR Employee], "401K2" )

In this example, "401K" and "401K2" are the actual deduction IDs.
There is a limit to the number of LOOKUP statements that can be nested in one formula. If you have more than 20 local taxes to combine, you must use more than one formula.

YTD Fringe

Prior Fringe

LOOKUP (YTD Fringe [PR Employee Fringe], Employee [PR Employee], "401KM" ) + LOOKUP (YTD Fringe [PR Employee Fringe], Employee [PR Employee], "401K2m" )

LOOKUP (Prior Year Fringe [PR Employee Fringe], Employee [PR Employee], "401KM" ) + LOOKUP (Prior Year Fringe [PR Employee Fringe], Employee [PR Employee], "401K2m" )

In this example, "401K" and "401K2" are the actual fringe IDs.
There is a limit to the number of LOOKUP statements that can be nested in one formula. If you have more than 20 locals taxes to combine, you must use more than one formula.

YTD Earnings

Prior YTD Earnings

LOOKUP (YTD Pay [PR Employee Pay], Employee [PR Employee], 3, "BONUS" ) + LOOKUP (YTD Pay [PR Employee Pay], Employee [PR Employee], 3, "BONUS2" )

LOOKUP (Prior Year Pay [PR Employee Pay], Employee [PR Employee], 3, "BONUS" ) + LOOKUP (Prior Year Pay [PR Employee Pay], Employee [PR Employee], 3, "BONUS2" )

In this example, "BONUS" and "BONUS2" are the actual pay IDs.
The 3 in the formula represents the pay type (1 = REG, 2 = OT, 3 = OTH, 4 = REM, 5 = ACC).