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?
T
theinnovativegro
October 12, 2024
Question

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.

  • October 12, 2024
  • 2 replies
  • 29 views
No text available

2 replies

J
JamaicaAQuickBooks Team
QuickBooks Team
October 12, 2024
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:
 
  1. Go to the Apps menu.
  2. Select the Find apps tab.
  3. Type any keyword in the search bar or click the Browse category dropdown menu to explore various programs.
 
Alternatively, you can manually add your trips using the following steps:
 
  1. Go to the Expenses menu and select Mileage.
  2. Choose Add trip.
  3. Enter the trip date, distance, starting and ending points, purpose, and the vehicle you used.
  4. Tap Save.

 

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.
T
theinnovativegroAuthor
October 14, 2024

Thanks. This doesn’t solve the issue. The mileIQ csv has a start and end date.

 

the info I download from QuickBooks does not. 

the issue is that QuickBooks is picking up the day and swapping it for the month when it is uploading into the system. 

H
HomePix
December 29, 2025

Hello all,
I came here to the community to find an answer to the issue with incorrect imports from MileIQ into Quickbooks online. Like many of you, I was getting errors and not much clarity as to what they were. It didnt appear that there was a real solution posed here. While searching around in another location, I did run across the ability to export trips FROM Quickbooks, and that was suggested to get a reference file for proper formatting. After looking at the file, I did find the date solution AND the ability to import the MileIQ files directly into Quickbooks!
Here it is: Export the MileIQ files as a .csv file. Open the .csv file in Excel (or similar). Select the cells that have the dates in them. Choose Modify Cells. Select the Date format, and then choose the format that looks like this YYYY-MM-DD.
I know that sounds weird, however that's the exact format that the exported Quickbooks file had. Once I changed the date format in my files, they imported without any errors!
I hope that helps someone in the QB community. 

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