I'm having issues with CSV file for MileIq importing incorrectly? The dates are swapped. If its a drive I made on June 12 2024, it shows the drive as Dec 6.

It's crucial to display the correct date when importing mileage data from MileIQ to QuickBooks, theinnovative. I'll share a few options you can use to correct the format.

 

First, download the CSV file from QuickBooks to have a reference of the correct format. To proceed, go to the Mileage tab, select the Add trip drop-down menu and choose Download my trips. After that, open the downloaded file and overwrite (copy & paste) with the trip data from MileIQ. Save it then upload through Import trips.

 

Additionally, you can convert the MileIQ file to CSV via an online converter or app, then compare the format accepted by QBO before importing. Look for one by following the steps below:

 

 

Alternatively, you can manually add your trips using the following steps:

 

 

If you haven't, you might want to explore QuickBooks Online mobile app to track business miles for one or more vehicles. Here's an article for complete details: Automatically track mileage in QuickBooks Online.

 

Furthermore, save this guide to learn what to do if you have problems tracking your work trips: Fix mileage tracking issues in the QuickBooks Online mobile app

 

I'll always be available in this thread to address your mileage concerns. Let me know in the comments below and I'll make sure to get you covered. Keep safe.