Populate Box 14 in Sage 100 W-2 Preparer Grid

Access the W‑2 preparer grid

Open Payroll, Period End, Federal and State Tax Reporting.
Select Federal then choose Form Name YEAR W‑2/W‑3 from the list.
Verify the correct tax year.
Select all employees, then click Proceed.
Complete the W‑2 Wizard until the W2/1099 Preparer grid opens.

Understand how Box 14 populates automatically

Earnings and deductions setup

Sage 100 uses settings in Earnings Code Maintenance and Deduction Code Maintenance.
These settings control which values appear in Box 14.

Tax calculation and mapping

Sage 100 calculates taxes using the Company Tax Group and the employee Tax Profile.
The system updates the values in the Employee Tax Summary, then maps them to Box 14.

Tax codes follow Sage 100 programming and populate the preparer grid automatically.

Work with multiple Box 14 columns

The grid can display multiple Box 14 columns for earnings, deductions or taxes.
Descriptions come from Earnings Codes, Deduction Codes or Tax Code settings.

Rename a Box 14 description

Right‑click the Box 14 column.
Select Rename.
Choose a predefined description or select Other.
Enter the description that prints on the W‑2.
Click OK.

Duplicate descriptions combine into a single entry with merged amounts. [Writing St...Agent.docx | Word]

Note: Box 14 descriptions support up to 10 characters.

Manually add amounts to Box 14

Insert a new Box 14 column

In the preparer grid, right‑click the top green row.
Select Insert.
Enter a column name.
In column setup, select Box 14.

Define the Box 14 description

In the Name Column‑Box 14 window, enter the W‑2 description.
Click OK.

Note: The description supports up to 8 characters.

Enter employee amounts

Enter dollar amounts for each employee directly in the column.

Complete the process

Finish all steps in the W2/1099 Preparer to finalize W‑2 forms.

CAUTION: