SB Enterprise Help Center

W-2 Processing

Updated on

IRS information

  • General Instructions for W-2

    https://www.irs.gov/pub/irs-pdf/iw2w3.pdf

  • Accuwage

    https://www.ssa.gov/employer/accuwage/index.html

  • Springbrook does not give legal advice. Refer to the resources above to obtain specific code and reporting information.

Prepare for W2s - Balancing

Remember – IF the Payroll history is correct in the system W-2’s will process without any issues or modifications.

  • Complete 4th quarter reports.
  • Do any manual check adjustments to handle items like disability pay.Be certain the check dates and batch years are for the W2 year being reported.
  • Total the reported amounts for the year.
  • Run a deduction register (Totals only) for the year.
  • Check against W-2 proof list
  • Make sure the totals for FICA/FICAR and MEDI/MEDIR match.
  • MEDI will not match if there were employees that earned over $200,000.
  • FICA will not match if there were employees with disability pay (depending on plan).

W2 Process

  • Generate  Brings in employee information to the batch.
  • Exceptions  Optional step but will identify some errors that need to be fixed.
  • Edit  Optional step.  This is where you would change items if needed.
  • Proof List  Summary and Detail available. Used to balance.
  • W2  Prints the forms.
  • Export  Exports data to be uploaded to Accuwage. Optional step.
  • Commit  Sends data to Employee Self Service.

W2 Process - Generate

  • Select 2021 (proper year being reported).
  • Use Check Date.
  • Select desired sort for the W2s.
    • Department Then Name
    • Employee Number
    • Last Name
    • Social Security Number
  • Check the FICA maximum and change if necessary.
  • If California, check the SDI Max
  • Use Reporting Groups only if required.
  • Employer Name and Address come from System Setup.
  • Employer Type  Does not save in earlier versions.
    • Federal Government
    • Not Applicable
    • State or Local Government
    • State of Local Government tax exempt
    • Tax Exempt
  • NY: State wages = Federal wages on W-2 toggle  Used in NY. Forces the State Wages to equal the Federal wages regardless of history.
  • Mark Retirement Plan
    • Mark any deductions or benefits identifying employee is in a Retirement plan.
    • Checks box 13 on the W2.                                                                                                        
  • Fill in Box Numbers and Codes
  • 7.15+ will create second W2s if more information than will fit in boxes 12, 14 and 19

Tip – The down arrow can make entry easier in this section of the window.

Generate Notes

  • Generate settings are not saved from year to year.  
  • Local Taxes (boxes 18, 19, 20) on the W2 – Functionality has been added to print the description keyed in the code box if filled in. If blank the description will come from the deduction description (as room allows).
  • DON’T forget to toggle the Retirement Plan box for any deduction/benefit codes that should mark this box.
  • Reporting Groups - Used to report separate Employer tax ID numbers.  Not often used unless reporting multiple agencies separately.  IF USED – MAKE SURE TO CHECK THE EMPLOYEES IN THE REPORTING GROUP BEFORE GENERATING!

Exceptions

  • Exceptions were enhanced to include an exception if there are any negative totals brought into the process.  These will reject in Accuwage.
  • If a Name, SSN or other required information is missing the Exceptions step will warn.
  • No exceptions will stop the process.  Be sure to check for exceptions.

Edit Step

  • Do you need to edit anything?
  • Hopefully not any primary information.
  • Make sure the Retirement box checked before making any edits.
  • Change address information on the employee if possible.
  • To add a new W-2
    • Typically only necessary if an employee did not have regular wages but had disability pay for the entire year.
  • Best Practice:  Have W2 generated information match Payroll History.

Overflow W-2s

If an employee has more than 4 items in box 12 or more than 2 in box 19 a second page will be created.  This is being added for box 14.  Not available in all versions.

The Plus indicates the second W-2 record.

If one of the records is edited the second record must also be edited.

Proof List

  • Run Summary first. Then change from Summary to Detail to have the detail version saved with the batch.
  • Detail can be run for a single box that doesn’t balance to other reports.
  • Tip: Send detail to Excel as well as the deduction register (summary) or General Wage report. This can help you find errors on specific employees.
  • In order to save the detail, go back and run the detail for all boxes.
  • Only the last version run will be retained in the batch.

Balance W2 data to Payroll

  • Run a deduction register (Totals only) for the year by check date.
    • Be sure to Exclude Void on the report.
  • Check against W-2 Summary proof list.
    • Make sure the totals for FICA and FICAR match each other and between the reports.
    • If no employees exceed $200,000 , MEDI and MEDIR will match.
  • Balance wage totals (FED, STATE, FICA, MEDI) to the Quarterly Wage report for 4thquarter.
  • Use General Wage report or export (7.17+) to balance local wages.
    • Other has been added as a Subject Wages option to the General Wage report.

