Skip to main content

PR Box 14 W-2 Reporting

A
Written by Andy Temple
Updated over 3 weeks ago

W-2 reporting in Coins ERP+ Payroll can report on Box 14 information. The functionality is for the US Region only.

Import Box 14 Entries

The Import Box 14 Entries function (Payroll > Company Setup > W-2 Processing) allows you to upload the updated Box 14 amounts from a .csv file to the W-2 records in Payroll > Company Setup > W-2 Processing > W-2 File Maintenance.

To use the Import Box 14 Entries function correctly, you must include the following three fields in the .csv file: Employee Number, Box 14 Description, and Box 14 Amount (shown as columns A, B, and C in the sample below).

Box 14 Analysis Report

The Box 14 Analysis Report (Payroll > Company Setup > W-2 Processing) allows you to display Box 14 information, which can then be exported to an Excel spreadsheet to update W-2 values.

Once generated, the report appears as shown in the sample below.

Localities

The Localities function (Payroll > Global Setup > US Specifics) gives you the ability to exclude Localities from W-2 processing through the use of the Exclude From W-2 Processing column.

For example: COINS users who use a Locality Code to capture Oregon Transit Tax must exclude those Localities since they are not actual Localities and their values should not be represented as a Locality tax in Boxes 18, 19, and 20 on the Primary tab of the W-2 File Maintenance screen.

  • If this column is unchecked, the Create W-2 Batch process works as usual when creating W-2s for the Locality.

  • If this column is checked, the Create W-2 Batch process does not create a Locality W-2 record.
    ​For example: If the column was checked for the OR TRANSIT Locality, the W-2 record would only reference the State of Oregon (OR) and the Locality Boxes 18, 19, and 20 would be zero and disabled.

Did this answer your question?