Back to Portfolio
Desktop POS & ERP

HisabX — POS and Billing System

PythonPyQt5SQLite DatabasePyInstaller PackagingHTML/CSS ReceiptsGoogle Drive Backup

Project Overview

HisabX is an enterprise-grade standalone desktop Point of Sale (POS) and inventory ledger software developed specifically for retail electronics businesses. Unlike standard supermarket POS apps, HisabX solves the complex mathematics behind installment plans, interest-rate tracking, ledger schedules, and balance depreciation.

The application compiles into a single self-contained desktop executable with built-in localized SQLite databases, meaning that store terminals can operate seamlessly with 100% offline durability, zero cloud subscriptions, and absolute security. It also includes Google Drive integration for automated cloud backups.

Live Application Screenshots

Complete Feature Modules

📊

Live Financial Dashboard

Real-time KPI cards: Total Sales, Total Cost (Kharch), Net Profit, Credit/Qist Sales, Recovered Amount, Remaining Balance, Active Debtors — all filterable by time period.

💳

EMI Installment Engine

Automates remaining-balance equations, schedules monthly payments, and alerts on overdue installment cycles. PDF Report export per plan.

🧾

Thermal Receipt Printing

Supports both 80mm Thermal and A4 receipt formats. View, Reprint, and Delete any historical receipt. Custom HTML/CSS templates for branding.

📦

Inventory Control (15,708+ Items)

Full product catalog with category filters, brand/manufacturer filters, barcode support, pack & single unit tracking, and profit-per-unit display.

🛒

Smart Purchase Orders

Create purchase orders manually or import from PDF invoices. AI Invoice Scanning auto-fills product rows. Supports Finalize + PDF export in one click.

👥

Customer CRM

Full customer management: Basic Info, Contact Details, Credit Limit, Payment History, View Products, Edit/Delete. Category tagging (Dealer, Retail, etc.).

📒

Payables & Receivables Ledger

Double-entry accounting with Bank Accounts, Customer Balances, and a timestamped Recent Transactions log — Cust Credit, Bank Transfers, Refunds.

💰

Daily Cash Book

Cash Inflow (Sales Revenue, Bank Transfers, Credits) vs Outflow (Purchases, Returns, Salaries) — full day-end reconciliation per register session.

☁️

Google Drive Backup

OAuth-authenticated Google Drive integration. Daily auto-backup, upload-on-close, and timestamped cloud restore. Stores multiple backup versions online.

🔐

Role-Based Access Control

Local login system with Administrator vs Cashier clearance levels. Protects accounting archives, backup settings, and admin-only financial reports.

🖥️

100% Offline Operation

SQLite-powered standalone executable. No internet required for daily operations. Compiles to a single .exe via PyInstaller — deploy to any Windows machine.

🔄

Multi-Industry Adaptable

Core framework adaptable to Pharmacy, Grocery (Karyana), Marquee Booking, or Tailoring businesses by binding custom SQLite table schemas.

Database Architecture

The local database engine relies on a robust relational SQLite schema containing tables optimized for sub-millisecond transaction speeds:

  • customers: Names, phone numbers, WhatsApp, addresses, category, credit limit, and overall credit standings.
  • inventory: Item IDs, product codes/barcodes, current stock pools (packs + singles), base prices, sale prices, and profit margins.
  • sales: Receipt IDs, timestamps, customer link, down-payments, total invoice amounts, and payment type (Cash / Installment / Credit).
  • installments: Computes specific schedule lines, payment status, due dates, received amounts, and remaining balances per plan.
  • purchases: Vendor links, received quantities, purchase prices, invoice references, and shelf assignments.
  • cashbook: Daily session cash inflow/outflow register with category breakdowns per shift.
  • accounts: Customer & bank ledger entries with transaction type, amount, and descriptive notes per line.

Custom Build Options Available

  • Interest Table Adjustments: Configure custom interest rates, markup calculations, down-payment requirements, and penalty matrices for late payments.
  • Thermal Print Customization: Refactor HTML/CSS thermal templates to include custom logos, barcode trackers, promotional notices, and localized text.
  • Multi-Terminal LAN Syncing: Establish LAN SQLite replication to synchronize billing data across multiple cash registers.
  • AI Invoice Scanning: The built-in AI scanner auto-populates purchase order rows from supplier PDF invoices — already deployed in the purchase panel.
  • Cross-Industry Adapting: Adapt the POS framework to Karyana (grocery), Pharmacy, Shadi Marquee, or tailoring businesses.