landed costs over multiple sites

Good day, Dean. Allow me to provide some information regarding landed cost for each site to ensure you can track your items correctly in QuickBooks.

You'll want to ensure that the items are categorized accordingly to the correct site when creating a bill. I have attached some screenshots for your reference on how to do this.

Then, recalculate the landed cost. In the Split by drop-down ensure that you split them accordingly so the landed cost will be added to the bill correctly.

The new selling price will be shown, you can update it based on the landed cost or just skip.

Once done, run the Inventory Valuation Detail report to verify the landed costs items and sites. For more details, open this link: Multiple Inventory Sites

In order to provide guidance on how QuickBooks calculates landed cost and tracking your inventories, refer to these resources:
 

• Landed cost FAQs
• How to calculate landed cost in QuickBooks Enterprise Services
• Understand Inventory Assets and Cost of Goods Sold Tracking
   

If you require additional assistance about inventory management or any concerns with QuickBooks Desktop, feel free to leave a comment . I am always available and ready to help. Take good care.

We are trying to track each items landed cost by site. When we receive a bill from the vendor the whole bill is always for one site or the other. I am understanding your instructions to show how to show separate landed cost to two different sites on the same bill. Since both of our sites use the same item numbers and the freight charges are different for each site the landed cost and average ends up being an average between both sites.

When we run a P&L for each site, we are seeing the landed cost for the product to be the same for each site when in fact it is not. This is causing one site to overstate profit and the other site to understate profit.

In order to fix this do we need to have each site to have their own item codes? Currently they are using the same item codes.

Nice to see you again posting your queries in the Community forum, Dean. I'll be glad to share more details about how the landed cost works for each site in QuickBooks Desktop, (QBDT).

Yes, creating separate items (sub-items or assemblies) for each site in QuickBooks Desktop is necessary to resolve the issue of the landed cost for products being the same for each site and causing profit discrepancies. Using the same item codes for multiple sites can cause inaccuracies in the profit and loss report.

Nevertheless, here's an article to help you understand how Landed cost works in QuickBooks Desktop Enterprise. It addresses common questions about Landed cost: Landed cost FAQs.

I'll be around if you have additional questions about managing your inventory in QBDT. Just leave them in the comments section below. Have a wonderful day.