Solutions · Spend management
Spend visibility across a portfolio.
Every company's monthly file checked, consolidated and traceable to its source. Analytics, not approvals or payments. Built around your categories and your model, and yours to extend.
One company, one quarter, as stored
- 7 AprSpend file rejectedMarch file. 11 rows carry a category that is not in the list0 rows
- 8 AprSpend file acceptedCorrected file · 284 suppliers3,906 rows
- 15 AprInitiative createdCloud consolidation · status Pipeline
- 2 MayInitiative updatedIn progress · stage gate Approved
- 6 JunSavings realisation updatedMay: actual and forecast entered against plan
- 1 JulPortco financials createdQuarter inputs entered. Impact on EBITDA calculated
Event names from the spend analytics system that runs at a private equity firm. Dates, counts and the initiative are invented.
Running it today
The portfolio view of spend is a slide nobody can trace.
If you lead value creation or procurement for a private-equity portfolio, you do not run the purchasing of the companies you hold. You receive their files. Each month every portfolio company prepares a spend file and sends it over, usually by email.
Then the questions start. Who has filed and who has not. Whether this month has the same columns as last month. Whether "Marketing" means the same thing in two companies. Whether the savings an initiative claimed ever showed up in the numbers.
Until those are settled, the consolidated picture is assembled by an analyst for each review. A figure on it cannot be followed back to the file it came from, and last quarter's version is whatever was saved at the time.
Why own it
Your categories and your value model are not a vendor's to define.
Spend management products are mostly built for one company controlling its own purchasing: requests, approvals, cards, payments. A portfolio owner is in a different position, and a generic data model built for a single buyer does not describe it.
A reporting dashboard gets closer, but it draws whatever it is given. It does not refuse a bad file, remember which file a number came from, or hold savings, contracts and financial inputs against the same companies and categories.
What makes the picture yours is the detail a vendor will not carry: your category list and how deep it goes, the columns your companies can really produce, your formula for savings and for impact on value. Those change as the portfolio changes. When you own the system, a new company or a revised formula is your decision, made when you need it.
What an owned system records
A file is accepted or rejected, and either way it is recorded.
In the system that runs at the private equity firm, each company is registered once, under the exact name its files use. An uploaded file is checked twice: first its format, then its data. A file that fails is recorded as rejected, with its errors, and none of its rows are counted. A file that passes is stored in full.
The spend analysis reads from validated rows only: spend over time, by category, company and supplier. Contracts, savings initiatives and a quarterly model of impact on value are held beside it, against the same registered companies. Because each of those is an event on one record:
- Trace. Spend totals can be filtered by company, date range, category and supplier, and every accepted file is listed with its row count, total spend and supplier count.
- Correct on the record. A corrected file is a new upload, and the rejected one stays on the record with its reasons. Uploading again for a month that already has data asks for confirmation and states how many records will be replaced.
- Reports that draw on history. Savings planned against realised, and each quarter's inputs as they stood, are read from what was recorded at the time.
Already handled
The hard parts, already built once.
Each of these is a case a portfolio data team meets every month, modelled in the system built for a private equity firm.
Private equity firm: Spend analytics case study
The late filer
Every active company with no accepted file for the period is listed as pending, with a due date and days past due. A reminder is logged as an event against the company.
Private equity firm: Spend analytics case study
The file that is nearly right
An unknown category or a missing column rejects the whole file, and the reasons are kept. An unknown contract reference is a warning and does not block it.
Private equity firm: Spend analytics case study
One category list across spend, contracts and savings
Spend, contracts and savings use the same list of categories, so a category means the same thing on each screen.
Private equity firm: Spend analytics case study
Credits and reversals
Negative rows are supplier credits or reversals. They are valid, and they are included in totals instead of being filtered out.
Private equity firm: Spend analytics case study
One contract, several companies
A group contract is stored once for each company it covers, under the same contract reference, so it appears against every company it covers.
Private equity firm: Spend analytics case study
A status nobody types
A contract's status is worked out from its expiry date, not entered by hand, so it does not go stale when nobody updates it.
Private equity firm: Spend analytics case study
Savings claimed against savings realised
Each initiative has a status, a stage gate and one record per period: planned, actual and forecast. "At risk" is a flag a person sets, and the event says who.
Private equity firm: Spend analytics case study
History in the value model
Each quarter's financial inputs are a new snapshot, so last quarter's figures and what they implied are still there.
The first build
The first build describes your portfolio and its files.
The first build is where your operation gets described. For spend visibility that means sitting with the people who chase the files and the people who read the result, and writing down what each company can really send.
Entities
The things your operation keeps track of.
- Your companies, under the names their files use
- Your categories, and how deep they go
- Suppliers, contracts and initiatives
- Your reporting periods and currency rules
Events
What happens to them, in your words.
- File accepted or rejected
- Contract recorded
- Initiative created and updated
- Savings and financial inputs entered
Exceptions
What happens when it does not go to plan.
- The company that has not filed
- A file with the wrong columns or categories
- Credits, reversals and group contracts
- Your formulas for savings and impact on value
What carries forward from the foundation
The event log, roles and permissions and reporting are already written. In this system data arrives by upload, in one currency; nothing is pulled from an accounting system. If what you need is approval and payment control inside one company, that is a different system. Phlo has approval chains, in use in the procurement systems, but they were not part of this one.
What comes after
Each new company and each new question sits on the same record.
Once validated spend is on record, the next step is an addition: another portfolio company, a further category level, a new view for the board. Each reads the history already held. It extends without a migration.
After the first build the framework becomes available to you. Your own engineers and product people can build the next system on it, or we carry on building for you. Both stay open, and the terms are settled in the first conversation, scoped to the engagement.
Get started
Tell us what your companies can actually send you.
The columns they can produce, the categories you want, and the questions the board asks. The first conversation is about your portfolio, not a demo.
coffee@jetbro.inWhatsApp +91 90999 62227
