Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
Jewelrymanufacturing
Level 1

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

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 Comments 2
On Beta
Level 6

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

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

LouiseG
QuickBooks Team

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

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.
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us