Executive Dashboard
daema3mal / Overview
EGP/USD30.95▲0.12%
EGP/EUR33.40▼0.08%
BRENT$82.40▲1.4%
GOLD$2,318▲0.6%
EGX3027,410▲0.9%
CBE RATE27.25%—
INFLATION28.1%▼0.5%
S&P5005,241▲0.3%
🤖 AI Treasury Intelligence — Executive Brief
Q2 2025 flows across 5 sectors: EGP 1.247B total, clearance 94.7%. FX exposure = 23% of treasury. CBE 27.25% pressures borrowing costs. Recommend NDF hedges on USD and accelerating EGP settlements.
⚠ FX Exposure 23%⚡ CIB 34% Conc.📊 Clearance 94.7%🏭 Poultry Risk💹 CBE 27.25%
Total Payments
1.247B
▲ +12.4% YTD
Cleared
1.181B
▲ Rate 94.7%
Pending
66.3M
▼ 47 TXNs
FX Exposure
287.4M
▼ 23% treasury
Weekly Position
312.8M
▲ WoW +6.2%
Top Bank CIB
34%
EGP 424.4M
Failed TXNs
12
▼ EGP 4.2M
Econ Risk Score
6.8/10
▼ High FX vol
Payment Clearance
94.7%
FX Exposure
23.0%
Bank Dependency
34.0%
Supplier Conc.
41.0%
Liquidity Ratio
78.0%
Treasury Coverage
82.0%
Monthly Payment Trend (EGP M)
Cleared / Pending / Failed
Sector Distribution
By payment volume
Bank Exposure (EGP M)
Currency Exposure
Payment Type Breakdown
All operating units
Payment Activity Heatmap — 52 Weeks
Transaction density by day
Less
More
| ID | Payee | Bank | Sector | Type | CCY | Amount EGP | Status |
|---|---|---|---|---|---|---|---|
| PAY-00412 | Cargill Intl | CIB | Agrofood | To Suppliers | USD | 4,218,000 | ✓ Cleared |
| PAY-00411 | NTRA | Banque Misr | Holding | Tax Payment | EGP | 1,840,000 | ✓ Cleared |
| PAY-00410 | Phibro Animal | HSBC | Animal Nutrition | To Suppliers | EUR | 3,670,000 | ⏳ Pending |
| PAY-00409 | Personnel Bureau | Arab Bank | Poultry | Labor Cost | EGP | 920,000 | ✓ Cleared |
| PAY-00408 | EGAZ | BNP Paribas | Other | Utilities | EGP | 312,000 | ✓ Cleared |
| PAY-00407 | Shareholders | CIB | Holding | Dividends | USD | 12,400,000 | ⏳ Pending |
| PAY-00406 | DSM Nutritional | CitiBank | Animal Nutrition | To Suppliers | EUR | 2,180,000 | ✗ Failed |
| PAY-00405 | Min. of Finance | Banque Misr | Holding | Tax Payment | EGP | 6,300,000 | ✓ Cleared |
Cash Management
Liquidity forecasting, treasury positioning, balance analysis
Net Cash Position
823.4M
▲ +4.1% MoM
Cash Inflow MTD
1.47B
▲ Operating
Cash Outflow MTD
647.2M
▼ Pay+loans
30-Day Forecast
+218M
▲ Positive
Weekly Cash Flow — Inflow vs Outflow
52-week EGP millions
90-Day Liquidity Forecast
Cash by Operating Unit
Banking Analytics
Bank utilization, concentration risk, payment routing efficiency
Bank Concentration
34%
▼ CIB dominant
Active Banks
10
Multi-bank
Avg Processing
1.4 Days
▲ vs 2.1 prior
Failed TXNs
12
▼ EGP 4.2M
Bank Utilization — Full Portfolio
Payment volume EGP millions
Payment Method
Weekly Transaction Volume
Forex Analytics
FX exposure, currency volatility, exchange rate impact
Total FX Exposure
287.4M
▼ USD+EUR
USD Exposure
162.3M
30.95/USD
EUR Exposure
84.7M
33.40/EUR
Other FX
40.4M
AED SAR GBP
EGP Exchange Rate Trends
USD EUR AED — 12 months
Cross-Border Exposure (EGP M)
Currency Risk Matrix
Economic Indicators
Global macro, CBE metrics, inflation and commodities
Egypt Inflation
28.1%
▼ Core CPI YoY
CBE Rate
27.25%
Stable
Brent Crude
$82.40
▲ +1.4%
Gold Spot
$2,318
▲ +0.6%
GDP Growth
3.8%
FY24/25 est
Current Account
-$11.2B
▼ Deficit
Inflation & CBE Rate — 24 Months
Commodity Price Index
🌍 Macro Outlook — AI Economic Brief
CBE rate 27.25% restricts borrowing. EGP stabilized ~30.95/USD. Elevated inflation (28.1%) erodes margins in food-linked sectors. Soy and corn above 5-year averages. IMF disbursements support FX reserves.
⚠ Borrowing Cost 27.25%🌾 Commodity Inflation💰 IMF Supporting EGP
Treasury Analytics
Position management, coverage ratios, credit facilities register
💼 CFO Treasury Brief
Coverage ratio: 82%. CBE 27.25% creates EGP 50.2M annual carry cost. USD debt at SOFR+350 = dual FX+rate risk. Actions: accelerate collections, negotiate EGP fixed-rate tranches, hedge USD via NDF.
⚠ Interest EGP 50.2M/yr💹 USD Dual Risk✅ Coverage 82%
Coverage Ratio
82.0%
Target 85%
Total Debt
185.4M
▼ EGP+USD
Annual Interest
50.2M
▼ CBE env.
Available Lines
214.6M
▲ Undrawn
Net Treasury
+29.2M
▲
Maturity 90d
42.8M
▼ Refinancing
Treasury Position — 12 Month Rolling
Available vs Drawn vs Net
Debt Maturity Profile
EGP M — 8 quarters
Rate Sensitivity ±100bps
| Bank | Type | CCY | Limit | Drawn | Available | Rate | Maturity | Status |
|---|---|---|---|---|---|---|---|---|
| CIB | Revolving | EGP | 80,000,000 | 62,000,000 | 18,000,000 | CBE+2.5% | Dec 2025 | Active |
| HSBC | Term Loan | USD | 50,000,000 | 50,000,000 | 0 | SOFR+3.5% | Jun 2026 | Active |
| Arab Bank | Overdraft | EGP | 30,000,000 | 18,400,000 | 11,600,000 | CBE+3.0% | Renewable | Active |
| BNP Paribas | LC Facility | EUR | 25,000,000 | 14,800,000 | 10,200,000 | EURIBOR+2.8% | Sep 2025 | Review |
| Banque Misr | Term Loan | EGP | 20,000,000 | 20,000,000 | 0 | CBE+2.0% | Mar 2026 | Active |
Supplier Analytics
Concentration, sector dependency, trading partner analysis
Concentration
41.0%
▼ Top-5 risk
Active Suppliers
284
▲ +12 new
Avg Pay Days
22 Days
▲ 91% on-time
Cross-Border
38
▼ 13% volume
Top 10 Suppliers by Payment
EGP millions YTD
Sector Dependency Radar
Payment Analytics
Aging, trend analysis, cross-border breakdown
Cleared
1.181B
▲ 94.7%
Pending
66.3M
▼ 47 TXNs
Failed
4.2M
▼ 12 TXNs
Avg Days O/S
8.4 Days
Pending avg
Payment Status
Weekly Trend
Payment Aging by Sector
AI Financial Insights
Real-time AI-generated treasury, risk, forex and liquidity intelligence
Ask the AI Financial Analyst
COSO Internal Controls
5-component Integrated Framework assessment
Overall Score
74/100
Satisfactory
Control Env.
82/100
▲ Strong
Risk Assessment
70/100
▼ FX gaps
Control Activities
75/100
Pay controls
Info & Comm.
80/100
▲ Quality
Monitoring
65/100
▼ Gaps
COSO Framework Radar
Current vs Target
Fraud Risk Indicators
🚨 Duplicate Supplier Pattern
Supplier #4412 — 3 near-duplicate payments within 48h. Total EGP 2.8M.
⚠ Off-Hours Payments
6 payments processed 11pm–2am. Total EGP 4.1M. Manual review required.
⚠ Bank Account Change
Cargill Intl account updated 2 days before EGP 4.2M payment. Verify directly.
Reports & Export
Generate board-ready reports and schedule automated delivery
Executive Summary
Board-ready briefing — KPIs, AI insights, risk flags
PDFXLSX
Treasury Report
Facilities, coverage, maturity, interest cost
PDFXLSXCSV
COSO Compliance
5-component scoring, fraud flags, control gaps
PDF
FX Risk Report
Currency exposure, sensitivity, hedging recs
PDFXLSX
Generation Status
Click a report card above →
| Report | Frequency | Recipients | Last Run | Next Run | Status |
|---|---|---|---|---|---|
| Executive Summary | Weekly (Mon) | CEO, CFO, Board | May 19, 2025 | May 26, 2025 | Active |
| Treasury Daily | Daily 08:00 | CFO, Treasurer | May 25, 2025 | May 26, 2025 | Active |
| COSO Compliance | Monthly | CCO, Audit Cmte | Apr 30, 2025 | May 31, 2025 | Active |
| FX Risk Report | Bi-weekly | CFO, Risk Team | May 12, 2025 | May 26, 2025 | Pending |
Import Data
Upload Excel or CSV, map columns, validate and import
Drop Excel or CSV file here
or click to browse — supports .xlsx .xls .csv
Column Mapping
Month Column
Amount Column
Status Column
Bank Column
Validation Rules
Check for duplicate Payment IDs
Flag missing currency values
Alert on amounts exceeding threshold
Auto-map unknown sector values
Settings
Platform configuration, themes, roles, security, notifications
Display Preferences
Theme, language and layout
Dark Mode
Arabic Language (RTL)
Compact Sidebar
Currency & Reporting
Default currency and period
Base Currency
Reporting Period
Security & Access
MFA, session, role-based access
Multi-Factor Authentication
Session Timeout 30min
Audit Log Enabled
Notifications
Failed Transaction Alerts
FX Threshold Alerts
Daily Executive Email