Profit on Every Invoice: FIFO Costing for UAE Traders

Profit on an invoice is the difference between what the customer paid and what the goods on that invoice actually cost to bring into the warehouse, and in a UAE trading company the only reliable way to know the second number is FIFO costing with landed cost applied at receipt. Most distributors in Dubai and Sharjah know their monthly gross margin from the accounts. Far fewer can say which invoice, which customer or which salesperson made or lost money last week, because the cost side is an average, an estimate or a figure someone remembers. This article explains why that happens, how FIFO closes the gap and what changes when every tax invoice carries its true cost.

Why “we made money this month” is not enough

A trading business lives on thin margins across many lines. Electronics, auto parts, building materials and FMCG share the same arithmetic: a few points of margin on high volume, with purchase prices that move every shipment and selling prices that move with every negotiation.

Monthly gross margin from the ledger hides the detail that matters:

A salesperson who hits target by discounting below cost on the fast movers.
A dealer quoted an old price list while replacement stock arrived at a higher cost.
A product line that looks profitable at list price but loses money once freight and duty are included.
Slow-moving stock still valued at a purchase-order figure from a year ago.

By the time the accounts reveal the problem, the quotes have been sent and the goods delivered. The useful question is not “did we make money?” but “did this invoice make money?”, and that needs a cost figure that is correct at the line level.

What FIFO costing actually does

First in, first out assumes that the oldest stock is sold first. Each receipt into the warehouse creates a cost layer: the quantity received and what each unit cost. When goods are sold, the system consumes the oldest layers first and records the cost of goods sold from those layers, not from an average and not from the current purchase price.

For a trader this matches reality better than the alternatives:

Method	How cost is set	Where it misleads a trader
Last purchase price	The most recent PO price	Overstates or understates margin whenever prices move between shipments
Weighted average	Running average of all stock on hand	Smooths away the effect of a single expensive shipment, so one bad buy hides inside many good ones
Standard cost	A fixed figure set by finance	Needs constant revision in a market where prices change monthly
FIFO	Oldest receipt layer consumed first	Reflects what the goods on this invoice actually cost; the layer is a fact, not an estimate

FIFO also produces a stock valuation that an auditor can trace: the balance sheet figure is the sum of the remaining layers, and each layer points to a goods receipt and a supplier bill.

Landed cost: the number most spreadsheets miss

The purchase order price is rarely the cost of the goods. A container of parts from Guangzhou or a pallet of appliances from Europe carries sea or air freight, insurance, customs duty, port handling, clearing agent fees and local transport. If those charges are posted straight to expense, every item on that shipment is undercosted and every margin on those items is overstated.

Landed costing allocates those charges across the receipt. The allocation basis can be value, weight, volume or quantity, depending on the charge. Duty follows value; freight usually follows weight or volume. Once allocated, the FIFO layer carries the landed figure, so the cost that flows to the invoice includes everything the shipment really cost.

A product bought at a good price with expensive freight can be a worse line than a dearer product that ships cheaply, and only landed FIFO shows it.

From receipt to invoice: how the cost travels

The chain in a trading ERP runs like this:

Purchase order. The agreed price per unit, in the supplier’s currency, with the expected landing charges estimated if known.
Goods receipt note. The quantity that actually arrived creates a cost layer per item, per warehouse, with lot or serial numbers where they apply.
Supplier bill and landed charges. The supplier’s invoice and the freight, duty and clearance bills are matched to the receipt and allocated across the layer, adjusting its unit cost.
Quotation. The margin guard reads the current FIFO cost of the items being quoted, so the salesperson sees the real margin before the price goes out.
Tax invoice and delivery. On delivery, the oldest layers are consumed, cost of goods sold is posted and the invoice records its gross profit.
Reports. Profit per invoice, per customer, per salesperson and per product line are answered from the same postings, with no spreadsheet in between.

Each step is a document the business already needs; the costing comes from linking them.

The margin guard: catching the loss before the quote is sent

Knowing profit after the fact is useful. Preventing a loss before it happens is better. A margin guard in the quotation module compares each quoted line against the live FIFO cost and the floor margin set for that product group or customer tier. A line below the floor is flagged, and the quote is routed for approval rather than sent.

Three things make the guard work in practice:

