Case studiesCase study · Venture Capital

Messy founder financials into clean SaaS metrics

Every portfolio founder sent numbers in a different shape. We built the fund a pipeline that ingests any format, consolidates each company into one record, and calculates the SaaS metrics automatically.

A B2B SaaS growth fund · portfolio financial monitoring

This client asked to remain anonymous.

Industry
Venture Capital
Use case
Portfolio monitoring · financial ingestion · SaaS metrics
Headline result
Any format, one clean record per company
01 · The challenge

Where the time was going

Every founder in the portfolio reported differently: a spreadsheet here, a PDF export there, a screenshot of a dashboard, a cut of the accounting system. Before anyone could look across the portfolio, someone had to hand-key each company's numbers into a common shape, every reporting period, and hope nothing was mistyped along the way.

  • Founder financials arriving in a different format from every company.
  • Hours of manual re-keying before any number could be compared.
  • SaaS metrics recalculated by hand, inconsistently, each period.
  • No single, trustworthy record to look across the portfolio from.
02 · What we did

DealSage, on their reporting

We built the fund an ingestion pipeline that takes founder financials in any format, extracts and reconciles the figures, and consolidates each company into one structured record. From that record, DealSage calculates the fund's standard SaaS metrics automatically, the same way, every time.

  • Ingests any format: spreadsheets, PDFs, exports, accounting cuts.
  • One consolidated, structured record per portfolio company.
  • ARR, NRR, burn, runway and the rest, calculated automatically.
  • Every figure traced back to the founder document it came from.
03 · How it works

Three steps, one workflow

Step 01IngestFounder financials come in however they come, and DealSage extracts and reconciles the figures regardless of format.
Step 02ConsolidateEach company lands as one structured record, in the fund's standard shape, with lineage back to the source.
Step 03CalculateThe SaaS metrics compute automatically off that record, consistently across the whole portfolio.
The results
Any formatfounder financials ingested, no re-keying
1 recordconsolidated per portfolio company
Every metricSaaS KPIs calculated automatically
Citedevery figure traced back to source

The compounding win is comparability. Once every company reports into the same structured record, the fund can look across the whole portfolio in one view, spot the outliers, and trust that the metrics were calculated the same way for each company, rather than reassembled by hand every quarter.

“Reporting used to be a re-keying exercise. Now the numbers land consolidated and the metrics are just there.”
Partner · Portfolio Operations

Want this on your deals?

We connect your stack, keep your AI assistant, and have your team asking real questions in under two weeks.