Landed Inventory Cost in QuickBooks Enterprise

QuickBooks 30-day free trial + 30% off for 12 months:
quickbooks.int...
Call our office 954-414-1524 to purchase QuickBooks from us or to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary from $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions [e-mail]

[@albertonicholson7237]

Awesome feature Hector and indeed Intuit should correct/update the screen/forms to show the user important info like the memos and the calculation feature in the New Selling Price screen/form. Well explained.

[@HectorGarciaCPA]

I agree, it didn’t happen, so you need to work with what you have.

[@ArsenalTirePerformanceTech]

Thanks a bunch! You removed any fear of using it and doing a mess.

[@HectorGarciaCPA]

Awesome!

[@khadarbile11]

Good Mentor Mr.Hector Garcia CPA Thank You

[@HectorGarciaCPA]

:)

[@wendysmith2193]

Hi Hector! Love watching your video. My question is around reporting. I'd like to be able to look at a supplier and see the acquisition cost, the landed cost and the new cost of the landed item. Have you been able to pull any reports? I cannot find a way to do this easily. Thanks in advance for any guidance.

[@benbutler8753]

If you did the entire thing again, new bill for inventory and new bills for customs, etc. would the average cost be a combination of the calculated cost for each bill? Bill 1 - Widget 1 - Landed cost is $68 Bill 2 - Widget 2 - Landed costs is $66 Average in Inventory Report would be $67?

[@PeterFRross]

Hector, great tutorial. Landed cost calculates one inventory bill at a time. What workaround would apply for a consolidated shipment (2 or more vendor bills) and one freight bill?

[@HectorGarciaCPA]

Peter Ross it can do multiple for sure.. you just need to add all the bills that contain the costs with the correct mapped items

[@PeterFRross]

@@HectorGarciaCPA Hector, thank you. I'll give it another shot.

[@mohamedkamal9000]

The Idea behind the constant change of interfaces that could be annoying sometimes is not to become old fashioned program. I believe that you would judge an application by its features and functions, but normal user would prefer the newly seemed application over the old looking one. Take facebook for example if they stopped changing their interface the website would've stayed on its first look which would be considered very old fashioned and would kept users away. Thank you Mr Garcia, for the videos and the lessons.

[@HectorGarciaCPA]

mohamed kamal ok

[@alakkodehidayath]

What a Presentation... I really Liked It.. very useful

[@HectorGarciaCPA]

Great!

[@MsStolga]

Thank you

[@PraveenUduweriya]

Neatly explained! Bravo

[@joannabananaberry]

What a cool feature! Thanks for the explanation!

[@HectorGarciaCPA]

You welcome.

[@zacchaeusisrael3466]

Thanks a lot

[@HectorGarciaCPA]

Most welcome

[@Kevin-om9pr]

Has anyone figured out if you can add and allocate a "landed cost" on the same receiving bill from our supplier? The majority of our significant incoming shipping costs we need to account for are prepaid and added to the invoice we get from our supplier. Do we have to create a second "-A" invoice for the same supplier just for the incoming shipping costs to make this work?

[@HectorGarciaCPA]

