A custom software solution developed to streamline real estate bookings, financial tracking, collections, and account management within a unified system.
Built to replace scattered Excel sheets, manual tracking, and fragmented tools - this tool eliminates fragmented real estate tracking by centralizing daily operations into a single streamlined workflow.
Lead TrackingBooking ManagementProperty InventoryOffline DashboardWorkflow AutomationSingle User System
1Operator, zero shared infra
6Core workflow modules
0Spreadsheets needed
100%Local data ownership
The Problem
One operator, scattered across too many tools
A single real estate operator managing multiple properties manually - with data scattered across Excel sheets, WhatsApp messages, and paper records. No centralized lead view. No booking history. No real-time property availability. Every update required touching three different files.
Scattered data, no single view
Lead notes in one file, bookings in another, payments tracked separately. No single screen showed the complete picture of daily operations.
Manual tracking, high error risk
Every booking update, payment receipt, and unit status change required manual entry across multiple spreadsheets - error-prone and time-consuming.
No centralized lead visibility
Leads came from multiple sources with no unified pipeline. Follow-ups were missed, site visits weren't logged, and booking conversions were hard to track.
No real-time property availability
Unit status (available, booked, blocked) wasn't visible in one place. Double-booking risks were real, and inventory decisions relied on memory rather than data.
The solution required unified visibility across operations and accounting:
Booking & Collections
Unit Availability
Overdue Milestones
Receivables & Aging
Architecture
How the workflow was structured
The tool is built around a centralized workflow model - daily operations (leads, bookings, payments) flow through automated rules into structured records, eliminating manual re-entry at every step. Everything runs locally, on one machine, with no internet dependency.
Spring Boot service layer - business logic, rule engine, validation
↓
Domain
Real estate domain + accounting rule engine - event-to-entry mapping
↓
Ledger
Financial entry system - immutable ledger, accrual/cash support
↓
Storage
SQLite embedded database - fully local, ACID-compliant, zero setup
↓
Documents
Local file system - agreements, KYC, receipts, invoices
No external APIsNo cloud syncNo remote databaseNo internet required
Engineering Decisions
Five design decisions that shape this tool
1
Embedded database over client-server architecture
SQLite was chosen deliberately - no server setup, no DBA overhead, no network latency. A single real estate operator gains ACID-compliant transactional integrity with zero operational complexity. The database ships inside the application.
SQLiteZero administrationACID compliant
2
Ledger-centric accounting - no direct UI-to-record writes
Every financial record is an immutable ledger entry. There is no "edit invoice" button that overwrites data. Corrections are made through reversal entries, mirroring how chartered accountants work. This guarantees a complete, auditable financial history from day one.
Ledger-firstImmutable recordsAudit trail
3
Event-driven financial mapping from real estate operations
Business operations - booking creation, payment receipt, cancellation, possession transfer - are modelled as domain events. Each event fires configurable accounting rules that generate draft ledger entries for review, eliminating manual re-entry entirely.
Event-drivenRule engineDraft-before-post
4
Encrypted backup-and-restore as the only data migration path
Rather than building distributed sync (with its concurrency complexity and conflict-resolution risks), the system provides encrypted full-system backups exportable to USB at any time. Migration to a new machine is a controlled restore - predictable, safe, and fully user-owned.
JavaFX + Spring Boot on desktop, not Electron or web
A Java-native stack was chosen over web-based desktop (Electron) to maximise local file system access, avoid browser sandbox restrictions, and deliver a responsive UI without the overhead of a bundled Chromium instance on modest office hardware.
JavaFXSpring BootNo Electron overheadNative file access
Core Workflows
What the tool handles, end to end
Accounting Engine
Tally-class core
Built
P&L, Balance Sheet, Cash Flow statements ✓
Accrual and cash-basis accounting modes ✓
Configurable chart of accounts ✓
Financial reconciliation with partial payments ✓
Role-based access control on ledger functions ✓
Revenue recognition & GSTR returns (Roadmap)
Booking & Inventory Management
Domain-native module
Built
Project / tower / unit inventory management ✓
Full booking lifecycle with stage tracking ✓
Unit availability matrix (sold / booked / blocked) ✓
Dynamic pricing and discount logic ✓
Cancellation and refund workflows ✓
Lead Tracking
Lead-to-booking pipeline
Built
Lead → site visit → booking funnel
Customer timeline view with full history
Follow-up scheduling and task management
Sales executive assignment and targets
Reporting & Analytics
Operational intelligence
BuiltRoadmap
Sales and collection dashboards ✓
Outstanding dues aging reports ✓
Project-level profitability tracking ✓
Unit-level financial drill-down ✓
Cash flow forecasting, margin by tower (Roadmap)
Construction Tracking
Project cost control
Built
Stage-wise construction progress ✓
Cost allocation per project and tower ✓
Contractor billing integration ✓
Work completion percentage tracking ✓
Backup & Portability
User-owned data control
Built
Encrypted full-system backup anytime ✓
Scheduled or manual export to USB / external drive ✓
Schema versioning for safe cross-version restore ✓
Controlled migration to a new machine ✓
Planned Features
Roadmap - what's coming next
The core modules shown here were built and validated. The roadmap features below represent planned extensions based on operator feedback and Indian real estate compliance requirements.
Revenue Recognition (High)
Percentage-of-Completion and milestone-based revenue for Ind AS compliance. Auto-journal entries on stage completion.
GST Returns (GSTR-1/3B)
Automated GSTR-1 and GSTR-3B export. Input Tax Credit tracking on materials. Tax compliance reports.
Sales velocity and unit absorption rates. Margin analysis by tower/location. Cash flow forecasting.
Technology Stack
Purpose-chosen, not fashionable
Every technology choice was evaluated against the core constraint: the system must run entirely on one machine, without installation complexity, and be maintainable by a small team long-term.
JavaFX - Desktop UI layer
Spring Boot - Business logic & rule engine
SQLite - Embedded transactional database
Java - Core application runtime
Local File System - Document repository
No Electron. No web browser. No bundled Chromium. JavaFX was chosen for native file system access, lower memory footprint on office hardware, and a richer local UI without web-layer overhead. Spring Boot provides the same production-grade service architecture used in distributed systems, applied entirely on-device.
Outcomes
Time saved, clarity gained, errors reduced
Workflow outcomes
Hours saved weekly on manual data entry across scattered sheets
Complete property availability visible at a glance - no memory-dependent decisions
Leads, bookings, and payments tracked from one dashboard - no tool-switching
Real-time collections status without manually compiling spreadsheet reports
Technical outcomes
All data stays on the operator's machine - no cloud, no third-party access
Single desktop install with no server, no subscriptions, no ongoing infrastructure
Immutable ledger guarantees a complete, error-free audit trail from day one
Encrypted backup to USB - data safety without internet dependency
Visual proof of key outcomes delivered:
Complete dashboard unifying bookings, collections, and unit availability
Real estate-specific chart of accounts with full audit trail
Complete immutable ledger with running balances and narrations
Customer-wise receivables with automated aging buckets
Prototype Value
What this single-user system validated
Real estate operations involve multiple interconnected processes. Bringing them into a single system improves visibility, reduces manual effort, and creates a more reliable source of operational and financial information.
Workflow depth, not scale
Building for one operator meant mapping every edge case in the real estate workflow - lead sources, booking stages, payment milestones, cancellation logic. This depth of process design is harder to achieve when designing for scale from day one.
Process mapping before automation
Before writing a single automation rule, we mapped how the operator actually worked - which data points mattered, what decisions required visibility, and where manual effort created the most friction. Automation followed the process, not the other way around.
UI clarity over feature breadth
Single-user tools demand that every screen makes sense without training. The dashboard was designed around daily decisions - what's available, what's owed, what's overdue - not around feature completeness or lengthy feature checklists.
"The project highlighted the importance of aligning software architecture with business requirements. In this case, complete data ownership and offline operation were just as important as the features themselves."
The success of the system came less from individual features and more from creating a single source of truth for bookings, collections, and financial records.
Need a custom workflow automation tool for your operations?
We build custom workflow and automation systems that reflect the way your business operates. The goal isn't to add more software—it’s to create clarity, visibility, and control across critical processes.
