Real-Time Inventory: Why Spreadsheets No Longer Cut It

Real-time inventory is a list of every unit in a project whose status (available, reserved, sold) and price update instantly for everyone, the moment something happens. A spreadsheet can't play that role once several people are selling at the same time: versions multiply, and errors become inevitable.

Almost every project starts with a spreadsheet. It's quick to set up, everyone knows how to use it, and for a few dozen units sold by one person, it works. The problem appears when the project grows, the team grows, and sales speed up.

In Short

• Real-time inventory updates each unit's status and price for the whole team, instantly.
• Spreadsheets break down as soon as several reps reserve units at the same time.
• The real cost of a spreadsheet: double bookings and hours lost to updates.
• Four signs tell you it's time to switch.

What a Spreadsheet Can't Do

Keep up with several reps at once. Two sales reps open the file in the morning, each reserves unit 1204 in the afternoon, and nobody notices until evening.

Keep a single version. "Inventory_final_v3", "Inventory_final_v3_SB", "Inventory_updated": every copy sent by email becomes a competing version.

Talk to your other tools. The website still shows a sold unit, the CRM doesn't know an offer was accepted, and the price list sent to buyers dates from last week.

Keep a history. Who changed the price of unit 803, and when? In a spreadsheet, there's no way to know for sure.

What It Really Costs

The most visible cost is the double booking: two buyers promised the same unit, and one of them walks away disappointed, often with a poor impression of the whole project.

The heavier cost is invisible: time. According to Salesforce's State of Sales report, sales reps spend 70% of their time on tasks other than selling. Updating a file, checking availability, re-sending a corrected price list: every minute spent there is a minute not spent with a buyer.

For management, the spreadsheet creates another problem. You have to wait for someone to update it to know where sales stand, so decisions are made on last week's numbers.

What Changes With Real-Time Inventory

With real-time inventory, a reservation made by one rep updates the unit everywhere at once:

• on the project website, where buyers see actual availability;
• in the sales team's tool, so no one can promise a unit that's already reserved;
• in the management dashboard, which tracks the sales pace of every project without waiting for a report;
• in the buyer's file, linked to their offer and contract.

Prices follow the same principle: a change made once applies everywhere, with a record of who made it and when.

How to Know It's Time to Leave the Spreadsheet

A few signs don't lie: more than two people edit the inventory, you've already had a double booking, you email price lists more than once a week, or management regularly asks "where are we at?" If any of these sound familiar, your project has outgrown what a spreadsheet can handle.

Frequently Asked Questions

What is real-time inventory in real estate? It's the list of a project's units whose status (available, reserved, sold) and price update instantly for the whole team, the website and management, as soon as a reservation or change happens.

Can you manage a presale project with Excel? For a small project run by one person, yes. As soon as several reps work at the same time, Excel creates competing versions and the risk of double bookings.

How do you avoid double bookings? With a shared, real-time inventory: a unit reserved by one rep instantly becomes unavailable to everyone else.

The Bottom Line

A spreadsheet is a fine starting point, but it can't keep pace with a launch. Real-time inventory gives the whole team the same information at the same moment, prevents costly errors and frees up time to sell. It's at the heart of NEO, the Onyx Technologies platform.

See your project's inventory in real time. Talk to our team →

Sources

1. Salesforce, State of Sales, 6th edition (2024)