How to: Run a Tiered Report (UK)

Let MileIQ keep track of all your vehicles and the different mileage rates associated with each one. With a tiered report, tracking business drives driven within and above 10,000 miles is automatic.

We offer two seamless ways to get your drives emailed to you: from within the mobile app or directly from the MileIQ web dashboard at dashboard.mileiq.com.

The tiered report will get sent to your email address on file and allows you to easily edit the business rate for different vehicles and tiers. The reports are in a XLS format which can be opened by any spreadsheet program (such as Microsoft Excel, Apple Numbers, and Google Docs).

Mobile App

From the mobile app, tap on the Reports button at the top right of the screen

Then, select the year or month for which you would like to receive your recorded drives. That’s it! Check your inbox for an email with a downloadable XLS file.

Web Dashboard

To print a tiered report from the MileIQ web dashboard, first sign in at dashboard.mileiq.com with the same email and password you use for the app.

british_dashboard_login.png

Once logged in, make sure all the drives you want to report are classified to ensure maximum business drive reimbursements. Drives that are not classified will not be included in the monthly tiered reports.

british_drives.png

Then, there are two ways to request an annual or monthly tiered report to your email address, from the Drives View or the Reports View.

Creating a Report from the Drives View

In the Drives View of the web dashboard, click the Date Filter and then use the drop-down calendar to select the month or year you wish to run a report for. You can also use preset filters like "This month" or "Last year" to pick a date range. Note that you'll need to select a start date AND an end date for a custom range.

british_dates.png

After selecting the drives you would like to report, a drive card will appear in the right-hand pane of the dashboard. Click the ‘Report’ button below the drive details in the drive card.

british_selection.png

This will bring up the Report Creation window, where you'll name the report, select a delivery method, specify a custom rate for your business kilometres (optional) and add other optional details.

Creating a Report from the Reports View

You can also create reports using the Report Builder in the Reports View. Easily access the Reports View by clicking the Reports Tab at the top of the page.

reports_red_rectangle.png

You'll use the Report Selectors to select a set of drives to include in the report. You can also use preset filters like "This month" or "Last year" to pick a date range. Note that you'll need to select a start date AND an end date for a custom range.

british_reports_numbered.png

After selecting the date range of the drives you would like to report, click “Create this report.” This will bring up the Report Creation window, where you'll name the report, select a delivery method, specify a custom rate for your business kilometres (optional) and add other optional details. Afterwards, check your Mail Inbox for an email with a downloadable XLS file with either your year-to-date or monthly drives report.

Monthly/Annual Tiered Report

After receiving your monthly/annual mileage report in your Inbox, please click on the ‘Detailed log of your drives (.xls)’ button to open a tiered monthly/annual XLS report.

After opening the report, you will see a ‘Total Miles Logged Outside of MileIQ’ and a ‘Mileage Rates Input’ table on the top left.

british_XLS_squares.PNG

You can adjust the business mileage rate for the different vehicles and tiers by editing the values within the the ‘Mileage Rates Input’ table.

The reimbursement rates that are used to calculate the value of business drives for cars/vans, motorcycles, and cycles are set by default to the HMRC standard rate of 45p, 24p, and 20p per mile, respectively, for the first 10,000 miles. For business miles above 10,000 miles, the standard rate for cars and vans, motorcycles, and cycles are 25p, 24p, and 20p per business mile, respectively.  

If you have been logging miles prior to using MileIQ, simply fill in the miles in the ‘Total Miles Logged Outside of MileIQ’ table. Once you input the numerical values, the report will take into account the miles logged outside of MileIQ into the amount of business miles driven. However, MileIQ will not add the value of these business miles logged outside of MileIQ into the total value of your business drives in this report. The report only calculates the values of the drives logged within MileIQ.

Within the report, the ‘Rate Tier’ column shows the value ‘1’ if the drive is within the first 10,000 business miles recorded for a specific vehicle type. For all drives over 10,000 business miles, the value ‘2’ is shown to indicate that the ‘Over 10K Miles’ rate for a specific vehicle is used to calculate these business miles. The monthly tiered report will take into account business miles recorded by MileIQ from previous months.

british_tiers.png

NOTES:

  • Tiered mileage reports can only be generated in the XLS format. PDF reports will not take into account the different values of business drives over 10,000 miles. In addition, PDF reports do not take into account the different vehicle rates for the first 10,000 miles.
  • The ‘Total Miles Logged Outside of MileIQ’ and the ‘Mileage Rates Input’ tables will not be included in the printed mileage report.
Was this article helpful?
1 out of 1 found this helpful