theinnovativegro
Level 1
‎October 12, 2024 10:53 AM

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.

 
Reply Join the conversation
JamaicaA
QuickBooks Team
QuickBooks Team
‎October 12, 2024 11:59 AM

Banking

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.
Reply Join the conversation
theinnovativegro
Level 1
‎October 14, 2024 11:07 AM

Banking

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. 

Reply Join the conversation
theinnovativegro
Level 1
‎October 14, 2024 11:09 AM

Banking

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. 

 

Reply Join the conversation
Tori B
QuickBooks Team
QuickBooks Team
‎October 14, 2024 12:47 PM

Banking

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! 

 

 

Reply Join the conversation
STPTreasurer
Level 1
‎August 05, 2025 04:05 PM

Banking

I’m am having the same issue… and reformatting the dates in excel before uploading to QBO is a clumsy and time consuming approach… please just have the intuit team correct the import logic that still has a bug in it.  It can’t be that hard.

Reply Join the conversation
RhoiceW
QuickBooks Team
QuickBooks Team
‎August 05, 2025 04:39 PM

Banking

Thank you for bringing this to us, STPTreasurer. Since you're having issues importing your files from MileIQ to QuickBooks Online, I suggest performing some troubleshooting steps.

 

Please follow these steps to clear your browser's cache, keeping in mind not to clear your cookies, as they store important user information and help with seamless access.

 

Additionally, you may consider using a different supported browser to ensure optimal compatibility with QuickBooks products.

 

If the issue persists after troubleshooting, I recommend contacting the MileIQ support team for assistance with the integration. They can adjust settings and investigate why the import to QuickBooks isn’t accurate.

 

Don't hesitate to reply if you need further assistance related to QuickBooks. We'll be here to help.

Reply Join the conversation