Question

MileIQ CSV upload issue self-employed

Forum|Forum|5 years ago
September 8, 2020
25 replies
26 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

QuickBooks Self-Employed

C

Catherine_B

Level 9

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:

Select the Miles menu and click Add trip at the upper-right.
Enter the distance in the Add miles field.
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

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

I'd like to join in and help get your file imported, The Emporium.

I also wanted to know if you got your CSV file from MileIQ? I'm asking this because QuickBooks only allows importing of miles if the file is downloaded from MileIQ and Google Trips.

If it's from MileIQ, use an incognito/private browsing session or switch to a different browser before importing the file. This would help us if a a possible browser issue might have caused the error.

Here are some of the keyboard shortcuts that would let you open an incognito session, depending on the browser that you're using:

Ctrl + Shift + N for Google Chrome
Ctrl + Shift + P for Firefox
Control + Option +P if you're using Safari
Ctrl + Shift + P for Microsoft Edge

Then, log back in and import your CSV file. If you're able to do it, follow the steps in this article to delete your browsing history: Clear Cache and Cookies to Fix Issues When Using QuickBooks Online.

I'd also like to give you more guide articles in case you will be needing them while using the app:

You can always reach out to us again if you have other questions. We'd be glad to offer our help any time of the day.

Hi JenoP, so I am trying to export CSV from MileIQ then import into quickbooks. The first problem is that despite it saying 'download csv' when you hit the button it downloads an .xls. I've tried saving that as a .csv and it throws an error report on the headers, I've then formatted it as per the example in the thread, still the same error message and now I have tried using safari as per your suggestion and I get a different error message:

Uh-oh, looks like we ran into some trouble importing this file. Te.headers.forEach is not a function. (In 'Te.headers.forEach((ve,ze)=>ot.setRequestHeader(ve,ze.join(",")))', 'Te.headers.forEach' is undefined). Correct it and try again.

Huge thanks for replying :)

Sign up

Login with SSO

Let's get you signed in

Login with SSO