Real Estate Transaction Tracker

Follow each property deal from first showing to closing, with offer and sale prices, key dates, documents and commission earned.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Trackers

Tables

Transactions

Fields

19

Views

grid, kanban, calendar, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Transactions

19 fields · 6 sample rows

  • All deals (Grid)
  • Pipeline (Kanban)
  • Closings (Calendar)
  • Sales (Dashboard)
PropertyTextClientTextClient phonePhoneSideSingle selectProperty typeSingle selectAgentSingle selectStageSingle selectList priceCurrencyOffer priceCurrencySale priceCurrencyDiscount to listFormulaCommission ratePercentCommissionFormulaOffer dateDateExpected closingDateDays to closeFormulaLenderTextDocumentsAttachmentNotesLong text
3BHK, Prestige Shantiniketan T4-1102Rakesh & Meena Agarwal+91 98450 11223BuyerApartmentNeha BansalDue diligence₹1,85,00,000₹1,78,00,0001.0%₹1,78,0007 Nov 202614 Dec 202625HDFC Home Loans
Villa 22, Palm MeadowsDr. Sarah ThomasSellerVillaCarlos MendesClosed₹4,20,00,000₹4,05,00,000₹4,05,00,0003.6%1.5%₹6,07,50020 Sep 202611 Nov 2026
2BHK, Lodha Palava B-504Imran Shaikh+91 98200 55443BuyerApartmentAditya RaoOffer made₹72,00,000₹68,00,0001.0%₹68,00017 Nov 20263 Jan 202745
Plot 118, Sector 57 GurugramHarjeet SinghSellerPlotNeha BansalShowing₹3,10,00,0002.0%₹0
Shop G-12, Phoenix Market CityBluestone Retail LLPBuyerCommercialCarlos MendesRegistration₹2,60,00,000₹2,48,00,000₹2,48,00,0004.6%2.0%₹4,96,00020 Oct 202623 Nov 20264SBI
1BHK, Hiranandani PowaiPooja MenonBuyerApartmentAditya RaoFell through₹95,00,000₹89,00,0001.0%₹89,00010 Oct 2026Loan not sanctioned.
Field details
Property · Text
Client · Text
Client phone · Phone
Side · Single select
Buyer, Seller, Both
Property type · Single select
Apartment, Villa, Plot, Commercial
Agent · Single select
Neha Bansal, Carlos Mendes, Aditya Rao
Stage · Single select
Lead, Showing, Offer made, Token paid, Due diligence, Registration, Closed, Fell through
List price · Currency
INR
Offer price · Currency
INR
Sale price · Currency
INR
Discount to list · Formula
IF(AND({List price} > 0, {Sale price} > 0), ({List price} - {Sale price}) / {List price}, BLANK())
Commission rate · Percent
Commission · Formula
IF({Sale price}, {Sale price}, {Offer price}) * {Commission rate}
Offer date · Date
Expected closing · Date
Days to close · Formula
IF(AND({Expected closing}, {Stage} != 'Closed'), DATETIME_DIFF({Expected closing}, TODAY(), 'days'), BLANK())
Lender · Text
Documents · Attachment
Notes · Long text

Real Estate Transaction Tracker: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates