Export approved expenses to accounting

Related module:

In this article:

• Accounting export of expenses
  • Selecting expenses to export
  • Export in standard Excel format
  • Export in software-specific format

Accounting export of expenses

Access: Expense Reports > Analyse des dépenses / Export compta

Selecting expenses to export

In the filter area:

• Restrict if needed to a specific department or structure
• Select the 'Période' to export (e.g.: 'ce mois-ci')
• Select the 'Statut' of requests to export, usually 'Validée' or 'A rembourser' or 'Remboursée' depending on internal control and payment processes for expense reports
• Verify that the 'Marque' of expenses is set to 'aucune marque'
• Click 'Afficher'

Export in standard Excel format

• Click the 'Export Excel' button on the right

• Select the desired export
• A file in .xls format is downloaded automatically
• Retrieve the file
• Click the 'Actions' button
• Select all items
• Mark as 'Exporté en compta' or 'Ordre de virement à effectuer'

• Click 'Confirmer' in the confirmation pop-up

This indicates to the software that the expenses have been sent to accounting. They will not be offered during the next export. The expenses disappear from the expense details because the filter area is set to the mark 'aucune marque'.

Export in software-specific format

• Click the 'Export Comptable' button on the right

• Select the desired accounting entry date; it will be included in the generated file
• Enter the type of marking that will be performed in 'marquer tous les éléments de la liste comme' ('exporté en compta' is recommended)
• Click 'Export comptable'
• The exported file is downloaded to your computer

The export now appears in the export history at the bottom of the page. You can download the file again by clicking on the paperclip icon:

Keywords associated with this article: 

Expense report - export approved expenses - accounting export - sending reimbursed expense reports to accounting - Excel export - expense analysis