Factorial allows you to export expense data for reporting, analysis, and accounting purposes. You can export either your current view or use the advanced export to access more filters and fields.
There are two main ways to export expenses:
- Export – current view → Quickly export the list as displayed on screen, including applied filters and selected columns.
- Advanced export → Customize filters, select additional fields, rename column labels, and reorder columns for deeper analysis.
Export – current view
- In your sidebar, go to Spending → Employee expenses → Expenses
- Click on the three dots
- Select Export view
Filters available:
- Approval date
- Category
- Creation date
- Document currency
- Document date
- Document type
- Expense type
- Owner
- Owner legal entity
- Payment
- Pending approvals
- Project
- Reimbursable currency
- Reported by
- Status
- Subproject
- Team
Columns shown by default:
- Alerts
- Amount
- Category
- Document date
- Owner
- Status
Optional columns you can enable:
- Creation date
- Document type
- Internal reference
- Payment method
- Reimbursable amount
This is the fastest option when you want a simple export of the table you’re currently viewing.
Advanced export
- In your sidebar, go to Spending → Employee expenses → Expenses
- Click on the three dots
- Select Advanced export
The Advanced export provides more flexibility, allowing you to rename columns, reorder them, and extract multi-level values (e.g., tax fields and approval dates for up to 5 approval levels).
Filters available:
- Approval date
- Category
- Creation date
- Document currency
- Document date
- Document type
- Expense type
- Owner
- Owner legal entity
- Payment
- Pending approvals
- Project
- Reimbursable currency
- Reported by
- Status
- Subproject
- Team
Extractable fields include:
- Alerts
- Approval date
- Approval level date (up to 5 levels)
- Base amount (up to 5 levels)
- Budget ID / Budget name
- Card last 4 digits
- Category / Subcategory
- Cost center
- Creation date
- Description
- Document amount, currency, date, number, type
- Employee bank account name / number
- End date / Start date
- Exchange rate
- Expense group ID / Expense ID
- Expense type
- Group ID / Group name
- Internal reference
- Link to Factorial
- Mileage rate, unit, total mileage, round trip
- Payroll cycle
- Project / Project code / Subproject
- Reimbursable amount / currency
- Rejection date / rejection reason
- Reported by
- Status
- Supplier TIN (tax ID)
- Tax amount and tax type (up to 5 levels)
- Vendor name
Use Advanced export when you need detailed, customizable datasets for financial reporting or audits.
If you need a more customized report, you can create one from Analytics using the widget builder, as long as it’s included in your plan.
Tips and Best Practices
- Use current view export for quick lists.
- Switch to Advanced export for finance reports, reconciliations, or when you need tax, multi-level approvals, or budget data.
- Rename and reorder columns in Advanced export to match your company’s reporting templates.
- Save your export files (CSV or Excel) in a secure location for compliance and audit purposes.
FAQ
-
Can I schedule automatic exports?
Not currently. Exports must be triggered manually.
-
What formats are supported?
Exports are available in CSV and Excel. Expense groups can also be exported as PDF.
-
Can I change the column order?
Yes, in the UI for current view, and in Advanced export for downloaded files.