A developer’s sales register knows everything and shows nothing. Total booked value is easy; what is hard, on one screen, is which project actually earns per square foot rather than in total, which booking type carries the margin, and how much of the pipeline is sitting unregistered. The Real Estate Development Dashboard in Google Sheets is built for those questions: 6 pages, 16 KPI cards, 16 charts, 4 named slicers per page and a deal lookup, all running on native Google Sheets pivot tables and slicers rather than a wall of formulas. The sample file carries 500 deals across 8 projects, 9 property types, 8 booking types and 10 sales agents, and everything is pre-wired for 1,000 rows. Built by PK, a Microsoft Certified Professional with 15+ years in spreadsheets and 300K+ subscribers across two YouTube channels. Your download is a PDF with a Make a copy link: one click and an editable copy is in your own Google Drive, with no add-on and no monthly fee.
Key Features of the Real Estate Development Dashboard in Google Sheets
- Pivot-and-slicer architecture. Every chart reads a native pivot table parked to the right of its page. No hidden helper formulas, which is what keeps the file quick as the deal register grows.
- Named slicers on every analysis page. Month, Project, Property Type and Deal Status on Overview; Project, Booking Type, Month and Buyer Tier on Projects; Booking Type, Property Type, Sales Agent and Buyer Segment on Sales; Buyer Tier, Buyer Segment, Payment Method and Month on Buyers.
- Revenue per square foot. Sale value and area sold are tracked on the same rows, so revenue per sq ft and average area per deal are calculated rather than estimated – the measure that separates a project selling well from one selling cheap.
- Sixteen KPI cards. Four per page: total revenue and average deal value on Overview, registered deals and area sold on Projects, investment deal revenue and largest deal on Sales, unique buyers and pending approval rate on Buyers.
- A full sidebar on every page. A three-stat snapshot, a 12-month revenue sparkline, a Top 5 ranking, a share-of-revenue bar list, a six-row At a Glance panel and a 12-month deal volume sparkline.
- Project comparison built in. All eight projects ranked on revenue, area sold, booking-type mix and share of portfolio revenue.
- Booking type analysis. New booking, resale, pre-launch offer, investment deal, possession handover, exchange deal, corporate lease and rent-to-own, each with revenue and share – which is how you see what pre-launch discounting really costs.
- Agent leaderboard. Revenue by Sales Agent ranks all ten agents, with a Top 5 panel that stays visible as you filter.
- Buyer tier and segment analysis. Deals by Buyer Tier across Corporate, First-Time Buyer, HNI, Investor, NRI and Premium, plus Buyer Segment Revenue vs Area for business owners, NRI investors, retirees and two salaried brackets.
- Payment and financing mix. Bank loan, cash, corporate finance, installment plan, mortgage and online transfer split by revenue, with the loan-financed share on the sidebar.
- Deal lookup page. Pick any Deal ID and read the full record: date, project, property type, booking type, buyer name, buyer tier, sale value, area, payment term in months, sales agent, payment method, deal status, buyer segment, month and quarter.
What’s Inside the Real Estate Development Dashboard
Six pages, linked by a navigation bar across the top of each.
1. Overview – portfolio-wide performance. Total Revenue, Total Deals, Total Area Sold and Avg Deal Value across all projects and deal types, with Monthly Revenue Trend, Revenue by Property Type, Revenue by Buyer Tier and Project Revenue vs Deals. The sidebar adds registered rate, average area, average payment term and the top five projects by revenue.
2. Projects – revenue, area and deal-type mix by project. Registered Deals, Total Area, the leading project’s revenue and Avg Area per Deal, with Revenue vs Area Sold, Revenue by Project & Booking Type, Monthly Area Sold and Deals by Status. Revenue per sq ft, average payment term and the pending-approval rate sit on the sidebar with each project’s revenue share.
3. Sales – deal type, property and agent performance. Investment Deal Revenue, Corporate Leases, Pre-Launch Revenue and Largest Deal, with Revenue by Booking Type, Property Type Revenue vs Deals, Revenue by Sales Agent and Area Sold by Buyer Segment. The sidebar carries revenue per sq ft, average area, deal types offered and the top five agents.
4. Buyers – tiers, segments and payment behaviour. HNI Revenue, Corporate Deals, Unique Buyers and Pending Approval Rate, with Deals by Buyer Tier, Buyer Segment Revenue vs Area, Revenue by Payment Method and Monthly Deal Volume. Revenue per buyer, deals per buyer and the loan-financed share sit on the sidebar.
5. Search – deal lookup. Choose a Deal ID and the page returns that transaction’s full record in one clean table – the fastest way to settle a query about a single unit without scrolling the register.
6. Instructions – a ten-point user guide. How the pivots and slicers are wired, why the KPI cards deliberately show unfiltered totals while the charts are slicer-aware, how to replace the sample data, and how to raise the row limit past 1,000 in the Apps Script file.
Behind those sits the Data sheet, one row per deal with the columns the pivots expect. Replace the sample rows with your own register, keep the headers, and every page follows.
Real Estate Development Dashboard vs. an Excel Report vs. a Property CRM – Where This Fits
| This Google Sheets dashboard | A hand-built Excel report | Property CRM analytics module | |
|---|---|---|---|
| Cost | 9.99 once | Free, plus your build time | Bundled into 50 to 300 per user per month |
| Platform | Google Sheets, any browser | Microsoft Excel on desktop | Vendor web app |
| Setup time | Under 30 minutes with your register | 2 to 3 days for six pages of pivots | Already there, if you use that CRM |
| Real-time team collaboration | Yes, native Google Sheets sharing | Only through OneDrive co-authoring | Per paid seat |
| Mobile access | Yes, free Google Sheets app | Limited | Yes |
| Customizable metrics | Yes – every pivot and card is editable | Yes, if you build them | No, fixed report set |
| Revenue per square foot | Yes, calculated per project | Build it yourself | Rarely included |
| Combines projects across systems | Yes – reads a data sheet, not an API | Yes | Only within that vendor |
| Share with an investor or lender | Yes, a view-only link | Send a file | Usually needs a seat |
| Year-1 cost for a 5-person sales team | 9.99 | 0 plus several days of work | 3,000 and up |
The honest position: a CRM chases leads and this sheet does not – it reports on deals already done. It earns its place when you want one view across projects that sit in different systems or spreadsheets, when an investor wants a portfolio pack without a CRM login, or when you want revenue per square foot, which most property CRMs simply do not calculate.
Who This Template Is For – and Who It’s Not For
A good fit if you are: a developer running two or more projects and comparing them on the same measures; a sales head tracking agent performance and booking-type mix; a project finance manager who needs revenue per sq ft and payment terms in one place; an investor or lender who wants a monthly portfolio pack; a consultant producing sales reports for a developer client.
Not the right tool if you are: looking for a CRM to manage leads, site visits and follow-ups – this reports on closed deals rather than chasing open ones; needing inventory or unit-availability management, which needs a live unit master this sheet does not carry; or running a single project with a handful of units, where the dashboard is more machinery than the question needs.
How to Use the Real Estate Development Dashboard
- Open the PDF in your download and click the Make a copy link. Google Drive creates your own editable copy.
- Read the Instructions page first. Ten points, two minutes, and it explains why the KPI cards show unfiltered totals while the charts respond to slicers – the one thing people misread.
- Export your deal register and paste it onto the Data sheet, keeping the existing column headers so the pivots, slicers and charts stay connected.
- Check the Overview page immediately. Total revenue, deal count and area sold will tell you within seconds whether the import landed correctly.
- Start with revenue per square foot on the Projects page. It is the measure that most often disagrees with the internal ranking everyone assumes.Real Estate Development Dashboard in Google Sheets
- Use the slicers to ask questions. Filter to one project, one quarter or one booking type and all four charts plus the sidebar move together.Real Estate Development Dashboard in Google Sheets
- Clear a slicer by opening it and choosing Select all. Slicers are per page, so each page keeps its own view.
- Going past 1,000 rows? Open the Apps Script file, raise DATA_ROWS and re-run main(). Everything below that limit already works with no setup at all.Real Estate Development Dashboard in Google Sheets
Real-World Use Cases
A developer ranking eight projects properly. Skyline Residences led on revenue at 17.1% of the portfolio, but the Revenue vs Area Sold chart showed another project moving similar value on far less area – a higher rate per square foot. The next phase’s pricing was set from that comparison rather than from headline sales value.Real Estate Development Dashboard in Google Sheets
Pricing a pre-launch discount. Pre-launch offers accounted for roughly 12.7% of revenue while new bookings carried 29.5%. Putting the two side by side, with average deal value beside each, made it possible to argue about the discount with numbers rather than instinct.Real Estate Development Dashboard in Google Sheets
A sales head reviewing ten agents. Revenue by Sales Agent spread from about 11 million to nearly 18 million. Filtering the same page by buyer segment showed the top agent’s lead came largely from one segment, which turned a bonus discussion into a training plan for the rest of the team.Real Estate Development Dashboard in Google Sheets
Frequently Asked Questions
Do I need a paid Google Workspace account?
No. A free personal Google account is enough. Click the copy link in the PDF and the dashboard lands in your own Drive with the pivots, slicers and charts working.
Does it connect to my CRM?
No, and that is deliberate. You export your deals and paste them onto the Data sheet, which means the dashboard works with any CRM or none at all – and lets you combine projects whose records live in different systems.
How many deals can it hold?
The pivots, slicers and formulas are pre-wired for 1,000 rows, so anything up to that needs no setup. To go further, open the Apps Script file, raise the DATA_ROWS value and re-run main().Real Estate Development Dashboard in Google Sheets
Does it track unit inventory or availability?
No. It reports on deals that exist in your register; it does not hold a unit master, so it cannot tell you what is unsold. That is a CRM or inventory job.Real Estate Development Dashboard in Google Sheets
Why don’t the KPI cards change when I click a slicer?
By design. The KPI cards and the At a Glance list use SUMIFS and COUNTIFS on the Data sheet so they always show unfiltered totals – the constant you compare against. The charts, pivots and Top 5 panels are slicer-aware and do respond.
Can I add my own projects, property types or booking types?
Yes. They are values in your data, not hard-coded lists. Paste in your own rows and the pivots, slicers and charts pick up whatever names you use.
Can I share it with an investor without giving them edit rights?
Yes. Use the normal Google Sheets Share button and give view or comment access – one of the practical advantages over a CRM whose reports usually need a paid seat per person.Real Estate Development Dashboard in Google Sheets
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.Real Estate Development Dashboard in Google Sheets
Explore Related Templates
- Tenant and Property Management Dashboard in Google Sheets – for the rental side of a portfolio.
- Real Estate Crowdfunding Dashboard in Power BI – investor-side analysis with drillthrough.
- Property Enquiry Data Entry System in Excel – captures enquiries before they become deals.
- Rent Collection Data Entry System in Excel – post-handover cash collection.
- Prop Tech Dashboard in Excel – the same questions in Excel.
- Browse every Google Sheets dashboard or the full Google Sheets template catalogue.
Get Your Copy
Export last year’s deal register, paste it in, and open the Projects page. Most developers find the revenue-per-square-foot ranking disagrees with the one they had in their head. If anything does not work as described, contact us and we will put it right.
Last updated: 12 August 2026.
Reviews
There are no reviews yet.