← Back to portfolio Musa Mubarak Abdulaziz
Case study · Inventory & sales software

From paper ledgers to peace of mind: an offline inventory system for a Kaduna security doors business

Alhaji Usman runs a security doors and wallpaper shop in Panteka, Kaduna. Stock, sales and customer debts were kept on paper. Today he opens one desktop app and sees what is in the shop, what sold, what profit was made and who still owes him money, with no internet needed.

ClientAlhaji Usman, SUMC Security Doors
LocationPanteka, Kaduna, Nigeria
TradeSecurity doors and wallpaper
My roleDesign & development, end to end
PlatformWindows desktop app, fully offline
Built withElectron, React, TypeScript, SQLite

The client

A busy shop with high-value stock.

Alhaji Usman's shop in Panteka, Kaduna sells security doors and wallpaper. Doors are not small purchases: in the system's catalogue, prices run from ₦58,000 for a steel door up to ₦250,000 for a double door. Every unit that is miscounted, mispriced or sold on credit and forgotten is real money.

Until now the business ran on manual paper records for stock, sales and what customers owed. Paper depends on memory and on every entry being written correctly, and the more products, customers and staff are involved, the harder that becomes to guarantee.

I set the design goals from the start: a tool the team can learn in a day, that works without internet or a monthly subscription, and that lets the owner see the whole business on one screen instead of piecing it together from paper.

The problem with paper

Paper records fail quietly, and the owner pays for it.

Paper is cheap and familiar, which is exactly why businesses stay with it long after it has stopped working. The trouble is that its failures are silent. A wrong total, a missing line or an unrecorded debt does not announce itself. It shows up weeks later as money that cannot be explained.

Stock you cannot trust

To know how many of a particular door are left, someone has to count or add up pages of entries. Deliveries and sales written late or not at all mean the book and the shelf slowly stop matching.

Arithmetic errors

Totals worked out by hand on every sale invite small mistakes. On items costing tens or hundreds of thousands of naira, one slip can cost more than a day's profit.

Debts that live in memory

Credit sales are the lifeblood of building supplies and also the easiest money to lose. A debt book makes it hard to see the total owed, how old each balance is, or what has been part-paid.

Profit is a guess

Sales are easy to see on paper. Profit needs the cost of every item compared with its selling price. Few paper systems do this, so the owner knows how much came in but not how much he actually made.

No accountability

Anyone can write in a book, in any handwriting, and entries can be changed. The cost price of every product is visible to whoever holds the book, and it is hard to tell which staff member made which sale.

Slow, unreliable reports

A monthly summary means hours of adding up. Best sellers, slow movers and trends stay hidden, so restocking is done by habit instead of by evidence.

One fragile book

A single physical book can be damaged by water, lost, misplaced or altered. If it goes missing, so does the memory of the business.

Constant background worry

The hardest cost is not on any page: the owner cannot step away without wondering what is being written, what is being missed and what is being forgotten.

Paper versus the system

The same daily jobs, done two ways.

Everyday jobOn paperWith the inventory system
Knowing what is in stockCount by hand or flip through pages and trust the last tallyLive quantity on every product, with an alert when an item reaches its reorder level
Working out a saleTotals added up by hand on every saleTotals and balances calculated automatically; price adjustable per sale
Money owed by customersDebts in a notebook and in the owner's memoryA debtor list showing amount paid, amount outstanding and who made the sale
Knowing the profitNeeds cost and selling price compared by hand, so it is rarely knownEstimated profit or loss on the dashboard, and profit by product in reports
Staff accountabilityEntries in anyone's handwriting, hard to check, and cost prices visible to whoever holds the bookEvery sale tied to a staff account; sales by staff; cost prices hidden from staff
Finding a recordTurning pages and hoping the entry was writtenSearch products by name, brand or SKU and customers by name, phone or email
ReportsHours of adding up at month end, if done at allReports for any date range, daily or monthly trends, exports to CSV
Returns and correctionsCrossed-out lines and notes in the marginReturns recorded with reasons, and net revenue and profit shown after returns
Risk to the recordsOne physical book that can be damaged, lost or alteredTyped, searchable records inside the system instead of a single fragile book
Deciding what to reorderGuesswork and habitBest sellers and the low-stock list show what to buy next

The solution

Everything the business did on paper, in one place.

I designed and built a desktop application that installs on the shop's own Windows computer and keeps all of its data in a local database. There is no subscription, no cloud account to manage and no internet needed to make a sale. The screens follow the way the shop actually works: record a sale, receive stock, check what a customer owes, read the day's numbers.

Live dashboard

Sales, receivables, low-stock items, stock value and estimated profit or loss for the day on one screen.

Products with photos

A visual catalogue with price, cost (admin only), category and stock for every door, searchable by name, brand or SKU.

Fast sales entry

Pick a product, set the price, record the amount paid. The system works out the balance due and updates stock instantly.

Categories per product line

Each category collects the right details for that type of product, and new lines such as wallpaper can be added.

Supplier purchases

Stock arriving from suppliers is recorded and added to inventory automatically, with a full history.

Customers & debtors

See who owes what, how much has been paid, and mark balances paid as customers settle them.

Returns & receipts

Returns are recorded with reasons and reflected in net revenue and profit, and sales keep a receipt trail.

