Excel staff imports

Go to the Staff sheet in the Staff Excel file. The column names from Synergy are shown, to show you what you can copy from your external system using this Excel import.

Use an excel export feature in your current system to get an excel style output with all your existing staff details. This could mean you export the staff details from your accounting system, MS Outlook, or another CRM software package.

Compare the data in your Excel file to the Synergy Excel template, and check which columns are required (blue columns) and which can be left blank (green columns).

• Copy the data into the Synergy Excel template, making sure that you keep the column headers intact.
• Only copy data below the header section.

Mandatory details 

• The email addresses entered must be unique. You cannot have more than one staff member with the same email address.
• The 'Unique ID' column must be unique. We suggest entering S-0002 on the first record and dragging it down to auto-complete a unique number on all the records.
• Set the 'Security Level' to be any of the following values: User, Assistant project manager, Project manager, Director access, or System administrator. Check the security matrix to see what each access level can do in Synergy in the Settings > Organisation > Security matrix.
• In the 'Reports to' column type the email address of the person that is the staff members manager. The manager must already exist in Synergy as a staff member or be included in the Excel file with this as their primary email address.
• The 'Default Rate' column is the Primary Rate name which the staff member will be charged out with. Additional rates can be added to the staff record after the import.
• The 'Salary Type' column allows the values: salary, contractor, or hourly cost.
• For salary type 'salary' enter the annual package (including superannuation or pension fund contributions) in the 'Salary Package / hourly rate' column.
• For salary types 'contractor' or 'hourly cost', enter the pay rate per hour in the 'Salary Package / hourly rate' column. For contractors, this is excluding superannuation or pension fund contributions value.

Extra details (green columns)

• The optional 'cost' and 'calendar' columns when left blank will add the 'default settings' from the Financial controls set up area. For example, if in your financial controls your hours per week is set to 37.5 hours then the working hours per weekday will default to 7.5 hours per day, Monday to Friday work week. Add values in these columns if you require a different value.
• Contractor 'Salary type' does not allow values to be imported for 'Cost - Extras' or 'Cost - Super' for Australian organisations.
• Hourly rate 'Salary type' does not allow values to be imported for the columns 'Cost- Extras', 'Cost - Super', 'Cost - Hours per year', 'Cost - Availabilty', 'Cost - Overhead adjustment', and 'Cost - Target utilisation'.
• The columns 'Cost - Extras' and 'Cost - Super' are only available for Australian organisations. For all other regions, the values in these columns are ignored on import.
• The default project number prefix is available for Synergy Enterprise product only. Enter the project prefix like 2018 or SYD or LON. Set up project prefixes in Settings > Organisation > Project numbers.
• Multiple tags can be entered. A Comma separates the entries in these fields when this is required. e.g. Tag1, Tag2, Tag3.