The Business

• UAE-headquartered trading business in industrial supplies
• Annual revenue: ~AED 32M
• 3 warehouse locations (Dubai, Jebel Ali Free Zone, Sharjah)
• Trades in 5 currencies: AED, USD, EUR, SAR, GBP
• 18 staff: sales, procurement, warehouse, finance, admin

Why They Outgrew QuickBooks

• Multi-warehouse stock visibility was effectively impossible — workarounds via separate company files broke reporting
• Multi-currency handling was creating reconciliation errors in finance
• UAE VAT reporting was manual — finance was rebuilding the return from QuickBooks reports each quarter
• No CRM, no purchase approval workflow, no integrated inventory management
• Salespeople had no live view of stock — quotes were promised on stock that was already committed

The Migration (RIM-Based)

Weeks 1–2: Discovery + Scope

Modules selected: Accounting, Inventory, Purchase, Sales, CRM, HR. Multi-currency setup designed with AED as company currency. Three warehouses configured with inter-warehouse transfer flows. UAE VAT localisation activated with TRN and fiscal positions for FZ exports.

Weeks 3–5: Configuration + Migration

Chart of accounts mapped from QuickBooks (with rationalisation — went from 340 accounts to 180). 1,800 products imported with multi-currency price lists. Customer + vendor master data (~ 950 records) imported with TRN flags. Opening balances reconciled to QuickBooks closing trial balance to the dirham.

Weeks 6–7: UAT + Training

Critical scenarios: full quote-to-cash cycle with FZ customer, multi-currency PO with USD vendor, warehouse-to-warehouse transfer with proper VAT treatment, VAT return generation for a partial period. All scenarios passed.

Week 8: Cutover

Cutover Thursday evening → Sunday morning (UAE weekend). Final QuickBooks balance migrated; opening Odoo trial balance reconciled and signed off Sunday afternoon. Live operations resumed Monday morning with on-site Rubicon presence Monday and Tuesday.

Outcomes

Capabilities Gained

• Single source of truth for stock across 3 warehouses, visible to sales in real time
• Multi-currency revaluation handled automatically at month-end
• UAE VAT return generated from Odoo in 2 hours, including FTA audit file export
• Purchase approval workflow with documented authorisation matrix
• Sales pipeline (CRM) replacing previous WhatsApp + Excel approach
• Quarterly close reduced from 7 working days to 3