Blog/Real Estate

Unit Inventory and Price Sheet Control: Stop Double Bookings

Run one controlled inventory and price sheet so sales, channel partners and finance never quote a sold unit or an outdated price again.

By Sagar Makker · 7 min read · October 2026
House Home
In short
Multiple copies of the inventory sheet lead to double bookings and buyers quoted outdated prices.
Keep one master inventory with clear unit statuses, blocking rules and an owner for every change.
Version every price sheet, publish read-only copies, and approve discounts outside the sheet.
The problem

This is for sales operations heads, CRM managers and finance controllers at developers selling several towers or phases at once. When the inventory and price sheet lives in emailed spreadsheets, two salespeople can promise the same unit, a channel partner can quote last month's price, and finance discovers the gap only at agreement stage. This post covers a single master inventory, unit status and blocking rules, price versioning, and the daily checks that keep everyone quoting the same truth.

A sales manager blocks a corner unit on the eleventh floor for a buyer who is arranging the booking amount. Another manager, working from a sheet emailed two days ago, books the same unit for a different buyer at a different price. Both buyers have been promised. Someone has to be disappointed, and the developer's credibility takes a hit with both families and their brokers.

Price errors are quieter but just as costly. Floor rise, preferential location charges and parking are calculated differently by different people. Channel partners keep old price sheets on their phones. Finance finds the mismatch when it prepares the demand letter, and the team must choose between honouring a wrong price or reopening a signed booking form.

Why it happens
01Inventory is maintained in multiple spreadsheet copies shared over email and WhatsApp.
02Unit blocks have no expiry, so units stay held long after buyers go quiet.
03Price sheets are not versioned, so nobody can tell which one a buyer was quoted.
04Charges such as floor rise, PLC and parking are calculated manually per quote.
05Discounts are given verbally and recorded only on the booking form.
How to fix it
1
Create one master inventory
Sales operations head owns a single master inventory in the CRM or a controlled sheet, with every unit, carpet area as per RERA documents, facing, floor and status. All other copies are retired.
2
Define statuses and blocking rules
Sales head defines statuses such as available, blocked, booked, agreement signed and on hold. Blocks need a reason, an owner and an expiry you set, after which the unit returns to available automatically.
3
Version every price sheet
Finance controller approves each price revision with a version number and effective date. Base rate, floor rise, PLC, parking and other charges are calculated by formula, not typed per quote.
4
Publish read-only views
CRM manager shares a read-only, current view with sales and channel partners, showing only available units and the active price version. Old versions are clearly marked as superseded.
5
Approve discounts outside the sheet
Sales head sets a discount approval matrix by amount. Any deviation from the active price sheet is requested and approved in the CRM before the booking form is filled, not written on it afterwards.
Worked example
A Gurugram developer ends the corner-unit fights

A developer selling two towers in Gurugram kept inventory in a spreadsheet that the sales operations team emailed every few days. Double bookings happened during busy weekends, and channel partners regularly quoted older prices. The sales operations head moved inventory into one master view with statuses and expiring blocks. Finance began versioning price sheets and calculating floor rise and PLC by formula. Channel partners received a read-only link instead of attachments. Discounts moved into a simple approval request. Weekend launches became calmer because a unit could only be blocked once, and demand letters stopped surfacing pricing surprises that had to be argued over with buyers.

Common mistakes
×
Allowing blocks without an expiry
Open-ended blocks hide sellable units for weeks. Give every block an owner and an expiry, and require a fresh approval to extend it.
×
Emailing price sheets as attachments
Attachments live forever on phones and inboxes. Share a read-only link to the current version and mark superseded versions clearly so outdated prices are easy to spot.
×
Recording discounts only on booking forms
Discounts written on forms surprise finance later. Approve every deviation in the CRM first, linked to the unit and price version, so the booking form simply reflects it.
Where an AI agent helps
Input
Master inventory, active price version, block requests and discount requests
Agent does
Checks unit availability, calculates the quote from the active price sheet and expires stale blocks
Human gate
Sales head approves discounts and block extensions beyond the set limits
Outcome
Accurate quote sheets and a daily inventory status report
Checklist
Retire every inventory copy except one master
Define unit statuses and who can change each one
Set an expiry for every unit block
Number and date every price sheet revision
Calculate floor rise, PLC and parking by formula
Share read-only inventory links with channel partners
What to measure
Double bookings per month
Units blocked past expiry
Quotes issued on superseded price versions
Discounts given without prior approval
Questions
Do we need dedicated inventory software?

Not necessarily at first. A well-controlled CRM module or a locked shared sheet with clear ownership can work. Move to dedicated software when volume, multiple projects or channel partner access make manual control unreliable.

Should channel partners see the full inventory?

Usually they need only available units and the active price version. Hiding blocked and booked units reduces confusion and protects buyer information. Decide access by role, and review it when partners change.

How long should a unit block last?

Choose a period that matches how long buyers typically need to arrange the booking amount, and keep it short. Extensions should need a reason and approval, so blocks do not become a way to hold units indefinitely.

What area should the price sheet use?

Use the area basis that matches your RERA registration and agreement, typically carpet area, and keep it consistent across inventory, price sheet and booking form. Check current RERA requirements for your state with your compliance team.

Keep reading
All posts →
House HomeReal Estate
Real Estate Lead Source Attribution: Know Which Spend Sells Homes
7 min readRead →
House HomeReal Estate
Property Enquiries: Respond Before the Buyer Calls Another Developer
4 min readRead →
House InteriorReal Estate
Channel Partner Follow-Ups: Keep Broker Leads and Payouts on Track
5 min readRead →
Next step

Want this fixed in your business?

Send the workflow. You get a scope and a fixed price within two working days — or a straight answer that it isn't a fit.

Secure by default · find → fix → verify · authorised scope only
Send a brief →enquiry@xdqlabs.com