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

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

 
Solved
Best answer April 26, 2020

Best Answers
MaryAnn_E
QuickBooks Team

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

Hi there, @vallerd1.

 

You can import your mileage from MileIQ to QuickBooks Self-Employed by following these steps below:

 

Here’s how:

 

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

 

In doing this, make sure that the file follows the correct format (QBSE_Miles.csv).

 

You can read through these articles to learn more about how the mileage tracking feature works in QuickBooks Online:

 

 

 I'm just around if there's anything that I can help you with. Stay safe!

View solution in original post

12 Comments 12
MaryAnn_E
QuickBooks Team

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

Hi there, @vallerd1.

 

You can import your mileage from MileIQ to QuickBooks Self-Employed by following these steps below:

 

Here’s how:

 

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

 

In doing this, make sure that the file follows the correct format (QBSE_Miles.csv).

 

You can read through these articles to learn more about how the mileage tracking feature works in QuickBooks Online:

 

 

 I'm just around if there's anything that I can help you with. Stay safe!

Eliriley123
Level 1

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

Do i have to this on the computer or i can do it from the quick books self employed app?

Eliriley123
Level 1

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

Do i do this on the website or the app? I tried the app but mileiq doesn’t popup as an option

Nick_M
QuickBooks Team

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

Hi Eliriley123. 

 

Thanks for dropping by the Community, I would definitely recommend trying the steps provided above when signing into your QuickBooks Self-Employed account on the website. Especially if it wasn't working on the app. If you're still having issues on the website, I would suggest reaching out to our support team as they can help guide you in a 1-on-1 setting. To reach them, you can follow these steps:

 

Ask QB Assistant:

 

QB Assistant is a virtual agent that gives you quick personalized answers. Ask general questions like "How much did I make this year?" or "How many business miles did I log?"

To open QB Assistant, follow the step for your device:

  • Web browser: Select Assistant from the top menu.
  • iPhone or iPad: Tap the button on the dashboard, then select Ask QB Assistant.
  • Android: Tap the chat bubble icon on any screen.

Once you're in, type a question or press and hold the mic icon to ask your question out loud.

 

Connect with us:

  1. Enter or say “Talk to a human.”
  2. Choose a way to connect with us:
    • Post a question and get answers from tax specialists and other customers like you.
    • Start a chat with a support expert.
    • Get a callback from the next available expert.

Keep in mind, some options are only available at certain times.

 

If you have any other questions, feel free to post here anytime. Thank you for your time and have a nice afternoon. 

Cortez24
Level 1

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

Hi,

 

I'm trying to create my report but MileIQ only allows me to create xls and pdf format which Quickbooks self-employed does not recognise.

Can I integrate my MileIQ and Quickbooks Self-Employed when I'm based in the UK and CVS format is not available? 

Thanks,

 

DivinaMercy_N
Moderator

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

I can provide tips you could ever need to import files from MileIQ to QBSE, @Cortez24.

 

You can use the file with xls format and convert it to CSV on your computer. This way, you'll be able to import the data in your QBSE account in the required file form. Once converted, please follow the steps to move the file:

 

  1. In QuickBooks, go to the Miles menu.
  2. Click the Add trip drop-down arrow and choose Import MilesIQ tripsmileiqtoqbse1.JPG
  3. Select the Browse button to locate your CSV file. mileiqtoqbse2.JPG

 

When finished, categorize the imported trips to ensure your data is organized. For the detailed steps, proceed to Step 2 of this article: Switch from MileIQ to QuickBooks Self-Employed. 

 

Also, for your question, the option to integrate QBSE with MileIQ is currently unavailable. You can only import trips manually by referring to the outlined steps above. 

 

You can also visit this wonderful article that can help you in managing your QuickBooks Self Employed account: Schedule C and expense categories. This page includes steps on how to record your self-employed income and expenses, and prepare your Schedule C. 

 

That's it! You'll now be able to import mileage from MileIQ to QBSE. Feel free to get back here if you have other QuickBooks-related concerns. I'm here if you need further assistance. Have a good one. 

PLP John
Level 1

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

I'm still having issues trying to import a .CSV file into QB from MileIQ. I've downloaded the .XLX file, saved it as a.CSV file (and tried various iterations) and I just keep getting import failure messages. 

 

I expect it's something really simple that's throwing it out, so does anyone have a working example of the relevant file & field names and formats? 

 

It shouldn't be this difficult. 

 

