COMPARISON · AS OF 11 NOV 2026

Excel, Power BI and Kiosa: multi-location reporting compared.

Excel and Power BI are tools for building your multi-location reporting yourself: flexible, with setup and upkeep done in-house. Power BI Pro costs €12.10 per user per month net. Kiosa comes with POS and staffing data from every location already connected, consistent metrics, Morning Briefing, forecast and AI Partner, plus scheduling, purchasing and HACCP in the same system. One View costs €99 per location per month.

01 // WHAT MATTERS

Seven criteria for multi-location businesses.

From the point of view of a business with several locations. With a DIY build, an eighth question comes in: who builds and maintains the system.

01

One data set instead of several tools

If POS, staffing, purchasing and invoices sit in separate programs, no number ever matches another. One data set means one revenue figure, one labor cost ratio, one cost of goods, calculated the same way at every location.

02

Yesterday's numbers, not month-end

The monthly management accounts (BWA) explain last month. What you can actually steer by is what you see in the morning about yesterday, per location, with staffing and cost of goods, not just revenue.

03

A forecast that drives scheduling and purchasing

A revenue forecast only counts if it decides how many people are on the schedule on Saturday and how much mozzarella gets ordered on Thursday.

04

Alerts before the monthly accounts arrive

With several locations, nobody reads every report every day. The system speaks up when the labor ratio tips at one location or a supplier puts up a price.

05

Published prices per location, no setup fee

One price per location that you know before the first conversation, with no setup fee. That way the eleventh location pays off just like the first.

06

The POS stays

Your POS is a given, and your team knows it. Management software reads it and doesn't ask you to switch.

07

HACCP and checklists in the same system

Temperature logs and cleaning plans are part of daily business. When they sit next to the numbers, management sees at a glance where something is still open at a location.

02 // THE SYSTEMS

Three ways to do multi-location reporting.

Kiosa One View + AI Partner

Built for: restaurants and groups with several locations that want numbers, staffing, purchasing, invoices and hygiene in one system. Born at Mama Trattoria, ten restaurants in Hamburg.

At its core: POS and staffing are connected once; after that, Kiosa pulls the data in itself. The metrics are predefined and calculated the same way for every location, and permissions per location are built in. Scheduling, purchasing, invoices and HACCP run in the same system.

One View €99 · all five modules €445 per location/month net · published prices

Excel and POS reports

Built for: one or two locations with a single POS and one person who reliably maintains the analysis, plus one-off analyses of any kind.

Strengths: you can start right away with the exports you already have. With Power Query, Excel loads external data and refreshes it. You can build any analysis you like, and almost everyone in the business can work with it.

Included in the Microsoft 365 plan · setup and maintenance in-house

Power BI

Built for: businesses with their own BI skills that want to design a data model across POS, staffing and other sources themselves.

Strengths: highly flexible modelling, with reports, dashboards, data alerts and row-level security. Copilot is available with Fabric or Premium capacity.

Pro €12.10 · Premium per user €20.80 per user/month net · As of 11 Nov 2026

03 // THE COMPARISON

The systems against the seven criteria.

As of 11 Nov 2026. Information about Excel and Power BI comes from Microsoft, each with a link.

