cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Track fuel usage quantity

I have setup an account for fuel usage, but I can only track the amount and for all vehicles. I want to be able to track the quantity of fuel used per vehicle in a given time. How to do this?

Solved
Best answer 01-18-2019

Accepted Solutions
Level 15

Re: Track fuel usage quantity


@boybi wrote:

I have setup an account for fuel usage, but I can only track the amount and for all vehicles. I want to be able to track the quantity of fuel used per vehicle in a given time. How to do this?


the method proposed by intuit james DuanT will work
But if do it that way it means you have one item per vehicle - that gets very awkward to use

set up a class named for each vehicle

one non inventory items named fuel, and link it to the fuel expense account

use that one item when fuel is purchased, and select the class for the vehicle it is being put in
enter the number of gallons as qty, and enter the total price, QB will do the math for the per gallon price

you can run class report per vehicle,. or all of them from the lists menu

and or you can report on the item and subtotal by class

View solution in original post

5 Comments
Moderator

Re: Track fuel usage quantity

How's your business doing, boybi?

 

We can create an item and associate the fuel usage account. Here's how to do it:

  1. Click Lists at the top menu and select Item List.
  2. Click the Item button and select New.
  3. Choose Non-inventory in the TYPE field and enter the Item Name/Number (vehicle 1, 2, or etc).
  4. Enter the fuel usage account in the Account field.
  5. Click OK.

If you're referring to something different, any additional information would be much appreciated. Thanks in advance!

Level 2

Re: Track fuel usage quantity

Will that be able to let me see how many gallons of fuel each vehicle consumed in a certain period?

Level 2

Re: Track fuel usage quantity

I would like to be able to track the volume of fuel used by each vehicle in a certain period.

Moderator

Re: Track fuel usage quantity

Thanks for getting back to me, boybi.

 

Yes, you should be able to enter the number of gallon for each vehicle. For example, you can go to the Items tab and enter the item you've created earlier.

  1. In the Bill window, go to the Items tab.
  2. Enter the item you created for each vehicle.
  3. Enter the number of gallons in the QTY column.
  4. Enter the cost, amounts, and details of the expense.
  5. Click Save & Close.

I'd also recommend checking this with your accountant. They might have a different way of doing this.

 

I'll be around if you have other concerns.

Capture.JPG

Level 15

Re: Track fuel usage quantity


@boybi wrote:

I have setup an account for fuel usage, but I can only track the amount and for all vehicles. I want to be able to track the quantity of fuel used per vehicle in a given time. How to do this?


the method proposed by intuit james DuanT will work
But if do it that way it means you have one item per vehicle - that gets very awkward to use

set up a class named for each vehicle

one non inventory items named fuel, and link it to the fuel expense account

use that one item when fuel is purchased, and select the class for the vehicle it is being put in
enter the number of gallons as qty, and enter the total price, QB will do the math for the per gallon price

you can run class report per vehicle,. or all of them from the lists menu

and or you can report on the item and subtotal by class

View solution in original post

Need to get in touch?

Contact us