eSmiley connector

Use your eSmiley data for reporting, automation and AI.

Data Panda pulls your eSmiley food-waste and HACCP data and brings it together with the rest of your kitchen and finance stack. From one place, we turn it into dashboards, automations, AI workflows and custom apps your head chefs, F&B managers and sustainability teams use every day.

Data Panda Reporting Automation AI Apps
eSmiley logo
About eSmiley

The Copenhagen platform behind 17,000 professional kitchens.

eSmiley was founded in Copenhagen in 2008 by Lars Friis and Mads Bredgaard, originally around digital self-monitoring for food safety, and grew from there into the Nordic market leader for kitchen compliance and food-waste tracking. The company was acquired by VIA Equity in January 2024 and now sits inside a wider Compliance Software Group alongside Mobaro. eSmiley reports more than 17,000 kitchens and 145,000 chefs on the platform, with offices in Copenhagen and London and customers including ISS, Sodexo, Coop, Arla, Danish Crown and a long list of Nordic hospitals.

For canteens, hospital catering, hotel F&B and school kitchens, eSmiley is the system of record for what gets thrown away and what gets checked off. A scale and a tablet sit on the kitchen floor; the staff weigh waste at four sources (production, buffet, storage and plates) and tag the registration to a registration point. Guest counts come in alongside, so kg per cover and cost per kg are calculable per service, per kitchen and per day. The HACCP side covers temperature logs, cleaning plans, audits and the task list that keeps an inspection short. The built-in reports answer the daily questions. The harder ones, like which menu items drive the highest plate waste against their food cost, or how CO2 per meal moves when a chef rotates the buffet line, sit between eSmiley, the recipe system and the accounting ledger. Pulling eSmiley into a warehouse is how those answers stop being a presentation pulled together at the end of the quarter.

What your eSmiley data is for

What you get once eSmiley is connected.

Food-waste reporting

Kg, cost and CO2 of waste per kitchen, per registration point and per guest, joined to the recipes and revenue around them.

  • Kg waste and cost per cover, per kitchen and per service
  • Plate versus production versus buffet split per menu
  • CO2 per meal trend across kitchens and quarters

Process automation

Turn waste registrations and HACCP events into the nudges your kitchen and finance teams would otherwise do by hand.

  • Post weekly food-waste cost into the accounting ledger per cost centre
  • Trigger a menu review when a dish crosses a plate-waste threshold
  • Open a HACCP follow-up task automatically on a missed temperature log

AI workflows

Use waste history and guest counts to forecast production volumes and tighten the prep list.

  • Forecast production volume per dish, per day-of-week and weather
  • Score menu items on plate-waste risk against food cost
  • Flag registration-point patterns that signal a process drift

Custom apps on your data

Small kitchen, sustainability and finance tools that sit on eSmiley data instead of a slide deck.

  • Sustainability cockpit with kg, cost and CO2 across kitchens
  • Per-kitchen waste leaderboard with menu-item drill-down
  • HACCP compliance board with open tasks and audit history
Use cases

Use cases we deliver with eSmiley data.

A list of concrete reports, automations and AI features we have built on eSmiley data. Pick the one that matches your situation.

Kg per coverTotal waste in kg divided by guest count, per kitchen and service.
Plate vs productionShare of waste from plate, production, buffet and storage per menu.
Cost per kg wastedCost of wasted ingredients per kg, by category and protein type.
CO2 per mealCO2 footprint per cover and per kitchen, tracked over time.
Worst-offender dishesMenu items with highest plate-waste rate against their food cost.
Registration adoptionShare of services where every registration point was logged.
Guest-type mixWaste and revenue split across guest categories per kitchen.
HACCP complianceLogbook completion rate and open control findings per site.
Open task ageingTasks open beyond their due date, per kitchen and area.
Multi-kitchen rollupGroup KPIs with per-kitchen drill-down in one report.
Service-period heatmapWaste kg by service period across the week, per kitchen.
Sustainability targetActual versus committed reduction target per kitchen and quarter.
Real business questions

Answers you will finally get.

How much food waste are we really running per cover, and where does it come from?

Total kg waste divided by guest count per kitchen and per service, with the split across plate, production, buffet and storage right next to it. Operations sees which kitchens trail the group on plate waste and which one has a production-prep problem instead, rather than reading a single average that hides both.

Which menu items are quietly costing us the most in wasted protein?

