MileIQ for Teams: How do I create a consolidated mileage Report?

  • Updated

Creating a consolidated report in MileIQ is quick and simple. These reports provide a summary of the total mileage and reimbursement amounts for every driver on the team, broken down by week, two-week period, or month. It’s useful when you want a single overview for payroll, reimbursement, or auditing.


How to Create a Consolidated Report

  1. Access the Teams Dashboard
    Go to your Teams Dashboard at https://dashboard.mileiq.com/teams/ and click on the Reports tab from the left-hand menu.

  2. Click “Download”
    In the top-right corner of the Reports page, click Download. Then, under Consolidated report, select Create a report.

  3. Set Your Report Parameters
    Choose the specific details you'd like included in the report:

    • Time frame: Select the start and end dates for the report.

    • Summary format: Choose whether to display total mileage as weekly, bi-weekly, or monthly summaries.

  4. Download the Report
    Once your parameters are set, click Download CSV to generate and download the report.

What’s included in a consolidated report

The CSV file contains:

  • Report details at the top: the report timeframe (from–to), the format you chose, and a note that partial weeks or months are pro-rated.
  • A combined report table with one row per driver, showing:
    • Name, Email, and Status (active, invited, or expired)
    • A pair of columns for each period in your date range: the reimbursement amount ($) and the distance (mi or km). For example, Week 1 $ and Week 1 mi, or Jan $ and Jan mi for monthly reports.

💡 Tip: Use spreadsheet tools like Excel or Google Sheets to further analyze or format the data.