Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi; I have to book several costs for the same inventory item; any ideas how to do? E.g. We import an item and the container has 1000 pieces. The costs are: 1. Item payment to supplier overseas. 2. Customs duties and taxes. 3. Transport costs. So there are several entities being paid for the same 1000 pieces shipment which will go to our inventory. Ideally all these costs should add up and QB should spread those to the 1000 pieces and come up with a unit cost. Many thanks for any help I can get
Solved! Go to Solution.
QB Enterprise is the only version that has the ability to add landed costs to items. It allows you to allocate the cost of multiple bills to an item. You can try this workaround that @Rustler posted a few years ago:
We're delighted to have you here in the Community space, @maali.
When managing or entering an item or product in QuickBooks Online (QBO), you'll only want to add up all the costs to acquire the item and enter them in the Cost field. Once you're ready, determine the exact price of what you sell them for and enter them in the Sale Price/Rate section. We'll gladly write down the steps to get you going:
For further guidelines, please see this page: Add inventory products in QuickBooks Online.
Also, we recommend checking these articles to help you track inventories, and learn more about COGS in QBO:
You can inform us anytime if you have other specific tasks you'd like to complete inside QuickBooks or need assistance managing inventory items. We'll be here to help you out again.
Hi; Unfortunately your answer doesn't help. Imagine I order 1000 units of an item from France. For the 1000 items there is an invoice of the supplier for say 90000 Euros. So I add the 1000 in my inventory for 90000€ then after 6 weeks I have another cost which is also related to these 1000 units and its the customs and import taxes say 40000€. So now this needs to be added to the cost of the same 1000 units but there is no way to add it to the same inventory cost. Then there will be local transport costs etc. What you are suggesting is that we dont book these costs until we know all the costs which is not practical as it means for weeks we may not have the accounts up to date.....
QB Enterprise is the only version that has the ability to add landed costs to items. It allows you to allocate the cost of multiple bills to an item. You can try this workaround that @Rustler posted a few years ago:
Hi, @maali.
I recognize the challenges that you've encountered in your business. I'd like to share some information about how to link your add-ons to your inventory cost.
In QuickBooks Online, it needs to be manually added whenever you make a bill or expense transaction. This will help you record the money-out process for specific items and entities. Once paid, we can create a bundle for an easy invoice recording whenever the customer wants to purchase. Let's set up all your inventory and service items for your bundle.
For Inventory - Container
For Service - Custom and Import taxes
For Service - Transport costs
For Bundle
When you need to manage your inventory, you can set up and track it so that you can get an alert once your inventory needs to be restocked.
You can always get back to me here if you have any other questions about your inventory. I'll be around to lend a hand.
Hello Rainflurry,
Thank you for sharing your input to help address the issue. We love to see members supporting one another! Have a great day.
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