The short answer
A monthly PE reporting package connects earnings, liquidity, planning and actions on one reconciled data basis. It shows management and the finance operating partner what has changed, why it changed and which decision follows. That requires clear definitions, a fixed reporting date and a documented sign-off.
The working template behind this article is a compact monthly report with a budget-to-actual comparison, an EBITDA bridge, a cash bridge and an action list. It contains fictitious example data only, in EUR thousand. It is a starting point for aligning with the shareholder and replaces neither the bookkeeping nor a full group consolidation.
Working template: the Excel file is available in German on the German version of this article; its structure and the worked example are described in full below.
Jump to a section: What the template contains · The building blocks of a PE reporting package · From findings to ongoing steering · Common questions
What the template contains
- One fully calculated reporting month with fictitious values in EUR thousand.
- Budget-to-actual comparison, EBITDA bridge and cash bridge.
- An action list with owners and next steps.
Check the definitions first, then replace the example data. The package shows a single monthly report; consolidation and individual financing agreements are added separately.
Which questions the report should answer
- Are earnings and the material operating drivers on plan?
- Which variances are one-off and which change the expected trajectory?
- How have bank balances, working capital and the funding requirement developed?
- Which actions have been decided, who delivers them and by when?
- Which risks or decisions do management and shareholders need to address now?
The choice of metrics follows the business model and the investment thesis. A software company needs different operating drivers than a manufacturer. The definitions have to remain traceable across reporting periods and entities.
The building blocks of a PE reporting package
Management summary
Start with a few essential statements: the most important variance, its effect on earnings or cash, and the decision required. Separate confirmed facts, assumptions and information still outstanding. A report with unresolved numbers can be marked as preliminary. Open items get an owner and a date.
P&L and budget-to-actual comparison
Compare the same period, the same entities and the same accounting basis. In a German portfolio company that last point matters: the entity keeps its statutory accounts under HGB (the German Commercial Code, whose accounting rules are oriented to creditor protection and the tax balance sheet), while the fund usually reads a management or IFRS view — the two must be reconciled, not shown side by side. The monthly comparison shows the current development. In regular use, year-to-date figures, a prior-year comparison and the current full-year outlook are added. The template concentrates on one month so that calculations and definitions stay verifiable.
EBITDA bridge
Show operating EBITDA and every adjustment separately. Document the reason, amount, period, evidence and approval of each adjustment. A one-off expense may already have been paid. Removing it from an adjusted earnings metric does not reverse the cash outflow.
The adjusted EBITDA used for management is not automatically the EBITDA of a loan agreement or of a later purchase-price negotiation. These definitions are kept expressly separate and tied to their respective sources.
Cash bridge and working capital
The cash bridge links the opening balance to the actual closing balance. It separates operating result, non-cash corrections, the change in working capital, capital expenditure, taxes, interest and financing. The calculated closing balance is compared with an independently entered bank balance.
The simplified template defines operating working capital as trade receivables plus inventories minus trade payables. Other operating balance sheet items have to be added where needed. EBITDA, revenue and ARR are not treated as cash receipts.
Forecast, financing and actions
The report explains which finding changes the next forecast. A full operating set-up adds the short-term cash forecast and the relevant financing requirements. For contractual metrics, the definition, measurement date, threshold, actual value and expected headroom are taken from the specific agreements.
The action list stays short enough for a review. Every action carries its trigger, owner, date and documented evidence. An expected effect is shown as an expectation until its realisation is proven.
A worked example
Fictitious month, all amounts in EUR thousand: With 1,200 revenue, 560 direct costs, 420 personnel costs and 140 other operating costs, EBITDA comes to 80. Budget is 150. The variance of minus 70 consists of minus 50 revenue, minus 10 direct costs, minus 20 personnel costs and plus 10 other costs.
A separately documented adjustment of 20 produces an adjusted EBITDA of 100. The template counts it towards the adjusted metric only once evidence and approval are recorded. The operating EBITDA variance remains minus 70.
The bank balance starts at 500. From 80 EBITDA, minus 60 additional working capital, minus 30 capital expenditure, minus 15 taxes paid, minus 10 interest paid and minus 20 loan repayment, the closing balance comes to 445. All other items are zero in the example. Any difference to the actual bank balance remains visible as a reconciling item.
How the monthly process runs
- Before the close: confirm the entity scope, data sources, metrics and recipients.
- Once actuals are available: reconcile accounts, material movements and, where applicable, the consolidation.
- While preparing the report: explain budget-to-actual variances and assess the effect on cash and forecast.
- In the management review: document decisions, actions and items still open.
- At sign-off: record version, preparer, reviewer and distribution list.
Deadlines follow the agreed reporting obligations and the closing process. A dashboard on its own does not replace this sequence.
Typical mistakes
The most disruptive are shifting EBITDA definitions, differing entity scopes, uncommented manual adjustments and missing reconciliations to the bank balance. A percentage comparison against a budget value of zero also needs an explanation. The template shows “n/a” for that case and keeps the absolute variance.
If the close is not reliable, the improvement starts in bookkeeping and close preparation. If reliable actuals exist but the forward view and analysis are missing, FP&A is the support that helps.
Building reporting with nugrow
We clarify recipients, reporting requirements, the state of the data and responsibilities. An agreed engagement can cover metric definitions, a first reconciled reporting package, a reporting calendar and the handover to the internal team. Ongoing preparation, analysis or finance leadership are scoped separately as needed.
Discuss PE reporting. The overview for private equity shows the roles available. The engagement references give an insight into previous assignments.
From findings to ongoing steering
Unclear starting conditions can be structured with a finance assessment. The next step after a reliable monthly report is building out FP&A. Our articles on covenant reporting and the 13-week cash flow forecast complement this.
Common questions
What belongs in a monthly PE report?
A management summary, comparable actual and budget figures, traceable earnings and cash bridges, and actions with owners. Forecast, operating metrics and financing requirements are added to fit the company and its agreements.
Is the reporting package a complete financial model?
No. The template shows a single reporting month with fictitious data, traceable calculations and a cash reconciliation. Consolidation, a full balance sheet, annual planning and individual covenant calculations are not included.
How are EBITDA adjustments handled?
Operating EBITDA and adjustments are shown separately. An adjustment needs a documented reason, evidence and an approval. Definitions for management, the loan agreement and a transaction are each agreed separately.
Sources and status
The reporting grid and the example data are working materials prepared by nugrow. The importance of reliable data and its link to value creation is also covered in PwC's findings on the finance function in PE portfolio companies. No performance promises for the template are derived from it. As of September 2026.
