cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Melanie B73
Level 1

Can I change inventory tracking from FIFO to weighted average for specific products? ie... FIFO- for store items, W/Avg for gasoline.

My challenge is in prev acct. program I could do this. Haven't figured it in QB yet... So I may need to change how I enter Gasoline sales. All other categories are entered only as a $ amount, not item count ( in sales ). But with gasoline, the cost changes every delivery and so does the margin. So I can't enter a flat cost % like I can for store items... (cost vs price in item setup to figure COGS) When I enter fuel sales I do quantity of gallons, and the price.... instead of just cost like other categories. So I/S is pulling the quantity of gallons sold as the cost for COGS purposes.
3 Comments 3
GlinetteC
Moderator

Can I change inventory tracking from FIFO to weighted average for specific products? ie... FIFO- for store items, W/Avg for gasoline.

Hello, Melanie B73. Let me share some insights about how inventory works in QuickBooks Online.

 

QBO only handles inventory in the FIFO method. 

 

In the meantime, you can search for an inventory management app that lets you do this in QBO. You can go to the Apps and browse for apps that integrate with QBO. I'll show you how:

 

  1. Go to the Apps tab.
  2. Type in inventory tracking in the Search by name or category field.
  3. Or you can click the Browse category drop-down for a more specific search.

Also, you can visit our QuickBooks Apps to find the right app for your business.

 

You can also check this article for additional reference about the FIFO method: What is FIFO and how is it used for inventory cost accounting?.

 

I'm always around if you have any other questions about managing inventory in QuickBooks Online.

Fiat Lux - ASIA
Level 15

Can I change inventory tracking from FIFO to weighted average for specific products? ie... FIFO- for store items, W/Avg for gasoline.


@Melanie B73 wrote:
My challenge is in prev acct. program I could do this. 

 

@Melanie B73 

Which accounting program did you have? Do you run a manufacturing company or a wholesale/retail one?

Melanie B73
Level 1

Can I change inventory tracking from FIFO to weighted average for specific products? ie... FIFO- for store items, W/Avg for gasoline.

I used Sage Business Works and run a retail company.  I didn't run FIFO and W/A exactly, but the way inventory was tracked I could pull a weighted average cost every day, while also tracking dollars instead of units for inventory purposes.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us