cancel
Showing results for 
Search instead for 
Did you mean: 
maali
Level 2

Booking several costs for same inventory item

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
Best answer November 16, 2023

Best Answers
Rainflurry
Level 13

Booking several costs for same inventory item

@maali 

 

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:

 

https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/re-qb-does-not-handle-lande... 

View solution in original post

5 Comments 5
Kurt_M
QuickBooks Team

Booking several costs for same inventory item

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:

 

  1. Access your QuickBooks Online company.
  2. On the top-right corner, click the Gear icon and then Products & services.
  3. Select New, then select Inventory.
  4. Fill out the required details like Name and SKU.

 

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.

maali
Level 2

Booking several costs for same inventory item

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.....

Rainflurry
Level 13

Booking several costs for same inventory item

@maali 

 

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:

 

https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/re-qb-does-not-handle-lande... 

MelroseV
QuickBooks Team

Booking several costs for same inventory item

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

  1. Go to the Gear icon, then click Products and Services.
  2. Select New and click Inventory.
  3. Under Name, type "Container." It depends on you what name you're going to put.
  4. Fill out the required details. Example: For the Sales price/Rate = 90, For the Cost = 90

 

For Service - Custom and Import taxes

  1. In the Gear icon, select Product and services.
  2. Select New, then choose Service.
  3. Under the Name, type "Custom and Import taxes." 
  4. Fill out the required details. Example: For the Sales price/Rate = 40, For the Cost = 40.

 

For Service - Transport costs

  1. Go to the Gear icon, then select Product and services.
  2. Click New, then choose Service.
  3. Under the Name, type "Transport costs.
  4. Fill out the required details. Example: For the Sales price/Rate = 10, For the Cost = 10.

 

For Bundle

  1. In the Gear icon, click Product and services.
  2. Select New, then click Bundle.
  3. Fill out the required details.
  4. Under Product/Service, click the drop-down in the field.
  5. Choose the name of the bundle that you make.

 

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.

 

AlcaeusF
Moderator

Booking several costs for same inventory item

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.

Need to get in touch?

Contact us