Plate-waste rate per menu item, multiplied by the cost per kg of the ingredients that landed in the bin. The chef sees which dishes look popular on the POS but throw 18% of the protein in the waste bin every service, and the menu review starts from a number rather than a feeling.

Are our kitchens really hitting the CO2 reduction we promised the customer?

CO2 per meal trended per kitchen against the committed reduction curve, with the underlying menu and waste data attached. The contract review with the corporate-catering customer runs on the same number both sides see, instead of a sustainability slide that nobody can audit.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Wasted-ingredient cost visible per kitchen, per cost centre and per category, posted into the accounting ledger as a real number rather than a quarterly estimate. Sustainability reporting and food cost stop being two parallel exercises owned by two different teams.

For sales leaders

Corporate-catering accounts with kg per cover, cost per kg and CO2 per meal in one view per contract. The renewal conversation with a hospital group or facility-management buyer runs on the kitchen's actual reduction curve, not on a sustainability statement written last spring.

For operations

Plate, production, buffet and storage waste per kitchen and per service on one dashboard, alongside HACCP completion and open tasks. The Monday morning kitchen call is about the dish that drove the spike, not about whose tablet was offline that week.

Ideas

What you can automate with eSmiley.

Pair with Apicbase

Join eSmiley waste against Apicbase recipes for menu engineering

eSmiley registrations per registration point are joined to the Apicbase recipe and ingredient data behind each dish, so plate-waste rate lands next to theoretical food cost on the same menu. Chefs see which dishes burn the costliest protein in the bin and the menu engineering review picks the right candidates to rework, rather than the loudest ones in the kitchen meeting.

Pair with Exact Online

Post eSmiley wasted-ingredient cost to Exact Online

Each week, the wasted-ingredient cost calculated from eSmiley registrations and ingredient prices is posted into Exact Online as a journal line per kitchen and cost centre. Finance closes the month with food-waste cost already booked against the right kitchen, instead of an end-of-quarter reclass based on a tablet export.

Pair with Mews

Line up eSmiley kitchen waste with Mews F&B revenue

eSmiley registrations and guest counts are joined to the F&B revenue Mews posts per outlet and meal period, so kg waste and cost per cover land next to actual breakfast, lunch and banquet revenue. Hotel F&B managers see which restaurants and which services drive both the waste and the margin, on one report instead of two exports.

Pair with HubSpot

Sync corporate-catering accounts and waste KPIs into HubSpot

eSmiley kitchens flow into HubSpot as company accounts with the kg per cover, cost per kg and CO2 per meal trend attached per contract. Sales chases corporate-catering renewals on the actual reduction curve the kitchen is hitting, instead of on a sustainability paragraph copied from last year's tender response.

Data model

Tables we make available.

These are the 9 tables we currently pull from eSmiley into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.

  • Accounts
  • Controls
  • Guest Registrations
  • Guest Types
  • Logbook Registrations
  • Logbooks
  • Registration Points
  • Registrations
  • Tasks

Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your eSmiley data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From eSmiley to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • eSmiley connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Which eSmiley data does the connector pull today?

The connector brings the core kitchen tables into the warehouse: registrations and registration points (each weighed waste entry and the location it was logged at), guest registrations and guest types (covers served and which category they belong to), logbooks and logbook registrations (HACCP entries such as temperature checks), controls (audits and findings) and tasks (cleaning and follow-up work), with the accounts that group them. That is a wide enough slice to drive food-waste, HACCP and sustainability reporting from one place.

How does this fit with our recipe or menu-management system?

eSmiley is the system of record for what was thrown away and what was checked off, by kitchen and by service. The recipe system is the system of record for what a dish costs in theory, and the POS or PMS is where the revenue lives. The value of pulling eSmiley into a warehouse is that those sides can be joined on dish, kitchen and date, so plate waste sits next to recipe cost and revenue rather than living in three separate dashboards.

We run a group of canteens or hospital kitchens. Does multi-site reporting come across?

Yes. Each kitchen is preserved as its own account in the warehouse, with the registration points, guest types and logbooks underneath it. Group reporting on kg per cover, cost per kg and HACCP completion joins them on the shared identifiers eSmiley already assigns, so a corporate-catering operator or a hospital group can read a single rollup with per-kitchen drill-down.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your eSmiley setup and the systems around it. Together we pick the first thing worth building.