Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This checklist outlines the steps This checklist outlines the steps to be taken to close USPS for the calendar year-end in the Redesign.

...

Panel
bgColorYellow

NWOCA W2 Printing Deadline

Friday, January 24, 2025

Info

W2 Reprints are $5.00 each plus postage.

Preliminary Calendar Year-End Closing

The following

Table of Contents
maxLevel1
minLevel1
include
outlinefalse
indent
excludeFriday|NWOCA
styledisc
typelist
printabletrue
class

Preliminary Calendar Year-End Closing

The following pre-closing steps can be completed any time prior to or during the processing of the last payroll of the calendar year.

  •  1.  W2 SSN Verification
  • Go to Reports>W2 SSN Verification>Create Reports/W2 SSN Verification/Create Submission File and click Generate Submission File.

  • Send this file to SSA for Verification.

  • Once file is received back from SSA and saved somewhere on your computer, go to Reports>W2 SSN Verification>Results Reports/W2 SSN Verification/Results Report.

    • Report Title = W2 SSN Verification Results (can be changed if desired).

    • Report Format = PDF or CSV.

    • Sort By = Employee SSN or Employee Name.

    • Click on 'Choose File' and browse to locate your file.

    • Click on ‘Generate W2 SSN Verification Results Report.’

    • Review the report for errors.

  •  2. Life Insurance: Process any Life Insurance Premium (NC1 payments in Classic) payments.
Warning

If the Life Insurance Premium Pay Type was NOT USED prior to the last pay of the calendar year, the Life Insurance (NC1) payment amount must be entered under the Core/Adjustment Journal in order for the Life Insurance amount to show correctly on the W2 form and to insure that the Quarter balances.  The W2 Report will automatically adjust the Federal, State, City, Medicare, etc. gross and taxable gross amounts. No manual adjustments are needed for the Gross and Taxable Gross amounts, however the Medicare withholding must be paid.  Create the adjustments for the Medicare payroll item(s).

The Board will need to pay for both Employee and Employer portion of Medicare and the employee can reimburse the district. 

The software provides the ability to withhold city tax on non-cash earnings. This can be activated by checking the "Tax Non Cash Earn" field on the city tax record in the Core/Payroll Item Configuration program. City taxes may also need to be paid if the employee is not a resident of the city where the tax is deducted.

  •  

...

  • 3Adoption Assistance: Process any Adoption Assistance (NC2 payments in Classic) payments.

...

  • Before or during your last pay of the calendar year, run the adoption assistance pay types for adoption assistance

...

  • Go to Payroll/ Payroll Payments - Future or Current

    • Click Create

    • If using Current, select the payroll being processed
    • Enter the employee
    • Select the position
    • Continue

      Employee = Select the appropriate employee.

    • Compensation = Select the appropriate compensation. 

    • Description = Enter if desired.

    • Pay Type = Adoption Assistance.

    • Unit

      Units = 1.

    • Rate = Amount of adoption assistance needing to be reported on the employee's W2.

    • Click Save.

  •  34Reimbursable Employee ExpensesNon-Cash Taxable Benefits: Process any Reimbursable Employee Expenses Non-Cash Taxable Benefits (NC3 payments in Classic) payments.  See the document called Reimbursable Employee Expenses for   See the document called Non-Cash Taxable Benefits for further information.
  •  45. Legal Name Field is used on W2s if populated: Check to make sure Legal Names entered in the Legal Name fields are accurate and should still be used for W2 Reporting.
  • Go to Core/Employee

    • Add all Legal Name fields to grid using the More button.  Legal Name option is located at bottom of More options.

    • Use filter a..z in each field, i.e. Last Name, First Name, Middle Name, Suffix to see if any names exist. 

    • Verify names if populated.

  •  56OSDI W2 Abbreviations: Verify the W2 abbreviation field on all OSDI records.  The OSDI The OSDI code needs to be listed first (required), followed by any description.  Click here for  for a complete list of OSDI codes.
  • Go to Core/Payroll Item Configuration

    • Filter the grid by entering OSDI in the Type field

    • Review the 'W2 abbreviation' column to verify the codes are accurate.

    • The OSDI code should also be listed on the OSDI Code field in the payroll item configuration.

  •  67. City W2 City W2 Abbreviations:  Verify  Verify the W2 abbreviation field on all City records. The first six characters will be printed on the employee's W-2. If left blank, the value in the abbreviation field will print.
  • Go to

...

  • Core/Payroll Item Configuration

    • Filter the grid by entering City Tax in the Type field

    • Review the 'W2 abbreviation' column to verify there is a value in the W2 abbreviation field.

Info

Indiana

...

 requirements include: A Payroll Item Configuration City Tax record for the county tax record and a Payee address with IN as the state. The Payroll Item record for your employees for Indiana County tax will need to have a Deduction Type of “R” for Residence and the Indiana code from the Indiana W2 Instructions, Appendix A. The Indiana Code will need to be put in the Payroll Item Code 1 field.

The codes are currently 01 – 92. If using 1 – 9, it must be entered as 01, 02, 03, 04, 05, 06, 07, 08, 09.  

The website for the County Codes is below, Page 12: 

EFW2 (W-2 and WH-3) Electronic Filing Requirements

  •  78. City Tax Entity Codes: For all cities not included in your CCA or RITA files, you will add the Entity Code on the payroll item configuration screen.  For those filing electronically, verify that the Tax Entity Code for the city is entered if this city requires a specific code.  If filing by paper copy, enter the first 5 letters of the city name.  This code allows you to create a submission file or print file for  each for each specific city.
  • Go to Core/Payroll Item Configuration

    • Filter the grid by entering city in the Type field

    • View each city not being reported through CCA or RITA 

    • Verify the appropriate code is entered in the Tax Entity Code

...

    • field ​

Warning

The information cannot be filed electronically or printed as a paper copy, unless the entity code is present.

  •  89. RITA City Taxes: For any city reporting to RITA, verify the following:

...

https://www.ritaohio.com/TaxRatesTable

  • Verify the RITA Code and Description are entered.  

    • Go to Core/Payroll Item Configuration

    • Filter the grid by entering City in the Type field.

    • Verify the appropriate RITA assigned code is entered in the RITA field and the appropriate RITA assigned description is entered in the RITA Description field

    • For the employees having the City tax withheld, verify their Payroll Item Deduction Type field is marked as Employment or Residence.

      • Go to Core/Payroll Item.

      • Select City under the Select Payroll item dropdown.

      • Verify the Deduction Type is set to Employment or Residence.

  •  910CCA City Taxes: For any city reporting to CCA, verify the following:

http://ccatax.ci.cleveland.oh.us/?p=mmspec

  • On the Core/

    Verify the CCA assigned code, CCA Description, and Report to CCA checkbox.

    • Got to Core/Payroll Item Configuration City record(s) verify .

      • Filter the grid by entering City in the Type field.

      • Verify the CCA assigned code is entered in the CCA field, the CCA assigned description is entered in the CCA Description, and the Report

      to
      • To CCA check box is checked.

      • Any district that reports to the CCA must also make sure that they review the Appendices that the CCA has published.  City codes MUST be in for cities on these lists, regardless if they are a CCA city or not.  These cities get reported in the file that is sent to CCA and must be coded.  

    • Go to Appendix A, B, or C to check for the correct assigned code http://ccatax.ci.cleveland.oh.us/forms/submitproc2023dataformat2023.pdf  

      • If CCA city is in Appendix A, they need the following in Payroll Item Configuration for CCA: Valid CCA code, valid CCA city name, and box checked on "Report to CCA".

      • If any city is not in Appendix A but in Appendix B, Payroll Item Configuration should be: Valid CCA code, valid CCA city name, and box UNchecked Unchecked on "Report to CCA".

      • If any city is not in Appendix A, B, or C, Payroll Item Configuration should be: Valid CCA code left blank, valid CCA city name*, and box UNchecked Unchecked on "Report to CCA". 

        • *The valid CCA city name should be entered based on the name found in the Ohio Municipal Income Tax Rate Table found at (aka The Finder):  

