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
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.Click “Download”
In the top-right corner of the Reports page, click Download. Then, under Consolidated report, select Create a report.-
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.
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.