Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI 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!!!
Which version (year) and edition do you have? QB 2020 Premier edition?
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)
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?
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?
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.