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.

 

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.

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.

 

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. 

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. 

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! 

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.

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.

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.