Ziloqa ERP — Dubai Jewellery LLC

October revenue

AED 4.86M

▲ 18% vs September

Invoices

1,318

avg ticket AED 3,688

Gold sold (net)

9.4 kg

+ 214 diamond pieces

Stock value

AED 7.9M

1,462 tagged pieces · today's rate

✦ Ziloqa AI — this morning's read

Revenue — last 12 weeks

Weekly AED · hover for exact figures

Gold jewelleryDiamonds & others

October revenue by branch

Where the AED 4.86M came from

Needs your attention ✦ prioritised by AI

Three things, before anything else

Rate	Unfixed gold with Al Noor Bullion: 2.4 kg with the rate up 2.1% this monthFixing 1 kg today locks ≈ AED 7,100 of gain
Stock	27 pieces have sat over 365 days — AED 610K of capital asleepMelt / rework list drafted by AI — review before Friday
Money	Al Madina Jewellers (wholesale) owe AED 68,400 — now 31–60 daysStatement sent 27 Oct — call Bilal today

Top categories — October

By revenue, all branches

22K Bangles		AED 1.28M
22K Chains		AED 940K
Diamond rings		AED 610K
Necklace sets		AED 585K
Polki & bridal sets		AED 402K
Coins & bars		AED 388K

Connected services

Everything feeding this screen automatically

Gold rate feed — synced 09:00 & 15:30 POS terminals — 3 branches online Tag scanners — 5 online WhatsApp Business — 214 messages today Rate-board screens — all branches ✓ FTA e-invoicing — structured-ready

Invoices — October

1,318

▲ 18% vs September

Average ticket

AED 3,688

▲ sets & bridal mix

Custom orders open

46

AED 512K advances held

Dhanteras — 29 Oct

AED 486K

171 invoices · record day

Invoices per day — October

All branches · the Dhanteras spike on the 29th

Recent invoices & orders

Live from all three branches

Branches reporting

3 of 3

+ workshop online

Sold today

AED 391,240

updating live

Footfall today

1,264

▲ Diwali week

Conversion

23%

tickets ÷ footfall

Feed from the branches

LIVE

POS sales, rate-board updates, old-gold exchanges and transfers, as they happen

POS — live Rate board — auto-push Tag scans — live

Today by branch

Sales · tickets · status

Suggested actions ✦ AI

From each branch's own pattern

Al Barsha22K chains down to 14 pcs — move 18 from Gold Souk before the weekend
Meena BazaarPolki set DJ-PK-0214 unseen 290 days at Gold Souk — rotate to MB bridal wall
Gold SoukFriday footfall peaks 19:30–22:00 — extend counters by one hour

This week by category

AED across all branches

Customers on file

8,412

312 new in October

VIP clients

118

AED 1.02M this month

Scheme members

642

gold savings plan

Wholesale due

AED 68,400

Al Madina · 31–60 days

Top customers — October

Lifetime value and last visit

October revenue by segment

All branches

Coming up

Occasions the system is watching

Nov	34 scheme members mature — AED 412K redemption inflow; appointment calls drafted
This week	4 VIP anniversaries — catalogue & private-viewing invitations queued
27 Oct	Mrs. Kavitha R. — January wedding, bridal budget discussed ≈ AED 120K

Bullion bought — Oct

8.6 kg

AED 2.71M total spend

Old gold taken in

3.1 kg

credited AED 872K

Open POs

2

1 kilobar unfixed

Diamond stones in

14

6.42 ct · certs verified

Purchase orders — October

Bullion fixed at the moment of deal, or held unfixed

Spend by supplier — October

Bullion, stones, findings & packing

Old-gold intake

Weighed, tested, credited — then melted

October intake	3,102 g
Average tested purity	21.2K
Customer credit given	AED 872,400
Melt batch RM-2410-04	3.1 kg · at refinery

Assay expected 2 Nov — fine gold returns to vault

Tagged pieces

1,462

every item barcoded

Gold on hand

22,840 g

branches + workshop

Stock value

AED 7.9M

at today's rate

Aged 365+ days

27 pcs

AED 610K asleep

Tag register — watchlist

Every piece: weight, purity, branch and days on display

Gold by location

Grams on hand, live from tag scans

Gold Souk · Deira		11,240 g
Meena Bazaar · Bur Dubai		6,180 g
Al Barsha		4,420 g
Workshop & vault		1,000 g

Last full tag scan 27 Oct — zero variance

Stock value by age

Capital at work vs capital asleep — over 180 days turns amber

Job orders — Oct

38

bridal season building

Gold issued

6,214 g

to four benches

Gold returned

6,158 g

finished + scrap + dust

Making loss

0.90%

within 1.0% tolerance

Job orders in progress

Every gram issued is signed for and weighed back

Bench gold accounts — October

