Blog · Territory, capacity and quota planning · Finance and FP&A teams
FP&A in private equity portfolio companies compares operating results with approved plans on a common basis. Build a reporting file, calculate company variances and reconcile the portfolio total with exact spreadsheet formulas.
FP&A private equity reporting compares portfolio-company operating plans with actual results on a common basis. The useful output is a reconciled explanation of which company, revenue line or cost category changed the result, with a manager responsible for the next action. Start with the operating companies' files and preserve the link back to their closed accounts.
The general FP&A definition covers planning, forecasting and explaining financial performance. In a portfolio setting, the extra work is making separate company submissions comparable without erasing their differences.
Agree the reporting month, currency, budget version and business perimeter first. Identify which locations and acquired businesses belong in each comparison. If an acquisition entered actual results after the budget was approved, show its effect separately before describing the remaining difference as operating performance.
Keep the local account code alongside the common reporting category. A company may record freight in direct costs while another puts it in operating expenses. A mapping can display both under a common definition, but finance must approve the classification. Do not silently change a company's accounting records to make its margin resemble another company's.
The workflow below compares company operating results. It does not value investments, calculate fund returns or determine transaction adjustments. The FP&A consolidation guide covers combining department and entity submissions in more detail.
Use the approved operating budget and the closed general ledger for the same month. Retain company, source account, reporting category, period, version, currency and amount in the supporting file. When producing the comparison sheet, summarize each company into matching budget and actual rows.
For this fictional US portfolio, the figures below cover September 2026 in USD. Direct costs and operating expenses are positive expense amounts. The operating-expense line includes all other operating charges under the example's common definition; there are no additional operating categories or reporting adjustments.
Put these rows in A1:G7. Columns E:G are calculated; column F contains the reporting sign.
| Company | Reporting line | Budget (USD) | Actual (USD) | Actual minus budget (USD) | Result sign | Result effect (USD) |
|---|---|---|---|---|---|---|
| Harbor Components | Revenue | 1,200,000 | 1,150,000 | -50,000 | 1 | -50,000 |
| Harbor Components | Direct costs | 480,000 | 470,000 | -10,000 | -1 | 10,000 |
| Harbor Components | Operating expenses | 420,000 | 440,000 | 20,000 | -1 | -20,000 |
| Mesa Services | Revenue | 800,000 | 840,000 | 40,000 | 1 | 40,000 |
| Mesa Services | Direct costs | 320,000 | 344,000 | 24,000 | -1 | -24,000 |
| Mesa Services | Operating expenses | 300,000 | 306,000 | 6,000 | -1 | -6,000 |
In E2 and G2, enter these formulas and fill down through row 7:
=D2-C2
=E2*F2
A positive result effect improves the operating result. This sign convention makes a cost saving positive even though actual expense minus budget expense is negative. Keep the raw expense variance too; the reporting sign should explain the bridge, not overwrite the source amount.
Operating result = Revenue - Direct costs - Operating expenses
Result variance = Revenue variance - Direct-cost variance - Operating-expense variance
For Harbor, the budget result is $1,200,000 minus $480,000 minus $420,000, or $300,000. Actual is $1,150,000 minus $470,000 minus $440,000, or $240,000.
In Excel, SUMPRODUCT multiplies corresponding values and sums the products. Use the reporting signs to calculate Harbor's budget and actual result:
=SUMPRODUCT(C2:C4,F2:F4)
=SUMPRODUCT(D2:D4,F2:F4)
Use rows 5:7 for Mesa. The complete result is:
| Company | Budget result (USD) | Actual result (USD) | Result variance (USD) |
|---|---|---|---|
| Harbor Components | 300,000 | 240,000 | -60,000 |
| Mesa Services | 180,000 | 190,000 | 10,000 |
| Total | 480,000 | 430,000 | -50,000 |
The combined shortfall is $50,000. Do not average company percentage variances to obtain the portfolio variance. The common dollar bridge is additive; percentage comparisons need a stated denominator and comparable definitions.
For a larger comparison sheet, put a company name in J2 and sum its effects with:
=SUMIFS($G$2:$G$7,$A$2:$A$7,J2)
SUMIFS adds values that meet the specified criteria. Extend the criteria to period and budget version when those columns are present. Without those filters, a workbook containing several months or forecasts can produce a plausible but incorrect total.
Harbor's bridge is $300,000 minus $50,000 plus $10,000 minus $20,000, which equals $240,000. Mesa's is $180,000 plus $40,000 minus $24,000 minus $6,000, which equals $190,000.
The combined proof is therefore $480,000 minus $50,000 equals $430,000. Check it directly against the source rows:
=SUMPRODUCT(D2:D7,F2:F7)-SUMPRODUCT(C2:C7,F2:F7)-SUM(G2:G7)
The answer must be zero. All amounts in this example are whole dollars; no rounding is needed. Also reconcile each company's budget and actual categories to its submitted totals. The arithmetic proof cannot detect a ledger account omitted from both the comparison and its bridge.
Ask Harbor's commercial owner to explain the revenue shortfall and its expense owner to explain the operating-expense increase. Ask Mesa whether the higher direct costs reflect more activity, a different service mix or higher unit costs. The table identifies questions; it does not establish the causes.
Keep each explanation beside its company, reporting line, supporting file, owner and expected next update. Distinguish timing from an enduring change before revising a forecast. A delayed shipment and a lost customer can produce the same monthly revenue variance while requiring different responses.
Use FP&A goals to assess whether material explanations arrive on time. For the evidence behind narrative reporting, see AI for financial analysis.
Covirage is not affiliated with Microsoft.
Bring a sample of your own company budgets, actuals and common reporting categories. Covirage maps the uploaded columns; its tools compute and check the variances, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your file.
See Covirage for finance teams for the reporting context.
The company finance team maintains operating budgets, compares results with those budgets and explains changes in revenue, costs and cash requirements. It supplies management with evidence for operating decisions and reports agreed measures to the owner using consistent definitions and reporting dates.
Yes. Keep the original account code and map it to a common reporting category. Check that every relevant account maps once and that mapped totals equal the original company totals. Review classification differences before comparing margins or operating variances.
Only use an adjusted measure with a documented definition and a separate reconciliation to the underlying accounting result. Keep adjustments visible by company and period. A management reporting calculation does not determine an acquisition valuation or establish the meaning of a debt agreement.