Case study · Real estate, plotted development
“Is DWC-424 still available?”
Dholera Worldmark sells residential and commercial plots in Dholera SIR, India’s first greenfield smart city. With around 2,500 plots across seven projects, availability, quotations and payment schedules all lived in Excel sheets and phone calls. We built one system for the whole plot lifecycle, from available to sold and fully paid.
The projects
Around 2,500 plots across seven projects in Dholera SIR.
Each plot has a code that combines its project and number, like DWC-424 or BRZ-088.
- DWCDream World City620 plots66 available
- DW2Dream World City 2410 plots188 available
- BRZBreeze Residency380 plots108 available
- ACHAerocity Hub300 plots169 available
- IMPImperial TP4B2290 plots211 available
- 4B14B1260 plots203 available
- 5B5B226 plots197 available
The problem
Four things that cost them sales.
Sales executives at the site, brokers and the accounts team all worked from copies of the same spreadsheet. By the time a plot was marked, someone else had already quoted it.
Availability checked by phone
Sales executives at the site called the office to ask whether a plot was free. The answer depended on who had updated which sheet.
The same plot promised to two buyers
Quotations on a calculator
Every quotation combined BSP, discounts, PLC, development charges, IFMS, stamp duty by gender and legal fees.
Errors buyers found before the team did
Instalments tracked by hand
Payment schedules sat in Excel. Reminders were phone calls, and late fees were worked out only when someone asked.
Overdue amounts nobody chased
Brokers paid from spreadsheets
Commission for each channel partner was worked out at month-end from bookings spread across sheets.
Brokers calling to ask what they were owed
Two of our team promised the same plot to two buyers. The sheet still said available.
What we did
We followed one plot from enquiry to final instalment.
We worked through the pricing rules with the accounts team, from BSP and PLC to stamp duty and late charges, and moved every project’s plot list out of Excel into a single master.
The life of one plot
- BeforeAvailabilitySales called the office, and someone checked a project’s Excel sheetWith FaxtorAvailabilityEvery plot’s status is live: available, on hold, sold or blocked, with a full history
- BeforeQuotationBSP, PLC, stamp duty and fees worked out on a calculator for each buyerWith FaxtorQuotationThe pricing engine applies BSP, discounts, PLC, stamp duty and fees, valid for 3 days
- BeforeBookingPayment schedule typed into a sheet. Status updated whenever someone rememberedWith FaxtorBookingBooking links buyer, plot and quotation. The schedule is generated and the plot is marked sold
- BeforeCollectionsDue dates tracked by hand. Buyers reminded by phone, late fees rarely chargedWith FaxtorCollectionsEmail reminders before each due date. Late charges of 1.25% a month applied automatically
- BeforeBroker commissionWorked out at month-end from bookings in several sheetsWith FaxtorBroker commissionEach booking is tagged to a partner and commission is worked out on booking value
What we built
Every plot in one place. Every rupee accounted for.
Project and plot master, pricing engine, customer profiles, bookings, payment tracking, reminders, channel partner commissions and dashboards. Hosted on AWS in Mumbai and used in the browser at the office and on site.
- 01Project & plot masterEvery project and plot with its code, size, dimensions, facing, road width and PLC flags. Status changes logged, with bulk updates.
- 02Pricing engineBSP, on-form discount, PLC, development charges, IFMS, stamp duty, registration, legal fees and late charges, set per project.
- 03Customer profilesBuyer details, Aadhaar, PAN and photo, with every plot they own across projects.
- 04Bookings & agreementsBooking links buyer, plot and quotation, and generates a custom instalment schedule.
- 05Channel partners & commissionBrokers tagged to each booking, with fixed or percentage commission and status from pending to paid.
- 06Payment trackingPayments by mode and reference, partial payments, late fees and a statement for every booking.
- 07Automated remindersEmails before each due date, overdue alerts and late-charge notices, all logged per booking.
- 08Dashboards & reportsInventory, receivables, collections, overdue, customer analytics and project-level summaries.
- 09Users & rolesSuper admin, admin, sales and accounts, with view, add, edit and delete set per module.
Plot mapping
The layout plan, with every plot live.
Sales open the approved layout of any project and see every plot coloured by its status. Tap a plot for its size, facing, road width, PLC and price, then put it on hold or start a quotation from the map. Buyers at the site see exactly what is still available.
Part of the next phase
Illustrative layout. Tap any plot to see its details.
A town-planned cityEach project sits inside Dholera SIR’s planned layout of roads, services and green zones, and its map follows that plan.
Landmarks on the mapBuyers see where their plot sits against the activation zone, the ABCD building and the expressway.
Chosen on the land itselfOn a site visit, buyers pick a plot on the tablet while standing on the land, and the code matches the marker on the ground.
The project
9 modules. Phase 1 in 3 weeks.
Phase 1 covers inventory, pricing, bookings, payments and dashboards. The next phase adds a visual plot map, iOS and Android apps, and a CRM for pre-sales.
- 9modules in phase 1
- ~2,500plots moved out of Excel
- 7projects in one system
- 3weeks to phase 1
The team
- PLProject lead
- UXDesigner
- FS2 full-stack engineers
- QAQA engineer
Built with
- React
- Node.js
- PostgreSQL
- AWS Mumbai
- Email automation
- Role-based access
The results
No plot sold twice. No instalment forgotten.
What changed for sales and accounts once every plot ran through the system.
- 2,486Plots on one screen
- 7Projects, one master
- 0Plots sold twice
- 3 daysQuotation validity, enforced
- 7 · 3 · 1Days-before reminders
- 1.25%Late charge, applied automatically
Availability
Live on site
Before
Call the officeQuotation
One tap
Before
On a calculatorPayment schedule
Generated on booking
Before
Typed into ExcelReminders
Automatic emails
Before
Phone callsLate fees
Applied on time
Before
Rarely chargedBroker commission
Per booking
Before
Month-end sheets
“Buyers see the plot, the price and the payment plan before they leave the site.”
Your projects next
More plots, more brokers, more instalments. Let’s put every project on one screen.
Book a no-obligation discovery call. Tell us how you sell and collect today, and we’ll show you exactly where the system saves you hours and money.