How to standardize portfolio metrics?

Portfolio metrics can become inconsistent in five ways: names, definitions, source values, reporting periods, and currency. To make metrics comparable across companies, each of these dimensions must be standardized.

• Metric names: Different companies often use different labels for the same metric (e.g., MRR, Recurring Revenue, Core Revenue). Map each company's terminology to a single set of standard metric names.
  
  

• Metric definitions: The same metric name can be calculated differently. One may exclude usage-based revenue, another may include it, and a third may apply a different churn or renewal logic. Standardize the definition before comparing the numbers.
  
  

• Source reconciliation: The same metric often appears in multiple places — CRM, financial model, data room, investor update, or PDF — with conflicting figures. Define which sources take precedence and how conflicts are resolved. (e.g., “Always use the value from the official quarterly reporting template”).
  
  

• Reporting periods: Companies operate on different fiscal calendars, close books at different times, and report monthly, quarterly, or irregularly. Normalize all metrics to a common reporting timeline (typically calendar quarters or your firm’s preferred fiscal periods) before aggregating or benchmarking them.
  
  

• Currency: Global portfolios often report in multiple currencies. Define a consistent conversion methodology so exchange-rate movements do not distort portfolio performance.

You can't meaningfully compare numbers until you're confident they're measuring the same thing, calculated the same way, reported for the same period, and expressed in the same currency. Here's how to work through each one step by step.

Step 1: How to standardize metric names across the portfolio?

Maintain a central metric dictionary that maps every company-reported label to a single standard name. PortfolioIQ’s Metric Dictionary is a good reference point to begin with.

The process is straightforward:

• Set the canonical name. For each metric, pick one official name and record it in the dictionary. This is the only version your fund-level view uses.
  
  

• Capture company-specific labels. Record the exact metric names companies use.
  
  

• Map every variant back. Link each label a company uses to its canonical name. For example, "Churn ARR," "Logos Lost," and "Logo Churn" should all resolve to the same metric.
  
  

• Maintain the map, not the source. When a company introduces a new label, update the dictionary rather than changing the company's reporting.

Step 2: How to standardize metric definitions?

Once metric names are standardized, standardize the calculation behind them. The same metric name often hides different formulas, making comparisons unreliable.

• Define the formula. Record exactly how each metric should be calculated.
  
  

• Always request the key components that roll up into the final metric. A single headline figure is easy to manipulate and hard to verify. To understand and trust it, you need to see what sits underneath.
  
  

• Recompute and compare. Calculate the metric using your definition and compare it to the reported figure.
  
  

• Resolve differences. When the numbers don't match, use the recomputed value and document the adjustment.

Operating income is a common example. One company excludes stock-based compensation and one-off charges, while another includes them. Both report "Operating Income," but they are measuring different things.

In other cases, companies report different versions of the metric itself. Consider marketplace businesses, for instance. Some report gross merchandise value (GMV/GNV), while others report net revenue after their take rate. A marketplace processing $100M of GMV with a 10% take rate generates $10M of revenue, not $100M. Before comparing companies, decide whether your portfolio standard is GMV or net revenue and convert every company to that definition.

Step 3: How to reconcile a metric reported across different documents?

The same metric often appears in multiple documents with different values. When that happens, define which sources take precedence and use financial logic to break ties.

How to work it:

• Gather every instance. Find each place the metric appears across board decks, financial statements, KPI reports, and update emails.
  
  

• Rank by sources. Audited financials beat management accounts, which beat forecasts and informal updates.
  
  

• Use the underlying calculation as a check. If a metric is part of a waterfall, bridge, or formula, the correct value should make the calculation reconcile.
  
  

• Record the source used. Keep a record of which value was selected and why.

An ARR waterfall is a good example. Churn ARR may appear in both a KPI summary and the ARR bridge, with different values. The bridge provides a built-in check: beginning ARR + new ARR + expansion ARR − churn ARR should equal ending ARR. The value that makes the waterfall reconcile is usually the correct one.

When two sources are equally reliable, let the use case decide. The number used for a board presentation is not always the number needed for fund-level reporting.

Step 4: How do you align metrics across different reporting periods?

Companies report on different fiscal calendars and cadences. Before any meaningful roll-up or comparison is possible, all metrics must be translated onto a common timeline.

The method:

• Set one standard reporting calendar. Pick the periods your fund reports on and treat them as fixed.
  
  

• Map each company’s periods onto the same calendar. Translate their fiscal quarters or months into your standard calendar before comparing anything.
  
  

• Define roll-up rules by metric type. Sum flow metrics across a period and use period-end values for point-in-time metrics.
  
  

• Define how to handle partial periods. Decide how to treat incomplete months, quarters, and fiscal-year changes, so roll-ups are consistent and repeatable.

Two issues usually arise. Fiscal calendars create the first mismatch. A U.S. company’s Q1 (January–March) cannot be directly compared to an Indian company’s Q1 (April–June). Their reported Q1 figures cover different months and cannot be compared directly until both are mapped to the same calendar period.

Reporting cadence creates the second mismatch. One company may report monthly while another reports quarterly. Before creating a fund-level view, both must be converted using the same roll-up logic.

For example, if Company A reports monthly revenue of $100K, $120K, and $130K, while Company B reports quarterly revenue of $350K, both can be compared once they are expressed as quarterly revenue totals. But the same logic does not apply to metrics like cash balance or headcount, where the quarter-end value is usually the relevant measure.

Step 5: How to standardize currency across the portfolio?

Convert all metrics into a single reporting currency, but choose the exchange rate that fits the specific use case. Otherwise, currency swings get mistaken for operational performance.

The process:

• Choose a reporting currency. Use a single currency for all fund-level reporting.
  
  

• Define the conversion method for each metric. Set the rule once, so the choice is not remade by hand each quarter.
  
  

• Use the spot rate on the reporting date for valuations and fund-level returns. They should reflect current market value.
  
  

• Use constant rates for operating metrics. Revenue, ARR, and other growth metrics should exclude currency effects.
  
  

• Document the rate used alongside each figure for transparency and auditability.

The key distinction is between measuring value and measuring performance. Valuations use the FX rate on the reporting date, because the point is what the asset is worth today. Operating metrics use a constant rate, so currency moves don't show up as business growth. For example, a company growing revenue from €10M to €12M grew 20%. If the euro also strengthened against the dollar, converting both periods at spot rates overstates that growth. A constant rate isolates the real performance.

But the bigger risk comes when companies convert currency using different methodologies. One company converts at a weighted-average rate, another at period-end, a third at whatever its accounting system produces. The reported number now reflects the conversion method as much as the business.

That's why the conversion rule should be defined in the metric dictionary and the rate used should travel with the data point. A number you can't trace to a known method can't be verified or compared.