ReyJohn_D
Moderator

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

I've got your back, @PLP John.

 

There are a few things we'll need to check before importing your CSV files into QuickBooks. These are the following:

 

  • Ensure there aren't zeros or extra characters from the file to prevent import issues.
  • Please add at least one vehicle before importing.
  • Only Business Trips will be imported.
  • Check for duplicate trips. QuickBooks will ignore them.

If the issue persists, I recommend contacting our support team. They can check your account securely and review this further. Before doing so, please check our support hours to make sure they can assist you on time.

 

Here's how:

 

  1. Click Assitant from the top bar.
  2. Type Talk to a human.
  3. Select your preferred method: Message an agent or Call an agent, or Get a callback.

If everything's okay, you can follow the steps given by my colleague @DivinaMercy_N to import your file.

 

When you're ready, you can begin categorizing and tracking your trips to ensure the accuracy of your records. For the detailed steps, please refer to steps 2 and in this article: Switch from MileIQ to QuickBooks Self-Employed.

 

Feel free to comment back below if you have additional questions about importing transactions in QuickBooks. I'll be here to lend a hand.

quiveringbee@gma
Level 2

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

What IS the correct QBSE_Miles.csv file format?  I was able to finally find something out there, but it only had a single START and STOP field.  When put in a full address they were put in the Trip Purpose field and address, city state zip for both START and STOP were empty.  Do you need START_ADDRESS, START_CITY, START_STATE, START_ZIP columns to correctly populate the actual start and stop sections?

Rose-A
Moderator

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

I appreciate you joining in this thread, quiveringbee@gma.

 

To be able to successfully populate and import your miles via the CSV file in QuickBooks Self-Employed, make sure the "Notes' column is blank. Also, check the format of the date, remove the time beside it, or any unwanted symbols. Please refer to the screenshots below:


z.PNG

 

If the issue persists, I would suggest getting in touch with our QuickBooks Self-Employed Support. Unlike in this public forum, they have the tools required to perform any escalations in the system whenever necessary on your behalf.

 

  1. Click Assistant at the upper right corner.
  2. Type in "Talk to a human."
  3. Then select your preferred support method: Message an agent (Live chat), Call an agent, or Get a callback. Keep in mind, some options are only available at certain times.

To help you categorize your imported trips, check out this article: Switch from MileIQ to QuickBooks Self-Employed.

 

Feel free to drop a comment below if you have follow-up questions about  importing and managing tracked mileage. I’m happy to help.

Flovia
Level 1

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

After spending so many hours finally figure out the column headings needed to import the mileage data into the QuickBooks.

 

I also spoke to customer service, but they had no clue about this but they confirmed that this is an open issue with them since December 11, 2020 (INV_51963).

 

START_DATE*

END_DATE*

CATEGORY*

START*

STOP*

MILES*

MILES_VALUE

PARKING

TOLLS

TOTAL

VEHICLE

PURPOSE

NOTES

Davidkinally
Level 1

How can I import mileage from MileIQ into QB Self-Employed for tax year 2020?

Here is my conversation with earl about the matter:

 

Today, 13:19

Today, 13:19
 
I am having issues uploading my mileIQ csv file showing error "Uh-oh, looks like we ran into some trouble importing this file. Http failure response for https://uk.selfemployed.intuit.com/secure/mileIq/import: 400 OK."
 
David at 1:19 pm said I am having issues uploading my mileIQ csv file showing error "Uh-oh, looks like we ran into some trouble importing this file. Http failure response for https://uk.selfemployed.intuit.com/secure/mileIq/import: 400 OK."
 
Hello there! You are connected to our on-demand team who will answer any of your questions about QuickBooks.
 
SYSTEM_MESSAGE at 1:19 pm said Hello there! You are connected to our on-demand team who will answer any of your questions about QuickBooks.
 
We will route you to the next available expert
 
SYSTEM_MESSAGE at 1:19 pm said We will route you to the next available expert

Wensley Earl has joined the chat

13:19

System Event at 13:19: Wensley Earl has joined the chat
 
094281
 
Wensley Earl at 1:20 pm said 094281
W
Hi! Hope you are well. This is Earl, thank you for messaging with Intuit QuickBooks Online UK support! Please give me a few minutes to review your concern. May I also have your Company ID? Please go to Cog Wheel >> Under Your Company, Account and Settings. >> Billing and Subscription. Your Company ID is located on the Upper Portion of your Screen.
 