Cost visibility is controlled. Sales staff see a margin indicator rather than the cost itself, with field-level security hiding the cost column.
The floor is per group, not global. Fast-moving consumables can carry a lower floor than slow-moving capital items.
The history is attached. The approver sees what this item was last sold for, to whom and at what margin.

Expiry-dated goods such as food and cosmetics should leave in order of expiry, so FEFO replaces FIFO for those lines. Phones and equipment carry serial or IMEI numbers, so a specific unit with its specific landed cost is tied to a specific invoice. An inventory module that keeps layers by lot and serial handles both and still posts cost of goods sold correctly, which also answers warranty and recall questions later.

Reports finance can finally trust

Once cost travels with the stock, a set of reports stops being a monthly project and becomes a live view:

Profit per invoice. Revenue, FIFO cost, gross profit and margin on every tax invoice, searchable by customer, salesperson, branch and period.
Margin by product line. Which categories carry the business and which are sold for volume at no return.
Customer profitability. Dealers who negotiate hard but pay late look different once cost, discounts and DSO sit together.
Stock valuation by layer. The balance sheet figure, reconciled to receipts and bills, ready for the auditor.
Slow-moving and ageing stock. Layers that have not moved, valued at their actual cost, so the write-down discussion is based on numbers rather than opinion.

Because the figures are posted, the executive dashboard and the board pack draw from the same source as the invoice.

Where Next Orbit fits

Next Orbit Technologies, a software company based in Dubai serving clients across the UAE, the GCC and beyond, offers, implements and supports e-tijariX, a trading, distribution and e-commerce platform built around one stock figure and one ledger. Its catalogue and inventory module runs FIFO and FEFO costing with multi-warehouse, bins, lots and serial or IMEI tracking; purchasing applies landed charges across goods receipts; the quotation module carries the margin guard; and the reports and dashboards module answers “profit on invoice” from true FIFO cost. For the wider stock picture see inventory management software for the UAE, and for how costing fits with purchasing and finance see ERP for trading companies in the UAE.

Frequently asked questions

What does profit on invoice mean?

Profit on invoice is the gross profit recorded on a single tax invoice: the invoiced value less the cost of the goods on that invoice, where cost is taken from the stock layers consumed at delivery rather than from an average or a list price. It lets an owner see which customers, salespeople and product lines earn money, invoice by invoice.

Is FIFO costing acceptable for accounts in the UAE?

FIFO is a recognised inventory valuation method under the accounting standards generally applied in the UAE, and it produces a stock figure that can be traced to receipts and supplier bills. Which method suits your business and how it interacts with corporate tax should be confirmed with your auditor or tax adviser; this article is general information, not accounting or tax advice.

How is landed cost calculated for imported goods?

Landed cost adds freight, insurance, customs duty, port and clearing charges and local transport to the purchase price of a shipment, then allocates the total across the items received using a basis such as value, weight, volume or quantity. The resulting unit cost is stored in the FIFO layer, so later invoices carry the complete cost rather than the bare purchase price.

Can salespeople see cost prices in the system?

Only if you want them to. Role-based permissions and field-level security let an owner hide cost and margin figures from sales roles while still showing a margin indicator or a floor warning. Managers and finance see the full picture, and every view of a cost field can be logged in the audit trail.

What happens when the purchase price changes between shipments?

Each receipt creates its own cost layer at its own landed cost, so the two shipments sit side by side in the warehouse at different values. Sales consume the older layer first. When the older layer is exhausted, the cost of goods sold moves to the newer figure, and the margin guard on new quotes updates at the same moment, which is exactly when a price list review is due.

Key takeaways

Monthly gross margin hides which invoices, customers and salespeople make or lose money.
FIFO costing records the cost of the actual stock layer consumed, not an average or a list price.
Landed cost allocation puts freight, duty and clearance into the layer, so margins stop being overstated.
A margin guard at quote time, reading live FIFO cost, prevents losses rather than reporting them.
Lots, serials and FEFO extend the same discipline to expiry-dated and serialised goods.
Profit per invoice, customer profitability and stock valuation by layer become live reports once cost travels with stock.

Next step

If margin figures still come from a month-end spreadsheet, Next Orbit’s engineers can show the chain from goods receipt to profit on invoice on Next Orbit’s sample data. Request a demo or contact us.