Live portfolio dashboards that replace Excel models and Python re-runs
A large health-focused nonprofit organization tracks portfolio company financial performance, ownership percentages, board seats, and allocation ratios in Airtable, syncing bi-directionally with Salesforce to keep a single source of truth. Finance and investment staff operate from interactive dashboards instead of maintaining complex Excel models or running Python scripts for updated figures.
The problem
Finance and investment staff maintained portfolio financial data across multiple systems that did not communicate. Complex Excel models handled ownership and allocation calculations, SharePoint held scorecard data that had to be manually re-keyed into Airtable, and daily reporting required screenshotting dashboards by hand.
Every update to the Python-based analytics models meant a full re-run. Salesforce license costs limited which team members could access deal and portfolio data, and there was no interactive calendar for tracking financing rounds across the portfolio.
What they built
The team built a portfolio analytics base in Airtable that tracks financial performance, ownership percentages, and board seats for each portfolio company. Scorecards previously stored in SharePoint were migrated into linked records, eliminating the manual re-keying step. A bi-directional Salesforce sync keeps both systems in agreement.
Custom formula columns calculate portfolio allocation ratios and sector breakdowns. Airtable Interfaces deliver the visualizations that previously required Python and pandas. A financing round calendar gives staff an interactive view of upcoming rounds, supporting follow-on planning without navigating Salesforce for every update.
The outcome
Finance and investment staff now open a live dashboard instead of re-running models or requesting Salesforce exports. Portfolio allocation ratios, sector and series stage breakdowns, and ownership data are current at all times and visible to contributors who do not hold Salesforce seats.
The manual scorecard re-keying task is gone. Financing round planning is visible on an interactive calendar linked to the portfolio records. The organization avoided Salesforce per-seat costs for analytical work that can be handled entirely within Airtable.
Inside the solution
Portfolio financial analytics and forecasting
Finance & Accounting
Finance & Procurement
- Portfolio company financial performance tracking
- Ownership percentage and board seat management
- Portfolio allocation ratio calculation
- Sector and series stage visualization
- Salesforce bi-directional sync and report updates
- Financing round calendar and follow-on planning
- Complex Excel forecasting models difficult to maintain
- Manual re-keying of scorecard data from SharePoint into Airtable
- Salesforce complexity and high per-seat cost
- Manual screenshotting of dashboards for daily reporting
- Lack of interactive calendar for financing rounds
- Python/pandas re-runs required for updated analytics
- Consolidated financial data in one place with Salesforce sync
- Real-time dashboards replace Python/pandas re-runs
- Reduced Salesforce seat costs by enabling analytical work in Airtable
- Improved readability via list views and Interfaces
- Interactive financing round calendar for follow-on planning
- Eliminated manual scorecard re-keying from SharePoint
- Finance
- Investment
- Salesforce
- SharePoint
- Airtable Interfaces
Portfolio financial analytics and forecasting
Track every portfolio company's financial performance, ownership percentage, board seats, and allocation ratio in one place, and read it from live interface dashboards instead of rebuilding a spreadsheet model or exporting from the CRM. Formula and rollup fields recalculate allocation ratios and sector breakdowns the moment ownership data changes, an interactive calendar surfaces every upcoming financing round, and built-in automations plus Airtable AI fields open scorecard reviews, flag holdings for follow-on review, and draft the committee recommendation for you.
How to build portfolio financial analytics on Airtable
Start from the portfolio companies template
Add allocation and sector formula columns
Connect Salesforce and build Interface dashboards
FAQ
Frequently asked questions
A bi-directional sync runs automatically on a schedule, updating both systems whenever relevant records change. Salesforce remains the system of record for certain interactions, while Airtable owns the analytical layer, including allocation formulas, sector views, and board seat tracking.
Formula fields in Airtable calculate each portfolio company's share of total allocation based on ownership percentages stored directly in the record. When ownership data is updated, the ratio fields recalculate automatically, so no script re-runs or manual formula updates are needed.
Each portfolio company record carries date fields for anticipated financing milestones. A calendar view in Airtable Interfaces surfaces these dates across the portfolio so finance staff can plan for follow-on timing without navigating deal records individually.
Yes. The Airtable Interface serves as the primary analytical surface, so team members who work with portfolio data but do not need to write to Salesforce can access dashboards, allocation views, and the round calendar through Airtable without additional Salesforce seat costs.
Existing scorecard records were imported into a linked Airtable table and attached to the relevant portfolio company records. Staff now complete and update scorecards directly in Airtable, and the data is visible alongside financial performance in the same Interface view without switching tools.