RUBICON

Case Study: JAFZA Trading Company, Dubai

How a Jebel Ali free zone trading company replaced 4 disconnected systems with Odoo, cut landed cost errors by 90%, and halved their month-end close time.

Client Overview

A JAFZA-registered trading and distribution company importing consumer electronics and accessories from China, Taiwan, and South Korea for distribution to UAE retail chains, hypermarkets, and online retailers. Annual turnover of AED 45 million, with a team of 28 staff across purchasing, warehouse, sales, and finance.

The company had been operating for 8 years on a combination of a legacy ERP system, separate accounting software, Excel-based landed cost calculations, and a standalone HR system for payroll. The systems did not talk to each other, meaning every import shipment required manual data entry in at least 3 systems.

The Challenges

Landed Cost Errors

Landed cost calculations done in Excel — freight, insurance, customs duty, and clearance fees calculated manually and allocated to products. Errors were common and product margins unreliable.

Inventory Inaccuracy

Stock levels in the legacy ERP frequently did not match physical warehouse counts. The team had lost confidence in system stock and was doing weekly manual counts.

Slow Invoicing

Sales invoices were created in the accounting system, but the data had to be manually transferred from the sales order in the legacy ERP. Invoice cycle was 3-5 days from delivery.

VAT Return Complexity

Three systems contributing to VAT-relevant transactions. The accountant spent a week every quarter reconciling VAT across systems for the FTA return.

No Profitability Visibility

Without accurate landed costs, the team could not calculate true product margins. Pricing decisions were based on intuition rather than data.

Disconnected Purchasing

Purchase orders raised in the legacy system, but supplier payment managed in accounting software. No automated matching between PO, goods receipt, and supplier invoice.

The Odoo Solution

Rubicon implemented Odoo over 10 weeks, replacing all 4 systems with a single integrated platform. The implementation covered Inventory, Purchase, Sales, Accounting with UAE VAT, Landed Costs, and HR/Payroll.

Landed Cost Automation

The most impactful change was automating landed cost allocation. For each import shipment, freight, insurance, customs duty, and clearance costs are entered once in Odoo and automatically allocated to each product line based on weight, volume, or value — whichever allocation method is most appropriate for that shipment type. Landed cost is calculated instantly and accurately, giving the team real product margins within hours of goods receipt rather than days.

Three-Way PO Matching

Odoo automatically matches supplier invoices to purchase orders and goods receipt notes. Discrepancies are flagged for review rather than paid. This eliminated accidental overpayment of suppliers — a real problem with the previous manual process — and reduced the time spent on supplier invoice processing by 60%.

Integrated Sales-to-Invoice

Sales orders in Odoo generate delivery orders automatically. When the delivery is confirmed, the invoice is generated with one click — pre-populated with the correct products, quantities, and pricing. Invoice cycle reduced from 3-5 days to same day.

JAFZA Free Zone Configuration

Odoo configured for JAFZA-specific requirements: customs bond management for bonded goods, re-export documentation, zero-rated VAT treatment for qualifying free zone transactions, and certificate of origin tracking for preferential duty purposes.

Results After 12 Months

90%

Reduction in landed cost calculation errors

50%

Faster month-end financial close

Same day

Invoice generation vs 3-5 days previously

100%

Inventory accuracy — system matches physical stock

“We were running a AED 45 million business on Excel for landed costs and had no idea what our real margins were. Odoo changed everything — we now know within hours of receiving a shipment exactly what each product cost us and what margin we make on every sale.”

— Finance Manager, JAFZA Trading Company

Key Learnings

Landed cost accuracy unlocks pricing power: Once the company had accurate landed costs, they discovered that 3 product categories had been priced below true cost — a problem that had been masked by the Excel approximations. Correcting pricing on these categories added AED 800,000 in annual margin.

System consolidation reduces hidden costs: Four software subscriptions replaced by one. Four training programs replaced by one. Four sets of user credentials replaced by one. The licensing savings alone covered 40% of the implementation cost annually.

Free zone configuration requires specialist knowledge: The JAFZA-specific VAT treatment — particularly for re-exports and intra-free zone transactions — required careful configuration. Getting this wrong would have created FTA compliance issues. Rubicons UAE regulatory knowledge was critical here.

Running a Trading Company in UAE?

Book a free consultation. Well show you how Odoo can give you the landed cost accuracy and inventory control this client achieved.

Book Free Consultation+971 50 448 9971

Related Services