How do private equity firms monitor portfolio companies from monthly financials to quarterly valuations?

TLDR

• Monitoring a portfolio company runs from monthly financial collection to quarterly valuations, with supplemental KPIs, data integrity checks, monthly review prep, Excel model refreshes, LP data requests, one-off portfolio questions, covenant monitoring and deliverable tracking in between. Private equity firms run all ten jobs on Lumonic.

• One submission per company feeds all ten, and every number in dashboards, Excel and reports keeps its source page.

Lumonic is the system of record for credit and equity fund portfolios, with an AI power user that runs the monitoring on the firm's behalf. It reads every document the night it lands, extracts the numbers the way the firm decided once, tests covenants and budgets, and stages what moved for review. The private equity page covers the platform. The ten jobs below cover the monitoring work, from the monthly pack to the quarterly mark.

1. How do portfolio companies submit monthly financials?

Before: The pack arrives as a PDF from one company, a workbook from another and a scan from a third, and an associate retypes each one into the firm's template before any analysis starts.

With Lumonic: Portfolio companies drag the file into Lumonic or forward the email. Lumonic reads PDFs, Excel workbooks and scans, and maps each company's accounts to the firm's own schema, so revenue, gross profit and EBITDA line up across the portfolio whatever labels a company uses. Standardized file validation plus preliminary sanity checks run on the raw file at submission, so the firm's team or the company's CFO sees a malformed file before it goes any further. Mapping decisions made on one pack carry forward to the next pack from that company. Budget, forecast and actual figures sit side by side for each company and period, and Lumonic tests actuals against budget in the same run.

What it means: The month starts with mapped, checked numbers, and the reformatting hours go to reviewing results and questioning management.

2. How do you collect KPIs the financial statements leave out?

Before: Receivables aging, headcount and debt capacity get collected over email and on calls, in whatever terms the asker uses, so a company's history depends on who gathered it.

With Lumonic: A monthly form, assigned to each company, captures the metrics the financial statements leave out: receivables and payables past 30 days, debt capacity still undrawn, floating-rate exposure, headcount and anything else the firm tracks. The firm defines each field once, so every company reports against the same definition. Formula fields derive one metric from others, and reminders go to the company contact until the form is in.

What it means: Each company builds a KPI series that is comparable month to month and across the portfolio, stored next to its financials.

3. How does Lumonic keep the numbers tied to their source?

Before: A mistake surfaces weeks later, when a figure fails to tie inside a model or a board deliverable, and tracing it means reopening the original file.

With Lumonic: Three checks run on every pack, and every published number keeps its source.

• Lumonic maps sub-account lines and their totals, so each total is reconciled to its components on every submission. When a company adds a revenue account that was never mapped, the total stops tying and Lumonic flags the changed mapping before the figure is published.

• Every published number carries the document and the page it came from, down to the cell. Click the number in Lumonic or in the Excel add-in and the page opens with the source boxed. A balance sheet that does not balance shows up from the number itself during review.

• Firms that request TTM financials every month give Lumonic a view of prior periods on every submission, so a quiet revision to last quarter is caught the month it happens. Lumonic marks anything that restates a published value, stages restatements in orange with the change shown, and can alert on revisions above a threshold the firm sets.

What it means: The numbers can be defended, because each one has a page behind it and a record of how it got there.

4. How is the monthly portfolio review prepared?

Before: Each month an associate rebuilds the one-pagers from the master Excel, pasting in the new actuals, recomputing variances and rewriting the commentary, and the review meeting waits on the slowest company.

With Lumonic: The review reads the published numbers. Dashboards and one-pagers update when a company's pack is published, with budget variance already tested and whatever moved waiting at the top of the queue. The report builder turns the same views into a PDF review pack with the page behind every number. Avante Capital Partners cut portfolio review prep from two to three weeks to two to three days, and per-company metric review from about an hour to about ten minutes. LAGO Innovation Fund reports review prep that took weeks now takes days.

What it means: The review meeting runs on the numbers as they land, and preparation becomes reading the flags rather than rebuilding the slides.

5. How does the Excel plugin fit the models you already have?

Before: Refreshing a model means opening several files and copying ranges across, and each copy becomes its own version of the truth.

With Lumonic: The Lumonic Excel add-in brings Lumonic data into the workbooks the firm already uses, and one refresh updates every linked cell. Formulas can be defined once inside Lumonic, which makes Lumonic the calculation engine while Excel handles presentation. A model input opens to its source page from Excel, and values can be written back to Lumonic. Avante Capital Partners uses the add-in for LPAC and annual meeting preparation.

What it means: A refresh takes minutes instead of an afternoon, and the model reads from one record instead of a stack of files.

6. How does Lumonic change the quarterly valuation cycle?

Before: Quarter-end stacks up: financials to gather, comps to refresh and support to rebuild for every company in the same two weeks.

With Lumonic: The firm keeps its own valuation workbook. Lumonic financials come in through the Lumonic add-in and PitchBook comps through the PitchBook Excel plugin, in the same template. Saothair Capital Partners runs its year-end valuation cycle this way, with PitchBook multiples flowing into its valuation templates, and Avante Capital Partners uses its review data directly as valuation model inputs. A private equity client of Lumonic values a company in roughly ten minutes once its comp set is in place.

What it means: Quarter-end time shifts from assembling data to the judgment calls: which comps, which adjustments and which multiples.

7. How do you answer LP data requests and share monthly reporting internally?

