LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
jacktjl
Level 2

Mileage expenses in standard reports

I started using Quickbooks in June. I noticed that the mileage that has been recorded is not flowing to the standard profit and loss report.  Is there something I need to change in settings to get these transactions to be included in the reports.   I do see all the individual transaction under the mileage tab.

Solved
Best answer August 29, 2022

Best Answers
Giovann_G
Moderator

Mileage expenses in standard reports

Hello, jacktjl.

 

I understand the importance of keeping track of your business miles and vehicle expenses so you have everything you need to calculate deductions when tax time comes around. I'll share some information on how this mileage feature works.

 

Importing and recording mileage expenses under the mileage tab or screen doesn't get reflected in the main account. This is only designed to keep everything in one place and tally the totals so you have everything you need to make tax deductions.

 

The profit and loss statement is a financial statement that summarizes the income, costs, and expenses incurred over a given period. You can create a reimbursement expense for you or your employee if you want the mileage expense to appear on your profit and loss report. I'll show you how.

 

Set up a vendor profile:

 

  1. Go to the Expenses menu, then the Vendors tab.
  2. Select New vendor.
  3. Fill in all the vendor's information.
  4. Once done, hit Save.

 

Set up a mileage reimbursement expense account:

 

  1. Go to Settings ⚙ and select Chart of accounts.
  2. Click New.
  3. From the Account Type dropdown menu, choose Expenses.
  4. From the Detail Type dropdown menu, select Auto or Travel.
  5. Give the account a unique name that's easy to identify.
  6. Once done, hit Save and Close.

 

Create an item for mileage reimbursement:

 

  1. Go to Settings ⚙ and select Products and services.
  2. Click New, then Non-inventory.
  3. Enter your desired name for the item
  4. In the Description section, select I sell this product/service to my customers. Then enter a description.
  5. In the Sales price/rate field, enter the cost you pay for travel per mile.
  6. In the Purchasing information section, select I purchase this product/service from a vendor. Then enter a description.
  7. From the Expense account ▼ dropdown menu, choose the mileage expense account you just created.
  8. Once done, hit Save and close.

 

Create a bill for the mileage reimbursement:

 

  1. Click + New.
  2. Select Bill.
  3. From the Vendor ▼ dropdown menu, choose the vendor you created for mileage.
  4. Select Item details to expand the section.
  5. From the Product/Service dropdown menu, use the mileage item you created.
  6. Enter or update the DescriptionQtyRate, and Amount as needed.
  7. Select the applicable Tax.
  8. Click the Billable checkbox if you need to make this a billable expense for a customer.
  9. Once done, hit Save and close.

 

Record the payment for the Reimbursement expense:

 

  1. Click + New.
  2. Select Pay bills.
  3. Choose the Payment account and the employee to reimburse.
  4. Once done, hit Save.

 

For your reference, you can visit this article: Reimburse employees' mileage and vehicle expenses in QuickBooks Online.

 

In addition, you can connect your bank or credit card account if you want QuickBooks to automatically download your bank transactions: Connect bank and credit card accounts to QuickBooks Online.

 

Don't hesitate to post again if you need anything else. We're always available to help you.

View solution in original post

16 Comments 16
Tori B
QuickBooks Team

Mileage expenses in standard reports

Good morning, @jacktjl

 

Thanks for reaching out. I hope your day is going great. 

 

In QuickBooks Online, the Profit and Loss report is already set by default to include all income and expense accounts. You can customize the report further to include all registered accounts. Let me walk you through some steps to customize the report so I can ensure you see your mileage expenses. 

 

Here's how: 

 

  1. Open the Profit and Loss report. 
  2. Tap on Customize in the upper right corner of the screen. 
  3. Under the Filter section, click on the accounts dropdown and choose All
  4. Tap on Run Report once you're ready. 

 

That should do it. Let me know if you're still having issues seeing the mileage expenses. I'm here if you need me. Have a good one! 

 

jacktjl
Level 2

Mileage expenses in standard reports

Tori B,

Thank you for your help.  I am sure it would work but there is no FILTER option on my screen.  Is it because I just have quick start?  I only see General and Rows/Columns.

 

 

DebSheenD
QuickBooks Team

Mileage expenses in standard reports

Hi, jacktjl.

 

Thanks for joining this thread. Allow me to chime in and share some information about customizing the Profit and Loss report in QuickBooks Online (QBO).

 

The report mentioned by Tori B is an Account report. You can pull up through Chart of Accounts or Profit and Loss report since you created an account specific for mileage transactions.

 

Here's how to open P&L report:

 

  1. Go to Business overview then hit Reports (Take me there).Locate and select the Profit and Loss report.
  2. In the open Profit and Loss report, select Customize.
  3. In the Customize report panel, select the Rows/Columns item to open the section.
  4. From the Columns dropdown list, select Locations. If you applied a different label to the field, select that label.
  5. Select Run report.

 

