← All work Case study · Restaurants · Belgrade

A restaurant chain moves from manual books to automatic accounting

We’re moving the chain to a system that collects sales, supplier invoices, bank payments and delivery reports into one database every night. In the morning the owner gets the numbers in a dashboard and in Telegram — no spreadsheets.

stage 1 in progress
IndustryRestaurants
Locations2
CityBelgrade
Working togethersince July 2026

Illustrative numbers. The client’s data stays private.

ConnectedSyrveSEF eFaktureWoltBanksGoogle SheetsTelegramPostgreSQLExcel
99.99%

of bank payments matched to supplier invoices

10× vs 0×

sales per dinar of delivery ads — one location vs the other

70,000+

records from 5 systems in one model

Month 4

when the second location paid back — seen in the data

How the system works

Every night, on its own

Syrve POSsales by check and payment
SEF e-invoicesboth companies
Banksstatements from email
Google Sheetsowner’s tables
Woltorders, ratings, payouts
MagLab Analytics
03:30LoadPOS, banks, spreadsheets, Wolt 06:40Loade-invoices 01Unifyone model: sales, invoices, payments 02CalculateP&L by the owner’s rules · invoices ↔ payments
PostgreSQL · raw → core → marts · backup daily
DashboardMoney · Ads & Wolt · down to documents
Telegram · 09:00morning summary with alerts
Excelexport of any table
Reconciliationsystem vs owner’s spreadsheets
Before → after

From spreadsheets to a system

The owner used to put the numbers together by hand. The system makes them arrive on their own.

Before

  • P&L and spending put together by hand
  • Invoices and bank payments checked one by one
  • Delivery ads judged by sales, not by margin
  • Each source in its own place: POS, banks, invoices, Wolt

After

  • P&L builds itself every night, by the owner’s own rules
  • Every invoice matched with a bank payment
  • Ads and Wolt judged by margin, per location
  • One dashboard and a morning summary with alerts
What we built

The whole chain, end to end

From the first audit to a system that runs every day.

01

Audit

  • Money and processes across all sources
  • Report, tables and 16 charts
02

Data integration

  • POS, e-invoices for both companies, bank statements, owner’s spreadsheets, Wolt
  • Reloads never duplicate data
03

P&L engine

  • The owner’s own rules for every line
  • Reconciled with the owner’s spreadsheets
04

Dashboard

  • Money, Ads & Wolt; any location, any month
  • Any P&L line opens down to the documents; Excel export
05

Morning summary

  • Turnover vs a usual day, month to date
  • Alerts: large invoices, new suppliers, unpaid bills, Wolt
06

Reliability & privacy

  • Nightly loads with a run log, backups, uptime monitoring
  • Guests’ phone numbers stored only as hashes
Timeline

Step by step

Each stage was delivered and accepted before the next one started.

  1. July–August · done

    Audit

    Found a supplier invoice paid twice, and which delivery ads pay off 10× — and which don’t at all.

  2. September–October · done

    Discovery

    Every data source mapped: where it lives and what can be automated.

  3. Now · in progress

    System, stage 1

    Nightly data, P&L, dashboard and the morning summary.

  4. Next

    Stage 2

    Two new dashboard sections: guests and shifts.

Next case

Want the same for your business?

The first call is 30 minutes and free.