Analytics - Overview

Analytics gives you a clear picture of your organisationโ€™s business expenditures. You can run customized analytic reports to get insights of your business performance and your employees' spending. For example, if you would like to know the expenses incurred by your organization in the month of June, you can run an Expense Details report. All the expenses that were incurred in the month of June along with the amount spent and the users who have incurred the expenses will be generated as a detailed report for you.

Also, you can customize the analytic reports to analyze your expenses better, according to your business needs. You can add additional filters based on which details will be generated and you can add the columns that you want to include in your analytic reports.

Generate Analytic Report

You can generate any of the analytic reports listed in the Analytics page.

Prerequisite: Unsubmitted reports will not be considered for running the analytics.

To generate an analytic report:

  1. Go to Analytics on the left sidebar.
  2. Click the analytic report you want to view.
    Generate Analytics
  3. If you want to generate the analytic report for another time period with additional filters, you can customize it.
  4. The selected analytic report will be generated with the applied customization.

Customize Analytic Report

Zoho Expense lets you customize the analytic reports based on your business needs. You can add filters, choose the columns that have to be displayed in the analytic reports etc.

To customize an analytic report:

  1. Go to Analytics on the left sidebar.
  2. Click the analytic report you want to customize.
  3. Click Customize at the top of the page.
    Customize Analytics
  4. Enter date range and customize the values filled in the other fields, if required.
  5. If you want to add more filters in the report, click + Add More at the end of the page.
  6. If you want to reset the filters you’ve added, click Reset Filters at the top right side of the page.
  7. If you have configured tags, click Filter by Tags to filter details according to the selected tag.
    Customize Analytics

To choose the columns that have to be displayed in the report:

  1. Click the Show/Hide Columns button at the top of the page. All the columns that can be added to your analytic report will be shown in the left side table and the columns that are already added to your analytic report will be shown in the right side table.
  2. Drag and drop the columns you want in your report from the left side table to the right side table. You can also hover over a column name in the left side table and click the button to add a column in your report.
    Customize Analytics
  3. If you want to remove a column, hover over a column name in the right side table and click .
    Customize Analytics
  4. Click Run Report to view the customized analytics.

Export Analytic Report

In Zoho Expense, you can export your analytic report in any of the following formats:

PDF CSV XLS or XLSX

To export an analytic report:

  1. Go to Analytics on the left sidebar.
  2. Click the analytic report you want to export. Customize it if required.
  3. Click the Export As dropdown at the top right corner of the page. Select the format in which you want to export your analytic report. You can also export your analytic report to Zoho Sheet and make use of the customizations available in Zoho Sheet.
    Export Analytics
  4. If you want to protect this file with a password, mark I want to protect this file with a password option and enter a password with at least 6 characters.
  5. Click Export to export the analytic report.
    Export Analytics

To print an analytic report:

  1. Go to Analytics on the left sidebar.
  2. Click the analytic report you want to print. Customize it, if required.
  3. Click Print on the top right side of the page. Print Analytics
  4. Click the icon on the top right side of the page and configure your preferences. Print Analytics
  5. Click Print to print the analytic report.

The following are the various categories for which you can generate analytic reports:

List of Analytic Reports

Expense

Reports

Trips

Activity

Get a personalized demo from our experts

By clicking Submit, you agree to our Privacy Policy.