Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Can Our Commercial Team Produce Monthly Cost Value Reconciliations Without a Week of Spreadsheet Work?
Problems We Solve

How Can Our Commercial Team Produce Monthly Cost Value Reconciliations Without a Week of Spreadsheet Work?

Contractor QS teams spend days each month on cost value reconciliations. We build a CVR that pulls cost, value and accruals together per job for review.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Monthly CVRs are slow because cost comes from the accounts system, value from the valuation, and accruals and forecasts from the QS's own knowledge, all brought together in a spreadsheet. We build a CVR that pulls cost and value from their sources, lists the likely accruals from orders and deliveries, and gives the QS a reconciliation to review and adjust, with the previous month kept for comparison.

Month end on the contractor side

The board wants a margin position for every job by the fifth working day. For each job, the QS needs value to date, from the latest application and what the client is likely to certify, and cost to date, from the accounts system. Then the adjustments: costs incurred but not yet invoiced, subcontract liabilities, variations not yet agreed, provisions for known problems, and the forecast to complete.

The accounts system produces a cost report by cost code. The QS exports it, pastes it into their CVR template, adds accruals they know about from memory and from the site team, and adjusts value for what they believe will be recovered. Across ten or fifteen jobs, the commercial team spends a large part of the first week of every month doing this.

Why CVRs take so long

  • Cost codes in the accounts system do not match the CVR's structure, so costs are regrouped by hand.
  • Accruals depend on knowing what has been delivered or done but not yet invoiced, which sits with site.
  • Subcontract liabilities are calculated from separate subcontract ledgers.
  • Value adjustments for unagreed variations are the QS's judgement and are not recorded with reasons.
  • Last month's CVR is a separate file, so movements are hard to explain.

What slow CVRs cost the business

The board sees margin late, often after the window for acting on it has passed. Accrual errors make margins swing month to month, which damages confidence in the numbers. Commercial staff are tied up in data work when they should be recovering value. And when a job goes wrong, the history of how its margin moved is hard to reconstruct.

CVR lineSourceWhat the build does
Cost to dateAccounts systemPulled and grouped to your CVR structure
AccrualsSite knowledge and ordersSuggested from orders and delivery records
Subcontract liabilitiesSubcontract ledgersCalculated from applications and assessments
Value to dateLatest application or certificatePulled from the valuation record
Value adjustmentsQS judgementEntered with a reason, carried forward
Forecast to completeQS judgementEntered and compared with last month

The CVR we build

  1. Your cost codes are mapped once to your CVR structure, per job or per template.
  2. Cost to date is pulled from your accounts or construction ERP system through its API or scheduled export.
  3. Purchase orders and delivery records are compared with invoices received to list likely accruals, which the QS accepts, edits or rejects.
  4. Subcontract liabilities are calculated from the latest applications and your assessments, where those are recorded digitally.
  5. Value to date comes from your valuation record, and the QS adds adjustments with a reason for each.
  6. The QS enters or updates the forecast to complete, with the previous month's figures shown alongside.
  7. The board pack is generated from the confirmed CVRs, with margin movement per job explained by line.

Accrual policy, provisions and forecasts are matters for your commercial director and finance team, and the tool applies their rules. It never sets them.

What month end looks like

The QS opens a CVR with cost, value and suggested accruals already in place and spends their time on the judgements: recovery of variations, the forecast, and provisions. Movements from last month are shown line by line. The board pack is ready sooner and is easier to trust, because every figure can be traced to its source or to a named decision.

Recognise your month end?

  • CVRs are built by pasting accounts exports into spreadsheets.
  • Accruals are compiled from memory and site phone calls.
  • Margins swing from month to month in ways that are hard to explain.
  • The board sees job margins later than it wants to.
  • Value adjustments are not recorded with reasons.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does it work with our accounts system?

If it has an API or scheduled export of costs by job and code, yes. We check before designing anything.

Will it set our accrual policy?

No. Your finance team sets the rules. The tool suggests accruals from orders and deliveries under those rules for the QS to confirm.

Can we keep our CVR template?

Yes. The output can follow your existing template and board pack format.

What affects the cost?

The systems to connect, how consistent your cost codes are across jobs, and whether delivery and order data is recorded digitally.

Keep reading

More on Problems We Solve

Start here

Tell us what your surveyors are rebuilding by hand

Describe the report, the log or the process, where its data comes from and who has to see it. We will tell you what we would build and what we would leave alone, and if a smaller change would fix it, we will say so. Professional judgement stays with your surveyors.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →