✦Template Printable Ideas Insights

Mastering Mileage Tracking in QuickBooks Online: A Step-by-Step Guide

By

If you're a small business owner or accountant managing expenses and transactions, you likely use QuickBooks Online. One powerful feature of QuickBooks is its ability to track and handle mileage expenses. Here's how to make the most of mileage tracking in QuickBooks Online.

Before we dive in, ensure you have the Mileage Tracker add-on activated in your QuickBooks Online account. This tool, powered by Triplog, allows automatic tracking and importing of mileage.

Setting Up Mileage Tracking

To start, you'll need to set up vehicles and set your mileage rate in QuickBooks Online.

How to Track Mileage in QuickBooks Online?
How to Track Mileage in QuickBooks Online?
The Quick Start Guide to QuickBooks - Small Business Sarah
The Quick Start Guide to QuickBooks - Small Business Sarah
How to Use QuickBooks Online
How to Use QuickBooks Online

Adding Vehicles

To add a vehicle, go to 'Settings' > 'Accounting' > 'Chart of Accounts', then click 'New' to add a new account type 'Vehicle'. Fill in the vehicle details and click 'Save and Close'.

Next, go to 'Expense' > 'Vehicles'. Click 'New' and select the vehicle you just added. Enter the vehicle details, such as make, model, year, and odometer reading. Click 'Save'.

How to Manage BANK FEEDS in QuickBooks Online
How to Manage BANK FEEDS in QuickBooks Online
20+ Quickbooks Online Videos
20+ Quickbooks Online Videos
Quickbooks Basics: How To Use Quickbooks Online
Quickbooks Basics: How To Use Quickbooks Online

Setting Your Mileage Rate

Setting your mileage rate is crucial as it determines the deduction for each mile driven. Go to 'Settings' > 'Accounting' > 'Products & Services'. Click 'New' to create a new service item, name it 'Mileage', and set the rate according to the latest IRS standard mileage rate.

After setting up, your mileage expenses should automatically sync with QuickBooks Online when you use the Mileage Tracker app or plugin.

Tracking Mileage

Now that everything is set up, you're ready to start tracking mileage. If you prefer automated tracking, consider using the Mileage Tracker app. Here's how:

Step by Step Instructions for QuickBooks Online
Step by Step Instructions for QuickBooks Online
How to Set Up and Use Classes in QuickBooks
How to Set Up and Use Classes in QuickBooks
Learn Quickbooks Accounting
Learn Quickbooks Accounting
My favorite Quickbooks features for Online Businesses | DIY Bookkeeping
My favorite Quickbooks features for Online Businesses | DIY Bookkeeping
Paying & Reimbursing Yourself in QuickBooks
Paying & Reimbursing Yourself in QuickBooks
How to Set Up Customers in QuickBooks Online?
How to Set Up Customers in QuickBooks Online?

Automatic Mileage Tracking

Connect your smartphone to the Mileage Tracker app. When you drive, the app will automatically detect your trip, record the distance, and upload it to your QuickBooks Online account.

You can review and edit these trips in the 'Expense' > 'Mileage' section of QuickBooks Online. Once satisfied, click 'Add to QuickBooks' to create journal entries and incorporate the mileage expenses into your financial records.

Manual Mileage Tracking

For manual tracking, click on 'Expense' > 'New Transaction' > 'Mileage'. Select the vehicle used and the date. Enter the odometer start and end readings. The app will calculate the trip distance. Add appropriate details like purpose of the trip, and click 'Save and New' or 'Save and Close'.

How to Enter Bounced or Returned Payments From Customer in QuickBooks Online
How to Enter Bounced or Returned Payments From Customer in QuickBooks Online
Let's talk Quickbooks 🤝 Dubsado!
Let's talk Quickbooks 🤝 Dubsado!
10 QuickBooks Online Hacks That'll Transform A Newbie Into A Pro
10 QuickBooks Online Hacks That'll Transform A Newbie Into A Pro

Regularly reviewing and adding these manual entries will keep your mileage expenses up-to-date.

Remember, staying consistent with your mileage tracking can save you time and maximize your tax deductions. Stay organized, and you'll enjoy the benefits of accurate and efficient mileage tracking in QuickBooks Online.