W-2 & Calendar Year-End Processing

1. W-2 & Calendar Year-End Processing AASBO CONFERENCE BREAKOUT SESSION Vivian Lovorn – Homewood City Board of Education September 19, 2016

2. Agenda • 3. Process • W2 Adjustments • Adjustment List • Generate Error Listing and Summary • Testing the file • W2 Report • Printing W2’s • Single W2 or Restarting W2’s • 4. Preparing for 2017 Payroll Processing • Update Federal Tax Tables • Reset Deduction Limits and Total Deducted • Calendar Year End Initialization • Deadlines • Electronic Reporting to SSA • Electronic Reporting to Alabama Department of Revenue • Preparation • Update your SSA Business Services Online (BSO) user information and change your password. • Download Accuwage • Download or Print Publication 15 from www.irs.gov • Verify W2 codes, Fringe benefits and DeductionsPayroll • Payroll Verification Report • Run Quarterly reports g) Thoughts on Balancing

3. Deadlines Electronic filing of W-2 data to the Social Security Administration and to the Alabama State Department of Revenue is now due on January 31st of each year.

4. Preparation

5. BSO User Id/Password Update Go to the website: www.ssa.gov/bso/bsowelcome.htm Select “Register” to create a new Business Services Online (BSO) user id. Select “Log In” to update your information and change your password. Passwords for existing user ids expire after 90 days.

6. Download Accuwage from SSA Go to the website: http://www.ssa.gov/employer/accuwage Click on: Download AccuWage – 2016 Tax Year

7. Download Accuwage from SSA A screen will appear and you will need to confirm that you want to install AccuWage.

8. Print or Download Pub 15 Go to the website: www.irs.gov Select “Pub 15”. When the publication opens, verify that it references “For Use in 2017”

9. Verify W2 Codes Payroll Setup, Payroll Code Maintenance. I, Tab 1. W2-Codes • Verify that all W2 codes are setup. • Harris School Solutions annual Calendar Year-End Memo has provided all districts with the most up to date list of W2 codes. You should use that list to ensure that your parameter file is accurate. • Additional notes have also been provided in the Year-End Memo. Please be sure to review their notes and suggestions for changes you may need to make.

10. W2 Codes Report PR Setup, PR Parameter Report, Payroll Validation Code Report Check W2 Code Category Generates a report with all the W2 codes and related information. Make corrections in PR Maint 1, Tab 1

11. Verify Fringe Benefit Codes Payroll Code Maintenance II, Tab 6 Benefits should include, but are not limited to: L – Life Insurance W2 Code 5 M – Miscellaneous V - Vehicle

12. Verify Deductions and their W2 codes PR Setup, Deduction Master Maintenance The above deduction will print CAF in Box 14 of the W2 because it’s W2 code is 1 which is a Section 125 (Cafeteria Plan). The deduction above has a W2 code of R which tells Nextgen to print “RET” in Box 14 of the W2 form.

13. Payroll Verification Report Under Calendar YE Procedures, run the Payroll Verification Report for each quarter. This report compares employees check details to the QTD Earning tables. If check records are different from quarterly records, it will show up here. Check the employee you wish to update, and press the save button. Some items you will not want to update. Investigate the differences first. You only want to update if Check Records are correct.

14. Run Quarterly Reports Run the Quarter/YTD Report (Print Grand Totals Only option) for all quarters to balance the W2 data.

15. Thoughts on Balancing • Each quarter, balance your tax deposits for Federal, State, Social Security and Medicare to the amount shown on the Quarter YTD report • Each quarter, re-run the Quarter/YTD Report (Grand Totals Only option) for each prior quarters. Verify that there are no changes in the amounts from the prior quarter(s). • Manually calculate each taxable wage (Federal, State, Social Security and Medicare) to ensure that deductions are proper set up for sheltering and for reporting on the W2. • After verifying your deposits and verifying your taxable wages, print the other quarterly reports and balance these to your Quarter YTD totals.

16. Process

17. The Menu

18. W2 Table Maintenance The Retirement Systems of Alabama provides to all school districts a file containing the IRS required “Employer Sponsored Health Coverage Cost” which must be reported on each employee’s W-2. You will use this transaction to import the data in this file each year as part of your W2 preparation. Click on the button labeled: “Import TTRS Amounts”. Browse to the location where the file from RSA has been downloaded. Select the file. Enter the tax year (2016) for the Adjustments. This transaction may also be used to import reportable Health Coverage Costs from providers other than RSA using the Import Employer Paid Benefits button.

