AJSP Manager
LiveA full-stack PWA that replaced a 15-year Excel workflow for my family's automotive spare parts shop.
Why this needed to exist.
Amar Jyothi Spare Parts is my family's automotive spare parts retail shop in Karnataka. For about 15 years, the business tracked purchases, payments, and sales in Excel spreadsheets. Month-end was a slow manual tally, the spreadsheets grew brittle as formulas broke with every new row, and there was no single place to see where the business actually stood. Every six months, the entire stock also had to be counted by hand — writing down every item, counting quantities, then calculating the total stock value on paper.
How I built it.
I built a full-stack PWA using Next.js, Supabase, and TypeScript. The app tracks purchases, payments, and sales in real time — purchases entered as they happen, payments marked when cleared, and monthly summaries that show exactly where the business stands without a manual tally. Fund management and loan tracking were added later and are also in daily use. The inventory-count module is fully implemented and waiting for the next six-monthly count: every item is already in the system, so the count becomes 'enter the quantity, let the app do the math.' As a PWA, it is installable on the owner's and my mother's phones and works without any app-store distribution.
What it did.
The app is used daily by the family business and has replaced the 15-year Excel workflow for purchases, payments, sales, funds, and loans. Monthly visibility into performance is now a single screen instead of hand-reconciled spreadsheets. The inventory counting module is built and ready for the next six-monthly count — switching that process over is the last remaining step before AJSP Manager replaces Excel end-to-end.
What I used — and why.
Next.js
Full-stack framework — handles UI, Server Actions, and API routes in one codebase, with App Router + Server Components for fast navigation.
Supabase
PostgreSQL + Auth + Storage in one platform. Google OAuth with a 2-email whitelist means no sign-up flow to build, and invoice photos live in Supabase Storage right next to their rows.
TypeScript + Zod
Strict types end to end, with Zod validating every form input both client- and server-side so bad data never reaches the database.
PWA
Installable on the owner's and my mother's phones straight from the URL — no app store, no review process, and offline-tolerant for when the shop's connection drops.
Want something similar?
Available for freelance projects and contract engineering. Usually reply within 24 hours.