MARGIN ANALYSIS · MAY 2026 · 18 DELIVERED DEALS · ESTIMATED VIEW
Estimated margin analysis 18 deals · est. gross margin 12.4% · range 3%–22%
Deal-level margin analytics for the Sales & CRM operational view. This is ESTIMATED margin only. Accounts & VAT owns the final financial truth · Inventory owns the cost basis truth · Purchase owns the vendor bill truth. Sales does NOT claim final profit · final settlement, journal posting, and VAT calculation live in the Accounts module. Use this surface for operational steering only · not financial reporting.
Estimated margin · verified by Accounts
Read-only · Inventory cost basis
Sales summary · settlement verified by Accounts
Estimation boundary · not final truth
All margin figures below are operational estimates derived from deal value (Sales) minus cost basis (Inventory) minus discounts (Sales) minus reconditioning estimate (Prep / reconditioning estimate) minus trade-in adjustments (Sell Your Car). Final profit lives in the Accounts & VAT module · which posts the actual journals, settles via Accounts, and computes the final VAT-adjusted margin in the financial close. Sales never claims final profit truth. Use this report to flag at-risk deals · not for board-level financial reporting.
EST. GROSS MARGIN↑ 1.4 pts
12.4%
vs 11.0% Apr · range 3%–22%
Estimate · before final VAT
EST. MARGIN VALUE
521K
aggregate · 18 deals
Accounts owns final
BEST DEAL
22%
Lexus LX600 · D-26210 · trade-in lift
AT-RISK DEALS
4
est. margin < 5% · approval flagged
DISCOUNT IMPACT
-3.2pts
avg margin erosion · 14 of 18 deals
Margin waterfallaggregate · 18 delivered deals · stage contribution to estimated margin
Estimate onlyDeal value4.20M
− Cost basis−2.95M
− Discounts−134K
− Recond. est.−52K
+ Trade-in lift+38K
Est. margin521K · 12.4%
Deal valueaggregate · 18 deals
4.20M
− Cost basisInventory · read-only
−2.95M
− DiscountsSales documents
−134K
− ReconditioningPrep / recond. estimate
−52K
+ Trade-in liftSell Your Car
+38K
Est. margin12.4% · estimate only
521K
Cost basis · discount · reconditioning · trade-in values sourced from Inventory · Sales documents · Prep / reconditioning estimate · Sell Your Car respectively. Final margin computed in Accounts close.
Top margin dealsest. margin % descending
1
D-26210 · Lexus LX600 2024
Fatima Al Suwaidi · trade-in BMW X5 lift · K. Ahmed
22%119K est.
2
D-26198 · Mercedes G63 2024
Hassan Rahman · S. Karim · no discount
18%94K est.
3
D-26194 · Bentley Bentayga 2024
Noora Bin Hamoodah · S. Manager · luxury margin
16%84K est.
At-risk margin dealsest. < 5% · approval required
4 flagged
!
D-26611 · Mini Cooper SE 2024
Sarah Khouri · K. Ahmed · 22K discount · approval pending
3%est. 4K
!
D-26224 · Range Rover Sport 2024
Mohammed Al Hashimi · S. Manager · trade-in adj
4%est. 18K
!
D-26219 · Porsche Cayenne 2024
Ahmed Al Shamsi · M. Hamoud · 32K discount
4%est. 14K
!
D-26201 · Toyota Land Cruiser 2024
Tariq Al Mansoori · used · recond. heavy
5%est. 11K
Approval impact: deals with est. margin < 5% require GM approval per standard discount policy. 4 of 4 flagged are in approval queue · final margin will be confirmed by Accounts at delivery close.
Data rules6
- Margin is ESTIMATED · Accounts & VAT owns final financial truth
- Cost basis sourced read-only from Inventory · Sales does not edit cost
- Discount impact reflects Sales document discounts · approval policy lives in Settings
- Reconditioning estimate · source placeholder · final cost truth outside Sales
- Trade-in adjustment sourced from Sell Your Car · Accounts settles trade-in valuation finally
- Sales does not post journals (ACC-02) · does not compute final VAT (ACC-04)