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,020.0M
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,110.0M · EBIT Margin 31.4%
↑ Strong operating leverage
Receivables
Aging report · Invoice wise
Total InvoicedPKR 4,680.0M
CollectedPKR 3,680.0M
OutstandingPKR 1,720.0M
79% collected · AR closing PKR 1,790.0M
Payables
Vendor obligations · Aging report
Total InvoicedPKR 2,860.0M
OutstandingPKR 2,140.0M
Above 365 DaysDPO 181.9 days
Trade Creditors: PKR 2,140.0M outstanding
Sales
Pipeline · Revenue · Targets
YTD RevenuePKR 6,740.0M
Annual TargetGross Profit PKR 2,460.0M
PipelineGP Margin 36.4%
Revenue PKR 6,740.0M · COGS PKR 4,290.0M
Revenue
Financial summary · Reference data
Total RevenuePKR 4,000.0M
Gross ProfitPKR 2,000.0M
Net ProfitPKR 286.0M
46% gross margin · reference data, not yet live
Projects
Execution status · Milestones
Active24 projects
On Track17 (71%)
At Risk / Delayed7 (29%)
PKR 2,400.0M total project value
Banking
Balances · AMG · Facilities
Current BalancesPKR 1,070.0M
AMG FacilitiesPKR 500.0M
UtilizedPKR 315.0M
Net bank balance per Trial Balance
Investments
Portfolio · Returns · Maturity
Portfolio ValuePKR 23.0M
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 562.0M
Weighted PipelinePKR 4,900.0M
30D Net Cash Flow+PKR 340.0M
Positive 30-day net cash flow · PKR 1,120.0M AR predicted
Requires CEO Attention
Monthly Revenue vs Collections (PKR M)
Financial Health Summary
Receivables Aging
Invoice wise aging report · PKR · As of
All
0–30 Days
31–90 Days
91–180 Days
181–365 Days
>365 Days
Total Invoiced (Open)
—
Collected
—
Outstanding
—
Uninvoiced Amount
—
Ordered but not yet invoiced
Aging Breakdown — of Outstanding
Not Yet Due
—
0–30 Days
—
31–90 Days
—
91–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
Total Outstanding: —
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
Total Outstanding: —
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
0–30 Days
31–90 Days
91–180 Days
181–365 Days
>365 Days
📊 Cash Status Summary
Date range and aging pills filter the
Unreconciled Payments
section below. Account balances are a live snapshot and always
show in full.
Total Balances
—
—
AMG Facility
—
—
AMG Utilized
—
—
Available
—
—
Balance by bank
AMG utilization
Account Details
Total Balance: —
Sorted: Bank (A→Z)
— accounts
| Bank ↑ | Account No | Balance (PKR) | AMG Limit | AMG Used | Status |
|---|
Unreconciled Payments
Receipts and payments not yet reconciled against the bank ·
filtered by the date range and aging pills at the top of the page
Receipts In
—
—
Payments Out
—
—
Net Unreconciled
—
—
Entries
—
—
Unreconciled by age (PKR M) — click a bar to filter
Unreconciled by bank (Top 10, PKR M)
Unreconciled Entries
Total Amount: —
Sorted: Date (Newest first)
— entries
| Date ↓ | Party | Document No | Bank | Type | Days | Amount (PKR) | Age |
|---|
Investments
Portfolio · Returns · Maturity schedule · PKR
Fixed Deposits (TDR)
23.0M
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
Total Principal: —
Unsorted
— instruments
| 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)
Business Type Breakdown
Hardware Sales
—
Awaiting Product Type field
Recurring / Renewal Business
—
Awaiting Product Type + Contract Term fields
Services Business
—
Awaiting Product Type field
Contract Term Distribution (5 Yrs)
Awaiting Contract Term field from DB team
Business Type Trend (Monthly)
Awaiting Product Type field from DB team
Orders by Status
Orders by Customer (Top 10)
Orders by Location
Recent Orders
Total Value: —
Sorted: Date Ordered (Most Recent)
| Customer | Project | Document No | Product | Location | Date Ordered ↓ | Value (PKR) | Status |
|---|
Revenue
Profit & loss · Live ERP data (IDL_BI_PNL_Detail_V) · PKR
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
Gross Profit Trend
Gross Revenue by Region
Top 10 Revenue Customers
Cost of Sales by Account
Revenue by Solution
Net Profit Trend
Expense Trend
Expense by Category
Cash Flow
Projection, scenarios & runway · PKR ·
Placeholder data — awaiting real AR/AP transaction feed
Filters
—Scopes everything below — projection and scenario tiles narrow together.
Scenario comparison — 2-week ending balance
Projection
—
AR — invoiced
AR — uninvoiced
(planned)
AP — invoiced
AP — uninvoiced
(reconstructed)
Cumulative
balance
Below cash
floor
Waterfall — how we get to the ending balance
Opening balance, current scenario & window, in scope
Scenario range — 2 weeks
Best-to-worst spread against the cash floor, in scope
Stream contribution — next periods
base case, net of APSame expected cash dates, split by stream — this is where "segment first, then aggregate" shows up in the combined view.
Project /
Milestone
Managed Services
(MRR)
License /
Hardware
Suggested actions
auto-generated from scope + assumptionsRead against the current filters and the scenario assumptions above — narrow the scope to check a specific owner, tier, or project.
Upcoming maturities
Next 6 weeks, largest first, in scope
| Date | Side | Project | Owner | Amount |
|---|
Exceptions
Floor breach, repeat slippage, stale entries, open disputes
| Type | Detail | Owner |
|---|
Forecast accuracy by owner
illustrative — click a row to filter by ownerA proxy accuracy score derived from overdue rate, dispute load and recorded slippage on each owner's AR book — click any row to scope the whole page to that owner, same mechanism as the Owner filter above.
| Owner | AR items | Overdue rate | Avg. slippage | Accuracy |
|---|
Projects
Execution status · Milestones · Budget tracking
Active Projects
—
Status ≠ Closed
On Track
—
Active, not flagged at risk
Delayed / At Risk
—
Active, flagged at risk
Total Value
—
PKR combined
Avg Completion
—
Across all active
Total Projects
—
All projects
Total Revenue
—
Sum across all projects
Total P/L
—
Revenue minus cost & expense
Avg Completion
—
Across all active tasks
Milestones Completed
—
Completed / Total (all tasks in group closed)
Project Status Breakdown
Projects by Revenue (Top 10)
Milestone Status
Task Status
Project Execution Status
Total Revenue: —
Sorted: Revenue (High→Low)
| Project Name | Customer | Type | Revenue (PKR) ↓ | Start | End Date | Completion | Status |
|---|
HR & Workforce
Organization headcount and workforce overview
All
Last Week
Last 30 Days
Last Month
Last Year
Last 2 Years
Total Employees
—
All-time
Active
—
On payroll
Left / Resigned
—
All
New Hires
—
All
Attrition Rate
—
Left ÷ total
PF Enrollment Rate
—
Active employees enrolled
Employees Enrolled in PF
—
Count, active only
Total PF Balance
—
Awaiting DB team field
Pending PF Contributions
—
Awaiting DB team field
By Department
By Location
By Employee Group
Top Jobs by Headcount
Average Salary by Department
PKR, aggregate only
Monthly Cost by Department
Awaiting historical monthly payroll data from DB team
Monthly Cost by Location
Awaiting historical monthly payroll data from DB team
Monthly Cost by Employee Group
Awaiting historical monthly payroll data from DB team
Medical Pay (Monthly)
Awaiting Medical Allowance field from DB team
Roles & Employees
Manage who can log in and what they can see
Team Presence — 0 Online
Activity Logs
| User | Action | IP Address | Time |
|---|
Data Refresh
Employees
| Role |
|---|
Create a New Role
Cash Status Summary — Edit Access
Anyone with Banking access can view the Cash Status Summary. Only people listed here can edit it — independent of their role.
| Added |
|---|
Roles & Permissions
Password Reset Email Settings
Controls which email account sends password reset codes to employees. Changes take effect on the next email sent — no restart needed.
Guarantees
Bank guarantees · Performance securities · Advance payment · As of
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
Guarantees by Bank (PKR M)
Top 10 Clients by Guarantee Amount (PKR M)
Guarantee Detail
Total: —
Sorted: Client (A→Z)
— guarantees
| Client ↑ | Type | Instrument No | Issue Date | Expiry Date | Location | Project | Bank | Amount (PKR) | Margin (PKR) | Status |
|---|
Forecasting
Revenue Projections · Cash Flow Forecast · Receivables Collection
Predictions
24M Trailing Avg Rev
PKR 562.0M
Monthly base trend
↑ +4.2% YoY growth
Weighted Pipeline (Q3/Q4)
PKR 4,900.0M
Probability-adjusted sales
↑ 8 active opportunities
Upcoming SLA Renewals
PKR 2,050.0M
Contractual recurring rev
→ 100% historical retention
30-Day Cash Net Flow
+PKR 340.0M
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,120.0M
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 |
|---|
Ask AI Assistant
Ask about headcount, sales pipeline, revenue, receivables, payables, guarantees, or projects.