cancel
Showing results for 
Search instead for 
Did you mean: 
Annastasia
Level 1

Does Quickbooks allow a csv file for my mileage to be uploaded? i try and get errors.

 
7 Comments 7
AlcaeusF
Moderator

Does Quickbooks allow a csv file for my mileage to be uploaded? i try and get errors.

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:

 

  1. Open the QuickBooks mobile app.
  2. Select the menu ☰ icon and then Mileage.
  3. Select the Unreviewed tab.
  4. Find the trip. Swipe left to categorize the trip as Business. Or swipe right to categorize it as Personal.
  5. Add a purpose for the trip.
  6. Select the vehicle you used.
  7. Select Save.

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.

Annastasia
Level 1

Does Quickbooks allow a csv file for my mileage to be uploaded? i try and get errors.

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.

MaryAnn_E
QuickBooks Team

Does Quickbooks allow a csv file for my mileage to be uploaded? i try and get errors.

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. 

mikelj
Level 1

Does Quickbooks allow a csv file for my mileage to be uploaded? i try and get errors.

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....

 

aki7
Level 1

Does Quickbooks allow a csv file for my mileage to be uploaded? i try and get errors.

Is quickbooks looking add this option cause it's needed.

JessT
Moderator

Does Quickbooks allow a csv file for my mileage to be uploaded? i try and get errors.

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.

dacapo
Level 2

Does Quickbooks allow a csv file for my mileage to be uploaded? i try and get errors.

I do need the import feature as well 

Need to get in touch?

Contact us