The Investor Relations Dashboard in Google Sheets turns a shareholder register and an IR contact log into six linked pages you can read in one sitting. The sample file ships with 500 demo IR records covering 10 institutional holders, 5 regions, 8 IR officers and 7 engagement types, driven by 15 slicers and 18 charts that all read native pivot tables. Built by NextGenTemplates, whose spreadsheet templates reach 300,000+ subscribers across our YouTube channels. Pivots, slicers and formulas already cover 1,000 rows, so you paste your own register over the demo data and every chart redraws. Instant download, lifetime access, and a PDF with a one-click Make a copy link into your own Google Drive.
Every figure in the screenshots is sample data supplied for demonstration. This is a tracking and reporting template: it does not give investment advice and makes no regulatory or disclosure-compliance claims.
Key Features of the Investor Relations Dashboard in Google Sheets
- Pivot-and-slicer architecture. Every chart reads a pivot table parked to the right of its page. Scroll past the spacer column and you can inspect the exact numbers behind any visual.
- Per-page filter strips. Overview, Shareholders and Engagement each carry four slicers; Performance carries three. Clicking one redraws every chart, pivot and Top 5 panel on that page, and leaves the other pages untouched.
- KPI cards that stay absolute. The four metric cards and the At a Glance list on each page use SUMIFS and COUNTIFS against the Data sheet, so they always show unfiltered totals as a reference point while the charts move with the slicers.
- Four ranked sidebars. Top 5 Holders by Value, Top 5 Regions by Value, Top 5 Investor Types by Value and Top 5 IR Officers by Value, each paired with a share-of-total bar list.
- A single-record lookup. The Search page takes an Event ID and returns all sixteen fields for that record, from holder and region through to sentiment and the IR officer who owned the interaction.
- Room to grow. Pivots, slicers and formulas already reach row 1001, so pasting a longer register needs no re-ranging.
- One-block theme. The slate ink, cyan accent and amber second-series colours live in one palette block, so rebranding is a three-value edit.
What’s Inside the Investor Relations Dashboard in Google Sheets
Overview – shareholder base, valuation and capital flows
The landing page carries four slicers (Month, Investor Type, Region, Analyst Rating) above four KPI cards: Total Position Value, Shares Held, Net Flow and Average P/E Ratio. Below them sit Position Value by Month, P/E Ratio vs Growth Rate, Ownership by Investor Type, Top Holders by Position Value, Average Share Price by Month and Net Flow Bridge by Quarter. The sidebar adds an IR Snapshot, a 12-month position value column strip, the top five holders and an analyst rating mix.
Shareholders – register composition
This page answers who owns what. Register Metrics show institutional value, sovereign wealth value, holders on register and average position size. Value vs Shares by Investor Type puts value columns against a share-count line, Position Value by Region ranks the five regions, Region Value by Investor Type stacks the mix inside each region, and Shares Held by Holder ranks the register itself. Slicers cover Investor Type, Region, Holder and Month.
Performance – share price, multiples and capital flow by period
Three slicers (Quarter, Analyst Rating, Holder) drive Average Share Price vs Position Value by Month, Net Flow by Month as a stepped area, and Average P/E by Analyst Rating. Valuation Metrics report average share price, peak share price, average growth rate and net inflow, while the sidebar breaks value down by quarter and lists the top five investor types.
Engagement – IR outreach, sentiment and analyst coverage
The outreach page counts total interactions, earnings calls, positive sentiment share and one-on-one meetings, then breaks them down through Sentiment Mix, Interactions by Engagement Type, Interactions by IR Officer, Monthly Interaction Volume and Value vs Interactions by Analyst Rating. Slicers cover Engagement Type, Sentiment, IR Officer and Region, so you can isolate a single officer’s roadshow record in two clicks.
Search – look up any IR record by Event ID
Choose an Event ID from the dropdown and the Record Details panel returns date, institutional holder, investor type, region, engagement type, analyst rating, position value, shares held, share price, P/E ratio, growth rate, net flow, sentiment, IR officer and month for that single row.
Instructions – a ten-step user guide
The last tab explains where the pivots live, how the slicers scope to a page, why the KPI cards stay unfiltered, how far the auto-expand reaches and which units the figures use. It is the page to read before you paste your own data.
Investor Relations Dashboard in Google Sheets vs. Excel vs. Paid IR Software – Where This Fits
| This template (Google Sheets) | An Excel IR workbook | Paid IR / CRM platform | |
|---|---|---|---|
| Cost | 16.99 one-off (9.99 on sale) | Similar one-off, plus an Office licence | Typically four figures a year and up |
| Platform | Browser, any OS | Windows or Mac desktop | Vendor web app |
| Setup time | Copy the sheet, paste your register – under an hour | Similar, once the file is downloaded | Onboarding and data migration, often weeks |
| Real-time team collaboration | Native, multiple editors at once | Needs OneDrive or SharePoint | Native |
| Mobile access | Google Sheets mobile app | Excel mobile app | Vendor app |
| Customisable fields | Add columns and pivot fields yourself | Yes | Usually vendor-controlled |
| Share with a link | Yes | File or cloud link | Seat-based invitations |
| Year-1 cost at 5 users | 16.99 total | 16.99 plus licences | Per-seat subscription |
| Shareholder register view | Built in, sliced by type, region and holder | Built in | Built in, often with data feeds |
| Live market data feed | No – you supply the numbers | No | Usually included |
If you need a live pricing feed or automated regulatory filing, a paid IR platform is the right tool. If you keep your register and meeting log in a spreadsheet already and want it to read like a dashboard, this is the cheaper path.
Who This Template Is For – and Who It’s Not For
A good fit for: IR managers at listed mid-caps who report to a board every quarter; CFOs and finance leads at growth companies preparing an investor update; fund administrators and family offices tracking positions across a handful of holders; and consultants who build IR reporting packs for clients.
Not a good fit if: you need live share prices pulled automatically from an exchange; you are managing thousands of retail holders and need registrar-grade record keeping; you want automated regulatory filing or disclosure workflow; or you need audit trails and per-field permissions. This is a spreadsheet you control, not a compliance system.
How to Use the Investor Relations Dashboard in Google Sheets
- Open the PDF in your download and click the Make a copy link. The dashboard lands in your own Google Drive.
- Read the Instructions tab first – it takes two minutes and explains the pivot and slicer layout.
- Open the Data sheet and replace the 500 demo rows with your own register and IR log. Keep the column headers exactly as they are.
- Check your units. Position Value and Net Flow are in millions and Shares Held in thousands; change the headers and number formats if you prefer different units.
- Refresh the slicer lists if you added new holders, regions or IR officers, then click through the filter strip on each page.
- Use the Search page to spot-check a few records against your source system before you circulate anything.
- Recolour the palette block if you want the dashboard in your own brand colours, then share the file with view access to your board or leadership team.
Real-World Use Cases
Priya, IR manager at a listed industrials group. She keeps the register in the Data sheet and files each analyst call, roadshow and site visit as an IR record. Before each board meeting she filters the Engagement page to the current quarter and screenshots the sentiment mix and interactions-by-officer charts straight into the pack.
Daniel, CFO at a pre-IPO software company. He has no listed price yet, so he repurposes the share price column as a last-round valuation per share and uses the Shareholders page to show his board how concentrated the cap table has become by investor type and region.
Amara, analyst at a boutique advisory firm. She copies the template once per client, drops in their register, and uses the Top 5 Holders and Position Value by Region panels as the opening two slides of every quarterly review.
Frequently Asked Questions
Does this template give investment advice or price recommendations?
No. It is a tracking and reporting tool. It displays the numbers you enter and nothing more – no valuations are calculated for you, no recommendations are produced, and the analyst ratings are simply a field you record.
Are the numbers in the screenshots real?
No. All 500 rows are demo data generated to show the layout working. Delete them and paste your own register before you share the file with anyone.
Do I need Google Sheets add-ons or macros?
No. The dashboard uses only native Google Sheets features: pivot tables, slicers, charts and standard formulas such as SUMIFS and COUNTIFS.
How many records can it hold?
Pivots, slicers and formulas are pre-ranged to 1,000 data rows. You can paste new rows anywhere up to row 1001 without re-ranging anything. Beyond that, extend the pivot ranges once and the rest follows.
Why do the KPI cards not change when I click a slicer?
That is deliberate. The four metric cards and the At a Glance list use SUMIFS and COUNTIFS on the Data sheet so they always show the unfiltered total, giving you a fixed reference while the charts, pivots and Top 5 panels respond to the slicers.
Can I use it in Microsoft Excel?
The file is built for Google Sheets. Slicers and pivots do not translate cleanly on export, so if you work in Excel, look at our Excel dashboards instead.
Can I change the colours?
Yes. The theme is one palette block – a slate ink, a cyan accent and an amber second-series colour. Edit those three values and the whole dashboard follows.
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.
Explore Related Templates
- Sustainability and ESG Dashboard in Google Sheets – the reporting side of the same governance story.
- Environmental, Social, and Governance (ESG) Dashboard in Google Sheets – ESG scores, initiatives and disclosure tracking.
- Audit & Internal Controls Dashboard in Google Sheets – findings, remediation and control coverage.
- Diversity & Inclusion Dashboard in Google Sheets – the workforce metrics investors now ask about.
- Real Estate Development Dashboard in Google Sheets – project capital and returns in the same slicer-driven layout.
Browse the full Google Sheets Dashboard category or the wider Google Sheets template library.
Ready to put your shareholder register on one screen? Add the Investor Relations Dashboard in Google Sheets to your cart and download it instantly – the PDF inside gives you a Make a copy link straight into your Google Drive. Read the full walkthrough on our blog: Investor Relations Dashboard in Google Sheets.
Watch the step-by-step video Demo:
Last updated: 14 August 2026.
