Balqiso Trade Inventory Tracker Business Intelligence

Problem

Wholesale clothing business owner spent 15 hours/week manually tracking inventory across 3 supplier spreadsheets and disconnected sales records. This led to frequent stockouts (RM5K+ monthly losses), over-ordering (RM8K+ tied up), and no real-time profit visibility.

Solution

Created all-in-one Google Sheets system with automated intelligence:

Centralized dashboard with live stock levels for 100+ SKUs

Automatic profit calculations with real-time margin tracking

Automated reorder alerts when stock hits minimum threshold

Supplier integration with costs, payment terms, and contacts

Sales analytics with trend charts and performance insights

Financial overview with inventory value and cash flow

Results

Admin time: 15 hours/week → 3 hours/week (80% reduction)

Value of owner's time saved: RM3,200/month

Stockout incidents: Reduced by 85% (automated alerts)

Inventory turnover: Improved by 30% (data-driven purchasing)

Real-time profitability insight (previously impossible)