— Industries / Trading
ERPNext for trading companies that import, re-export and ship across the GCC.
UAE trading is a high-velocity, multi-currency, multi-warehouse business with LCs, landed cost, and FTA edge cases on every transaction. Here's how we set ERPNext up to handle all of it cleanly.
TL;DR
Five things to know.
- Multi-currency is not optional. Most UAE trading groups deal in AED, USD and at least one Asian currency. ERPNext's multi-currency engine with auto-rate refresh handles it natively — but the Chart of Accounts and exchange-gain/loss treatment need careful setup on day one.
- Landed cost is where margin lives or dies. Without proper Landed Cost Vouchers, your gross-margin reports lie. We set this up as a default workflow, not an afterthought.
- Designated-zone VAT needs Tax Categories on parties and Tax Rules. Free-zone trading flows (re-export, intra-zone, into mainland) each have a different VAT treatment. Misconfigure and you'll over-claim or under-charge.
- LCs are accounting work, not just admin. Sight LCs, usance LCs and back-to-back LCs each book differently. We model them as Bank Guarantee records with proper contingent-liability treatment.
- Multi-company with inter-company transactions covers groups. One ERPNext database can cleanly run a Dubai mainland LLC, a JAFZA free-zone entity and a Saudi subsidiary in parallel — with consolidated reporting at the group level.
Context
The trading business in the UAE & GCC.
The UAE has been a regional re-export hub for half a century, and the trading sector remains one of the largest contributors to non-oil GDP. Trading companies span every product category — electronics, building materials, FMCG, automotive parts, machinery, chemicals, food, textiles — and most operate across multiple jurisdictions inside and outside the UAE.
The geography is concentrated. Dubai Multi Commodities Centre (DMCC) in JLT hosts thousands of commodity trading licences, with a strong skew toward gold, diamonds, tea, coffee and increasingly carbon credits. Jebel Ali Free Zone (JAFZA) is the heavyweight for industrial and bulk-goods trading, with port access and bonded warehousing. Dubai South hosts logistics-led trading near Al Maktoum International. Sharjah's SAIF Zone and Hamriyah serve light-manufacturing and trading SMEs at lower cost than Dubai. RAK FTZ is the budget option, popular with SME re-exporters.
Mainland trading licences (issued by DED in each emirate) cover the bulk of B2B distribution into the local market — anything sold to a UAE end customer typically routes through a mainland licensed entity, often as a sister company to a free-zone holding entity.
Common business shapes we see: single-entity importers (one mainland licence, sourcing from overseas, selling locally); two-entity hybrids (a free-zone entity for international flows + a mainland sister for UAE B2B); multi-entity groups (typically 3–6 entities spanning Dubai, Sharjah, Saudi and sometimes a Singapore or Hong Kong sourcing arm); designated-zone re-exporters (goods never enter UAE mainland, sold to GCC and Africa); and commodity-trading houses (DMCC-licensed, often dealing in metals or soft commodities with futures-like exposures).
Each shape has different ERP needs, but the constants are: multi-currency, multi-warehouse, FTA VAT compliance, LC and bank-guarantee handling, and consolidated group reporting where there's more than one entity.
Capabilities
What ERPNext gives trading companies.
Multi-currency invoicing with auto-rate refresh
AED as functional, plus arbitrary number of transaction currencies. Rates pull daily from a configurable feed (we use UAE Central Bank rates for accounting, OANDA for treasury). FX gain/loss posts automatically on settlement. Customer and supplier statements available in either party currency or company currency.
Landed-cost tracking on inbound consignments
Landed Cost Voucher prorates clearing, freight, insurance, customs duty and other charges across receipts by qty/weight/value. Item valuation updates retroactively in stock. Gross-margin reports reflect true landed cost. Avoids the classic "we thought we made 18% but we made 6%" trading mistake.
Letters of Credit and bank guarantees, properly accounted
Sight LC, usance LC and back-to-back LC patterns each modelled with contingent liability on opening, supplier liability on goods receipt, and cash settlement on bank presentation. Bank Guarantee DocType tracks expiry, renewal, charges. Templates for Emirates NBD, ADCB and FAB transaction patterns ship with our setup.
Multi-warehouse with bonded and free-zone segregation
Tree of warehouses per company — bonded zones, free-zone yards, mainland stores, customer-consignment locations. Stock visibility group-wide. Stock transfers between warehouses are non-revenue moves; transfers between companies fire inter-company workflow. Per-warehouse cost tracking.
Designated-zone VAT done correctly
Tax Categories on customers (Mainland UAE, Designated Zone Goods, Designated Zone Services, Outside GCC) plus Tax Rules cross-referencing item type fire the right tax template automatically. Re-export, intra-zone, and zone-to-mainland flows each route to the right VAT-201 box. No manual selection at sales-invoice time.
Inter-company sales between sister entities
Sales Invoice from Company A to Company B auto-generates Purchase Invoice in Company B with matching tax, GL, and inter-company AR/AP reconciliation. Configure customer-supplier mapping per company pair once. Supports 2–6 entity groups with consolidated reporting at group level.
Customer credit limits, ageing and follow-up
Per-customer credit limit with hard or warning enforcement at order/invoice creation. AR ageing buckets configurable. Built-in payment-reminder workflow with email templates. Statement of account in either party or company currency. Sales rep dashboards show their own ageing book.
Supplier scorecards and procurement automation
Supplier scorecard tracks on-time delivery, quality reject rate, price variance, and payment-term compliance. Auto-Material Request from re-order levels triggers Request for Quotation to multiple suppliers; quote comparison is built in. Approved Supplier list per item category.
Real scenarios
Common trading scenarios we've delivered.
A Dubai-based trading group with four sister companies, three currencies and consolidated financial reporting. Group structure: a JAFZA holding entity, a Dubai mainland distribution LLC, a Sharjah Hamriyah light-manufacturing arm, and a Saudi subsidiary in Riyadh. ERPNext configured as a single instance with four Companies, shared customers/suppliers across the group, inter-company transactions wired between every pair, and consolidated P&L plus Balance Sheet at group level. AED, USD and SAR as transaction currencies; each company's functional currency set per its jurisdiction. VAT-201 per UAE entity, ZATCA per the Saudi entity, with separate consolidated VAT reporting for the UAE VAT group.
A DMCC commodity trader dealing in tea and coffee with LC-funded purchases from origin countries. All purchases sight-LC funded through Emirates NBD; each shipment opens an LC at PO confirmation, recognises supplier liability on goods receipt at the JAFZA bonded warehouse, and settles on bank presentation. Landed cost includes freight, insurance, port charges, tea-board duties and CHA fees — all routed through Landed Cost Vouchers so item valuations reflect true cost. Sales out of the bonded warehouse to other GCC and African buyers run designated-zone-out treatment for VAT.
A Sharjah SAIF Zone re-exporter sourcing from China and selling to East Africa. Goods land at Sharjah airport free-zone warehouse, never enter UAE mainland, and re-export within 60–90 days. ERPNext multi-warehouse models the bonded inventory; sales are out-of-scope UAE VAT (correctly tagged via Tax Category "Outside GCC" on the African customers). Cash flow tight enough that we built a custom dashboard showing aged inventory by source consignment and projected re-export date.
A mid-size building-materials importer migrating from Tally with 8,000 active SKUs and 600 customers. Tally migration via our standard ERPNext migration kit — masters, opening balances, last 24 months of historical transactions for trend reporting. Two-month parallel run, weekly reconciliation against Tally, then cutover. Post-go-live the team gained AR ageing they could actually act on, supplier scorecards that exposed two consistently underperforming vendors, and gross-margin reporting at item level for the first time.
Day one
What we configure on day one.
Every Craft trading engagement starts with a fixed checklist. We don't begin custom work until these are in place — they're the difference between an ERP that works and one that limps.
- UAE-localised Chart of Accounts, validated against your auditor's preferred structure
- Multi-currency configuration with daily auto-refresh from a configured rate feed
- FX gain/loss accounts and exchange-rate revaluation schedule
- Sales and Purchase Tax Templates for standard, zero-rated, exempt, out-of-scope and reverse-charge
- Tax Categories on customers (Mainland, Designated Zone Goods, Designated Zone Services, Outside GCC) and items (Goods vs Services)
- Tax Rules cross-referencing customer and item categories to fire the right template automatically
- TRN field renamed and validated on Customer and Supplier; mandatory for invoice issuance
- Bilingual (English/Arabic) tax invoice print format, Article 59-compliant
- Warehouse tree with bonded, free-zone and mainland segregation tagged
- Landed Cost Voucher template configured with your standard apportionment basis
- Bank Guarantee / LC DocType extensions and journal templates for sight, usance, back-to-back
- Customer credit-limit policy with warn or block at order entry
- Inter-company customer-supplier mappings if multi-company group
- Standard reports pinned: AR ageing, Stock Ageing, Gross Margin, VAT-201, Landed-Cost variance
- User roles for finance, sales, purchase, warehouse, management — with permissions tested
Pricing
Pricing approach.
Trading-company implementations run on a fixed-fee, fixed-scope model. Once discovery is complete, we issue a single SOW with a not-to-exceed price covering implementation, configuration, training and go-live. No surprise change orders inside the agreed scope.
The fee depends on entity count, currency count, warehouse complexity, integration count, and whether you need migration from a legacy system. Single-entity setups land in a different bracket from 5-entity groups with LC workflows. We don't publish exact prices because they vary too much; what we will commit to is a fixed number once we've done discovery.
See our ERPNext pricing approach for how we structure engagements and what's included.
Add-ons
Add-ons we often implement.
Most trading clients add one or more of these in phase 2:
- UAE VAT deep-setup — VAT groups, designated-zone Tax Rules, custom consolidated VAT-201 for grouped entities.
- Custom dashboards and reports — landed-cost variance, consignment ageing, LC exposure, gross-margin by source country.
- Bank integrations — payment file export and statement import for Emirates NBD, ADCB, FAB, Mashreq.
- NexGPOS — for trading groups with retail showrooms or wholesale-to-retail flows.
- E-commerce integrations — Shopify, Magento, WooCommerce sync of products, orders, stock and customers.
- Managed AMC — ongoing version upgrades, monitoring, ticket SLAs, quarterly reviews.
Questions
FAQ.
Can ERPNext handle Letters of Credit (LC) and bank guarantees?
Yes — and properly, not just as memo lines. We model an LC as a Bank Guarantee record linked to the underlying Purchase Order. The opening of the LC books a contingent liability (off-balance) via a Journal Entry; on goods receipt, the supplier liability is recognised against the LC; on the bank settlement, the LC is closed and cash leaves. Sight LCs, usance LCs, and back-to-back LCs each have their own configuration recipe — we have templates for the three common UAE bank patterns (Emirates NBD, ADCB, FAB).
How does multi-warehouse work for trading companies with branches in multiple emirates?
ERPNext models warehouses as a tree under each Company, so a Dubai trading entity can have warehouses for JAFZA bonded, Dubai South free zone, and Al Quoz mainland — all in one entity, with stock visibility across all three. Stock transfers between them are Stock Entry documents that move quantity without a sales/purchase invoice. For multi-emirate branches operating as a single legal entity, you keep one Company. For separate licensed entities (e.g. Dubai LLC + Sharjah LLC), use multi-company with inter-company transactions.
Does ERPNext do landed-cost tracking for imports?
Yes — through the Landed Cost Voucher. When you receive a shipment, the supplier invoice gives you item cost. As clearing-agent invoices, freight, insurance, customs duty and other charges arrive, you book them against a Landed Cost Voucher that prorates them across the original receipt by quantity, weight, or value (your choice per voucher). The item valuation in inventory updates retroactively, and your gross-margin reporting reflects true landed cost — not just supplier price.
Can it handle inter-company sales between sister entities?
Yes. Inter-company transactions in ERPNext auto-create the matching counterparty document. A Sales Invoice from Company A to Company B (both in your group) auto-generates the Purchase Invoice in Company B, with matching tax treatment, GL effects, and inter-company AR/AP reconciliation. Configure once per company pair — set the customer in A that maps to B, and the supplier in B that maps to A — and it runs hands-off after that. We use this for trading groups with 2–6 entities routinely.
How do we manage consignment stock?
Consignment goods are physically with the consignee but legally still owned by you until sold. ERPNext handles this via a separate "Consignee" warehouse type tagged with the consignee party. Stock transfer to the consignee warehouse is a non-revenue Stock Entry. When the consignee reports a sale, you book a Sales Invoice against them and the COGS is taken from the consignee warehouse. Reverse moves (returns) are simple stock entries back to your own warehouse. We add a custom Consignment Reconciliation report that shows aged consignment stock by consignee.
Does it integrate with UAE banks for direct payments?
Direct host-to-host bank integrations exist for some UAE banks (Emirates NBD, ADCB, Mashreq) via SWIFT MT files or proprietary APIs, and we have built ERPNext payment-export connectors for several. For most SMEs, we configure ERPNext to export a payment file in the bank's required CSV/SWIFT format that finance uploads to the bank portal. Reconciliation imports the bank statement back into ERPNext. Full host-to-host is a custom build — typically 2–3 weeks per bank.
Can ERPNext handle re-export and out-of-scope sales for free-zone trading?
Yes. Free-zone trading companies in JAFZA, SAIF Zone, DAFZA or RAK FTZ that re-export goods without those goods entering the UAE mainland are typically out-of-scope for UAE VAT. ERPNext's Tax Categories and Tax Rules let you tag the customer (e.g. "Outside GCC") and the goods movement (e.g. "Designated Zone Re-Export") so the right zero/out-of-scope template fires automatically. The VAT-201 report then bucket-sorts these correctly without manual intervention.
How long does an ERPNext implementation take for a trading company?
A single-entity trading company with multi-currency, multi-warehouse, and standard LC handling typically runs 10–14 weeks from signed SOW to go-live. Multi-company groups with 3–6 entities run 16–22 weeks. The longest pole is usually master data — products, customers, suppliers — and opening balances reconciled against the legacy system.
— Ready when you are
Talk to a real ERP consultant.
A 30-minute call is the fastest way to know if we're a fit. No slides.