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.
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'.
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:
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'.
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.