Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
December 31, 2022
Question

Need to BEGIN tracking inventory value

  • December 31, 2022
  • 1 reply
  • 3 views

Hi!

 

  This may be challenging!! How do we begin tracking the inventory value of products we assemble? We've been tracking inventory quantities on the components,  removing and adding as needed without inputting costs. It creates a nightmare when trying to figure out inventory value at year end.  We'd like to enter the costs of all the inventory (components) we just counted at end of year for a clean slate January 1st. 

 

Background: 

 

We assemble products (such as soap dispensers) from 2 inventory components (bottle and pump), and sell the final assembled products alone or in sets. 

 

We reduce the inventory components from stock as they go out via quantity adjustments. I.e. we sell a plastic bottle with a pump (an assembled soap dispenser), we remove both components from inventory.

 

We use sales receipts for groups of sales (i.e. each pay period from marketplaces like Amazon). We just enter the product as an inventory item called "Sales". 

 

How do we do start entering the costs for our components,  so we at least can add them to inventory with costs as we purchase in the future, and have the value automatically subtract when we reduce them from inventory? 

 

We could start scratch by archiving and recreating inventory products with values- but won't that count the COGS twice? (We already have our expenses accounted for as COGS s we purchased components, they're just not tied to inventory items.)

 

Hope that's clear,  and I hope someone had a solution!

 

Thanks!

Christine

 

1 reply

katherinejoyceO
Level 9
December 31, 2022

Hello there, @ArtanisHome

 

I'm delighted to guide you in tracking your inventory value in QuickBooks Online.

 

Here's how:

 

  1. On the left panel, click the Sales menu, then go to the Products and Services.
  2. Select the item you're working on from the list and click the Edit button in the Action column.
  3. Click the Quantity on hand section and hit the Starting value link to see more information about the product.
  4. Select Got it to confirm, then review the item details on the Inventory Starting Value # Start page to ensure the data entered is correct.
  5. Update and enter all the information needed, then click Save and close.

 

Visit this article to learn more about managing your inventory quantity: Inventory Quantity Adjustment in QuickBooks Online.

  

Drop me a line and I'll assist you with more concerns about inventory reports in QuickBooks. I wish you the best of luck!

 

December 31, 2022

Hi Katherine,

 

    Would I set the initial quantity on hand as my current quantity, and put "as of" today?. What do I do if, say, I have 10000 pumps currently, 3000 were bought at $0.25, 4000 were bought at $0.24, and 3000 were bought at $0.26? 

    What would I put for the Inventory adjustment account? If I put "Cost of Goods Sold" as the Inventory adjustment account, wouldn't this double my COGS, since I've already accepted the products as COGS expenses as I purchased them throughout the years?

 

Thanks!

Christine

 

Moderator
December 31, 2022

Thanks for getting back in this thread, @ArtanisHome.

 

The complexity of your concern requires assistance from an accounting expert. That said, I suggest performing this process in collaboration with your accountant or any other competent financial practitioner to ensure that everything is accurate and avoid messing up your inventories.

 

If you're not affiliated with one, you can use our Find an Accountant tool to look for a Pro-Advisor near your area.

 

I’m also adding this resource where you can access our self-help articles: QuickBooks Online guide. These resources contain topics that will guide you on efficiently handling your taxes, payroll, account information, banking tasks, sales or expenses-related activities, and so on.

 

Please know that you can always get back to this thread if you have other questions or concerns about managing your inventories in QBO. I'll be around to provide the information you need. Keep safe!