Skip to main content
Anil MauryaSoftware · AI · Automation

Retail & Distribution

Inventory & GST Billing Application

A demonstration of connected stock and billing: barcode counter invoicing, multi-location inventory, batch and expiry tracking, and live receivables ageing.

Demo buildRetail & Distribution
Type
Demo build
Category
Retail & Distribution
Features
10 documented
Stack
6 technologies
The problem

What the business was dealing with

A distributor with two godowns and a counter maintains stock in a spreadsheet and issues invoices from separate billing software. The two never agree, so orders get accepted for stock already sold. GST invoices are prepared by hand with tax calculated per invoice. Outstanding payments are known only approximately, so collection effort goes to whoever is remembered rather than whoever is most overdue.

The approach

How it was solved

One system where every invoice reduces stock and every goods receipt increases it. Barcode scanning makes counter billing fast at peak hours, GST is computed from item HSN and place-of-supply rules rather than by hand, and batch and expiry tracking supports first-expiry-first-out issue. Receivables ageing is live, with automated WhatsApp reminders that stop as soon as payment is recorded.

Interface

Illustrative screens

These are abstract representations of the interface layout, drawn in CSS — not screenshots of a client system. They show structure rather than data.

Counter billing. Barcode-driven invoice entry with live stock check and automatic tax computation.Illustrative UI
Stock position. Location-wise stock with batch and expiry visibility and reorder suggestions.Illustrative UI
Receivables ageing. Outstanding by customer and age bucket, with reminder status against each.Illustrative UI

Main features

  • Item master with units, conversions, HSN codes, barcodes and multiple price lists
  • Barcode counter billing with keyboard shortcuts and quick item search
  • GST invoicing with CGST, SGST and IGST by place of supply
  • Multi-location stock with transfers and in-transit visibility
  • Batch, lot and expiry tracking with FEFO issue suggestion
  • Purchase orders, goods receipt and supplier payables
  • Payment recording with part payments and advance adjustment
  • Receivables ageing with automated WhatsApp reminder sequences
  • Reorder level alerts derived from actual consumption and lead time
  • Reports: daily sales, stock valuation, ageing, non-moving items, GST summary

What this demonstrates

The engineering problems this project exists to show we can handle.

  • Transactional integrity between billing and stock movements
  • GST computation driven by data rather than per-invoice judgement
  • Batch and expiry handling with FEFO issue logic
  • Interface tuned for speed at a busy counter

Technology stack

  • Next.js
  • PostgreSQL
  • FastAPI
  • Barcode scanning
  • WhatsApp Business API
  • Thermal printing

Want something like this for your business?

Your operational detail will differ — that is normally where the real work is. Tell us how your process runs and we will scope it honestly.