✦Template Printable Ideas Insights

Track Mileage in QuickBooks Desktop: A Step-by-Step Guide

By

Tracking mileage is a crucial aspect of managing your business, especially if you use vehicles for work purposes. QuickBooks Desktop, a popular accounting software, offers an effective way to monitor and manage your vehicle mileage. Here's how you can track mileage in QuickBooks Desktop step by step.

Before you start, ensure you have set up your vehicle and related accounts in QuickBooks Desktop. You'll also need to record your odometer readings regularly for accurate tracking.

Setting Up Your Vehicle

To begin tracking mileage, you first need to set up your vehicle in QuickBooks Desktop.

Tracking Vehicle Mileage in QuickBooks Desktop 2024
Tracking Vehicle Mileage in QuickBooks Desktop 2024
How to Track Mileage in QuickBooks Online?
How to Track Mileage in QuickBooks Online?
How to Enter Mileage in QuickBooks - Track & Categorize
How to Enter Mileage in QuickBooks - Track & Categorize

1. Go to the "Company" menu, select "Setup," and then click on "Vehicles."

Adding a Vehicle

To add a new vehicle, click on the "Vehicle List" tab, then select "New" from the drop-down menu.

UK Mileage Expense Tracker | Self Employed HMRC Rates (Excel Download)
UK Mileage Expense Tracker | Self Employed HMRC Rates (Excel Download)
Mileage Log and Tracker, Excel and Google Sheets, Business Mileage Deduction Spreadsheet for Self Employed, Instant Download
Mileage Log and Tracker, Excel and Google Sheets, Business Mileage Deduction Spreadsheet for Self Employed, Instant Download
Mileage Tracker Spreadsheet | Google Sheets Log for Tax Deduction (Digital Download)
Mileage Tracker Spreadsheet | Google Sheets Log for Tax Deduction (Digital Download)

1. Enter your vehicle's details such as make, model, year, and license plate number. Also, input the purchase price, date, and any related expenses.

Setting Up Mileage Tracking

After adding your vehicle, you need to set up mileage tracking.

1. Go back to the "Vehicles" window and select the vehicle you just added. Click on "OK" to close the window.

Mileage Tracker Spreadsheet with Auto IRS Rate for Excel and Google Sheets
Mileage Tracker Spreadsheet with Auto IRS Rate for Excel and Google Sheets
IRS Mileage Log Template | Vehicle Expense Tracker Spreadsheet | Self-Employed Business Mileage | CPA Built Excel
IRS Mileage Log Template | Vehicle Expense Tracker Spreadsheet | Self-Employed Business Mileage | CPA Built Excel
Mileage Tracker Spreadsheet, Vehicle Fuel & Service Log with IRS Tax Deduction, Auto Dashboard
Mileage Tracker Spreadsheet, Vehicle Fuel & Service Log with IRS Tax Deduction, Auto Dashboard
Vehicle Cost Per Mile Tracker -- Google Sheets Template with AI Assistant
Vehicle Cost Per Mile Tracker -- Google Sheets Template with AI Assistant
Reseller Mileage and Expense Tracker Spreadsheet, Small Business Tax Log, Mileage Deduction & Expenses, Excel + Google Sheets
Reseller Mileage and Expense Tracker Spreadsheet, Small Business Tax Log, Mileage Deduction & Expenses, Excel + Google Sheets
Mileage Log Tracker, Auto Tax Deduction Spreadsheet (Digital Download)
Mileage Log Tracker, Auto Tax Deduction Spreadsheet (Digital Download)

2. In the "Vehicle List" window, click on the "Mileage" tab. Here, you can set up your mileage tracking preferences. Choose how you want to track mileage (by date, by time period, or both) and set up your starting odometer reading.

Recording Odometer Readings

Regularly recording your odometer readings is vital for accurate mileage tracking. Here's how you can record odometer readings in QuickBooks Desktop.

1. Go to the "Company" menu, select "Setup," and then click on "Vehicles."

Mileage Log Excel | Template Business
Mileage Log Excel | Template Business
Mileage Tracking Spreadsheet excel, Google Sheets, Mileage Tracker, Business,personal, Mileage Log, Mileage Tracker Template
Mileage Tracking Spreadsheet excel, Google Sheets, Mileage Tracker, Business,personal, Mileage Log, Mileage Tracker Template
Mileage Log Tracker (HTML Web App Digital Download)
Mileage Log Tracker (HTML Web App Digital Download)

Recording a New Odometer Reading

To record a new odometer reading, follow these steps:

1. In the "Vehicle List" window, select the vehicle for which you want to record the odometer reading.

2. Click on the "Mileage" tab. Click on "Record Mileage" and select "Current Mileage."

3. Input the new odometer reading and choose the date. Click "OK" to save.

Recording Mileage for Business Trips

When you record your odometer reading, you can also record mileage for business trips. Here's how:

1. In the "Record Mileage" window, click on "Business."

2. Enter the business purpose, date, and odometer readings (both starting and ending). Click "OK" to save.

Running Mileage Reports

After recording your mileage, you can generate reports to monitor and analyze your vehicle usage.

1. Go to the "Reports" menu, select "Accountant & Taxes," and then click on "Mileage."

Running an Odometer Reading Report

To generate a report of your odometer readings, select "Odometer Reading".

1. Choose the date range and the vehicle(s) you want to include in the report. Click "Run Report."

Running a Vehicle Mileage Report

To generate a report of your vehicle mileage, select "Vehicle Mileage."

1. Choose the date range, vehicle(s), and the mileage tracking method (by date or by time period). Click "Run Report."

Tracking your mileage in QuickBooks Desktop can help you manage your vehicle expenses more effectively and ensure you're only claiming legitimate business mileage for taxes. Regularly update your odometer readings and run mileage reports to maintain accurate records.