Landed Cost and Inventory Costing on Autopilot in UAE Businesses: How Automation Spreads Freight, Duty and Clearing Charges So Product Margins Are Real

Warehouse staff member scanning stock on shelves with a handheld scanner and tablet, illustrating landed cost and inventory costing automation

18 min read

Most finance teams know the purchase price of every item they stock. Far fewer know what each item really cost by the time it reached the warehouse shelf. The supplier invoice is only the first bill. Freight, insurance, customs duty, clearing agent charges, port handling and the truck from the port all arrive later, often from different vendors, in different currencies, weeks apart. If those bills land in a general “freight expense” account instead of in the cost of the goods, product margins on the management report are simply wrong.

This guide is for finance managers and CFOs who want product margins they can defend. It explains what landed cost automation does, how it spreads freight, duty and clearing charges across stock receipts, how the costing method changes cost of goods sold, which decisions still belong to a qualified accountant, and which controls to demand before you trust the numbers. For the wider picture of how automation fits into a modern finance function, see our AI accounting automation hub.

Published: 13 November 2026

Important note on numbers. Every AED figure in this article is a hypothetical illustration built on the assumptions stated next to it. They are not quotes, benchmarks or a price list from us or anyone else. Replace the assumptions with your own shipment volumes, cost lines and salary levels. This is not a tax or customs article: customs duty appears here only as one of the costs that belongs in inventory.

Quick Answer

What is landed cost automation? It is the part of an inventory accounting system that collects every cost of bringing goods to their present location (purchase price, freight, insurance, customs duty, clearing, handling and inland transport), allocates those costs to the specific stock receipt they relate to, and updates the unit cost of each item before it is sold. The result is a cost of goods sold figure that reflects what the goods really cost, not just what the supplier charged.

What still needs a qualified accountant? Choosing the allocation basis for each cost type, deciding which charges belong in inventory and which are period expenses, handling bills that arrive after the goods are sold, judging stock write-downs, and signing off period cut-off. At Qaspro we put it simply: AI does the routine work, and qualified accountants review and sign off. We serve businesses in the UAE and internationally, remotely.

Why Invoice-Price Costing Overstates Your Margins

Under IFRS, which most UAE businesses report under, IAS 2 Inventories says the cost of inventory includes the purchase price, import duties and other non-recoverable taxes, transport, handling and other costs directly attributable to bringing the goods to their present location and condition. Trade discounts and rebates are deducted. In other words, the standard already expects landed cost. The problem is rarely the rule. The problem is the workload.

When landed cost is done by hand, these things usually happen:

Freight is expensed, not capitalised. The shipping bill is posted to a freight expense account in the month it arrives. Inventory is understated, and that month’s profit takes a hit that has nothing to do with sales.
Margins look better on the product report than they are. The product report shows sales against invoice cost, so every imported line looks more profitable than it really is.
Pricing follows the wrong number. Sales teams set discounts and price lists using a cost that is missing 10% to 20% of the real cost on some lines.
Profit swings between months. A big clearing bill in one month and none in the next makes the gross margin jump around, so trend analysis becomes noise.
Late bills are never matched. A freight bill arriving six weeks after the goods is posted to expense because no one can easily trace which receipt it belonged to.

A hypothetical illustration: one shipment

Assume a mid-size trading company imports one container of goods. All figures are hypothetical.

Cost line	AED (illustration)
Supplier invoice (goods)	200,000
Sea freight	12,000
Marine insurance	1,000
Customs duty (assumed 5% of the goods, freight and insurance value of 213,000)	10,650
Clearing agent and port handling	3,350
Inland transport to warehouse	2,000
Total landed cost	229,000

The extra costs add AED 29,000, or 14.5%, on top of the supplier invoice. Now take one item from this shipment that cost AED 100 on the supplier invoice and sells for AED 130:

Margin on invoice cost: (130 – 100) / 130 = about 23%.
Margin on landed cost: (130 – 114.50) / 130 = about 12%.

The product report shows almost double the real margin. If that item is a volume line, a discount that looks safe at 23% can wipe out most of the real 12%. This is an illustration, not a forecast for your business, but the pattern is common wherever goods are imported.

Customs duty rates depend on the goods and their classification. For the rate that applies to your products, check the customs authority of your emirate. We mention duty here only as a cost that belongs in inventory, not as a tax topic.

What Landed Cost Automation Actually Does