https://thefinder.tax.ohio.gov/StreamlineSalesTaxWeb/Download/MuniRateTableInstructions.aspx

  • REQUIREDFor the employees having the CCA or any other city tax withheld, verify their Payroll Item Deduction Type field is marked as Employment or Residence.

    • Go to Core/Payroll Item.

      • Select City under the Select Payroll Item dropdown

      • Verify the Deduction Type is set to Employment or Residence.

  • REQUIRED Verify employee's addresses to make sure you are following the guidelines set up by the US Postal Service in Publication 28:    https://pe.usps.com/cpim/ftp/pubs/pub28/pub28.pdf

  •  1011. Other State: Verify Other State IDinformation is complete and accurate.
  • Go to

...

  • Core/Payroll Item Configuration

    • Filter the grid by entering 'State Tax' in the Type field 

    • View each State Payroll Item

    • Verify the State ID field is filled in and correct.

  •  1112. HSA: Verify any Payroll Items being used for HSA purposes have the Annuity Type field set to Other.
  • Go to Core/Payroll Item Configuration

    • Filter the grid by entering 'health' in the Type field

    • View the HSA record 

    • Verify the Annuity Type is set to Other

Info

This amount will be placed in Box 12 with code W.

  •  1213. W2 Configuration: Verify all information is complete.
  • Go to System/Configuration/W2

...

  • configuration.

    • Verify the 'District will Submit Own W2s Files' is CHECKED

    • District has option to check box for: "Include only last 4 digits of employee's SSN on W-2 forms and XML".

    • Verify Company Information is accurate.

    • Verify or complete all information under Contact Information.

    • Verify or complete all information in the Submitter Information.

    • Click the box for "Submitter Name and Address same as Company".

    • Save.

Warning
  • The Submitter EIN is the Federal ID used when registering with Social Security Administration-Business Services Online (SSA-BSO)

  • The Submitter User Id is the unique Id assigned when registering with the Social Security Administration-Business Services Online (SSA-BSO)

...

A complete Quarter-End Checklist can be found by clicking here.

  • Go to Reports/ODJFS Reporting/ODJFS Report

    • Choose the 4th Quarter and Generate the Report.

    • Check all totals carefully for accuracy. 

    • If necessary, adjustment can be made using the Core/Adjustments screen.

  • When all data is correct, go to

...

  • Reports/ODJFS Report, click on the Generate Submission File option.

  • Upload the ODJFS_YY_QQ.TXT file to The Source (Ohio Department of Job and Family Services)

  • Select ICESA as the file type.

Note

In order to upload the file you must have an account with The Source. To register for an account if you do not already have one click here.

  •  1415. Quarter Report:
  • Go to Reports/Quarter Report

    • Year- Should be defaulted to current year

    • Quarter-Should be defaulted to current quarter (4th)

    • Sort By- Choose sorting option from drop down

    • Click Generate Report         

Note

In the "Totals Summary" section of the Quarter Report, the gross and adjusted gross should balance using a manual calculation.

                      Gross

                    ‾ Annuities

                    Calculated Adjusted Gross

  •  1516. Verify Payables Balance.
  • Payee checks and electronic payments for the quarter should equal the total Payroll Items showing on the Quarter Report. 

Tip

Be sure to verify the electronic transfers of Federal and Medicare payments as well. This should be true for every Payroll Item code.

  •  1617. Verify Gross Balances.
  • The total gross showing on Quarter Report should equal the total of all Payroll Disbursement Checks created during Payroll Posting to USAS for the quarter.

  •  1718. Print Quarter Report (Optional).
  • Once balanced if a hard copy of the report is desired print the Quarter Report.

  •  1819W2 Balancing: It is recommended that you balance the W2Report quarterly to minimize problems at calendar year-end.
    •  Balance W2 Report and Submission.

    Go to Reports/ W2Reports/W2 Report and Submission. 

    • Output type should be set to Report.

    • Check the report for Employee with Errors only Checkbox.

    • Verify report.

    • Run Again unchecking the Report Employees with errors only.

    • Verify and balance report

    • Balance W2 Report and Submission.

  •  

    Complete and balance the W2Report Reconciliation Worksheet for the quarter following the directions on the worksheet.

     

  • Balance the Payroll Item totals (taxes and annuities) on the W2Report with the totals from the Payables Reports from the quarter.

     

  • Balance the gross amounts on the W2Report with Pay Reports for the quarter.

Tip

Federal Total Gross on W2 Report minus Insurance minus Medicare Pickup = Quarter

...

Report/Totals Summary/YTD Total Gross 

Warning

These amounts may not balance due to the way W2Report handles certain amounts (e.g. Medicare pickup.)

Note

If errors are discovered, check employees that had exception processing during the quarter such as voided checks, error adjustments, or manual changes made through Core/Adjustments. 

The Audit Report (Reports/Audit Report Report) can be useful in identifying these problems.

  • Start Date- Enter a start date you wish to begin your audit from.        

  • End Date- Enter an end date you wish to process the report through.

  • Select Specific Objects, or leave all in Available box to run for all Objects

  • Select Specific Users, or leave all in Available box to run for all Users.

  • Select Operation

    • Added

    • Modified

    • Deleted

    • All

  • Select Sort Option

    • Date

    • Username

  • Click Generate Report

  •  1920. Payable Balancing:  Verify all Payables have been processed to date and correct amount paid.
  • Go to Processing/Outstanding Payables and verify that there are no outstanding Payroll Items. (Screen should be empty)

  • The total of all Employer Distribution amounts (if tracked on the system) should equal the total of all USAS accounts payable checks to the vendor or deduction company.

  • For City Withholdings, take the total gross times the percentage to be sure the tax withheld and submitted are correct.

Tip

Mobile employees could cause discrepancies

  •  2021. Complete and File Required Quarter-End Submission Forms.
  •  2122OAPSE Report-Required  (unless you do not have OAPSE dues)This report will gather needed YTD information for your OAPSE Dues that will be requested after December is closed.
  • Go to Home or Reports/Report Manager

    • Select Generate

    • Format -Excel Data

    • Query Options - Enter your OAPSE Payroll Item code(s)

    • Click Generate Report

    • Review data for accuracy and requirements from OAPSE

    • Save in your files for reporting of Annual Wages to OAPSE.

Expand
titleDownload instructions for the OAPSE Report.rpd-json

If you need the OAPSE report definition on your 

  • Go to the Report Repository found on NWOCA’s Redesign Wiki.

  • Click OAPSE Report.rpd-json to download to your PC

  • In Redesign, go to Reports/Reports Manager.

  • Click Import Report.

  • Browse to locate OAPSE Report.rpd-json

  • Save the report to your Report Manager.

  •  2223. Print Quarter End Reports (Optional)
    •  Only if hard copies of quarter end reports are desired, run the following:
      • Reports/Employee Master (all data)
      • Reports/Employee Earnings Register

...

  • .
Warning

STOP:

If you need to begin January payroll processing BEFORE completing W2 processing, leave do the following:

  • Leave the December posting period OPEN (December does NOT have to be Current for W2 Processing)

and create your January posting period. (
  • .

  • Go to Core/Posting Period

) and make January CURRENT. You may then process your January Payroll. When you
  • , click Create.

    • Calendar Month = January

    • Calendar Year = YYYY

    • Current = Mark the checkbox to make the January posting period CURRENT.

    • Click Create

  • Verify the banner in the upper right hand corner states January YYYY.

  • Process your January Payroll. 

When you are ready to process your W2s, you may do so at any time beginning with Step 2224.

...

W2 Processing Final Checking and Adjustments

...

Steps 24-32 in the W2 Processing section below are a repeat of Steps 5-13 in the Preliminary Calendar Year End Closing section of the checklist.  If Steps 5-13 were not already completed, please assure Steps 24-32 are completed now, otherwise you can skip to Step 33.

  •  24. Legal Name Field is used on W2s if populated: Check to make sure Legal Names entered in the Legal Name fields are accurate and should still be used for W2 Reporting.
  • Go to Core/Employee

    • Add all Legal Name fields to grid using the More button.  Legal Name option is located at bottom of More options.

    • Use filter a..z in each field, i.e. Last Name, First Name, Middle Name, Suffix to see if any names exist. 

    • Verify names if populated.

  •  2425.  OSDI W2 Abbreviations: Verify the W2 abbreviation field on all OSDI records.  The OSDI The OSDI code needs to be listed first (required), followed by any description.  Click Click here for a complete list of OSDI codes.
  • Go to Core/Payroll Item Configuration

    • Filter the grid by entering OSDI in the Type field

    • Review the

