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
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.
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
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.
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%
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.
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.
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.
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.
Landing cost calculation task is given high priority. We will keep you updated on the progress