Solved

Is there a mileage report in quickbooks online? If so, where is it located?

Forum|Forum|5 years ago
February 20, 2021
3 replies
0 views

I've added mileage to track my vehicle business use, but I cannot find any reports to send this information to my accountant.

QuickBooks Online

Best answer by Maybelle_S

Glad to have you here in the Community, @dr-bjarnason.

In QuickBooks Online, the mileage report can be pulled up by clicking on the Download Trip button from the Trips page. This will open a report in an Excel file that shows all the trips that you've entered.

To do that, just open the trips page and press on Download Trips. Please see the screenshot attached for your reference:

You may also want to check the reports available for your version in QBO.

I've also added these articles about maintaining mileage, fixing some issues, and other topics.

Know that you can always get back to me if you need anything else. I'll be around to lend a helping hand. Have a nice day!

M

Maybelle_SAnswer

Glad to have you here in the Community, @dr-bjarnason.

In QuickBooks Online, the mileage report can be pulled up by clicking on the Download Trip button from the Trips page. This will open a report in an Excel file that shows all the trips that you've entered.

To do that, just open the trips page and press on Download Trips. Please see the screenshot attached for your reference:

You may also want to check the reports available for your version in QBO.

I've also added these articles about maintaining mileage, fixing some issues, and other topics.

Know that you can always get back to me if you need anything else. I'll be around to lend a helping hand. Have a nice day!

M

Maybelle_S

Hi, @dr-bjarnason.

Hope you’re doing great. I wanted to see how everything is going about the mileage report that you had the other day. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

Looking forward to your reply. Have a pleasant day ahead!

D

dr-bjarnasonAuthor

Thank you for your reply. I did use the "download trips" button; however, this report does not give any details or totals...just a list of trips made. I was hoping there was an actual report w/ total miles driven, total business miles, % of business miles, etc. A screen shot of the Mileage dashboard will suffice. Thanks again for your help.

J

journeysofhealing

Is there a way to run a mileage report that lists mileage for a defined date range? Like a report for the month of March?

TiedemanCleaning

When you go into the mileage, under Tax Year, there is an option to chose custom date. Click Custom date and then you can pick your date range. Once you have your date range chosen, you then click download trips and it will only download the trips for that date range.

A

acphoto71

What about creating a report that only shows business mileage, not personal?

T

tojoproperties

When I try to download trips, I get a new file, but it is not in a readable form. not a csv, pdf or anything.

D

DebSheenD

Hello there, @tojoproperties.

I understand the importance of downloading trips in QuickBooks Online (QBO). I'm here to help you fix this.

Beforehand, may I know what is the file format you're trying to download? Thus, downloading the trip needs to be in a CSV format.

We can download the trips using an incognito or other browser. Here's how.

Log in to your account using a different browser.
Go to Expenses, then click Mileage.
Choose the drop-down arrow next to Add Trip.
Hit Download trips.

Additionally, let me share this article to help manage mileage in QuickBooks:

Keep me posted if you have further concerns with your mileage. I'll be around to help always. Take care!

A

acphoto71

Is there a way to generate a report for business trips only, excluding personal mileage?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded