cancel
Showing results for 
Search instead for 
Did you mean: 
Lennyplus4
Level 1

Mileage

Suggestions how to gather the total mileage for prior year? Probably simple task that I can’t figure out. 

13 Comments 13
KhimG
QuickBooks Team

Mileage

Good day, @Lennyplus4.

 

Thanks for dropping by the Community. I’m here to make sure you’re able to gather the total mileage for the prior year on your account.

 

You can track mileage to both QuickBooks Online and Self-Employed. However, you'll need to manually do this in QBO by setting up an employee as a vendor, creating an expense account, Product/Service item and entering bills. Here’s an article for reference: How to track mileage.

 

While in QBSE, the system uses your location to track your trips automatically. Check out this article for more information: Automatic mileage tracking in the mobile app

 

To get the total mileage for the prior year, go to the Miles tab. Here’s how:
1.    Go to Miles in the left navigation.
2.    In the Miles tab, click the Date drop-down and select the appropriate yearly options.
 


That should do it. Reach out to me if you need more help getting a mileage report in QBSE, I’ll be more than happy to help. Thanks for reaching out and take care!

Alpaca
Level 1

Mileage

Hi,

Struggling to find a summary report of my mileage for 2018 for tax purposes.  I reviewed your previous answer, but on my version of QBSE, I do not have a tab for Miles.  I have a tab for Trips, but that just gives me a detailed summary of all of my trips for 2018.  Is there no way to pull a summary report for 2018 that shows total miles business, total miles personal?  I really hope there is, because that's the whole reason I signed up in order to receive this year-end type of reporting....many thanks for your assistance!

 

Cathy

IamjuViel
QuickBooks Team

Mileage

Good day, @Alpaca.

 

I want to provide you with details on how to generate mileage reports in QuickBooks Self-Employed.

 

To start with, QuickBooks Self-Employed only have 3 available types of reports:

  • Profit and Loss
  • Tax Summary Report
  • Tax Details Report.

However, you need not to worry, you can still download a copy of your tracked mileage as a CSV file.

 

Here’s how:

  1. Go to Miles tabs.
  2. Under Type drop-down list, choose Business.
  3. In the Date drop-down list, select 2018.
  4. Click the Download Icon.


 That should do it! Just change the type of tracked mileage Business to Personal. This will allow you to download a complete list of your tracked mileage for 2018.

 

Should you have other questions about generating mileage reports, please don’t hesitate to visit us here in the Community.  I’m always here to help.

CEGS
Level 1

Mileage

How do you get the summary of the total amount of mileage for the year?

I have the report of all trips, but I can't see how to print the total amount and the amount I can deduct, like at the top of page on miles where it says total...my report just has each trip not the total.

MaryLandT
Moderator

Mileage

You're on the right track, CEGS.

 

All that's left to do is download the Miles report to Excel. The file provides the list of mileage deductions. From there, you can manually calculate the total.

 

Let me show you how:

 

  1. Go to Miles from the left menu.
  2. Select All, then the specific year.
  3. Click the Download icon.
    totalmileagedeductions.PNG
  4. Open the downloaded Excel file.
  5. Add all fields in the Deduction column.
    totalmileagedeductions1.PNG

I'm adding these articles to help run reports needed at the end of the year:

Stay in touch with me if you need anything else aside from getting the total amount of your mileage. I'll be around to help you.

Pastor Frazier
Level 1

Mileage

i need to know how to print off my

mileage

MaryLandT
Moderator

Mileage

Let me walk you through printing a mileage, Pastor Frazier.

 

You can download trips to your computer as a CSV file in QuickBooks Online (QBO). And, I'm glad to show you how get the data you need:

 

  1. Go to Mileage from the left menu.
  2. Click the Download Trips icon.
    print mileage.PNG
  3. Open the Excel file and print data from there.

If you need to make some changes to your trips, you can review and edit it. Here are the steps to follow:

  1. Sign in to QuickBooks Online in a web browser.
  2. Go to the Mileage or Trips menu.
  3. Select the All or Reviewed tab.
  4. Find the trip you want to edit.
  5. Select More ▼ and then Edit.
  6. Make your changes.
  7. Select Save.

In case there's an issue when tracking trips on your your QBO app, here's how to fix it.

 

Don't hesitate to leave a comment below if there are other data you need to print in QuickBooks. I'm always around to help you.

WalterMac
Level 1

Mileage

Hi, this is not working for me, i don’t have a download trips button.. how do I get my mileage report?

ZackE
Moderator

Mileage

