Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Can you import MileIQ trips into QuickBooks Self-Employed using the import feature and creating your own .csv file EVEN IF you don't have a MileIQ account?

Looking to upload some trips into QuickBooks Self-Employed without having to enter each one manually.  I don't like the mileage tracker because it tracks everything AND it runs my cell phone battery down when it is set to always.

5 Comments
Moderator

Can you import MileIQ trips into QuickBooks Self-Employed using the import feature and creating your own .csv file EVEN IF you don't have a MileIQ account?

Hi there, quiveringbee@gma.

 

The option to import mileage using your own CSV file format isn't available. 

 

We'll have to follow the format by QuickBooks Self-Employed. Let me guide you with these steps:

 

Click the Miles tab.

2. Hit the Add trip button.

3. Select Import MileIQ trips.

4. Follow the on-screen instructions to complete the process.

 

I've added these references for more information when tracking mileage:

 

 

I'll be around if you need help. Keep safe!

Level 1

Can you import MileIQ trips into QuickBooks Self-Employed using the import feature and creating your own .csv file EVEN IF you don't have a MileIQ account?

Thanks.  Do you know all the available column fields that I can actually use in a .csv file when importing mileage data?  The attached .csv file was accepted, but once imported it concatenated the START address and STOP address at the end of the "Trip Purpose" field in QuickBooks.  I was hoping to be able to populate the start and stop address just like was done when I had the auto mileage tracking feature on.  If you can't read the .csv file the columns used were: START_DATE, END_DATE,CATEGORY,START,STOP,MILES,MILES_VALUE,PARKING,TOLLS, TOTAL,VEHICLE,PURPOSE,NOTES

Start and Stop were filled in with 1122 SW 1st Portland, OR 97219

Moderator

Can you import MileIQ trips into QuickBooks Self-Employed using the import feature and creating your own .csv file EVEN IF you don't have a MileIQ account?

Thanks for getting back to me, quiveringbee@gma.

 

At this time, I recommend reaching out to our Phone Support team. We have agents there that can take a look at your account and verify the error further.

 

Here's how you can contact them:

 

  1. Click the ? Help button.
  2. Enter Talk to a human.
  3. Enter, Import Mileage.
  4. Select I still need a human.

 

Feel free to reply to this thread if there's anything that I can help. Keep safe!

Level 1

Can you import MileIQ trips into QuickBooks Self-Employed using the import feature and creating your own .csv file EVEN IF you don't have a MileIQ account?

I went onto the Miles tab, followed the instructions to import trips, but it said that I wasn't using the correct file type, even though I was- I was using the CSV file type for my trips. Do you know how I can fix this?

QuickBooks Team

Can you import MileIQ trips into QuickBooks Self-Employed using the import feature and creating your own .csv file EVEN IF you don't have a MileIQ account?

Let's perform some basic troubleshooting steps so you can import your MileIQ trips, @Sekou Traore.

 

Sometimes local internet cache files stored in the system can cause unexpected behavior in the product. This can be the reason why you're getting an error message that your file type is incorrect even though it's in the right format. 

 

Let's fix this by accessing your QBSE account in a private window. This is a special mode that doesn't record the browsing activity on your local device. Simply press the following keys: 

 

  • Press Ctrl + Shift + N (Google Chrome).
  • Ctrl + Shift + P (Firefox).
  • Control + Option + P (Safari).

 

If you're able to import your MileIQ trips into QBSE, then let's clear the cache in your web browser or try using a different supported browser. It could be a temporary issue with QuickBooks and the current browser that you use.

 

In case you accidentally forgot to track the trip on your mobile phone, you can still manually add it in QBSE.

 

Let me know how else I can help you with QuickBooks by adding a comment below. I'm more than happy to lend a helping hand. Have a great day, and keep safe!

Need to get in touch?

Contact us