A well-configured inventory system turns landed cost from a month-end spreadsheet into routine work done as bills arrive. In general terms, the automated part covers:

Linking cost bills to the receipt. When a freight, insurance, duty or clearing bill is captured, it is linked to the purchase order or goods receipt it belongs to, using the shipment reference, bill of lading or container number on the document.
Holding costs in a clearing account until the shipment is complete. Costs that arrive before all bills are in sit in a goods-in-transit or landed cost clearing account, not in expenses.
Allocating each cost by the basis you set. The system spreads each charge across the lines on the receipt by value, weight, volume or quantity.
Updating unit cost. The new landed unit cost flows into the item’s stock valuation, so the next sale uses the real cost.
Flagging exceptions. Bills with no matching receipt, a freight charge far outside the normal range for a route, duty that does not match the declared value, or a clearing account balance that does not clear are flagged for review.

Which tools support it

Public accounting and inventory software handles this to different degrees, and features change, so always check the vendor’s current documentation for your plan:

Odoo has a dedicated landed costs feature inside its inventory application.
Zoho Inventory and Zoho Books (on supported plans) let you track landed cost on items and allocate it across a bill by value or quantity.
Xero does not have native landed cost allocation at the time of writing; businesses usually use a third-party inventory app or a spreadsheet plus a journal.
QuickBooks Online inventory features vary by plan; many importers use an add-on inventory app for landed cost.

Qaspro ERP, Qaspro’s own accounting system, is another option for businesses that want inventory, purchasing and accounting in one place. The software matters less than how the costs are classified, allocated and reviewed. For a wider comparison of systems, see our guide to the best accounting software for UAE businesses.

Allocation Basis: The Decision That Changes the Answer

The allocation basis is not a technical detail. It changes which products look profitable. Take the same AED 12,000 freight bill and two product lines on the same receipt. All figures are hypothetical.

	Product X	Product Y
Invoice value	AED 150,000	AED 50,000
Weight	2,000 kg	8,000 kg
Freight allocated by value	AED 9,000	AED 3,000
Freight allocated by weight	AED 2,400	AED 9,600

By value, the light and expensive Product X carries most of the freight. By weight, the heavy and cheap Product Y does. Freight is usually driven by weight or volume, so a value basis here would make Product Y look far more profitable than it is and Product X far less.

A sensible starting point, which your accountant should confirm for your business:

Customs duty: by value, because duty is normally assessed on value.
Insurance: by value.
Sea or air freight: by weight or volume, whichever the carrier charges on.
Clearing and port handling: by quantity of packages or by value, depending on how the agent bills.
Inland transport: by weight or volume.

Automation applies the basis consistently every time. Choosing it, and reviewing it when your shipping pattern changes, is a judgment call that stays with the accountant.

FIFO vs Weighted Average: How Costing Method Moves COGS

IAS 2 allows first-in, first-out (FIFO) or weighted average cost for interchangeable items. LIFO is not permitted. The method matters more when landed costs change between shipments, for example when freight rates rise.

Hypothetical illustration: you receive 100 units at a landed cost of AED 114.50, then 100 more at AED 121.00 after freight goes up. You sell 120 units.

Method	Cost of goods sold for 120 units	Closing stock (80 units)
FIFO	100 x 114.50 + 20 x 121.00 = AED 13,870	80 x 121.00 = AED 9,680
Weighted average	120 x 117.75 = AED 14,130	80 x 117.75 = AED 9,420

The difference is AED 260 on one item in one month. Across hundreds of items, it is material for gross margin reporting. Neither method is “right” in general. The important points are that the method is applied consistently, that landed costs are included before the cost is calculated, and that the system recalculates automatically when a late bill changes the cost of a receipt that is still in stock.

What Automation Takes Over vs What the Accountant Still Decides

Task	Automation can take over	The qualified accountant still decides
Capturing freight, duty and clearing bills	Reads the document, extracts amounts, shipment reference and currency	Confirms unclear or unusual documents
Linking bills to the right receipt	Matches on shipment, container or PO reference	Resolves bills with no clear match
Allocating costs	Applies the set basis to every receipt, every time	Sets the basis for each cost type and reviews it
Updating unit cost and COGS	Recalculates FIFO or weighted average automatically	Chooses the costing method and keeps it consistent
Clearing account reconciliation	Shows open balances by shipment	Investigates and clears old balances
Late bills after goods are sold	Splits the cost between stock on hand and sold units, by rule	Approves the treatment and the period it goes to
Stock write-downs	Flags slow-moving or below-cost items	Judges net realisable value and books write-downs
Period cut-off	Lists goods in transit and unbilled receipts	Signs off cut-off and accruals at month end

