Skip to main content
August 29, 2022
Solved

Mileage expenses in standard reports

  • August 29, 2022
  • 1 reply
  • 0 views

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.

Best answer by Giovann_G

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.


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.

1 reply

Tori B
August 29, 2022

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! 

 

jacktjlAuthor
August 29, 2022

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.

 

 

August 29, 2022

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!