This is to allow landing cost to be distributed and added onto item cost during purchases.
First, go to Tools > Next, click on Program Control > Then, go to Module Setting
After that, check the checkbox of Landing Cost to enable it.
Default Setting
First, go to Tools > Then, click on Options > Next, go to Invoicing > After that, click on Landing Cost
Now, select the default option for Calculate Landing Cost Pro-Rated by
Pro-rated by Sub Total: landing cost will be distributed among transacted items according to the ratio of each item row’s subtotal. E.g.
Total landing cost = 100.00
Item A, Qty=2, Unit Price=100, Sub Total = 200 Pro-rated landing cost = 200/500 * 100 = 40.00
Item B, Qty=3, Unit Price=80, Sub Total = 240 Pro-rated landing cost = 240/500 * 100 = 48.00
Item C, Qty=1, Unit Price=60, Sub Total = 60 Pro-rated landing cost = 60/500 * 100 = 12.00
Pro-rated by Stock Item Weight: landing cost will be distributed among transacted items according to the ratio of each item row’s total weight; item weight is maintained at Stock Item Maintenance. E.g.
Total landing cost = 100.00
Item A, Qty=2, Item Weight=10 kg Total Weight= 20 Pro-rated landing cost = 20/50 * 100 = 40.00
Item B, Qty=3, Item Weight=8 kg, Total Weight= 24 Pro-rated landing cost = 24/50 * 100 = 48.00
Item C, Qty=1, Item Weight=6 kg, Total Weight= 6 Pro-rated landing cost = 6/50 * 100 = 12.00
Pro-rated by Stock Item Volume: landing cost will be distributed among transacted items according to the ratio of each item row’s total volume; item volume is maintained at Stock Item Maintenance. E.g.
Total landing cost = 100.00
Item A, Qty=2, Item Volume=10 litre, Total Volume= 20 Pro-rated landing cost = 20/50 * 100 = 40.00
Item B, Qty=3, Item Volume=8 litre, Total Volume= 24 Pro-rated landing cost = 24/50 * 100 = 48.00
Item C, Qty=1, Item Volume=6 litre, Total Volume= 6 Pro-rated landing cost = 6/50 * 100 = 12.00
To maintain item weight and item volume, go to Stock > Stock Item Maintenance,
Click on Others,
Transaction – Purchase
Landing Cost is applicable to Goods Received Note, Purchase Invoice, and Cash Purchase.
First, go to Purchase > Then, click on purchase Invoice
After that, click on Create A New Purchase Invoice
Next, add 3 different items…
Then, click on the Landed Cost button,
Foreign Charge: if landing cost was charged by the service provider in foreign currency, key in foreign charge amount. Now, this amount will be distributed and filled in the column of Foreign Charge.
Local Charge: if landing cost was charged by the service provider in local currency (or converted to local currency), key in local charge amount. Now, this amount will be distributed and filled in the column of Local Charge.
Calculate Landing Cost Pro-rated base on: select an option.
Then, click on OK.
The column of Local Charge is filled with landing costs.
Distribution of landing cost is applicable only on stock items. If there is a mixture of Stock items and Service items, the service items will not be included in the pro-rated distribution.
You may also key in Duty charge (in value) per each item (if any). Furthermore, the duty rate can be maintained at Stock Item Maintenance so that it will be auto-calculated (yet amendable).
Note: Purchase cost per unit, therefore, will be… (Subtotal + Local Charge + Duty) / Qty
Last, click on Save & Preview.
Both Landing charge and Duty are for costing purposes and will not be displayed in the Purchase Invoice.
Stock Card Report
First, go to Stock > Then, click on the stock Card Report
Next, define filter options, click on Inquiry, click on the ‘+’ sign before item code to expand the details.
As you can see, the landing cost was added to the stock unit cost.
Posting – A/P Invoice
First, go to A/P > click on A/P Invoice Entry
Now, select the Purchase Invoice you have just saved
Then, click on View
Then, you will notice that A/P Invoice Entry does not include landing cost and Duty charge.
For total Landing Cost and total Duty Charge, there are separate invoices billed by the respective supplier and will be recorded with separate Purchase Invoices or A/P Invoice Entries (G/L accounts involved should be Cost Of Sale type and not Expenses type.).
Landing Cost vs Profit & Loss Statement
To make it easier to understand the consequences of Landing Cost in Profit & Loss Statement after all necessary entries, I shall use an extreme example where the purchased stock was not sold at all …
Example 1: Landing Cost module is used to adjust the stock value: `
Sales: 0 (there were no sales, so the closing stock remains unsold)
Purchases: 100
Landing Cost: 10
(A) if the Landing Cost Account is created under COST OF SALES account type:
The Profit & Loss Statement will be:
(B) if the Landing Cost Account is created under Expenses account type:
The Profit & Loss Statement will be:
Both end up with the same Net Profit amount, but with different Gross Profit amount.
Example 2: Landing Cost module is NOT used.
Sales: 0 (there were no sales, so the closing stock remains unsold)
Purchases: 100
Landing Cost: 10
(A) If the Landing Cost Account is created under COST OF SALES account type:
The Profit & Loss Statement will be:
(B) If the Landing Cost Account is created under Expenses account type:
The Profit & Loss Statement will be:
Pingback: AutoCount Module - AutoCount Software