Acubiz provides 2 types of salary related data files
Note. The format description below is based on a basic set-up and may vary depending on the specific payroll system for which data must be supplied. As a starting point, the basic information for a salary system is described below |
Salary file 1: Payouts and deductions (EMS)
A salary file for payments and salary deductions will contain information about the following salary-related transactions created in Acubiz, based on salary types/salary codes from the company's current salary system. There are a total of 3 salary codes used in Acubiz
- Salary code A:
Temporary employee (must be able to handle both payment and salary deductions)- Cash expenses for reimbursements (Payout)
- Privately paid company credit cards (payout)
- Private purchases on company-paid company credit cards (payroll deductions)
- Cash withdrawal on company-paid company credit cards (payroll deductions)
- Salary code B:
Tax-free driving allowance according to government's rates (Payout) - Salary code C:
Tax-free travel allowance according to the government's rates (Payout)
The format for salary contains at least 7 pieces of information
- Column 1: Date
- Column 2: Employee initials
- Column 3: Employee number (salary number)
- Column 4: Salary code (A, B or C depending on transaction type)
- Column 5: Units
Only the number of kilometers driven is indicated on the tax-free driving allowance and the payroll system calculates the correct amount for payment. - Column 6: Amount
There will be no amount of tax-free driving allowance. - Column 7: Line number
However, Acubiz has specific formats for several payroll systems, where the file may look slightly different from the example above, but the information is the same. This applies to pay systems such as: Visma pay (formerly Multiløn Erhverv), Visma Dataløn, LESSOR pay, Danløn etc.
Example of salary file with all entries included.
04-10-2022;KBR;12345;Lønkode A;;250,00;1
04-10-2022;KBR;12345;Lønkode A;;-350,00;2
04-10-2022;KBR;12345;Lønkode B;25;;3
04-10-2022;KBR;12345;Lønkode C;;850,00;4
Display in column format
Data values are provided as follows:
- Amount: Decimal point is a comma "," Ex. 199,45
- Date: (dd-mm-yyyy) eg 01-01-2022
There are options for different date and amount settings.
Other salary systems:
Salary file 2: Timeregistration records (TIME)
A payroll file for time registrations will contain information about the time registrations made in Acubiz. In connection with time registration, different registration categories are created in Acubiz, each of which contains the specific wage code.
The format for time registration contains at least 6 pieces of information
- Column 1: Date
- Column 2: Employee Initials
- Column 3: Employee number (salary number)
- Column 4: Salary code (The registration category determines the salary code)
- Column 5: Units
- Column 6: Line number
For example, the following time registration categories for absence can be created in Acubiz:
- Registration of holidays taken:
Pay code: HOLIDAY(Unit is Days) - Registration of hours
Wage code: HOURS (The unit is hours) - Registration of illness
Salary code: SICK (Unit is Days)
Eksempel på fil:
04-10-2022;KBR;12345;HOLIDAY;2;1
04-10-2022;KBR;12345;HOURS;7;2
04-10-2022;KBR;12345;SICK;3;3
Visning i tabel format
Comments
0 comments
Please sign in to leave a comment.