MRT POS

Small and medium retail shops — particularly mobile device and electronics retailers — were managing their entire operation across disconnected tools: spreadsheets for inventory, manual ledgers for cash, separate invoicing software, and no unified view of profitability. This created daily reconciliation headaches and left business owners unable to answer basic questions about stock, outstanding payments, or margins at a glance.

The client needed a single desktop application that could run entirely offline, protect sensitive financial data, handle printing natively, and consolidate every business function — without requiring a server, subscription, or IT team to operate.

We built MRT as a cross-platform Electron application with React and Tailwind CSS as the UI layer. The entire data model — customers, vendors, products, stock items, sales invoices, purchase invoices, expenses, cash entries, and payments — runs against a local SQLite database encrypted with SQLCipher. No cloud dependency means it works on day one with zero configuration.

Google Drive integration was built as an optional backup layer, letting owners export and restore their database without relying on a subscription service. Barcode scanning was integrated at the hardware level, and Node Printer handles receipt and invoice output directly to connected printers — no print dialog, no friction.

We modelled the data layer first — twelve entities covering every financial and operational object in a retail business — then built the service layer before a single UI screen was started. This meant every feature was backed by a tested, complete API before the React interface consumed it.

The UI was structured around the operational flows a shop owner actually runs: morning stock check, sale entry, supplier payment recording, and end-of-day cash reconciliation. DataSheet Grid was used for the bulk product and stock views, giving the feel of a familiar spreadsheet while maintaining full data integrity. Electron Builder packages the app into native installers for all three platforms from a single build command.