...

    • 'W2 abbreviation' column to verify the codes are accurate.

...

    • The OSDI code should also be listed on the OSDI Code field in the payroll item configuration.

  •  26. City W2 Abbreviations:  Verify the W2 abbreviation field on all City records. The first eight six characters will be printed on the employee's W-2. If left blank, the value in the abbreviation field will print.
  • Go to

...

  • Core/Payroll Item Configuration

    • Filter the grid by entering City Tax in the Type field

    • Review the 'W2 abbreviation' column to verify there is a value in the W2 abbreviation field.

...

  •  
    • Go to Core/Payroll Item Configuration

      • Filter the grid by entering city in the Type field

      • View each city not being reported through CCA or RITA 

      • Verify the appropriate code is entered in the Tax Entity Code field 

Warning

The information cannot be filed electronically or printed as a paper copy, unless the entity code is present.

  •  27. RITA City Taxes: For any city reporting to RITA, verify the following:
Info

https://www.ritaohio.com/TaxRatesTable

    • Verify the RITA Code and Description are entered.  

Info

Indiana requirements include: A Payroll Item Configuration City Tax record for the county tax record and a Payee address with IN as the state. The Payroll Item record for your employees for Indiana County tax will need to have a Deduction Type of “R” for Residence and the Indiana code from the Indiana W2 Instructions, Appendix A. The Indiana Code will need to be put in the Payroll Item Code 1 field.

The codes are currently 01 – 92. If using 1 – 9, it must be entered as 01, 02, 03, 04, 05, 06, 07, 08, 09.  

The website for the County Codes is below, Page 12: 

EFW2 (W-2 and WH-3) Electronic Filing Requirements

  •  27. City Tax Entity Codes: For all cities not included in your CCA or RITA files, you will add the Entity Code on the payroll item configuration screen.  For those filing electronically, verify that the Tax Entity Code is entered if this city requires a specific code.  If filing by paper copy, enter the first 5 letters of the city name.  This code allows you to create a submission file or print file for each specific city.
  • Go to Core/Payroll Item Configuration

    • Filter the grid by entering

      City

      city in the Type field

      .

    • View each city not being reported through CCA or RITA 

    • Verify the appropriate

      RITA assigned

      code is entered in the

      RITA field and the appropriate RITA assigned description is entered in the RITA Description field

      For the Tax Entity Code field ​

Warning

The information cannot be filed electronically or printed as a paper copy, unless the entity code is present.

  •  28. RITA City Taxes: For any city reporting to RITA, verify the following:

https://www.ritaohio.com/TaxRatesTable

  • Verify the RITA Code and Description are entered.  

    • Go to Core/Payroll Item Configuration

    • Filter the grid by entering City in the Type field.

    • Verify the appropriate RITA assigned code is entered in the RITA field and the appropriate RITA assigned description is entered in the RITA Description field

    • For the employees having the City tax withheld, verify their Payroll Item Deduction Type field is marked as Employment or Residence.

      • Go to Core/Payroll Item.

      • Select City under the Select Payroll item dropdown.

      • Verify the Deduction Type is set to Employment or Residence.

  •  2829CCA City Taxes: For any city reporting to CCA, verify the following:

 http://ccatax.ci.cleveland.oh.us/?p=mmspec

  • On the

    Verify the CCA assigned code, CCA Description, and Report to CCA checkbox.

    • Got to Core/Payroll Item Configuration City record(s) verify .

      • Filter the grid by entering City in the Type field.

      • Verify the CCA assigned code is entered in the CCA field, the CCA assigned description is entered in the CCA Description, and the Report

      to
      • To CCA check box is checked.

      • Any district that reports to the CCA must also make sure that they review the Appendices that the CCA has published.  City codes MUST be in for cities on these lists, regardless if they are a CCA city or not.  These cities get reported in the file that is sent to CCA and must be coded.  

    • Go to Appendix A, B, or C to check for the correct assigned code code http://ccatax.ci.cleveland.oh.us/forms/submitproc2023dataformat2023.pdf  

      • If CCA city is in Appendix A, they need the following in Payroll Item Configuration for CCA: Valid CCA code, valid CCA city name, and box checked on "Report to CCA".

      • If any city is not in Appendix A but in Appendix B, Payroll Item Configuration should be: Valid CCA code, valid CCA city name, and box UNchecked Unchecked on "Report to CCA".

      • If any city is not in Appendix A, B, or C, Payroll Item Configuration should be: Valid CCA code left blank, valid CCA city name*, and box UNchecked Unchecked on "Report to CCA". 

        • *The valid CCA city name should be entered based on the name found in the Ohio Municipal Income Tax Rate Table found at (aka The Finder):    

https://thefinder.tax.ohio.gov/StreamlineSalesTaxWeb/Download/MuniRateTableInstructions.aspx

  • REQUIRED

     

    For the employees having the CCA or any other city tax withheld, verify their Payroll Item Deduction Type field is marked as Employment or Residence.

    • Go to Core/Payroll Item.

      • Select City under the Select Payroll Item dropdown

      • Verify the Deduction Type is set to Employment or Residence.

  • REQUIRED Verify employee's addresses to make sure you are following the guidelines set up by the US Postal Service in

    Publication 

    Publication 28:   

      

    https://pe.usps.com/cpim/ftp/pubs/pub28/pub28.pdf

  •  2930. Other State: Verify Other State State information is complete and accurate.
  • Go to

...

  • Core/Payroll Item Configuration

    • Filter the grid by entering 'State Tax' in the Type field 

    • View each State Payroll Item

    • Verify the State

...

    • ID field is filled in and correct.

  •  3031. HSA: Verify any Payroll Items being used for HSA purposes have the Annuity Type field set to Other.
  • Go to Core/Payroll Item Configuration

    • Filter the grid by entering 'health' in the Type field

    • View the HSA

...

    • record 

    • Verify the Annuity Type is set to Other

Info

This amount will be placed in Box 12 with code W.

  •  3132. W2 Configuration:   Verify all information is complete.
  • Go to System/Configuration/W2

...

  • configuration.

    • Verify the 'District will Submit Own W2s Files' is CHECKED

    • District has option to check box for: "Include only last 4 digits of employee's SSN on W-2 forms and XML".

    • Verify Company Information is accurate.

    • Verify or complete all information under Contact Information.

    • Verify or complete all information in the Submitter Information.

    • Click the box for "Submitter Name and Address same as Company".

    • Save.

Warning
  • The Submitter EIN is the Federal ID used when registering with Social with Social Security Administration-Business Services Online (SSA-BSO)

  • The Submitter User Id is the unique Id assigned when registering with the Social Security Administration-Business Services Online (SSA-BSO)

  •  

...

  • 33. Dependent Care: If not using the Dependent Care Payroll Item type, enter the amount for Dependent Care benefits in Core/Adjustments.

Info

