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
  • 20 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!

D
David_Urbancanopy
October 21, 2020

HI, 

 

I am having the same error message pop up when trying to import the CSV file, i do not want to have to manually enter all the trips when i have been logging them...

Could you share a working CSV file example so i can make sure its not something silly stopping the CSV file from working please?

 

Cheers

E
ECS-01
March 26, 2022

Hello, lsmm. 

 

Thank you for reaching out here in the Community. I appreciate the steps you've performed to isolate the issue.  

 

Since we lay out the possible solution yet the issue persists, I suggest contacting our QuickBooks Support so that they can pull up your account in a safe environment and help you further with the error you've encountered.  

 

Here's how: 

 

  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.

 

For more details, please see this page: How to get help with QuickBooks.

 

I'm adding this resource to know more about track mileage in QuickBooks, check out this guide: Automatically track mileage in QuickBooks Self-Employed.

 

Feel free to comment down below if you have other questions about this matter or with QuickBooks. The Community has your back. Have a good one!


I'm getting the exact same message and have tried doing everything here as well!

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