Glossary for custom export formats

👉 Applies to: administrators who set up a custom export. The feature is activated through support.

Field	Means
Booked amount incl. VAT	Accounted amount including VAT
Booked amount excl. VAT	Accounted amount excluding VAT
VAT	VAT in local currency
VAT code	Code according to the VAT settings
Currency	The currency of the transaction
Exchange rate	The rate at the time of purchase

Field	Means
Transaction date	Date of the purchase
Created date	Date the entry was created
Voucher date	Date of accounting or export
Export date	Date the export is made
Export date with line number	Export date followed by the line number
Export period	Period based on the fiscal year
Export file number	Sequential number of the export (1, 2, 3 …)
Line number	The row in the export (1, 2, 3 …)
ID	The expense report's unique number in Expense

Field	Means
Company name	The company's name
Organization/registration number	The company's registration number
Company code	Value set by Expense Support
Hardcoded value	A fixed value that is always printed, for example ”General Ledger”

Field	Means
Belongs to – first name / last name	The user's name
Employee number	The user's employee number
Employee code	The user's employee code

Field	Means
Account number	Account from the chart of accounts
Account description	The account's name
Internal accounts (shown with their names)	For example cost center or project
Wage type (purchase)	Wage type linked to the purchase amount
Wage type (settings)	Wage type linked to the account
Wage type amount	Amount paid out

Field	Means
Place of purchase	Where the purchase was made
Location/city	City of the purchase
Comment	The user's comment
Accounting name	Invoice number or name of the travel expense report
Travel start time	When the travel started
Travel end time	When the travel ended
Travel deductible	The part of the travel that is deductible
Mileage – travel date	Date of the travel
Mileage – number of km	Number of kilometers
Mileage – tax-free / taxable	Tax-free and taxable part

Do I have to use all fields?
No, only choose the fields your system needs.

How do we get access to Create a custom export format?
Contact support and we will activate the feature.

With Create a custom export format, you decide which fields to include in the export file to your accounting or payroll system. Here all the fields are explained, grouped by type.