This amount will be added to the total and taxable gross fields by any amount above the maximum ($5,000.00 if filing married or $2,500.00 if married filing separately) for any Payroll Item that taxes Dependent Care (Federal, Ohio, and City (if applicable).  This amount would only be entered under the 001 Federal payroll item. 

Option #1:

  • Go to Core/Adjustments
    • Click Create
    • Find the employee by name or id
    • Under payroll item, choose Federal Tax, Code: 001
    • Set type to Dependent Care
    • Enter a transaction date within the current posting period
    • Enter the amount of dependent care
    • Description can be added if desired
    • Click Create

Option #2:  

If the Dependent Care Payroll Item has been used during normal payroll processing no further action is necessary.
Info

These amounts will appear on the W2 in Box 10.

  •  33. Third Party Sick Pay:  There are two types - taxable and non taxable.  Please see the document called Third Party Sick Pay for further information.        

...

  • Find the employee name or ID
  • Choose the payroll item(s) from the drop down: Fed, State, City and OSDI (if applicable), and Medicare.
  • Choose the type-Total Gross
  • Enter or choose a transaction date
  • Enter the amount of the third party pay
  • A description can be added (optional)
  • Click Save

Follow the same steps as above for the type - Applicable (taxable) Gross

Warning

These adjustments will need to be made on the Federal, State, and City if honored, OSDI and Medicare records accordingly.  Please see the Third Party Sick Pay document for steps to create these adjustments.

If Medicare tax was not withheld by the Third Party vendor then an Adjustments journal entry for Medicare-Amount Withheld will need to be processed. The board will pay the employee and employer amount and can ask the employee for reimbursement if desired.

...

  • Go to Core/Adjustments
    • Enter the employee name or ID
    • Choose the payroll item from the drop down -Federal Tax 001
    • Choose the type-Third Party Pay
    • Enter a transaction date within the current posting period
    • Enter in the amount of the non taxable third party pay
    • A description can be added (optional)
    • Click Save

Info

This information will be placed on the W2 in Box 12 as a Code J.

  •  34. Life Insurance (known in Classic as NC1): If the Life Insurance Premium Pay Type was NOT USED prior to the last pay of the calendar year, the Life Insurance payment amount must be entered as an adjustment on the Federal payroll item.  W2 Report and Submission will automatically adjust the Federal, State, OSDI, City (If applicable) and Medicare, total and taxable gross amounts.  No manual adjustments are needed for the Gross and Taxable Gross amounts, however the Medicare withholding must be paid. If the Medicare withholding is set up to be paid by the employee, employer or employee/employer, adjustments must be made to the Amount Withheld and Board Amount of Payroll Item. If Medicare is fully board paid (Pickup) then the total Adjustment should be made to the Board Amount of Payroll Item.

  • Go to Core/Adjustments

    • Click Create

    • Enter the employee name or ID

    • Under the payroll item drop down and choose Federal

    • Under type choose Life Insurance Premium

    • Enter in a transaction date

    • Enter the amount of the life insurance 

    • Description can be entered (optional)

    • Click Save

  • Use Core/Adjustments to manually add the Medicare Amount Paid

    • Enter the employee name of ID

    • Under the payroll item drop down, choose Medicare Tax

    • Under type choose Amount Withheld

    • Enter in a transaction date within the current posting period

    • Enter in the amount owed for employee and employer Medicare for the Life Insurance Premium. (board will need to pay both employee and employer share and employee can reimburse the district if the board desired.)

    • A description can be entered (optional)

    • Click Save

  • Repeat for the Board Amount of Payroll Item
Info

The city is only adjusted when the city payroll item configuration Tax Non Cash Earnings box is checked. 

If Medicare is fully board paid (Pickup) then the total Adjustment (1.45%) should be made to the 'Board Pickup Amount of Payroll Item'. This will update both Medicare pickup and Medicare on the Employee's W2.

Board will need to pay for both Employee and Employer portion of Medicare and employee can reimburse the district if board desires.

...

The amount entered exceeding the maximum ($5,000.00) will be added to the Total Gross and Applicable Gross fields on Federal Tax, Ohio State Tax, and City (if applicable) Payroll Items. 

  • Go to Core/Adjustments, click Create

    • Employee = Locate the employee by name or id

    • Payroll Item = 001-Federal Tax

    • Type = Dependent Care

    • Transaction Date = Enter a date within the current posting period

    • Amount = Enter the amount of dependent care

    • Description = Can be added if desired

    • Click Save

Info

These amounts will appear on the W2 in Box 10.

  •  34. Third Party Sick Pay:  There are two types - taxable and non taxable.  Please go to the Third Party Sick Pay link for further information.      
Warning

Taxable -These adjustments will need to be made on the Federal, State, and City if honored, OSDI and Medicare records accordingly.  Please see the Third Party Sick Pay document for steps to create these adjustments.

If Medicare tax was not withheld by the Third Party vendor then an Adjustments journal entry for Medicare-Amount Withheld will need to be processed. The board will pay the employee and employer amount and can ask the employee for reimbursement if desired.

Info

This information will be placed on the W2 in Box 12 as a Code J.

  •  35. Life Insurance: Process any Life Insurance (NC1 payments in Classic) payments. 

If the Life Insurance Premium Pay Type was included prior to the last pay of the calendar year (refer to Step 2 of the checklist), then no further steps are necessary.

If the Life Insurance Premium Pay Type was not used prior to the last pay of the calendar year please go to Reporting Taxable Amounts -Life Insurance Premium link for further information.

Info

This information will be placed on the W2 in Box 12 as a Code C.

  • Go to Core/Adjustments, click Create

    • Employee = Locate the employee by name or id

    • Payroll Item = 001-Federal Tax

    • Type = Fringe Benefits

    • Transaction Date = Enter a date within the current posting period

    • Amount = Enter the amount of the fringe benefit

    • Description = Can be added if desired

    • Click Save

Info

This information will be placed on the W2 in Box 14 as a code Fringe.

Tuition Reimbursement above $5,250.00 is considered as a Fringe Benefits and would be subject to regular taxation.  Add the amount above $5,250.00 paid for tuition reimbursement.

  •  36.  Moving Expenses: Reimbursements 37.  Moving Expenses: Process any Moving Expense payments.

Reimbursements for moving expenses paid to active military employees, including payments made directly to a third party,

...

should be reported.  The moving expense amount is treated as an

...

excludable fringe benefit. 

  • Go to Core/Adjustments

...

  • , click Create

...

    • Employee = Locate the employee by name or

...

    • id

    • Payroll Item = 001-Federal Tax

    • Type = Moving Expenses

    • Transaction Date = Enter

...

    • a

...

    • date within the current posting

...

    • period

    • Amount = Enter the amount of the moving

...

    • expense

    • Description

...

    • = Can be added if desired

    • Click Save

Info

This information will be placed on the W2 in Box 12 with a code P.

  •  3738Company Vehicle:  Process any Company Vehicle payments.  

A Core/Adjustment to the Federal Tax Payroll Item is the only requirement.  The Vehicle Lease

...

Adjustment will automatically update the Total Gross and Applicable Gross on the Federal Tax and Ohio

...

State Tax Payroll Items

  • Go to Core/Adjustments

...

  • , click Create

    • Employee = Locate the employee by name or id

    • Payroll Item = 001-Federal Tax

    • Type = Vehicle Lease

    • Transaction Date = Enter a date within the current posting

...

    • period

    • Amount = Enter the amount of the company vehicle

...

    • Description

...

    • = Can be added if desired

    • Click Save

Info

This information will be placed on the W2 in Box 14.

  •  3839Adoption Assistance:  Process any Adoption Assistance (known NC2 payments in Classic) payments.  See Reporting Taxable Amounts - Adoption Assistance (Known as NC2 ):  Payments in Classic) for further details.   

If the Adoption Assistance payment (refer to Step 3, using the Adoption Assistance Pay Type) was processed as part of a payroll prior to calendar year end, no further processing is required.  

If the Adoption Assistance

...

Pay Type was not used prior to the last pay of the calendar year,

...

a Core/Adjustments using the Type of Adoption Assistance for the payment must be created.  The only Adjustment needed is the Type/Federal Tax Payroll Item, detailed below. The Adoption Assistance Adjustment will automatically update the Total Gross and Applicable Gross on the Federal Tax, City (if applicable), Medicare Payroll Items. No further adjustments for Total Gross and Applicable Gross are necessary.

  • Go to Core/Adjustments

...

  • , click Create

...

    • Employee = Locate the employee by name or

...

    • id

...

    • Payroll Item

...

    • = 001-Federal Tax

    • Type = Adoption Assistance

    • Transaction Date = Enter

...

    • a

...

    • date within the current posting period

    • Amount = Enter

...

    • the amount of the adoption assistance

    • Description

...

Click Save

    • = Can be added if desired

    • Click Save

The software provides the ability to withhold city tax on non-cash earnings. City tax withholding is based on whether the Core/Payroll Item Configuration/Tax Non Cash Earn checkbox is marked or not marked. Keep in mind, city taxes may also need to be paid if the employee is not a resident of the city where the tax is deducted.

