Gateway of accounts

Al Rayyan Optical Group

Five branches in Doha. Books are posted automatically from the Optical CRM feed — sales orders, prescriptions, inventory movement and appointments become double entries without manual vouchers.

Period FY 2026 · YTD Jan–Aug

{{ col.title }}

Optical CRM feed

LIVE

{{ s.k }}

Endpoints

Needs attention

Trading position

Dashboard · {{ scopeLabel }} i

{{ k.label }}

{{ k.delta }} vs {{ k.cmpLabel }}

Revenue by month · QR ’000

2026 {{ cmpSeriesLabel }}

Gross margin % 56.8% → 59.1%

Revenue mix by product type

Mapped from productType on each sales order line

Appointment → sale funnelPlus 6,590 walk-in orders with no prior appointment

{{ f.src }}

Settlement mix

Each paymentType posts to its mapped ledger

→ {{ t.acc }}

Branch league

Branch	Revenue	GM%	Contr%
{{ r.name }}	{{ r.rev }}	{{ r.gp }}	{{ r.cpc }}

Existing screen

This screen ships unchanged from the current build. Only two things change for the optical client: the ledger it reads is fed by the Optical CRM sync instead of manual vouchers, and Indian GST fields are replaced by Qatar VAT at 5% with a January–December fiscal year.

Finance analytics · {{ scopeLabel }} i

Benchmark column: {{ benchLabel }}

{{ h.label }}

bench {{ h.bench }}

Revenue to net profit bridgeYTD Jan–Aug 2026 · bar length is share of net revenue

Budget vs actualYTD · QR ’000

Line	Budget	Actual	Var
{{ r.k }}	{{ r.b }}	{{ r.a }}	{{ r.v }}

Growth quality

Where to look

Ratio pack — August 202621 ratios · balance-sheet ratios at 31 Aug 2026, flow ratios for the month

Marker: centre = benchmark

Ratio	Definition	Aug 2026	{{ cmpColLabel }}	Δ	{{ benchLabel }}	Position	Verdict
{{ fam.title }}
{{ r.name }}	{{ r.formula }}	{{ r.cur }}	{{ r.cmp }}	{{ r.delta }}	{{ r.bench }}		{{ r.vLabel }}

DuPont decomposition of return on equityYTD annualised · shows whether return comes from margin, efficiency or leverage

{{ p.k }}

Return on equity

56.9%

peer 32.0%

Return is driven by margin, not leverage — net margin is 6.6 points above peer while gearing sits 8.8 points below it. Asset turnover is the one weak leg: 1.88× against a 1.95× peer, and the gap is entirely inventory.

Cash conversion cycle103.9 days · 26.9 days worse than peer

{{ c.v }}

{{ c.k }} peer {{ c.bench }} {{ c.v }}

Clearing the 1,842 frames held past 270 days would release roughly QR 968k and pull the cycle down to about 84 days.

Break-evenMonthly · contribution margin 58.0%

QR 0break-even QR 1,742kactual QR 2,570k

Gross profit by product type

COGS posted at weighted average cost from inventory_details

Product type	Revenue	COGS	Gross profit	GM%	Share of GP
{{ g.k }}	{{ g.rev }}	{{ g.cogs }}	{{ g.gp }}	{{ g.gm }}	{{ g.share }}

Discount & loyalty leakageQR 1,901,800 given away — 9.4% of gross retail value

Optometrist performance

Joined on doctorName from the prescription feed and salesPerson on the order

Optometrist	Branch	Exams	Rx	Conv%	Revenue	AOV	Attach
{{ o.n }}	{{ o.s }}	{{ o.ex }}	{{ o.rx }}	{{ o.cp }}	{{ o.rev }}	{{ o.aov }}	{{ o.at }}

Attach ratesBar shows actual, notch shows target

Recall & repeat cycle24-month replacement window from last dispensed order

Cash flow — YTD Jan–Aug 2026Indirect method, from posted journals

{{ c.v }}

Closing cash & bank QR 2,145,800

Receivables ageingQR 1,982,400 · 68% sits with insurance schemes

Payables ageingQR 2,410,600 · 76.5 days, 14 days slower than peer

Working capital tied up

Cash commitments — next 60 days

Branch unit economicsDirect costs only · central marketing and admin of QR 1,007,290 sit above contribution

Click a row to scope the whole app to that branch

Branch	Revenue	GM%	Rent	Payroll	Contribution	Contr%	Orders	AOV	Conv%	LFL
{{ r.name }} {{ r.code }}	{{ r.rev }}	{{ r.gp }}	{{ r.rent }}	{{ r.pay }}	{{ r.contr }}	{{ r.cpc }}	{{ r.orders }}	{{ r.aov }}	{{ r.conv }}	{{ r.lfl }}
Group	{{ groupRev }}	58.0%	{{ groupRent }}	{{ groupPay }}	{{ groupContr }}	27.6%	13,830	QR 1,319	41.0%	+9.8%

Revenue against contributionLandmark Mall carries the third-largest revenue on the weakest contribution

Slow-moving stock1,842 units held past 270 days · QR 968,400 · the single biggest drag on the cash cycle

19.9% OF FRAME STOCK

Code	Description	Branch	Units	Value	Days held
{{ s.c }}	{{ s.d }}	{{ s.s }}	{{ s.u }}	{{ s.v }}	{{ s.day }}

Sync console

Optical CRM feed i

Next run 04:42

{{ k.label }}

Connection

MODE: LIVE

Token is sha256(customerNumber + apiKey), rotated nightly. Paging runs at 500 records per request with an incremental offset held per endpoint.

Run log

Time	Endpoint	Scope	Records	Journals	Duration	Status
{{ r.t }}	{{ r.e }}	{{ r.s }}	{{ r.rec }}	{{ r.jv }}	{{ r.dur }}	{{ r.st }}

Exception queue{{ excCount }} open · blockers hold the record out of the ledger until resolved

{{ x.id }}

{{ x.kind }}

Mapping studio