01 The challenge
Each audit used a large template — hundreds of standards grouped into sections, each with its own weighting — maintained in Excel. Consolidating results, producing client reports and comparing hotels across a group took days of manual work, and every template change risked breaking the scoring. The consultancy needed a system its auditors could use on site and its clients could log into.
02 What we did
NHZ Global delivered the IQ Audit web application under a fixed-scope contract, from wireframes to production:
- Template builder — sections, standards and weightings defined once and versioned (the 2015 template was migrated as the first)
- Auditor entry screens optimised for working through a property quickly, with evidence notes
- Automatic weighted scoring replacing spreadsheet formulas
- Client dashboards comparing properties and periods, with exportable reports
- User management for consultants, hotel clients and property managers
03 The results
- Audits scored instantly instead of consolidated by hand
- Template changes made by the consultancy without developer time
- Properties from Bangkok to Cologne benchmarked on one system