What are Cost Value Reconciliations (CVRs) in construction?
According to the DesignBuildings wiki, cost value reconciliation is used to monitor and measure expenditures against the budget on a construction budget. All of the expenses for the previous period are gathered and added up to see all of the current costs. The current cost value is relevant to see how much has actually been spent on the project already.
In addition to that, additional data can be included in the reporting to show the final ending point of the project. These can include the actual done work in the field, variations in subcontracts, bids for upcoming jobs, and price adjustments for materials. Using these additional metrics for the report can show potential budget overruns and problem locations already in advance.
Why are CVRs required for construction projects?
CVRs are very important for construction projects because they provide the current status of the project. You are able to somewhat accurately predict the future profitability of the project by putting this report together. It is especially relevant for construction contractors since the sum of all of their construction project profitabilities adds up to the profitability of the whole project.
Without doing CVRs, you are just going through the project blindly and will only find out the profitability and the total cost of the project when it ends. In many cases, this is too late. It can be very bad for your client as well since they have no way of figuring out how much money they are going to have to pay you during the whole project. And how much during the next months.
Not having this info can easily put you into the 25% of construction companies at risk of bankruptcy. If you do have this information in advance, you can warn your customer beforehand or get credit from the bank. That could help you react early enough to avoid cash flow issues and bankruptcy threats. If you also keep in mind that 9 out of 10 projects experience cost overrun, the necessity will be even more clear.
When you do have the reports without having made any calculation mistakes, life is good. You can use the data from similar past projects and directly account for the estimation mistakes and price increases. Past data will clearly show why something was cheaper or more expensive.
What key metrics do CVRs provide?
The CVR process in a nutshell is taking all incomes from the client, expenses, variations, and inputs from the market (subcontractor and vendor bids) and adding all of these numbers up on a job level in the budget. When all of the number-crunching has been done, then you can use the data to extract various project key indicators.
Depending on the financing model and contract type with the customer, the KPIs might be only internal for the contractor or also shared with the client. It is even possible that two different reports are put together since the company might operate with a fixed cost with the client, thus not wanting to share the profit margin.
Value of the project
The value of the project is basically all of the project income from the client added up. The reporting can include all of the already received amounts in addition to also prognosing the likely income at the end of the project. It is good to add up both of these values so that the actual income change is also known. Construction is a very fluid and changing industry with up to 35% of projects needing a variation or change order. This can include client variations as well so that’s why it is important.
Current cost of the project
One of the other main jobs of the CVR is to add up the current cost to date. This metric can be used to compare the program or schedule to see where the cost of work done is compared to the actually done work. These two metrics together can already show the possible ending point of the project if jobs are overbilled in advance.
Changes to the total cost at completion
In addition to the current cost of the project, it’s also critical to know the total completed cost. This information can then be communicated to the client or used internally to try to save on other jobs. Or to take credit to cover the potential cashflow issues if no savings can be had.
Construction material costs have increased by more than 30% between 2020 and 2022 and can continue to rise 12% YoY still in the future. This means that your estimates at the beginning of your project are definitely going to be higher at completion. Depending on the material it could even be more.
This means that it is crucial to also track the cost at completion of each job throughout the project. Every time a new tender ends with bids that are higher than your estimated budget, you track it. Additionally, every time a new subcontract or client contract variation is agreed upon, you mark it down somewhere. Afterward, you can refer back to these budget revisions to make sure your cost to complete is correct.
total cost at completion = all current costs + all future costs + adjustments due to material costs + adjustments due to subcontractor bids
Current cash flow of the project
Together with the current value of the project and the current cost of the project, you are able to see the balance of the project. Assuming no mistakes were made in entering the data, you can calculate if there is enough buffer for the project.
Once this number is calculated for all of the ongoing projects of the company, you can be a bit more sure. If all of the projects have enough of a safety margin, the whole company should as well.
current cashflow of a project = current value – current costs
Profitability of the project at completion
Much like cash flow, we can calculate the profitability of the project at completion based on the previous metrics. We just need to subtract the cost at completion from the value at completion. The calculation itself is trivial, but it’s key to include all of the information when calculating the two required values.
Just like the current cash flow of the project, when all of the projects are prognosed to be profitable, the company will be profitable. It’s actually very important to figure out which projects and which jobs are the profitable ones. It just needs a bit of extra effort at the data collection and structuring stage.
profitability at completion = value at completion – cost at completion
Who usually compiles the CVR reports and for whom?
It really depends on the company structure. In general, it’s construction companies that do the main contracting on behalf of the customer. In many cases, it is the main or general contractor, but it can also be the architect or designer.
The person in the company that usually does the CVR depends on the region. In the UK, it is usually the Quantity Surveyor (QS) role. It could also be the Contract Manager (CS) that helps the QS with putting together the valuations part so that variations could also be included. In other markets or smaller companies, also the Project Manager (PM) may be responsible for collecting and compiling all of the info into a CVR.
The CVRs can be for internal use or they can also be external for the customer, to keep them updated. In the internal one, the report is meant for the management or directors of the company. For them, it is relevant to know which projects are profitable and which are not. Additionally, it is very important to know why the projects are profitable or why they aren’t. It really helps to know exactly which jobs have changed from the initial estimate, by doing job costing.
What to keep in mind when putting together CVRs?
As we described in the previous sections – you need to stay organized. All of the cost documents should be timely (ideally immediately) allocated and structured somewhere for simple lookup later on. Since there is usually so much data involved in the process, you need a clear process.
A quick list of pointers for doing so:
- Have a single point of entry for every cost document for each project
- Attach the project information to the document as soon as possible
- Directly update your budget revision in your system or spreadsheet on variations
- Do the same for any material price changes or subcontractor bids that differ from the estimate
- Also, update the values for any adjustments in the client-side billing
- Remember why you need this level of detail and don’t give up 🙂
How often are CVRs put together?
The most common is to do CVR reporting at the end of every month during construction and when the project is just about to end. In an ideal world, one would do this as often as you’d like, but the time needed is just too high. Having a higher frequency than monthly could be beneficial as you would be able to find problems quickly when something changed. The longer the time period, the more changes happened in regards to the project financials.
What are the downsides of compiling CVRs?
With great power comes great responsibility. As we already mentioned in the previous sections, the effort to put the reports together is A LOT of work. Couple that with the attention to detail and strict following of structure when handing the documents and you have a difficult task on your hands. The reward and the effort of CVRs are very negatively correlated. The more effort you put into it doing it and preparing for it, the more accurate the result will be.
Even if we assume all of the data was available in a structured way, it’s a lot of work. One still has to add up all of the incurred costs and sales invoices. And if you want to track the cost of completion, you’d also need to scan through price lists, bids, and variations. That is often why contractors have to hire multiple Quantity Surveyors for the job. There’s just so much data to go through.
Could CVR reporting be made easier?
We do think so! That’s why we have created the Planyard construction software package. It’s an automatic construction CVR accessible to you anywhere and anytime. All you have to do is manage the whole financial process of your projects on Planyard – estimating, subcontractor bidding, subcontracts, valuations, variations, and costs. Planyard will then use all of the already input information to always calculate the real-time CVR for you. To get the report, you don’t have to do anything more than just a few clicks.
Bruker du fortsatt Excel for budsjettadministrasjon?
Det er en bedre måte.
Regneark er ikke den beste måten å håndtere jobbkostnader på
- Det er for lett å gjøre feil;
- Du kan ikke se bak tallene;
- Det er vanskelig å standardisere og sikre samsvar;
- Det er ingen sanntidsoversikt over lønnsomhetsprognoser;
- Det betyr duplikatarbeid for PM og regnskapsførere.
Planyard sparer tid og nerver
Følg budsjettet ditt i sanntid og ta øyeblikkelig handling når det oppstår feil. Jobbkostnader er organisert, og fullt søkbare og tilgjengelige for prognoser, prosjektledelse og mer.