Info

This information will be placed on the W2 in Box 12 as a Code T.

  •  3940Taxable Benefits:  If the 'Non-cash Taxable Benefit' pay type was NOT USED during payroll processing, an Adjustment entry is needed using the Taxable Benefits. This will update the Total and Applicable Gross totals on the Federal and State records during W2 Report. 
Info

Please see document called Reimbursable Employee Expense Situations for further details.

Option #1: 

  • Go to Core/Adjustments

    • Click Create

    • Enter the employee name or ID

    • Under the Payroll Item drop down and choose the 001 record

    • Under Type choose Taxable Benefits

    • Enter in a Transaction Date within the current posting period

    • Enter in the amount of the taxable benefit

    • Description can be entered (optional)

    • Click Save

Option #2:

  • If the 'Non-cash Taxable Benefit' pay type in Payroll Payments Current or Future was used, this will represent the non-cash taxable benefits amount.  Nothing further needs to be processed.

  •  40Cash Taxable Benefits:  Process any Non-Cash Taxable Benefits (NC3 payments in Classic).

If the Non-cash Taxable Benefit payment (Step 4, using the Non-cash Taxable Benefit Pay Type) was processed as part of a payroll prior to calendar year end, no further processing is required.  

If the Non-cash Taxable Benefit Pay Typewas not used prior to the last pay of the calendar year please go to Non-Cash Taxable Benefits link for further information.

  •  41Employer Health Coverage Costs.  If all Health Insurance of the appropriate health insurance Core/Payroll Item configuration screens have 'Configuration records have had the Employer Health Coverage ' boxes checked checkbox(s) marked the entire calendar year and both employee and/or employer amount(s) are tracked on the system, and the totals being reported are accurate, nothing further is required. 

If the Employer Health Coverage Costs needs updated, create a Core/Adjustments for the Federal Tax Payroll Item using the Type of Health Insurance.  Keep in mind, the amount entered on

...

the Health Insurance Adjustment does not overridethe existing amount. The Adjustment amount is added or subtracted to the existing total. 

  • If individuals need updated: 

    • Go to Core/Adjustments

...

    • , click Create

...

      • Employee = Locate the employee by name or

...

      • id

      • Payroll Item = 001-Federal Tax

      • Type = Health Insurance

      • Transaction Date =

...

      • Enter a date within the current posting

...

      • period

      • Amount = Enter the amount needing to be added to the current amount being reported

      • Description = Can be added if desired

      • Click Save

  • If multiple employees need updated, Utilities/Mass Load can be used.

    • Create a .CSV file.  Click here for the CSV file requirements.

    • Go to Utilities/Mass Load to upload the CSV file

    • Browse to file .CSV file

    • Importable Entities= AdjustmentJournal

    • Click Load

Info

The Adjustment for Health Insurance does NOT OVERRIDE the amount, it will add or subtract to the existing total. Only enter the

...

amount NOT

...

 tracked in USPS system

...

If needing to update multiple employees a mass load spreadsheet can be used:

...

.

...

...

Click Load

Info

Information placed in box 12 with code DD.

  •  4142Health Reimbursement Arrangement Information:  this This only applies to those small to those employers with less than 50 Fullfull-Time Equivalent time equivalent employees (those who work 130 hours a month or 30 or more hours a week for 120 consecutive days) and do NOTthe employer does not offer a group health plan to any of your employeestheir employees. 

The only Adjustment needed is the Type/Federal Tax Payroll Item.

  • Go to Core/Adjustments

...

  • , click Create

    • Employee = Locate the employee by name or id

    • Payroll Item = 001-Federal Tax

    • Type = Health Reimbursement

    • Transaction Date =

...

    • Enter a date within the current posting

...

    • period

    • Amount =

...

    • Enter the amount needing to

...

    • be reported

    • Description = Can be added if desired

    • Click Save

Info

Information placed in box 12 with code FF.

...

W2

...

Report and Balancing  

  •  4243Run W2 Report and Submission-Error Report
  • Go to Reports/W2 Reports/W2 Report and Submission/W2 Report Options tab.

    • Output Type = Report

    • Format = PDF

    • Report Title = Defaults to W2 Report. This can be changed if desired.

    • Federal ID Number = Defaults to Federal EIN number in Core/Organization. Check for accuracy.

    • State ID Number = Defaults to State EIN number in Core/Organization. Check for accuracy.

    • Kind of Employer = Defaults to S, State and Local Government Employer. Can be changed through drop down option.

    • Sort Options = Choose from the drop down option how the report should be sorted.

    • Report for Year = XXXX

    • Include Fringe Benefits in Box 14? = Uncheck the box, not needed for error checking.

    • Report Employees with errors only? = Check the box

    • Select Payroll Items to print in box 14 = Leave blank

    • Click Generate Report

    • Print the W2 Report and verify the data.

Info

For more details regarding the W2 Report, Errors and Warnings, and Submission program and it's options, click here.

  •  

...

  • 44. Run W2 Report and

...

  • Submission-Balance and

...

  • Verify W2 Report:  
  • Go to Reports/W2 Reports/W2 Report and Submission/W2 Report Options tab.

    • Output Type = Report

    • Format = PDF

    • Report Title = Defaults to W2 Report. This can be changed if desired.

    • Federal ID Number = Defaults to Federal EIN number in Core/Organization. Check for accuracy.

    • State ID Number = Defaults to State EIN number in Core/Organization. Check for accuracy.

    • Kind of Employer = Defaults to S, State and Local Government Employer. Can be changed through drop down option.

    • Sort Options = Choose from the drop down option how the report should be sorted.

    • Report for Year = XXXX

    • Include Fringe Benefits in Box 14? = Check the box so these are included on W2

    • Report Employee with errors only? = Uncheck the box

    • Select Payroll Items to print in box 14 = Click Add to select payroll item(s) to print on W2 (maximum of 3 will print)

    • Click Generate Report

    • Print the W2 Report and verify the data.

Tip

W2 Report and Submission/Generate Report can be run as many times as necessary until all data on report is correct.  Please see document called Affects of Special Situations on W2 Processing for additional assistance with balancing.

W2 Print Files

  •  4445Create Print File for the Employee Copy of Print W2's:  
  •  
  • Go to Reports/W2 Reports/W2 Mailable Forms

    • Report Title = Defaults to W2 report

    • Federal ID Number = Defaults to Federal EIN number in Core/Organization. Check for accuracy.

    • State ID Number = Defaults to State EIN number in Core/Organization. Check for accuracy.

    • Kind of Employer = Defaults to S, State and Local Government Employer. Can be changed through drop down option.

    • Sort Options = Choose from the drop down option how the report should be sorted.  

      • Select the sort option that matches how you wish to have your employEE copies of your W2's printed. 

      • Please make note of this sorting option, you will use it again for Step

...

      • #54

    • Report for Year = XXXX

    • Employer Name = Defaults to Name in Core/Organization. Check for accuracy.

    • Employer Address first line = Defaults to Street 1 in Core/Organization. Check for accuracy.

    • Employer Address second line = Defaults to Street 2 in Core/Organization. Check for accuracy.

    • Employer City = Defaults to City in Core/Organization. Check for accuracy.

    • Employer State = Defaults to State in Core/Organization. Check for accuracy.

    • Employer Zip Code = Defaults to Postal Code in Core/Organization. Check for accuracy.

    • Show Building/Department Code =

...

    • If desired, check the checkbox to have the building/department printed on the mailable section of the form (to the right of the employee address).

    • Include Fringe Benefits in Box 14? = Check the box so these are included on

...

    • W2s.

      • Select Payroll Items to print in box 14 = Click Add to select payroll item(s) to print on W2 (maximum of 3 will print)

      • If you include Fringe Benefits in Box 14, please make note of any payroll items selected in this step, you will use it again for Step

...

Panel
borderStylenone

Image Removed

      • #54

    • Select Individual Employees? = Leave Blank

    • Select Pay Groups = Leave Blank

    • Click Generate Mailable Forms

    • An Informational message will be displayed.

