Skip to main content
September 10, 2024
Question

How can I add and track inventory based on the number of units only and not the dollar value?

  • September 10, 2024
  • 2 replies
  • 0 views

Hello,

 

I own and operate a jewelry manufacturing business where I need to keep track of the precious metals I use when manufacturing jewelry. I am using QuickBooks Online Plus.

 

When I create an invoice, I want to write how much gold I ended up using, and I want that "x" amount to be reflected in my total inventory. I do not want the $ amount, because gold prices change daily.

 

For example, let's say I own 3,000 grams of 24K Gold.

Client A used my services to manufacture a ring, and that ring needed 5 grams of 24K Gold.

I want the invoice to show the labor cost as a dollar value, and the 24K Gold amount as a unit/gram and NOT a $ value.

That way, when I look at my total inventory, it will show 2995g 24K Gold, and it will not be affected by fluctuations in the market.

 

Is there anyway I can do that? Or am I stuck using the dollar value and having to update it every day, and sometimes every couple hours?

 

I really appreciate the help.

2 replies

September 10, 2024

Consider having an inventory management app with assembly feature or a manufacturing app to integrate with QBO.

September 10, 2024
Welcome to the Community!

Let me share some information about tracking inventory based on the number of units in QuickBooks Online (QBO), @Jewelrymanufacturing

Adding a number of units and not the dollar value when creating an invoice isn't supported in QBO. Thus, you may consider exploring a third-party app that integrates with the program and that can accomplish what you need. QBO has a Find Apps feature and here's how you can visit the page:

  1. Sign in to your QuickBooks Online account.
  2. Click Apps at the right panel, then select Find Apps.
  3. Look for the app you wish to connect using the magnifying glass bar or the Browse categories in searching for an app by class.

To personalize your transactions according to your needs, you can refer to this article: Customize invoices, estimates, and sales receipts in QuickBooks Online.

If you have still have questions in mind, don't hesitate to add a Reply below. We're always here ready to help.