Issued vs returned, per craftsman

Bench 1 · Ustad Karim	2,140 g → 2,122 g	0.84%
Bench 2 · Anil	1,680 g → 1,664 g	0.95%
Bench 3 · Joseph	1,420 g → 1,407 g	0.92%
Bench 4 · Mahmoud	974 g → 965 g	0.92%

Dust and filings are collected per bench and credited back after refining — nothing leaves the loop.

Weekly gold issued & making loss — October

Columns: grams issued · line: loss %

Gold issued (g)Loss % (right axis)

XRF purity tests — Oct

212

intake · workshop · floor

Hallmark batches

9

1 awaiting return

Certified diamonds

64

100% coverage ≥ 0.30 ct

Failures

1

caught before the floor

Hallmark & release board

Nothing reaches a display tray unmarked

Site & compliance checks

Signed on a tablet, on schedule

Weighing scales calibration	Valid ✓
XRF machine calibration	Due 12 Nov
Vault & CCTV audit	12 Oct ✓
Insurance — stock & transit	Valid to Mar 2025
Trade licence & permits	Current ✓

The one failure

Why the system exists

Bangle pair from melt batch tested 21.6K against a 22K claim — quarantined at the workshop, never tagged, remade from vault gold. Logged as NC-24-011 with the melt batch traced.

Transfers — Oct

26

412 pieces moved

In transit now

1

T-2410-27 · sealed

Discrepancies

0

dual-scan at both ends

Insured per run

AED 2M

secure courier

Transfer log

Sealed bag, two scans, one truth

How a transfer works

The same ritual, every time

1	Tags scanned out by two staff — manifest created, bag sealed with numbered seal
2	Secure courier run — insured, tracked, receiving branch notified
3	Seal verified, every tag scanned in by two staff — any gap alerts instantly

26 of 26 transfers this month reconciled to the last gram

Transfers per week — October

Rebalancing stock to where it sells

Collected — October

AED 4.71M

card 68% · cash 32%

Operating profit

AED 530K

10.9% of revenue

VAT payable

AED 192,500

filing due 28 Nov

Net gold position

Long 11.5 kg

rate-sensitive — see below

October in plain numbers

Management P&L

Sales	AED 4,860,000
Metal & stones cost bullion at fix, diamonds, findings	AED 3,620,000
Making & trading margin	AED 1,240,000 · 25.5%
Overheads staff AED 486K · rents AED 142K · marketing AED 46K · other AED 36K	AED 710,000
Operating profit	AED 530,000 · 10.9%

Cash in vs out — weekly

Gold position ✦ watched by AI

What a one-dirham rate move does

Gold on hand	22,840 g
Unfixed with Al Noor Bullion	+2,400 g
Scheme liability (gold-equivalent)	−8,940 g
Customer orders rate-locked	−4,800 g
Net long position	11,500 g

▲ AED 1 / g ⇒ +AED 11,500 on stock value

VAT — UAE 5%

Retail collected · bullion under reverse charge

Output VAT — retail sales	AED 231,400
Input VAT — expenses	AED 38,900
B2B gold & diamonds	reverse charge — no cash VAT
Payable this period	AED 192,500

✓ Q3 filed 28 Oct · AED 176,200 paid on time

Team

24

3 branches + workshop

October gross pay

AED 486,200

run on 28 Oct ✓

Commission pool

AED 68,400

1.2% over target

Absence

1.2%

▼ best month this year

October payroll — sales floor

WPS SIF file submitted with the run

…and 15 more across the branches and workshop — full register in the People page.

Payroll summary — October

Employer view

Gross pay	AED 486,200
Commission accrued	AED 68,400
WPS SIF file	Submitted ✓
Gratuity provision updated	✓

Coming up

People & rosters

Nov	Wedding-season rosters — Friday late shift at Gold Souk proposed
2–3 Dec	UAE National Day — promo staffing plan drafted
Interviewing	One senior salesperson for Al Barsha — two candidates shortlisted

One-click reports, written in plain English

Every screen in this system has the Simple report button — Ziloqa AI turns the numbers into a one-page summary anyone can read, ready to print, save as PDF or send to WhatsApp. These are the same reports, all in one place.

Ziloqa AI — built into every screen

The assistant, the Simple Reports, the rate-position watch and the forecasts all run on the same engine — reading live business data, never guessing.

AI searchAI reporting Season & demand forecastingDead-stock detection Rate-position advisorDocument vision Anomaly watchTranslation · EN / AR / HI / ML

Today's AI insights

Written this morning from the live figures

Why you can trust it

Guard-rails, not magic

It only reads what the signed-in person is allowed to see — permissions are enforced in the database.

Every answer can show the exact records behind it — invoices, tags, melt batches.

If the data can't support an answer, it says so instead of inventing one.