WC Administrators

Retirement Plan Administrators
about us |  contact us
        Calculators       About Our Providers:    The Guardian       John Hancock       The Hartford       First Mercantile       Nationwide       MassMutual       Great West       Ohio National      
    WC Administrators home page Forms: Address Changes, Loan Requests, Distributions and more Definitions of commonly used terms Manage your 401k account Learn about our cafeteria plans and manage your cafeteria plan account Learn about 401k retirement plan, cafeteria plans, etc. Links to other financial planning sites Participant Notices, Summary of Material Modifications, etc.


You may download the template for the annual census by clicking on the following link:

Download Census Template (Microsoft Excel File)

go to top

Changes in the 2015 census

There are no changes in the information requested for the census this year. However, please remember that due to changes made in 2009 to federal requirements for reporting vesting, census data must include ACTUAL NUMBER OF HOURS WORKED for each employee.
  • We can no longer accept estimates of more or less than 1000 hours.
  • For full-time, salaried employees, you can enter 2080 hours worked.
  • For part-time or terminated salaried employees, please estimate the number of hours according to the employee's typical work schedule.
Also please note that first name, last name, and middle initial are divided into separate fields on this new template. Middle initials should consist of only one letter.

Instructions for download

Click on the link above to download the current census. Depending on your browser, one of the following may occur:

The file opens within your browser window or within Microsoft Excel: You may enter the information directly on this screen. To save your changes or to save a copy of the file on your system, click on "File" in the menu bar, select "Save As" and choose where to save the file on your system. You must save the changes on your system in order to submit the file.

The browser prompts you to either open the file or save it to disk: Choose "Open" or "Open with" (specify Excel if it is not the default). The file will open in Excel. You may enter the information directly on this screen. Then, to save your changes or to save a copy of the file on your system, click on "File" in the menu bar, select "Save As" and choose where to save the file on your system.

go to top

Instructions for completing the census

We need the information listed on the worksheet for each person who was an employee of your company in 2015, regardless of whether or not that person was a participant in the 401(k) plan. (Make sure that when you are reporting total gross earning that you report gross wages from the final payroll report.) All information MUST be provided. If there is missing information or any rework needs to be done an additional charge may be imposed.

Please return the census information to our office as soon as possible after the end of the year but no later than January 31, 2016.

go to top

Sample census

Click on the following link for a sample of a completed census

Sample Completed Census (Microsoft Excel Format)

go to top


How to require a password to open a file in Microsoft Excel

When you create a password, write it down and keep it in a secure place. If you lose the password, you cannot open or gain access to the data in a password-protected workbook.
  1. On the File menu, click Save As.
  2. On the Tools menu, click General Options.
  3. In the Password to open box, type a password, and then click OK.
    Passwords are case sensitive. Type the password exactly as you want users to enter it, including uppercase and lowercase letters.
  4. In the Reenter password to proceed box, type the password again, and then click OK.
  5. Click Save.
  6. If prompted, click Yes to replace the existing workbook with the open workbook.

Home  |   Forms  |   Glossary  |   My 401k  |   Cafeteria Plans  |   Products & Services  |   Links  |   Part. Notices  

About Guardian  |   About John Hancock  |   About The Hartford  |   About Nationwide
About First Mercantile  |   About MassMutual  |   About Great West  |   About Ohio National

Calculators  |   About Us  |   Contact Us  |   Legal Notice


This Site does not, and is not intended to, provide any financial, insurance, legal, accounting, or tax advice, and shall not be relied upon by you in that regard.

The Site is not intended, nor shall it be used by you, as a replacement for personal research or professional advice from a registered financial advisor.

All information provided by you through this Site will be used by WC Administrators for business purposes only, and will neither be distributed nor disclosed, except as needed to service your needs as a customer, in accordance with privacy laws.

WC Administrators, LLC is not a subsidiary or affiliate of John Hancock Life Insurance Company (U.S.A.), Manulife Financial, The Guardian Insurance & Annuity Company, MassMutual Financial Group, Great West Retirement Services, Ohio National Financial Services, The Hartford Retirement Plans, Nationwide Investment Services and/or their affiliates.

Copyright © 2004 WC Administrators, LLC. All Rights Reserved.

Guardian Life Insurance & Annuity John Hancock Financial
    formerly Manulife Financial USA

  Financial Group