Know where every dollar sits, and who pays for it.
Cashflow forecast to the month. Claims in one click.
PowerCAPEX reconciles your accounts against the work breakdown structure, forecasts cashflow at every level of the programme, and applies each funding agreement automatically. When a claim is due, it comes out in one click, with the ratios that applied on the day.
Built on Microsoft Power Platform · Sign in with your Microsoft account · Works with Xero and Excel
Your accounts are built for auditors. Your programme needs something else.
Accounting ledgers record what was paid. ERPs won't hold a work breakdown structure that keeps changing shape. Almost nothing forecasts cashflow, and programmes with several funders defeat every tool on the market. So the real picture ends up in one person's spreadsheet that nobody else can read.
| What the programme needs | Accounting system | ERP / job costing | Spreadsheet | PowerCAPEX |
|---|---|---|---|---|
| Every transaction coded to the WBS | Partly | Yes | By hand | Yes |
| WBS that can change shape mid-programme | No | Hard | Yes | Yes |
| Cashflow forecast at every tier | No | Rarely | By hand | Yes |
| Several funders, each with its own rules | No | No | Fragile | Yes |
| Claim produced with the ratios on the day | No | No | By hand | One click |
| Board and funders can look for themselves | No | Licence per seat | Emailed copies | Web portal |
From the ledger to the claim, in four steps.
Bring in the transactions
A live feed from Xero, or a standard spreadsheet import from any accounting system. History comes across once; new costs keep arriving.
Reconcile to the WBS
Each cost is matched to a line of the work breakdown structure. Anything uncoded is flagged, so nothing sits outside the model.
Forecast the cashflow
Six fields per line produce a month-by-month forecast, rolled up to every tier and split by funder.
Report and claim
Board, funders and the team see the same numbers in the portal or in Excel. Claims come out with the right split, already checked.
Six fields per line. A forecast you can keep up to date.
A project manager can maintain this in minutes a week. Change a date or a curve and the cashflow for that line, its stage, its funder and the whole programme moves with it.
01Estimate02Contingency03Start04Finish05Spend curve06Progress
Try it. The example is one construction line from the demo programme.
Everything a capital programme reports on, in one model.
One source of truth. The portal, the reports and the Excel tables all read the same stored figures, so two people never see two answers.
A WBS that can change shape
Three tiers, any depth of detail. Add, split and re-code lines as the programme evolves, without breaking history.
Forecast at every tier
Monthly or cumulative, actual against projection, for a line, a stage, a funder or the whole portfolio.
Funding agreements, held as rules
Many funders, many buckets. Shares, caps and conditions per funder, so each cost lands against the right party automatically.
One-click claims
Cut a claim at any date. The split uses the ratios that applied on the day, and a claim register keeps every one on file.
QA checks and unclaimed work
Flags uncoded costs, overruns and lines past their finish date, and shows work done but not yet claimed.
A portal for the board and funders
Interactive Power BI reports in a secure web portal. Filter by stage, resource or funder. No Power BI licence needed.
PowerCAPEX for Excel
Insert the cost summary, WBS lines, funding split or cashflow into any workbook, and refresh them from the live model.
Change log and audit trail
Every change to an estimate, date or funding rule is recorded, with who made it and when. Completed lines can be frozen.
The right view for each person
Viewer and contributor roles per project. Sign in with Microsoft. Funders and board members request access in one step.
The part nothing else does.
Crown money, council share, a private partner. Each with its own rules about who pays for what, at what share, up to what cap. PowerCAPEX holds the agreements themselves.
- Every cost lands against the right bucket and the right funder
- Cashflow forecast per funder as well as per programme
- Claimed to date, this claim, and remaining to claim, always current
- Ratios that change over time are applied as they stood on each date
Built to be kept up to date by the person running the job.
The WBS app is where the team works: estimates, dates, curves, resources and milestones side by side, with the cashflow updating as you type.
- Base estimate and most-likely total on every screen
- Tick a line done to freeze it at actual cost
- Group by stage, resource or milestone
Your numbers, in the spreadsheet you already use.
The PowerCAPEX add-in puts live tables into any Excel workbook on Windows, Mac or the web. Build your own pivots and board papers. One button refreshes them all.
- Cost summary, WBS lines, funding by funder, cashflow by month
- Read-only copies, so the model stays the source of truth
- Same sign-in as the portal
One model. Three people who stop arguing about the numbers.
Programme and project managers
What will this stage cost, and when?
Keep the forecast current in minutes, not a monthly spreadsheet rebuild. See overruns and unclaimed work before anyone asks.
Finance and commercial
Does the model agree with the ledger?
Every transaction reconciled to the WBS. Claims split correctly. Cashflow ready for treasury and the bank.
Boards, funders and owners
Are we on budget, and what do we owe?
A live portal instead of a board pack. They answer their own questions, on the spot, from the same numbers.
Made for programmes where the money and the ground have to keep talking.
Land development and subdivision
Stage-by-stage cost and cashflow from consent to titles. Show the bank and your investors a forecast they can check.
Local government and infrastructure
Capital works programmes across many projects and contracts, with a clear line from each cost to the budget that funds it.
Government and co-funded delivery
Funding agreements with milestones, shares and caps. Claims that match the agreement every time, and a record to show the auditor.
Joint ventures and partnerships
Several parties, one programme. Each partner sees their share of cost, cashflow and what they owe, from the same model.
Community and iwi developments
Housing and facilities funded from several sources, reported clearly to trustees, members and every funder.
Client-side project managers
Run cost control for several clients from one method, and hand each of them a portal instead of a monthly report.
Works with the systems you already run.
PowerCAPEX sits between your accounting system and the people who need the numbers. It is built on Microsoft's own platform, so it fits an organisation that already runs on Microsoft 365.
Comes in
- Microsoft Power Apps
- Microsoft Dataverse
- SharePoint lists
- Power BI model
Goes out
Your project, kept separate and on the record.
Your own environment
Each client gets its own Power Platform environment, SharePoint site and reporting workspace. Nothing is shared between clients.
Microsoft cloud, Australia region
Data is held in Microsoft's Australian data centres, under Microsoft's own security and compliance.
Roles and access requests
Viewer or contributor, per project. New people request access and are approved before they see anything.
Audit log
Sign-ins, changes and claims are logged, so you can show a funder or auditor exactly what happened and when.
A subscription sized to the programme.
Priced per project, not per user, so the board and every funder can have a login at no extra cost. Every plan includes setup, the portal, the Excel add-in and support from the person who built it.
Project
For a single development or capital project that has outgrown its spreadsheet.
- WBS, cashflow and cost control
- Spreadsheet import
- Portal and Excel add-in
- Unlimited viewers
Programme
For co-funded programmes where each cost has to land against the right funder.
- Everything in Project
- Funding rules and one-click claims
- Claim register and QA checks
- Per-funder cashflow
Portfolio
For councils, developers and funders running several programmes at once.
- Everything in Programme
- Portfolio roll-up and reporting
- Custom analysis tags and reports
- Priority support
From your spreadsheet to a live portal.
You don't start from a blank page. Your current budget, history and funding agreements are the starting point.
Demo call
30 minutes on your programme, with the demo project on screen.
Map it
Your WBS, funders and agreements, written down with you.
Set it up
Your own environment, site and portal, configured to your structure.
Bring the history
Past transactions imported and reconciled, so the model starts true.
Go live
Logins for the team, board and funders. Training on the job.
Bring PowerCAPEX to your clients.
Firms that already advise on capital programmes can offer PowerCAPEX as part of their service.
Referral and delivery partners
You keep the client relationship. We set up and support the platform. You get a tool that makes your advice visible, and a share of the subscription.
Built on Microsoft
PowerCAPEX runs on Microsoft Power Platform, Dataverse, SharePoint and Power BI, and plugs into Excel. Your IT team already knows how to look after it.
Accounting feeds: Xero live, other ledgers by import.
“When a programme needs an instrument nobody sells, I don't write a business case for one. I make it.”William Loppe · KPMO · Kaikōura, New Zealand
PowerCAPEX was built by a programme manager, for the programmes he runs: nineteen years of capital works across three continents, including the post-earthquake rebuild of Kaikōura's infrastructure. It is designed, written, deployed and supported by the same person, so the person who answers your question is the one who built the feature.
More about KPMO →Frequently asked.
Does it replace our accounting system?
No. Xero or your ledger stays the record of what was paid. PowerCAPEX reads from it and adds what it can't do: the WBS, the forecast, the funding rules and the claims.
Do our board and funders need Power BI or Microsoft licences?
No. They sign in to the web portal and see interactive reports. Pricing is per project, so extra viewers cost nothing.
We use MYOB, not Xero. Will it work?
Yes. Transactions come in through a standard spreadsheet import from any accounting system. A live Xero feed is available as an add-on.
Can it handle funding shares that change during the programme?
Yes. Funding rules are held with the dates they apply from, and each claim uses the ratios as they stood on its date.
How long does setup take?
It depends on how much history and how many funding agreements come across. We agree a plan after the mapping step, and your existing spreadsheet is the starting point.
Where is our data held?
In Microsoft's cloud, Australia region, in an environment and SharePoint site set up for your organisation alone.
Can we try it first?
Yes. The demo shows a real programme structure with fictional names and figures. Book a call and we'll walk through it on your questions.
See your programme in PowerCAPEX.
Thirty minutes, on screen, with the demo project. Bring your current spreadsheet and your trickiest funding agreement.
- william.loppe@kpmo.co.nz
- Support
- support@kpmo.co.nz
- Clients
- Log in to the portal or create an account
- Based
- Kaikōura, New Zealand. Works with clients anywhere.