In Apperio you can export all the matters that contribute to the total spend on the spend overview and matters page into an Excel file.
Exporting the Spend Overview
Exporting the spend overview allows you to view the data across all matters for your connected law firms. Navigate to the spend overview and select the download button to export the data.
Use the date picker to select a date range to choose the data you want to export, or apply filters to the page using the filters icon.
You can filter the spend overview by folder name, law firm, fee structure and any other matter property that you have configured for your business. Alternatively you can export the dashboard entirely without applying any filters.
Select the download button on the top right hand side of the page to export the data. All matters exported correspond to the total spend viewed on the spend overview.
Once the file is exported, the cover page tab shows the details of the export including the date range selected, name of filters applied and the total number of matters.
On the results tab is a list of all the matters and you can apply your own pivots to the data in Excel. Here you can view the billed and WIP totals alongside all the matter properties. Totals are provided in both your business currency and the matter currency. These are for work done between the dates selected in your filter, which may not be the full total for any matter listed if spend was incurred outside of those dates.
Exporting the Matters List Page
You can also export all the matters that make up the matters list page in Apperio. Exporting data from the matter list provides you with a complete summary of your data, across all your matters in Apperio. To do this, navigate to the matters page from the side menu.
On the top right hand side of the screen select the download button to export all matters from the list to excel.
The cover page provides you with an overview of all the matters exported from the list including the total number of matters and a breakdown of filters applied. On the results tab is a list of all matters in Apperio, here you can apply your own pivots across fields and columns.
Exporting the Invoice List Page
Data related to your invoices can be exported to excel from the invoice list page. This gives you a complete summary of all invoice information related to your business in Apperio.
Select the invoice page from the side menu and set a date range for the data to be exported. You can narrow down the data in the export by filtering by invoice status, law firm and other categories.
Select the download button to export invoices to excel.
The cover page shows you the total number of invoices exported and the results tab includes all information associated with the invoices.
If your business uses the Apperio Invoice review & approval workflow, the following fields will appear on your invoice:
- Status - The status of the invoices in the approval workflow (paid, queried, approved etc.)
- Requires Approval from - The approver of the invoice in its current status
- Invoices via Apperio - A Yes/No indication as to whether the law firm uploads PDF invoices to Apperio.