Add or Edit a Landed Cost

Add or Edit a Landed Cost

Open the supplier invoice and click Landed Cost. If the invoice already has a landed cost, the same button opens it for editing. Every field on the screen has a short note under it, and all amounts are in your home currency.

The invoice is at Purchases > Invoices — click its reference to open it.

Purchase

  • Supplier Invoice, Supplier and Reference: filled in for you.
  • Date: the date the new item costs and the journal are posted on. It must be in an open fiscal year.
  • Shipping Company: the company that brought the goods, from your list of shipping companies. When you choose one, Adjustment Account changes to that shipping company's own account, the Shipper GL Account set for it in Inventory > Settings > Shippers. Leave it as None when there was none, or click + to add a new one. The list and the report can be filtered by it.
  • Adjustment Account: the account the total landed cost is credited to. It is the shipping company's account when it has one. When there is no shipping company, or it has no account, your default adjustment account is used (the Inventory Adjustments Account in GL Setup), as before. You can still choose another account, for example the account where the freight, insurance and customs bills were booked. The items' inventory account is debited.

Costs to add

  • Shipping: freight paid to bring the goods to you.
  • Insurance: insurance on the goods while in transit.
  • Customs: customs duty and clearing charges.
  • Processing: handling, port, loading and unloading charges.
  • Other Charges: any other cost of getting the goods into your store.

Total Landed Cost adds them up. The items below recalculate as you type.

Type of calculation

  • Amount (shared by line value): each ticked item takes a share in proportion to its line value (quantity × price). Use it when the cost follows the value of the goods, such as customs duty or insurance.
  • Quantity (the same per unit): every unit of the ticked items takes the same amount, whatever its price. Use it when the cost follows the number of units, such as freight by the carton.

Example. The invoice has item A, 10 × 100 = 1,000, and item B, 5 × 600 = 3,000. The landed cost is 400.

ItemLine valueBy Amount: shareBy Amount: new unit priceBy Quantity: shareBy Quantity: new unit price
A (10 units)1,000.00100.00 (25%)110.00266.67126.67
B (5 units)3,000.00300.00 (75%)660.00133.33626.67
Total4,000.00400.00400.00

By amount, 400 ÷ 4,000 = 10% of each line's value. By quantity, 400 ÷ 15 units = 26.67 a unit. Under the choice, a line shows the figures of your own landed cost as you work.

Items

Every stock item on the invoice is listed and ticked. Untick an item to leave it out: the cost is then shared over the others. Services take no share. For each item you see Qty, Unit Price, Line Total, Share (its percentage of the landed cost), Landed Cost, New Unit Price and New Line Total. Add a Memo if you wish.

Saving

  • Draft: keeps it to finish later. Nothing is posted and no cost changes.
  • Submit (or Update when editing): posts it. The items' cost price goes up by their share and the journal is posted.

What is posted

With the example above by amount, a shipping company chosen, and all the goods still in stock:

AccountDebitCredit
Inventory400.00
Shipping company's account (or the adjustment account)400.00

If 2 of the 5 units of item B had already been sold, only 3 can carry their share: 3/5 of B's 300 (180) goes to stock and 2/5 (120) to Cost of Sales, because there is no stock left to carry it.

AccountDebitCredit
Inventory (A 100 + B 180)280.00
Cost of Sales (B's units already sold)120.00
Shipping company's account (or the adjustment account)400.00

Editing

Everything comes back as you saved it: the date, account, costs, type of calculation, shipping company, memo and the ticked items. Saving an edit reverses the landed cost and posts it again with the new figures under the same reference.

A landed cost keeps the account it was posted to. To move one you posted earlier to the shipping company's account, open it, click Edit, choose that account in Adjustment Account and click Update.

Voiding or editing after some goods were sold

A void takes back only what the landed cost still holds in stock. What went out with the goods sold since comes back from Cost of Sales. Example: you received 100 units at 10 each and added a landed cost of 200, so the cost price became 12. Then 90 units were sold at 12, which put 180 of the landed cost into Cost of Sales. Voiding the landed cost now posts:

AccountDebitCredit
The account it was credited to (shipping company or adjustment account)200.00
Inventory (the 10 units still held, 2 each)20.00
Cost of Sales (the 90 units already sold)180.00

The cost price goes back to 10. When nothing is left in stock, the cost price stays as it is and the whole amount comes back from Cost of Sales. An edit does the same first, then posts the new figures on the stock as it is now.

The list of landed costs, the details view and the Landed Cost Report are described in Landed Cost.

Related pages

Global Coverage

Multi-Country ERP — One Platform

Supports GST (India), VAT (UAE, South Africa, Egypt, Iraq, Botswana), and local compliance across all regions.

🇮🇳 India (GST)
🇦🇪 UAE (VAT)
🇸🇦 Saudi Arabia
🇶🇦 Qatar
🇧🇭 Bahrain
🇴🇲 Oman
🇰🇼 Kuwait
🇪🇬 Egypt
🇮🇶 Iraq
🇿🇦 South Africa
🇧🇼 Botswana
🇲🇾 Malaysia
🇸🇬 Singapore
🇦🇺 Australia
🇬🇧 United Kingdom
🇺🇸 USA
🌏 & More Regions
Chat with us
Book a demo Free trial