Skip to content

Agency ERP

One tool for a design studio's whole working day. Hours, working time, projects, offers, invoices and reports in one place, built around what the team really uses.

Role
Concept, UX/UI, build
Stack
Next.js, Supabase, Postgres
For
A design and branding agency
Year
2026

What it does

The agency had tried several tools over the years. Some did far more than a small team needs and buried the daily work under settings. Others were simple but missed the parts that matter at the end of a month.

So we built our own. It keeps only what the team uses every day and adds what no tool offered. Working time checks, a month close, holidays that update planning and invoices built straight from booked hours.

The numbers

  • 43

    database tables, every one protected by row level security

  • 0

    differences after moving years of history from the old tool

  • 2

    languages, English and German, switchable per person

Month end

  • Copying numbers between toolsabout a day
  • Review and confirmabout an hour

Rough estimate from the agency's own month end before and after.

How it works

No AI inside. Hours, money and working time have to be exact, so the rules live in the database and in plain code with tests. Every change is logged, closed months are locked and only the admin sees invoices, offers and reports.

  1. PersonLog timeQuick add or timer, on desktop or phone
  2. CodeCheckWorking time rules, breaks and budgets
  3. PersonClose monthEveryone confirms their month
  4. CodeBillUnbilled hours become an invoice
  5. OutputReportPDF invoices, payroll export and reports
CodePersonOutput
  • [ Next.js ]
  • [ Supabase ]
  • [ Postgres ]
  • [ Row level security ]
  • [ TypeScript ]
  • [ Tailwind CSS ]
  • [ EN / DE ]

Screens

1 / 6
Time tracking with the week strip and the entries of one day
Time tracking. The week at a glance and every day against its working time target.
Project page with booked hours, budget, hours per task and per person
Projects. Budget, hours per task and per person, and a forecast when the budget runs out.
Invoice with document preview, details and payments
Invoices. Built from booked hours, sent as a branded PDF, payments on the same record.
Planning board with planned hours per person and week
Planning. Hours per person and week, with holidays and sick days already taken out.
Working hours with times, breaks and legal checks per day
Working hours. Start, end and breaks per day, checked against the legal limits.
Management report with utilisation per person and month
Reports. Utilisation, revenue and open items per person and month.

What it brings

  • One place instead of five

    Hours, projects, offers, invoices and working time live in one tool.

  • Month end in an hour

    Everyone confirms their month, the admin reviews and bills.

  • Budgets warn early

    Projects turn amber at 80 percent and red when they run over, long before the invoice.

  • Every number traceable

    An amount on an invoice leads back to the hours behind it.

Good to know

The demo runs completely in your browser with a fictional studio, so you can click through everything without an account. Changes stay on your device and the reset button brings the starting data back. The real version runs on Supabase with logins, two factor sign in for finance roles and the agency's own data.

→

Watch Inventory