Thanks for joining this thread, WalterMac.
 

Since you're not seeing the Download Trips button on your Mileage screen, I'd recommend checking the browser in use. It's possible this could have something to do with temporary internet files. Browsing applications store these types of records, but sometimes they can cause issues with certain webpages. You can open a private window and check to see if your Download Trips button shows up.
 

Here's how to access incognito mode in some of the most commonly used web browsers:

  • Google Chrome: Ctrl Shift N
  • Mozilla Firefox: Ctrl Shift P
  • Microsoft Edge: Ctrl Shift P
  • Safari: Command Option P


If you can see it while browsing privately, it's safe to say this problem's being caused by your browser. It can be fixed by clearing cached data and Intuit-specific cookies.
 

In the event it continues not displaying while using incognito, you'll initially want to try switching to another browsing application.
 

Here's a list of supported browsers:

  • Google Chrome
  • Mozilla Firefox
  • Microsoft Edge
  • Safari 11 or newer


You can also check a browser's compatibility with your books by utilizing our browser health checkup tool. QuickBooks supports the current and two previous versions of browsers. If you find that you're using an older version, make sure to update it to its latest release. Steps for doing so can be found on the particular company's website.

 

In the event you've found no problems that could be causing this with your browser, I'd recommend using a different device and/or internet connection. If it continues happening on other devices and/or internet connections, you'll want to get in touch with our Customer Care team. They'll be able to pull up your account in a secure environment, conduct further research, and create an investigation ticket if necessary.
 

They can be reached while you're signed in:

  1. Use the Help (?) icon.
  2. Click Contact Us.
  3. Enter a description of your situation in the What can we help you with? field, then hit Let's talk.
  4. Select Start messaging or Get a call.

 

Be sure to review their support hours so you'll know when agents are available.

 

I've also included a detailed resource about system requirements for QuickBooks which may come in handy moving forward: System requirements

 

Please feel welcome to send a reply if there's any additional questions. Have a great day!

soul_craft
Level 1

Mileage

I need the odometer reading, not the mileage recorded by the app. Every year I put in starting and ending mileage but I can't figure out how to find that. 

MariaSoledadG
QuickBooks Team

Mileage

Let me add some details on this, Soul_Craft.

 

Generally, the odometer is used to measure the distance traveled. While mileage is the fuel consumption per kilometer. This means that the distance you have traveled with a car helps you find out the mileage.

 

For now, QuickBooks Online (QBO) only records business miles and vehicle expenses so you can calculate deductions at tax time. You'll only have to turn on mileage tracking and add a vehicle. Then track the business miles. To add a trips manually, follow the steps outlined below:

 

  1. Sign in to QuickBooks Online in a web browser.
  2. Go to Expenses, then Mileage.
  3. Select Add trip.
  4. Add the trip date, starting and ending locations, distance, and purpose.
  5. Choose the vehicle you used.
  6. Click Save.

 

To know more, check out this article on how the app automatically tracks trips from start to finish: Automatically Track Mileage in QuickBooks Online.

 

Furthermore, you may notice missing or inaccurate trips on your phone or tablet. Go through this article if you'll experience issues. Fix Mileage Tracking Issues in the QuickBooks Online Mobile App.

 

You can always get back to us if you have any questions about tracking mileage. We're always right here to help you. 

soul_craft
Level 1

Mileage

Hi Maria,

 

As I said, I need the odometer which WAS recorded every year for the past many years. Last year I was able to find it and used the recorded amount as reference for that year's filing. This year, I can't find it anywhere. 

MariaSoledadG
QuickBooks Team

Mileage

Thanks for the confirmation, soul_craft.

 

Sometimes, this happens if you have browser-related issues. We can perform some troubleshooting steps to fix this. You can log into your account using an incognito window. Use these shortcut keys for easy access:

 

  • Google Chrome: Ctrl + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P
  • Safari: Command + Shift + N
  • Microsoft Edge: Ctrl + Shift + P

 

This mode deletes cookies and browser history leaving your browser clean and easy to access any websites and error-free. Once done, double-check if the option is already showing. If it is, then go back to the main browser to clear its cache and delete some outdated files that might be the cause of the error. Otherwise, use a supported, up-to-date browser.

 

Furthermore, QuickBooks offers different reports that tell you different aspects of your business. You'll only have to customize them to ensure you'll get the right data you need. I've added this article for more details: Customize Reports in QuickBooks Online.

 

Please touch base with us here if you have any questions about mileage. We're always right here to help you anytime. Have a nice day!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us