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

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!

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.

Summary: not really, but we call the data you can download to produce one a "report" anyway.

I don't have the Download Trips button in my online Quickbooks. Is there another way to do this?

Hello, shannondaily. 

In QuickBooks, you can also view the Download Trip under Add trip drop-down arrow. Please view the screenshot attached for your visual reference:  

However, If you still unable to view the Download Trips, let's access your account using a private browser or an incognito window. This is to check if the missing Download Trips button has something to do with the browser you're using or your subscription. This browsing doesn’t store data and will help the page load without issues from temporary data.

Let me guide you how: 

• Press Ctrl + Shift + N (Google Chrome).
• Press Ctrl + Shift + P (Mozilla Firefox).
• Press Command + Shift + N (Safari). 

Next,  clear the cache of your regular browser to start on a clean slate. This process helps the browser to fetch the latest version of the webpage and a faster browsing experience. You can also use other supported, up-to-date browsers to roll out the possibility of a browser-related issue.

You can read through these articles to learn more about this new mileage feature: 

• Tracking your Mileage
• Automatically Track Mileage
• Fix mileage tracking issues in the QuickBooks Online mobile app 

Let me know how it goes after trying the above steps as I want to ensure this is resolved for you. Take care and have a great day ahead.

Where is the download in trips in order to create an excel file?

Hello there, @rowan3.

I'm here to provide you steps on how you can download trips in order to create an excel file. Let me show you how.

Click the the Mileage from the left menu, then tap the dropdown arrow beside the Add trip button and select the Download trips option.

See the screenshot below for your reference.

Also. I'll add this article on how to track multiple vehicles in QuickBooks Online: Manually track mileage for multiple vehicles.

You can read through these articles to learn more about how the mileage feature works:

• Automatically track mileage in QuickBooks Online
• QuickBooks can do WHAT? Tracking your mileage

Feel free to comment down below if you have any other concerns or questions about downloading your trips in QuickBooks. I'm always glad to help in any way I can.

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?

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. 

You need to please add the start and end times. Thank you.

Thanks for joining the thread, @Diakoneo. I wan to make sure we're able to achieve your goal for today.

Can you please provide more information on what you're trying to accomplish? This way. we can take a look an it and assist you further.

We're looking to hearing from you on this. We're more than happy to guide you more with this matter or QuickBooks. Have a good one and take care!

When you are in QuickBooks under the mileage feature the data displayed shows the start time and end time for your travel. When you export (Download) the data, the CSV file does not contain the time stamps, it only provides the dates. If you travel multiple times during one day having the timestamps in the export is helpful. Please consider adding the timestamps to the exported data set.

Good morning, @Diakoneo. 

Thanks for replying back on this thread! 

This feedback would be beneficial to our Product Developers so they can consider adding this within the feature. Here's a guide to help: 

Submit your feedback

Feel free to come back if you have any other concerns. We're always here to lend a helping hand. Take care! 

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.  

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.

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

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

• Automatically track your mileage.
• Set up mileage tracking and vehicles in QuickBooks Online

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

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

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

Thanks for joining this thread, @acphoto71. Let me chime in and share information on how QuickBooks generates a mileage report.

When accessing a mileage report, QuickBooks Online automatically downloads all your trips based on the period you’ve set under the Tax Year dropdown menu. Thus, creating a statement that only shows business mileage isn’t possible.

You may consider modifying the data in Excel to exclude your personal mileage. This way, you can make a straightforward business mileage report.

These articles offer tips and tricks to keep your records organized and help you get the deductions you deserve:

• Automatically track mileage in QuickBooks Online
• QuickBooks can do WHAT? Tracking your mileage

Please let me know if there's anything else that I can do to help. We’ve got you covered, @acphoto71.

Okay, thank you!

Hello there, @acphoto71.

I'm happy that the information provided by my colleague helped create a mileage report within QuickBooks.

You're always welcome to post here in the Community space. Count us in if you need additional help with any QuickBooks Online-related. We're always ready to assist. Take care, and have a great day!