Quarter end, without rebuilding every portfolio company by hand.
Portfolio reviews, LP reports and investment committee decks. The same companies in every deck, typed in again every quarter from the numbers each one sends in.
Link your decks to the fund model once, and every company in every deck refreshes in one click. Think of the hours that gives back to your team.
For portfolio monitoring, investor relations, finance and ESG teams.
The trial runs on Business: Excel, SharePoint and Google Sheets, where fund models and portfolio data usually live.
No credit card · Your data stays on your PC · Windows, Office 2016+
- Nordkapp Logistics
- Verdant Foods
- Kellerman Optics
- Saltire Marine
- Ostrand Materials
- 1Connect your data
- 2Link the numbers
- 3Color by your rules
- 4Generate one file each
How to build a board pack in Microsoft PowerPoint straight from SQL Server
Read the transcript
Many teams pull SQL into Excel every month, then copy it into a board pack. You can skip the middle. Link the slide straight to the database.
We show each step in our SQL Server video. Next month, the number changes in the database. Open the deck, and click Refresh.
Click OK, and the pack matches the database, with nothing retyped. SQL Server connections are on the Professional plan.
Quarter end, two ways.
- Each portfolio company sends its monthly or quarterly numbers
- An analyst types revenue, EBITDA and net debt into the portfolio review, the LP report and the IC deck, one company at a time
- Someone checks the three decks agree. Then a number changes and it starts again
- Link each deck to the fund model once. That is the last time anyone copies a number by hand
- When the numbers land, click Refresh. Every deck updates together, in seconds
- Generate every company's page and every fund's report in one run. Weeks of quarter end work, done in an afternoon
Example: a fund with 25 portfolio companies, reviewed every quarter.
Today: each company's review pack takes about 2 hours to update from its reporting pack and check. 25 packs, 4 quarters, 2 hours each: 200 hours a year, about 5.3 working weeks, and the same figures are then typed again into the LP report and the IC deck.
With INSYNCR: one template, linked once. Refresh, and all 25 packs are generated in one run. The LP report and the IC deck read the same fund model too, so nobody retypes a single figure and nothing can fall out of step: change a number once in the model and every deck shows it.
Proof, from our published customer story: a private equity firm with over $40bn under management and 55 plus portfolio companies produced an annual sustainability scorecard for each, under SFDR. By hand it took one analyst four months every cycle. With INSYNCR, all 55 plus scorecards refresh and generate in two to three hours.
Read the full story
What this industry runs on INSYNCR.
Quarterly portfolio reviews
One page or pack per company: revenue, EBITDA, net debt and covenants against budget and last year, refreshed from each company's reporting pack.
LP reports and investor updates
Fund level figures such as IRR, TVPI, DPI, NAV and capital calls, plus a summary per company, refreshed from the fund model at quarter end.
Investment and valuation committee decks
Valuations, multiples and movements per company, reading the same model as the LP report, so the two never disagree.
Portfolio company board packs
The same template across the portfolio, one file per company, refreshed every month or quarter.
ESG and SFDR scorecards
One scorecard per company from the data collection each company returns. This is the published story: four months down to three hours.
Fundraising and track record decks
Fund performance and portfolio tables that stay current while the deck is in the market, instead of being rebuilt for every investor meeting.
What this industry asks before it buys.
Our portfolio companies report on different schedules and half the data arrives late.
The template does not care. Generate the companies whose data has landed, refresh the rest when it does, and the ones already produced stay as they were. The published story ran 55 scorecards this way, from four months of work down to an afternoon.
Link once. Refresh forever.
Link the template once
Open the existing deck and link each figure, chart and table to the fund model, the monitoring sheet or the database.
One file per company or fund
Filter the template per company or per fund. Snapshot generates the set, PowerPoint or PDF.
Refresh at quarter end
New numbers in, one click, every deck current and in agreement.
Excel fund models and monitoring sheets, Excel Online, SharePoint, Google Sheets, and with Professional, SQL Server and other databases behind your portfolio monitoring.
- A private equity firm with $40bn plus under management, 55 plus portfolio companies (the published story)
Named as the site names them. All customers.
Business for this report
Business covers Excel, SharePoint and Google Sheets, where most fund models and portfolio data collection live. Professional adds SQL Server, Oracle, ODBC and OData for monitoring platforms with a database behind them.
Questions from this industry
Can the LP report and the IC deck read the same numbers?
Yes. Both link to the same fund model. Change a figure once and both decks show it after a refresh, so they cannot drift apart.
Our portfolio companies send their numbers in different formats.
Most teams already consolidate them into one sheet or the fund model. INSYNCR reads that consolidated source, so the decks only need linking once.
Can each portfolio company get its own file?
Yes, that is what Snapshot does: one deck or one PDF per company, or one report per fund, from one template.
Is the data auditable?
Every figure on every slide traces to a cell, row or query. A reviewer can click any number and see where it came from.
The pages behind this one.
Wondering what the rebuilding costs you now? Put four numbers in and see