Before and After: Manual vs Reviewed Automated Landed Cost

All figures are hypothetical illustrations for a business receiving 25 import shipments a month, using these assumptions: manual work takes about 90 minutes per shipment (gathering bills, building the spreadsheet, allocating, posting journals) plus 6 hours a month reconciling the clearing account; reviewed automation takes about 20 minutes per shipment for review and exceptions plus 1.5 hours of reconciliation; admin cost is AED 90 per hour.

Item	Manual spreadsheet landed cost	Reviewed automated landed cost
Hours on allocation and posting	About 37.5 hours a month	About 8.5 hours a month, mostly review
Clearing account reconciliation	About 6 hours, often left to year end	About 1.5 hours, open items shown by shipment
Error risk	High: formula errors, wrong basis, missed late bills	Lower: same basis every time, exceptions flagged
When product margins are reliable	After month-end, if at all	During the month, as bills arrive
Late bills after goods are sold	Usually posted to expense	Split between stock and COGS by rule, then reviewed
Admin cost at AED 90 per hour (illustration)	About AED 3,915 a month	About AED 900 a month, before any provider charge

The hours saved are only part of the value. The bigger gain is that pricing, discount and product decisions are made on a real cost.

Want to see what AI could save your business on inventory costing? Chat with us on WhatsApp and we will go through it with your own numbers.

The Hidden Costs of Manual Landed Cost Spreadsheets

The admin hours are visible. These costs usually are not:

Wrong pricing decisions. If a product’s real cost is 14% higher than the report says, every price list, promotion and quote built on that report gives away margin.
Margin surprises at year end. When the auditor or year-end review moves freight from expense into inventory, or writes off an old clearing balance, the gross margin you reported all year changes.
Late close. Waiting for the last clearing bill before anyone can post the receipt holds up the month-end close. For more on shortening the close, see our guide on month-end close in 2 days instead of 10.
Stuck clearing balances. Bills paid but never allocated sit in a clearing account for months. Nobody knows whether they are real costs, duplicates or errors.
Duplicate cost bills. A clearing agent’s invoice paid once by the warehouse team and once by finance is hard to spot in a spreadsheet. Automated duplicate checks catch it before payment; see our article on automated controls that catch accounting errors and fraud.
Key-person risk. Often one person understands the landed cost workbook. When that person is on leave, the process stops.
Stock valuation questions from lenders. Banks lending against inventory ask how stock is valued. A spreadsheet with manual overrides is harder to defend than a system with an audit trail.

Controls to Demand Before You Trust Automated Landed Cost

Automation makes the process faster, but you still need to be able to prove the numbers. Ask for these controls, whether you run the system in-house or use a provider:

Receipt-level audit trail. For any item, you should be able to see its unit cost broken down into invoice price, freight, duty, insurance and clearing, and the source document for each.
Allocation basis recorded, not assumed. The basis used for each cost on each receipt should be stored, so a reviewer can see why the numbers are what they are.
Clearing account reconciliation every month. Open balances should be listed by shipment, with an age, and cleared or explained.
Human review of exceptions. Unmatched bills, unusual freight amounts and changes to allocation rules should need a named reviewer’s approval.
Change log for costing settings. Any change to the costing method, allocation rule or item cost should be logged with who, when and why.
Cut-off checks at month end. Goods received but not billed, and goods billed but not received, should be listed and accrued where needed.
Data security and privacy. Supplier, pricing and shipment data is commercially sensitive. Ask where it is stored, who can access it, whether access is logged, and how the provider meets UAE Personal Data Protection Law (PDPL) obligations where personal data is involved. Ask your own legal adviser which obligations apply to you.

For a fuller list of what to check before trusting automated books, read our CFO buyer checklist for automated books.

Readiness Checklist: Are You Ready to Automate Landed Cost?

Use these questions to judge where you stand today:

