95% faster monthly reconciliation
Real-time stock valuation
The Problem
FMCG distribution operations suffered from fragmented tracking: sales reps wrote orders on paper or chat (WhatsApp/Qontak), inventory valuation was calculated manually on spreadsheets, and monthly reconciliation against bank statements took days, leading to stock mismatches and financial leakage.
Constraints
- [01]System must sync real-time stock across central warehouse, managers, and offline mobile POS.
- [02]Handling large-volume daily transaction logs and reconciling them without database locking.
- [03]Legacy WhatsApp order channel (Qontak integration) must feed directly into the pipeline.
Our Approach
We engineered a centralized ERP system with NestJS and PostgreSQL, complemented by a modular Vue 3 dashboard and a mobile-friendly POS. The core feature was an automated data reconciliation pipeline that mapped sales orders, stock valuation entries, and bank statements in minutes, backed by Qontak API integration to process social-commerce orders.
For operational software, matching the interface directly to existing real-world worker SOPs (like warehouse check-in/check-out) is more critical for success than complex enterprise abstractions.
Gallery
Outcome
- Replaced manual spreadsheets with an automated stock valuation pipeline.
- Reduced accounting reconciliation time from 5 days to under 15 minutes.
- Synced chat-commerce orders (Qontak) directly into warehouse fulfillment queue.
- Gave managers real-time analytics on product turnover rates and staff performance.
Why this matters
We avoided generic off-the-shelf ERP platforms that carry heavy subscription fees and rigid structures, building a tailor-made system designed around the exact warehouse SOPs and chat-ordering habits of the distributor's operations.