Reports & exports

Any date range, daily or monthly trends, revenue by category, profit by product and receivables aging, exportable to CSV.

Owner & staff roles

The owner controls accounts. Staff can sell and look up stock without seeing cost prices.

The system in use

A walk through the main screens.

SUMC login screen
Screen 1 of 9

Secure sign-in

Every person signs in with their own account. Accounts are created by the owner from Manage Users, so only people he approves can open the system, and every action is tied to a name.

SUMC dashboard with sales, receivables, stock alerts and profit
Screen 2 of 9

Dashboard: the whole shop in one glance

Today's sales, outstanding receivables, low-stock items, the value of the stock on the shelf and estimated profit or loss for the day, with recent sales, best sellers this week and sales by staff member underneath. This is the screen the owner opens first.

SUMC new sale screen with product search and cart
Screen 3 of 9

Recording a sale

Search the catalogue, build the cart, choose the customer and payment method and enter the amount paid. The total and the balance due are worked out automatically, and stock drops the moment the sale is completed.

SUMC products catalogue with photos, prices and stock levels
Screen 4 of 9

Product catalogue with photos

Each door has its photo, selling price, cost price (visible to the admin only), category and quantity in stock. Search by name, brand or SKU, or filter to show only items running low.

SUMC category management screen
Screen 5 of 9

Categories that match the trade

Fire, glass, interior, kitchen, security, sliding and steel doors, each collecting the details that matter for that type, such as size, height or style. New categories can be added for other product lines, so wallpaper can be tracked beside the doors.

SUMC purchases screen with supplier purchase history
Screen 6 of 9

Purchases from suppliers

When stock arrives, the purchase is recorded against the supplier and the quantities are added to inventory in the same step. A full purchase history and a supplier list are kept.

SUMC customers screen listing debtors and unpaid balances
Screen 7 of 9

Customers and debtors

The handwritten debt book became a live list: who owes what, how much has been paid, who made the sale and when, with one click to mark a balance fully paid once the customer settles it.

SUMC reports with revenue by category, best sellers, profit by product and receivables aging
Screen 8 of 9

Reports that answer real questions

Revenue by category, best sellers, profit by product and receivables aging for any date range, plus returns and the reasons for them. Sales, returns and aging can be exported to CSV for Excel.

SUMC manage users screen
Screen 9 of 9

Owner and staff access

The admin adds staff accounts, promotes or deactivates users and controls who can administer the store.

A day with the system

How the daily routine changed.

Open the shop, open the dashboard

Before the first customer arrives, the owner sees yesterday's activity, what is outstanding and which doors are running low. No books are opened.

Make a sale

Staff search the product, add it to the cart, choose the customer and payment method and enter the amount paid. The total and any balance are calculated and stock reduces automatically.

Sell on credit without losing track

If the customer pays part now, the rest is recorded as an unpaid balance against their name, ready to be collected and marked paid later.

Receive new stock

When a delivery arrives, it is recorded as a purchase from the supplier and the quantities go straight into inventory.

Close the day with certainty

The dashboard shows the day's sales, estimated profit and sales by staff member. The owner knows how the day went in seconds, not after an evening of adding up.

Plan the week with real numbers

Reports show best sellers, profit by product and ageing debts, so reordering and collections are based on evidence.

What it gives the owner: peace of mind

Features matter, but the real change is how it feels to own the business.

I know what is in my shop

Stock is a number on the screen that moves with every sale and delivery, not a figure someone remembers or a count that takes a day.

I know who owes me

Every unpaid balance has a name, an amount and a date. Money owed stops being a worry at the back of the mind.

I know what I really made

Estimated profit and loss are shown for the day, and profit by product shows which doors actually earn their place on the shelf.

I know what my staff are doing

Each sale is linked to the person who made it. Staff sign in with their own accounts and do not see cost prices.

No internet, no problem

The system runs on the shop's own computer. No network, no data bundle, no waiting for a website to load and no sale lost to a bad connection.

My records belong to me

There is no cloud subscription and no outside company holding the shop's numbers. The data stays in the shop.

The goal was simple: the owner can leave the counter and still know exactly how the business is doing.

Design decisions that mattered

Built around the realities of a small business in Nigeria.

1

Offline first

Unreliable internet is part of everyday life, so the app never depends on it. Everything is stored in a local database on the shop's computer.

2

Roles for owner and staff

The first account created becomes the admin. The admin adds staff accounts and controls who can administer the store. Sensitive information such as cost prices is hidden from staff, and checks are enforced in the application's back end, not just hidden on screen.

3

Secure sign-in

Passwords are stored only as hashes and never as readable text. The owner can deactivate an account instantly.

4

Stock that updates itself

Sales reduce stock and purchases increase it automatically, so the numbers on screen match the shelf without anyone counting.

5

Flexible categories

Doors, wallpaper and any future product line need different details. Categories define what is collected for each, so data stays consistent without forcing every product into one form.

6

Simple enough to learn in a day

A clear sidebar, large buttons and plain language follow the shop's routine, so staff do not need training in software.

ElectronReactTypeScriptSQLiteWindows installer

Still running your business on paper or spreadsheets?

I build inventory, sales and reporting tools that fit how your business really works.

Start a conversation See more projects