The General Store POS Web App packs 20 connected screens, an 8-KPI sales dashboard, and 19 built-in reports into a single Google Sheets web app — with role-based logins for six staff types and a delivery-and-pickup picking queue. Setup takes under 15 minutes, and the whole system is a one-time $39.99 purchase instead of the $60–$169+ monthly fee charged by cloud POS platforms.
Running a general store, grocery shop, or mini-mart on paper registers or a single spreadsheet makes it hard to track stock, reconcile the till, and fulfil delivery orders accurately. The General Store POS Web App solves this by giving every cashier a touch-friendly billing screen with SKU and barcode search, while the owner sees live sales, low-stock alerts, and a full audit trail from any browser.
🚀 Try the Live Demo Before You Buy
We have deployed this web app in our own Google account so you can test every page and every one of the 6 user roles — with real sample data — before purchasing. No signup, no email required.
🔑 Test Login Credentials
Sign in as Admin1 for full control over users, settings and every module, or try any of the other roles to see the exact permissions each staff member gets — from processing sales at the counter to view-only reporting. All passwords are abcd.
💡 What you get after purchase: The full source code (Code.gs + Index.html) plus a step-by-step deployment guide so you can deploy your own private instance in your own Google account in under 15 minutes.
Key Features of the General Store POS Web App
- Touch POS with SKU and barcode search — product cards grouped by category, with discount, 12% tax, delivery charge, hold, and payment on one screen.
- Counters, delivery, and pickup board — walk-in tills, delivery lanes, and pickup slots managed from one live view.
- Picking Queue — fulfilment tickets move through Pending, Preparing, Ready, and Served, with refrigerated-line flags.
- Six role-based logins — Admin, Manager, Cashier, Storekeeper, Inventory User, and Viewer.
- 19 Excel-exportable reports and an 8-KPI dashboard with 7-day and hourly sales trends.
- Inventory with auto stock deduction, purchase tracking, supplier directory, expenses, and shift cash reconciliation.
Three facts make the difference clear: the General Store POS Web App runs 20 screens from one Google Sheet, supports unlimited simultaneous users across six roles, and costs $39.99 once rather than hundreds of dollars per year in SaaS fees.
Screens Explanation
1. Login Page
Every user signs in with their own username and password, and the system loads only the screens their role allows. The page carries the store branding and a touch-friendly welcome panel.
2. POS / Billing
Cashiers build a cart from product image cards grouped into categories such as Groceries & Staples, Beverages, Dairy & Eggs, and Personal Care, using SKU or barcode search. The checkout panel handles the customer, discount, 12% tax, delivery charge, hold, and payment.
3. Held & Open Orders
Every saved or running order is listed with its number, date, type, counter, customer, item count, total, status, and cashier, so staff can resume, bill, or cancel it.
4. Counters
A live board grouped into walk-in Counters, Delivery lanes, and Pickup slots, each card showing status, running total, and customer, with one-tap start order, hold, or bill.
5. Picking Queue
Delivery and pickup orders move through Pending, Preparing, Ready, and Served. Staff pick each item and quantity, flag refrigerated lines, print the pick list, and filter to active tickets.
6. Bills
Search, reprint, void, or refund any completed bill with date-range and status filters. Each row shows the bill, date, type, counter, customer, cashier, total, payment mode, and status.
7. Dashboard
Eight KPI cards — Sales, Orders, Discounts, Tax Collected, Voids/Refunds, Held Orders, Open Counters, and Low Stock Items — sit above a 7-Day Sales Trend and Hourly Sales chart.
8. Reports
Nineteen ready-made reports cover daily sales, item and category analysis, cashier performance, payment modes, tax, voids, counter sales, picking, shift closing, stock, purchases, expenses, customer sales, and a full audit log — all export to Excel.
9. Products
The product master holds every item with its image, code, category, type, price, tax percent, stock, and status, with add, edit, import, export, and category management.
10. Inventory
A stock ledger records every movement with date, product, category, in/out quantity, running balance, and reference bill. Sales deduct stock automatically and low stock is highlighted.
11. Purchases
Stock inward from suppliers is logged with date, supplier, invoice, total, amount paid, and paid-or-partial status, and can be exported to Excel.
12. Suppliers
A directory of food and consumable vendors with contact person, mobile, email, credit terms, and status.
13. Customers
Guests, regulars, and loyalty members are stored with mobile, email, birthday, loyalty points, and status for targeted retail marketing.
14. Expenses
Daily spend is tracked against shifts with date, category, payee, amount, mode, linked shift, and bill copy.
15. Shifts & Cash Register
Cashiers open and close their till with opening cash, and the system reconciles expected against actual cash, flagging any difference.
16. Import / Export
Download a template for any module, bulk-import rows with validation, and export every module to Excel, up to 1,500 rows per file.
17. User Management
Admins add team members and assign roles — Admin, Manager, Cashier, Storekeeper, Inventory User, and Viewer — and manage usernames, passwords, and status.
18. List Management
Configure the dropdown master lists used across the app — product categories, units, payment modes, counter types, and expense categories.
19. Settings
Set the store profile, logo, tax rate, delivery charge, discount rules, receipt paper size, and the bill, ticket, shift, and order prefixes.
20. Audit Log
Every login, sale, void, refund, stock change, and edit is recorded with time, user, role, action, module, record, and details.
General Store POS Web App vs. Excel POS vs. Paid Cloud POS — Feature Comparison
| Feature | General Store POS Web App | Excel POS Template | Square / Vend / Lightspeed POS |
|---|---|---|---|
| Cost | $39.99 one-time ✅ | $5–15 one-time | $60–169+ / month |
| Platform | Google Sheets + Apps Script ✅ | Microsoft Excel | Proprietary SaaS |
| Setup time | Under 15 minutes ✅ | 30–60 minutes | 1–3 days + onboarding |
| Multi-user, role-based | Yes — 6 roles ✅ | No (single file) | Yes (paid add-on) |
| Mobile / tablet access | Yes — any browser ✅ | Limited | Yes (dedicated hardware) |
| Delivery & pickup picking | Built-in ✅ | Not available | Add-on / limited |
| Year-1 cost at 5 users | $39.99 total ✅ | $15 total | $720–$2,028+ |
| Audit log & void tracking | Full audit trail ✅ | Manual only | Yes |
For general stores and mini-marts that want a complete POS without paying Square or Lightspeed monthly fees, the General Store POS Web App sits in the sweet spot.
Who Should Use This Template
Perfect for:
- Independent general store, grocery, and mini-mart owners who want a full POS without a monthly SaaS fee
- Kirana and neighbourhood shops running walk-in, delivery, and pickup from one screen
- Store managers overseeing 1–5 outlets with a small counter and stockroom team
- Cashiers and storekeepers who need fast, touch-friendly billing and picking
Not a fit if:
- You are an enterprise supermarket chain needing SOC 2 compliance, weighing-scale integration, or dedicated POS hardware
- You require built-in payment gateways — card, UPI, and wallet payments are recorded manually
- You process 500+ bills per hour and need industrial barcode terminals
Real-World Use Cases
Ramesh runs a neighbourhood kirana store. He bills walk-in customers at two counters, takes phone orders into a pickup slot, and reconciles his cashier’s till at close — without paying $99 a month for a cloud POS. Barcode search rings staples in seconds and low-stock alerts tell him what to reorder.
Fatima operates a mini-mart with home delivery. She loaded 300 products across 12 categories and pushes every delivery order to the Picking Queue so her storekeeper packs the right items. Category and payment-mode reports cut her month-end reconciliation from four hours to twenty minutes.
David manages a grocery shop with a loyalty program. He tracks regulars and birthdays on the Customers screen and sends targeted promos, while shift reconciliation caught a cash discrepancy in week one that his paper register would have missed.
Advantages of the General Store POS Web App
- Massive cost saving — one $39.99 payment replaces $720–$2,028+ a year in cloud POS fees at five users.
- No new infrastructure — it runs in the Google account you already have, on any phone, tablet, or PC.
- Faster closing — automatic stock deduction, shift reconciliation, and Excel exports remove hours of manual work.
- Full accountability — the audit log records every sale, void, refund, and stock change by user and time.
Opportunities for Improvement
Being honest about the limits helps you buy with confidence. The General Store POS Web App records card, UPI, and wallet payments manually rather than through an integrated payment gateway, so it does not settle transactions automatically. It also does not connect to weighing scales or barcode-printing hardware, which high-volume supermarkets rely on. Because it is built on Google Sheets, extremely large stores with hundreds of thousands of transactions per year may prefer a dedicated database. For most independent stores, though, these trade-offs are minor next to the cost saving.
Best Practices
- Import your product list and opening stock through Import / Export before your first trading day.
- Set accurate categories and units in List Management so reports and the POS grid stay clean.
- Have each cashier open a shift with declared opening cash and close it at handover to keep the drawer reconciled.
- Review the Low Stock / Reorder report daily and raise purchases before you run out.
- Keep a regular Google Drive backup of the sheet and restrict Admin access to owners only.
Explore Relevant Templates
The General Store POS Web App shares its 20-screen engine with our other point-of-sale systems. If you run a different kind of shop, one of these may fit better:
- Pharmacy POS Web App — chemist and medical store POS with batch and expiry tracking.
- Hardware Store POS Web App — hardware and building-supplies billing and inventory.
- Bakery POS Web App — bakery-focused POS with product cards and picking.
- Restaurant POS Web App — dine-in, takeaway, and delivery POS with table and KOT management.
- Coffee Cafe POS Web App — café POS with menu cards, KOT, and shift reconciliation.
- Bar POS System Web App — bar, pub, and lounge POS on the same Google Sheets engine.
All of these are built with Google Apps Script web apps, so they deploy privately in your own Google account.
Frequently Asked Questions
What is the General Store POS Web App?
The General Store POS Web App is a 20-screen point-of-sale and store management system built on Google Sheets and Apps Script. It handles billing, counters, picking, inventory, purchases, suppliers, customers, shifts, expenses, and 19 reports for a general store, grocery shop, or mini-mart.
Does the General Store POS Web App need a subscription?
No. The General Store POS Web App is a one-time $39.99 purchase. It runs in your own Google account with no monthly fee, no per-user charge, and no hardware requirement, unlike Square or Lightspeed which bill $60–$169+ per month.
Can multiple cashiers use it at the same time?
Yes. The General Store POS Web App supports multi-user access with six roles — Admin, Manager, Cashier, Storekeeper, Inventory User, and Viewer — so several staff can bill, pick, and manage stock simultaneously in any browser.
How does the delivery and pickup workflow work?
Delivery and pickup orders are sent to the Picking Queue, where a storekeeper sees each item and quantity, marks refrigerated lines, and moves the ticket through Pending, Preparing, Ready, and Served before handover.
How long does the General Store POS Web App take to set up?
Setup takes under 15 minutes. You copy the Google Sheets file using the PDF guide, deploy the web app from Apps Script, configure your store settings, and add products and team members — no coding required.
Is my store data private?
Yes. All data stays in your own Google Sheets file inside your Google Drive, protected by Google’s security and 2FA. NextGenTemplates never has access to your store data.
About the Author
Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Conclusion
The General Store POS Web App gives an independent store everything a paid cloud POS offers — billing, counters, picking, inventory, shifts, and reporting — for a single $39.99 payment on a platform you already own. Click here to purchase the General Store POS Web App and deploy it in your own Google account in under 15 minutes.
Instant download · One-time payment · No subscription.
🎥 For step-by-step video tutorials, visit YouTube.com/@NeoTechNavigators.
Last updated: July 2026