...

    • image-20241113-173458.pngImage Added

    • The W2 Printing Jobs will also be displayed in the grid on the right hand side of the screen.

    • File name: W2 Report mailable.zip

  •  Send an email to mail_staff_fis@nwoca.org to let NWOCA know your W2's are ready to be printed and how you will receive your W2s, either by picking them up at the Archbold office (by appointment only) or having them sent via UPS. 
Note
  • Notification will be sent by NWOCA when the W2's have been printed.

  • NWOCA will Archive the W2 Form Data.PDF file sitting located in the W2 Form Output Files grid place . This will be archived in the Payroll Archive/YYYY - Calendar Year Reports.

  •  

...

  • 46. Create Print File for the Employer Copy of W2's: 

...

  • Go to Reports/W2 Reports/W2 Report and Submission/ W2 Report Options tab

    • Output Type = Forms

    • Forms Title = Defaults to W2 Form Data. Can be changed if desired.

    • Federal ID Number = Defaults to Federal EIN number in Core/Organization. Check for accuracy.

    • State ID Number = Defaults to State EIN number in Core/Organization. Check for accuracy.

    • Kind of Employer = Defaults to S, State and Local Government Employer. Can be changed through drop down option.

    • Sort Options = Choose from the drop down option how the report should be sorted.

...

borderStylenone

...

    •  Usually Employee Name.

      • Select the sort option that matches how you wish to have your employER copies of your W2's printed. 

    • Report for Year = XXXX

    • Employer Name = Defaults to Name in Core/Organization. Check for accuracy.

    • Employer Address first line = Defaults to Street 1 in Core/Organization. Check for accuracy.

    • Employer Address second line = Defaults to Street 2 in Core/Organization. Check for accuracy.

    • Employer City = Defaults to City in Core/Organization. Check for accuracy.

    • Employer State = Defaults to State in Core/Organization. Check for accuracy.

    • Employer Zip Code = Defaults to Postal Code in Core/Organization. Check for accuracy.

    • Include Fringe Benefits in Box 14? = Check the box so these are included on W2.

      • Select Payroll Items to print in box 14 = Click Add to select payroll item(s) to print on W2 (maximum of 3 will print)

    • Select Individual Employees? = Leave Blank

    • Select Pay Groups = Leave Blank

    • Click Generate W2 Forms

    • An Informational message will be displayed.

...

    • image-20241113-174124.pngImage Added

    • Once the job has completed, go to Reports/W2 Reports/W2 Form Output Files and click the download option. This will save the file to your computer.

    • Submit the W2 Forms.ZIP file to your printer using Actual Size

  • Go to Reports/W2 Reports/W2 Form Output Files and select the Archive option.

    • This will remove the file from the W2 Form Output Files grid and place in the Payroll Archive/YYYY - Calendar Year Reports

...

  •  

...

  • 47. Create Print File for the City Copy of W2's:

...

  • (if needed to file paper copies) 

  • Go to Reports/W2 Reports/W2 Report and Submission/W2 Report Options tab

    • Output Type = Forms

    • Forms Title = Defaults to W2 Form Data. Can be changed if desired.

    • Federal ID Number = Defaults to Federal EIN number in Core/Organization. Check for accuracy.

    • State ID Number = Defaults to State EIN number in Core/Organization. Check for accuracy.

    • Kind of Employer = Defaults to S, State and Local Government Employer. Can be changed through drop down option.

    • Sort Options = Choose from the drop down option how the report should be sorted.

...

    •  Usually Employee Name.

      • Select the sort option that matches how you wish to have your

...

      • CITY copies of your W2's printed. 

    • Report for Year = XXXX

    • Employer Name = Defaults to Name in Core/Organization. Check for accuracy.

    • Employer Address first line = Defaults to Street 1 in Core/Organization. Check for accuracy.

    • Employer Address second line = Defaults to Street 2 in Core/Organization. Check for accuracy.

    • Employer City = Defaults to City in Core/Organization. Check for accuracy.

    • Employer State = Defaults to State in Core/Organization. Check for accuracy.

    • Employer Zip Code = Defaults to Postal Code in Core/Organization. Check for accuracy.

    • Include Fringe Benefits in Box 14? = Check the box so these are included on W2.

      • Select Payroll Items to print in box 14 = Click Add to select payroll item(s) to print on W2 (maximum of 3 will print)

    • Select By City Tax Entity Code = Enter the first City Tax Entity Code (located on the

...

    • Core/Payroll Item Configuration/Tax Entity Code field).

    • Click Generate W2 Forms

    • An Informational message will be displayed.

...

Info

Info - Job started to generate W2 Forms.  Generated Forms can be found in the W2 Form Output Files View.

    • image-20241113-190612.pngImage Added

    • Once the job has completed, go to Reports/W2 Reports/W2 Form Output Files and click the download option. This will save the file to your computer.

    • Submit the W2 Forms.ZIP file to your printer using Actual Size

  • Go to Reports/W2 Reports/W2 Form Output Files and select the Archive option.

    • This will remove the file from the W2 Form Output Files grid and place in the Payroll Archive/YYYY - Calendar Year Reports.

  • Repeat these steps for each city needing to print forms for.

W2 Submission Files

  •  4748. Create and Submit Federal Submission File:  
  •  
  • Generate the Federal submission file.

    • Go to Reports/W2 Reports/W2 Report and Submission/W2 Report options tab

    • Output Type = Submission

    • Federal ID Number = Defaults to Federal EIN number in Core/Organization. Check for accuracy.

    • Additional Federal ID Number = If additional Federal ID number is available enter here.

    • State ID Number = Defaults to State EIN number in Core/Organization. Check for accuracy.

    • Kind of Employer = Defaults to S, State and Local Government Employer. Can be changed through drop down option

    • Sort Options = Choose from the drop down option of how the report should be sorted.  

    • Report for Year = 20XX

    • Employer Name = Defaults to Name in Core/Organization. Check for accuracy.

    • Employer Address first line = Defaults to Street 1 in Core/Organization. Check for accuracy.

    • Employer Address second line = Defaults to Street 2 in Core/Organization. Check for accuracy.

    • Employer City = Defaults to City in Core/Organization. Check for accuracy.

    • Employer State = Defaults to State in Core/Organization. Check for accuracy.

    • Employer Zip Code = Defaults to Postal Code in Core/Organization. Check for accuracy.

    • Contact Name = Enter name of employee creating the file (required).

    • Contact Phone Number = Enter phone number of person creating file (required).

    • Contact Phone Extension = Enter extension of person creating file (optional).

    • Contact Fax Number = Enter fax number for person creating file (optional).

    • Contact Email Address = Enter email address of person creating file (required).

    • Is this file being resubmitted? = No

    • Type of Software = In-House Program

    • Preparer Code = L-Self-Prepared

    • Select Generate SSA W2 Submission File Summary Report.  Print and save.

    • Click Generate SSA W2 Submission File

      • Save the W2MAST.TXT file to your desk top or somewhere on your computer

      • On save file, right click on the file and click Send

...

      • To/ Compressed Zip folder

...

  • Verify reports have been copied to the File

...

  • Archive/Calendar Year End bundle

    • Go to

...

    • Utilities/File Archive

      • Filter Year by entering

...

      • 2024

...

      • Single click

...

      • 2024 - Calendar Year Reports line.  You should see the following reports and files:

        • W2 Report.PDF

        • W2MAST.TXT 

...

  • Verify the Federal file is corrected formatted.

    • Log into

...

...

    •  website

    • Click on the Report Wages to Social Security option

    • Click on I Accept

    • Click on the Accuwage Online tab

    • Click on Accuwage Online option

    • Under Submission Type click W-2 and then click Start Testing

    • Find your W2MAST.TXT file Run the W2MAST.TXT file through Accuwage to check for any errors that may be on the file.

    • Fix errors on the W2MAST and re-run through ACCUWAGE until errors are gone.

...

  • Upload the Federal file.

    • Log into

...

    • the SSA-Business Services Online using your Secure User ID and Password

    • Choose the Report Wages to Social Security option

    • Choose Upload Formatted Wage File tab

    • Click on Submit a Formatted Wage File

    • Follow the menu options Choosing the New W-2s W-3s for Tax Year 20XX

    • Locate your W2MAST.TXT file that you have appended and zipped and click on the submit option.

    • Print out the Submission information

    • Check back periodically to see the status of the submission.

    • Print confirmation of submission being accepted.

  •  