Kiosa One View + AI PartnerExcel and POS reportsPower BI
One data set instead of several toolsYes. POS and staffing in one data set; Inventory, Invoices, Scheduling with time tracking, HACCP and Loyalty on the same data.Separate files and exports. Scheduling, purchasing and HACCP run in other tools.Reports and dashboards on top of your data model. Scheduling, purchasing and HACCP are not part of the product.
Yesterday's numbers, not month-endYes. POS every 15 minutes, daily P&L per location against plan and prior year, location matrix with month-end projection.Only as current as the last export or refresh.Scheduled refresh up to 8 times a day (Pro), up to 48 times with Premium per user, Premium or Fabric capacity.
Source: Microsoft Learn: Refreshing data
A forecast that drives scheduling and purchasingYes. Revenue forecast per location and day, which feeds scheduling and order suggestions.Your own forecast built in formulas; you connect it to scheduling and purchasing yourself.You build a forecast in the data model and connect it to scheduling and purchasing yourself.
Alerts before the monthly accounts arriveYes. Morning Briefing every morning, anomaly alerts on revenue, labor cost and cost-of-goods ratio, weekly report.With extra setup, such as conditional formatting.Data alerts on dashboard tiles, a notice in the notification centre and optionally by email.
Source: Microsoft Learn: Data alerts
Published prices per location, no setup fee€99 per location per month for One View, all five modules €445, net. No setup fee, self-service checkout.Included in your Microsoft 365 plan (not compared here). Setup and upkeep in-house.Pro €12.10, Premium per user €20.80 per user per month plus VAT, billed annually. Copilot only with Fabric capacity from F2 or Premium from P1. Setup and upkeep in-house.
Source: microsoft.com: Power BI pricing, Microsoft Learn: License types, Microsoft Learn: Copilot for Power BI
The POS staysYes, with OktoPOS and Hypersoft. Staffing via gastromatic, e2n and ordio. Connection included in the price.Yes, via exports or Power Query.
Source: Microsoft Support: Power Query in Excel
Yes, via connectors. Sources without a direct network connection need a gateway.
Source: Microsoft Learn: Refreshing data
HACCP and checklists in the same systemYes, included in One View: checklists, temperature logs with photo evidence, HACCP report as a PDF.Via your own templates, kept separate from the numbers.Not part of the product.

04 // KIOSA DAY TO DAY

A week with Kiosa.

This is what it looks like at one location, described over an ordinary week.

At night

Nobody pulls exports

The POS is read every 15 minutes, the staffing system likewise during the day, and at night Kiosa reconciles the last seven days. The metrics are defined the same for all locations, restaurant managers see their sites, management sees all.

07:00

The briefing is in your inbox

Before the first supplier rings the bell, the Morning Briefing tells you what happened yesterday: net revenue, labor cost ratio and cost of goods per location, against plan and prior year. Plus a few sentences on what stands out and what's on today. On Mondays, the weekly report arrives too.

Tuesday

Something stands out

If the labor cost ratio at one location has been above plan for three days, Kiosa flags it on its own. You drill the number down to product group, item and invoice and see where it comes from, long before the monthly accounts show the same thing.

Anytime

Ask your own numbers

Which location had the highest labor cost ratio in October, and why? The AI Partner works out the answer from your data and names the source. In the AI Workspace, recommendations and tasks sit in one place, and nothing is carried out until you approve it. With the AI plugin you can ask the same questions in ChatGPT or Claude.

Wednesday

The forecast plans with you

For every location and day, Kiosa calculates a revenue forecast from history, weekday, season, public holidays, school holidays, weather and events. The schedule suggests staffing from it, and the order suggestions use the same number. You can see how accurate it is per location in the product.

Daily

HACCP in the same place

Checklists for opening, closing and hygiene, temperature logs with photo evidence, and at month-end the HACCP report as a PDF for inspections. Included in One View, no extra module.

Kiosa was born at Mama Trattoria, ten restaurants in Hamburg, and is used there every day. It was built by restaurateurs who know these mornings from their own business. One View is the foundation; you add Inventory, Invoices, Scheduling and Loyalty per location. Within a module there are no feature tiers, and you sign up via self-service checkout. Hosted in Germany, and the data belongs to the business.

05 // SAMPLE CALCULATION

A sample calculation for ten locations.

Ten locations, eleven Power BI users (ten restaurant managers, one in management). The assumptions are stated openly, so plug in your own figures.

Item per monthPower BI self-builtKiosa One View
Licences11 users × €12.10 = €133.1010 locations × €99 = €990
Setup (60 hrs × €45, spread over 12 months)€225€0, no setup fee
Upkeep by your controller (4 hrs a week × €45)€780with Kiosa
Management time (2 hrs a week × €70: collecting and checking numbers)around €607Briefing instead of collecting
Total per montharound €1,745€990
What you also getReports and dashboards on top of your data model.AI Partner, Morning Briefing, forecast, location comparison, HACCP and checklists. Scheduling, purchasing and invoices as modules.

Assumptions: Power BI Pro for all eleven users per microsoft.com, checked on 11 Nov 2026, without Premium or Fabric capacity, without Copilot, without running a gateway. Setup of 60 hours (data model, connecting POS and staffing for ten locations, reports) and 4 hours of upkeep a week if your controller takes it on, each at €45 fully loaded cost per hour. Two hours a week of management time at €70 per hour. These are assumptions, not measurements.

