Data source
SYNTHETIC Synthetic sample data (fictional)
Reporting period: 2026-01-08 → 2026-06-24 · 12 row(s) · amounts in SAR
Sample loaded in this browser: not recorded (load time, not the data’s own update date)
Columns: date (YYYY-MM-DD), customer, project, revenue, cost — plain numbers in SAR, no separators. Quoted fields supported. Excel (.xlsx) import: planned.
Summary
Revenue
SAR 361,000
Recorded costs
SAR 278,400
Gross profit
SAR 82,600
Gross margin
22.9%
Metric definitions & reconciliation
- Revenue = sum of the revenue column for rows in the selected period.
- Recorded costs = sum of the cost column (only costs present in the file).
- Gross profit = Revenue − Recorded costs.
- Gross margin = Gross profit ÷ Revenue; shown as “n/a” when revenue is 0.
- Each row is counted once. Check: project totals SAR 361,000 · customer totals SAR 361,000 · overall SAR 361,000 ✓ match.
Project profitability
| Customer | Project | Rows | Revenue | Cost | Gross profit | Margin | Revenue vs cost |
|---|---|---|---|---|---|---|---|
| Sample Client B | Mobile App MVP | 2 | SAR 105,000 | SAR 91,500 | SAR 13,500 | 12.9% | |
| Sample Client A | Portal Rebuild | 2 | SAR 84,000 | SAR 60,500 | SAR 23,500 | 28.0% | |
| Sample Client D | ERP Integration | 2 | SAR 84,000 | SAR 58,500 | SAR 25,500 | 30.4% | |
| Sample Client C | Data Migration | 2 | SAR 37,000 | SAR 38,700 | SAR -1,700 | -4.6% | |
| Sample Client A | Support Retainer | 2 | SAR 24,000 | SAR 15,900 | SAR 8,100 | 33.8% | |
| Sample Client C | Cloud Setup | 1 | SAR 18,000 | SAR 9,200 | SAR 8,800 | 48.9% | |
| Sample Client B | Maintenance | 1 | SAR 9,000 | SAR 4,100 | SAR 4,900 | 54.4% |
Bars: ■ revenue, ■ cost, both on one shared scale (largest absolute revenue or cost in this table). ■ negative amount, bar length = absolute value.
By customer
| Customer | Rows | Revenue | Cost | Gross profit | Margin | Revenue vs cost |
|---|---|---|---|---|---|---|
| Sample Client B | 3 | SAR 114,000 | SAR 95,600 | SAR 18,400 | 16.1% | |
| Sample Client A | 4 | SAR 108,000 | SAR 76,400 | SAR 31,600 | 29.3% | |
| Sample Client D | 2 | SAR 84,000 | SAR 58,500 | SAR 25,500 | 30.4% | |
| Sample Client C | 3 | SAR 55,000 | SAR 47,900 | SAR 7,100 | 12.9% |
Bars: ■ revenue, ■ cost, both on one shared scale (largest absolute revenue or cost in this table). ■ negative amount, bar length = absolute value.
Insights
Rule-based demo insights — AI integration planned
1 project(s) with negative gross profit
Data Migration (SAR -1,700)
1 project(s) below 20% gross margin
Mobile App MVP (12.9%)
Largest customer by revenue: Sample Client B
31.6% of revenue in the selected period.
Highest-margin project: Maintenance
Gross margin 54.4% on SAR 9,000 revenue.
Actions
Saved in this browser only (localStorage). Shared team workspaces are planned.
No actions yet. Add one above or create one from an insight.