Step 1: Gather your invoice/financial data
Start with the spreadsheets your finance team creates when paying invoices. These typically contain:
Energy usage per building (e.g. electricity split into day and night units in kWh)
Gas consumption per meter
Monthly breakdowns
Waste collection volumes and treatment method
Transport and logistics activity
Water consumption
Note: You don't need cost/price data for the platform – only consumption (kWh, m³, etc.) is needed to calculate emissions.
Step 2: Download the import template from the platform
In the Klappir platform, go to Data> Import>Data, select the relevant data type (e.g. Electricity, Fuel, Water, Waste), and download the Excel template.
Note: Templates are available for all data types directly in the platform.
Step 3: Structure your data into the template
Map your invoice data into the template columns:
From/To timestamps: Use the first and last day of each month (e.g. 1st April – 30th April)
Asset: Use the asset name as set up in your asset list in the platform (e.g. buildings, vehicles etc.)
Meter reference: Add the meter number in the reference column
Supplier: Fill in your supplier
Units: Kilowatt hours for electricity – day and night units can be entered as separate rows
Legal entity: Your organisation
Tip: If a column is missing or incorrect, it will show red in the platform – fix it in your spreadsheet before uploading.
From invoice to your Klappir system
Step 4: Upload the file to the platform
Go to Data>Import, select the data type, upload your prepared file, and select the correct sheet. The platform will auto-match your columns.
Review the preview – if everything is green, press Confirm to import.
Step 5: Monitor and verify in Import history
After importing, go to Import History to verify the data. Make sure there are no duplicate entries (e.g. if data was previously entered manually or by a colleague, delete the duplicate to avoid double-counting).
Step 6: Repeat for each asset and data type
Follow the data import flow. For example for:
Electricity → E.g. for each building
Fuel (Gas) → Goes under "Fuel" in the platform. E.g. for fuel used by the vehicles you own and fuel burned on premises for heating or cooking
Water → E.g. Cold water consumption for your buildings (heating via gas is already covered under Fuel)
Waste → E.g. Waste data type, weight and disposal treatment method for your buildings in your system
Step 7: Confirm data assignment
Confirm that values, labels, and structured datasets appear correctly in your Klappir workspace.
Head to Data>Asset Rules and Data>Supplier Rules to ensure your data is assigned to the right assets, suppliers in your Klappir workspace.
Confirm data assignment
Step 8: Analyse in the platform
Once data is imported, use the Dashboard, Insights, and KPIs sections to review trends – e.g. spotting why consumption doesn't drop during summer period (heating left on, etc.).