Export expense reports to Excel
Do you want to sort, filter or analyze expense reports outside Expense? Activate Excel as export format and export one or more expense reports to an .xlsx file.
🔍 Excel export or statistics report?
| Excel export | Statistics report | |
|---|---|---|
| What is exported | Expense reports within the chosen date range | All expenses and accountcodings for a period |
| Format | Excel (.xlsx) | Tab-separated text file (TSV) |
| Fits for | Following up specific expense reports | Analysis and budget work |
👉 Applies to: administrators, finance managers and auditors.
⚙️ Step 1 – Activate Excel as export format
- Go to Administrate > Settings and select the Import & Export tab.
- Choose one of the Excel formats. There are 15 different Excel formats with different content.
- Click Save.
💡 Not sure which format fits? Ask Expense support for the file definitions, so you see exactly what each format contains.
📤 Step 2 – Export expense reports
- Go to Accounting > Export to Accounting.
- Choose the from and to dates and the verification date.
- Click Export.
✅ The file contains, for example, date, user, amount, accounting and internal accounts. The exact content depends on which Excel format you use.
💡 In Excel, you can use filters and pivot tables to sum up costs per user, project or period.
🛠️ If something does not work
| Problem | Check |
|---|---|
| The export fails | That you have the right permission and that the Excel format is activated |
| The file does not open | That the file has downloaded completely and is not blocked by the computer's security settings |
If the problem remains, contact Expense support.
❓ Frequently asked questions (FAQ)
Can I export several expense reports at once?
Yes, all expense reports within the chosen date range end up in the same file.
Can the export be automated?
It depends on your setup and integrations. Contact Expense support.
✅ Summary
- ⚙️ Activate Excel under Administrate > Settings > the Import & Export tab
- 📤 Export under Accounting > Export to Accounting
- 📈 Analyze with filters and pivot tables