Urgent Items Data Source: 3 from email analysis, 2 from tracker sheets
Trend: 5 total (+2 from yesterday)
Breakdown: 2 contracts, 1 invoice, 2 LPOs
5
Projects At Risk Data Source: Project tracker sheets
Active Projects: 12 total
Risk Factors: 2 overdue approvals, 3 budget variances, 2 delayed milestones
4
Overdue Approvals Data Source: Approval trackers & email follow-ups
By Department: 1 Commercial, 3 Legal, 2 Finance
Aging: Average 3.2 days overdue
6
Issues Resolved Data Source: Completed items in trackers
Trend: +12% vs last week
Resolution Time: Average 2.3 days
12
Next MD Meeting: Today @ 2:30 PM Agenda
Key Project: IBGOB Contract Renewal
Last updated: Today 11:42 AM System: Operational
Company Logo

Commercial Intelligence Dashboard

System Operational +8% 96% Data Coverage Data Sources:
✅ 12/12 Sheet Trackers Connected
✅ Email Integration Active
📊 3,452 Documents Indexed
⚡ 87% AI Analysis Complete

Tuesday, 19 March 2025 Export Report Paterno Dungca (Commercial Manager)

🔴 URGENT / MUST ACTION 4 items from emails, 1 from tracker This section combines critical items identified by AI analysis of emails and high-priority tracker items

3 CRITICAL ITEMS

IBGOB Contract Renewal

CRITICAL
Tracker Status: Legal Review (Deadline: Today EOD)
Latest Email: Final signature blocked by Legal pending review of clause 12.3 (from Sarah @ Legal - 1h ago)
Time remaining 8 hours
Originated: 12-Mar
Personnel: 4 involved 1. Uwais (Commercial)
2. Sarah (Legal)
3. Paterno (Commercial)
4. MD Office

PC#1831 - Bauhaus

HIGH
Tracker Status: Pending Finance Certification (Due: Yesterday)
Latest Email: Contractor threatening penalty for late payment (from Jamzith - 3h ago)
Overdue by 1 day
AED 42,750
Required approvals: 2/4 ✔ Sydney (Commercial)
✔ Jamzith (QS)
□ Marc (Finance)
□ MD Office

Security Cheque #4589

MEDIUM
Tracker Status: Pending MD Signature (Due: Tomorrow)
Latest Email: Required for DEWA contractor bond (from Pradeesh - 1d ago)
Time remaining 34 hours
DEWA Electrical
MD Office Finance

APPROVAL PIPELINE

Updated 15m ago

VAF-BSI-1831 | Bauhaus Furniture

From: Cost Control Tracker

2d
Pending Uwais (Asst. Manager) Submitted: 17-Mar
AED 12,450
2/5 approvals completed
Commercial Legal

PC#1844 | Al Qadar Plumbing

From: Email thread (Jamzith)

4h
Pending Marc (Financial Manager) Submitted: Today 09:42
AED 34,200
3/4 approvals completed
Commercial Finance

Recent Decisions

LPO#123-2023 - Bauhaus furniture
Approved by Uwais (Tracker - 18-Mar)
Approved
Artline Contract - F&B Services
Rejected by Legal (Email - clauses 5.2, 8.4 need revision)
Rejected

PROJECTS OVERVIEW

12 Active

IBGOB Corporate Office

RISK
Project ID: STI-PRJ-056 Commercial Lead: Paterno
Progress: 63%
End: 15-May-2025

Contract renewal pending, structural work 80% complete, awaiting MEP drawings...

35 docs 7 new emails 3 urgent 5 pending

Zen Tower Refurbishment

ON TRACK
Project ID: STI-PRJ-042 Commercial Lead: Uwais
Progress: 82%
End: 30-Apr-2025

Finalizing MEP snag list, awaiting revised drawings from consultant...

28 docs 4 new emails 2 pending

FINANCIAL WATCH

Tracker Data
LPOs Issued
7
+2 this week
Invoices Pending
12
3 overdue
PCs Approved
5
+1 yesterday
Disputed Amount
AED 67,400
12% decrease

Top Payments This Week

Mars Digital Systems
LPO#457-2023 | Cleared today
AED 28,500
Paid
Al Qadar Plumbing
PC#1844 | Pending approval
AED 34,200
Processing
Ayal Nasser Contracting
Invoice #INV-7894 | Due tomorrow
AED 52,100
Urgent

Payment Pipeline: World Island Account Ledger - World Island.csv

Total LPO Value AED 2,456,800
Invoiced Amount AED 1,783,400 (73%)
Certified Payments AED 1,245,600 (70%)
Amount Paid AED 987,300 (79%)

AUTHORITY APPROVALS

Tracker Data
Showing: Key Projects
IBGOB
DEWA Electrical
12-Mar-2025
Zen Tower
DEWA Water
Pending
World Island
BCC
05-Mar-2025
Seven City
DM
Not Started
Ayal Nasser
DEWA
Rejected 10-Mar

Approval Status Legend

Approved
Pending
Rejected
Not Started

RECENT ACTIVITY

Last 24 hours
New email from Legal Dept
"URGENT: IBGOB Contract revisions needed for clauses 5.2, 8.4 before final signature..."
Received 1h ago From: Sarah Al Habsi
Tracker Update
LPO#789-2023 for Project Seven City - Status changed from "Pending Commercial" to "Approved by MD"
Updated 2h ago By: Uwais (Asst. Manager)
New Potential LPO Identified
Email from Paterno with draft LPO for ABC Corp (AED 45,200) - Not yet in tracker
Detected 4h ago Subject: "Draft LPO for ABC Corp"
Reminder from Contractor
"Following up on overdue payment for PC#1831 - Bauhaus Furniture (AED 42,750)"
Received 5h ago From: Jamzith (QS)
Tracker Update
Invoice #INV-2845 for Zen Tower - Status changed to "Paid" with payment date 18-Mar-2025
Updated 7h ago By: Sydney Sarmiento

DOCUMENT CATEGORIES

Last 30 days
+12%
28
Contracts
+5%
45
Invoices
+8%
18
Payment Certificates
-3%
22
LPOs

Top Document Types

28
Contracts
45
Invoices
18
PCs
22
LPOs
12
RFQs

Document Status

42
Approved
28
Pending
35
In Process
9
Rejected
18
Paid
7
Expired