Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Thanks for joining the Community, graham24
As a workaround, you can try downloading the CSV file from QuickBooks to get the correct format (from the Mileage tab, select the drop-down menu > Download trips).
Open the downloaded file and over-write (copy & paste) with the trip data from MileIQ. After saving, use the Import trips option to upload in QB.
I gave that a try, but it failed.
Should I be filling in each of the fields in the exported Quickbooks csv? Or are there any I should leave blank (Logging Method etc).
Also could it be because the Business Purpose may be different from the options currently shown in the drop down box, or would they automatically update the dropdown options?
FOr instance, this is the top line of the csv file I am exporting. I have changed the client's name in the start/end address fields:
Date | Type | Trip Purpose | Vehicle | Start Address | End Address | Distance | Deduction | Logging Method |
20/01/2021 | Business | Between Offices | Mercedes GLA 200d | Home | Client A | 5.3 | 2.39 | |
20/01/2021 | Business | Between Offices | Mercedes GLA 200d | Client A | Home | 6 | 2.7 |
Thanks
Hello Graham24, did you download the trips to see what the format was so it was the same for when you try to import them in?
Hi
Yes, I downloaded the trips from QuickBooks and then overwrote the file with the relevant data from MileIQ.
Thank you for providing me with the additional information, @graham24.
As another option, you can convert the MileIQ file to CSV. To do this, you can use an online converter or app. Once converted, you can import it to QuickBooks Online (QBO). You can look for relevant apps directly within QBO. Here's how:
Before importing, you can compare the format accepted by QBO to the converted file. This ensures that the file is uploaded successfully.
Alternatively, you can manually add your trips using the following steps:
Moreover, you can choose to set up your vehicles and let QBO track your mileage automatically.
If you require further help with importing your mileage data from MileIQ to QBO, feel free to add a reply to this thread. We're always ready to back you up.
Hi
I had converted the XLS file to CSV in Excel. But the file still would not import (even with all of the extra date and columns removed.
As shown in my post above, the MileIQ data I am trying to import matches the format in the Quickbooks csv file.
I have three years worth of MileIQ data that I would like to import into Quickbooks, so manual entry unfortunately isn't an option.
Please advise if this is at all possible
Thanks
Graham
I appreciate your effort in chiming back into this thread, graham24. Let me provide further insights to sort things out for you when importing mileage data from MileIQ to QuickBooks, so you can get back to business seamlessly.
I understand how crucial it is to import and keep track of employees' time mileage data from MileIQ to QuickBooks Online. Since the program is dependent on the information sent from MileIQ, it's best to reach out to their support team to provide you with other specific files that can be supported and imported to QuickBooks. This way, they'll assist you in converting the exported file from their data into the online program.
In addition to that, you may utilise running reports in your file to efficiently track your business finances and employees' worked hours.
I'll always be available in this thread if there's anything else you need further assistance with when importing mileage data to your account. Feel free to let me know in the comments below and I'll make sure to get you covered. Keep safe!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.