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. 

7 Comments
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
QuickBooks Team

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
QuickBooks Team

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.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us