Import payroll data for ChartHop Basic

if you have charthop basic and need to import payroll data from a system that is not supported by a charthop basic app, you can export your payroll to a spreadsheet and then import the spreadsheet to charthop ensure that the data in your file conforms to charthop's formatting requirements exporting data from a payroll system when you export payroll data from your system, the spreadsheet file should be in csv or xlsx format be utf 8 encoded have fewer than 1000 records at a minimum, the file should contain the following columns work email (as the first column) first name last name job title manager start date view and download an example spreadsheet typically, we recommend you use work email addresses to identify employees when you import however, you can use system id as your first column and then list payroll system identifiers such as adp id , bamboo id , or job id in that column if you do so, ensure that you provide a corresponding identifier for the person's manager (for example, if the first column is adp id , provide the manager's adp id in the manager column) import your data to charthop to import your data to charthop, complete the following steps on charthop's main screen, under upload a spreadsheet , select excel or csv or if you have already implemented some data on the left sidebar, select admin from the sub menu, select import spreadsheet data under upload your spreadsheet , drag and drop the file to import select next step charthop attempts to match each column with a charthop field for example, a column titled fname is identified as first name if necessary, under column in your spreadsheet , match any unmatched columns (highlighted in red) with the appropriate charthop field note that selecting none of these for a required field will generate an error under date format , select the date format for dates in the file select looks good! to proceed to the next section under add required info and tidy up your data , fix any errors (highlighted in red), such as improperly formatted dates or email addresses see the following section for a reference of common errors select looks good! to proceed to the next section under help us understand your org structure , select the head(s) of your organization if necessary, under identify managers , select any missing managers (highlighted in red) click looks good! to start creating your charthop organization a progress bar is displayed, but you can close the window without interrupting org creation you receive an email when your charthop organization is created org chart importing images we recommend connecting the slack docid\ qsduvgxe4fmcnahbrlxen app or your payroll/hris to import images, but if needed, you may upload them via a spreadsheet you can add profile pictures for your employees by uploading image links to the picture you want to associate with the employee add these links to the image column charthop will resize images and add them to individual's profiles when uploading images, note the following you should host images on a publicly available server with no login required you can upload images with the jpeg, jpg, png, and gif file types common column errors the following table contains column errors you may encounter while setting up your charthop organization error how to resolve invalid email format use a valid email format for work email and manager , such as steven jones\@charthop com invalid date format use a valid date format for start date that matches the one you selected, such as m/d/yyyy email addresses are not unique ensure that each person has a unique email address missing required field include work email , first name , last name , job title , and start date for each person p ackages basic basic | | headcount planning headcount planning | | compensation reviews compensation reviews | | performance performance | | engagement engagement roles owner