Analytics Start free
Ellibo Analytics

Reports and dashboards over your whole business, live

Sales from the till, the online store and your invoices, beside costs from your books, stock, pipeline and hours. Read live from your Ellibo apps, with your own files, sheets and databases added in.

Free for 2 users. 14-day trial of everything, no card. Data from your Ellibo apps never counts toward your rows.

Sales overview
Sales-
Gross profit-
Margin-
Orders-all channels

Sales and costsSalesCostsMargin %

Sales by channel

  • Shop till-
  • Online store-
  • Invoices-
-
Live fromPOSEcommerceAccountingNothing to sync

A sample business. Switch the period: every chart follows, as on a real dashboard.

  • Free for 2 users, for ever
  • Live from every Ellibo app
  • App data never counts toward your rows
  • 14-day trial of everything, no card
Live, with nothing to sync

Every Ellibo app is already a data source

No connectors to set up, no sync to wait for, no copies that drift. Analytics reads each app where it keeps its records, so a dashboard shows this minute's figures.

POS sales against costsTakings by outlet beside purchases and expenses from your books.
Pipeline against invoiced revenueDeals you expect to win beside what you have really invoiced.
Project profitFees beside hours logged and expenses claimed, project by project.
Stock value against salesSlow stock and fast sellers on one page, by warehouse.

Ready-made dashboards for each app you use come with Analytics, and you can change them like any other.

From data to answers

Bring it in, shape it, see it, share it

Start with the data you already have in Ellibo, and add the rest when you are ready.

Bring in data

Files, sheets, web addresses, databases and APIs

Upload Excel or CSV, paste a table, or connect a Google Sheet, a web address, an outside database or an API. Choose how it refreshes and what happens to the rows already there.

  • Replace, add to the end, or update rows by a key column
  • Refresh daily or weekly, or every hour on Professional
  • Tidy as it comes in: rename, change types, fill blanks, split and remove duplicates
  • A history of every import, with the rows that failed and why
Files on every plan · schedules from Standard · databases from Professional
Reports

Drag a field, get a chart

Put a field on the axis and a value in the chart, then filter, group dates by month or quarter, show the top 10, and click a bar to drill in.

  • About 30 chart types, plus tables, pivots, summaries and KPI cards
  • Compare with the period before or the same period last year
  • Running totals, percent of total and colours by rule
  • Export to PDF, Excel or CSV
Every plan
Pivots and summaries

Rows, columns and totals, the way you think about them

Put products down the side and months across the top, and every cell fills in, with totals and colours that show the big numbers at a glance.

  • Several values side by side, such as sales, cost and margin
  • Group by any field, or by day, week, month, quarter or year
  • Totals and subtotals you can switch on and off
Every plan
Formulas, lookups and query tables

Join your data and work it out once

Add a formula column, define a measure like margin percent, link one table to another through a shared column, or write a query table in SQL when you need full control.

  • Formula columns and measures, checked as you type
  • Lookups join tables for you in every report
  • Query tables read your other tables and never count toward rows
Formulas on every plan · query tables from Standard
Dashboards

One page that answers the morning question

Place charts, KPI cards, tables, text and pictures on a grid. Add filters for the person looking, such as date range, region or salesperson, and every chart follows.

  • Ready-made dashboards for each Ellibo app you use
  • Play a dashboard as a slideshow on a meeting-room screen
  • Pin a dashboard to the Home of your other Ellibo apps
  • Works on phones, and installs from the browser
Every plan
Ask and insights

Ask in plain words, and see what changed

Type "sales by month this year" or "top 5 products last quarter" and get the chart. Insights point out the biggest movers, trends that turned and figures out of the ordinary, with a simple forecast of where things are heading.

  • Ask works with no AI service and no charge per question
  • Insights and forecasts on Professional and up
  • Add your own AI key on Professional for harder questions
Ask from Standard · insights from Professional
Share, schedule and alert

The right figures reach the right people

Share a workspace, a report or a dashboard to view or edit. Email it as PDF, Excel or CSV on a schedule, and get an alert when a number crosses a line.

  • Each person sees only their own rows, such as their region, on Professional
  • Scheduled emails from Standard, alerts from Professional
  • Public links and website embeds on Professional, with a password and an end date
  • Your own logo and colours on public pages on Business
Sharing on every plan

Names and figures in these pictures are examples.

Ways to show it

About 30 chart types, and the views around them

Bar Horizontal bar Stacked 100% stacked Line Smooth line Step Area Stacked area Bar and line combo Pie Donut Rose Funnel Scatter Bubble Heat map Tree map Sunburst Gauge Radar Waterfall KPI card Table Pivot Summary
Fair limits

Your Ellibo data never counts toward your rows

Row limits apply only to data you bring in from outside. However much your apps hold, it costs nothing extra to report on.

