AssanKhata – Multi-Business Invoicing & Management Platform
Offline-first multi-business management and invoicing PWA with seamless background cloud sync, multi-tenant switching, and PDF billing.
Project Overview
AssanKhata is an offline-first, multi-tenant Progressive Web App designed to empower small and medium businesses to manage invoicing, billing, customer and supplier ledgers, inventory, and payment tracking across multiple business profiles from a single unified dashboard. Built with an offline-first architecture using IndexedDB (Dexie.js), it allows users to create invoices and manage accounts seamlessly without an active internet connection, syncing automatically to Supabase when back online and generating professional PDF invoices.
Problem It Solves
Small businesses and multi-venture owners frequently face unreliable internet connectivity, causing traditional cloud-based POS and invoicing tools to freeze mid-transaction. Additionally, owners managing multiple distinct shops or enterprises needed a clean, isolated way to manage separate books, custom invoice sequences, and customer records without switching accounts or risking data leaks.
Tools & Technologies Used
Skills Involved
Challenges
Architecting robust offline-first synchronization alongside multi-business data isolation. Key complexities included building a reliable sync queue that handles optimistic updates with rollback capabilities, managing isolated sequential invoice numbering per business profile, and developing PostgreSQL RPC functions that gracefully resolve bidirectional conflicts when reconciling offline transactions.
Learnings
Mastered offline-first PWA design patterns, client-side caching with Dexie.js/IndexedDB, and distributed data consistency strategies. Gained in-depth experience structuring multi-tenant schemas with Supabase Row-Level Security (RLS), handling complex transactional integrity across offline queues, and engineering smooth, responsive mobile-first interfaces.