Export expenses, per diem and mileage allowance to payroll
Create a payroll file in Expense and import it into your payroll system, so that expenses, per diem and mileage allowance are paid out with the salary โ without manual registration.
๐ผ How export to payroll works
Expense collects all approved reimbursements in a payroll file that you import into the payroll system. The file can contain:
- ๐ฐ Private expenses
- ๐ Mileage allowance
- โ๏ธ Per diem
- ๐งพ Other reimbursements according to your setup, for example representation
๐ Applies to: administrators and payroll managers who pay out reimbursements through payroll. If you pay out through the bank instead, see Payment file to the bank โ BGC, ISO 20022 and SUS.
โ Before you start
- โ The expense reports are approved for export and the approval flow is complete
- ๐ The wage types are linked (see step 1)
- ๐ค The users have the right employee numbers
- ๐ The period for the payroll run is decided
โ๏ธ Step 1 โ Choose export format and check wage types
Done once at start-up and whenever something changes.
- Go to Accounting > Export to Salary.
- Choose the export format for your payroll system.
- Check that the wage types match the payroll system.
- Save.
โ The reimbursements end up on the right wage type when imported.
๐ Step 2 โ Start the export and enter the period
- Go to Accounting > Export to Salary.
- Enter the from and to dates.
- Enter the payment date.
โ ๏ธ The dates must match the expense reports in List All โ otherwise entries may be missing from the export.
๐ Step 3 โ Check the salary statement
Click Salary statement and check that:
- โ All entries are included
- ๐ฐ The amounts are correct
- ๐ฅ The right people are included
๐ค Step 4 โ Export the file
Click Export.
โ The payroll file is created and downloaded. Save a copy as documentation.
๐ผ Step 5 โ Import into the payroll system
- Log in to the payroll system.
- Choose import of payroll file and upload the file.
- Check the result and complete the payroll run.
โ The reimbursements are paid out with the salary.
๐ฅ Watch the walkthrough
โ ๏ธ Common errors
- ๐ซ The export cannot be created: check that the payroll format is activated, that the expense reports are approved for export and that the wage types are linked.
- ๐ The import fails in the payroll system: check the file format, the users' employee numbers and that the wage types match the payroll system.
- ๐ Entries are missing: check that the date range matches the expense reports in List All.
๐ก Tips for the best result
- ๐ Export well ahead of each payroll run
- ๐ Check the salary statement every time
- ๐งช Test the export format at start-up
- ๐ Review the wage types regularly
โ Frequently asked questions (FAQ)
What is included in the payroll export?
Expenses, mileage allowance and per diem, and other reimbursements depending on your setup.
Does the expense report have to be approved?
Yes, only expense reports that are fully authorized and approved for export are included.
Can I check before exporting?
Yes, through Salary statement.
What happens if the dates are wrong?
Entries may be missing from the export. Check the dates against List All.
Where do I set up the wage types?
Under Accounting > Accounts, on the Wage types tab. See Link wage types to your payroll system.
โ Summary
- โ๏ธ Choose the export format and link the wage types once
- ๐ Enter the right period and check the salary statement
- ๐ค Export and import the file into the payroll system
- ๐ฐ The reimbursements are paid out with the salary