...
Private equity and portfolio reporting · Portfolio and ESG scorecards

One scorecard per portfolio company, every year, from one template.

Sustainability scorecards, portfolio reviews, LP reporting. A private equity firm with 55 plus portfolio companies took four months of one analyst's year to produce its annual scorecards by hand. Linked once, the same set refreshes and generates in two to three hours.

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

Sustainability Scorecard.pptxSaved to this PC
FileHomeInsert DesignINSYNCR SharePoint
Nordkapp LogisticsSustainability Scorecard
Scope 1 and 2-12%
Board diversity38%
Data coverage94%
A red score colours the row
ESG register
  • Nordkapp Logistics
  • Verdant Foods
  • Kellerman Optics
  • Saltire Marine
  • Ostrand Materials
0 of 55 portfolio companies
  • 1Connect the source
  • 2Bind the shapes
  • 3Rule the formatting
  • 4Generate one per record
Example data
The Sustainability Scorecard generated from the esg register, one document per portfolio company. Example data.
The reports

What this industry runs on INSYNCR.

ESG and sustainability scorecards

One scorecard per company, the same layout, the numbers from the data collection each company returns.

Portfolio and LP reviews

Quarterly packs where every figure has to reconcile with the fund model.

Board packs for portfolio companies

The same template across the portfolio, one file per company, refreshed at each cycle.

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 one scorecard

Bind the first company's scorecard to the sheet or database that holds the data.

2

Generate the set

Snapshot runs it for every company: one file each, Microsoft PowerPoint or PDF.

3

Refresh next year

Same template, new data, the same afternoon.

The sources you already have

Excel and Excel Online, SharePoint, SQL Server, the fund model, the ESG data collection sheet.

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.

"That saved us four months of work."
ESG Analyst, private equity
Which plan

Business for this report

Business covers Excel, SharePoint and Google Sheets, where most portfolio data collection ends up. Professional adds the databases.

FAQ

Questions from this industry

How long does the first scorecard take to link?

In the published case, the first company was linked and the rest generated in one click the same day. Plan a morning for the first template.

Can each portfolio company get its own file?

Yes, that is what Snapshot does: one deck or one PDF per company, 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+