Don't use GoCo's Time Tracking, but have hours that need to be added during the pay run? Use GoCo's Time & Pay import option!
Before we start, ensure your spreadsheet is set up for success!
- You must include Employee ID on your spreadsheet. You can find these values by building a GoCo custom report with "Employee Name" & "Employee ID"
- Do you have types of pay that are paid at a different rate (ie Holiday Pay)? You'll need to add an additional column corresponding to that pay rate.
- For example, if "Holiday Hours" is paid at 1.5x the regular wage, you must include a "Holiday Pay Rate" column with the correct wage amount. Otherwise, GoCo will assume that the "Holiday Pay Rate" is the same as the "Regular Pay Rate".
- Here's an example of what the spreadsheet might look like:
Now that your spreadsheet is ready, let's learn how to import it into GoCo!
- Start your pay run in GoCo
- After the payroll populates, click the "Import" button on the upper right-hand side of the table
- A window will appear to select your import file.
- Review the mapping of the columns in the spreadsheet with the corresponding fields
- ⭐HINT: If you do not want a column to be included, simply "X" it out. (if you forget to do this at this step, you can do so in the next step as well)
- Don't see the earning code you need? It hasn't been set up yet. Email the Payroll Specialist team at embeddedpayroll@goco.io for assistance.
5. Once everything is mapped click "Continue"
6. You'll now be taken to a new page to review errors or add any missing information. If there are errors, you will be asked to review and either fix or continue without fixing
-
- ⭐HINT: Hover over the red cell - it will let you know what the error is
- To resolve the error or add any information that you forgot to input, click on the cell & update.
- If you decide to continue without resolving the error, those hours will not be imported for the employee
![Screenshot 2024-02-13 at 2.17.56 PM](https://help.goco.io/hs-fs/hubfs/Screenshot%202024-02-13%20at%202.17.56%20PM.png?width=586&height=369&name=Screenshot%202024-02-13%20at%202.17.56%20PM.png)
8. Once imported, you'll be redirected back to the pay run and you'll see a nifty "import" symbol on any employees who have imported hours. You will now continue your pay run in GoCo! 🎉
Have additional questions? Email us at help@goco.io 💚