Mini-ERP: Unified Admin Module for a Growing Business

The Challenge

A trading and services company with around 30 staff members came to us at a point where their internal operations had outgrown the tools they were using. Different departments were managing their work in completely disconnected ways — inventory in one spreadsheet, purchase orders in another, employee leave tracked in a third, customer complaints logged in a shared email inbox, and internal reports assembled manually by the operations manager every week by pulling data from all of these sources.

The immediate pain points were specific: inventory counts were unreliable because the spreadsheet was not always updated in real time, leading to situations where stock was ordered that they already had, or commitments made to customers for items that were not actually in stock. Leave management was informal enough that scheduling conflicts happened regularly. And customer complaints occasionally fell through the cracks when the person monitoring the shared inbox was on leave.

They had considered a full ERP system but rejected it — the cost of implementation and the complexity of adoption for a 30-person team felt disproportionate to the problem. What they wanted was something that covered their specific pain points without requiring weeks of training or forcing them to change processes that were already working.

Our Solution

We scoped the project carefully to avoid the common trap of custom software becoming a full ERP rewrite. The goal was to solve the five specific problems that were costing the most time and creating the most risk — not to digitalise every process in the business simultaneously.

The inventory module tracks stock in real time with inward and outward logging, reorder level alerts, and a dashboard view of current quantities by product and location. Purchase orders are raised through the system and matched against incoming stock, which closes the loop on the inventory accuracy problem — the system reflects what is actually in stock because entries happen at the point of receipt, not retrospectively.

The leave management module allows staff to submit leave requests through the system, managers to approve or decline with a reason, and the calendar view to show who is out on any given day. Leave balances update automatically. The operations manager no longer needs to cross-reference a spreadsheet before approving — the system shows balance and team coverage simultaneously.

Customer complaints are logged through a simple form, assigned to the relevant staff member immediately, and tracked through to resolution with a timestamped audit trail. Nothing can be accidentally missed because no complaint closes without a resolution being recorded. Response time targets are visible on the dashboard.

The weekly management report — previously assembled manually from five sources — is now generated from the system in two clicks. It shows inventory status, open purchase orders, leave schedules for the coming week, open complaints and their ages, and a summary of the week's activity across all modules.

The system is role-based: staff see only what is relevant to them, department managers see their area plus summary data from others, and the directors see everything. This kept the interface clean enough that adoption happened quickly — users were not overwhelmed by data that was not relevant to their role.

Results

Technology Used