Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
J
jacksalvage
September 8, 2020
Question

MileIQ CSV upload issue self-employed

  • September 8, 2020
  • 1 reply
  • 13 views

Hi,

 

I've been having an issue for a while trying to upload my MileIQ files to quickbooks, I've been through agents on quickbooks and mileiq and still not much help.

 

So I get my monthly report of my tracked miles through MileIQ which is sent as a XLS file then I have to convert it to CSV for Quickbooks which doesn't upload and I get the https://uk.selfemployed.intuit.com/secure/mileIq/import: 400 OK error

then I got sent a format from the Quickbooks agent which uploads successfully but doesn't include any of my destinations and when I try to add different dates for my different monthly reports it removes half of them as duplicates.

I tried speaking to MileIQ to see if they can send me a straight CSV format for Quickbooks but apparently that is only available to US customers. So I'm pretty stuck on what I can do here any advice would be appreciated.

 

Cheers

1 reply

C
Catherine_B
Level 9
September 8, 2020

Hello there, jacksalvage.

 

Our product engineers are currently investigating about the 400 OK error when importing miles into QuickBooks Self-Employed. They are working to identify the cause and looking for a resolution to this issue.

 

I'd suggest getting in touch with us again so we can add your account to the notification list. Updates are sent via email. To contact support, check out this link.

 

Meantime, you can add your miles manually. Let me show you how:

  1. Select the Miles menu and click Add trip at the upper-right.
  2. Enter the distance in the Add miles field.
  3. Add the details and select Save.

You can also check out these articles that will help you handle and record trips:

Thanks for your patience while we are continually working on resolving this issue. If there's anything else that you need help with you can always mention me in your reply. You take care!

-
-restorativepodi
November 8, 2021

Agreed. I do not want to manually enter the journey history retrospectively. I might as well not have an auto tracker if im doing that. Please share a working example of a CSV file.

J
JonpriL
Level 9
March 11, 2022

Hi, I am going around in circles sadly. I have deleted and re-loaded acrobat as asked. I am told that UK customers ONLY get an .xls from MileIQ so that may be a problem. Is it not possible to let me have an example .csv sheet that I can use to manually populate my mileage? If this is not possible, I will need to leave quickbooks as I need a holistic service, not one that causes me extra work...

I am sure you understand.


I hear you, @The Emporium. I share details about your mileage data.

 

As of the moment, there isn't a CSV file format to create a list of your mileage. With this, let's consider letting our product developers know about your request by sending feedback.

 

To do so:

 

  1. Sign in to your QuickBooks account.
  2. Select the Help (?) icon.
  3. Scroll down to select the Contact Us button and follow the prompts.
  4. You will be able to request a callback or start a live chat with an expert.

 

Feel free to check this page for more details: How to get help with QuickBooks. 

 

You may also read this article for other ways to track your mileage: How to Use the QuickBooks Self-Employed Mobile App to Automatically Track your Business Miles?

 

If there's anything else that I can help you with aside from this one, please let me know by leaving a comment using the Reply option below. Take care always!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement