The Problem
The business relied on manual record-keeping and spreadsheets to track inventory, sales, expenses, and payments. This caused errors, wasted hours weekly, and made it hard for the owner to understand profitability or stock levels in real-time.
The Solution
I built a custom system that centralised operations into a single platform. It tracks inventory levels, walk-in sales, expenses, and payments with clear reporting dashboards. I used Next.js for the frontend and Supabase for the backend to ensure real-time data sync across devices.
Key Impact
Outcome 1
Eliminated manual spreadsheets and saved several hours of admin work every week.
Outcome 2
Improved financial accuracy and profitability tracking for the business owner.
Outcome 3
Reduced manual inventory errors by 30% through automated stock deduction.