Keep track of all of your business miles in one spot. Import your trips into QuickBooks Self-Employed if you track your kilometres with Google Timeline. This allows QuickBooks to combine all of your business miles to optimise your deductions. Here’s how to get a connection to your Google Timeline file so you may import it into QuickBooks Self-Employed.

Step 1: Export Google Trips: You’ll begin by opening QuickBooks Self-Employed:

  • Sign in to the Google account from which you want to export miles. Maintain this in a different browser tab.
  • Access QuickBooks Self-Employed.
  • Navigate to the Miles menu.
  • Select the Add trip menu, followed by Import Google travels.
  • Choose the Google Takeout option.

This creates a new web browser tab with the Google Takeout page. Next, hover your mouse over your Google profile icon to ensure you’re logged in to the correct account.

  • Select the Location history checkbox in the Select data to include the section of Google Takeout.
  • Choose JSON from the Location history dropdown after selecting the Multiple formats option. Then click OK.
  • Choose the next step.
  • Select Add to drive from the Delivery method selection.
  • Select .zip as the file type and 2 GB as the file size in the File type & size box.
  • Choose Create Export.

It may take Google a few seconds to build the file. When it’s finished:

  • Choose the Open in Drive option.
  • Choose the verticle ellipses and then click Share.
  • Choose Copy Link.

You should now have access to your Google Timeline file.

Step 2: Enter your trips into QuickBooks Self-Employed: 

  • Reopen QuickBooks Self-Employed.
  • Navigate to the Miles menu.
  • Select the Add trip menu, followed by Import Google travels.
  • Paste the Google Timeline file link into the Google Drive URL field in the Import your work trips section.
  • Choose Import.

Step 3: Sort your trips into categories: QuickBooks now has access to your Google Timeline travels:

  • Navigate to the Miles menu.
  • Examine the imported trips
  • Classify each as either business or personal.

How do I import miles into QuickBooks?

The option to import mileage data to QuickBooks Online (QBO) is currently unavailable. So, the only option is to enter previous travels into the system manually for the time being. To track business miles using the app, sign in with your QBO account and complete these steps:

  • Then, navigate to the QuickBooks mobile app.
  • Choose the menu icon, then Mileage.
  • Choose the Unreviewed tab.
  • Locate the trip. Swipe to the left to mark the trip as Business. Swipe right to classify it as Personal.
  • Add a reason for the travel.
  • Choose the vehicle you utilised.
  • Choose Save.

Does QuickBooks have a mileage tracker?

Business-related miles can quickly mount up. You may be eligible to deduct your company travel and expenses at the end of the year. To track business mileage for several vehicles, use the QuickBooks Online mobile app. Keep track of your excursions and vehicle information throughout the year, so you have all you need when it comes time to file your taxes. Here’s how to get started with mileage tracking and adding vehicles.

How do I print miles in QuickBooks?

Record your company mileage and vehicle expenses in QuickBooks, so you have all you need to compute deductions when tax season comes around. 

Drivers on your team may log business kilometres using the QuickBooks Online mobile app. The software automatically tracks trips from beginning to end. Simply launch the mobile app and let QuickBooks take care of the rest. You only need to categorise the trip. 

Step 1: Check the user permissions of your driver: Here’s how to alter your user rights so your driver can track their mileage if you haven’t previously. In QuickBooks Online, only admin users may track mileage.

Step 2: Enable mileage tracking and enter a car: Set up the automatic mileage tracking feature if you haven’t already. Add your vehicles to QuickBooks Online before you begin monitoring journeys. This allows you to assign trips to the appropriate vehicle.

Step 3: Keep track of your business mileage: Simply take out your mobile device and open the QuickBooks Online mobile app whenever you start driving. Keep the app open throughout the journey. It will identify and track the miles from beginning to end.

Manually enter a journey: Have you forgotten to track a trip? Not an issue. You can always manually enter trips:

  • On a web browser, log in to QuickBooks Online.
  • Navigate to the Mileage or Trips menus.
  • Select the Add Trip option.
  • Include the travel date, starting and ending points, distance, and purpose.
  • Choose Save.


In conclusion, QuickBooks Desktop software is accounting software that helps you manage the books and accounts of a particular organisation. This blog will get to know more about exporting the google timeline data in QuickBooks Desktop software. I hope that this blog was helpful and was worth your time. This

Share this Link:
Call for Help & Support