File API - File types

[#1]

• File types
• Sandbox file types
• File API Sandbox Uploads
• File API Sandbox Downloads
• HR Core Payroll Business file types
• Batch Input format
• CSV file (one-off mutations)
• Journal entries
• Excel base document ( fixed/period)
• Payslips and Annual statements
• Tax declaration /Loonaangifte file types
• Payment manager/ Betaalmanager (NL) file types
• UPA file for Pension and Assurance 3rd parties using Keylane
• UPA file for Pension and Assurance 3rd parties using Other Side at Work
• Personneldossier

 

File types

Sandbox file types

File API Sandbox Uploads

Name	File API Sandbox Uploads
Business type id	7100
Type	Upload to YouServe
Owner	File API
Info	Type can be used to test the File API

File API Sandbox Downloads

Name	File API Sandbox Downloads
Business type id	7101
Type	Download to YouServe
Owner	File API
Info	Type can be used to test the File API

HR Core Payroll Business file types

Batch Input format

Name	Batch Input format (EN) / Batch input formaat (NL)
Business type id	113001
Type	Upload to YouServe
Owner	HR Core Payroll Business
Info	File Pattern: <TENANTID>_<OPTIONAL>.<EXTENSION> Description of this type can be found in the online help of HR Core Payroll Business. Search for the keywords: "externe systemen overzicht", and follow the "batch input" description. To configure this type, ask your (payroll) consultant or account manager. Extension can be configured per individual customer. This is customer specific. The content contains text-file. Mostly used is .dat type, but any type is possible.

CSV file (one-off mutations)

Name	CSV file (one-off mutations) (EN) / CSV bestand (dagmutaties) (NL) old name: Payroll EMA Imports
Business type id	113002
Type	Upload to YouServe
Owner	HR Core Payroll Business
Info	File Pattern: <TENANTID>_<COMPANYKEYCOD>_<OPTIONAL>.csv Description of this type can be found in the online help of HR Core Payroll Business. Search for the keywords: "externe mutaties" and follow the "CSV bestand (dagmutaties)" description. To configure this type, ask your (payroll) consultant or account manager.

Journal entries

Name	Journal entries (EN) / Journaalposten Export (NL)
Business type id	113003
Type	Download from YouServe
Owner	HR Core Payroll Business
Info	File Pattern: RPD.<TENANTID>.*.* Description of this type can be found in the online help of HR Core Payroll Business. Search for the keywords: "automatische journalisering". To configure this type, ask your (payroll) consultant or account manager. Extension can be configured per individual customer. This is customer specific depending on the financial application of the customer.

Excel base document ( fixed/period)

Name	Excel base document ( fixed/period) (EN) / Excel basisdocument (vast/periode) (NL)
Business type id	113016
Type	Upload to YouServe
Owner	HR Core Payroll Business
Info	File Pattern: <TENANTID>_<OPTIONAL>.<EXTENSION> Supported extensions: xlsx (Deprecated, still supported: <TENANTID>_<COMPANYKEYCOD>_<OPTIONAL>.<EXTENSION>) Description of this type can be found in the online help of HR Core Payroll Business. Search for the keywords: "externe mutaties" and follow the "Excel basisdocument" description. To configure this type, ask your (payroll) consultant or account manager.

Payslips and Annual statements

Name	Payslips and Annual statements
Business type id	113014
Type	Download from YouServe
Owner	HR Core Payroll Business
Info	File Pattern: RPD.Dossier.[tenantid].[mutkey of company]00[runnr payroll]_[current date and time in 'ticks'].zip One delivery contains: 1 zip file with the payslips or annual statements and 1 xml file which can be used as index file for the zip file. The zip file and the xml file have the same file name. Only the extension is different. To sent the files to File API, the configuration needs to be changed in HR Core Payroll Business. This configuration change is described in the online help of HR Core Payroll Business. Search for  the keywords: "Loonstroken en jaaropgeven naar File API". To configure this type, ask your (payroll) consultant or account manager.

 Tax declaration / Loonaangifte file types

Name	Tax declaration / Loonaangifte (NL)
Business type id	102000
Type	Download from YouServe
Owner	HR Core Payroll Business
Info	File Pattern: DECL.[tax declaration reference number].[yyyypp].[yyyyMMdd-HHmmss].txt Description of this type can be found in the online help of HR Core Payroll Business. Search for the keywords: "Kopie aangifte verzenden via File API ". Configuration is done per payroll tax number (loonheffingsnummer (NL)). To configure this type, ask your (payroll) consultant or account manager.

Payment manager/ Betaalmanager (NL) file types

Name	Payment files /  Betaalbestanden (NL)
Business type id	134001
Type	Download from YouServe
Owner	Payroll business
File Pattern	SEPA-[YouServe tenantId]-[messageId]-[IBAN number]-[yyyymmdd]_[hhmmss].xml Notes: [YouServe tenantId] = unique customer number [messageId] = payment message id example: SEPA-3333333-1286-NL72FVLB0138782523-20241008_113108.xml Description of this type can be found in the online help of HR Core Payroll Business. Search for the keywords: "Route betaalbestand". Configuration is done per checking account (betaalrekening (NL)). To configure this type, ask your (payroll) consultant or account manager.

UPA file for Pension and Assurance 3rd parties using Keylane

Name	UPA files Keylane
Business type id	141001
Type	Download from YouServe
Owner	Payroll business
Info	This file contains a set of employee data that can be used by pension providers and insurance companies to implement the pension regulations and process information about the premiums that have been withheld. The file complies with the so called "UPA-specifications" (Uniforme PensioenAangifte) as published by the Dutch SIVI organization. File pattern The file names matches this pattern: UPA_[Payroll tax number]_[Message ID]_[yyyymmddhhmmss]_UPA.xml Notes: [Payroll tax number] = Dutch [loonheffingsnummer] [messageId] = The message ID is composed as follows: [YouServe customer number]-[Payroll tax number]-[Sequence number]-[Declaration ID] example: UPA_123456789L02_1234567-123456789L02-1-87195_20250520100332_UPA.xml Configuration To be able to collect this file type using the File API, ask your (payroll) consultant or call our service desk. They can find the settings here:  User group: Uniforme pensioenaangifte Menu: Settings  > Declaration steering data (Instellingen > Aangifte stuurgegevens) There are two ways of working possible: If the original declaration has to be sent to the file API, and the organisation that picks up the file there will take care of all processing, choose: Aangifte verzenden via: File API Kopie Aangifte verzenden via File API: Nee If the original file has to go to the regular pension provider or insurer, and a copy has to be provided by the file API for additional purposes: Aangifte verzenden via: <choose the proper pension provider or insurer> Kopie Aangifte verzenden via Fila API: Ja Online help In the online help from HR and Payroll you can find more explanation, search for these keywords: (Dutch) Aangifte Aangifte verzenden Aangifte stuurgegevens

UPA file for Pension and Assurance 3rd parties using Other Side at Work

Name	UPA files Other Side at Work
Business type id	141003
Type	Download from YouServe
Owner	Payroll business
Info	This file contains a set of employee data that can be used by pension providers and insurance companies to implement the pension regulations and process information about the premiums that have been withheld. The file complies with the so called "UPA-specifications" (Uniforme PensioenAangifte) as published by the Dutch SIVI organization. File pattern The file names matches this pattern: UPA_[Payroll tax number]_[Message ID]_[yyyymmddhhmmss]_UPA.xml Notes: [Payroll tax number] = Dutch [loonheffingsnummer] [messageId] = The message ID is composed as follows: [YouServe customer number]-[Payroll tax number]-[Sequence number]-[Declaration ID] example: UPA_123456789L02_1234567-123456789L02-1-87195_20250520100332_UPA.xml Configuration To be able to collect this file type using the File API, ask your (payroll) consultant or call our service desk. They can find the settings here:  User group: Uniforme pensioenaangifte Menu: Settings  > Declaration steering data (Instellingen > Aangifte stuurgegevens) There are two ways of working possible: If the original declaration has to be sent to the file API, and the organisation that picks up the file there will take care of all processing, choose: Aangifte verzenden via: File API Kopie Aangifte verzenden via File API: Nee If the original file has to go to the regular pension provider or insurer, and a copy has to be provided by the file API for additional purposes: Aangifte verzenden via: <choose the proper pension provider or insurer> Kopie Aangifte verzenden via Fila API: Ja Online help In the online help from HR and Payroll you can find more explanation, search for these keywords: (Dutch) Aangifte Aangifte verzenden Aangifte stuurgegevens

Personneldossier

Name	Personnel dossier import
Business type id	107000
Type	Upload to YouServe
Owner	Personnel dossier (PDOL)
Info	File Pattern: *.zip Info:  Personnel File imports documentation