Back to projects
Illustration of the ERP workflow from factory records to an owner dashboard

Project report

From handwritten notebooks to a 20-minute weekly audit.

Custom ERP for a concrete block manufacturer

TypeCase study / manufacturing
ClientConcrete block manufacturer
UsersWatchman, salesperson, owner
Web appNext.js
ServerNestJS
DatabasePostgreSQL (TypeORM)
PlatformSupabase
DashboardsMetabase
4–6 hrsevery weekend
On this page

Overview

Built for an owner who needed a clear view of what was happening in his business.

This project aims to solve a real problem, and doesn’t fully demonstrate my tech skills or potential.

From paper trails to a clearer picture.

Before

A weekend spent piecing it together

The watchman recorded what left the factory. The salesperson recorded what was sold. Both sent photos of their notebooks to the office, where someone retyped the entries into Excel and built reports by hand for the owner.

Notebooks → Photos → Excel → Reports

4–6 hours every weekend

After

One entry, a live view

The watchman and salesperson each log their entries once in a simple web app. The system cross-checks the records, flags mismatches, calculates performance and builds reports. The owner gets live Metabase dashboards.

Two roles → One system → Dashboard

About 20 minutes every weekend

Watchman and sales records feed into one system, which powers the owner's dashboard

What it meant for the owner.

AreaResult
TimeThe weekend audit went from 4–6 hours to about 20 minutes, giving someone their weekend hours back.
VisibilityLive dashboards give the owner a clearer view of earnings and performance.
Trust in the numbersEntries are recorded once, cross-checked and no longer retyped from notebook photos.

Understand the work first.

  1. 01I spoke to the watchman, salesperson and owner separately before writing code.
  2. 02I mapped the whole paper trail, including the photo-to-Excel step nobody thought of as part of the process.
  3. 03I designed each screen around what that person already did on paper, making the change easier to adopt.

What I built.

A set of practical tools for the people doing the work and the owner keeping track of it.

ModuleWhat it does
Watchman + BillingCompare what left the factory with what was sold, and flag differences for review.
TrucksKeep arrivals, departures and loads connected to dispatch records.
Users & PermissionsGive each person access to the work they need to do.
Ageing ReportSee which payments are outstanding and how long they have been due.
ReportingGive the owner a live view of business performance through Metabase dashboards.

Want something like this for your business?

Tell me what is slowing your team down. I’d be happy to show you how this works.

Request a demo

Screens shown use anonymized demo data.