11
Active Projects
↑ 12%
9
Open Tenders
↑ 5%
5
Awarded Tenders
↑ 8%
2
Lost Tenders
↓ 3%
12
Orders in Hand
↑ 18%
4
Pending Quotations
— 2%
9
Sales Opportunities
↑ 15%
2
Overdue Tasks
🔴 Critical
2
Pending Approvals
— Waiting
BD 8.49M
Revenue Forecast (Annual)
↑ 22%
📊 Tender Pipeline
🏗️ Project Status
💰 Revenue vs Collections
📦 Orders by Department
💰 Financial Risks
👤 HR Risks
⚙️ Operational Risks
📈 Business Risks
9
Open Tenders
8
Submitted
5
Awarded
2
Lost
📋 Tender Register
| Tender No | Title | Client | Dept | Value (BD) | Deadline | Status | Win Prob |
|---|
12
Total Orders
BD 1.24M
Total Order Value
7
Pending Delivery
3
Completed This Month
📦 Orders in Hand
| Order ID | Customer | Dept | Description | Value (BD) | Order Date | Delivery Date | Status | Salesperson |
|---|
11
Active Projects
4
Completed
3
Delayed
BD 4.2M
Total Project Value
🏗️ Project Register
| Status | Project | Client | Dept | Value (BD) | Start | End | Progress | Manager |
|---|
8
Strategic Projects
5
In Progress
2
Delayed
BD 680K
Total Budget
🎯 Strategic Project Overview
| Status | Project | Owner | Dept | Budget (BD) | Target Date | Progress | Priority | Remarks |
|---|
BD 2.84M
Total Receivables
🔴 Action Needed
BD 1.12M
Total Payables
↑ 8%
BD 940K
Outstanding Balances
BD 420K
Monthly Revenue
↑ 12%
BD 310K
Monthly Collections
BD 280K
Monthly Expenses
BD 140K
Net Cash Flow
↑ Positive
BD 1.87M
Total Bank Balance
BD 1.54M
Available Cash Position
📊 Revenue vs Collections vs Expenses
🔴 Receivables Aging
BD 480K
Current
BD 220K
Due Soon
BD 160K
30 Days Overdue
BD 95K
60 Days Overdue
BD 54K
90 Days Overdue
🔴 Alert
BD 31K
Critical
Immediate Action
🏢 Top 10 Outstanding Customers
🔴 Outstanding Receivables Register
| Customer | Code | Dept | Invoice No | Invoice Date | Due Date | Amount (BD) | Days | Salesperson | Status | Remarks |
|---|
BD 1.87M
Total Bank Balance
Healthy
BD 1.54M
Available Funds
BD 310K
Expected Collections
BD 180K
Upcoming Payments
BD 1.67M
Net Cash Position
🏦 Bank Accounts
📈 Weekly Cash Trend
🏦 Balance by Bank
🏦 Bank Accounts Register
| Bank Name | Account No | Account Type | Current Balance (BD) | Available Balance (BD) | Last Updated |
|---|
⚡ Next 7 Days
Receivable Collections+BD 85K
Supplier Payments-BD 42K
Payroll-BD 28K
Project Expenses-BD 15K
Other Commitments-BD 8K
Net Cash Flow+BD -8K
Projected BalanceBD 1.86M
📅 Next 30 Days
Receivable Collections+BD 310K
Supplier Payments-BD 168K
Payroll-BD 112K
Project Expenses-BD 60K
Other Commitments-BD 32K
Net Cash Flow-BD 62K
Projected BalanceBD 1.81M
📆 Next 90 Days
Receivable Collections+BD 920K
Supplier Payments-BD 504K
Payroll-BD 336K
Project Expenses-BD 180K
Other Commitments-BD 96K
Net Cash Flow-BD 196K
Projected BalanceBD 1.67M
📈 90-Day Cash Flow Projection
248
Total Employees
231
Active Employees
6
Vacancies
🔴 Action Needed
11
On Leave
4
New Hires (Month)
2
Resignations
3
Recruitment Requests
👥 Headcount by Department
🔍 Vacancy Status
3
Open
2
Interviewing
1
Offer Sent
4
Filled (This Month)
1
On Hold
🔍 Vacancy Register
| ID | Position | Dept | Location | Required Date | Priority | Status | Hiring Manager | Recruiter | Remarks |
|---|
3
Fully Staffed Depts
3
Resource Shortage
1
Critical Shortage
14
Total Gap
🏢 Workforce Planning — Resource Gap Analysis
| Status | Department | Current Staff | Required | Vacancies | Gap | Fill % |
|---|
24
Total Tasks
11
In Progress
2
Overdue
11
Completed
☑️ Tasks & Reminders
| Task | Assignee | Dept | Due Date | Priority | Status |
|---|
3
Pending Approval
12
Approved This Month
2
Rejected
| Request | Requested By | Dept | Amount (BD) | Date | Status | Action |
|---|
62%
Win Rate
↑ 4%
38%
Loss Rate
↑ 2%
BD 3.2M
Value Won YTD
5
Awarded Tenders
Win vs Loss by Department
Win Rate Trend
9
Active Opportunities
BD 2.1M
Pipeline Value
| Customer | Opportunity | Dept | Value (BD) | Stage | Probability | Owner |
|---|
4
Pending Quotations
18
Approved This Month
BD 850K
Quotation Value
| Quotation No | Customer | Dept | Amount (BD) | Date | Valid Until | Status |
|---|
142
Total Accounts
24
Key Accounts
38
Active Contacts
| Company | Contact | Dept | Total Business (BD) | Last Activity | Stage | Owner |
|---|
1,842
SKUs in Stock
23
Low Stock Alerts
BD 4.2M
Inventory Value
📦 Inventory management module — connect Google Sheets to populate live data.
14
Open POs
BD 620K
PO Value
🛒 Procurement module — connect Google Sheets to populate live data.
🤝 Customer management module — connect Google Sheets to populate live data.
🔎 Competitor intelligence module — connect data sources to populate.
📁 Document management module — connect Google Drive to populate.
📑 Reports & Analytics — connect Google Sheets to generate reports.
🌟 Employee Performance module — connect HR Google Sheets to populate.
📋 Tenders closing this week?
🏦 Bank position?
🔴 Overdue customers?
🔍 Open vacancies?
⚠️ Critical projects?
🚨 All alerts?
⚙️ System Administration