- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Is there a mileage report in quickbooks online? If so, where is it located?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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.
- Automatically track mileage in QuickBooks Online
- QuickBooks can do WHAT? Tracking your mileage
- Fix mileage tracking issues in the QuickBooks Online mobile app
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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
Summary: not really, but we call the data you can download to produce one a "report" anyway.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
I don't have the Download Trips button in my online Quickbooks. Is there another way to do this?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
Where is the download in trips in order to create an excel file?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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:
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
You need to please add the start and end times. Thank you.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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:
Feel free to come back if you have any other concerns. We're always here to lend a helping hand. Take care!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
Is there a way to generate a report for business trips only, excluding personal mileage?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
What about creating a report that only shows business mileage, not personal?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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:
Please let me know if there's anything else that I can do to help. We’ve got you covered, @acphoto71.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
Okay, thank you!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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!