cancel
Showing results for 
Search instead for 
Did you mean: 
elementsltd
Level 1

Inventory, COGS, manufacturing

I have done a lot of reading about inventory, COGS, assemblies, and manufacturing with QB, however my situation is different enough that I am not sure how other answers might apply. I am hopeful that if I lay out our business process someone much smarter than myself will be able to translate this into the accounting methods and steps to use in QB.

 

FYI - we are a small family business. We will be doing the following process 1-4 times per year.

 

Process:

 

1. We purchase a shipping container of logs from overseas. That purchase covers all costs up to arrival at US port of entry.

2. We arrange and pay the customs broker, transportation, and other logistics to get the container from port of entry to a local sawmill. 

3. We pay the sawmill to cut the logs into lumber and dry it in their kiln. Each log is unique and generates different quantities and qualities of lumber.

4. We sell the lumber (primarily wholesale or consignment).

 

What I do not understand is if I should be tracking the logs as an inventory item, or if I should only be tracking the finished product (lumber). If I do track the logs, please help me better understand that full process, and how I manage the changes in inventory when the logs become lumber. Lastly, I do not understand if the log purchase would fall into COGS Purchases, or how the COGS aspect works with our process.

 

I may be completely asking the wrong questions or headed down the wrong path. Please help me understand what to do in QB to correctly model our business processes.

 

Thank you for your help!!!

 

5 Comments 5
Fiat Lux - ASIA
Level 15

Inventory, COGS, manufacturing

Which version (year) and edition do you have? QB 2020 Premier edition?

john-pero
Community Champion

Inventory, COGS, manufacturing

As far as an inventory item I would only track the finished product. As you admitted, you do not know the end result of each log when purchased so to track each log as an item to be divided up and add incremental charges to is overwhelming.  Think if you owned the forest, or a vineyard (my specialty), or a wheat field. A crop that you harvest or is harvested for you can in fact be inventory but you are performing an added value before you make it available for resale.  Your total costs of creating boards ready for sale are your COGS and cannot be expensed until you sell your finished product - but you do not necessarily have to track the changes in inventory from logs to boards - just the raw ingredients and the added value. Now you certainly can allocate average costs of production across the inventory of board feet and quite possibly "board feet" might be ab acceptable increment of inventory, which, if I understand timber industry remotely correct, translates across boards of various widths, lengths, and thicknesses.

 

p.s. depending on what variety of logs you are importing, I have timber companies in my back yard (within 30-50 miles) shipping logs OUT of the US.  Someone should sit in the middle and reduce all the transportation costs (and time lag) 

Firstcarpentry
Level 1

Inventory, COGS, manufacturing

Can quickbooks compute board foot? 

If not, is it possible for me to enter the corresponding number of board foot for each size and have quickbooks mulitpy quantity  x board foot x unit price? 

Firstcarpentry
Level 1

Inventory, COGS, manufacturing

Can quickbooks compute for board foot?

 

Or does quickbooks have boardfoot as unit of measurement?

 

If not,  can I be the one to enter a corresponding board foot for each size of lumber and just have quickbooks multiply the quantity x board foot x price? 

Jovychris_A
Moderator

Inventory, COGS, manufacturing

Thanks for your prompt response, @Firstcarpentry.
 

Currently, QuickBooks has no boardfoot as a unit of measurement. What we can provide is the Quantity type of unit of measurement.
 

You can follow john-pero's recommendation by tracking the finished inventory product only. Then you'll enter the total costs of creating lumber ready for sale as your COGS and cannot be expensed until you sell your finished product so that you don't have to necessarily track the changes in inventory from logs to lumber.
 

You can also look for an application that you can use for tracking your raw material inventory: https://desktop.apps.com/home.

 

Please feel free to leave a message to this post if you have more questions. I'll be around to help. Have a food one!

Need to get in touch?

Contact us