Contact person: Business Client

Phone:Show

Email:Show

Location: Cairo, Egypt

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Real Estate Management System – Software Requirements Document (Updated)
1. Project Overview

Company: AL Masriya for Housing and Touristic Development
Scope: Develop a professional, centralized web-based internal system for managing all real estate operations, including sales, clients, contracts, payments, maintenance, handover, cancellations, and marketing companies/commissions.
Users: Single primary user (company operations manager).

Objectives:

Centralize all data of projects, units, and clients.

Automate calculations for payments, maintenance, resale commissions, and marketing commissions.

Generate contracts, reports, and official documents (PDF/Excel) automatically.

Enable tracking of all financials, unit status, and project progress in real-time.

2. System Requirements
2.1 Dashboard

Centralized dashboard showing:

Projects overview: total sales, available units, sold units, delivered units.

Upcoming payments, maintenance, and marketing commission notifications.

Quick access to units, clients, and contracts.

Interactive charts and summary tables.

2.2 Projects & Units Management

Add/Edit/Delete projects: name, location, delivery year, status.

Add/Edit/Delete units: unit number, type (Studio, 1BR, 2BR, 3BR, Villa), floor, size, price, currency, status (available / reserved / sold / delivered / cancelled).

Upload unit plans and images.

Track unit history and changes.

2.3 Clients & Contracts Management

Client profile: personal info, contact details, passport, nationality.

Link client to purchased or reserved units.

Record contracts (Cash or Installment), including:

Payment plan: number of installments, amount, due dates, currency.

Automatic calculation of remaining balance.

Generate PDF contracts with all details.

Handle resale transactions:

Record seller, buyer, and unit transfer.

Calculate company commission (default 5%) with exceptions.

Update unit ownership.

2.4 Payments & Maintenance

Record all payment types: deposit, installment, maintenance, utility connection fees, resale fees, penalties.

Support multi-currency (EUR, USD, GBP, EGP).

Automatic maintenance calculation every 5 years, with 10% increase over the previous 5-year payment.

Handle exceptions (fixed amount or one-time 15% payment).

List upcoming payments and overdue balances.

2.5 Handover Management

Track unit handover status: ready, delivered, delayed.

Prevent handover if client has pending payments.

Upload handover documents and unit photos.

Generate PDF handover certificates.

2.6 Contract Cancellation Management

Record cancellation reasons.

Calculate refunds or penalties automatically.

Reset unit status to available.

Store all official cancellation documents.

2.7 Marketing Companies & Commissions

Register Marketing Companies:

Add/Edit/Delete marketing companies.

Record contact info (phone, email), default commission percentage or fixed amount, and notes.

Link Sales to Marketing Companies:

Assign marketing company to each sale (if applicable).

Automatically calculate commission based on predefined percentage or fixed amount.

Ability to adjust commission manually for exceptions.

Commission Payments:

Record payment of commissions (date, amount, currency).

Track pending and paid commissions per marketing company.

Reports:

Sales associated with marketing companies.

Outstanding and paid commissions.

Export reports to PDF or Excel.

2.8 Reporting

Generate reports filtered by project, client, unit, payment type, marketing company, or date range:

Sales summary

Payments collection

Maintenance due

Units status

Cancelled contracts

Marketing commissions

Export all reports to Excel or PDF.

2.9 System Features

Web-based internal system (desktop-focused).

Single user (operations manager) with full access.

Data backup (daily or weekly).

Modern, user-friendly interface for managing large-scale projects.

Audit log: track all changes to units, clients, payments, contracts, and commissions.

3. Optional Future Enhancements

Add multiple user roles (sales, accounting, management).

Automated email/SMS notifications for upcoming payments, maintenance, handovers, or commission payments.

Cloud deployment for multi-device access.

4. Deliverables

Fully functional web application (desktop-focused).

Database of projects, units, clients, contracts, payments, maintenance, and marketing commissions.

PDF/Excel generation for contracts, handover certificates, commission reports, and financial reports.

User manual and installation guide.

Daily/weekly backup setup.

5. Technologies (Suggested)

Frontend: ReactJS, VueJS, or similar.

Backend: Python (Django/Flask), NodeJS, or similar.

Database: MySQL, PostgreSQL, or SQLite.

PDF/Excel generation library integrated.

Hosted on company server or secure cloud server." (client-provided description)