Wensley Earl at 1:20 pm said Hi! Hope you are well.<br><br>This is Earl, thank you for messaging with Intuit QuickBooks Online UK support!<br> <br>Please give me a few minutes to review your concern.<br><br>May I also have your Company ID? Please go to Cog Wheel &gt;&gt; Under Your Company, Account and Settings. &gt;&gt; Billing and Subscription. Your Company ID is located on the Upper Portion of your Screen.
 
ok hold on
 
David at 1:21 pm said ok hold on
 
 
 
David at 1:22 pm said 1935 1474 4729 254
W
Thank you and can you please provide me your email address
 
Wensley Earl at 1:23 pm said Thank you and can you please provide me your email address
 
David at 1:23 pm said [email address removed]
W
One moment let me pull up your account.
 
Wensley Earl at 1:25 pm said One moment let me pull up your account.
 
thanks
 
David at 1:26 pm said thanks
 
I tried to pull up the account using the email address you have provided but there is no account pulled up. Let me create an account for you.
 
Wensley Earl at 1:27 pm said I tried to pull up the account using the email address you have provided but there is no account pulled up. Let me create an account for you.
 
I mean contact on our end.
 
Wensley Earl at 1:27 pm said I mean contact on our end.
W
And while I'm creating a contact in here. How can I help you today?
 
Wensley Earl at 1:27 pm said And while I'm creating a contact in here.<br>How can I help you today?
 
I am having issues uploading my mileIQ csv file showing error "Uh-oh, looks like we ran into some trouble importing this file. Http failure response for https://uk.selfemployed.intuit.com/secure/mileIq/import: 400 OK."
 
David at 1:29 pm said I am having issues uploading my mileIQ csv file showing error "Uh-oh, looks like we ran into some trouble importing this file. Http failure response for https://uk.selfemployed.intuit.com/secure/mileIq/import: 400 OK."
 
this is to quickbooks self emoployed uk
 
David at 1:29 pm said this is to quickbooks self emoployed uk
W
MilelQ is this mileage?
 
Wensley Earl at 1:30 pm said MilelQ is this mileage?
 
yes
 
David at 1:31 pm said yes
W
Because technicallly for mileage we don't do uploading using CSV file. We only enter the correct mileage in the mileage tab. then it will automatically create an expense.
 
Wensley Earl at 1:33 pm said Because technicallly for mileage we don't do uploading using CSV file. <br>We only enter the correct mileage in the mileage tab.<br>then it will automatically create an expense.
 
ok so why is there an option to upload from a mileIQ report then?
 
David at 1:34 pm said ok so why is there an option to upload from a mileIQ report then?
 
that asks for a CSV file?
 
David at 1:34 pm said that asks for a CSV file?
W
I do understand that one however for Mileage feature this is not yet available in QBSE account. What we can only do is to manually enter it.
 
Wensley Earl at 1:37 pm said I do understand that one however for Mileage feature this is not yet available in QBSE account. What we can only do is to manually enter it.<br><br>
 
ok
 
David at 1:42 pm said ok
 
you can manually enter it? or I have to?
 
David at 1:42 pm said you can manually enter it? or I have to?
W
You need to manually enter it. We don't have any access to your account.
 
Wensley Earl at 1:42 pm said You need to manually enter it. We don't have any access to your account.
 
Because this is one of the reasons I have moved over to quickbooks. If its not available then why is the option there?
 
David at 1:42 pm said Because this is one of the reasons I have moved over to quickbooks. If its not available then why is the option there?
 
it literally says on the site "Switching from MileIQ to QuickBooks Self-Employed?"
 
David at 1:43 pm said it literally says on the site "Switching from MileIQ to QuickBooks Self-Employed?"
 
which contradicts what you just said
 
David at 1:43 pm said which contradicts what you just said
 
Import trips from MileIQ in three simple steps.
 
David at 1:43 pm said Import trips from MileIQ in three simple steps.
W
Yes I do understand that one however this feature for importing is not yet available in QBSE account and this is a system design for now our developers are working on it to be available in the future.
 
Wensley Earl at 1:44 pm said Yes I do understand that one however this feature for importing is not yet available in QBSE account and this is a system design for now our developers are working on it to be available in the future.
 
but that's the thing buddy
 
David at 1:46 pm said but that's the thing buddy
 
it IS availible
 
David at 1:46 pm said it IS availible
 
the feature is literally available but won't let me upload the file
 
