Year-End is right around the corner, and my goal is to help you get your W2’s out the door on time!! I’d like to remind you about some COOL W-2 features, provide you with some basic information around how W-2's work in Microsoft Dynamics GP, as well as provide you the most Frequently Asked Questions we see in support. Enjoy!
What COOL features should you be aware of?
With the release of Microsoft Dynamics GP 2015 R2, Self-Service users can view and print their own W2s!! Click HERE to read more about this feature in US Payroll.
With the release of the 2015 Year End Update for GP 2015, users can control 'when' employee self-service users are able to access W2 information!! To enable this new feature, the 'Publish to Employee Self Service' field was added to the Print W-2 Forms window (Microsoft Dynamics GP >> Tools >> Routines >> Payroll >> Print W-2s):
With the release of Microsoft Dynamics GP 2016 R2, users can now print W-2's on blank paper!!!!!!!! YEAH!!
Where does the information in the W-2's come from?
When a year is closed in the Payroll module, Microsoft Dynamics GP populates the Payroll Year End Wage tables. The following tables are used to generate the Year-End Wage file to generate your W-2’s and W-3!!
Payroll Year End Wage Tables used to Generate W2 and W3 (Company Database)
Year End Header
Employee W2 amounts
Special amount information
State tax information
Local tax information
Other amount information
IF you need to make changes/edits to ensure W-2s are accurate after the year-end wage file has been created, you have a couple of options:
Option 1 - Manually Edit W-2's (most common):
Manually edit the W-2 via the Edit W-2 Information window (Microsoft Dynamics GP >> Tools >> Routines >> Payroll >> Edit W-2). *This is what most users do*:
Note: Changes made here will update the Payroll Year End Wage tables only, and are not reflected in any other tables in the Payroll module.
Note: If you remove the Year End Wage File for any year, ALL edits made manually via the Edit W-2 Information window are lost. This is because removing the year-end wage file removes data from all of the Payroll Year End Wage tables for the year in question.
Option 2 - Remove Year-End Wage File, Make Changes, and Recreate Year-End Wage File:
*Remember, if you choose this option any manual edits you've already made on your W-2's will be lost.
*Always make a backup of the databases prior to making any changes.*
1. Ensure No users are processing in Payroll system wide.
2. Remove the Year-End Wage file for the appropriate year (Microsoft Dynamics GP >> Tools >> Utilities >> Payroll >> Remove Year End Information).
3. 2016 Tax Tables recommended.
4. Make needed changes in Payroll (whether that's voiding checks, processing checks, fixing W-2 labels, processing manual checks, etc.)
5. Once you have verified all data is accurate, close the Payroll year again (2016 tax tables recommended).
6. Verify changes updated the Year-End Wage file and W-2's as desired.
7. Make another backup.
8. Re-install 2017 tax tables prior to any further processing in Payroll for the 2017 payroll year (Microsoft Dynamics GP >> Maintenance >> US Payroll Updates >> Check for Tax Updates).
Note: For the 2016 W-2 reporting year, the verification code is not required. Microsoft Dynamics GP will not produce the verification code for the 2016 year. This is something we will review in a future update as it is still optional at this point and only in a testing stage.
QUESTION 1: Deductions, benefits, and/or pay codes are doubled/tripled on my W-2’s! Why, and how can I fix this?
ANSWER 1: This happens when the ‘same’ W-2 label has been assigned to a particular pay code, benefit, or deduction more than once (you can assign up to 4 W-2 labels to each code). Please utilize the AWESOME blog Benefit, Deduction and/or Pay Code Amounts are Doubled on My W-2s to find and remove the problem duplicates so you can recreate your Year End Wage file with appropriate amounts!
QUESTION 2: Box 1 on the W-2 does not match Federal Wages in the Employee Summary window. Why, and how do I fix this?
ANSWER 2: It can be normal for Box 1 to differ from the Federal Wages in the Employee Summary window. All pay codes are added to ‘Gross’ under Cards >> Payroll >> Summary, even if the federal box is not marked on the pay code. However, most users do want these two values to match.
The calculation for Box 1 of the W-2 is as follows:
Gross Wages (from Employee Summary window) + YTD Benefits subject to Fed tax + Reported Tips + Charged Tips – YTD TSA Deductions
This is explained in more detail in the W-2 Data Source Document:
The only time a pay code is not added to ‘Gross’ is when the pay code is a ‘Business Expense’ pay type marked ‘not to be included as wages’.
It is very common for users to think pay codes not marked as subject to federal tax will not be included in Box 1. However, that is not the case. If you do not want a pay code amount to be included in box 1 you need to set it up as a business expense pay code pay type.
Most commonly, users will see amounts in this field updated with unexpected amounts when:
See KB 862929 for more information around what can cause unexpected federal wages differences, along with how to fix the problem.
QUESTION 3: Is Microsoft Dynamics GP going to make changes to accommodate Ohio requirements (locality + municipal code) around local tax labels on the W-2?
ANSWER 3: No, there were no changes made in Microsoft Dynamics GP. With that being said, you can certainly modify the Locality field in the Edit W-2 Local Tax Information window (Microsoft Dynamics GP >> Tools >> Routines >> Payroll >> Edit W-2s >> Local button). However, the Locality field is limited to 6 characters. If you require more than 6 characters to accurately reflect your Locality + Municipality, Greenshades does offer additional functionality around this.
We get a lot of questions, so rest assured I will keep updating the list as questions come in.
Assistance for W-2 and W-3 Questions associated with Payroll Year End Close
Microsoft Dynamics GP Blog - https://community.dynamics.com/product/gp/gptechnical/b/dynamicsgp/default.aspx
Microsoft Dynamics Community - https://community.dynamics.com/default.aspx
Microsoft Dynamics Support - https://mbs.microsoft.com/support/newstart.aspx
If you are creating a case with the Technical Support Team for assistance with W-2's and/or the W-3 related to Year End close for Payroll, please refer to the category selections below to ensure you are routed to the correct Support team for assistance:
--Support Topic Selection: Payroll
--Sub-topic Selection: Year End Procedures
W-2 and W-3 Resources:
Year-End Close Resources:
Please refer to the 2016 Year-End Blog Schedule to review current and upcoming blog posts and other helpful resource links related to Year-End Closing for Dynamics GP.
I hope this is helpful and that you have a successful Year-End!! If you have any feedback or suggestions, please let us know.
Have a wonderful Year-End!!!
Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP