cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
chrislisle11
Level 1

I have my own mileage log on a spreadsheet. How can I import the CSV file just for this as there does not seem to be a facility for it?

 
Solved
Best answer May 06, 2020

Accepted Solutions
Angelyn_T
QuickBooks Team

I have my own mileage log on a spreadsheet. How can I import the CSV file just for this as there does not seem to be a facility for it?

Thank you for getting back to us here on the Community page, @chrislisle11.

 

My colleague RaymondJayO is using Firefox does he was asked where he wants to open the file with. The options after downloading the Download Trips button depend on the browser you're using. 

 

I've added these screenshots for your visual reference.

c1 1.PNGc1 2.PNGc1 3.PNG

 

Also, the download just shows a blank spreadsheet file with the mileage heading if there are no trips or transactions added on the date you've selected during the download.

c1 4.PNG

 

Let me know if you have any other questions. I'm always here to help. Have a good day!

View solution in original post

5 REPLIES 5
John C
QuickBooks Team

I have my own mileage log on a spreadsheet. How can I import the CSV file just for this as there does not seem to be a facility for it?

Hi chrislisle11

 

If you are the Master Admin of your account you should be able to download your CSV file by selecting mileage, from the menu on the right handside > select the relevant year > download > select the file.

chrislisle11
Level 1

I have my own mileage log on a spreadsheet. How can I import the CSV file just for this as there does not seem to be a facility for it?


Hi

 

Thanks but there is no option on Right hand side.

 

 

RaymondJayO
Moderator

I have my own mileage log on a spreadsheet. How can I import the CSV file just for this as there does not seem to be a facility for it?

Hello there, @chrislisle11

 

The steps provided by my peer above apply when you're downloading trips as a CSV file from the program. I've attached a screenshot below on how this process looks like in QuickBooks Online (QBO). Rest assured that I have an alternative method to bring in your mileage data to QBO. 

DownloadTripsInQBO.PNG

 

Right now, there isn't an option to import the file from the Mileage menu on the right-hand side. As a workaround, I recommend manually adding the trips from there. Please use the spreadsheet as your reference before performing the steps below. 

  1. Go to Mileage from the left menu. 
  2. Click Add Trip.
  3. Add the Trip date, Distance, Starting/Ending points, Description, Vehicle, and the trip purpose.
  4. Click Save.
  5. Repeat the process for the other trips. 

 

The screenshot below shows you the third to fourth steps. For more details, see the How to manually track your mileage section through this article: Mileage Overview

ManuallyAddTripsInQBO.PNG

 

Also, I'd suggest visiting this website: QBO UK Blog. You'll learn more about our product improvements in this link. Then, scroll down the page. That way, you can enter your Email address and click Subscribe in the Let's stay in touch section. It helps you get the latest tips, advice, and resources straight to your inbox to help your business succeed. 

 

As always, you can go back to the Mileage menu. From there, you can edit and duplicate your trips (see the screenshot below). Doing so will help ensure your trips are up to date in QBO. 

EditAndDuplicateTrips.PNG

 

Please know that I'm here anytime you need further assistance. Keep safe always, @chrislisle11

chrislisle11
Level 1

I have my own mileage log on a spreadsheet. How can I import the CSV file just for this as there does not seem to be a facility for it?

The download trips option just downloads a blank spreadsheet file with the mileage headings. Your screen shot looks like I could select a file but I don’t get the dialogue box or a choice of file on my system

 

Angelyn_T
QuickBooks Team

I have my own mileage log on a spreadsheet. How can I import the CSV file just for this as there does not seem to be a facility for it?

Thank you for getting back to us here on the Community page, @chrislisle11.

 

My colleague RaymondJayO is using Firefox does he was asked where he wants to open the file with. The options after downloading the Download Trips button depend on the browser you're using. 

 

I've added these screenshots for your visual reference.

c1 1.PNGc1 2.PNGc1 3.PNG

 

Also, the download just shows a blank spreadsheet file with the mileage heading if there are no trips or transactions added on the date you've selected during the download.

c1 4.PNG

 

Let me know if you have any other questions. I'm always here to help. Have a good day!

Need to get in touch?

Contact us