I cannot import mileage from MileIQ csv file. Upload fails everytime instantly. Says make sure file is under 100kb and is in .csv format, both are true. Help please!

Hello there, nkbservicesllc.

To ensure smooth import of your MileIQ CSV file in QuickBooks Online (QBO), you can consider reducing its file size. 

If the issue persists, we can proceed with some troubleshooting steps. To begin, please open an incognito window and log in to your QBO account. Depending on your browser type, you may refer to the keyboard shortcuts provided below:

• Google Chrome: Ctrl + Shift + N
• Mozilla Firefox: Ctrl + Shift + P
• Microsoft Edge: Ctrl + Shift + N
• Safari: Command + Shift + N

When this works, you may proceed to clear the browser's cache. This removes its stored cache to ensure the program performs efficiently. I recommend using another supported browser or device if you still encounter the same challenges.

In addition, you'll want to check this article as a reference to run basic reports: Run reports in QBO.

If you have further concerns about uploading your MileIQ CSV file in QBO, feel free to come back here in the Community. We're here to assist you 24/7.

Unfortunately I have already tried your canned response to no avail.  I have verified it is saved as .csv and the file size is 14.6kb (well under the 100kb limit).

I have also tried different browsers both normally and in cognito / private.  

I find it funny that when I did the online chat for help prior, they told me this feature is only available to the highest (advanced) subscription level and tried to get me to upgrade my subscription level (a $110 per month increase). 

This is not true.  I found the issue, and neither the online chat, nor your response was helpful.  Very nice that you outright lie to your customers to try and swindle more money out of them.  What a joke of a company.

I can see how you want the feature to work how it should. Let me provide another workaround so the import would be successful, NKB.

Yes, you're right. The import option of MileIQ is available on other QuickBooks Online (QBO) versions. You'll want to ensure you've provided the correct header character and update the first row of your CSV to trigger some changes. You can also check the following format for your reference:

Also, make sure everything in your CSV is mapped correctly to prevent issues along the way. Once done, double-check if you can already import your data from MileIQ. However, if the problem persists, I recommend reaching out to our support team so they'll be able to provide you with another workaround and investigate further why this is happening. They have the tools to pull up your account in a secure environment. Here's how to reach them:

1. Sign in to your QuickBooks Online company.
2. Click Help (?).
3. Select either tab to get started:
   • Assistant: Get quick, personalized answers. Select a suggested option, or type a question or topic you need help with. If you decide you need further help, you can still Talk to a human.
   • Search: Search the QuickBooks Online knowledge base directly, or select Contact Us and choose a way to connect with us:
     • Start a chat with a support expert.
     • Get a callback from the next available expert.

Moreover, you can check out some of QuickBooks available reports to get the right data you need. You'll only have to customize them so the information shows up on the right place. I've added this article for more details: Customize Reports in QuickBooks Online.

Any other concerns about mileage are greatly appreciated. Leave a comment and I'll make sure to get back to you.