Review expense analytics and export to CSV
See what your business spends, by month, status, category and vendor, and download the expenses you need as a spreadsheet.
- What you'll achieve: A clear picture of your spending, and a CSV file of the expenses you chose for your accountant or your own checks.
- Who can do this: Expenses: Read
- Time: about 3 minutes
Before you start
- Expenses have been recorded (see "Record an expense and send it for approval").
Steps
1. Open Expense Analytics
In the sidebar, open Expenses and select Analytics. The cards show Total Expenses, Total Records, Pending Approval and Approved Total.
Tip: Totals are in your company's base currency, so expenses paid in another currency are converted.
2. See where expenses are in approval
Status Distribution splits your spending into Paid, Approved and Pending Approval. Rejected and Draft expenses are shown as Not counted as spend.

3. Read the monthly trend
Monthly Expense Trend shows the amount spent each month, with the number of expenses as a second line.
4. Compare categories and vendors
By Category shows the total and the number of expenses in each category. Top Vendors ranks the suppliers you spend the most with.
Tip: Expenses saved without a category are grouped as Uncategorized. Edit them to give them one.

5. Go to the expense list
To export expenses, open Expenses to see the list.
6. Choose what to export
Select a status tab, such as Approved, or type in Search expenses.... The export contains exactly the expenses the list is showing, across every page.

7. Export to CSV
Select Export CSV. A file with each expense's number, title, vendor, category, date, amount, currency and status downloads to your computer.
Tip: Open the file in Excel or Google Sheets, or send it to your accountant.

Troubleshooting
"No data to export"
The list is empty for the tab and search you chose. Select All and clear Search expenses..., then try again.
Export CSV is greyed out.
The list couldn't load. Refresh the page; when the expenses show again, the button works.
There's no Export CSV button.
You need the Read right on Expenses. Ask your administrator.
