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.