Skip to main content
J
jam22407
February 10, 2020
Question

Can you import mileage (from say, MileIQ) into QB Online as you can with QG Self Employment?

  • February 10, 2020
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

Jen_D
Jen_D
February 10, 2020

Glad to see you here, @jam22407,

 

Importing mileage data into QuickBooks Online (QBO) from other sources is currently unsupported. What you can do is to automatically track your mileage and trips.

 

Here's how:

  1. Go to the Mileage menu from the left toolbar.
  2. Select Add Trip, then add the information like date, starting/ending points, distance, and the purpose.

  3. Hit Save.

To know more on how to use the Mileage tracking feature in QBO, see the following links:

Being able to import MileIQ data into QBO like you do in QuickBooks Self-Employed is a great idea when added to the program. I know how beneficial it is to keep this related information in one place using a direct integration tool. While this is not introduced yet, I'll make sure to relay this to our developers.

 

Stay on top of our product updates and feature releases by visiting the QuickBooks Blog: Intuit Blog.

 

If you have any other questions about QuickBooks, feel free to post them here. I'll be glad to share additional insights and help. Have a wonderful week ahead!

    G
    GraceH
    May 6, 2021

    Yes, please do relay that to the developers! It would be a huge help to and improvement for me. 

      Tori B
      Tori B
      May 6, 2021

      Hey there, @GraceH. 

       

      Thanks for following the thread. 

       

      Please know that we have sent this suggestion to our product development team. Our product developers will analyze the request and will decide rather to add it as a new feature. 

       

      I also wanted to include that you can submit a feedback request any time you have ideas for new features you'd like to see included in updates. Our product development team loves to hear from customers like you. 

       

      1. Hit the Gear icon at the top, then Feedback.
      2. Enter your comments or product suggestions. Then tap Next to submit feedback.

      Your valuable feedback goes to our Product Development team to help improve your experience in QBO. You can track feature requests through the QuickBooks Online Feature Requests website.

       

      Please let me know if there's anything else that I can do for you. I'm happy to lend a hand anytime. Take care and have a fantastic day! 

      M
      mikelj
      May 17, 2022

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

       

      C
      Carneil_C
      May 17, 2022

      Thanks for joining the thread, @mikelj.

       

      I appreciate you coming up with a workaround here in the Community on how to import mileage. Information like this will definitely help other users who may have the same concern.

       

      This is a great time to send this suggestion to our Product Development Team. Your ideas are helpful to us. Our developers can then determine what features are to be included in QBO's future updates.

       

      Here's how:
       

      1. Go to the Gear icon.
      2. Select Feedback.
      3. Enter a brief description of your product suggestion and then click Next.
      4. Type your email address.
      5. Once done, click Send Message.

       

      In addition, I've got this helpful resource to guide you further on tracking mileage in QBO: 

       

       

      You can post anytime if you have questions or want to share your best practices using the product. Please know the Community has your back.

      Terms & ConditionsAccessibility statement