Gold Exchange MIS
Operations and inventory management system for a gold exchange with transaction tracking, Excel/PDF reporting, Redis caching, and comprehensive Filament admin panels.
Technical case study by Rojit Pokharel — Full-Stack Web Developer & System Architect, Kathmandu, Nepal
Stack diagram
- ›A gold exchange ran operations and inventory on spreadsheets — no real-time visibility into stock, transactions, or pricing.
- ›Managers needed structured reporting (Excel/PDF) for audits and daily reconciliation.
- ›High-read operational queries needed caching to stay fast during market hours.
- ›Full-stack developer — Laravel management information system with Filament panels, transaction tracking, reporting, and Redis caching.
- ›Designed the inventory and transaction schema.
- ›Laravel + Filament admin panels for inventory, transactions, pricing, and reporting.
- ›Redis caching for frequently read lookup data (current rates, item catalogs).
- ›Excel and PDF report generation for audits and daily reconciliation.
- ›Schema for items, batches, inventory movements, transactions, and pricing history.
- ›Inventory movements normalized so stock levels are computed from an immutable ledger.
- ›Role-based access distinguishing operators, managers, and administrators in Filament.
- ›Laravel behind Nginx, MySQL, Redis cache, Supervisor-managed workers for report generation.
- ›Redis-cached rates and catalogs keep the busiest queries off the database.
- ›Report generation runs in the background and streams large Excel exports.
- ›Inventory reconciliation was error-prone when tracked in spreadsheets.
- ›Large report exports could stall the web process if run synchronously.
- ›Immutable inventory-movement ledger makes stock levels auditable and computable.
- ›Queued, chunked Excel/PDF export generation with a ready notification.
- ›Production MIS replacing spreadsheet operations with structured, auditable transaction tracking and reporting.
- ›An immutable ledger is the right foundation for any inventory system.
- ›Cache the hot reads; queue the heavy reports.
Full-Stack
Real-World Impact: Production Projects That Deliver Results
A deep dive into six production projects that solve real business problems — from restaurant SaaS and insurance platforms to multi-container deployments and real-time systems.
Payments
Payment Gateway Integration in Nepal: eSewa, Khalti, ConnectIPS, FonePay
How to integrate Nepali payment gateways — eSewa, Khalti, ConnectIPS, FonePay — and how NRB rules shape e-commerce checkout, plus the common mistakes that cost money.
Answers
Read the Answers
Direct answers to questions about Rojit Pokharel and the technologies used across these projects.
Want a production system like this?
I build production web applications end-to-end. Let's discuss your project.
Get in Touch