Skip to content

Operations

Plot Management Software: How to Run Plots and Files Without Selling Anything Twice

Files, allotted plots, premiums and dealers selling from the same blocks: here is how to structure plot inventory so nothing is sold twice and every file maps to real land.

Every developer has a version of the same story. Two dealers sell the same 10-marla corner plot on the same afternoon. A file is sold in the open market that the head office has no record of. A buyer turns up for balloting holding a file for a category that was already full.

These are inventory problems, not sales problems. Plot management software exists to make inventory the single source of truth: one record per plot or file, one status at a time, and a hard rule that nothing is sold unless the record says it is available. This guide explains how to structure that inventory, how to treat files differently from allotted plots, and what to bring over from Excel when you switch.

Why this matters more now

Over-issuance of files is no longer a rumour. A NAB Rawalpindi probe reported by the Islamabad Post found housing schemes in Islamabad and Rawalpindi had sold roughly 91,000 plots and files beyond their available land or approved layout plans. In one cooperative society case, The News reported that the approved layout plan and land bank supported around 6,000 files, while about 42,000 were allegedly issued, and that investigators found complete payment and allotment records missing for thousands of them.

Regulators are responding. In March 2026 the Rawalpindi Development Authority declared 294 housing societies and farm schemes illegal and barred them from selling or advertising plots (Express Tribune). In Punjab, private schemes are being moved onto PLRA's Housing Societies Management System to issue green certificates (Dawn).

For a legitimate developer, the takeaway is simple: you must be able to prove, at any moment, that every file you have issued maps to land you own and a layout plan you have had approved. That starts with land due diligence and continues with disciplined inventory.

Step 1: Structure inventory from land to plot

A good inventory has a clear hierarchy. Each level answers a different question.

LevelExampleQuestion it answers
Land bank parcelKhasra 412, 36 kanal 8 marlaWhat land do we actually own or control?
Project / phasePhase 2What has been approved as one scheme?
Block / sectorBlock CHow is the layout plan divided?
StreetStreet 7, 40 ft roadWhich plots share access and road width?
PlotC-7-112, 5 marlaWhat exactly is being sold?

The land bank level is often skipped in spreadsheets, and that is exactly where over-issuance hides. If you cannot add up the plots in a phase and compare them to the land and layout plan behind it, you cannot prove you have not oversold.

A note on marla size

Agree on one measurement convention and write it down. In most modern Punjab and Islamabad schemes a marla is taken as 225 sq ft, so a 5-marla plot is 1,125 sq ft. Revenue records and some older authority records use 272.25 sq ft (30.25 sq yd), so the same "5 marla" is about 1,361 sq ft. A kanal is 20 marla under either convention.

The practical rule: store the actual dimensions or square footage of each plot alongside its marla size, and print the convention on your booking form. CapitalEstatePK's land-bank conversions use the 272.25 sq ft marla, so if your scheme sells 225 sq ft marlas, record plot sizes as sold and keep the land bank in the revenue unit it was purchased in.

Attributes that belong on every plot

At minimum: plot number, block, street, marla size, category (residential or commercial), unit type (plot, file, house, apartment, shop, office), and price-affecting features such as corner, park-facing, boulevard, main road, facing direction and road width. Add development charges if they vary by plot size or category.

Step 2: Treat files and allotted plots as different things

A file is a buyer's contractual right to a plot of a certain size in a scheme, before a specific plot number has been assigned. Files are usually sold early, often in the open market, and converted into specific plots through balloting. An open file is one traded without being registered in a named buyer's name, which is precisely why it is so hard to track.

An allotted plot is a specific, numbered plot assigned to a named owner, usually through an allotment letter after balloting or on direct booking.

The control that matters is a cap. For each category in the approved layout plan (say, 5-marla residential), the number of files issued plus plots directly booked must never exceed the number of plots in that category.

Here is an illustrative capacity check with made-up figures:

Category (Phase 2)Plots in approved layoutPlots booked directlyFiles issuedHeadroom
5 marla residential40012026020
10 marla residential2509015010
1 kanal residential8035450
4 marla commercial6022308

In this example, the 1-kanal category is full. Any further 1-kanal file sold is, by definition, a file without land. Run this check before every new file batch is released to dealers, and keep the result with management sign-off. We explain the wider controls in preventing overselling land.

The simplest way to enforce this in software is to create every file as an inventory record from the start, with a unit type of "file" under its category, rather than as a separate list of receipts. Then the count of file records is the count of files, and you cannot issue one without creating a record. When balloting runs, the file is converted into a specific numbered plot. Our guide to computerized balloting covers that step.

Step 3: Use a strict status lifecycle

Every plot or file should have exactly one status at any time. Below is a practical set of statuses and what each should mean.

