Payroll reports

What a payroll report contains and how it works

Information about Payroll reports

Payroll reports are created as Excel-files (.xlsx).

Payroll reports are built to make handling payroll as easy as possible, no matter what system you use. Payroll reports can be seen as a snapshot of the information available in Simployer One at the creation of the report. For this reason it is important to know that if you make any changes in Simployer One for a certain period, this will only be reflected in any reports created after a change.

To create a Payroll report you first have to select a period for the period. Currently we support months. Once a report is created it cannot be deleted. This is to make it possible to check, and double-check, any information sent to your payroll department/provider.

There is a built in system to inform you about updates between the previous payroll report. To get this working properly you use the Mark as effective-function. Marking a report as effective means that the next report you create, in a future period, checks for changes in comparison to this exact report.

Note: Since reports are static, updates to what report is to be seen as effective does not update previously created reports. So be careful when changing this.

What does a Payroll report contain?

The Excel-file contains 6 sheets/tabs, below is a description of their contents.

Note: All tabs, except New hired and Terminations, has First name, Last name, Social security number and Employee number as the first set of columns. They also have the two last columns set to Department - Name and Office - Name.

Employee info

Work email, Work phone, Email, Phone, Birth date, Legal gender, Nationality, Bank Name, Clearing number, Bank account number, IBAN, BIC, Home Address - Country, Home Address - Postal Code, Home Address - City, Home Address - Street, Tax table, Tax column

Employment & Compensation

Latest change, Title, Compensation - Amount, Compensation - Currency, Compensation - Effective date, Compensation - Note, Compensation - Paid overtime, Compensation - Payout day, Compensation - Payout frequency, Compensation - Payout period, Hire date, Employment - Start date, Employment - Country, Employment - End date, Employment - Note, Employment - Rate, Employment type - Name, Cost center - Name, Cost center - Code

Time off

Leave - ID, Leave type - ID, Leave type - Name, Start date, End date, Leave (working days)

Timesheet

Payroll period start, Payroll period end, Working days, Working days worked, Total working time, Approved working time, Submitted working time, Rejected working time, Pending working time

New hires

First name, Last name, Social security number, Employee number, Hire date

Terminations

First name, Last name, Social security number, Employee number, Hire date, End date, Offboarding comment, Involuntary offboarding, Offboard date

Formats

Most fields are formated as plain text. Some fields contain pre-computed formats as:

Timesheet hours: HHH:MM

Dates: YYYY-MM-DD

Datetime (used for leaves that are less than a whole day): YYYY-MM-DD HH:MM

Social security numbers are only formated for Swedish personnummer (YYYYMMDD-XXXX).