AutoBillDrive
Offline-First Desktop Billing & Invoicing Automation System
Offline-first desktop billing application for Windows with SQLite persistence, automated PDF generation, Google Drive sync, and WhatsApp delivery.
Automation & Utilities, Backend Systems
3 Months (Iterative Design & Deployment)
Electron
Windows 10 / 11 (x64, ARM64), macOS (packaged), Linux (deb/AppImage)
Problem, Solution & Engineering Scope
Operational Challenges & Cloud Fragility
Small workshops, service garages, and retail businesses face unstable internet connections and high subscription costs for cloud-based POS tools. Network downtime halts invoice generation, disrupts walk-in customer checkout, and leads to error-prone handwritten bills that cause tax discrepancies and inventory stockouts.
Offline-First Zero Latency Local Engine
A zero-latency, local-first Electron desktop billing station running an embedded SQLite database. Invoices and inventory updates commit atomically on the local disk within milliseconds. Whenever network connectivity is detected, background daemons sync encrypted backups to Google Drive and enable instant PDF delivery over WhatsApp.
- 1Deliver sub-10ms invoice persistence without requiring an active internet connection
- 2Generate professional, tax-compliant PDF invoices with custom headers and serial numbering in under 150ms
- 3Automate off-site cloud backups to Google Drive with zero configuration for non-technical shop owners
- 4Streamline digital distribution through instant single-click WhatsApp delivery
- Automobile Repair Shops & Service Centers
- Hardware & Raw Material Retailers
- Independent Contractors & Freelance Technicians
- Small Business Accounting Desks
Key System Capabilities
Engineered features and deep architectural implementations.
Invoice Management
Create, itemize, edit, and void invoices with automated tax calculations, discounts, and custom payment states.
Customer Management
Maintain comprehensive customer ledgers, transaction histories, credit balances, and one-click contact shortcuts.
Materials & Inventory
Manage stock counts, batch prices, low-stock warnings, and barcode/SKU mappings with auto-deduction upon billing.
Vector PDF Generation
Vector-precision PDF engine rendering customized multi-page invoices with branding logos, terms, and tax breakdown.
Google Drive Sync
Background watcher uploads encrypted database snapshots and compiled invoice PDFs whenever network connects.
WhatsApp Sharing
Dispatches generated invoices directly to customer WhatsApp numbers using deep-linked web automation.
Excel Import / Export
Bidirectional xlsx and csv synchronization to import customer databases or bulk-export monthly sales ledgers.
AI Invoice Review
Intelligent validation checking for duplicated line items, irregular tax tiers, and anomalous totals before printing.
Revenue Dashboard
Real-time visual reports tracking daily revenue, top-selling inventory items, outstanding credit, and tax liability.
Backup & Restore
Single-click encrypted local archive generation and restoration with automatic timestamped checkpointing.
AutoBillDrive IPC & Offline-First Persistence Architecture
Electron multi-process topology separating Chromium UI from the Node.js main supervisor with sandboxed IPC channels and an embedded SQLite transactional engine.
Presentation Layer
Electron Renderer (Chromium) running React/Tailwind UI with reactive state, responsive data tables, and instant print previews.
Application Core
Node.js Main Process handling system IPC, file system access, PDFKit vector rendering, and native OS dialogs.
Persistence Layer
Embedded SQLite 3 with Write-Ahead Logging (WAL) and PRAGMA foreign_keys=ON for atomic ACID commits.
External Services
Google Drive API (OAuth 2.0 refresh tokens), WhatsApp Web automation, and SheetJS Excel parsers.
Electron Renderer (Chromium) running React/Tailwind UI with reactive state, responsive data tables, and instant print previews.
Node.js Main Process handling system IPC, file system access, PDFKit vector rendering, and native OS dialogs.
Embedded SQLite 3 with Write-Ahead Logging (WAL) and PRAGMA foreign_keys=ON for atomic ACID commits.
Google Drive API (OAuth 2.0 refresh tokens), WhatsApp Web automation, and SheetJS Excel parsers.
Architectural Subsystems & Responsibilities
Renders billing workspace, customer directory, and dynamic data tables.
Enforces strict process sandboxing and validates all inter-process message payloads.
Executes business transactions, manages system events, and orchestrates sync workers.
Executes sub-millisecond local SQL transactions with write-ahead logging (WAL).
Constructs vector-perfect PDF invoices in-memory with custom layout coordinates.
Polls network connectivity and pushes incremental database backups and PDF artifacts.
Application Interface & Workflows
High-resolution screenshots showcasing user workflows, dashboards, and operational interfaces.

Revenue & Sales Performance Dashboard
Real-time summary of daily revenue, open receivables, and fast-moving inventory items.

