← All work
Manual to automatedGSTSmall business

Ashraf Traders

From a counter ledger to GST bills in one click.

Role
Product Owner, Business Analyst and engineer
Timeline
Jun 2026 – present
Context
Independent · client project
Status
Live
Live
ashraf-traders.netlify.app ↗

Problem

A family steel and roofing business ran every quote, bill and GST entry by hand across two shops. Quotes were taken over the phone, dues lived in a register, and every bill was typed again into Tally at filing time.

Outcome

Customers browse size charts and send quotation requests online; the shop turns a request into a GST invoice in one click and sends it on WhatsApp. Bills export straight into Tally, so nothing is retyped.

  • 1 clickfrom customer request to GST bill
  • 0bills retyped into Tally
  • 15product pages with size charts
  • 2shops in one system
Lifecycle8/10
  1. Discover
  2. Understand
  3. Define
  4. Ideate
  5. Prototype
  6. Build
  7. Launch
  8. Adopt
  9. Measure
  10. Improve

Discover · Understand · Define · Ideate · Build · Launch · Adopt · Improve

A short tour of the live product.

Before and after

BeforeAfter
CatalogueCustomers phoned or walked in to ask about sizesEvery product, size and thickness online with photos and size charts, per shop
EnquiriesQuotes written down from phone callsMulti-size quotation requests land in the admin
BillingHandwritten, GST worked out by handGST invoices with CGST/SGST or IGST, HSN codes and automatic numbering
PaymentsDues tracked in a registerPayments recorded per bill, balance due always visible
GST filingEvery bill retyped into TallyGST spreadsheet and Tally import files exported in one step
Two shopsSeparate books and stockOne system, each shop with its own stock, letterhead and invoice series

How it works now

  1. 01

    Browse

    The customer checks a size chart on their phone.

  2. 02

    Request a quote

    Several sizes and quantities in one request.

  3. 03

    Convert to bill

    One click fills a GST bill; totals calculate themselves.

  4. 04

    Share

    PDF or WhatsApp, on the shop's letterhead.

  5. 05

    Record payment

    Part or full payment saved against the bill.

  6. 06

    File GST

    Export to a spreadsheet and Tally, with no retyping.

The problem

Ashraf Traders sells M.S. beams, angles, channels, pipes and roofing sheets from two shops, in Bhandup and Padgha. Customers phoned to ask what sizes were in stock, quotes were written down from calls, bills were handwritten with GST worked out by hand, and the accountant retyped every bill into Tally at filing time.

My role

Product owner, business analyst and engineer. The owner had a real process but no specification, so I used working software as the elicitation tool: short demos, quick feedback, then the next slice. Version 1 runs the business today; version 2 is in progress.

Prioritisation

I sequenced the backlog by what unblocked revenue first:

  1. GST billing, because every sale needs a correct invoice.
  2. Per-shop catalogue and stock, so each shop sees its own.
  3. Quotation requests, so buyers can ask for prices online.
  4. Accounts and exports, so month-end is no longer manual.

The billing rules

  • An intra-state sale splits GST into CGST and SGST; an inter-state sale charges IGST. The form works out which applies.
  • Invoice numbers are allocated by the database per shop and year, so two bills can never share a number.
  • Totals are calculated in the database, so the website, the mobile admin app and the Tally export always agree.
  • Bills over ₹50,000 are flagged for an e-way bill, and its number is stored on the invoice.

Key decisions

Decision Why
Business rules in database functions with automated tests One source of truth for the website and the mobile app
Postgres Row-Level Security The public can read the catalogue and send requests; only admins can do more, and there is no public sign-up
Price by weight, size or piece Matches how steel is actually sold
Requests expire after 48 hours The inbox stays current without manual clean-up

Screens

Product catalogue
Product catalogue
Category page with size chart
Category page with size chart
Quotation request
Quotation request
Home page on a phone
Home page on a phone

Stack and tools

Next.jsTypeScriptTailwind CSSSupabase (Postgres)Row-Level SecurityExpoGitHub ActionsNetlify