ctisystems wrote:

Hi All,
I would just like to express an opinion on "landed Cost".
According to most accounting standards, incoming Inventory should be valued at "landed cost"
itemized landed cost is the correct way to handle inventory from the “GAAP” perspective. Additionally, IRS Publication 538 states that "For merchandise purchased during the year, cost means the invoice price minus appropriate discounts plus transportation or other charges incurred in acquiring the goods. It can also include other costs that have to be capitalized under the uniform capitalization rules of section 263A of the Internal Revenue Code."

"Landed Cost" is the legally correct way to account for inventory and is also the best method for management purposes.
many commercial software packages now include some way to handle this issue.

for frontaccounting, when entering a supplier / service provider invoice, or making a payment by direct journal entry It should be possible to apportion it on a line by line basis between an expense account (for non "landed costs" invoice Items and a "cost of goods sold" Suspense account until the goods arrive.
On receipt of the goods received note, the balance of that suspense account is allocated according to the preferred method (weight, volume, quantity etc.) to each line of goods on the GRN.
Dimensions would also be a good way to keep track of all items related to a particular order for audit purposes.

Finally!

As the guy who started the thread, there are a lot of apples being mixed with the oranges in this thread.

Landed cost is somehow getting mixed with Inventory Valuation. There are basically 3 methods of inventory valuation, First In - First Out (FIFO), Last In - First Out (LIFO) and Replacement Cost. As mentioned above, these are recognized by the IRS, and you can only change from on to another once every, I think, 5 or 7 years, in order to stop people from gaming the system during times of steep price changes.

Landed cost is well stated above, although some do allocate shipping based on weight, rather than a flat percentage across the invoice. memory chips have hardly any weight, but high value. But their actual percentage of a load of electronics could be 50%, while their weight is 2%.

Landed cost requires keeping a PO open until all related costs are received. As stated above, unless special costs such as VAT, GST, etc. in some countries must be broken out, everything goes to COGS or Inventory Value, including inbound shipping that many incorrectly call an expense.

Earlier versions of Peachtree and the more expensive Sage and other accounting packages allow posting the inventory, so the goods show in stock, but not FINALIZING the PO until all related costs are shown. For my UK operation it can be several weeks before getting an invoice from DHL for VAT and their processing fees. I'm sure others have a similar experience.

The point I'm trying to make here is simply related to Landed Cost.

How you decide to bring that into your Inventory Valuation, as far as average cost, FIFO, LIFO, etc. is an entirely different subject. My personal choice has always been Replacement Cost, but this can show a higher bottom line at year end.

Ideally, the accounting should use an Average Cost for COGS, considering the entire history of costs for that item, but show the FIFO, LIFO, RC value in Assets. They truly are two different fruits.

Ye olde Excel

Item Code| Qty x Cost Ea = Total Cost + Shipping In (prorated by item weighs) + VAT (prorated by item value) = Grand Total / Qty = Landed Cost Per Item x Factor = Selling Price in USD x Conversion Rate = Actual Selling Price in GBP

Fortunately just a couple of dozen items. I dropship for Ebay sellers by air mail worldwide, but 80% is to the UK and by November 1 the mail is so backed up Christmas presents won't make it in time. So I have the truly hot movers in the UK for established sellers who depend on me the other 10 months.

So, I can go through it once and get a good idea. Shipping will vary a bit depending on the mix in the cartons, but VAT is constant and there is no duty on my goods, so I can get an idea of pricing and leave a bit of cushion. Nothing to stay awake over, but someone else started a thread and I replied. Then the forum powers that be decided to fork this off on it's own.

Thanks, Mac

Yes, this is a concept foreign to those who have no use for it. It is far more a management tool than a "bookkeeping for tax purposes" general ledger entry. And there is far more than just shipping, there is VAT (I have businesses in China and the UK, as well as the US and VAT is a fact of life in the UK, as duty can be, also.) There are also costs such as drayage from port to warehouse and demurrage on the time the container is sitting on your property.

All of these need to calculated as costs of the particular item, not expenses down the COA, in order to tell what youare really making (and give a realistic markup / gross profit) per item.

Amazingly, there are a number of Point-of-Sale (computer cash registers) software packages that offer this, but few accounting programs. MYOB for the US market in the 1900's did, and there are add-on modules for other mid and high priced PC based programs, but nothing for a free or low-cost online package.

Doing a simple Google of "landed costs" will show there is quite a bit of talk about this method. Here's just one link - http://www.joc.com/2010/10-tips-understanding-total-landed-and-delivered-costs

Thanks for your rapid reply!

Yes, it makes sense. I was hoping to avoid that. There are account programs the are capable of handling "landed cost" as a single item.

When receiving an item or a PO of several items the shipping and port fees can be entered after the goods are received to update the cost, either by weighted average for each item on the PO, or by specifically breaking it out for each item.

I have not studied FA to the point that I know if the cost for Manufactured item A will fluctuate as the costs of any of the components, either the goods, the shipping or the port fees vary from one shipment to another.

If not, I'd like a Last In, First Out cost or the book value of the inventory at the "replacement cost" or the last known total cost of the goods.

What you suggest is a work-around, which I may have to use, but I was hoping for it all under the purchased goods.

When receiving imported goods is it possible to enter the cost of the goods, the shipping costs and any taxes or duties involved with that item / order so that the item cost in the books is shown as a total of all these costs.

Example -

100pc item 1 at 100 = 10,000
Shipping total = 1,000
Total Customs Fees = 500

Total Landed Cost of 100pc = 11,500  per unit = 115

Cost per item in inventory / items, in COGS, in inventory asset account and reports shows as  115?