Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello there
I'm just setting up QB Enterprise and I am not sure how to handle labor costs and How can I allocate shipping and freight costs to the inventory assemblies?
We are a small lighting factory. our typical work is assembling and packing the lighting products
firstly we purchase the raw materials and the packaging materials from other factories and then receive them in our store
then, in the production stage we hire some workers to assemble the items and create the final product and they also do the laser marking and packing work
then when the goods are finished, QC company handle the inspection
after that the products are stored until the delivery time then loaded into the container
so now we have
the raw materials
boxes and cartons
designing products and boxes
delivering goods from and to our factory
loading and unloading goods when receiving the goods and loading the containers
laser marking costs
assembly costs
packing costs
inspection fees
container loading costs
I am stuck at recording these costs into the assembly. so what is the best way to create the assembly item including all these costs because my boss used to have each cost recorded separately in excel sheets before moving to QB
I tried to add the labor cost only inside the assembly and keep other costs as expenses but this way we don't get the value of the assembly item correctly
so please advise how to solve it and how to deal with the bills containing these costs
Thanks in advance
Thanks for the details, New Beginning 2021.
I'm here to share some information on how to handle labor cost.
Currently, QuickBooks Desktop isn't able to handle landed costs, however, I have a workaround that you may want to consider.
On each item, you can add portion of the shipping. Then, when creating a bill, manually enter the quantity received on each items and then enter the item cost plus a portion of the shipping. When you click out of the total cost, the system will do the per item rate.
You can use a clearing expense or asset account when paying the bill. Then, modify the original bill for each item and increase the item's total cost by a portion of the third-party shipping. Afterwards, select the clearing account or asset account and then enter the full amount as a negative number.
Upon clicking Save & Close, you'll be prompted with any warnings about payments applied. The system, will redo the purchase cost of each item as of the date of the bill. Whenever an item, have been sold, QuickBooks will make COGS adjustment resulting from the increased per item cost.
Here's an article to know more about adjusting inventory value (Scroll down until you reached the Adjust the value of an inventory item section): Adjust inventory quantity or value.
If you need assistance in doing this, you can reach out to our Phone Support team.
Let me know if you have other concerns. I'll be happy to help you out. Keep safe!
so please advise what is the best way to build the assembly then?
what to add beside the raw materials costs to build the assembly
Thanks for getting back to us, @new beginning 2021,
As mentioned by my peer above, you can add a portion of the shipping cost by manually entering the quantity received on each items as a workaround. This way, it'll override the item's amount on your bill. See the above recommendations for details.
On the other hand, you can create a service item for your costs and fees. This way, you can include them in your assembly build. Here's how:
Below is the image of how it looks like.
Learn more about assemblies in these guides:
Additionally, here's a link that'll help you in creating and running inventory reports: Inventory reports in QuickBooks Desktop.
Please know that you're always welcome to reply anytime if you have follow-up questions. Have a great day ahead.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here