Local-First Desktop ERP
Built a cross-platform desktop ERP with 9 modules using Electron and Next.js, running database queries offline via SQLite.
← Back to Work
2026 • Freelance Full Stack Developer
InBill ERP
Production-Grade Local-First Desktop ERP System for AF Nutrition
Project Overview
InBill ERP is a production-grade local-first desktop application developed for a live retail business in Bhavnagar. It features 9 operational modules: Billing, Inventory, Purchases, Parties, Expenses, Reports, Settings, AI Upload, and Dashboard. Implemented an AI invoice parsing workflow using Gemini 2.5 Flash to scan supplier invoices and auto-extract items, prices, and HSN codes directly into a review screen. Engineered a dual-mode database architecture (SQLite desktop / Neon PostgreSQL cloud) with a custom compatibility layer for 500-row batched sync, and integrated PDF invoice generation, WhatsApp Business API sharing, ledger-based credit accounting, and PIN-based security.
Technologies Used
ElectronNext.jsSQLitePostgreSQLNeonPrisma ORMGemini AIWhatsApp Business API
Key Features
AI Invoice Upload Workflow
Gemini 2.5 Flash scans invoice PDFs or images, extracting items, prices, and HSN codes into a review screen before inventory logging.
Dual-Mode Sync Engine
Uses local SQLite and Neon PostgreSQL cloud with a compatibility layer for 500-row batched syncing to maintain multi-device state.
Enterprise Utilities
Features PDF invoice generation, WhatsApp Business API sharing, ledger-based credit accounting, and secure PIN access control.