You'll want to check this article to learn which reports are available for your QBO version: Reports included in your QuickBooks Online subscription.

 

Just in case you want to improve your QBO subscription and have a filter option, feel free to check out this article for detailed steps: Upgrade or downgrade your QuickBooks Online subscription.
 

You can get back to me anytime if you have additional questions about customizing a report in QBO. Take care!

jacktjl
Level 2

Mileage expenses in standard reports

Debra,

Thank you for the information.  Simple Start does indeed show the Profit and Loss report as standard.  The problem is that the report is incomplete and does not show the mileage transactions I have entered since Jun 14th 2022.   The report does include mileage transactions imported from GoDaddy from Feb 2022 to Jun 14,2022.  Is there some type of possible issue  related to that import.  

 

Having all expenses in the standard report is as basic as it gets. Right now I don't have that information and am not receiving what I am paying for.  Do you have any ideas for a remedy?  I don't beleive that I should have to upgrade.

Giovann_G
Moderator

Mileage expenses in standard reports

Hello, jacktjl.

 

I understand the importance of keeping track of your business miles and vehicle expenses so you have everything you need to calculate deductions when tax time comes around. I'll share some information on how this mileage feature works.

 

Importing and recording mileage expenses under the mileage tab or screen doesn't get reflected in the main account. This is only designed to keep everything in one place and tally the totals so you have everything you need to make tax deductions.

 

The profit and loss statement is a financial statement that summarizes the income, costs, and expenses incurred over a given period. You can create a reimbursement expense for you or your employee if you want the mileage expense to appear on your profit and loss report. I'll show you how.

 

Set up a vendor profile:

 

  1. Go to the Expenses menu, then the Vendors tab.
  2. Select New vendor.
  3. Fill in all the vendor's information.
  4. Once done, hit Save.

 

Set up a mileage reimbursement expense account:

 

  1. Go to Settings ⚙ and select Chart of accounts.
  2. Click New.
  3. From the Account Type dropdown menu, choose Expenses.
  4. From the Detail Type dropdown menu, select Auto or Travel.
  5. Give the account a unique name that's easy to identify.
  6. Once done, hit Save and Close.

 

Create an item for mileage reimbursement:

 

  1. Go to Settings ⚙ and select Products and services.
  2. Click New, then Non-inventory.
  3. Enter your desired name for the item
  4. In the Description section, select I sell this product/service to my customers. Then enter a description.
  5. In the Sales price/rate field, enter the cost you pay for travel per mile.
  6. In the Purchasing information section, select I purchase this product/service from a vendor. Then enter a description.
  7. From the Expense account ▼ dropdown menu, choose the mileage expense account you just created.
  8. Once done, hit Save and close.

 

Create a bill for the mileage reimbursement:

 

  1. Click + New.
  2. Select Bill.
  3. From the Vendor ▼ dropdown menu, choose the vendor you created for mileage.
  4. Select Item details to expand the section.
  5. From the Product/Service dropdown menu, use the mileage item you created.
  6. Enter or update the DescriptionQtyRate, and Amount as needed.
  7. Select the applicable Tax.
  8. Click the Billable checkbox if you need to make this a billable expense for a customer.
  9. Once done, hit Save and close.

 

Record the payment for the Reimbursement expense:

 

  1. Click + New.
  2. Select Pay bills.
  3. Choose the Payment account and the employee to reimburse.
  4. Once done, hit Save.

 

For your reference, you can visit this article: Reimburse employees' mileage and vehicle expenses in QuickBooks Online.

 

In addition, you can connect your bank or credit card account if you want QuickBooks to automatically download your bank transactions: Connect bank and credit card accounts to QuickBooks Online.

 

Don't hesitate to post again if you need anything else. We're always available to help you.

jacktjl
Level 2

Mileage expenses in standard reports

Thank you for the explanation and process.  This is very helpful.

 

LieraMarie_A
QuickBooks Team

Mileage expenses in standard reports

Hi there, @jacktjl.

 

I'm happy to hear that my peer was able to help you with the process. Visit us again if you have any other concerns. We're always here to assist.

 

Have a lovely day!

ssllc2222
Level 1

Mileage expenses in standard reports

Despite reading through these posts multiple times, I'm still unsure how to get my mileage deduction into the Profit & Loss Statement.

 

I've entered mileage for all of my trips. How can I pull what is already entered in the system into the P&L Statement?

 

Having all of my expenses incorporated into the P&L is a basic accounting function. But right now I can't seem to get that, which is what I'm paying for. How can this be accomplished without me making duplicate entries with your "vendor" creation solution? I don't believe I should have to make duplicate entries or upgrade to get this basic functionality.