Rows used on the Standard plan14,900 of 250,000
  • Sales invoices (Accounting)free, live
  • POS billsfree, live
  • Stock and items (Inventory)free, live
  • Deals (CRM)free, live
  • targets.xlsx1,240 rows
  • Ad spend (Google Sheet)13,660 rows
Who it is for

For owners and teams who want the numbers without the spreadsheet

  • Shops and restaurants

    Takings by outlet and hour, best sellers and margins, from the till and the books together.For example: Sales by outlet, Top dishes, Busy hours

  • Distributors and wholesalers

    Sales by retailer and route, stock value by warehouse, and who owes you, on one page.For example: Sales by route, Slow stock, Ageing dues

  • Online sellers

    Orders by country and channel, returns and repeat buyers, with your ad spend brought in from a sheet.For example: Orders by country, Return rate, Spend against sales

  • Agencies and service firms

    Profit by client and project, with hours, expenses and invoices side by side.For example: Project profit, Billable share, Pipeline

  • Finance and operations

    Monthly packs that build themselves, emailed on the first of the month, with alerts when something slips.For example: Monthly P&L pack, Cash in and out, Overdue alerts

Using a separate reporting tool today?

Here is what changes

A separate reporting tool
Ellibo Analytics
Your business apps
Synced a few times a day through connectors
Read live, with nothing to set up
Row limits
Synced app data counts toward them
Ellibo app data never counts
Reports across apps
Joins to build and keep up to date
Ready-made, from apps that already share customers and items
Who sees what
Set again in the reporting tool
Follows your Ellibo roles, with row limits per person
Price
Often priced for large teams
Free for 2 users, then from $9 a month for your business
What it costs

One price for your business, users and rows included

Prices are a month, before tax. A year costs the same as 10 months.

Free for ever

Free

2 users, 10,000 imported rows
$0

Standard

3 users, 250,000 rows
$9a month
Most popular

Professional

10 users, 2 million rows
$19a month

Business

25 users, 10 million rows
$39a month

Need more? Add users or rows to any paid plan. See all plans

Straight answers

Questions people ask

What is Ellibo Analytics?

It is reporting and dashboard software for your whole business. It reads live from your other Ellibo apps and from data you bring in, such as Excel files, Google Sheets, web addresses, outside databases and APIs. You build charts, pivot tables and dashboards by dragging fields, share them, and get them by email or as alerts.

Do I need to sync or export my Ellibo data?

No. Data from your Ellibo apps is read live, from where each app keeps it, so a dashboard shows this minute's figures. There is nothing to set up, schedule or wait for.

What counts toward my row limit?

Only rows you bring in from outside, such as files, sheets, web addresses, databases and APIs. Data from your Ellibo apps never counts, however much of it you have. Query tables don't count either, because they read rows that are already there.

Who counts as a user?

Everyone who signs in to Analytics, Viewers included. The Free plan has 2 users. Paid plans include more users, and you can add users to any paid plan.

Which Ellibo apps can I report on?

All of them: Accounting, POS, Inventory, CRM, Projects, Timesheets, Expense, HR, Helpdesk, Field Service, Manufacturing, Bookings, Subscriptions, Ecommerce and Sign, whichever your business uses. You can put figures from several apps on one dashboard, such as POS sales beside costs from your books.

Can everyone see every figure?

No. Admins and Managers see all data. Analysts see their own workspaces, what is shared with them, and only the apps an Admin allows. Viewers see only what is shared with them. Pay and salary data stays with Admins. On Professional and up you can also limit the rows each person sees, such as their own region.

Can I connect my own database?

Yes, on the Professional plan and up. Analytics connects to MySQL, PostgreSQL and SQL Server and refreshes on a schedule. Your database host must allow connections from our server, and we only read. Use a read-only database user.

Is there AI?

Ask works in plain words on Standard and up, such as "sales by month this year", with no AI service and no cost per question. On Professional and up you can add your own AI key for harder questions. Your key and questions go only to the AI service you chose.

What does it cost, and what happens after the trial?

Free for 2 users and 10,000 imported rows. Standard is $9 a month for your business before tax, Professional is $19 and Business is $39. A year costs the same as 10 months. Every new business gets 14 days of everything, no card needed. After that you move to the Free plan or the plan you choose. Nothing is deleted: anything beyond your plan pauses until you upgrade.

Is my data safe?

Your business's data is kept apart from every other business, and every report checks who is asking. Passwords for outside sources are stored encrypted. Public links work only while your plan includes them, and you can turn any link off at once.

Can I put a dashboard on my website?

Yes, on the Professional plan and up. Make a public link, or an embed for your website or intranet. You can add a password and an end date, and turn it off at any time.

Do I need Ellibo Accounting too?

No. Analytics works on its own with data you bring in. Every other Ellibo app you use simply adds more live data to choose from.

Want the details? Read the Analytics help guides.

See your whole business on one page

Free for 2 users, for ever. 14 days of everything, no card.

Chat with us