With over 4000 customers, and over 350 000 employments being handled, Mepco is one of Finland's most popular payroll and HR software. Many of Bezala customers use Mepco or another HR software called Sympa, and to make their life easier we've created an integration that automates the following:
Update employees' basic data from Mepco/Sympa to Bezala (incl. name, email, SSN, language, IBAN, BIC)
Updates the employees' defaults (default cost centers, accounts)
Updates the employees' foreman
Deactivates the employee the day after the contract is terminated
Since Mepco/Sympa does not yet have an API, we've built the integration using CSV files that are transferred via SFTP. The columns in the CSV file are listed below. The order of the columns does not matter, and not all columns are required. However, the header name has to be exactly as shown below.
Required columns:
Column header | Description |
Person Number | Add your Mepco/Sympa employee ID here |
User Email |
|
User Name | Please note! There must not be a comma between the first name and the last name. |
Optional columns:
Column header | Description |
User Language | Can be ENGLISH, SWEDISH or FINNISH, otherwise we will fall back to the company default language. |
User Role | Can be EMPLOYEE, MANAGER, ACCOUNTANT, APPROVER, or MONEY CHECKER, otherwise we will fallback to EMPLOYEE |
User IBAN |
|
User BIC |
|
User SSN |
|
Default Cost Centers ::: dimensionname | Please add all dimensions in separate columns. Ex: "Default Cost Centers ::: Cost Center". The dimensionname has to match to the dimension name in Bezala, otherwise, we will ignore this column. The cost center ID also has to exist in Bezala, otherwise, we will ignore it. IF the company has a company ID set then the corresponding company ID must be set in the "Yhtiönumero" column for this to work. |
User Approvers | Comma-separated, specified by their Person Numbers. If the approvers are separated by a comma (102, 103), the THEN rule will be applied between them. Approvers can also be separated using these rules, for example (102 THEN 103) or (102 OR 103). The values in the column should not include the parentheses from these examples. |
Ts Päättymispv | DD.MM.YYYY |
Yhtiönumero | If you are a group of companies, place the company ID that the employee belongs to in this column. If you only have one company then please ignore this column. The company ID needs to be added to "External company ID" field in company settings in Bezala. |
Incomes Register | Send Incomes Register reports from this user or not. Value can be YES or NO. If the column is present, "YES" is assumed by default, e.g. if the cell is empty. |
Mileage Category | User-specific mileage category. The value is category’s name, e.g. Finland: Default. Value "None" can be used to remove user-specific category from user settings. If the cell is empty, user’s category is not updated. |
Per Diem Category | User-specific per diem category. The value is category’s name, e.g. Finland: Default. "None" can be used to remove user-specific category from user settings. If the cell is empty, user’s category is not updated. |
street | street and number of home adress, e.g. Keilalahdentie 2-4 |
postal code | postal code, e.g. 02150 |
city | city, e.g. Espoo
Make sure this user value is added since new SEPA rules make this value mandatory. |
country | country, e.g. FI (See country code table down below) Make sure this user value is added since new SEPA rules make this value mandatory. |
Work Time Group | Use the name of the work time group in this column. Has to be exactly the same name as it is in Bezala, e.g. Monthly salary |
Work Time Percentage | Has to be a number between 0-100 so full time work would be 100 |
Working Weekdays | Weekday names in English that are comma separated, so a normal Monday-Friday week would be:
or you can also write weekday's with only the 3 first letters: mon, tue, wed, thu, fri
The values are not case sensitive, but has to be either full name i.e. Monday or monday or abbreviated to 3 first letters i.e. Mon or mon or MON |
Hide Flex Time | Value needs to be YES or NO |
Vacation Days | Number of vacation days in the balance, has to be a whole number so e.g. 0 or 5 or 8 or 25 |
Vacation Balance Date | From which date the vacation balance is valid. DD.MM.YYYY so first of April 2026 would be 01.04.2026 |
Flex Hours | Either in decimal format or HH:MM so 1h and 15 minutes would be 1,25 or 1.25 or 01:15 or 1:15
Note! Both Flex Hours and Flex Balance Date needs to have a value for flex balance to be set in Bezala |
Flex Balance Date | From which date the flex balance is valid. DD.MM.YYYY so first of April 2026 would be 01.04.2026 |
Long Absence Type ::: long absence name | Please add all long absence names in separate columns. The value in the row should be the yearly separate saldo for that specific absense so e.g. a long absence called Extra holiday with a yearly saldo of 3 days should have the following:
Value in user row cell: 3 |
Download the sample file here: Mepco_4061_daily_document_2547659.csv
Download sample file with time and attendance columns: Mepco_daily_document.csv
Country code table:
Country name | Country code |
Argentina | AR |
Australia | AU |
Austria | AT |
Belarus | BY |
Belgium | BE |
Brasilia | BRA |
Brunei | BND |
Bulgaria | BG |
Canada | CA |
Chile | CHL |
China | CN |
Colombia | COL |
Croatia | HR |
Cyprus | CY |
Czech Republic | CZ |
Denmark | DK |
Estonia | EE |
Ethiopia | ET |
Finland | FI |
France | FR |
Germany | DE |
Greece | GR |
Hong Kong | HKG |
Hungary | HU |
Iceland | IS |
India | IND |
Indonesia | IDN |
Ireland | IE |
Israel | IL |
Italy | IT |
Japan | JP |
Jordan | JO |
Kazakhstan | KAZ |
Kenya | KE |
Latvia | LV |
Lithuania | LT |
Luxembourg | LU |
Malaysia | MYS |
Malta | MT |
Mexico | MEX |
Morocco | MAR |
Netherlands | NL |
Nigeria | NGA |
North Macedonia | MK |
Norway | NO |
Oman | OMR |
Peru | PER |
Philippines | PH |
Poland | PL |
Portugal | PT |
Romania | RO |
Russia | RU |
Saudi Arabia | SAU |
Serbia | RSD |
Singapore | SG |
Slovakia | SK |
Slovenia | SI |
South Africa | ZAF |
South Korea | KOR |
Spain | ES |
Sri Lanka | LKA |
Sweden | SE |
Switzerland | CH |
Taiwan | TWN |
Tanzania | TZ |
Turkey | TR |
UK | GB |
Ukraine | UA |
United Arab Emirates | AE |
United States of America | US |
Uruguay | UY |
Vietnam | VNM |
Connecting Bezala to your Mepco/Sympa Server
Connect your Bezala environment to Mepco/Sympa by activating the integration through the following path: Settings -> Integrations -> HR and Payroll Software -> Mepco. You can find instructions for that here: https://help.bezala.com/en/articles/140319-hr-integration-settings-mepco-sympa
Sending Mepco/Sympa files to Bezala's Server
If you don't have a server of your own, nor do you have a Mepco/Sympa server, you can ask our support to use our server. We will setup a server for you for an extra cost of 50€/month.
The timetable for the sync
Data will be fetched from Mepco/Sympa to Bezala automatically on a daily basis (Mon-Fri at 6.30 AM) after the connection with Mepco/Sympa has been established.