David at 1:46 pm said the feature is literally available but won't let me upload the file
 
so get rid of it if its not yet available or make it available. Have you been to the community and seen the amount of people frustrated with this? go to support and type in MileIQ and see what comes up
 
David at 1:47 pm said so get rid of it if its not yet available or make it available. Have you been to the community and seen the amount of people frustrated with this? go to support and type in MileIQ and see what comes up
 
Again even in our test account would not allow us to upload the mileage as this is not yet available in QBSE and the upload feature is still a system deisng
 
Wensley Earl at 1:47 pm said Again even in our test account would not allow us to upload the mileage as this is not yet available in QBSE and the upload feature is still a system deisng
W
So what we can only do is to manually enter it.
 
Wensley Earl at 1:47 pm said So what we can only do is to manually enter it.
 
IN FACT! hold on there
 
David at 1:48 pm said IN FACT! hold on there
 
How can I import mileage from MileIQ into QB Self-Employed for tax year 2020? QuickBooks Self-Employed Cheer Join the conversation Best Answers MaryAnn_E MaryAnn_E QuickBooks Team QuickBooks Team ‎April 26, 2020 06:42 AM Hi there, @vallerd1. You can import your mileage from MileIQ to QuickBooks Self-Employed by following these steps below: Here’s how: 1. 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. In doing this, make sure that the file follows the correct format (QBSE_Miles.csv). You can read through these articles to learn more about how the mileage tracking feature works in QuickBooks Online: QuickBooks can do WHAT? Tracking your mileage Track mileage in QuickBooks Online I'm just around if there's anything that I can help you with. Stay safe! View solution in original post 1 Cheer Reply
 
David at 1:48 pm said How can I import mileage from MileIQ into QB Self-Employed for tax year 2020? QuickBooks Self-Employed Cheer Join the conversation Best Answers MaryAnn_E MaryAnn_E QuickBooks Team QuickBooks Team ‎April 26, 2020 06:42 AM Hi there, @vallerd1. You can import your mileage from MileIQ to QuickBooks Self-Employed by following these steps below: Here’s how: 1. 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. In doing this, make sure that the file follows the correct format (QBSE_Miles.csv). You can read through these articles to learn more about how the mileage tracking feature works in QuickBooks Online: QuickBooks can do WHAT? Tracking your mileage Track mileage in QuickBooks Online I'm just around if there's anything that I can help you with. Stay safe! View solution in original post 1 Cheer Reply
 
Even an member of the quickbooks team says you can do it
 
David at 1:48 pm said Even an member of the quickbooks team says you can do it
 
that was written over a year ago
 
David at 1:48 pm said that was written over a year ago
 
and in the community is says that if there are any issues please talk to you guys.
 
David at 1:51 pm said and in the community is says that if there are any issues please talk to you guys.
 
this is the most unprofessional "professional" business I have ever dealt with
 
David at 1:52 pm said this is the most unprofessional "professional" business I have ever dealt with
 
HAHA that was from December 2019. The one I referenced is from April 2020 (more recent)
 
David at 1:53 pm said HAHA that was from December 2019. The one I referenced is from April 2020 (more recent)
 
I assume you are just being lazy here and do not want to help
 
David at 1:53 pm said I assume you are just being lazy here and do not want to help
 
do you have a manager that can call me?
 
David at 1:54 pm said do you have a manager that can call me?
 
We already reach to our senior support and they confirm that there is no available for importing for mileage even there is a button. We also tried to upload it on our end and it is giving us an error so again our developers are still working on it to be available in QBSE
 
Wensley Earl at 1:55 pm said We already reach to our senior support and they confirm that there is no available for importing for mileage even there is a button.<br>We also tried to upload it on our end and it is giving us an error so again our developers are still working on it to be available in QBSE
W
And I'm not being lazy because I know who the sytem would work it just happen that the import for Mileage is not yet available as that is a system design for now.
 
Wensley Earl at 1:56 pm said And I'm not being lazy because I know who the sytem would work it just happen that the import for Mileage is not yet available as that is a system design for now.
 
Earl, I think you and your team need to go and have a good chat about both customer service. Thank you for bringing this to light. I have saved this conversation and will be posting it to the communities to better inform them. Have a nice day
 
David at 1:58 pm said Earl, I think you and your team need to go and have a good chat about both customer service. Thank you for bringing this to light. I have saved this conversation and will be posting it to the communities to better inform them. Have a nice day
 

Need to get in touch?

Contact us