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

T
The Emporium
March 11, 2022

Thanks for getting back to us, @The Emporium.

 

I have some information to share. You'll want to update your Adobe Acrobat and Adobe Reader. This CSV file uses Adobe Captive or Moodle when saved. Thus updating it fixes issues like the header error.

 

To update or repair Adobe Acrobat, refer to this guide: How to update, repair, or re-install Adobe Reader/Acrobat.

 

After updating, go back try exporting a CSV file again.

 

If you're experiencing the same result, please contact our Customer Care Support. This way, we can create a ticket for you and investigate further. Use this link to reach out: Contact QuickBooks Self-Employed Support.

 

I've also added our help page in case you have other questions with QuickBooks Self-Employed. It has topics with articles that'll guide you along.

 

Please reply to this thread if you have follow-up questions with exporting file. I'll be around for you. Have a wonderful weekend.

 


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.

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