Halve the setup, upkeep and management time and the DIY build still comes to around €940 a month. In every scenario the licence is the smallest item; time is by far the biggest. With Kiosa there is no setup, and Kiosa maintains the interfaces and metrics.

06 // UPKEEP

What you have to maintain when you build it yourself.

Setup is a one-off. After that, these four jobs keep coming back:

Access to the data

Exports from the POS and staffing system have to be pulled regularly or set up as a refresh. With several locations, that means several exports per source.

Consistent definitions

What counts towards the labor cost ratio, which period, gross or net? If one formula differs, you get a different number.

Changes in the sources

If a column or table changes at the source, Microsoft says the refresh in the Power BI service can fail. Someone has to notice and fix it.

Source: Microsoft Learn

Knowledge locked in one person

Whoever built the file or the model knows the logic. If they are away, you need someone to step in and get up to speed.

07 // PRICE

What Kiosa costs: €99 per location.

One View with AI Partner costs €99 per location per month net. For ten locations that is €990 a month.

Foundation · always included

One View with AI Partner

€99 / month per location
Book a demo call

No setup fee. 12-month minimum term, then renews for 12 months at a time. Cancel with 3 months' notice before the end of the term.

LocationsOne View with AI Partner+ InventoryAll five modules
5€495 / month€740 / month€2,225 / month
10€990 / month€1,480 / month€4,450 / month
20€1,980 / month€2,960 / month€8,900 / month

All prices per location per month, net, no setup fee. One View €99, Inventory +€49, Invoices +€99, Scheduling +€99, Loyalty +€99. All five modules together: €445 per location. The complete breakdown is on the pricing page.

08 // METHODOLOGY

Date and sources.

As of 11 Nov 2026, information about Excel and Power BI from Microsoft: Pricing, License types, Data refresh, Copilot, Data alerts, Row-level security, Power Query in Excel. Power BI prices are per user per month, billed annually, plus VAT. Kiosa is our product; Kiosa prices are net per location per month.

09 // FREQUENTLY ASKED QUESTIONS

Frequently asked questions about Excel, Power BI and Kiosa

With one or two locations, a single POS and one person who reliably maintains the file, often yes. With Power Query, Excel loads external data and refreshes it. But every extra location means more exports, and formulas and definitions depend on whoever built the file. For one-off analyses, Excel stays useful either way.

According to Microsoft, the licence costs €12.10 (Pro) or €20.80 (Premium per user) per user per month plus VAT, billed annually (checked on 11 Nov 2026). On top of that come setup, data connections, upkeep and management time. In the sample calculation on this page for 10 locations (60 hours of setup, 4 hours of upkeep and 2 hours of management time a week), Power BI comes to around €1,745 a month and One View to €990. The assumptions are stated openly, so plug in your own figures.

Power BI is a blank canvas: you build and maintain the data model, metrics, permissions and forecasts yourself. Kiosa is ready to go: POS and staffing are connected once, the restaurant metrics are calculated the same way for every location, the Morning Briefing arrives on its own, and the AI Partner answers questions with your numbers. Scheduling with time tracking, Inventory, Invoices, HACCP and Loyalty run on the same data.

In Power BI you can schedule up to eight refreshes a day on shared capacity (Pro) and up to 48 with Premium per user, Premium or Fabric capacity. Kiosa pulls POS data from OktoPOS and Hypersoft every 15 minutes. Staffing data from gastromatic, e2n and ordio comes in every 15 minutes during the day, and overnight Kiosa reconciles the last seven days.

You ask in plain language, for example for the labor cost ratio per location. The AI Partner works through fixed Kiosa analyses on your data, names the source under every answer and suggests what you can do. Nothing is carried out until you approve it. A pivot table only answers the question you built it for.

One View with AI Partner costs €99 per location per month net, so €990 a month for ten locations. Further modules cost €49 (Inventory), €99 (Invoices), €99 (Scheduling) or €99 (Loyalty), all five together €445 per location. No setup fee, 12-month minimum term, sign-up via self-service checkout.

Yes, both stay useful for one-off analyses. As an admin, you can export your data in the settings as a ZIP of JSON files and keep working with it in Excel or Power BI.

See it with your own numbers.

Want to see what this looks like with your numbers? In the demo call we show you Kiosa on a live business and go through your locations with you.

One View €99 · all five modules €445 per location per month, net · no setup fee

Book a demo call