...
Private equity and portfolio reporting · Portfolio, LP and IC reporting

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+

Q3 Portfolio Review.pptxSaved to this PC
FileHomeInsert DesignINSYNCR Excel
Nordkapp LogisticsQ3 Portfolio Review
Revenue vs budget+4.2%
EBITDA18.6m
Net debt / EBITDA3.1x
EBITDA below budget turns amber
Fund model
  • Nordkapp Logistics
  • Verdant Foods
  • Kellerman Optics
  • Saltire Marine
  • Ostrand Materials
0 of 55 portfolio companies
  • 1Connect your data
  • 2Link the numbers
  • 3Color by your rules
  • 4Generate one file each
Example data
The Q3 Portfolio Review generated from the fund model, one document per portfolio company. Example data.
Short video

How to build a board pack in Microsoft PowerPoint straight from SQL Server

Pulling numbers from SQL Server into Excel every month, just so you can paste them into the board pack? You can skip the middle step.
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.

Before and after

Quarter end, two ways.

Today
  1. Each portfolio company sends its monthly or quarterly numbers
  2. An analyst types revenue, EBITDA and net debt into the portfolio review, the LP report and the IC deck, one company at a time
  3. Someone checks the three decks agree. Then a number changes and it starts again
With INSYNCR
  1. Link each deck to the fund model once. That is the last time anyone copies a number by hand
  2. When the numbers land, click Refresh. Every deck updates together, in seconds
  3. 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

The reports

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.

The first question

What this industry asks before it buys.

Our portfolio companies report on different schedules and half the data arrives late.
The answer

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.

Read that story

How it works here

Link once. Refresh forever.

1

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.

2

One file per company or fund

Filter the template per company or per fund. Snapshot generates the set, PowerPoint or PDF.

3

Refresh at quarter end

New numbers in, one click, every deck current and in agreement.

The sources you already have

Excel fund models and monitoring sheets, Excel Online, SharePoint, Google Sheets, and with Professional, SQL Server and other databases behind your portfolio monitoring.

Who runs it
  • A private equity firm with $40bn plus under management, 55 plus portfolio companies (the published story)

Named as the site names them. All customers.

Which plan

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.

FAQ

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.

Go deeper

The pages behind this one.

Wondering what the rebuilding costs you now? Put four numbers in and see

Start free trial

No credit card · Your data stays on your PC · Windows, Office 2016+