To prepare your Salary import file, follow these steps: 

1. Download the Excel template Salary Data Upload from the download section.
   
   Note: We recommend re-downloading the Excel template directly from this article before executing each import to avoid using an outdated version.
2. Open the Excel template and insert the email address for each employee.
3. In the column Fixed salary, fill out the currently valid gross monthly or yearly salaries, or use the Hourly salary column to fill out the currently valid hourly salaries.
   
   Note: Do not fill out both columns, as they will interfere with each other's calculations.
   
   
4. Use the column Interval to specify the frequency of the payment. You can choose either Monthly or Yearly.
   
   Note: The Interval column is only applicable in the case of a Fixed salary. Any value in this column will be ignored if you enter an Hourly salary.
   
   
5. For each employee, add the date from which the current salary is valid (usually the hire date or the date of the last salary increase).
6. For each employee, enter the Weekly hours.
   
   Note: If this value is left empty, the weekly working hours of the employee's department will be applied by default.
   
   
7. Save the completed Excel file.

Notes for salary imports
▶︎ The salary for part-time employees must be stated in the amount they actually receive.
Example: Carla receives 80 percent of her salary which equals to €3000: this is the amount that should be entered within the Excel file.
▶︎ Employees whose salary should not be imported (for example, former employees) may be omitted from the Excel file.
▶︎ When formatting the cells in the Excel file, make sure that salaries do not have more than two decimals.
▶︎ Performance-based bonuses can be set up separately for each employee. Find more details about Configuring Performance Goals.

Add past salaries and weekly working hours (optional)

If, in addition to the current salaries, past salaries and weekly working hours should also be imported into Personio, simply add additional entries for the respective employee in the Excel template and set the corresponding date in the past, in the Valid from field. This allows you to save all of your employees' salary history, and easily track salary changes.

It is possible to enter additional recurring salary components for each employee (for example, public transportation subsidy, meal allowances, gym subsidy, internet flat rate, etc.). These can be uploaded through the same method that you used before for the salaries. 

To prepare your import file, follow these steps: 

1. Download the Excel template Recurring Compensations Upload from the download section.
   
   Note: We recommend re-downloading the Excel template directly from this article before executing each import to avoid using an outdated version.
   
   
2. Open the Excel template and insert the email address for each employee.
   
   
3. Create a column for every recurring compensation type that is relevant to you.
   
   Notes
   ▶︎ Name each column the following way: Salary / description of the recurring compensation type.
   ▶︎ Every recurring compensation type that you want to import needs to be already created within Personio.
   
   
4. Then enter the respective amount for each compensation type.
   
   Note: To handle deductions, such as pension contributions, you can use negative amounts. Simply place a minus before the amount (for example, -700,00).
   
   
5. In the Interval column, set the payout interval to either monthly, quarterly, half-yearly, or yearly.
6. Now enter in Valid from the starting date from which the compensation has been paid out. Optionally, you can enter under Valid until the date on which the compensation ends. On the specified date, the corresponding compensation will be set to zero. 
   
   
7. Save the completed Excel file.

Note
Before you can import the Excel file, the additional salary components must first be stored in Personio.

To store additional salary components in Personio, follow these steps:

1. Go to Settings > Payroll > Additional Compensation.
2. Click Create New and enter the name of the compensation.
3. Under Payout Frequency choose Recurring.
4. Click Confirm.

Learn more about Managing recurring compensations.

You also have the option to import custom bonuses. These can be uploaded via the same method as the salaries.

To prepare your import file, follow these steps: 

1. Download the Excel template Custom Bonuses Upload from the download section.
   
   Note: We recommend re-downloading the Excel template directly from this article before executing each import to avoid using an outdated version.
2. Open the Excel template and insert the email address for each employee.
3. Under Custom Bonus, enter the respective amount.
4. Now enter in Valid from the starting date from which the compensation has been paid out.
5. Save the completed Excel file.

Note
Before you can import the Excel file, the bonus must be created as a salary component for the respective employees. 

To create the custom bonus for your employee, follow these steps

1. Navigate to the Employee profile and enter the Salary tab.
2. Under Salary components, click Edit.
3. Click on Edit/Add bonus, and select Custom bonus.
4. Choose the Bonus period and when the change is effective from.

Learn more about Managing Bonus Payments.

You also have the option to assign One-time compensations.

To prepare your import file, follow these steps: 

1. Download the Excel template One-Time-Compensation Upload from the download section.
   
   Note: We recommend re-downloading the Excel template directly from this article before executing each import to avoid using an outdated version.
2. Open the Excel template and insert the email address for each employee.
3. Enter the One-time compensation Payment type and Amount, an optional Comment, and the Month and Year of the payment.
4. Save the completed Excel file.

Note
▶ You do not need to create the One-time compensations in Personio beforehand. They will be automatically created by the import. Therefore, make sure that you use the correct spelling to avoid duplicate entries.
▶ Columns that contain numbers should always be formatted as text to be correctly imported in Personio.

Learn more about One-time compensations.