Export approved expenses to accounting (new version)

This article is intended for: 

Admin
Manager

Relevant module:

 

The accounting export of expenses generates a file to be imported into accounting software. This file can be in standard Excel format or in a specific format for the target accounting software.

200-2-1.gif

This article covers:

 

Accounting export of expenses

Access: Expense claims > Expense analysis / Accounting export

Choosing the expenses to export

In the filter area:

  • If necessary, restrict the results to a specific department or organisation
  • Select the 'Period' to export (e.g. 'this month')
  • Select the 'Status' of the claims to export, generally 'Approved', 'To be reimbursed' or 'Reimbursed', depending on the internal process for checking and paying expense claims
  • Check that the 'Tag' for the expenses is set to 'no tag'
  • Click 'Display'

Exporting in standard Excel format

  • Click the 'Excel Export' button on the right
1.jpg
  • Choose the desired export
  • A file in .xls format is downloaded automatically
  • Retrieve the file
  • Click the 'Actions' button
  • Select all items
  • Mark them as 'Exported to accounting' or 'Transfer order to be made'
2.jpg
  • Click 'Confirm' in the confirmation pop-up

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

Exporting in the software-specific format

  • Click the 'Accounting Export' button on the right
3.jpg
  • Select the desired accounting entry date; this will be included in the generated file
  • Enter the type of tagging to be applied under 'mark all items in the list as' ('exported to accounting' is recommended)
  • Click 'Accounting export'
  • The exported file has been downloaded to the computer

The export now appears in the export history at the bottom of the page. The file can be downloaded again by clicking the paperclip:

4.jpg

Keywords associated with this article: 

Expense claim - export of approved expenses - accounting export - sending reimbursed expense claims to accounting - Excel export - expense analysis

Was this article helpful?

0 out of 0 found this helpful

Comments

Please sign in to leave a comment.