Bryan_M
QuickBooks Team

Mileage expenses in standard reports

Let me help you shed some light, @ssllc2222 

 

QuickBooks Online (QBO) only tracks mileage for recording reasons. As a result, it is excluded from the client profitability report and income statement.

 

You can use the data in the mileage tab to create the expense transaction manually.

 

You can also submit feedback straight to our product developers so they can review this option and help you with your business needs.


Here’s how you can add your feedback in QBO:

 

  1. Go to the Gear icon.
  2. Under the Profile column, click on Feedback.
  3. Share your feedback. Then, click "Next."

 

For future reference, you can utilize this article to automatically track mileage in QuickBooks Online.

 

In addition, if you’re using your personal car for business, then I suggest checking out this article. It's about reimbursing employees' mileage and vehicle expenses in QuickBooks Online.

 

Let me know if you have further questions in mind about mileage. I’m just one post away from assisting you. Have a great day!

ssllc2222
Level 1

Mileage expenses in standard reports

I appreciate your response, Bryan, and I have submitted feedback to the developers using the Gear icon. 

 

However, this process is still so incredibly disappointing. This is such a basic accounting function. It makes no sense to create duplicate entries to accomplish something so basic.

Lucie hird
Level 1

Mileage expenses in standard reports

for the first step with the New vendor information - what do you put here?  this is for my own personal mileage throughout the year,  Do I add myself as a vendor?

DebSheenD
QuickBooks Team

Mileage expenses in standard reports

Welcome to the Community, @Lucie hird.

 

I'm here to help you with mileage expenses in QuickBooks Online (QBO).

 

Yes, you can add yourself as a vendor in QuickBooks Online for tracking your mileage. Just enter your name and relevant details to categorize your expenses.

 

Here's how to set up a vendor profile:

 

  1. Go to the Expenses menu, then the Vendors tab.
  2. Select New vendor.
  3. Fill in all the vendor's information.
  4. Once done, hit Save.
     

In the meantime, you can check this article for additional guidance on how you can categorize your mileage via mobile or web browser: Automatically track mileage in QuickBooks Online.
 

I'm also adding this link here in case you encounter issues tracking mileage: Fix mileage tracking issues in the QuickBooks Online mobile app.

 

Feel free to comment down below if you have any other concerns or questions about printing your mileage report. I'm always glad to help in any way I can.

psych4kids
Level 1

Mileage expenses in standard reports

These instructions do not work for me. When I get to new bill the options in the instructions do not exist. There really must be an easier way to do this. 

AlverMarkT
Moderator

Mileage expenses in standard reports

Thanks for joining the thread, @psych4kids. I'm here to help. 

 

To provide better assistance, may I kindly inquire as to what happens when you enter a bill? It would also greatly help us if you could attach a screenshot of the issue you encountered. 

 

Aside from creating a bill to track your mileage expenses, you can consider creating a check or expense instead.

 

I also encourage sending feedback, especially about easier ways to handle and manage mileage expenses to show in standard reports. Here's how: 

 

  1. In your QBO account, go to the Gear icon.
  2. Select Feedback.
  3. Enter your comments or product suggestions.

 

Let me add these resources to assist you in automatically monitoring your business mileage and effectively evaluating the value of your vehicle: 

 

 

We'll be on the lookout for your reply about handling mileage expenses in QBO. We're committed to offering ongoing support. Take care.

MacS_01
Level 1

Mileage expenses in standard reports

I'm the sole member of my LLC. So my mileage accruals are a simple expense incurred that should be reflected in the P&L. To make me double enter this every time I travel is insane. I can understand the desire or need to track who you are expensing mileage reimbursements for in a larger organization with employees. But a simple on/off toggle for Mileage that allows you to simply accrue each trip as an expense to the overall P&L for single member LLCs should be a no-brainer. I imagine there are a LOT of single member LLCs - probably the largest user group of this type of software. Why make it harder for your core audience than necessary? This software is not customer-centric if an unchangeable default is not set up for the majority of users. 

MacS_01
Level 1

Mileage expenses in standard reports

I'm the sole member of my LLC. So my mileage accruals are a simple expense incurred that should be reflected in the P&L. To make me double enter this every time I travel is insane. I can understand the desire or need to track who you are expensing mileage reimbursements for in a larger organization with employees. But a simple on/off toggle for Mileage that allows you to simply accrue each trip as an expense to the overall P&L for single member LLCs should be a no-brainer. I imagine there are a LOT of single member LLCs - probably the largest user group of this type of software. Why make it harder for your core audience than necessary? This software is not customer-centric if an unchangeable default is not set up for the majority of users. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us