Records of all company expenses for a specified period can be exported from the Expend dashboard. The records are exported to a CSV file. You can also choose to have all receipts and any other files you attached to expenses exported at the same time.
What is exported
As a user with the Administrator role (or the Accountant role), all expenses submitted by all members of your organisation are exported.
If you belong to more than one organisation
Expenses are exported for the company that is currently active on the dashboard. The current company is shown in the upper right. To change companies, click the current company's name and select another company from the pop-up list.
Members of multiple companies: Ensure that the company for which you want to export expenses is selected in the upper-right corner of the dashboard.
In the dashboard menu, click Reporting and then click Exports.
Go to the Expenses section.
Select the type of expenses to include by turning the switches on or off.
Select a date range. All expenses between and including these dates will be exported.
Select the Format:
- Default (CSV) to only export records of the expenses to a CSV file, or
- Expenses & Receipts (ZIP) to export the CSV as well as all attachments.
In the Expenses section, click Download.
Note about the file format
Each record appended with links to the documents attached. If an expense record has more than one attachment, they are separated by commas. This means that each will appear in a separate column when imported into a spreadsheet application.
For more details, also see CSV export formats.