Needs to be separate :(

[@toxhawk]

Learning a lot from you already so thanks in advance. So new to QuickBooks enterprise platinum and since before we didn't track shipping separately. Just wondering what the best way to go from a purchase order we send to a vendor and they in return send invoice with shipping costs. So do we receive the inventory and when bill is created add an item line for shipping? or do something with landed cost? Also I have such a hard time wondering why there isn't a manual entry or a vendor discount % feature for when PO's are created. Most of the time we know what the msrp is and there isn't a way we can just put in somewhere that when we order from vendor x we get a 20% discount for those items. If vendor x wants to give us 25% discount we have to go through each item and change costs. Seems like the margin area in inventory is lacking for figuring this out also since you need to know your cost first. Be nice if there was a manual entry area as well since some vendors have special terms where we get another 5 to 10% off at times of the year. On top of the 2% -10 net 30. Is there a way you can track PO's and sales by sales person also and have it listed somewhere on the paper trail?

[@HectorGarciaCPA]

There is no solution for this

[@padilla178]

Hi Hector, thank you for this video! I have a question. Is this landed cost going to be tied to the specific items received on the bill and their lot number? and when using FIFO will it assign the correct landed cost to the oldest items in my inventory? The landed cost varies sometimes significantly so i was wondering if it was tied to the lot number. Also, Can i assign landed cost to inventory I already have in the system? how that would affect the financials? thank you for your help.. I tried to be as clear as I could.

[@khs391]

Hi professor CPA, I have one question related to land cost and Quickbook .. As your Quickbook enterprise is advance inventory that has land cost and advance inventory ... How can we check the expiration date of Quickbook and the subscription advance inventory? Because Quickbook enterprise are annual payment .. how to play the times that need to pay annual payment .. Thanks

[@shawninman3126]

Since landed cost is a new feature and will continue to use avg cost what is the recommendation for current inventory and landed cost that has already been paid for?

[@jcogden5829]

What I don't like about this feature is that it changes the item cost on the inventory bill itself. The vendor that sells the inventory isn't changing the cost of their item; rather, COGS (or in this case "other assets") like freight and duty are put into the cost of the inventory items separately to arrive at a new, landed cost of the inventory items.... the vendor's cost doesn't actually change, but now my QB file has different costs than my paperwork. Thank you for explaining this new feature, however! I was hoping it would save me some time but after seeing it in action, I don't think it will.

[@marthajames8326]

Did you find a resolution for this problem? I ran in to the same issue.

[@tanyapn8138]

@@marthajames8326 Any update on this? We were going to upgrade to QB MFG Enterprise Platinum for the landed cost feature but would not want the vendor cost to change. In reading other comments, it looks as though others say the vendor cost doesn't change, it just changes in the Inventory Valuation Summary and the landed cost BIll. Does it change the cost (vendor item price) in the PO? @JC Ogden

[@Caesardun]

Excel is faster. This takes way to long for many skus. Can the landed cost be entered (not calculated) if I calculate outside of Quickbooks?

[@HectorGarciaCPA]

No, becase you need to make the adjustment inside each item purchase

[@adamhaney]

This is a great new feature. It still seems a little backwards to me - generally we pay for landed costs AFTER we get the bill for the parts. So I work starting with the bill for landed costs and then want to associate it with specific part numbers. This should work so that if any of those items have been included in a customer invoice in a prior period, it should recognize that additional expense and generate a GL transaction in the current period based on additional unit cost added. Is that funcationality also included with this?

[@HectorGarciaCPA]

Adam Haney so the order doesn’t matter

[@leandroweissmann6896]

I have follow the video and I did exactly what you showed but I can not see any bill when I click on "ADD BILLS". It says: THERE ARE NO S&H ITEMS MAPPED TO CLEARING LANDED COST OR S&H BILLS CREATED POST LANDED COST SET UP. Do you know what the problem could be? Thanks

[@aircomusa5969]

Can I allocate landed costs from two different bills to the same Vendor bill (using two different split principles) ?

[@stevenmurphy8079]

This is great! Is there a way to make landed cost visible on the invoicing page though. It would be nice to see that when determining how cheap I can actually sell an item for, instead of drilling down in the items edit page.

[@HectorGarciaCPA]

Steven Murphy not possible, requires a drill down in the item list

[@stevenmurphy8079]

@@HectorGarciaCPA Yeah... I figured. It would be a nice feature though.

[@HectorGarciaCPA]

Steven Murphy yes it would, I’ll add it to my wishlist: quickbooks-training.net/quickbooks-desktop-2019-beyond-wishlist/

[@alextting]

My current version of QBDT 2020 now gives me an option to choose whether to set up my Clearing Landed Cost Account to either Other Current Asset (Recommended) or COGS as your video suggested. So should I choose COGS instead of their recommended settings? Thanks!

[@HectorGarciaCPA]

I like COGS

[@alextting]

@@HectorGarciaCPA I experimented with both actually. Functionality it's quite similar although the major difference using COGS vs. Other Current Assets is not seeing the outstanding balance appear in the COA. Maybe that's why QB is recommending Other Current Assets instead of COGS?

[@user-kh8jw6lv4e]

Landed cost is a kind of inventory and become to cost of goods sold?

[@HectorGarciaCPA]

It becomes part of the inventory cost until sold

[@malayshah9110]

Hi Hector thanks for sharing this. I am able to do what you presented. But on the calculate landed cost page I dont get an option to post to bill. Can you tell why?

[@HectorGarciaCPA]

You probably dont have the latest version of QB enterprise

[@WholesaleCabinet]

recently my QuickBooks enterprises could not complete the transaction, the landed cost would not apply to the items. have your problem resolved? I called QB customer service, but the pro can not give the the answer. shared the screen with them still could not find out WHY?

[@user-fj7rl6vk7v]

Good Thank you

[@muhammaddawood2418]

Dear Sir Please Guide , My Assembly items calculated with average cost that should be calculate on landed cost so that my cost will be perfect when i built an assembly it is calculated on average cost not on landed cost Please Please Guide

[@HectorGarciaCPA]

If you use landed cost properly. “Avg” cost becomes the landed cost

[@LearnedQB]

Is there a way to see Landed Cost report? I mean the breakdown of cost allocated to the product?

[@HectorGarciaCPA]

No report :(

[@srobel7]

@@HectorGarciaCPA Is the landed cost detail in a transaction file the I can export and massage to get a report?

[@LearnedQB]

@@HectorGarciaCPA thank you

[@Mymusicfmw33]

Hello. I’ve created Item and invoice. Problem: I have several line items all at $42.50. Total Quantity of the line items equals 720.22. Now when I use a calculator to multiply 720.22 times the unit price 42.50 I get $30609.35. I use subtotal on invoice and QBDT Premier has total of $30613.28. Why is QB rounding up? How do I turn off

[@HectorGarciaCPA]

MS Cellaneous Yeap QB rounds up... can’t turn off..

[@srobel7]

How can we allocate freight based on volume of the goods we import? Our goods come from Vietnam and China and we typically cube out our 40' containers that contain a variety of items that take vastly different volumes compared to the FOB cost, so we would want to allocate based on volume - will we be able to do that? Thanks in advance

[@HectorGarciaCPA]

Not possible, as there is not field track volume

[@srobel7]

@@HectorGarciaCPA Sounds like I just need to do the allocation calc offline and then enter it using the percentage method. For each SKU I will measure pack dimensions and qty to get volume each and use this as a data table and vlookup in volumes in a second tab where I enter the item number and pack quantity. Our best volume utilization use on a 40' container is 95% so I will use that as the standard. My cost standard will be the most common rate I hav paid in the last 6 months. When I allocate if I pay more (or less) than standard or pack less (or more) than standard I will make those general cost of goods sold expenses for the period in which this occurs and will treat these as volume packing variance to standard and shipping cost variance from standard so that I get uniform costs per item. Just not sure how often to update the pricing standard. Thanks, Scott

[@melissacary8050]

Hi Hector, Great Video! We also have the Desktop Enterprise - Contractors Edition. We recently started doing Inventory and needed a proper way to Allocate the cost of Freight and Sales Tax to the jobs. This is perfect; however, I followed the steps Identically and it will Not update my costs on the bill itself or the Items and amount due tab. Do you have any idea why it will not update the totals for me? I do click skip and proceed when it asks if I want to update my sales price, is that an issue? Any help with this would be greatly appreciated!

[@HectorGarciaCPA]

Hard to tell… could be a bug? Have you contacted Intuit?

[@melissacary8050]

@@HectorGarciaCPA I figured it out finally and took me several days of continuous reading articles and forums to get the answer. Come to find out this happens to a lot of people, and some have had the issue for years and Intuit couldn't even figure it out after 2 years of continuous investigation. However, I found an individual who finally figured it out without the help of intuit. If this happens to anyone, then chances are they will have to change their "Product Description" on the bill. For some reason if your product description has Certain Symbols other than Letters & Numbers it won't Allocate the cost on the bill. To fix this you must open the Bill and click on the product description and remove symbols and then resave the bill. You will then reopen the bill and Calculate Landed Cost and this time it should work! So, if you have people that ever ask you why it won't work, and they have done everything right then please tell them to try this and they should be good to go.

[@HectorGarciaCPA]

@@melissacary8050 Holly crap.. what a random bug. thank you for letting us know!!!

[@LearnedQB]

Hi Sir, it seems like the multiple currency don't allocate accurately with the landed cost specially on the purchase price is different currency from the landed cost clearing on home currency.Any suggestion on work around?

[@LearnedQB]

Let say USD landed Cost Clearing. Purchases is AUD

[@HectorGarciaCPA]

Multi currency support for landed cost its still a known issue, no fix

[@shawninman3126]

Can you still use class tracking with Landed Cost?

[@xmrgx2007]

Hi Hector! How would you handle if freight is a line item in the raw materials invoice?

[@HectorGarciaCPA]

Works the same

[@sergiohank9148]

Hi Hector, great explanation video, I didn't understand how to use this feature until today. In my case it seems a lot more work than useful, hopefully you can help me out. I have QB manufacturing edition, landing cost is great but kind of pointless for me because it does not update the assembly item with the landing cost, it keeps the vendors price. So correct me if I'm wrong but even after using the new feature I would still need an excel sheet to calculate my assembly item's true cost....?

[@HectorGarciaCPA]

No.. the ACTUAL cost of your assembly item will be higher if you apply landed cost to the inventory items I me the BOM.. the “cost” that you see on the BOM screen are the vendor costs and are only “useful” for setup up a sales price. But if you want to assembly items to have the landed cost of the components; just receive all competente with landed cost

[@sergiohank9148]

@@HectorGarciaCPA thank you so much for replying. I'm experimenting with 1 assembly product and I am using landed cost on one of the items used but it's not updating in BOM of assembly product. Is there an option that I need to turn on for BOM to include landing cost?

[@HectorGarciaCPA]

Sergio Hank correct; you won’t see the “landed cost” in the BOM.. but when you build the assembly, the inventory value of the assembly will include the landed cost.

[@edwardbellinger114]

Can you assign freight & customs to an inventory assembly item that is manufactured overseas and then imported? Or should freight & customs be part of the build?

[@HectorGarciaCPA]

Part of the build

[@edwardbellinger114]

@@HectorGarciaCPA Thank you, that's what I was thinking also

[@nadinemonico6835]

After you calculate your landed cost the Landed Cost Clearance Cost shows a negative number on the Balance Sheet? Is this correct or am I missing a step?

[@HectorGarciaCPA]

It migt show a small balance for rounding errors.. This is why I personally prefer the clearing account in the P&L as a COGS account instead. You can just adjust that remaining balance against COGS

[@smm997]

I don’t have in 2013 why?

[@HectorGarciaCPA]

Was released later

[@webuyhomesinnorthernnewjer7582]

Hi hector, how can I get in touch with you for your services?

[@phillybahama]

Hello Hector, I am a subscriber to your channel and I want to share with you and your viewers something that happened to me after I did a landed cost transaction. I'm not sure if this issue was covered in another of your vids but I will share anyway. I made a few landed cost transactions and noticed afterward that my inventory, accounts payable and cost of goods sold were off. I discovered that all of the inventory items that were entered on the bill from my vendor that did not have a U/M designation did not reverse the original inventory amount but rather added it back in. Quickbooks I assume tried compensating for this by posting random credit amounts to make the adjustments but in the end did not clear the account totally. I figured out which entries I need to correct the error but I realize that I cannot post a journal entry because it won't affect the inventory or accounts payable or COGS. Is there any advice you can give me to clear this up?

[@HectorGarciaCPA]

This is not a landed cost issue. This is a negative inventory issue

[@williamdavidson9700]

So if we apply the landed cost to the item and then in the future when we go to purchase this item again and send a Purchase Order, will it show the correct cost for the vendor, or will it show the landed cost?

[@HectorGarciaCPA]

Vendor cost.. landed cost is only for bills that were allocated.

[@williamdavidson9700]

@@HectorGarciaCPA Cool so it doesn't change your "COST" or is there a new field called vendor cost?

[@HectorGarciaCPA]

William Davidson no new field.. is just a change for the one transaction.

[@alextting]

If my goods comes in and I start selling even when not all my landed cost components had been factored in, can I still update my landed cost on the item and will it reflect the corrected landed of the items already sold? Thanks.

[@HectorGarciaCPA]

Yes, as long as the bill is dated before the invoice

[@alextting]

Good to know. Thank you sir!

[@zong612687]

Hay Hector, I have a question, We have a scenario, Products we purchased are in Euro Currency, and pay Shipping cost in USD. When Calculate Landed cost it does not show Shipping cost (Bills recorded in USD) It only shows Bill's recorded in EURO. Is their any way to tackle this scenario ? Thanks

[@HectorGarciaCPA]

DOESNT WORK WITH MULTI CURRENCY

[@zong612687]

@@HectorGarciaCPA, its works for same currency, both transportation bill and items bill entry must be in same. In that case it works.

[@HectorGarciaCPA]

@@zong612687 yes

[@geethachandra5857]

Hello Hector-watched your youtube video and followed the steps exactly by creating items for shipping costs and mapping it to a clearing account in other assets But when I create a bill for these shipping charge items, it goes and sits in the inventory offset account instead of the Other asset account.Can you please let me know how I can fix this?

[@HectorGarciaCPA]

You can’t use Landed Cost with Enhanced Inventory Receiving turned on! Sorry, that was not covered in the video, because not that many people use that feature, but is a known problem yet unreaolved

[@geethachandra5857]

@@HectorGarciaCPA Thanks for your response. Is there a way to work around it?

[@philipj.brogan5386]

Is this still true? I'm having this issue as well. When I enter a bill for shipping and send it to my Other Charge linked to landed cost asset account it debits inventory offset account (liability) instead of Landed Costs to Allocate (asset). @@HectorGarciaCPA

[@philipj.brogan5386]

Nvm i figured it out. you need to create a PO for your landed cost shipping item, receive it, and tie a bill to the receipt. Only then will the accounting be correct AND the shipping will be available as a landed cost to allocate. In other words you cannot simply enter a bill for your shipping landed cost item because that debit will go to inventory offset account.

[@noumanali4847]

I have a question. how can i tell that a quickbooks version installed on someones computer is a pirated version or legal version?

[@HectorGarciaCPA]

I don’t know how to tell. But you can hit CTRL 1 to see the license number and then call Intuit 1-800-4INTUIT and ask them.

[@noumanali4847]

@@HectorGarciaCPA Thank you.. i was thinking that QB may be sends email to the person who purchases the version containing Licence key and link from where we can download it. Am i write?

[@HectorGarciaCPA]

That is true as well.

[@noumanali4847]

@@HectorGarciaCPA Thank you. I must tell you that i have learned alot form you. Thanks for your great work.

[@HectorGarciaCPA]

Nouman Ali you welcome

[@udoohizu]

Hello Hector, when making use of advanced inventory, how do you make those expenses you used to ascertain cost reflect under Cost of Goods Sold in the Profit or Loss?

[@HectorGarciaCPA]

With inventory advances, its not in the P&L

[@DVisco]

I thought he gave a very good explanation but went way too fast.