StatusMeaningWho should be able to set it
AvailableCan be sold todaySystem, after cancellation or release
ReservedHeld for a buyer pending token or paperworkSales manager, with a time limit
BlockedNot for sale (owner's quota, legal issue, layout change)Management only
BookedToken or down payment received, booking createdSystem, on booking
SoldFully paid or contract completeSystem or accounts
TransferredOwnership moved to a new buyerSystem, after dues check and transfer
CancelledBooking cancelled; plot pending releaseManagement, under the refund policy

Three rules make the lifecycle work:

  1. Only "available" can be booked. The system must refuse a booking on anything else. CapitalEstatePK does this at the point of booking, so a second salesperson trying to book the same plot gets an error, not a duplicate.
  2. Reservations need an expiry you actually enforce. Decide a limit (for example 48 or 72 hours), and have someone review the reserved list every morning and release stale holds. Ask any vendor whether holds expire automatically or need a person to release them.
  3. Blocked is a management decision. Owner's quota plots and plots under litigation should be blocked with a written reason. "Blocked" plots that quietly get sold are a classic internal fraud pattern (internal fraud controls).

Dashboards should show counts by project, block and status so that management sees, every morning, how many plots are available, reserved, booked and sold.

Step 4: Stop double booking across dealers and offices

Double booking usually happens when inventory lives in more than one place: a master sheet at head office, a printed map with a dealer, a WhatsApp list sent last week. The fix is not more phone calls. It is one live record that everyone reads from.

  • One inventory, many users. Dealers and branch staff should check availability in the same system head office uses, with permissions limiting what they can change (role-based access control).
  • Book in the system first, collect paper second. If the token is taken before the booking is created, you are back to a race.
  • Dealer allocations, if you use them, should be inventory too. If a dealer is given 20 plots to sell, block or reserve those 20, and do not let head office sell them without releasing them first.
  • Daily exception report. Any plot booked by a user outside the branch or dealer it was allocated to should appear on a report for the sales head.

If you run several sales offices, see our notes on managing multiple branches.

Step 5: Price premiums from attributes, not memory

Corner, park-facing, boulevard and main-road plots usually carry a premium. The mistake is letting salespeople apply it from memory. Store the feature on the plot and apply the premium by rule.

An illustrative premium schedule (made-up percentages):

FeaturePremium on base price
Corner10%
Park-facing10%
Boulevard / main road15%
Corner and park-facing20%

Whether premiums stack, and whether they also apply to development charges, should be decided once and written into the booking form. Our guide to corner and park-facing plot pricing covers the options and the disputes they cause.

Step 6: What to bring over from Excel

Most developers moving to plot management software already have a master sheet. Clean it before you import, not after.

DataColumns to includeCommon problems to fix first
InventoryProject, block, street, plot no., marla, sq ft, category, unit type, corner/park/boulevard flags, statusDuplicate plot numbers, merged cells, sizes typed as text
CustomersName, father's name, CNIC, mobile (+92), address, overseas flagCNICs without dashes, missing digits, one customer under two spellings
BookingsPlot, customer, booking date, sale price, discount, premiums, development chargesBookings without a matching plot or customer
SchedulesInstallment no., due date, amountSchedules that do not add up to the sale price
PaymentsDate, amount, method, receipt no., cheque no., bankDuplicate receipt numbers, payments not linked to a booking
FilesFile no., category, holder, issue dateOpen files with no named holder

Then reconcile three totals before going live: number of plots per category against the layout plan, total sale value of bookings, and total received per booking against your accounts. If those three agree, the migration is sound. If they do not, you have found a problem that already existed in Excel. More pitfalls are in real estate software implementation mistakes.

When a spreadsheet is still fine

A single project with a few hundred plots, one person editing the master sheet, no files traded in the open market and no external dealers can run on Excel with discipline: lock the sheet, keep dated copies, and reconcile weekly. Once several people sell from the same inventory, or you issue files ahead of balloting, the risk of a silent error grows faster than the cost of software. See our comparison of CapitalEstatePK and manual spreadsheets.

What plot management software will not do for you

Software enforces the rules you give it. It will not tell you whether your land title is clean, whether your layout plan is approved, or whether a dealer is selling paper files outside the system. It also may not show your full map: in CapitalEstatePK, for example, the map view shows location pins, not drawn plot boundaries, so your approved layout plan remains the visual reference.

What it will do is make your inventory honest and visible. For the bigger picture of what else a developer system should cover, read our housing society management software guide, and for what happens after a booking, see designing installment plans and installment recovery.

Try it on one block

Pick one block, import its plots and live bookings, and check that the status counts match your master sheet. CapitalEstatePK's features include the land bank, plot attributes, status lifecycle and dashboards described here. Start a 7-day free trial, or contact us if you would like help mapping your Excel master sheet before you import it.

Keep reading

Run a housing society or a building project?

See plot inventory, bookings and installment recovery in one ledger. Read about the ERP features, pricing or our Pakistan ERP guide.