Executive Overview
Commtel Networks — all figures in PKR · Trial Balance FY 2024-25 ·
As of 30 Jun 2025
Days Sales Outstanding
96.8d
AR ÷ Revenue × 365 · Industry avg 60d
⚠ 61% above benchmark
Working Capital
2.02B
Current Assets − Current Liabilities
✓ Positive working capital
Cash Conversion Cycle
-31.3d
DSO 96.8 + DIO 53.8 − DPO 181.9
✓ Negative = collecting before paying
Gross Profit Margin
36.4%
EBIT PKR 2.11B · EBIT Margin 31.4%
↑ Strong operating leverage
Receivables
Aging report · Invoice wise
Total InvoicedPKR 4.68B
CollectedPKR 3.68B
OutstandingPKR 1.72B
79% collected · AR closing PKR 1.79B
Payables
Vendor obligations · Aging report
Total InvoicedPKR 2.86B
OutstandingPKR 2.14B
Above 365 DaysDPO 181.9 days
Trade Creditors: PKR 2.14B outstanding
Sales
Pipeline · Revenue · Targets
YTD RevenuePKR 6.74B
Annual TargetGross Profit PKR 2.46B
PipelineGP Margin 36.4%
Revenue PKR 6.74B · COGS PKR 4.29B
Revenue
Financial summary · Reference data
Total RevenuePKR 4.00B
Gross ProfitPKR 2.00B
Net ProfitPKR 286M
46% gross margin · reference data, not yet live
Projects
Execution status · Milestones
Active24 projects
On Track17 (71%)
At Risk / Delayed7 (29%)
PKR 2.4B total project value
Banking
Balances · AMG · Facilities
Current BalancesPKR 1.07B
AMG FacilitiesPKR 500M
UtilizedPKR 315M
Net bank balance per Trial Balance
Investments
Portfolio · Returns · Maturity
Portfolio ValuePKR 23M
YTD ReturnFixed Deposit / TDR
Avg. Return RateOn-balance sheet
Code 2008001 · Fixed Deposit closing balance
HR & Workforce
Headcount · Departments · Attrition
Total Employees145
Active142
Attrition Rate2.1%
5 new hires · 3 left/resigned this period
Guarantees
Bank guarantees · Performance securities
Total GuaranteesPKR 419.3M
Valid39
Expired15
72% valid · PKR 186.0M margin blocked
Forecasting
Revenue · Cash flow · Collections
Trailing Avg RevPKR 562M
Weighted PipelinePKR 4.9B
30D Net Cash Flow+PKR 340M
Positive 30-day net cash flow · PKR 1.12B AR predicted
Requires CEO Attention
Monthly Revenue vs Collections (PKR M)
Financial Health Summary
Receivables Aging
Invoice wise aging report · PKR · As of 12 May 2026
Total Invoiced (Open)
—
Collected
—
Outstanding
—
Uninvoiced Amount
—
Ordered but not yet invoiced
Aging Breakdown — of Outstanding
0–30 Days
—
31–60 Days
—
61–180 Days
—
181–365 Days
—
Above 365 Days
—
Top customers — outstanding (PKR M)
Aging distribution
0–30
31–60
61–180
181–365
>365
Collection rate — top 12
Outstanding by bucket (PKR M)
Customer Risk Matrix — Outstanding vs Age (bubble size =
invoice amount)
Top-right quadrant = highest priority for collection
action
Invoice Detail
Sorted: Customer (A→Z)
— invoices
| Customer ↑ | Project | Doc No | Date | Due Days | Invoiced | Received | Outstanding | Bucket |
|---|
Payables
Vendor obligations · Due tracking · PKR
All
0–30 Days
31–60 Days
61–180 Days
181–365 Days
>365 Days
Total Invoiced
—
—
Outstanding — All
—
—
Vendors Affected
—
—
Total Outstanding
—
—
Payables aging
Top vendors by outstanding
Vendor Payables Detail
Sorted: Vendor (A→Z)
— vendors
| Vendor ↑ | Invoices | Total Invoiced | Paid | Outstanding | 61–180 Days | 181–365 Days | Above 365 Days | Worst Bucket |
|---|
Banking
Account balances · AMG facilities · PKR
All
Low Utilization
Medium Utilization
High Utilization
Total Balances
—
—
AMG Facility
—
—
AMG Utilized
—
—
Available
—
—
Balance by bank
AMG utilization
Account Details
Sorted: Bank (A→Z)
— accounts
| Bank ↑ | Account No | Account Type | Balance (PKR) | AMG Limit | AMG Used | Status |
|---|
Investments
Portfolio · Returns · Maturity schedule · PKR
Fixed Deposits (TDR)
23M
On-balance sheet (Code 2008001)
Financial Charges
36.3M
Guarantee + bank charges (FY25)
Guarantee Charges
7.0M
FY2025 (Code 7516004)
Markup on Loans
23.1M
LT loan markup (Code 7516002)
Bank Charges
5.2M
FY2025 (Code 7516010)
Portfolio allocation
Monthly returns (PKR M)
Investment Portfolio Detail
| Instrument | Institution | Type | Start Date | Maturity | Principal (PKR) | Rate % | Accrued Return | Status |
|---|
Sales
Orders · Pipeline · FY 2025-26
Pipeline & Orders
Opportunities
Total Sales
—
—
Total Orders
—
Distinct order count
Avg Order Value
—
PKR per order
Uninvoiced Amount
—
Ordered, not yet invoiced
Open / Pending Orders
—
Status ≠ Completed
Orders Fulfilled %
—
QtyDelivered ÷ QtyOrdered
Monthly Order Value (PKR M)
Orders by Product (Top 10)
Orders by Status
Orders by Customer (Top 10)
Orders by Location
Recent Orders
Sorted: Date Ordered (Most Recent)
| Customer | Project | Document No | Product | Date Ordered ↓ | Value (PKR) | Status |
|---|
Revenue
Financial summary · Reference data from Accounts & Finance
Dashboard (PNL tab) · Jul 2025 – Jun 2026 · not yet fed by live
ERP data
Total Revenue
—
Gross Profit
—
—
Cost of Sales
—
Operating Expenses
—
EBIT
—
Shown as Net Profit in source — true EBIT not available
Net Profit Margin
—
Net Profit ÷ Gross Revenue
Revenue Trend — Modified
Gross Profit Trend
Gross Revenue by Region
Top 10 Revenue Customers
Cost of Sales by Product Categories
Revenue by Solution
Net Profit Trend
Expense Trend
Expense by Category
Projects
Execution status · Milestones · Budget tracking
Active Projects
24
Total active
On Track
17
71% healthy
Delayed / At Risk
7
Needs attention
Total Value
2.4B
PKR combined
Avg Completion
58%
Across all active
Project status breakdown
Projects by value (PKR M)
Project Execution Status
| Project Name | Customer | Type | Value (PKR M) | Start | Deadline | Completion | Status |
|---|
HR & Workforce
Organization headcount and workforce overview
All
Last Month
Last Year
Last 2 Years
Total Employees
—
All-time
Active
—
On payroll
Left / Resigned
—
All
New Hires
—
All
Attrition Rate
—
Left ÷ total
By Department
By Location
By Employee Group
Top Jobs by Headcount
Average Salary by Department
PKR, aggregate only
Roles & Employees
Manage who can log in and what they can see
Employees
| Role |
|---|
Create a New Role
Roles & Permissions
Guarantees
Bank guarantees · Performance securities · Advance payment · As of
12 May 2026
Total Guarantees
—
—
Valid
—
Active instruments
Expired
—
Need renewal review
Total Margin
—
Cash blocked
Performance Sec.
—
Largest category
Advance Payment
—
Advance guarantees
Guarantee amount by type (PKR M)
Valid vs Expired
Guarantee Detail
— guarantees
| Client | Type | Instrument No | Issue Date | Expiry Date | Location | Project | Amount (PKR) | Margin (PKR) | Status |
|---|
Forecasting
Revenue Projections · Cash Flow Forecast · Receivables Collection
Predictions
24M Trailing Avg Rev
PKR 562M
Monthly base trend
↑ +4.2% YoY growth
Weighted Pipeline (Q3/Q4)
PKR 4.9B
Probability-adjusted sales
↑ 8 active opportunities
Upcoming SLA Renewals
PKR 2.05B
Contractual recurring rev
→ 100% historical retention
30-Day Cash Net Flow
+PKR 340M
Est. Inflows minus Outflows
✓ Positive net cash flow
Known Upcoming Payables
PKR 279.2M
Skylink & Vendor firm dues
⚠ Due in next 30 days
Predicted AR Collections
PKR 1.12B
Based on customer days-to-pay
→ Avg collection: 108 days
A. Revenue Forecast — Trailing 24M vs Pipeline & Renewals
(PKR M)
B. Cash Flow Projection — Historical Inflows/Outflows & 6M
Projections
C. Expected Receivables Collection Timeline (PKR M)
Revenue Projections by Segment
Module C: Receivables Collection Forecast
Applies customer historical payment pattern to open invoices
to predict collection dates
5 Predicted Records
| Customer | Doc No | Issue Date | Invoiced (PKR) | Outstanding (PKR) | Hist. Avg Days-to-Pay | Predicted Collection Date | Status / Priority |
|---|
Module A: Upcoming Contract Renewals & Sales Pipeline
| Customer / Opportunity | Type | Segment | Contract Value (PKR M) | Probability | Weighted Value (PKR M) | Target Date | Owner |
|---|