Generating a custom export format

Do you want to export your expenses to an accounting programme for which there is no webservice link, or do you want to export the data to a Excel file for your own specified overview?
You can generate a custome export format to accomodate these needs.

Go to Admin > Advanced > Export formats

Click on 'Add' to generate a new format. 

In the first tab you can define the type of file (Excel, SCV or XML) and name the file. 

Settings


Depending on the chosen file type different options will be shown. Below you can see the options if you chose a CSV file. 

 

You can choose the desired seperator, decimal seperator and line ending format. Furthermore you can choose if you want to quote all text cells (to facilitate the import in a different program), if you want to show column titles in the first row and if you want to adhere to a seperate header row (for example for a journal entry). 

 

Selection


In this screen you can indicate which expense types you want to include in the export format. If you do not make a selection all types will be included. 

Furthermore you have option for mileage expenses to export taxed/untaxed amounts on a seperate row. 

 

Data

In the tab Data you can indicate which types of data you want to export form Declaree. In the overview you can see which data corresponds to which column in the CSV file.