Start a new topic
Planned

Landed Cost distributions

While landed cost Expenses - freight, insurance, duties, etc - can be allocated to Invoices


It will be nice to also be able to allocate the allocate Expenses of Invoices to Products


This feature will allow us to get a more accurate Product costing


7 people like this idea

Hi All

Landing cost calculation task is given high priority. We will keep you updated on the progress

Regards

DEAR Team 

The ability to add landed costs at a product level is essential in any robust inventory system. The larger cost components of landed cost to allocate is typically duty and shipping costs.  Where orders are placed on vendors for multiple skus the chance of having skus on the one order with varying duty rates is high. In my case I have had different skus on the same order/invoice that were duty free and another attracting 40% tariff.  Likewise shipping costs are typically incurred on a cubic metre measure. Under the current dear assumption a small high cost item will attract the bulk of the landed cost assumption when combined in the same order as a low cost large item.  As you can see from both these scenarios the current dear methodology is insufficient to reasonably apply importing or landing costs to the respective products within an invoice.

We import beer so for best accuracy, we need to allocate cost by volume (e.g. liter). Alcohol are also dutiable so we need to assign different duties to each product's landed cost. 

I am also supporting a firm that imports in South Africa and we are having the same issue. It is important to get accurate landed cost calculation by product. DEAR team, please advise. You advertise that landed cost is supported, but in actual fact in practice it does not yield the correct answer.


1 person likes this

Hi Dear


We are an import company and import goods into South Africa.However we have certain items that attract  customs duties and some that don't on the same order.We used to use Sage one and this provides a seamless solution where you can enter costs per line item without any hassles.This is creating major issues and workarounds for us in DEAR which I feel is a major let down from DEAR's side as I am sure I am not the only importer using this system.Please can you urgently look at adressing this.I happy to share more info etc.I have placed a screenshot below of the way Sage one offer it.You can manually add the individual costs to the individual line items and then you load the total additional costs invoice in at the bottom.


image



2 people like this

thanks Danny.  this is what we also do.  except in situations wherein the Duty rates are different for each product groups the current set up does not allow allocation to individual products for a more accurate landed cost


for example machinery may be 1% duty while spare parts may be 3% and accessories is 7%


2 people like this

My formula for working out actual landed costs on good is they following...


Total invoice amount in AUD + landed charges (duty/freight/insurance etc..) Divided by the original invoice amount is whatever currency you bought it in (USD/EURO etc) This will give you a factor multiplier that you can use to multiply the original suppliers invoice line amount by the factor.


EG: 

10 x Machine Part A @ 250 Euro each = 2500 Euro

5 x Machine Part B @ 150 Euro each = 750 Euro


Total invoice amount = 3250 Euro


Paid amount in AUD = 5240 AUD

+Freight = $700 AUD

+Duty = $400 AUD

+Insurance = $100 AUD

= $6440 AUD / 3250 (original supplier amount) = 1.9815


Landed Costs

10 x Machine Part A @ 250 x 1.9815 = $495.375 each $4953.75 Total

5 x Machine Part B @ 150 x 1.9815 = $297.225 each $1486.125 Total 


You may have to some tweaking as it's hard to get the line total to equal exactly what you got with your multiply factor as Dear only lets you adjust the line amount and not the line total which is a pain.


Lastly the GST portion can be entered into the services section on the PO as Import tax, you will need to multiply it by 10 with "GST on Expenses" and then create anther line of the same but with negative the same amount and "GST free expenses". This will put the correct GST amount in.


This may seem a little complicated but it really isn't once you've done it a few times... Gives me accurate costings on all my inventory which is very helpful.



2 people like this
Login or Signup to post a comment