Finance Dashboard
Consolidated view — all projects — FY 2024–25
Total Revenue (YTD)
₨ 284.6M
+18.4% vs last FY
Receivables Outstanding
₨ 67.2M
14 overdue
Payables Due
₨ 23.8M
3 critical
Net Profit (YTD)
₨ 51.3M
18.0% margin
Monthly Revenue vs Collections
Invoiced
Collected
Revenue by Project
Gulberg Heights
42% — ₨ 119.5M
DHA Tower
28% — ₨ 79.7M
Bahria Residency
18% — ₨ 51.2M
Eden Heights
12% — ₨ 34.1M
Recent Transactions
| Date | Description | Type | Amount |
|---|---|---|---|
| 15 Mar | Buyer: Ahmed Khan – Installment 3 | Receipt | +₨ 850,000 |
| 14 Mar | Contractor: FastBuild – Progress Bill | Payment | -₨ 2,400,000 |
| 13 Mar | Tenant: Sara Malik – March Rent | Receipt | +₨ 95,000 |
| 12 Mar | WHT Deposited – FBR | Tax | -₨ 340,000 |
| 11 Mar | Investor: Mr. Raza – Q3 Profit | Payment | -₨ 1,200,000 |
Alerts & Required Actions
3 invoices overdue >60 days — ₨ 4.2M at risk
Contractor bill pending approval — FastBuild ₨ 2.4M
Q3 investor profit distribution due 20 Mar
Bank reconciliation gap: HBL main — ₨ 180,000
General Ledger
Account-by-account transaction history with auto-posting logic
Total Debits (MTD)
₨ 38.4M
Total Credits (MTD)
₨ 41.1M
Net Balance
₨ 2.7M
Unposted Entries
4
Needs review
Chart of Accounts — Real Estate Specific
| Code | Account Name | Type | Project | Debit | Credit | Balance | |
|---|---|---|---|---|---|---|---|
| 1000 | ASSETS | ||||||
| 1100 | Cash & Bank | Current Asset | All | 284.6M | — | 284.6M | |
| 1200 | Accounts Receivable – Buyers | Current Asset | All | 67.2M | — | 67.2M | |
| 1210 | AR – Installments Due | Current Asset | All | 52.1M | — | 52.1M | |
| 1220 | AR – Overdue (>30 days) | Current Asset | All | 15.1M | — | 15.1M | |
| 1300 | Security Deposits Held | Current Asset | All | 8.4M | — | 8.4M | |
| 1500 | Work In Progress – Construction | Non-Current | Gulberg Hts | 142.3M | — | 142.3M | |
| 2000 | LIABILITIES | ||||||
| 2100 | Accounts Payable – Contractors | Current Liab. | All | — | 23.8M | 23.8M | |
| 2200 | Advances from Buyers | Current Liab. | All | — | 34.2M | 34.2M | |
| 2300 | Withholding Tax Payable | Tax Liab. | All | — | 4.1M | 4.1M | |
| 3000 | EQUITY & INVESTOR FUNDS | ||||||
| 3100 | Investor Capital – Project-wise | Equity | All | — | 218.5M | 218.5M | |
| 4000 | REVENUE | ||||||
| 4100 | Unit Sales Revenue | Revenue | All | — | 196.4M | 196.4M | |
| 4200 | Rental Income | Revenue | All | — | 42.8M | 42.8M | |
| 4300 | Late Payment Penalties | Revenue | All | — | 2.1M | 2.1M | |
| 5000 | EXPENSES | ||||||
| 5100 | Construction Costs | COGS | All | 161.2M | — | 161.2M | |
| 5200 | Marketing & Sales | OpEx | All | 12.4M | — | 12.4M | |
| 5300 | Admin & Overhead | OpEx | All | 8.9M | — | 8.9M | |
| 5400 | Agent Commissions | OpEx | All | 9.7M | — | 9.7M |
Journal Entries
Manual & auto-posted entries with full audit trail
New Journal Entry
Entry Date
Reference No.
Project
Description
| Account | Debit (₨) | Credit (₨) | Unit | |
|---|---|---|---|---|
Debit Total: ₨ 850,000
Credit Total: ₨ 850,000
✓ Balanced
Auto-Posting Rules
System auto-generates journal entries for these trigger events:
Installment Received
Rent Collected
Expense Approved
Unit Booked / Sold
Penalty Applied
Depreciation Run (Monthly)
Trial Balance
As of 15 March 2025 — All Projects Consolidated
Total Debits
₨ 726.1M
Total Credits
₨ 726.1M
Difference
₨ 0
Status
Balanced ✓
Trial Balance — Detailed View
| Code | Account | Opening Dr | Opening Cr | Period Dr | Period Cr | Closing Dr | Closing Cr |
|---|---|---|---|---|---|---|---|
| ASSETS | |||||||
| 1100 | Cash & Bank | 41.2M | — | 38.4M | 29.6M | 50.0M | — |
| 1200 | Accounts Receivable – Buyers | 72.1M | — | 12.3M | 17.2M | 67.2M | — |
| 1300 | Security Deposits | 7.9M | — | 0.5M | — | 8.4M | — |
| 1500 | WIP – Construction | 128.6M | — | 13.7M | — | 142.3M | — |
| LIABILITIES | |||||||
| 2100 | Accounts Payable – Contractors | — | 19.4M | — | 4.4M | — | 23.8M |
| 2200 | Advances from Buyers | — | 28.7M | — | 5.5M | — | 34.2M |
| 2300 | WHT Payable | — | 3.8M | 0.34M | 0.64M | — | 4.1M |
| REVENUE & EXPENSES | |||||||
| 4100 | Unit Sales Revenue | — | 172.1M | — | 24.3M | — | 196.4M |
| 4200 | Rental Income | — | 38.4M | — | 4.4M | — | 42.8M |
| 5100 | Construction Costs | 144.3M | — | 16.9M | — | 161.2M | — |
| 5200 | Marketing & Sales | 11.1M | — | 1.3M | — | 12.4M | — |
| TOTALS | 405.2M | 262.4M | 83.04M | 83.04M | 441.5M | 284.9M | |
Receivables — Customer Ledger (AR)
Buyer installments, tenant rent, investor returns — unit-wise tracking
Total Outstanding
₨ 67.2M
Current (0–30 days)
₨ 42.1M
Overdue (31–60 days)
₨ 18.4M
Critical (>60 days)
₨ 6.7M
Buyer Installments
Tenant Rent
Investor Returns
Buyer Installment Tracker
| Buyer | Unit | Project | Total Price | Received | Outstanding | Next Due | Status | |
|---|---|---|---|---|---|---|---|---|
| Ahmed Khan | 504 – 5F | Gulberg Hts | ₨ 8.5M | ₨ 5.1M (60%) | ₨ 3.4M | 01 Apr 2025 | On Track | |
| Nadia Aamir | 203 – 2F | DHA Tower | ₨ 12.0M | ₨ 4.8M (40%) | ₨ 7.2M | 15 Mar 2025 | Due Today | |
| Usman Farooq | 801 – 8F | Gulberg Hts | ₨ 9.2M | ₨ 2.76M (30%) | ₨ 6.44M | 28 Feb 2025 | 45 Days Late | |
| Sana Mehmood | 102 – 1F | Eden Heights | ₨ 6.8M | ₨ 6.8M (100%) | ₨ 0 | — | Paid Off | |
| Bilal Chaudhry | 307 – 3F | Bahria Residency | ₨ 7.4M | ₨ 1.48M (20%) | ₨ 5.92M | 20 Mar 2025 | On Track |
Receivables Aging Analysis
Payables (AP)
Vendor bills, contractor payments, expense approvals with multi-level workflow
Total Payable
₨ 23.8M
Pending Approval
₨ 8.4M
5 bills
Due This Week
₨ 4.1M
Overdue
₨ 2.8M
Bills Pending Approval
| Vendor | Project | Amount | Due | Approver | Level | Actions |
|---|---|---|---|---|---|---|
| FastBuild Ltd | Gulberg Hts | ₨ 2.4M | 18 Mar | GM Finance | L2 | |
| ElectroPak | DHA Tower | ₨ 880,000 | 20 Mar | Project Mgr | L1 | |
| Pak Cement Co. | Bahria | ₨ 1.9M | 22 Mar | Director | L3 |
Approval Workflow
1
Bill Created
Site manager enters vendor bill with supporting invoice documents
2
Level 1: PM Review
Project Manager approves bills up to ₨ 500,000
3
Level 2: GM Finance
GM Finance approves ₨ 500K – ₨ 5M; escalates above
4
Level 3: Director
Director approval required for amounts exceeding ₨ 5M
5
Payment Released
Finance posts payment; system auto-generates journal entry
Investor Dashboard
Investment tracking, profit sharing, ROI — per investor per project
Total Capital Raised
₨ 218.5M
Profit Distributed (YTD)
₨ 22.4M
Avg. ROI (Annualized)
18.2%
Above 15% target
Pending Distributions
₨ 5.8M
Q3 payout
MR
Mr. Raza
Investor ID: INV-001 · Joined Jun 2022 · CNIC: 37405-XXXXXXX-X
Total Invested
₨ 25M
Project
Gulberg Heights
Profit Share %
30%
ROI (annualized)
21.4%
| Period | Project Revenue | Mr. Raza Share (30%) | Cost Deduction | Net Profit | Status |
|---|---|---|---|---|---|
| Q1 FY25 | ₨ 48.2M | ₨ 14.46M | ₨ 11.2M | ₨ 3,260,000 | Paid |
| Q2 FY25 | ₨ 52.1M | ₨ 15.63M | ₨ 12.1M | ₨ 3,530,000 | Paid |
| Q3 FY25 | ₨ 61.4M | ₨ 18.42M | ₨ 14.4M | ₨ 4,020,000 | Pending |
Project Financial Summary
Budget vs actual, cost allocation, WIP tracking, project-wise profitability
Gulberg Heights
₨ 119.5M
22% margin
DHA Tower
₨ 79.7M
19% margin
Bahria Residency
₨ 51.2M
11% margin
Eden Heights
₨ 34.1M
16% margin
Gulberg Heights — Budget vs Actual
| Cost Category | Budgeted | Actual | Variance | % Used | Progress |
|---|---|---|---|---|---|
| Construction – Civil Works | ₨ 80M | ₨ 74.2M | +₨ 5.8M saved | 92.8% | |
| Construction – MEP | ₨ 22M | ₨ 18.9M | +₨ 3.1M saved | 85.9% | |
| Marketing & Sales | ₨ 8M | ₨ 9.2M | -₨ 1.2M over | 115% | |
| Admin & Overhead | ₨ 5M | ₨ 4.1M | +₨ 0.9M saved | 82% | |
| Agent Commissions | ₨ 6M | ₨ 5.8M | +₨ 0.2M saved | 96.7% | |
| TOTAL COSTS | ₨ 121M | ₨ 112.2M | +₨ 8.8M under budget | 92.7% |
Total Revenue
₨ 119.5M
Total Costs
₨ 112.2M
Net Profit
₨ 26.3M
Unit Ledger — Gulberg Heights
Each unit treated as a standalone financial entity — click any unit for its ledger
Total Units
60
Sold
28
Rented
14
Vacant / Available
18
Floor Plan View — Click a Unit
Sold
Rented
Vacant
Booked
Floor 5
501
Sold
502
Rented
503
Sold
504
Active
505
Vacant
506
Booked
Floor 4
401
Rented
402
Sold
403
Vacant
404
Rented
405
Sold
406
Booked
Unit 504 — Financial Detail
Sold
Sale Price
₨ 8.5M
Collected
₨ 5.1M
Outstanding
₨ 3.4M
Collection Progress — 60%
| Installment | Due Date | Amount | Status |
|---|---|---|---|
| Booking Amount | Jun 2023 | ₨ 850,000 | Paid |
| Installment 1 | Sep 2023 | ₨ 1,275,000 | Paid |
| Installment 2 | Dec 2023 | ₨ 1,275,000 | Paid |
| Installment 3 | Mar 2024 | ₨ 1,700,000 | Paid |
| Installment 4 | Jun 2024 | ₨ 1,700,000 | Due |
| On Possession | Dec 2025 | ₨ 1,700,000 | Future |
Rent Management
Lease contracts, rent schedules, security deposits, annual escalation
Active Leases
14
Monthly Rent Income
₨ 1.42M
Security Deposits Held
₨ 4.26M
Leases Expiring (90d)
3
Renew soon
Active Leases
| Tenant | Unit | Rent/Mo | Lease Start | Lease End | Escalation | Status |
|---|---|---|---|---|---|---|
| Sara Malik | 301 | ₨ 95,000 | Jan 2024 | Dec 2025 | 10%/yr | Active |
| Tariq Hassan | 406 | ₨ 80,000 | Mar 2024 | Feb 2025 | 8%/yr | Expired |
| Amna Rizvi | 601 | ₨ 120,000 | Jul 2024 | Jun 2026 | 10%/yr | Active |
| Hamid Corp | 102 | ₨ 180,000 | Oct 2023 | Sep 2024 | 12%/yr | Renewal Due |
Rent Schedule — Sara Malik (Unit 301)
Monthly Rent
₨ 95,000
Security Deposit
₨ 285,000
Next Escalation
Jan 2025 (+10%)
| Month | Rent | Collected | WHT (5%) | Net to Company |
|---|---|---|---|---|
| Jan 2025 | ₨ 95,000 | Paid | ₨ 4,750 | ₨ 90,250 |
| Feb 2025 | ₨ 95,000 | Paid | ₨ 4,750 | ₨ 90,250 |
| Mar 2025 | ₨ 95,000 | Paid | ₨ 4,750 | ₨ 90,250 |
| Apr 2025 | ₨ 95,000 | Upcoming | — | — |
WHT auto-deducted at 5% (residential) per FBR Section 155. Deposited to FBR monthly.
Payment Entry
Record receipts from buyers, tenants, investors — auto-posts to GL
New Payment Receipt
Payment Type
Receipt Date
Project
Unit No.
Payer (Buyer / Tenant)
Installment Reference
Amount Received (₨)
Payment Mode
Bank Account
Transaction / Cheque Ref.
Notes / Remarks
AUTO-GENERATED JOURNAL ENTRY PREVIEW
Dr: 1100 – Cash & Bank (HBL ****4821)₨ 1,700,000
Cr: 1210 – AR Installments (Unit 504)₨ 1,700,000
Partial Payment & Edge Case Handling
If amount received is less than installment due → system marks as "Partial" and creates a residual AR line automatically.
1
Full Payment
Installment fully marked Paid. AR line closed. No further action.
2
Partial Payment
Paid portion recorded. Remaining balance auto-carried to new AR line with same due date.
3
Overdue (>30 days)
Penalty auto-calculated at 2% per month on outstanding. New AR line created for penalty amount.
4
Refund / Cancellation
Reverse journal entries posted. Booking cancellation fee deducted as per signed contract terms.
Expense Entry
Project-wise expense recording with WHT computation and approval workflow
New Expense
Expense Date
Expense Category
Project
Vendor / Payee
Gross Amount (₨)
WHT Rate
TAX COMPUTATION
Gross Amount₨ 2,400,000
WHT @ 7% (Section 153)- ₨ 168,000
Net Payable to Vendor₨ 2,232,000
Payment Method
Vendor Invoice No.
Description / Scope
Recent Expense Entries
| Date | Vendor | Category | Amount | WHT | Approval Status |
|---|---|---|---|---|---|
| 14 Mar | FastBuild | Construction | ₨ 2.4M | ₨ 168K | Pending L2 |
| 12 Mar | MediaPak | Marketing | ₨ 340K | ₨ 34K | Approved |
| 10 Mar | ElectroPak | MEP | ₨ 880K | ₨ 88K | Pending L1 |
| 08 Mar | Office Depot | Admin | ₨ 45K | None | Posted |
Bank Reconciliation
Match system records against bank statements — identify and resolve gaps
Bank Balance (HBL)
₨ 48.32M
Book Balance
₨ 48.14M
Unreconciled Gap
₨ 180,000
Unmatched Items
7
Needs attention
Reconciliation — HBL Main A/C — March 2025
Bank Statement
| Date | Description | Amount |
|---|---|---|
| 15 Mar | IBFT – Ahmed Khan | +1,700,000 |
| 14 Mar | CHQ – FastBuild | -2,232,000 |
| 13 Mar | IBFT – Sara Malik | +90,250 |
| 12 Mar | WHT Deposit | -340,000 |
| 11 Mar | IBFT – Unknown | +180,000 |
⇄
System (Book) Records
| Date | Description | Amount | |
|---|---|---|---|
| 15 Mar | JE-0348 – Ahmed Khan | +1,700,000 | ✓ |
| 14 Mar | JE-0341 – FastBuild | -2,232,000 | ✓ |
| 13 Mar | JE-0339 – Sara Malik | +90,250 | ✓ |
| 12 Mar | JE-0336 – WHT FBR | -340,000 | ✓ |
| — | No matching entry found | ₨ 180,000 | ? |
1 unmatched bank credit — ₨ 180,000 on 11 Mar. Create a journal entry to record this, or assign to an existing transaction.
Tax Module — Pakistan (FBR)
Withholding tax, sales tax on services, FBR compliance & challan management
WHT Collected (MTD)
₨ 1.24M
WHT Deposited to FBR
₨ 0.9M
₨ 340K pending
Sales Tax (PST/GST) Due
₨ 680,000
WHT Rate Schedule — FBR 2024–25
| Payment Type | Section | Filer Rate | Non-Filer | Auto-Applied |
|---|---|---|---|---|
| Contractor Payments | 153(1)(a) | 7% | 14% | Yes |
| Services | 153(1)(b) | 10% | 20% | Yes |
| Rent (Commercial) | 155 | 15% | 30% | Yes |
| Rent (Residential) | 155 | 5% | 10% | Yes |
| Property Sale (Capital Gain) | 37 | Slab-based | Slab-based | Manual |
| Commission to Agent | 233 | 12% | 15% | Yes |
Monthly WHT Challan Register
| Month | Collected | Deposited | Due Date | Status |
|---|---|---|---|---|
| Jan 2025 | ₨ 892,000 | ₨ 892,000 | 15 Feb 2025 | Filed |
| Feb 2025 | ₨ 1,041,000 | ₨ 1,041,000 | 15 Mar 2025 | Filed |
| Mar 2025 | ₨ 1,240,000 | ₨ 900,000 | 15 Apr 2025 | Partial — ₨ 340K pending |
Commission Management
Agent / reseller deal-based commission tracking with staged payouts
Total Commission Earned
₨ 9.7M
Paid Out
₨ 7.2M
Pending Payout
₨ 2.5M
Active Agents
18
Commission Ledger
| Agent | Unit | Sale Price | Rate | Commission | WHT 12% | Net Payable | Status |
|---|---|---|---|---|---|---|---|
| Zain Properties | 504 – Gulberg | ₨ 8.5M | 2.5% | ₨ 212,500 | ₨ 25,500 | ₨ 187,000 | Paid |
| Bright Realty | 801 – Gulberg | ₨ 9.2M | 2.5% | ₨ 230,000 | ₨ 27,600 | ₨ 202,400 | Pending |
| Prime Homes | 307 – Bahria | ₨ 7.4M | 3.0% | ₨ 222,000 | ₨ 26,640 | ₨ 195,360 | Pending |
| Zain Properties | 203 – DHA | ₨ 12.0M | 2.0% | ₨ 240,000 | ₨ 28,800 | ₨ 211,200 | On Closing |
Commission Payout Rules
1
On Booking (50% of commission)
Half commission released when booking is confirmed and booking amount received from buyer
2
On 40% Collection (30%)
Next 30% released when buyer has paid 40% of total sale price
3
On Unit Possession (20%)
Final 20% released at unit handover to buyer
WHT Deduction: 12% WHT (Section 233) deducted at source from each payout. WHT certificate issued. Deposited monthly to FBR.
Audit & Controls
Role-based access control, approval workflows, immutable audit logs
Role Permissions Matrix
| Module | Data Entry | PM | GM Finance | Director | Auditor |
|---|---|---|---|---|---|
| Payment Entry | Create | Approve L1 | Approve L2 | Full | Read Only |
| Journal Entries | — | — | Post | Full | Read Only |
| Chart of Accounts | — | — | — | Full | Read Only |
| Investor Returns | — | — | Prepare | Approve & Pay | Read Only |
| Payables / AP | Create | Approve L1 | Approve L2 | Full | Read Only |
| WHT / Tax | — | — | File Challan | Full | Read Only |
| Reports | Own Project | Own Project | All Projects | Full | Full |
Live Audit Log
| Timestamp | User | Action | Record | IP |
|---|---|---|---|---|
| 15 Mar 14:22 | ali.khan | Posted | JE-0348 | 192.168.1.x |
| 15 Mar 14:18 | sara.gm | Approved | AP-Bill-082 | 192.168.1.x |
| 14 Mar 11:05 | data.entry1 | Created | AP-Bill-082 | 10.0.0.14 |
| 14 Mar 09:40 | director.r | Exported | Trial Balance Mar | 10.0.0.2 |
| 13 Mar 16:55 | ali.khan | Attempted Delete | JE-0330 | 192.168.1.x |
| 13 Mar 16:55 | System | BLOCKED | JE-0330 – deletion denied | — |
Attempted deletion of posted entry JE-0330 was automatically blocked. System policy: posted entries are immutable. Only journal reversals are permitted.