19. W2 Table Maintenance In addition to importing the data from RSA, you may use this transaction to enter employee wage, withholding or benefit adjustments (including extra fringe benefits) for boxes 11, 12, and 14 on the W2 form. Also used for adjustment to YTD wages, withholdings, or benefits as needed. Note: SS# must contain dashes

20. W2 Adjustment Report Used to verify adjustments that were entered in the W2 Table Maintenance

21. Generate W2 Data The W2 Generate combines all the adjustments that were imported and entered along with the employee’s yearly payroll data to output a file for storing and printing W-2 information • Pin number is issued by SSA. It is needed to print on the magnetic media file to identify site. • Check the “Submitting Magnetic Media to State”. Selecting this option will cause the program to generate the records required by the Alabama State Department of Revenue. • BROWSE to the drive where you need to save the file and enter the file name • Press Enter (F1) to create the to create W2 file and the error listing. • **Note that checking the “ReGenerate Magnetic Media Only” will only create a new magnetic media file, but it will not regenerate the data in the workfile.

22. Generate Error Listing • Nextgen will now allow W2’s to be processed without an address in an employee’s maintenance. • RED warnings will be rejected by the SSA. These will usually include negative amounts. If those employees are to be included, corrections must be made through the W2 Maintenance Table. • Any Unchecked SSN’s will be excluded from the W2 file. • Carefully review any errors you receive. It is likely you will need to make corrections and regenerate the file. However, there may be circumstances where this would not be the case.

23. Summary W2 Data • Print this page for your records. • Data should be compared with the 941 report or QYTD reports and the amounts imported or entered through the W2 Table Maintenance. Any time adjustments are added or check records are effected by changes the generate MUST be run again to include the new information.

24. Test the Magnetic Media File Run the Magnetic Media File through the AccuWage2016. This software will identify any errors in the file generated by Nextgen. Note: AccuWage must be downloaded each year to perform required edits for the new calendar year. Be sure you are using AccuWage 2016. • “Start Testing” button will prompt you to find the Magnetic Media file that was generated. • Once you “open”, it will scan the file and produce an error report. • Errors must be corrected before you can send the file to the SSA. • Once the corrections are made in Nextgen you MUST Generateagain.

25. Print W2 Report Note: Magnetic Media File should be tested before running report. If corrections were made, file had to be generated again. Reports employee wage, withholding and benefit information that is recorded in the W2Report export file. Alabama districts will have both the RW and RS records since we are to submit electronically to the State.

26. W2 Printing • Harris School Solutions provides three different methods for printing W2 forms at your district. The options are: • Printing forms through the NextGen Payroll System • Printing forms through Harris School Solutions Document Services application • Printing forms through SoftDocs Doc e Serve application. • In addition, Harris School Solutions also offers a service through which they will printing the W2 forms for your district. • Please refer to the Harris School Solutions Calendar Year End Memo for specific instructions regarding printing since these instructions will vary depending on your choice for how your will print the forms.

27. Submit file to Social Security Administration • Electronically upload the file to the Social Security using the AccuWage System. • In addition, upload the W2REPORT file to the Alabama Department of Revenue. This is done through the same website where you make your monthly Alabama tax payments.

28. Preparing for 2017 Payroll Processing

29. Reset Deduction Limits and Total Deducted Enter your Social Security Deduction number. Then select Total Deducted. You will ignore the Old Amount and set everyone to $0.00. You will also reset the Limit if the IRS Social Security Wage base changes for 2017. Please refer to Pub 15 and the Harris School Solutions Calendar Year End Memo for this information. Use this transaction for resetting you limits and total deduction amount on tax sheltered annuities as well. This transaction can be run either before or after W2 processing, but MUST be run before any payroll for the new calendar year is computed. Each calendar year, you must reset the Social Security Total Deducted back to zero. To do this go to Mass Change Deduction under Employee Maintenance.

30. Calendar Year End Initialization This transaction creates new deduction quarterly total records, fringe benefit quarterly total records and earnings records for all employees. You will enter the NEW Calendar Year 2017 You may get a message that information already exists in the new years tables and it will not be updated. You should click YES to continue. Usually it is because you have already added a new person in the new Cal Year. This transaction can be run either before or after W2 processing, but MUST be run before any payroll for the new calendar year is computed.

31. Update Federal Tax Tables This transaction updates the Federal Tax Table and the Annual Federal Exemption amount. As part of the calendar year end program update, Harris School Solutions provides a file to all districts with the new values. However, you should double check the accuracy of the tables and the Federal Exemption Amount from the Circular E-Pub 15 on the IRS website. When running this transaction, you will select the two boxes shown and click F1 (Enter) to import the new tax information. This transaction can be run either before or after W2 processing, but MUST be run before any payroll for the new calendar year is computed.