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!

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

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

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.

I have set up the same way to track fuel for each vehicle now when I print a report I would like to average the cost of the fuel it adds the gal. and amount but is there a way to average the cost in the report.

Hi there, @dduffy57.

You've got me here to share some information about how average costing works in the system.

QuickBooks Desktop calculates the average cost for the items sold. To get the average cost of the fuel you can manually calculate this through Excel. You'll need to pull up a Custom Transaction Detail Report and filter it with the fuel expense account to see all the transactions.

Here's how:

1. From the menu bar, select on Reports, then tick on Custom Reports.
2. Press on Transaction Detail.
3. Enter the date range and click the Customize Report option at the top.
4. Hit on the Filters tab.
5. In the Choose Filter box, with the Account filter highlighted, choose the fuel expense account from the drop-down list.
6. Refer to the Display section.
7. Under Columns, select Qty and Amount.
8. Hit on OK.
9. Click on the drop-down arrow beside Excel and choose Create New Worksheet.
10. Select Export.

From there, you can now start calculating the average by entering =average() in the formula section. Please see the sample snip below for reference: 

I'm also adding here some links that talks about the average costing in QBDT and on how to customize reports for your guide:

• Understand inventory assets and cost of goods sold tracking
• Customize reports in QuickBooks Desktop

I'll be around to help if there's anything else you need. Just let me know by dropping a comment below. Take care!

would you know if I can change sales tax  to excise tax in quick books because I collect excise tax not sales tax

Hello, @dduffy57.

You can set this excise tax as sales tax. Follow the steps below: 

1. Go to Edit menu then Preferences.
2. Click Sales Tax and choose Company Preferences.
3. Select Add sales tax item. 
4. Under Type, choose Sales Tax Item. Then, type the Sales Tax Name, Description, Tax Rate (%), and the Tax Agency (vendor that you collect for).
5. Click on OK once you're done. 

To apply the excise tax, just add the sales tax item under the Tax column and the Tax drop-down in the invoice.

Here's more information on how to set up sales tax in QuickBooks Desktop. Also, you can check the following article on how to resolve common sales tax issues.

Let me know if you still need further assistance in setting this up. I'm always here to assist. Stay safe and have a wonderful day!

thank you I'v done that and when I print an Invoice it prints sales tax on invoice is there a way to change that so it prints Excise tax thanks for your help.

Hello @dduffy57,

As of that moment, there isn't an option to change and modify the sales tax function. With this, you can create a service item for the excise tax you're collecting.

1. Go to Lists.
2. Select Item List.
3. On the Item menu, select New.
4. Under TYPE, select Service.
5. Enter the name and the tax amount.
6. Select an appropriate account.
7. Click OK.

From here, you can start creating your sales transactions and make sure to include the recently created service item.

Lastly, here's a few articles you can read for ideas in managing your customers and sales transactions: Income and Expenses for QuickBooks Desktop.

Keep me posted in the comments down below if you have any other questions. I'll be happy to help.

thank you I've done that way also  thanks for the help.

Welcome to the Community. It appears you've created a blank post, @SS2005.

To assist you properly, I'd like to ask for additional details on the issue at hand. This way, I can provide you the steps for a resolution, or an answer to your question. 

Please feel free to post a reply below. I'm looking forward to hearing back from you. Enjoy the rest of the day!