Customized ERP System for Small-Medium Business

THE STORY:How I Built a System that helped a growing manufacturing business replace five disconnected systems with one center system.

SECTOR: Production and Manufacturing Business/Multi-functional Business Operations

TOOLS: Airtable.

Scaling a production business is not just a manufacturing challenge, it is an information challenge. When HR lives in spreadsheets, sales happen over WhatsApp, and inventory is managed by memory, the business is not growing on a foundation. It is growing on luck. This is the story of what happens when you replace that fragility with real infrastructure.

A fully integrated ERP system that connects HR, finance, sales, operations, and inventory into a single dashboard, automated work and enabling centralized decision-making.

<aside> 🧗🏻

THE DIANOSIS

What Was Actually Going Wrong

From the outside, the business was operating. Orders were being fulfilled, staff were being paid, stock was moving. But inside, every department was running a separate, silent experiment in staying afloat. There was no shared language between HR, finance, sales, and operations and the cost of that silence was compounding daily.

The business had multiple disconnected systems:

Finance disconnected from sales - Invoices were raised in one tool, payments tracked in another, and sales confirmed over WhatsApp. Revenue was happening, but visibility into it was always three steps behind.
Inventory managed by instinct - Without a live count of stock, purchasing decisions were made on gut feel. The result was a cycle of costly overstock followed by damaging shortages both avoidable, both recurring.
Decisions made without data - Managers spent more time gathering information than acting on it. By the time a report was assembled, the window to respond had often already closed.
HR managed in spreadsheets - Attendance, payroll, and approvals lived in manually updated files. Every pay cycle was a hunt for the right version of the right sheet — and errors were a matter of when, not if.

</aside>

The Solution

One dashboard. Every department.

The solution was not to upgrade each department's individual tool. It was to eliminate the gaps between them entirely. Built on Airtable, the ERP system creates a single operational environment where every department feeds into and draws from the same live source of truth.

HR & payroll - Attendance, contracts, and payroll calculations connected in one place. Approvals trigger automatically. Errors stop before they happen.
Finance - Expense tracking, purchase orders, and payment status linked end-to-end. Every transaction creates a trail. Nothing falls through the cracks.
Sales - Sales orders flow directly into invoicing, which flows into revenue tracking. The full cycle — from order to payment — is visible in real time.
Inventory - Purchase orders automatically update stock levels. Low-stock alerts fire before shortages hit. Procurement becomes proactive, not reactive.
Operations - KPIs and performance data for every department surface in a single executive dashboard — giving decision-makers the full picture without asking for it. </aside>

<aside> ✨

THE SHIFT

Before and After

AREAS	BEFORE	AFTER
Finance visibility	The money movement from sales, revenue, expenses where scattered and alot of time was spend to calcuate and merge.	End-to-end financial tracking from revenue, sales, expenses to profits in one view
Sales process	Orders confirmed over WhatsApp, invoices raised manually, revenue always lagging	Sales orders trigger invoicing automatically; revenue data is live, not estimated
Inventory control	Stock levels guessed rather than tracked; shortages and overstock both routine	Real-time stock updates with automated low-stock alerts before shortages occur
Decision-making	Reports assembled manually; by the time data was ready, the moment had passed	Live KPI dashboard gives executives full operational visibility without asking for it
Scalability	Every new hire or new product line added more manual work to an already strained system	Modular architecture scales with the business — more volume, same operational overhead
</aside>

<aside> 📈

BUSINESS IMPACT

What it actually changed

Ability to scale operations without adding headcount.
50–70% reduction in administrative time across departments.
20–30% improvement in payroll and accounting accuracy.
Reduced stock mismanagement → cost savings of 15–20%.
Faster decision-making due to real-time dashboards. </aside>

The Philosophy Behind The ERP The goal was never to digitize what already existed. It was to redesign how the business thinks; connecting every department into one nervous system so that a decision made is felt immediately in inventory, finance, and operations.