This step prints the W2 forms.

  • Employee Copies (B, 2, C)
  • Extra Copies (2, C, 2)
  • State Copies (1)
  • Employer Copies (D)

W2s print the entire form 3 to a page so no line-ups are needed.

Forms

  • Springbrook prints the entire front of the W-2  
  • 3 W2s to a page
  • Approved vendors – Some print on plain paper.
  • Order Forms from approved vendor  to insure line-up is correct.

Export

  • Springbrook does not create a printed W3.
  • All reporting is done electronically.
  • NOTE:  No record layout changes to the Federal file for 2020 reporting.

SSNVS – Social Security Number Verification Service

  • Checks employee names to SSNs.
  • Export available in Payroll > Utilities > SSNVS.
  • Exports a file that can be uploaded to BSO SSNVS for Social Security Number verification prior to sending W2s.

BSO – Business Services Online

  • Check now to make sure you can log In to BSO.
  • Add additional services (SSN checking) if needed.

        https://www.ssa.gov/bso/bsowelcome.htm

  • Accuwage – Used to upload the W2 file export.
  • Must log in to BSO to get to Accuwage Online.
  • Instructions on the page linked below.

        https://www.ssa.gov/employer/accuwage/index.html

Accuwage

FFCRA – Families First Coronavirus Response Act

IRS Notice 2020-54

New Menu option – Payroll > Utilities > Import W2 Updates

  • New utility has been added to import data into specific boxes on the generated W2.  Available in versions 7.15+.
  • Menu Security will need to be added to access the Utility.
  • Can only be used to import data into boxes 12, 14 and 19.
  • Box 12 – Currently has 4 available boxes.  Currently creates overflows
  • Box 14 – Currently has 3 available boxes.  Does not currently have overflow capability.
  • Box 19 – also fills boxes 18 (wages) and 20 (code). Currently creates overflows.

Import W2 information

  • Import will create an overflow W2 if the boxes are full.
  • Will NOT overwrite existing data in the boxes.
  • Export and combine the information that will be imported into the W2.
  • Use the Pay Type Register sent to excel (totals by employee) for Box 14 FFCRA data.
  • Use the General Wage Report (7.15 and 7.16) or the General Wage Export to get box 19 data.
  • Payroll > Utilities > Import W2 Updates window.  Information is imported to a W2 batch that has been generated.

Import W2 information – File Format

Import W2 information – Process

  • After the W2 Generate is completed, the import can be done.
  • The import process will create a job in the Job Viewer.
  • After the import completes the batch will reset to the Edit step for review.
    • If incorrect data is imported or imported twice the W2 batch will need to be regenerated and import again.
  • Result if there is a problem with the import.
    • Errors will display in the job viewer.
  • As long as the file imports (the fields and format are correct), any valid data will import to the W2s.
    • Invalid information will display in the job viewer.

Federal Tax Table Updates - Cloud ONLY

Menu Option > Payroll > Utilities > Federal Tax Table Update

Updated information for this process will be released in a cloud update after the final version of IRS Publication 15-T is available.

  • Available for Cloud databases only.
  • This option was created to simplify annual updates to Federal Tax Tables.  Each year Springbrook Enterprise will ship updated Federal Tax Table information for the next calendar year after it is published by the IRS.
    • The Update will add a new Revision to the tax tables dated 1/1/YYYY.
    • In some cases you may need to modify the revision date but only if your first pay period in the upcoming year ends prior to the check date that is in the new calendar year.
  • New menu item  Menu Security will need to be changed to access it.
  • Will NOT update State tax tables.
  • When the Year says 2022 (the next calendar year), the tables are available to update.
  • This window says 2021 which indicates the 2022 tax tables are not available yet.

Federal Tax Table Update

  • Select your tax table that matches the code in the window.  These are the codes and descriptions on your tax tables.
  • Click in the Filing Status box to display the down arrow to select the table with the update information.
  • Select each table to update.  You can do this in several steps if desired.
  • Available selections match Publication 15-T table information.
  • Standard indicates Box 2 is unchecked.
    • Single  Standard 2020 or later
    • Married Filing Jointly  Standard 2020 or later
    • Head of Household  Standard 2020 or later
    • Married Filing Separately Standard (same as single  Standard 2020 or later)
    • Single  Box 2 checked 2020 or later
    • Married Filing Jointly-Box 2 checked 2020 or later
    • Head of Household-Box 2 checked 2020 or later
    • Married Filing Separately  Box 2 checked (same as Single-Box 2 checked) 2020 or later
    • Married  2019 or prior
    • Single  2019 or prior
  • Save changes.
  • If any table(s) have a current revision with the date 1/1/YYYY  there will be an error.
  • The revision date can be changed or deleted to resolve.  
  • Change the error line to blank to save the rest, then check the others to resolve the issue(s).
Previous Article 1099 NEC Preparation
Next Article Springbrook Enterprise - 1099 NEC
Still Need Help? Contact Us