Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of contents

Table of Contents

Summary

This document describes Complex Landed Costing process. 

For simple landed costing see Simple Landed Costing

General Overview of Landed Costing

Landed costing adds costs incurred in getting the stock into store to the price paid for the stock and updates the average cost in the system

...

Gliffy
bordertrue
nameLanded cost options explained
pagePin67

For the Accountants - here are the journals created.

Gliffy
bordertrue
nameLanded Cost Options
pagePin1

Note

Supplier freight is always allocated to the stock cost. Supplier freight is not known until the supplier invoice is entered and includes freight. The average cost is updated by averaging the freight based on line item value. The average cost update is limited to the value that would have resulted if all the stock is still in the system - if there is less stock remaining than was received then not all the freight will be allocated and some will remain in the "Carriage In" control account

If you do not want the freight allocated or you want to allocate it using a different method then enter it as a separate invoice.

There are two stages in Complex Landed Costs

  1. Estimated stage = costs are estimated.   The PO can be receipted and average cost of the stock will use the estimated costs
  2. Actual stage = actual costs are compared with the costs used in the estimate stage and the average costs are then adjusted to suit.
Note

to use Landed costing configurations are required

The typical scenario is as follows:

  1. A number of products are to be imported from an overseas country from a number of suppliers
    1. Therefore there are multiple purchase orders each with multiple lines on them
  2. Costs are then incurred
    1. A shipping company is engaged - and will cost money
    2. Transport is arranged in the foreign country, travelling to your country and then within your country to your dock
    3. Export and import fees and duty may apply
  3. The product is then shipped
  4. The product arrives in your store and is placed into stock
  5. Some of this product may be used or sold
  6. The final charges are presented to you by your suppliers (and not by item or PO)

...

  1. Select purchase order that will require landed cost adjustment
  2. Provide a name

Entering the Charges

Note

Expected charges may be entered as estimates and later (even after stock receipt) linked to the actuals and stock value recalculated if required.


  1. Enter Type of charge
    1. Charges are setup at Administration > configuration > Lookups > "ChargeType"
  2. enter Method of apportioning the charge
    1. By weight will look at the weight of each item and allocate by weight and is useful for shipping or air freight that is charged by weight
    2. By Dollar value uses the dollar value on the purchase order
    3. By volume uses the article volume
    4. Manual enables you to manually allocate the charges across all related lines
  3. Description - add a note to so you can remember what this charge was intended to cover

View the Estimated charges by Purchase Order Line

Action Button: Calculate and show Apportions

...

New Average cost = (current average cost * current stock qty + qty from the PO * final cost ea) / (current stock qty + PO stock Qty)

Set the Estimate Ready to Use

When you have completed the estimate then Action Button: Set Estimate Ready to use

...