...

  • 49. Create and Submit Ohio Submission File.

...

  • Go to Reports/W2 Reports/W2 Report and Submission/W2 State Options tab.

    • State = Ohio

    • Federal ID Number = Defaults to Federal EIN number in Core/Organization. Check for accuracy.

    • Additional Federal ID Number = If additional Federal ID number is available enter here.

    • State ID Number = Defaults to State EIN number in Core/Organization. Check for accuracy.

    • Kind of Employer = Defaults to S, State and Local Government Employer. Can be changed through drop down option

    • Report for Year = 20XX

    • Employer Name = Defaults to Name in Core/Organization. Check for accuracy.

    • Employer Address first line = Defaults to Street 1 in Core/Organization. Check for accuracy.

    • Employer Address second line = Defaults to Street 2 in Core/Organization. Check for accuracy.

    • Employer City = Defaults to City in Core/Organization. Check for accuracy.

    • Employer State = Defaults to State in Core/Organization. Check for accuracy.

    • Employer Zip Code = Defaults to Postal Code in Core/Organization. Check for accuracy.

    • Contact Name = Enter name of employee creating the  file (required).

    • Contact Phone Number = Enter phone number of person creating file (required).

    • Contact Phone Extension = Enter extension of person creating file (optional).

    • Contact Fax Number = Enter fax number for person creating file (optional).

    • Contact Email Address = Enter email address of person creating file (required).

    • Is this file being resubmitted? = No

    • Type of Software = In-House Program

    • Preparer Code = L-Self-Prepared

    • Select Generate Ohio W2 Submission File Summary Report.  Print and save.

    • Click Generate Ohio W2 Submission File

      • Save the W2MAST_OH.TXT file to your desk top or somewhere on your computer

      • On save file, right click on the file and click Send

...

      • To/ Compressed Zip folder

  •  Verify reports have been copied to the File
  • Archive>Calendar
  • Archive/Calendar Year End bundle.
  • Go to

...

  • Utilities/File Archive

    • Filter Year by entering

...

    • 2024

...

    • Single click

...

    • 2024 - Calendar Year Reports line.  You should see the following reports and files:

      • W2MAST_OH.TXT 

  •  Verify the Ohio file is
  • corrected
  • correctly formatted using Accuwage.
  • Log into

...

...

  •  website

    • Click on the Report Wages to Social Security option

    • Click on I Accept

    • Click on the Accuwage Online tab

    • Click on Accuwage Online option

    • Under Submission Type click W-2 and then click Start Testing

    • Find your W2MAST_OH.TXT file. Run the W2MAST_OH.TXT file through Accuwage to check for any errors that may be on the file.

    • Fix errors on the W2MAST_OH.TXT and re-run through

...

    • Accuwage until errors are gone.

  •  

...

  • 50. Create and Submit Other State Submission File(s) - if applicable:
Info

...

Electronic State Filing Requirements:

The following is the criteria each state requires for filing on paper or electronically:

  • Indiana - requires electronic filing if 25 or more W2's.

  • Kentucky - requires electronic filing of all W2's.

  • Michigan - requires electronic filing if 250 or more W2's.

  • Pennsylvania - requires electronic filing if 10 or more W2's.

  • West Virginia - requires electronic filing if 25 or more W2's.

Warning

Indiana requirements include: A Payroll Item Configuration City Tax record for the county tax record and a Payee address with IN as the state. The Payroll Item record for your employees for Indiana County tax will need to have a Deduction Type of “R” for Residence and the Indiana code in the Indiana W2 Instructions, Appendix A. The Indiana Code will need to be put in the Payroll Item Code 1 field.

The codes are currently 01 – 92. If using 1 – 9, it must be entered as 01, 02, 03, 04, 05, 06, 07, 08, 09.  

           The website for the County Codes is below, Page 12: 

EFW2 (W-2 and

...

WH-3) Electronic Filing Requirements

  • Go to Reports/W2 Reports/W2 Report and Submission/W2 State Options tab (Repeat process for each state)

    • State = Select the appropriation state

    • Federal ID Number = Defaults to Federal EIN number in Core/Organization. Check for accuracy.

    • Additional Federal ID Number = If additional Federal ID number is available enter here.

    • State ID Number = Defaults to State EIN number in Core/Organization. Check for accuracy.

    • Kind of Employer = Defaults to S, State and Local Government Employer. Can be changed through drop down option

    • Report for Year = 20XX

    • Employer Name = Defaults to Name in Core/Organization. Check for accuracy.

    • Employer Address first line = Defaults to Street 1 in Core/Organization. Check for accuracy.

    • Employer Address second line = Defaults to Street 2 in Core/Organization. Check for accuracy.

    • Employer City = Defaults to City in Core/Organization. Check for accuracy.

    • Employer State = Defaults to State in Core/Organization. Check for accuracy.

    • Employer Zip Code = Defaults to Postal Code in Core/Organization. Check for accuracy.

    • Is this file being resubmitted? = No

    • Type of Software = In-House Program

    • Preparer Code = L-Self-Prepared

    • Submitter EIN = Verify information is correct

    • Submitter User ID = Verify information is accurate

    • Tax Payer ID (10 digits) = Only applies to Indiana

    • TID Location (3 digits) = Only

...

    • applies to Indiana

    • Select Generate the XX W2 Submission File Summary Report.  Print and save.

    • Click Generate XX W2 Submission File

      • Save the W2MAST_XX.TXT file to your desk top or somewhere on your computer

  •  Verify reports have been copied to the File
  • Archive>Calendar
  • Archive/Calendar Year End bundle.
  • Go to

...

  • Utilities/File Archive

    • Filter Year by entering

...

    • 2024

...

    • Single click

...

    • 2024 - Calendar Year Reports line.  You should see the following reports and files that are applicable to your district:

      • W2MAST_MI.TXT

      • W2MAST_IN.TXT

  •  Upload the W2MAST_XX.TXT file to the appropriate state website.

  •  

...

  • 51. Create and Submit City Submission File(s) (if applicable):  This will be run for each City being submitted electronically.

...

  • Go to Reports/W2 Reports/W2 Report and Submission/W2 City Options tab

    • Federal ID Number = Defaults to Federal EIN number in Core/Organization. Check for accuracy.

    • Additional Federal ID Number = If additional Federal ID number is available enter here.

    • State ID Number = Defaults to State EIN number in Core/Organization. Check for accuracy.

    • Kind of Employer = Defaults to S, State and Local Government Employer. Can be changed through drop down option.

    • Sort Options = Choose from the drop down option how the report should be sorted.

    • Report for Year = 20XX

    • Employer Name = Defaults to Name in Core/Organization. Check for accuracy.

    • Employer Address first line = Defaults to Street 1 in Core/Organization. Check for accuracy.

    • Employer Address second line = Defaults to Street 2 in Core/Organization. Check for accuracy.

    • Employer City = Defaults to City in Core/Organization. Check for accuracy.

    • Employer State = Defaults to State in Core/Organization. Check for accuracy.

    • Employer Zip Code = Defaults to Postal Code in Core/Organization. Check for accuracy.

    • Tax Entity Code = Code entered on the Payroll Item Configuration record in the Tax Entity code field.

    • Include Amounts For All Cities? = Uncheck the box

    • Include City Name For the Processing City? = Check the box

    • Is this file being resubmitted? = No

    • Type of Software = In-House Program

    • Preparer Code = L - Self-Prepared

...

    • Select Generate City W2 Submission File Summary Report.  Print and save.

    • Select Generate City W2 Submission File City Summary Report.  Print and save

...

    • .

    • Click Generate City W2 Submission File

      • Save the W2CITY_XXXXX.TXT file to your desktop or some where on your computer.

...

  • Verify reports have been copied to the File

...

  • Archive/Calendar Year End bundle.

    • Go to

...

    • Utilities/File Archive

      • Filter Year by entering

...

      • 2024

...

      • Single click

...

      • 2024 - Calendar Year Reports line.  You should see the following reports and files:

      • W2CITY_

