SJ Lace
A Unified Desktop POS and Inventory Management system integrating FIFO-based stock tracking with double-entry financial ledgers. Designed for retail and wholesale distributors requiring real-time multi-location cash reconciliation, barcode-driven sales processing, and automated vendor return workflows.
A comprehensive desktop point of sale application designed for retail businesses managing lace and fabric inventory with advanced financial tracking and multi-user capabilities.
Project Gallery
A multi-level exploration of the interface and workflows.
Login Screen – Secure authentication portal with username and password fields.
Problem Synthesis
Traditional retail businesses, particularly in the lace and fabric industry, struggle with fragmented systems that separate sales, inventory, and financial management.
Key Challenges
- 01.Manual inventory tracking causing stock discrepancies and inability to track product movement
- 02.Disconnected financial records making it difficult to reconcile cash flow across multiple payment sources
- 03.Limited visibility into business performance with no real-time analytics or reporting capabilities
Project Objectives
Goal Deliver a unified desktop application that integrates sales, inventory, and financial management in a single system
Goal Implement real-time inventory tracking with FIFO-based stock management and automated profit calculations
Goal Provide comprehensive financial oversight through double-entry ledger system with multi-location cash tracking
Desktop point of sale application with support for both registered customers and walk-in sales
Real-time inventory management system with category-based organization and barcode support
Comprehensive financial platform with double-entry ledger, multi-bank support, and cash flow tracking
Multi-user system with role-based access control supporting four permission levels
Advanced reporting engine for sales, purchases, and expenses with date-range filtering
Automated backup and restore functionality with PostgreSQL database integration
Eliminated inventory discrepancies through automated FIFO stock tracking
Reduced financial reconciliation time by implementing automated ledger entries
Enabled data-driven decision making with comprehensive analytics dashboard
Technical Deep Dive
Frontend
01- React with TypeScript
- Ant Design UI library
- Redux Toolkit
- Recharts
- React Router
Backend
02- Electron Framework
- Node.js Runtime
- Prisma ORM
- PostgreSQL database
- bcryptjs for security
Desktop & Build
03- Electron Builder
- Vite Tooling
- Windows, macOS, and Linux support
Sales Management
01- Dual invoice system (Registered/Walk-in)
- Automatic year-based invoice sequencing
- Discount & payment processing
- Invoice voiding with audit trail
- PDF invoice generation
Inventory Control
02- Auto-generated product IDs & Barcode support
- FIFO-based stock tracking
- Low stock alerts & minimum level monitoring
- Opening stock & stock return processing
- Vendor return management
Financial Management
03- Double-entry ledger for all transactions
- Multi-bank account management
- Cash vault & counter tracking
- Vault-to-bank & local-to-vault transfers
- Party balance tracking (Vendors/Customers/Creditors)
Reporting & Dashboard
04- Real-time sales overview & trends
- Top-selling product analysis
- Categorized expense tracking
- Daily ledger statements
- Bank reconciliation reports
System Integrity
01- Four role levels (Developer, Super Admin, Admin, Staff)
- Bcrypt password hashing with salt rounds
- Audit logging for financial operations
- Secure local PostgreSQL authentication