Financial Management
Admin User
Super Administrator
Financial Overview
Budget Allocation
Expense Tracking
Vendor Payments
Client Billing
Financial Overview
₹ 85.75L
Total Income
₹ 62.34L
Total Expenses
₹ 23.41L
Net Profit
27.3%
Profit Margin
Profit & Loss Statement (October 2023)
Project Revenue:
₹ 72,50,000
Other Income:
₹ 13,25,000
Total Income:
₹ 85,75,000
Material Costs:
₹ 38,45,000
Labor Costs:
₹ 12,75,000
Equipment Costs:
₹ 5,20,000
Overhead Expenses:
₹ 5,94,000
Total Expenses:
₹ 62,34,000
Net Profit:
₹ 23,41,000
Balance Sheet (As of 31 October 2023)
Assets
Current Assets:
₹ 45,67,000
Fixed Assets:
₹ 28,45,000
Other Assets:
₹ 12,30,000
Total Assets:
₹ 86,42,000
Liabilities & Equity
Current Liabilities:
₹ 32,15,000
Long-term Liabilities:
₹ 25,50,000
Owner's Equity:
₹ 28,77,000
Total Liabilities & Equity:
₹ 86,42,000
Budget Allocation Per Project
Residential Tower A - Budget Overview
On Budget
Total Budget:
₹ 5,80,00,000
Budget Used:
₹ 3,45,75,000
Budget Remaining:
₹ 2,34,25,000
Percentage Used:
59.6%
Budget Breakdown
| Category | Allocated Budget | Actual Spent | Remaining | % Used | Status |
|---|---|---|---|---|---|
| Site Preparation | ₹ 25,00,000 | ₹ 22,50,000 | ₹ 2,50,000 | 90% | Over Budget |
| Foundation | ₹ 85,00,000 | ₹ 78,25,000 | ₹ 6,75,000 | 92% | Over Budget |
| Structure | ₹ 2,45,00,000 | ₹ 1,38,50,000 | ₹ 1,06,50,000 | 56.5% | On Track |
| Finishing | ₹ 1,85,00,000 | ₹ 78,25,000 | ₹ 1,06,75,000 | 42.3% | On Track |
| MEP Services | ₹ 40,00,000 | ₹ 28,25,000 | ₹ 11,75,000 | 70.6% | On Track |
Budget Utilization
Expense Tracking
₹ 62.34L
Total Expenses
₹ 38.45L
Material Costs
₹ 12.75L
Labor Costs
₹ 5.20L
Equipment Costs
Expense Details
| Date | Project | Category | Description | Vendor | Amount (₹) | Status | Actions |
|---|---|---|---|---|---|---|---|
| 25-10-2023 | Residential Tower A | Materials | Cement Purchase | ABC Cement Co. | ₹ 2,45,000 | Paid | |
| 24-10-2023 | Commercial Complex B | Labor | October Wages | XYZ Contractors | ₹ 4,75,000 | Pending | |
| 22-10-2023 | Hospital Building C | Equipment | Crane Rental | Equipment Rentals Ltd. | ₹ 1,25,000 | Paid | |
| 20-10-2023 | Residential Tower A | Subcontractor | Electrical Work | Prime Electricians | ₹ 3,20,000 | Approved | |
| 18-10-2023 | All Projects | Overhead | Office Rent | Property Management | ₹ 85,000 | Paid |
Vendor Payments
₹ 42.75L
Total Payables
₹ 18.50L
Pending Approval
₹ 24.25L
Approved for Payment
₹ 7.35L
Overdue Payments
Vendor Invoices
| Invoice # | Vendor | Project | Invoice Date | Due Date | Amount (₹) | Status | Actions |
|---|---|---|---|---|---|---|---|
| INV-2023-10567 | ABC Cement Co. | Residential Tower A | 20-10-2023 | 30-10-2023 | ₹ 2,45,000 | Paid | |
| INV-2023-10568 | XYZ Steel Ltd. | Commercial Complex B | 22-10-2023 | 01-11-2023 | ₹ 3,85,000 | Approved | |
| INV-2023-10569 | Prime Electricians | Hospital Building C | 15-10-2023 | 25-10-2023 | ₹ 1,75,000 | Overdue | |
| INV-2023-10570 | Equipment Rentals Ltd. | Residential Tower A | 18-10-2023 | 28-10-2023 | ₹ 1,25,000 | Pending |
Client Billing/Invoicing
₹ 85.75L
Total Invoiced
₹ 62.40L
Paid Invoices
₹ 15.25L
Pending Payment
₹ 8.10L
Overdue Invoices
Client Invoices
| Invoice # | Client | Project | Invoice Date | Due Date | Amount (₹) | Status | Actions |
|---|---|---|---|---|---|---|---|
| INV-2023-20567 | ABC Infrastructure Ltd. | Residential Tower A | 05-10-2023 | 15-10-2023 | ₹ 25,50,000 | Paid | |
| INV-2023-20568 | XYZ Developers | Commercial Complex B | 10-10-2023 | 20-10-2023 | ₹ 18,75,000 | Paid | |
| INV-2023-20569 | National Housing Authority | Hospital Building C | 15-10-2023 | 25-10-2023 | ₹ 32,50,000 | Overdue | |
| INV-2023-20570 | ABC Infrastructure Ltd. | Residential Tower A | 25-10-2023 | 04-11-2023 | ₹ 9,00,000 | Pending |