RICS Cost Report Generator — turning Excel cost breakdowns into client-ready PDFs

The challenge

Reports were inconsistent, time-consuming, and one-off — quality and structure depended entirely on who assembled them and when. Residential and commercial projects had different requirements, but no tooling handled both cleanly.

Business challenges

• Enforce report consistency regardless of who assembles it
• Cut time spent on formatting rather than analysis
• Handle residential and commercial project types cleanly
• Make previous work reusable and duplicable

Technical challenges

• Parse variable Excel structures into a normalized schema
• Map cost line items to the correct NRM1 elemental categories
• Flag missing or inconsistent fields before report generation
• Assemble a branded, consistently formatted PDF automatically

Our solution

A four-layer system — Input, Processing, Document Builder, and Output — where raw Excel data becomes structured, NRM1-aligned report content and flows straight into a client-ready PDF.

Core features delivered

• Excel upload & parsingStaff upload existing cost-breakdown spreadsheets; the parser reads structured columns, identifies line items, and extracts values into a normalized schema — no re-entry.
• Data normalizationRaw data is cleaned, validated, and normalized into a consistent schema, with missing or inconsistent fields flagged for review.
• NRM1 category mappingParsed cost data is mapped to NRM1 elemental categories for both residential and commercial project types.
• Dynamic report populationCost summary, elemental breakdown, area schedules, qualifications, and exclusions are populated from the processed dataset — no manual assembly.
• Project storage & reuseEach processed dataset is linked to its project record, enabling history reuse, project duplication, and consistent access to prior breakdowns.
• PDF output pipelineThe processing layer feeds the document builder, assembling cover, NRM1 summary, elemental breakdown, and schedules into one clean PDF.