Can I import Google Takeout json location/mileage? I've enabled sharing as editor for everyone, tried incognito, cleared cache, un-zipped file, uploaded files (1/month).

Thank you for providing some details, turnkeyids-gmail.

I'd like to help and make sure you import those mileage data to QuickBooks Self-Employed (QBSE).

It may take some time to create and export your file to your Drive. Once it's done, you can follow these steps below generate a link from your drive and then import your trips to QBSE.

To generate the link:

1. Select the Open in Drive link.
2. Click the verticle ellipses ⋮ and then Share.
3. Select Copy link.

Now that you have the link to your Google Timeline file, all you need to is import.

Like this:

1. Log in to your QuickBooks Self-Employed account.
2. Go to the Miles menu.
3. Select the Add trip ▼ dropdown, then Import Google trips.
4. In the section titled Import your work trips, paste the Google Timeline file link into the Google Drive URL field.
5. Then, click on Import.

For more details about the process, check out this article: Import Google Timeline trips into QuickBooks Self-Employed.

I'm adding this resource for your future reference: Fix mileage tracking issues in QuickBooks Self-Employed for Android.

Let me know if you still need further assistance or if you still have other mileage concerns. I'll be happy to assist. Enjoy your weekend.

Thank you for your reply. Yes, those are the exact instructions that I followed from the knowledgebase. (I phrased it as a question because I was directed to do so when posting). But when the process failed scores of times, consistently, over a period of days, I tried to see what I could do to debug the process on my end by eliminating possibilities. Here are some of the tests I performed:

Google Drive tests-
- Changed the sharing permissions in Google Drive to include anyone who has the link.
- Download and expand the zipped file. Upload a single month and share it by itself (both in zipped and unzipped formats).
- Uploaded file to a different Google Drive and re-shared it for anyone with the link.

QBSE tests-
- Constrained the import dates to one month at a time (in both zipped and unzipped formats), after first testing the whole zip file as per the instruction set
- Tried different date formats: 2/1/22 to 2/28/22 (the default), 02/01/22 to 02/28/22, 02/01/2022 to 02/28/2022
- Looked to see if the feature were supported in the QBSE mobile app (it is not, but there was a link to report the issue, which I did, but before documenting attempted alternative solutions)

Browser tests-
- Cleared the cache
- Tried incognito mode in Chrome
- Switched browser to Firefox (Developer Edition)
- Tried it from the full version of the website from an (Android) cellphone browser (Firefox) and received the error message, "Oops something's up Sorry we could not find any miles"
- Repeated the same test on an unzipped file of a single month. This time the error message was the more common, "Something didn't connect. No trips were imported yet. Try again in a bit."

Temporal tests-
- I get the error message, "Something didn't connect. No trips were imported yet. Try again in a bit." So I tried it at different times of the day and night (until about a hundred o'clock), over a period of days, and I still get that message.

Accordingly, the data suggests that this is a problem on the back end. That this feature is listed in the Labs section suggests to me that it is still an experimental feature, not yet ready for prime time. I'm a programmer (meaning "computer savvy"), and I regard it as a matter of enlightened self-interest to help Intuit resolve this. If there isn't a solution in Intuit Support's interior knowledgebase, either, I would be willing to take the time to work with an engineer (in realtime, or asynchronously) to resolve the process, the way I conversed with Intuit Support when I used to make new feature requests (years ago, in the earliest days of Quicken, when I co-authored a book about it). Given the potential user base of, for instance, rideshare drivers to whom the feature is mission-critical, it would seem to me that it is in Intuit's best interest to fully enable this feature, lest users search for a different software suite for their solution. In the case of an Uber or Lyft driver, no one is going to manually enter thousands of trips from Google Maps location history into QBSE at tax time.

Thank you for your time.

I received this error during the first test importing a single month's file (unzipped). 

As there has been no reply from Intuit in the 2 weeks since I posted this, it is safe to conclude that this is no longer a supported feature. I came here in good faith, with all the goodwill in the world, only to have wasted a substantial amount of time. I would recommend not listing it as a feature for sales purposes until or unless Intuit commits to getting it working. I am well aware of what's involved with mapping fields in json files. Truly, it's simply a matter of deciding to do it and allocating the time to follow through. As I have a year's worth of mileage and trip data to import for taxes, I don't have a choice but to look for another solution and to start over. Am I mistaken?

Hi, @turnkeyids-gmail. I’ve got an update regarding your concern about the error you encountered while importing mileage from google drive to QuickBooks Self-Employed. ‘

At the moment, there’s an investigation about importing mileage in QBSE. Our Engineers are aware of this issue and currently working on a fix.

I recommend contacting our support team to add you to the list of affected companies. Rest assured that updates will be implemented soon. Here’s how:

1. Click Assistant from the top menu.
2. Enter Talk to a human and choose I still need a human.
3. Select Get a callback or Call an agent. 

Also, I'm adding the articles below for additional information about importing mileage within your account and fixing issues:

• Import Google Timeline trips into QuickBooks Self-Employed.
• Fix mileage tracking issues. 

Get back to me here if you have further questions about mileage in QBSE. I'd be more than happy to answer it for you. Have a nice day.

Having exact same issue. "Something didn't connect   No trips were imported yet. try again in a bit."  

Hi there, @autrainrivercott. 

As of now, we haven't received any updates yet. We do not have an ETA for resolution at this time. Rest assured that our engineers are currently investigating and working on an immediate fix.

I also encourage you to reach out to our Customer Care Support team to add your account to the list of affected users. This way, you will get notified of any updates on the progress of the investigation via email. 

Here's how:

1. Select Assistant from the top bar.
2. Type in "Talk to a human," then press Enter.
3. Enter a short description of your concern. You can type in the investigation number here.
4. Select Message an agent or Get a callback.

For more details about our support availability, refer to this article: Contact Support. 

Additionally, you can click on the link for your device on how to fix mileage issues in QuickBooks Self-Employed:

• iOS
• Android

I appreciate your patience as we work through this. We hope to have more information for you soon. If you have any other concerns, please don't hesitate to drop a comment below. Take care.

Someone posted in another thread that it appears to be an issue with a change that was made in Google Takeout, specifically that the folder/file organization changed, including adding an additional JSON (maybe splitting an existing one) and changing file names. Not sure if it also resulted in changing the structure of the data within the JSON files themselves. Definitely a deeper issue on QB's side to adjust to the Google update.

its now been multiple years and this has still not been fixed........

I understand how important this feature works to you, @jonnyreco.

Currently, we still haven't received any updates from our engineers.

In the meantime, I'd recommend reaching out to our Customer Support Team. This way, they can add your account to the list of the affected users. By doing so, you'll be notified of any updates on the progress of the investigation via email.

Here's how:

1. Select Assistant from the top bar.
2. Type in "Talk to a human," then press Enter.
3. Enter a short description of your concern. You can type in the investigation number here.
4. Select Message an agent or Get a callback.

For more details about our support availability, refer to this article: Contact Support. 

 I'm adding the articles below for additional information about importing mileage within your account and fixing issues:

• Import Google Timeline trips into QuickBooks Self-Employed
• Fix mileage tracking issues

 Please know that you can always get back to us if you have other questions. We're always here to help.

i allready have done this and have had no responce from support after they said they would advance it to stage 2.

looking at all of these posts on multiple threads over several years makes me think this has been abandoned. 

is there no way you can contact the development team as this is so easy to fix for any team 

ive contacted support and talked to a human and they advanced it to stage 2 but ive not heard anything back from them 

has this feature been abandoned?

there are numerous threads goign back 2 years with this issie and its a waste of your resources to keep offering the same advice for somthing that needs to be fixed by your development team 

Addressing all of your concerns promptly is always our priority, @jonnyreco.

Upon checking our database, there's already an assigned agent to your case for further research. Rest assured, it's already in an Escalated status. 

You'll want to review your email as I can see one that's been sent to you last August 6, 2022. Someone will reach out if there's new information about the investigation on the issue.

If you have other concerns or you need real-time updates about the case, I suggest contacting our Customer Support.

Feel free to post back so we can assist you further. Let us know if you have additional concerns with handling your data or QuickBooks. Stay safe!

OMG.  I just called to get an update on this "escalated" issue.

Could the tech support be any more disconnected from having a conversation in English?  It's not a conversation if only canned responses are read from a script book (the same goes for email support; restating established notes in the thread).

I informed them of this documented issue/thread, and the agent told me they could help me and wanted me to describe the error message.  Oh My!

Does anyone at QB, who has the ability to fix this issue, taken responsibility for this issue?  Is it scheduled to be worked on?  What's an ETA?

Thank you to the user who did all of the testing...isolating and changing the value for one variable in the process at a time.  I ran into this same issue with ADP years ago,  they make changes on their side (tab counts on web sites and db fields and names) and you need to "remap" the import process on your side.

It'd be great if the features worked as great as paying your monthly QB subscription fee... ;)

Hello, neophyte740.

I understand the impact this has caused you and that it's not the sort of experience we want you to have while trying to import mileage from google drive to QBSE account. With this, I'd like to give some details about the INV status. 

I've checked with the INV status, and this investigation has been resolved for QuickBooks Self-Employed.  

Since you still experiencing the same issue, I suggest reaching out to our customer support team again so we can further investigate. 

For more details, you can open this article: How and when can I contact Support?. 

We appreciate your patience. If you have any other concerns, just let me know and I'll guide you through.