An open-source sales and KPI dashboard for shops, cafés and bakeries with more than one site, built with Next.js, TypeScript and PostgreSQL. It shows sales by day, week and month against last week and last year per site and category, gross margin, average basket, labour and waste as a share of sales, sell-outs and monthly targets, with figures from a till CSV import or a daily form, drill-down to the rows, share links and a morning email.
by Light CloudDashboards and analytics


The dashboard is built on the Next.js SaaS starter's accounts, teams and design system, with the KPI maths as pure, unit-tested functions in src/lib/metrics. Money is stored in pence per site and day, labour cost as a share of sales only counts days that have both, and gross margin is measured over the lines that have a cost. The first start seeds the Yorkshire Bakery Group demo, about 72,000 rows of deterministic sales for four shops, and the first account to sign up takes it over. The morning email needs RESEND_API_KEY; on hosting that scales to zero, such as Light Cloud's default, also set CRON_SECRET and have a scheduler call POST /api/summary every 15 minutes. Rename the business and add your sites under Settings, Business, import a day from your till, then remove the demo data on the same page.
Net sales against the same day last week, customers and average basket, labour cost as a share of sales, waste, and what sold out early. Once a week, add gross margin and how each site is doing against its monthly target; this dashboard puts those on one screen per site.
Export sales by product (date, site, product, category, quantity, net sales and cost if the till has it) as CSV and import it under Enter figures, Import a CSV file. Match the columns once and every row is checked before anything is saved; dates are read day first, as UK tills write them.
Wages for the period, including employer National Insurance and pension, divided by net sales without VAT. Only days that have both a labour cost and sales count, so a missing rota never makes a shop look cheap to run.
Yes. Settings, Share links makes a signed, read-only link for one or more sites that expires after 7, 30 or 90 days or when you turn it off. The person can change the dates and open the rows behind each chart, but cannot enter figures or see the team.
Set RESEND_API_KEY so the app can send email, then set CRON_SECRET and have a scheduler call POST /api/summary with it every 15 minutes. A server that stays running checks every 10 minutes on its own, and each person gets each summary once however often it is called.