Inventory looks simple until you have three towers and a rumour about which flats are left.
Get the data right
Unit number, type, area, price, facing and floor in one place. Fix errors once at the source.
Update status automatically
Bookings, holds and cancellations should change status without manual edits. Manual edits drift.
Reconcile monthly
Compare system status with sales reports and the site. Differences point to process gaps.
Why inventory needs a checklist
Inventory is the product in real estate. When it is inaccurate, everything downstream suffers: salespeople promise unavailable units, marketing advertises sold-out options and management makes decisions on wrong numbers. A simple checklist, followed consistently, keeps inventory trustworthy.
The checklist covers three areas: getting the data right at the start, keeping status current every day and reconciling regularly.
Setting up projects correctly
Create each project with its basic details: name, location, phases, total units and status. Then add every unit or plot with its number, type, size, facing, floor or position, base price and any premium. Check the data against the approved plan before opening sales.
Use consistent naming for units and phases. Inconsistent numbering, such as A-12 in one place and A12 in another, causes confusion in conversations and reports.
Recording unit attributes
Record the attributes buyers ask about: size, facing, road width, corner position, view or floor. These attributes power filters on plot maps and unit grids, helping salespeople answer questions quickly and accurately.
Keep attribute values standardised. A dropdown with defined options is better than free text, which invites spelling variations.
Status updated automatically
Status should change automatically when actions happen: hold placed, booking confirmed, cancellation approved. Manual status changes should be rare, restricted and recorded. Automatic updates are the best protection against double booking.
Display status clearly wherever units appear: lists, grids, maps and cost sheets.
Managing holds and blocks
Holds need owners and end dates. Blocks, such as units reserved for management or legal reasons, need a clear reason and an approver. Review both regularly so that units do not stay unavailable without a good reason.
Expired holds should release automatically or appear on a daily action list.
Prices and price changes
Keep base prices and charges in the inventory system, not in separate sheets. Apply price changes through controlled bulk updates that touch only unbooked units, and keep a history of every change.
Make sure cost sheets and booking records read prices from the same source.
Partners and inventory access
Decide what channel partners can see: perhaps availability and price but not buyer details. Give them live or frequently updated access from the same inventory, rather than separate lists that drift out of date.
Clear rules on partner holds and bookings prevent conflicts with your internal team.
Monthly reconciliation
Once a month, reconcile inventory with bookings in accounts and files in legal. Check that every booked unit has a booking record, every booking has payments and every cancelled booking has released its unit. Investigate mismatches immediately.
Keep a short reconciliation log. Over time it shows whether data quality is improving.
A worked example
During a monthly reconciliation, accounts notices a payment received for a unit that still shows as held in inventory. Investigation reveals that the booking was agreed but never created because the executive was on leave. The booking is created, the hold removed and the executive’s manager adds a coverage step for leave periods.
Without the reconciliation, the unit might have been offered to another buyer.
Common mistakes
Common mistakes include importing units without checking them against the approved plan, using free-text attributes, allowing manual status changes without records and keeping prices in separate spreadsheets. Each erodes trust in the inventory.
Another mistake is skipping reconciliation during busy months, which is exactly when errors are most likely.
Questions teams often ask
Who should own inventory data? Name an inventory owner for each project, usually in sales operations, with clear authority over changes.
How often should inventory be reviewed? Glance at holds and status changes daily, and reconcile fully every month.
In short
Set up projects and units carefully, standardise attributes, update status automatically, manage holds and blocks with owners and dates, keep prices in one place, give partners controlled access and reconcile every month.
The checklist at a glance
Before launch: projects and units created from the approved plan, consistent unit numbering, standard attributes, base prices and charges stored centrally, roles and permissions set.
Every day: status changes happen automatically from holds, bookings and cancellations, expiring holds are reviewed, and any manual change is recorded with a reason.
Every month: inventory reconciled with bookings in accounts and files in legal, mismatches investigated, partner access reviewed and the reconciliation log updated. Print this list, pin it near the sales desk and tick it off every month.
Accurate inventory is not a one-time project. It is a daily habit supported by a monthly check, and it protects every promise your sales team makes to buyers and partners.
Share the results of each reconciliation with sales so everyone sees that the data is trusted.
Where do I see all properties?
In the All Properties inventory, with type, area, deposit and booking status.