Export Data Structure: Field Descriptions for Payroll File

Acubiz provides payroll-related data files to external payroll systems for managing payments and payroll deductions.

Note: The format description below is based on a standard setup. The format may vary and be customized depending on the specific payroll system receiving the data.

Transaction Types and Payroll Codes

The data file contains payroll-related transactions recorded in Acubiz. These are matched with the company's current payroll codes via three standard payroll codes:

• Payroll Code A: Employee Account Handles both payments and payroll deductions:

  • Cash expenses (payment)

  • Privately paid company credit cards (payment)

  • Private purchases on company-paid credit cards (payroll deduction)

  • Cash withdrawals on company-paid credit cards (payroll deduction)

• Payroll Code B: Tax-Free Mileage Allowance

  • Mileage according to government rates (payment)

• Payroll Code C: Tax-Free Travel Allowance

  • Per diem according to government rates (payment)

Standard File Format (Data Fields)

The payroll file contains at minimum the following seven columns:

However, Acubiz has specific formats for several payroll systems where the file may look slightly different from the example above, but the information remains the same.

Example of Payroll File (CSV Format)

The example below shows a generated payroll file with all transaction types:

04-10-2022;KBR;12345;Payroll Code A;;250,00;1
04-10-2022;KBR;12345;Payroll Code A;;-350,00;2
04-10-2022;KBR;12345;Payroll Code B;25;;3
04-10-2022;KBR;12345;Payroll Code C;;850,00;4

Display in column format