Skip to content
method64
Menu

climactra

Climactra overview with next steps and a hotel’s sustainability score
A hotel’s overview, score and next steps

Software for hotels: record consumption, calculate the CO₂ balance and certification status, export the evidence as PDF and Excel. Live at climactra.com.

2026Concept, development, operationTypeScript · Next.js · React · PostgreSQL · Prisma · Stripe · Docker

Lines of TypeScript
89,135
Data models
37
Tests
606
Criteria
405

climactra.com

Starting point

From meter reading to proof

A hotel that wants to prove its sustainability collects bills and meter readings, maintains emission factors and works through a separate list of criteria for each label. That makes four filing systems that know nothing of each other, and at the end of the year they have to produce a figure that someone can check. Climactra brings them together in one place.

The application

Four steps, one data model

Excerpt of the data model with the tables for hotel years, monthly occupancy and heating contracts
Occupancy, years, heating contracts
Excerpt of the data model with the tables for emission factors, consumption data and targets
Consumption data with their factors
Excerpt of the data model with the tables for certificates, criteria and their status
Certificates, criteria, compliance status
Excerpt of the data model with the tables for documents, notes and measures
Documents, notes, measures

01Recording

Month by month

Energy, water, waste and occupancy go in every month. District heating and green electricity depend on contracts with their own terms, and occupancy is recorded per month because every metric is calculated per guest.

02Accounting

Every figure can be recalculated

Every recorded consumption stores the emission factor it was calculated with. If a factor changes later, an old balance can still be recalculated, and the application shows where the new figure differs.

03Certification

One status per year and label

Four labels, 405 criteria in total, each with its own status per hotel. That there is exactly one current certificate per hotel, year and standard is enforced by a partial index in the database, not by a check in the code.

04Reporting

What comes out at the end

The output is the balance by Scope 1 to 3, a score and the status of each label, as PDF and Excel. Each document is attached to the criterion it applies to; alongside are the measures with their expected impact.

Calculation

Where a balance goes wrong

CO₂ from wood and pellets counts as climate-neutral and does not belong in the Scope 1 total; Climactra reports it separately. Electricity is always calculated twice, location-based and market-based, and a green electricity contract only counts for months it covers in full. Spending in euros is deflated to the base year before conversion, otherwise the balance rises with prices rather than with consumption.

Decisions

What is built this way on purpose

Anyone opening someone else’s hotel gets a 404, not a 403, so nobody can guess which hotels exist. The database throttles requests itself; a separate cache service would be a second service to run, and the traffic doesn’t justify it. For one label the official assessment basis is missing. There, Climactra doesn’t estimate a level but shows the criteria and leaves the level open.

The complete data model as a tall diagram of around forty linked tables
The data model, 37 models

Live for hotels, in German, Italian and English.

Enquiry

Tell me about your project.

A few details are enough for a first assessment.

Send an enquiry