Does every import purchase have a reference (PO, shipment or container number) that also appears on freight, duty and clearing bills?
Do you know which cost types you incur on a typical shipment, and who bills each one?
Have you agreed an allocation basis for each cost type?
Is your costing method (FIFO or weighted average) set and applied consistently?
Do you have a goods-in-transit or landed cost clearing account, and is it reconciled monthly?
How do you handle bills that arrive after the goods are sold?
Are your item master data, units of measure and weights accurate enough to allocate by weight or volume?
Does your current system support landed cost natively, through an add-on, or not at all?
Who reviews exceptions and signs off cut-off each month?
Can you show a lender or auditor how a single item’s cost was built up?

If you answered “no” or “not sure” to several, the first step is usually cleaning up references and master data, not buying new software. Our guide to moving purchase invoices into the ledger without typing covers the capture side that landed cost depends on.

A Short Example From Practice

A mid-size trading company with several product ranges was reporting healthy gross margins on its imported lines, while cash never seemed to match the profit. Freight and clearing bills were being posted to expenses in the month they arrived. Once costs were linked to receipts and allocated by weight and value, the margin on a few heavy, low-value lines turned out to be close to zero, and some light, high-value lines were more profitable than the reports showed. The company adjusted pricing on the weak lines and stopped discounting them. The numbers here are rounded and the story is general; it is not traceable to any single client.

Frequently Asked Questions

What costs should be included in landed cost?

Under IAS 2, include the purchase price, import duties and other non-recoverable taxes, transport, handling and other costs directly attributable to bringing goods to their present location and condition. Deduct trade discounts and rebates. Storage after the goods arrive, general admin and selling costs are normally period expenses, not inventory.

Is landed cost the same as cost of goods sold?

No. Landed cost is the full cost of an item when it arrives in stock. Cost of goods sold is the landed cost of the items you actually sold in the period, calculated using FIFO or weighted average.

Which allocation method is best for freight?

There is no single answer. Freight is usually driven by weight or volume, so allocating by weight or volume often gives a fairer result than by value. Your accountant should choose the basis based on how carriers charge you and review it when your shipping pattern changes.

Can automation handle freight bills that arrive after the goods are sold?

Yes, if it is set up for it. The system can split the late cost between units still in stock (added to inventory) and units already sold (added to cost of goods sold). The accountant should approve the treatment and the period it is posted to.

Does Xero or QuickBooks Online support landed cost?

At the time of writing, Xero does not offer native landed cost allocation, and QuickBooks Online inventory features vary by plan. Many businesses on these systems use a third-party inventory app. Check the vendor’s current documentation for your plan.

Should customs duty be included in inventory cost?

Customs duty paid on imports that is not recoverable is part of the cost of purchase under IAS 2, so it normally belongs in inventory. For the duty rate on your goods, check with the customs authority of your emirate. This article does not cover tax or customs rules in detail.

FIFO or weighted average, which should we use?

IAS 2 allows both for interchangeable items; LIFO is not allowed. FIFO tracks recent costs in closing stock, while weighted average smooths cost changes. The key is to choose one, apply it consistently and include landed costs before the cost is calculated.

What is a landed cost clearing account?

It is a temporary account where freight, duty and other import costs wait until they are allocated to a receipt. It should be reconciled every month. A growing, unexplained balance is a sign that costs are not being allocated.

Can AI decide our allocation basis or stock write-downs?

No. Automation applies rules consistently and flags exceptions, such as slow-moving or below-cost items. Choosing the allocation basis, judging net realisable value and booking write-downs are accounting judgments for a qualified accountant.

Can an outsourced provider manage landed cost remotely?

Yes. Bills, receipts and allocations are digital, so the work can be done remotely with a qualified accountant reviewing the output. We serve businesses in the UAE and internationally, remotely.

How quickly will product margins become reliable?

New shipments can carry correct landed cost from the first month after set-up. Older stock may need a one-off review to correct its cost. The timeline depends on your data quality and volume, so we cannot promise a specific date for your business.

Next Step

If your product margins are built on supplier invoice prices, the first step is to find out how far they are from the real landed cost. See our AI accounting automation hub for the wider picture of what automation can take off your finance team’s desk.

Want to see what AI could save your business? Chat with us on WhatsApp.

This article is general information, not accounting, legal, tax or customs advice. All AED figures are hypothetical illustrations. Speak to a qualified professional about your own situation.

Written by Muhammad Qasim FCCA
Founder & CEO, Qaspro Global — UAE tax expert with 16+ years of experience in VAT, corporate tax and FTA audit support.