...

      • XXXXX.TXT

...

      • (one for each city file generated)

  • Upload the file to the appropriate city website.

  •  

...

  • 52. Create and Submit CCA Submission File (if applicable):

...

  • Go to Reports/W2 Reports/W2 Report and Submission/W2 Report Options tab

    • Output Type = Submission

    • Federal ID Number = Defaults to Federal EIN number in Core/Organization. Check for accuracy.

    • Additional Federal ID Number = If additional Federal ID number is available enter here.

    • State ID Number = Defaults to State EIN number in Core/Organization. Check for accuracy.

    • Kind of Employer = Defaults to S, State and Local Government Employer. Can be changed through drop down option.

    • Sort Options = Choose from the drop down option how the report should be sorted.

    • Report for Year = 20XX

    • Employer Name = Defaults to Name in Core/Organization. Check for accuracy.

    • Employer Address first line = Defaults to Street 1 in Core/Organization. Check for accuracy.

    • Employer Address second line = Defaults to Street 2 in Core/Organization. Check for accuracy.

    • Employer City = Defaults to City in Core/Organization. Check for accuracy.

    • Employer State = Defaults to State in Core/Organization. Check for accuracy.

    • Employer Zip Code = Defaults to Postal Code in Core/Organization. Check for accuracy.

    • Contact Name = Enter name of employee creating the file (required).

    • Contact Phone Number = Enter phone number of person creating file (required).

    • Contact Phone Extension = Enter extension of person creating file (optional).

    • Contact Fax Number = Enter fax number for person creating file (optional).

    • Contact Email Address = Enter email address of person creating file (required).

    • Is this file being resubmitted? = No

    • Type of Software = In-House Program

    • Preparer Code = L-Self-Prepared

    • Select Generate CCA W2 Submission File Summary Report.  Print and save.

    • Select Generate CCA W2 Submission File City Summary Report.  Print and save.

    • Click Generate CCA W2 Submission File

      • Save the W2MSTCCA.TXT file to your desktop or somewhere on your computer

...

  • Verify reports have been copied to the File

...

  • Archive/Calendar Year End bundle.

    • Go to

...

    • Utilities/File Archive

      • Filter Year by entering

...

      • 2024

...

      • Single click

...

      • 2024 - Calendar Year Reports line.  You should see the following files:

      • W2MSTCCA.TXT 

...

...

...

  • Mail the W-3 Annual Reconciliation Form.

  •  

...

  • 53. Create and Submit RITA Submission File (if applicable)

...

  • Go to Reports/W2 Reports/W2 Report and Submission/W2 Report Options tab

    • Output Type = Submission

    • Federal ID Number = Defaults to Federal EIN number in Core/Organization. Check for accuracy.

    • Additional Federal ID Number = If additional Federal ID number is available enter here.

    • State ID Number = Defaults to State EIN number in Core/Organization. Check for accuracy.

    • Kind of Employer = Defaults to S, State and Local Government Employer. Can be changed through drop down option.

    • Sort Options = Choose from the drop down option how the report should be sorted.

    • Report for Year = 20XX

    • Employer Name = Defaults to Name in Core/Organization. Check for accuracy.

    • Employer Address first line = Defaults to Street 1 in Core/Organization. Check for accuracy.

    • Employer Address second line = Defaults to Street 2 in Core/Organization. Check for accuracy.

    • Employer City = Defaults to City in Core/Organization. Check for accuracy.

    • Employer State = Defaults to State in Core/Organization. Check for accuracy.

    • Employer Zip Code = Defaults to Postal Code in Core/Organization. Check for accuracy.

    • Contact Name = Enter name of employee creating the file (required).

    • Contact Phone Number = Enter phone number of person creating file (required).

    • Contact Phone Extension = Enter extension of person creating file (optional).

    • Contact Fax Number = Enter fax number for person creating file (optional).

    • Contact Email Address = Enter email address of person creating file (required).

    • Is this file being resubmitted? = No

    • Type of Software = In-House Program

    • Preparer Code = L-Self-Prepared

    • Select Generate RITA W2 Submission File Summary Report.  Print and save.

    • Select Generate RITA W2 Submission File City Summary Report. Print and save.

    • Click Generate RITA W2 Submission File

      • Save the W2MSTRITA.TXT file to your desktop or somewhere on your computer

...

  • Verify reports have been copied to the File

...

  • Archive/Calendar Year End bundle.

    • Go to

...

    • Utilities/File Archive

    • Filter Year by entering

...

    • 2024

...

    • Single click

...

    • 2024 - Calendar Year Reports line.  You should see the following reports and files:

    • W2MSTRITA.TXT

...

W2 Archive & Close

...

CYE

  •  5354. Create W2 Archive Individual Forms (required!): This file will be placed in the Utilities/File Archive/W2 Archive for the current calendar year and will be used by the Kiosk Employee Self Service (if applicable) for employees to access their W2 information.
Warning

...

  • This file should be created after the user has verified that they have finalized W2 processing.

...

  • Users will need to make sure the control numbers that are generated, match the printed forms.  This can be done by choosing the same Sort Options used in

...

  • Step 45 when generating the W2 employee print file. 

...

  • Go to Reports/W2 Reports/W2 Archive Individual Forms

    • Federal ID Number = Defaults to Federal EIN number in Core/Organization. Check for accuracy.

    • State ID Number = Defaults to State EIN number in Core/Organization. Check for accuracy.

    • Kind of Employer = Defaults to S, State and Local Government Employer. Can be changed through drop down option.

    • Sort Options = Choose from the drop down option how the report should be sorted.  **This must be the same sort option used in step

...

    • 45**

    • Report for Year = 20XX

    • Employer Name = Defaults to Name in Core/Organization. Check for accuracy.

    • Employer Address first line = Defaults to Street 1 in Core/Organization. Check for accuracy.

    • Employer Address second line = Defaults to Street 2 in Core/Organization. Check for accuracy.

    • Employer City = Defaults to City in Core/Organization. Check for accuracy.

    • Employer State = Defaults to State in Core/Organization. Check for accuracy.

    • Employer Zip Code = Defaults to Postal Code in Core/Organization. Check for accuracy.

    • Include Fringe Benefits in Box 14? = Check the box so these are included on W2.  

    • Select Payroll Items to print in box 14 = Click Add to select payroll item(s) to print on W2. **This must match the payroll item(s) selected during the submission process in step

...

    • 45.**

    • Schedule Date and Time = schedule now, or at later time. Avoid 2:00am due to other processes running at that same time.

    • Click Schedule Job.

Info

...

An informational message will appear, stating that the Job was scheduled and the date and time it was scheduled for

...

.

Image Removed

...

  • Verify Individual W2s have been copied, after the scheduled job above processes, in the File

...

  • Archive/W2 Archive.

    • Go to

...

    • Utilities/File Archive/W2 Archive

      • Filter Description by entering

...

      • 2024

        • Single click

...

        • 2024 Tax Year Reports line. 

        • You should see files for individual employees W2s.

  •  54​55.   Run  Run the YTD Report (Optional).
  • Go to

...

  • Reports/YTD Report

    • Report Title = Defaults to YTD Report.  Can be changed if desired

    • Sort Option = Choose appropriate Sort option

    • Year = Enter appropriate calendar year

    • Include Compensation Information on Report? = Defaults to include Compensation information

    • Include Archived Employees? = Check the checkbox is wanting to include Archived employees

    • Specific Employees = Leave blank

    • Specific Pay Groups = Leave blank

    • Specific Job Statuses = Defaults to Inactive and Active selected

    • Generate Report

  •  5556.  Close the December Posting Period.
  • Go to

...

  • Core/Posting Period.

    • Click on

...

    • the Folder option for December.

    • The Open column field should now say ‘False’ for December.

  •  5657.  Verify Calendar Year End Report Bundles.
  • Go to

...

  • Utilities/File Archive

    • Filter Year by entering

...

    • 2024

...

    • Single click

...

    • 2024 - Calendar Year Reports line.  You should see the following reports:

      • Attendance Journal Report

      • Leave Balance Report

      • Payment Transaction Status Report

      • Employee Master Report

      • Earnings Register

      • YTD Report