{"id":221,"date":"2014-09-22T12:09:20","date_gmt":"2014-09-22T12:09:20","guid":{"rendered":"https:\/\/www.avacon.org\/handbook\/?page_id=221"},"modified":"2020-04-29T20:16:25","modified_gmt":"2020-04-29T20:16:25","slug":"onboarding-new-employees","status":"publish","type":"page","link":"https:\/\/www.avacon.org\/handbook\/chapter-8\/onboarding-new-employees\/","title":{"rendered":"Onboarding New Employees"},"content":{"rendered":"<h1 id=\"toc0\"><a name=\"ONBOARDING NEW EMPLOYEES\"><\/a>ONBOARDING NEW EMPLOYEES<\/h1>\n<hr \/>\n<div id=\"toc\">\n<h1 class=\"nopad\">Page Sections<\/h1>\n<div style=\"margin-left: 1em;\"><a href=\"#ONBOARDING NEW EMPLOYEES\">ONBOARDING NEW EMPLOYEES<\/a><\/div>\n<div style=\"margin-left: 1em;\"><a href=\"#Employee Personnel Files\">Employee Personnel Files<\/a><\/div>\n<div style=\"margin-left: 1em;\"><a href=\"#Accounts Welcome Email\">Accounts Welcome Email<\/a><\/div>\n<div style=\"margin-left: 2em;\"><a href=\"#Accounts Welcome Email-Google Docs\">Google Docs<\/a><\/div>\n<div style=\"margin-left: 1em;\"><a href=\"#Social Media &amp; Web Account Services\">Social Media &amp; Web Account Services<\/a><\/div>\n<div style=\"margin-left: 1em;\"><a href=\"#AvaCon Grid\">AvaCon Grid<\/a><\/div>\n<\/div>\n<p>This page contains important information about the steps that must be taken when a new employee is hired and &#8220;onboarded&#8221; to AvaCon. \u00a0For a full checklist of each step of the onboard process, please see the document in our shared documents in AvaCon HR Dept &gt; Personnel Files &gt; AvaCon Master Employee Checklist. \u00a0Only approved HR personnel will have access to these files.<\/p>\n<p>&nbsp;<\/p>\n<h1 id=\"toc1\"><a name=\"Employee Personnel Files\"><\/a>Employee Personnel Files<\/h1>\n<hr \/>\n<p>The following items must be included in all employee personnel files:<\/p>\n<p><strong>Application Materials<\/strong><\/p>\n<ul>\n<li>Position description<\/li>\n<li>Employee Application<\/li>\n<li>Interview notes<\/li>\n<li>Test and test results if given during an interview<\/li>\n<li>Resume or CV<\/li>\n<\/ul>\n<p><strong>AvaCon Internal Forms<\/strong><\/p>\n<ul>\n<li>Biographical Data Form<\/li>\n<li>Photograph for Marketing &amp; PR (download from Biographical Data Form)<\/li>\n<li>Signed Conflict of Interest Form (required for members of the Executive Board, Directors, or Officers)<\/li>\n<li>Signed Intellectual Property Policy<\/li>\n<li>Signed Anti-Discrimination Policy<\/li>\n<li>Signed Confidential Information Policy<\/li>\n<\/ul>\n<p><strong>Federal &amp; State Tax Compliance Forms<\/strong><\/p>\n<ul>\n<li>Federal W-9 Request for Taxpayer ID &amp; Certification (Independent Contractors only)<\/li>\n<li>Federal W-4 Form for Federal Tax Withholding<\/li>\n<li>Massachusetts M-4 State Tax Withholding form (MA Residents only)<\/li>\n<\/ul>\n<p>What items should <strong>not<\/strong> be kept in an employee&#8217;s personnel file:<\/p>\n<p><strong>Medical records.<\/strong> Do not put medical records into a personnel file. If your worker has a disability, you are legally required to keep all of the worker&#8217;s medical records in a separate file &#8212; and limit access to only a few people. Even for workers who are not disabled, you may have a legal obligation to keep medical records private (and it&#8217;s a good idea to do so, in any case).<\/p>\n<p><strong>Form I-9s.<\/strong> Do not put Form I-9s into your employees&#8217; personnel files. Form I-9 is a form from U.S.Citizenship and Immigration Services (USCIS), formerly the INS. You must complete an I-9 for all employees, verifying that you have checked to be sure that the employees are legally authorized to work in the United States. <strong>You should put all Form I-9s into one folder for USCIS.<\/strong> The government is entitled to inspect these forms, and if it does, you don&#8217;t want the agents viewing the rest of the employee&#8217;s personnel &#8212; and personal &#8212; information at the same time.<\/p>\n<p><strong>Lawsuit evidence<\/strong>. Don&#8217;t put anything in a personnel file that you would not want a jury to see.<\/p>\n<p><strong>Unnecessary material.<\/strong> Although an employee&#8217;s personnel file may contain any other job-related documents, don&#8217;t go overboard. Remember that, in many states, employees have the right to view their personnel files.<\/p>\n<h1 id=\"toc2\"><a name=\"Accounts Welcome Email\"><\/a>Accounts Welcome Email<\/h1>\n<hr \/>\n<p>In the employee&#8217;s personnel file, start a new document called &#8220;Lastname, Firstname &#8211; Accounts Email Welcome Letter&#8221; and paste in the template text from <a href=\"http:\/\/avaconinc.wikispaces.com\/Accounts+Email+Template\" target=\"_blank\" rel=\"noopener noreferrer\">Accounts Email Template<\/a>. To complete the template, create the various accounts needed and paste the appropriate account information into the template.<\/p>\n<h2 id=\"toc3\"><a name=\"Accounts Welcome Email-Google Docs\"><\/a>Google Docs<\/h2>\n<hr \/>\n<p>The new employee&#8217;s <a href=\"mailto:first.last@avacon.org\" rel=\"nofollow\">first.last@avacon.org<\/a> email address needs to be created and access given to the appropriate directories.<\/p>\n<p>1. From Google Domain Admin Console &gt; Users &gt; Create User (set default password for email template)<\/p>\n<p>2. Add user to share for AvaCon Staff directory<\/p>\n<p>3. Add user to share for any other appropriate program directories<\/p>\n<p>4. Add user to <a href=\"mailto:staff@avacon.org\" rel=\"nofollow\">staff@avacon.org<\/a> and any other relevant company group email distribution lists.<\/p>\n<p>4. Paste appropriate information into the in-progress <a href=\"http:\/\/avaconinc.wikispaces.com\/Accounts+Email+Template\" target=\"_blank\" rel=\"noopener noreferrer\">Accounts Email Template<\/a><\/p>\n<h1 id=\"toc4\"><a name=\"Social Media &amp; Web Account Services\"><\/a>Social Media &amp; Web Account Services<\/h1>\n<hr \/>\n<p>1. Add the user to the appropriate Trello boards (use their <a href=\"mailto:first.last@avacon.org\" rel=\"nofollow\">first.last@avacon.org<\/a> address for the invitation!)<\/p>\n<p>2. Add user to the appropriate Skype groups<\/p>\n<p>3. Create an account for the user on the avacon.org public website,<\/p>\n<p>4. Paste appropriate information into the in-progress <a href=\"http:\/\/avaconinc.wikispaces.com\/Accounts+Email+Template\" target=\"_blank\" rel=\"noopener noreferrer\">Accounts Email Template<\/a><\/p>\n<h1 id=\"toc5\"><a name=\"AvaCon Grid\"><\/a>AvaCon Grid<\/h1>\n<hr \/>\n<p>1. If the user didn&#8217;t create an account on the AvaCon Grid during the interview process, send a separate invitation email with instructions to create an account and how to download and install the client.<\/p>\n<p>2. Approve the user&#8217;s account on the AvaCon Grid Wifi Administration panel, if applicable.<\/p>\n<p>3. Add the user to the AvaCon Staff group in-world.<\/p>\n<p>4. Add the name plate on the user&#8217;s assigned office in-world.<\/p>\n<p>&nbsp;<\/p>\n<h1>Setting Up New Employee Timekeeping<\/h1>\n<p>Adding a new employee or volunteer to our timekeeping system is a two part process. \u00a0First, the person needs to be added to the <a href=\"https:\/\/www.avacon.org\/blog\/documents\/time-reporting\/\" target=\"_blank\" rel=\"noopener noreferrer\">Time Reporting<\/a> form options in the Admin Dashboard on the AvaCon website. Then, the new person must be added to the formulas and automatic aggregation on the &#8220;Form &#8211; AvaCon, Inc. &#8211; Time Reporting [Year] (Synched)&#8221; spreadsheet where time reporting data is stored and calculated for payroll.<\/p>\n<h2>Add New User to Time Reporting Form<\/h2>\n<p>1. \u00a0Log into the <a href=\"avacon.org\/blog\/wp-admin\" target=\"_blank\" rel=\"noopener noreferrer\">Admin Dashboard<\/a> of the AvaCon public website.<\/p>\n<p>2. \u00a0Navigate to Formidable &gt; Forms &gt; Time Reporting &gt; Edit<\/p>\n<p>3. \u00a0On the first question &#8220;Name&#8221;, click the question to bring up the options and select &#8220;Bulk Edit Field Choices&#8221;<\/p>\n<p>4. \u00a0Type in the user&#8217;s name in alphabetical order following the precise format &#8220;Lastname, Firstname&#8221; without the quotes. \u00a0It is important that there be a comma and a space between the Lastname and Firstname in order for the spreadsheet calculations to work correctly. \u00a0Click &#8220;Update Field Choices&#8221; to save.<\/p>\n<p>5. \u00a0Scroll to the bottom of the page and click &#8220;Update&#8221; to save changes.<\/p>\n<p>6. \u00a0Scroll to the top of the screen and select the &#8220;Settings&#8221; button for the form.<\/p>\n<p>7. \u00a0In the Time Reporting Settings page, click the &#8220;Emails&#8221; tab on the left side of the screen.<\/p>\n<p>8. \u00a0Scroll all the way to the bottom of the page and click the &#8220;+ Add Notification&#8221; button.<\/p>\n<p>9. \u00a0Replace the &#8220;Email Recipients&#8221; address in the last notification with the new person&#8217;s first.last@avacon.org email address.<\/p>\n<p>10. \u00a0Enter the Subject as: \u00a0&#8220;AvaCon Time Report &#8211; [638] &#8211; [620] &#8211; [618]&#8221; without the quotes.<\/p>\n<p>11. \u00a0Click the link under Options to &#8220;Use Conditional Logic&#8221;<\/p>\n<p>12. \u00a0Change the Conditional Logic to &#8220;Send&#8221; this notification if &#8220;any&#8221; of the following match:<\/p>\n<p>Select Field: \u00a0&#8220;Name&#8221; is equal to &#8211; then select the new employee&#8217;s name from the pull down menu.<\/p>\n<p>13. \u00a0Scroll to the bottom of the screen and click &#8220;Update&#8221;<\/p>\n<p>14. \u00a0View the public facing\u00a0<a href=\"https:\/\/www.avacon.org\/blog\/documents\/time-reporting\/\" target=\"_blank\" rel=\"noopener noreferrer\">Time Reporting<\/a> form and make a test entry for the new employee with 0 hours to ensure that the form is working.<\/p>\n<h2>Add New User to Formulas in Time Reporting Spreadsheet<\/h2>\n<p>The\u00a0&#8220;Form &#8211; AvaCon, Inc. &#8211; Time Reporting [Year] (Synched)&#8221; spreadsheet has three main tabs:<\/p>\n<p>1) <strong>Time Punches<\/strong> &#8211; This first sheet is where raw time entry data from the Time Reporting web form is stored. \u00a0This tab should NEVER be edited except to reorder the rows or change values in a particular cell to correct a data entry error. \u00a0It is VERY important that columns, column names, and rows are not changed or deleted, or this will break the automatic synchronization between the Time Reporting web form and the spreadsheet.<\/p>\n<p>2 ) <strong>[Year] Totals<\/strong> &#8211; (For example, the current second tab is called &#8220;2015 Totals&#8221;) &#8211; The second sheet is where the time reports for the entire year are aggregated by a variety of categories, including by employee, by task type, and by project.<\/p>\n<p>3) \u00a0<strong>P Date1-Date2<\/strong> &#8211; (Pay period tab, for example, the current third tab is called &#8220;P 01\/11\/15-01\/24\/15&#8221;) &#8211; The third sheet is where time reports for a particular pay period are calculated in order to run payroll.<\/p>\n<p>Any additional tabs after the third tab are just copies of previous weeks payroll tabs for the time period specified in the tab name.<\/p>\n<p>In order to add a new employee to these calculations, we will be editing the second tab, and making a new copy of the third tab to edit.<\/p>\n<h3>Adding User to the &#8220;[Year] Totals&#8221; Tab<\/h3>\n<p><strong>Step One &#8211; Adding user to the Employee Hours section<\/strong><\/p>\n<p>1. \u00a0At the top of the sheet, insert a row in the Employee Hours section in the proper alphabetical order for the new employee. \u00a0Enter the user&#8217;s Last Name and First Name in the appropriate columns.<\/p>\n<p>2. \u00a0In Column C for the new employee row, copy the formula from the row above, and paste into the new employee&#8217;s row &#8211; then edit the formula to reflect the new employee&#8217;s name.<\/p>\n<p>3. \u00a0In Column D for the new employee row, enter the formula to make the number in that cell reflect the percentage of total hours that employee has worked of all Total Hours worked at AvaCon. \u00a0After entering the formula, make the data type a percentage.<\/p>\n<p>4. \u00a0In Column C find the Total Hours sum, and make sure the total rows being summed include the new employee&#8217;s row.<\/p>\n<p>To double check and make sure the Employee Hours are adding correctly, go back to the first tab in Time Punches, and edit the last row in the spreadsheet where the test time entry you entered for the new employee on the Time Reporting web form is recorded. \u00a0Change the hours worked from 0 to a new number, and make sure the new total is being reflected in the [Year] Totals spreadsheet. \u00a0When you&#8217;re finished checking, reset the time reported hours back to zero.<\/p>\n<p><strong>Step 2 &#8211; Adding user to the Billable Hours sections (pink)<\/strong><\/p>\n<p>Now that we&#8217;ve added a new row for the employee, you will need to copy the formulas from Columns F &#8211; K in the row above and paste them into the new employee&#8217;s row, then edit each formula by hand to change the employee name.<\/p>\n<p>For example, in Column F, the the formula in the employee row ABOVE my new employee&#8217;s row says:<\/p>\n<p><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">IFERROR<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span class=\" default-formula-text-color\" dir=\"auto\">SUM<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span class=\" default-formula-text-color\" dir=\"auto\">FILTER<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\">&#8216;Time Punches&#8217;!F:F<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span dir=\"auto\">&#8216;Time Punches&#8217;!B:B<\/span><span class=\"  default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" string \" dir=\"auto\">&#8220;Stortz, Joshua&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span dir=\"auto\">&#8216;Time Punches&#8217;!C:C<\/span><span class=\"  default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" string \" dir=\"auto\">&#8220;Yes&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\">0<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/p>\n<p>Copy that formula into the new employee row Column F, and edit the formula to replace the name with the new employee name. \u00a0<strong>Make sure to use the same format that you used when editing the Time Reporting web form, with the &#8220;Lastname, Firstname&#8221; format.<\/strong> \u00a0You must have a comma and space between the last and first names!<\/p>\n<p>Repeat this process for each cell in the new employee row for\u00a0Columns F &#8211; K.<\/p>\n<p>You may also need to check the Total Hours row in\u00a0Columns F &#8211; K to make sure the hours summary for each column is including\u00a0your new row in the calculation. \u00a0If not, adjust the rows being summed accordingly.<\/p>\n<p>To double check and make sure the Billable\u00a0Hours are adding correctly, go back to the first tab in Time Punches, and edit the last row in the spreadsheet where the test time entry you entered for the new employee on the Time Reporting web form is recorded. \u00a0Change the answer to Billable to yes, change the hours worked from 0 to a new number, and try various project names to make sure the new billable total is being reflected in the [Year] Totals spreadsheet. \u00a0When you&#8217;re finished checking, reset the time entry back to not billable and the hours reported to zero.<\/p>\n<h3>Creating a New Pay Period Tab with New Employee<\/h3>\n<p>Finally, we need to create a new pay period tab that will include the new employee for payroll purposes.<\/p>\n<p>1. \u00a0Select the most recent Pay Period tab (should be the third tab in the spreadsheet), select the small pull down triangle on the tab, and select &#8220;Duplicate&#8221;. \u00a0This should create an exact duplicate copy of the last pay period tab.<\/p>\n<p>2. \u00a0Reorder the tabs so that your new duplicate &#8220;Copy of..&#8221; tab is the third tab in the spreadsheet.<\/p>\n<p>3. \u00a0Edit the name of the new pay period tab to reflect the next or current pay period dates, in the format &#8220;P MM\/DD\/YY-MM\/DD\/YY&#8221;.<\/p>\n<p>4. Delete all row data (roughly rows 3-75) above the Employee Hours section from the last payroll, and reset the row colors to pink.<\/p>\n<p>5. \u00a0Scroll down to the Employee Hours section of the spreadsheet (starting at roughly row 76). \u00a0We are essentially going to repeat the process we followed in the previous tab &#8211; first adding a new row for the new employee, then copying and editing the formulas to match the new employee.<\/p>\n<p>That should be the last step!<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.avacon.org\/handbook\/chapter-8\/termination-exit-interview\/\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright\" title=\"page-turn_150px.jpg\" src=\"\/mainSpace\/files\/page-turn_150px.jpg\" alt=\"page-turn_150px.jpg\" width=\"150\" height=\"144\" align=\"right\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ONBOARDING NEW EMPLOYEES Page Sections ONBOARDING NEW EMPLOYEES Employee Personnel Files Accounts Welcome Email Google Docs Social Media &amp; Web Account Services AvaCon Grid This page contains important information about the steps that must be taken when a new employee is hired and &#8220;onboarded&#8221; to AvaCon. \u00a0For a full checklist of each step of the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":211,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-221","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.avacon.org\/handbook\/wp-json\/wp\/v2\/pages\/221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.avacon.org\/handbook\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.avacon.org\/handbook\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.avacon.org\/handbook\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.avacon.org\/handbook\/wp-json\/wp\/v2\/comments?post=221"}],"version-history":[{"count":11,"href":"https:\/\/www.avacon.org\/handbook\/wp-json\/wp\/v2\/pages\/221\/revisions"}],"predecessor-version":[{"id":533,"href":"https:\/\/www.avacon.org\/handbook\/wp-json\/wp\/v2\/pages\/221\/revisions\/533"}],"up":[{"embeddable":true,"href":"https:\/\/www.avacon.org\/handbook\/wp-json\/wp\/v2\/pages\/211"}],"wp:attachment":[{"href":"https:\/\/www.avacon.org\/handbook\/wp-json\/wp\/v2\/media?parent=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}