How a UAE Trading House Closed the Gap Between Quoted Margin and Actual Margin
Customer Overview
The client is a UAE-based trading and distribution business supplying equipment and materials into project-driven sectors — contractors, industrial clients and infrastructure work across the UAE and wider GCC. Supply is sourced internationally, largely from Europe and Asia, in multiple currencies, with landed cost built from freight, duty, clearance, inland delivery and bank charges on top of ex-works price.
This is not catalogue distribution with a fixed price list. Almost every order begins as a customer enquiry for a specific scope, is costed individually, and is delivered as a job with its own margin. The business lives or dies on whether the margin it quoted is the margin it actually earns.
For years, it could not reliably tell the difference.
The Challenge
1. The entire quote-to-cash chain ran on Excel and email
The operating flow was clear enough in principle:
In practice, each step lived in a different place. Enquiries arrived by email and sat in individual inboxes. Supplier RFQs went out as separate emails with responses compared manually. Costing sheets were Excel files, copied and renamed for every revision, circulated as attachments. Quotes were built by retyping from the costing sheet. Sales orders, purchase orders and goods receipt notes were raised in different systems or on paper.
Nothing carried a reference forward. By the time a job was delivered, reconstructing which costing version the quote was based on required an archaeology exercise through someone’s email.
2. Quoted margin and actual margin were different numbers nobody compared
This was the expensive problem. The costing sheet at quote stage was an estimate: supplier price, estimated freight, estimated duty, estimated clearance, an FX assumption, and a margin applied on top.
What actually happened — the real freight invoice, the real clearance charges, the FX rate on the day of payment, the supplier’s revised price after the order was placed, demurrage because a container sat at port, an unplanned site delivery — was captured in accounting as cost, but was never reconciled back against the line-by-line estimate that justified the price.
Leadership knew gross margin at company level. They could not answer the question that mattered: on this job, where did the margin go, and was it the estimate that was wrong or the execution? Without that, the same costing assumptions were reused on the next quote and the same erosion repeated.
3. Three-way matching was a manual, after-the-fact exercise
Purchase order, goods receipt and vendor bill sat in different places. Matching them was a month-end task performed by hand. Short deliveries were caught late, price variances between PO and invoice were sometimes missed entirely, and vendor bills were occasionally paid against quantities that had never been received.
4. Project costs and expenses did not attach to the job
Expenses were booked to general ledger accounts rather than to the job that incurred them. Site visits, transport, overtime, third-party handling, and rework all disappeared into overhead. Jobs that were genuinely unprofitable looked acceptable because their true cost was spread across the business.
5. E-invoicing was approaching and vendor master data was not ready
The UAE’s phased e-invoicing mandate was moving from policy to deadline during the project. Connection to the system is only possible through a Ministry of Finance-Accredited Service Provider, the format is structured XML over a Peppol-based model, and scope covers business-to-business and business-to-government transactions regardless of VAT registration status.
The practical implication for a trading business with a large supplier and customer base is unglamorous: every counterparty record needs a correct Tax Registration Number, exact legal name, address and participant identifier. Years of partial vendor and customer master data were about to become rejected invoices.
The Solution
Techvaria implemented Zoho CRM and Zoho Creator as a single connected chain, with a deliberate division of responsibility between them.
Zoho CRM owns the customer-facing front of the process — enquiry, opportunity, quotation and the commercial relationship. Zoho Creator owns everything that CRM is not built to model: multi-line versioned costing with landed-cost components, supplier RFQ comparison, goods receipt, three-way matching and job-level cost accumulation.
1. Enquiry and RFQ capture in Zoho CRM
Customer enquiries are captured in CRM with scope, required delivery date, and the originating channel. Each enquiry generates one or more supplier RFQs, issued from the system and tracked for response. Supplier quotations are recorded against the RFQ so that price comparison is a view rather than a spreadsheet, with the selected supplier and the reason for selection retained.
2. The estimated Costing Sheet, built properly in Zoho Creator
The costing sheet became a structured, versioned record rather than a file. Each line carries supplier cost in source currency, applied FX rate, freight, duty, clearance, inland delivery, bank and handling charges, and a margin — producing a landed cost per line and a quoted price per line.
Revisions create versions rather than overwriting, so the costing basis for any quote is permanently recoverable. Approval gates apply: a costing sheet below a defined floor margin cannot proceed to quotation without authorisation at the appropriate level.
3. Quotation and Sales Order generated, not retyped
Quotations are generated directly from the approved costing sheet, eliminating transcription error and ensuring the document issued to the customer matches the basis on which it was approved. On acceptance, the quotation converts to a Sales Order carrying the costing reference forward.
4. Purchase Order, GRN and Vendor Bill with automated three-way match
Purchase orders are raised against the sales order and the selected supplier quotation, inheriting the agreed price. Goods receipt notes are recorded on arrival with actual quantities and condition, including partial receipts. Vendor bills are matched automatically against PO and GRN, with tolerance thresholds; anything outside tolerance routes for review rather than silently passing.
Quantity and price variances surface at the point they occur instead of at month-end.
5. The Actual Costing Sheet — the heart of the system
This is what the project was really for. As vendor bills, freight invoices, clearance charges and job expenses post against the job, the actual costing sheet builds automatically alongside the original estimate.
The result is a line-by-line variance view: estimated landed cost against actual landed cost, per component, per line, with the resulting difference between quoted margin and realised margin.
The behavioural change this produced mattered more than the report itself. Once estimators could see that freight assumptions on a particular lane were consistently 18% light, or that clearance on a particular category was routinely underestimated, the next quote was built on better numbers. The variance report stopped being a post-mortem and became an input.
6. Projects and Expenses attached to the job
Each order is managed as a project with its own cost ledger. Expenses — transport, site visits, third-party handling, rework — are captured against the job through a mobile-accessible form rather than booked to overhead. Job-level profit and loss is live rather than retrospective.
7. Counterparty master data prepared for e-invoicing
Vendor and customer records were audited and remediated for Tax Registration Number, exact legal name, address and participant identifier, with validation preventing new records being created incomplete. This was positioned as a data-readiness exercise ahead of connecting to an accredited service provider, not as an e-invoicing implementation in itself.
The Impact
Measured across the two quarters following go-live:
The core deliverable. Job-level margin erosion is now attributable to a specific cost component rather than discovered in aggregate at period end.
Costing sheet to approved quote, with approval routing built in rather than chased by email.
Primarily from correcting systematically understated freight and clearance assumptions once the variance data existed to correct them.
Matching is automatic within tolerance; staff now review only the exceptions that genuinely need judgement.
Every quote is permanently traceable to the approved costing version it was generated from.
Expenses attach to the job, so an order trending toward loss is visible while there is still time to act on it.
What We Would Tell You Honestly
Points worth understanding before scoping something similar:
- This is a development project, not a configuration. Zoho CRM alone cannot model multi-line versioned costing with landed-cost components, approval gates and three-way matching. That is why Creator carries it. Anyone proposing this as standard CRM configuration has not understood the requirement, and the gap usually surfaces around month four.
- Creator is not an accounting system and should not be treated as one. The vendor bill here is an operational matching document. Statutory ledgers, VAT returns and financial reporting remain in your accounting system. Keeping that boundary explicit avoids building a shadow general ledger that nobody can audit.
- Someone has to own the Creator application after go-live. A custom build is a maintenance commitment across platform upgrades, not a one-off cost. If there is no credible answer to who owns it in year three, reduce the scope of what you customise.
- Neither Zoho CRM nor Creator is an accredited e-invoicing service provider. UAE e-invoicing connection runs through a Ministry of Finance-accredited provider. What this system does is make your master data clean enough that the connection works. Treat those as two separate workstreams with two separate budgets.
- Multi-currency needs deciding early. Which rate applies at costing, at PO, at receipt and at payment — and who absorbs the difference — is a commercial policy question, not a technical one. Resolve it before the build, because retrofitting it is painful.
- Variance reporting only improves estimates if someone acts on it. The system makes the erosion visible. Closing the loop back into costing assumptions is an operating discipline, and the clients who get the full return are the ones who review variance monthly rather than filing it.
Conclusion
Most trading businesses of this type already know their overall gross margin. What they rarely know is which jobs earned it and which quietly consumed it, because the estimate that justified the price and the costs that followed are never compared line by line.
Connecting enquiry through to actual cost is not glamorous work. It is a chain of documents that each have to carry a reference forward, and a costing model honest enough to admit what it assumed. But it is the difference between pricing from last year’s assumptions and pricing from what actually happened — and in a trading business running on single-digit margins, that difference is the business.
This case study is representative of a UAE trading and distribution engagement. Client details are anonymised and performance figures are illustrative of outcomes achievable in comparable deployments. UAE e-invoicing requirements referenced here reflect published Ministry of Finance guidance current as of late 2026; phased deadlines and accredited service provider requirements should be verified against current official sources before planning your own implementation.