Before: An LP asks for eight quarters of revenue, EBITDA and net debt across the portfolio, and an associate spends days assembling the answer.

With Lumonic: Because every company's data lands in one standardized record, a portfolio-wide data set is a query rather than a compilation. The Excel add-in populates the LP's own template, including the firm's existing ILPA-based template, from the Lumonic database. Firms also build LP data sets by asking Claude through the read-only Lumonic MCP, which respects each user's Lumonic role. Lumonic Reports produces scheduled, branded PDF reports from the same data through the report builder, and a monthly dashboard reaches colleagues outside the weekly portfolio call, such as the business development team.

What it means: LP requests turn around faster, read consistently quarter to quarter, and reuse the setup from the last one.

8. How do you answer a one-off question about the portfolio?

Before: A partner asks which companies missed budget two quarters running and are also late on their reporting, and the answer is a half-day project across two spreadsheets and an inbox.

With Lumonic: The question goes to chat in Lumonic in plain English, and the answer comes back as a table with the page behind every number, in Lumonic or in Excel. Chat joins the data sets a person would have joined by hand, so budget misses and reporting status arrive in one table. It also reports reporting and covenant status, edits a field with the change staged for review, and starts an extraction from an attached document. Lumonic 12.0 describes the chat and the review queue behind it.

What it means: A portfolio question gets an answer with its sources attached, and no project behind it.

9. Can Lumonic track covenants for the debt your portfolio companies carry?

Before: Covenant headroom lives in a separate tracker from portfolio reporting, each company prepares its own compliance certificate, and the firm learns about a tight covenant when the lender raises it.

With Lumonic: Lumonic was built for private credit, and covenant monitoring was the product it started with. For a private equity firm, that means the financials a portfolio company already submitted feed its covenant tests, so headroom against each lender's thresholds appears alongside the operating results. A tightening covenant shows up before the lender's certificate is due, and the owner receives the exception in Lumonic or by Slack or email. Lumonic also helps portfolio companies prepare the compliance certificates they owe their lenders from the same tested figures. Most portfolio companies carry debt, and this sits on top of the monthly operating view for firms that want that visibility.

What it means: Covenant pressure is visible early enough to act on, and a lender's call is no longer the early warning.

10. How are tax returns, K-1s and board materials tracked?

Before: The list of what each company owes lives in a spreadsheet, the chasing happens from an inbox, and nobody is sure what is outstanding until someone asks.

With Lumonic: Each recurring deliverable is set up once per company with its due date, and Lumonic sends reminders to the company contact that stop automatically when the item arrives. A per-company checklist shows each item as submitted, partial or past due, and the documents are stored in Lumonic next to the financial data they support. LAGO Innovation Fund reports no more reminder emails and no more wondering which companies are late.

What it means: Chasing becomes a status board instead of an email thread, and there is one answer to what is outstanding.

What the ten jobs have in common

A document lands, a form is submitted or a schedule fires. The power user reads it and proposes the numbers, using the same tools the firm's analysts use, within their permissions and extraction rules. Lumonic checks for restatements, missing values, changed mappings and formula health, and stages each change with what moved shown. The firm approves, run by run or by rules that publish when every check passes. Then the record updates, and dashboards, the Excel add-in, Lumonic Reports and the MCP all read the same numbers with the same page behind each one.

Who this fits

• Private equity firms collecting monthly financials and KPIs, refreshing Excel models, running valuations and answering LP requests from one set of numbers.

• Firms whose portfolio companies carry debt and want covenant headroom next to operating results without a second system for it.

• Institutional firms that need review and publish steps where their controls require them, every change logged, SOC 2 Type II certification.

Questions to put to your own team before choosing a platform

• Where does the most time go today, in hours per month, and which of the ten jobs would recover the most of it?

• Which companies in the portfolio would be the hardest to bring onto a platform, and why: format, cadence or the finance team's bandwidth?

• Which step in the current process would the team be least willing to hand over, and what does that step protect?

Frequently asked questions

Does a portfolio company have to change its reporting format or style to fit a template?
No. Each company keeps its own formats. Lumonic maps them to the firm's schema once, and the mapping carries forward to the next pack.

Are PitchBook comps inside Lumonic? PitchBook comps reach the valuation workbook through the PitchBook Excel plugin, alongside Lumonic financials from the Lumonic add-in. There is no native comps screen inside the platform today.

Can the deal team keep using its Excel models? Yes. The Lumonic add-in refreshes data in existing workbooks, with dashboards and chat as other ways in.

Can a firm start with a few companies? Yes. Saothair Capital Partners began its rollout with a small cohort before extending it across the portfolio.

Run it on your own documents

Give us the documents from your last reporting cycle and we'll run them through Lumonic. You'll see the data extraction we'll put up against anyone you're evaluating, run on your own documents, with every number traced back to the page it came from. Hold anyone else to the same test. Request a working session.

Disclaimer

This article was written by Lumonic, a PitchBook company, and reflects Lumonic's views as of October 2026. It describes Lumonic's own product as it stood at the time of writing, and features, pricing and positioning may have changed since this article was last updated. Customer outcomes attributed by name are taken from the published customer stories linked in the text, anonymized outcomes are Lumonic's own observations of client use, and nothing here is a guarantee of results. General statements about industry practices, spreadsheet-based workflows or other tools are Lumonic's own observations and are not statements about any particular vendor or product. Where the text links to third-party sources, those sources speak for themselves and Lumonic has not independently verified them. If you believe a statement is inaccurate, contact support@lumonic.com and Lumonic will review and correct it.