Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello there, @Annastasia.
Let me share some clarification about importing mileage data from a CSV file.
Currently, the option to import mileage data to QuickBooks Online (QBO) is unavailable. For now, the only available method is to add the previous trips manually into the system.
To track business miles using the app, use your QBO login, and follow these steps:
I appreciate your input about being able to import mileage data into the system. We continue to improve the QuickBooks features, and this preference might be available in the future.
While we assess this option, I recommend you visit our QuickBooks Blog to stay up-to-date with all the changes.
You can also check this article for more details about tracking mileage in the Online version: Automatically track mileage in QuickBooks Online.
Please let me know if you need anything else. The Community and I will be here to help you.
Since we do not use the feature your talking about is there anyway someone can import them for me as I am not able too. We need to have this feature and not be limited to only one way to track mileage.
Hi there, @Annastasia.
I understand how important this file in your QuickBook.
CSV files can only be used when importing transactions and lists in QuickBooks Online. See Common questions about importing data to QuickBooks Online article for more details about the importing process. Visit our Bring in your data page for more insights about importing your data.
To learn more about this one, check out these articles for more details:
I'll be right here to continue helping if you have any other concerns or questions about QuickBooks. Assistance is just a post away. You have a good one.
Yes you can - sort of.
If you want to import historical mileage from QB desktop to QB online (as I did), try this:
(1) In QBD, run up the Mileage by Vehicle Detail Report (Mileage, Mileage Reports, Mileage by Vehicle Detail)
(2) Choose the time frame for the report (I chose All)
(3) Under the Excel menu, choose Create New Worksheet
(4) Give it a name and IMPORTANT - choose "Create a comma separate values file"
(5) Now open the file and massage it so that you have the following column headers:
Date, Type, Trip Purpose, Vehicle, Start Address, End Address, Distance, Deduction, Logging Method
(6) I used the following example info in mine:
01/04/2021, Business, Site Visit, XC12 ABC, NA, NA, 175, 0, Manual
(All rows in my file had Business, Site Visit, XC12 ABC, NA, NA, 0, Manual column entries, only things changed were Distance and Date)
(7) In QBO, go to Mileage, click on arrow next to Add Trip, then Import Trips
(8) Select and Import the CSV file, and you should be good !
Why on earth Intuit couldn't add an import of mileage from QBD is beyond me. But then I've just moved to QBO and I'm starting to find it's limitations. Already looking for an alternative....
Is quickbooks looking add this option cause it's needed.
Thank you for joining in on the thread, aki7.
We're tracking the requests, but we haven't got an announcement from the development team if this will be added in the future. Just send yours by clicking Give feedback on the Customer Feedback for QuickBooks Online page. The more requests we receive, the higher the chance of it being implemented in the future.
Check out the What's New in QuickBooks page to see the latest features we've launched recently. You can also enter your contact information at the bottom of the page to be updated of our upcoming features.
I'm just a comment away if you need anything else. Enjoy your the rest of the day and take care.
I do need the import feature as well
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here