POS Billing & Fast Line-Item Entry
Streamlined billing interface with instant product search, tax calculation, and split payment modes.

Customer Directory & Balance Ledger
Centralized directory tracking individual customer billing history, credit allowances, and contact details.

Vector PDF Invoice Preview & Print
High-precision vector PDF output rendered with custom branding, itemized tables, and tax breakdown.

Financial Reports & Tax Analytics
Detailed analytics breakdown covering GST reports, monthly turnover, and stock replenishment alerts.
Technology Stack & Core Tooling
Selected languages, frameworks, runtime environments, and engines.
Electron
Cross-platform desktop application shell with native OS API bindings and isolated IPC renderer.
Node.js
Main supervisor process handling file I/O, IPC message routing, and background sync workers.
SQLite
Embedded zero-configuration transactional database running in Write-Ahead Logging (WAL) mode.
PDFKit
High-performance vector PDF rendering engine generating itemized tax invoices in memory.
React
Component-driven user interface for POS billing forms, customer search, and inventory tables.
Tailwind CSS
Utility-first styling powering desktop dark mode and responsive layout grids.
Google Drive API
OAuth 2.0 automated cloud backup service syncing encrypted snapshots and invoices.
SheetJS (xlsx)
Bidirectional Excel and CSV data parser for bulk inventory imports and financial ledger exports.
Database Architecture & Schema
Normalized relational schema designed to 3NF standards, enforcing referential integrity with foreign key constraints, composite unique indexes, and SQLite Write-Ahead Logging (WAL).
Zero-configuration local SQLite persistence running in Write-Ahead Logging (WAL) mode. Transactions write to the WAL ring buffer with zero blocking on read queries, achieving under 2ms read/write latency. Automatic VACUUM and hourly checkpoints ensure zero database fragmentation.
One customer can have multiple invoices and historical payment records.
An invoice contains one or more itemized line products with quantity and tax rates.
Inventory materials map to billed line items to trigger automated stock decrements.
Table:invoices
Header records for all customer billing transactions and totals.
| Column | Type | Constraints | Description |
|---|---|---|---|
| id | INTEGER | PK | Auto-incrementing unique invoice identifier. |
| invoice_number | TEXT | - | Sequential formatted invoice code (e.g. INV-2024-0012). |
| customer_id | INTEGER | FK | Foreign key reference to the billed customer.→ References customers(id) |
| subtotal | REAL | - | Sum of line item amounts before tax and deductions. |
| tax_amount | REAL | - | Aggregated CGST, SGST, or IGST tax sum. |
| discount_amount | REAL | - | Discretionary discount applied to the bill. |
| total_amount | REAL | - | Final payable amount rounded to standard currency. |
| payment_status | TEXT | - | Status flag: 'PAID', 'PENDING', or 'PARTIAL'. |
| created_at | TEXT | - | ISO 8601 creation timestamp. |
Engineering Challenges & Technical Solutions
Complex bottlenecks, concurrency hurdles, and architectural decisions resolved during development.
Configured SQLite with PRAGMA journal_mode = WAL and PRAGMA synchronous = NORMAL, coupled with atomic transaction blocks wrapped in Node.js IPC handlers to guarantee zero state corruption.
Transactions are executed within db.transaction() scopes in better-sqlite3, committing to disk in <4ms with automated hourly VACUUM checkpoints.
Individual Contributions & Architectural Ownership
Sole Architect & Full-Stack Desktop Engineer responsible for design, desktop shell, data model, and local distribution.
Architected the multi-process Electron application with sandboxed IPC communication
Designed the 3NF relational SQLite schema with foreign key cascades and WAL mode
Built the dynamic PDFKit canvas layout engine for custom invoice compilation
Implemented Google Drive OAuth 2.0 token management and automated cloud sync daemon
Engineered single-click WhatsApp Web deep-linking for paperless invoice dispatch
Project Outcomes & Benchmarks
Deployed to active workshop environments, eliminating checkout delays during internet blackouts and cutting billing turnaround time by over 40%.
Local SQLite transaction write speed
Full vector document compile time
Zero cloud dependencies for billing
Faster customer transaction processing
- 1Thermal receipt printer driver support via ESC/POS direct USB printing
- 2Multi-terminal LAN synchronization allowing multiple checkout counters to share a local SQLite server
- 3Automated GST e-Way bill and e-Invoicing portal direct government API integration
Explore Other Architectures
EventApp
Production-ready event registration platform with Spring Boot 3.2, React 18, JWT RBAC, QR-code ticket generation, and async email confirmations.
FarmaShield
Digital biosecurity monitoring platform for agricultural and poultry operations with real-time risk dashboards, role-based workflows, and multilingual UI.
