SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
theinnovativegro
Level 1

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.

 
4 Comments 4
JamaicaA
QuickBooks Team

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.
5.png

 

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.
6.png

 

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.
theinnovativegro
Level 1

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.

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. 

theinnovativegro
Level 1

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.

Unfortunately your solution didn’t solve anything. 

QuickBooks is picking up the date incorrectly when the day is showing as month. 

Manually recategorizing doesn’t help as each month has hundreds of drives. 

 

Tori B
QuickBooks Team

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.

Thanks for checking back with us, @theinnovativegro.

 

We appreciate your patience as we work through this together. 

 

I wanted to take a moment to chime in to mention how some of our users have found opening their files in a program like Excel and changing the format of the columns with the dates in them helpful. You can try to flip-flop the day and the month. Then, you could re-import the file. 

 

That should do the trick. Please don't hesitate to let me know if you have any additional questions or concerns. Have a good one! 

 

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us