General Store POS Web App

The General Store POS Web App runs an entire general store, grocery shop, or mini-mart from a single browser tab — 20 connected screens, an 8-KPI sales dashboard, 19 built-in reports, and role-based login for Admin, Manager, Cashier, Storekeeper, Inventory User, and Viewer. Setup takes under 15 minutes: deploy the script, set your business profile, load your products, and your counters are live.

🌍 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Google Sheets and web app solutions.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

🔑 Key Features of the General Store POS Web App

🔹 Complete 20-screen store suite — The General Store POS Web App covers every operational area from touch-screen billing to the audit trail, so a grocery shop or mini-mart can run daily trade without a monthly POS subscription.

🔹 Touch-friendly POS with SKU and barcode search — Cashiers build carts from product image cards sorted into categories like Groceries & Staples, Beverages, Dairy & Eggs, Bakery, and Personal Care. The live checkout panel handles customer selection, discount, 12% tax, delivery charge, hold order, and final payment on one screen.

🔹 Counters, delivery, and pickup in one board — Tills are grouped into walk-in Counters, Delivery lanes, and Pickup slots. Each card shows its live status (available, occupied, on hold), the running total, and the customer, and allows one-tap start order, hold, or generate bill.

🔹 Picking Queue for delivery and pickup orders — Every fulfilment ticket moves through Pending → Preparing → Ready → Served. Store staff pick each item and quantity, flag refrigerated lines, update status, and print the pick list from one board.

🔹 Six role-based access levels — Admin, Manager, Cashier, Storekeeper, Inventory User, and Viewer each get tailored screen access. Admins manage users, passwords, and settings; cashiers handle billing and shifts; storekeepers manage stock and picking.

🔹 19 built-in reports — Daily sales, bill-wise, item-wise, category-wise, cashier-wise, payment modes, tax summary, discounts, voids and refunds, counter sales, picking queue, shift closing, product stock, low stock and reorder, purchases, supplier payments, expenses, customer sales, and a full audit log — every report exports to Excel.

🔹 Inventory ledger with auto stock deduction — Every sale deducts stock. The inventory screen logs each movement with date, product, category, quantity in/out, running balance, and the reference bill, plus manual adjustments and low-stock highlights.

🔹 Shift and cash register reconciliation — Each cashier opens and closes their own till with opening cash declared. The system calculates expected cash from sales and flags the difference, so the drawer is reconciled before every handover.

📦 What’s Inside the General Store POS Web App

1 – Login Page

The secure sign-in screen where every user enters their own username and password to access the system based on their assigned role. It carries the DailyMart store branding, logo, and a touch-friendly welcome panel built for a busy till.

2 – POS / Billing

The main point of sale screen where staff build a cart from product image cards grouped into categories like Groceries & Staples, Snacks & Confectionery, Beverages, Dairy & Eggs, Bakery, and Personal Care. Each card shows live stock, and the checkout panel on the right handles the customer, discount, 12% tax, delivery charge, hold order, and final payment in one place. SKU and barcode search lets a cashier ring items in seconds.

3 – Held & Open Orders

Lists every saved or running order with its order number, date, type, counter, customer, item count, total, status, and the staff member who created it. From here you can resume an order, send it to billing, or cancel it.

4 – Counters

A live counter board grouped into Counter tills (C1, C2, C3), Delivery lanes (DL1, DL2), and Pickup slots (PK1, PK2). Each card shows its status of available, occupied, or on hold, plus the current order value and customer, and lets you start an order, hold it, or generate the bill in one tap.

5 – Picking Queue

The fulfilment board for delivery and pickup orders, moving each picking ticket through Pending, Preparing, Ready, and Served. Store staff see each item and quantity to pick, mark refrigerated lines, update status, print the pick list, or cancel the ticket, with an active-only filter to cut noise during a rush.

6 – Bills

Search, view, reprint, void, or refund any completed bill with a date range and status filter. Each row shows the bill number, date, order type, counter, customer, cashier, total, payment mode (Cash, Card, UPI, Wallet), and status, and can be exported to Excel.

7 – Dashboard

Opens with 8 summary KPI cards — Sales, Orders, Discounts, Tax Collected, Voids/Refunds, Held Orders, Open Counters, and Low Stock Items — for the selected date range, followed by analytical charts including 7-Day Sales Trend and Hourly Sales.

8 – Reports

The reports center provides 19 ready-made reports — daily sales, bill-wise, item-wise, category-wise, cashier-wise, payment modes, tax summary, discounts, voids and refunds, counter sales, picking queue, shift closing, product stock, low stock and reorder, purchases, supplier payments, expenses, customer sales, and audit log. Pick a report, set a date range, run it, and export to Excel.

9 – Products

The product master holding every grocery and household item with its image, code, category, type, price, tax percent, stock, and status. You can add, edit, import, and export products and manage their categories from one place.

10 – Inventory

The stock ledger that records every movement with the entry, date, product, category, type, quantity in, quantity out, running balance, and reference bill. Every sale deducts stock automatically, and the screen supports manual adjustments and low-stock highlights.

11 – Purchases

Records stock inward from suppliers, showing each purchase with its date, supplier, invoice number, total, amount paid, and payment status of paid or partial. You can raise a new purchase and export the list to Excel.

12 – Suppliers

Your directory of beverage, food, and consumable vendors, holding each supplier with their contact person, mobile, email, credit terms, and status. You can add suppliers and export the full list.

13 – Customers

Keeps your guests, regulars, and loyalty members with their mobile, email, birthday, loyalty points, and status. You can add customers, track loyalty points, and view upcoming birthdays for targeted retail marketing.

14 – Expenses

Tracks daily spend against shifts, recording each expense with its date, category, payee, amount, payment mode, linked shift, and bill copy. You can add expenses and export them to Excel.

15 – Shifts & Cash Register

Lets cashiers open, manage, and close their till sessions. Each shift shows the user, open and close time, opening cash, sales, expected and actual cash, and the difference, so the drawer is always reconciled before a handover.

16 – Import / Export

Handles bulk data: download an Excel or CSV template for any module, import rows with validation, and export every module to Excel. Rows with an existing ID update in place; rows without an ID insert as new records, up to 1,500 rows per file.

17 – User Management

Lets the admin add team members and assign roles such as Admin, Manager, Cashier, Storekeeper, Inventory User, and Viewer, each with its own access. It also manages usernames, passwords, last login, and active status.

18 – List Management

Configure the dropdown master lists used across the app — product categories, units, payment modes, counter types, and expense categories — with their display order and active status.

19 – Settings

Configure your business profile, billing rules, and print formats in one place. Set the store name, logo, and login image; tax rate, delivery charge, and discount rules; receipt paper size; and the bill, ticket, shift, and order prefixes.

20 – Audit Log

Records every important action in the system — logins, sales, voids, refunds, stock changes, and edits — showing the time, user, role, action, module, record, and details for full transparency and accountability.

📊 General Store POS Web App vs. Excel POS vs. Square / Vend — Where This Fits

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
Real-time team access (multi-user)	Yes — role-based ✅	No (single file)	Yes (paid add-on)
Mobile / tablet access	Yes — any browser ✅	Limited	Yes (dedicated hardware)
Delivery & pickup picking queue	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
Customizable product categories	Yes ✅	Limited	Yes (paid tiers)

For general stores, grocery shops, 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 This Template Is For — and Who It’s Not For

✅ This system is built for:

• Independent general store, grocery, and mini-mart owners who want a full POS without a monthly SaaS fee
• Kirana shops and neighbourhood stores running walk-in, delivery, and pickup from one screen
• Store managers handling 1–5 outlets with a small counter and stockroom team
• Retail entrepreneurs looking for a one-time investment in billing and inventory software
• Cashiers and storekeepers who need a fast, touch-friendly billing and picking interface

❌ This system is NOT for:

• Enterprise supermarket chains needing SOC 2 compliance, weighing-scale integration, or dedicated POS hardware
• Stores requiring built-in payment gateways (card, UPI, and wallet payments are recorded manually)
• High-volume outlets processing 500+ bills per hour that need industrial barcode terminals

⚙️ How to Use the General Store POS Web App

1. Purchase and deploy — Follow the PDF guide to copy the Google Sheets file to your Google Drive and deploy the Apps Script web app.
2. Configure settings — Set your store name, logo, tax rate, delivery charge, and receipt format in the Settings screen.
3. Load your products — Add grocery and household items with images, categories, prices, SKUs, and stock levels in the Products screen.
4. Set up counters and lists — Configure counters, delivery lanes, pickup slots, units, and payment modes via List Management.
5. Add your team — Create user accounts and assign roles (Admin, Manager, Cashier, Storekeeper) in User Management.
6. Open a shift — Each cashier opens their till with an opening cash amount before taking orders.
7. Bill and fulfil — Use the POS screen to ring up carts, hold orders, and send delivery or pickup orders to the Picking Queue.
8. Review daily reports — Run daily sales, shift closing, and low-stock reports at the end of trade from the Reports center.

💼 Real-World Use Cases

Ramesh runs a neighbourhood kirana store. He uses the General Store POS Web App to bill walk-in customers at two counters, take phone orders into the pickup slot, and reconcile his cashier’s till at close — without paying $99 per month for a cloud POS. Barcode search rings staples in seconds.

Fatima operates a mini-mart with home delivery. She loaded 300 products across 12 categories, pushes every delivery order to the Picking Queue so her storekeeper packs the right items, and tracks daily revenue by category and payment mode, cutting her month-end stock reconciliation from 4 hours to 20 minutes.

David manages a grocery shop with a loyalty program. He uses the customer loyalty screen to track regulars, send birthday promos, and monitor repeat visits, while the shift reconciliation feature caught a cash discrepancy in week one that his old paper register would have missed.

❓ Frequently Asked Questions

What does the General Store POS Web App include?

The General Store POS Web App includes 20 screens covering billing, held orders, counters, picking queue, bills, an 8-KPI sales dashboard, 19 reports, products, inventory, purchases, suppliers, customers, expenses, shifts, import/export, user management, list management, settings, and an audit log — all in one Google Sheets web app.

Does this work on mobile and tablet?

Yes. The General Store POS Web App runs in any modern browser, so it works on tablets, smartphones, and desktops without any native app install. The POS uses touch-friendly product cards and SKU or barcode search for quick billing at the counter.

How many users can access the system at the same time?

The General Store POS Web App supports multi-user simultaneous access. Each user gets their own login with role-based access — Admin, Manager, Cashier, Storekeeper, Inventory User, and Viewer — all working at the same time.

How does this compare to Square or Lightspeed POS?

Square and Lightspeed cost $60–$169+ per month plus hardware fees. The General Store POS Web App is a one-time $39.99 purchase with no monthly fee, no per-user charge, and no hardware requirement — ideal for independent stores managing costs carefully.

How long does setup take?

Setup takes under 15 minutes. You copy the Google Sheets file using the PDF guide link, deploy the web app from Apps Script, configure your store settings, and add your products and team members. No coding or IT support is required.

Can I customise the product categories and counters?

Yes. The List Management screen lets you define product categories, counter types, delivery lanes, pickup slots, payment modes, and units. The Settings screen configures tax, delivery charge, discounts, and receipt format — all without editing any code.

Is my data stored securely?

All data is stored in your own Google Sheets file within your Google Drive account. Google Drive provides enterprise-grade security, 2FA, and regular backups. NextGenTemplates never has access to your 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 (@PK-AnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.

🔗 Explore Related Templates

Looking for more point-of-sale systems? Explore our full range of Google Sheets Templates and web app POS tools:

• Pharmacy POS Web App — Chemist and medical store POS with batch, expiry, and the same 20-screen engine.
• Hardware Store POS Web App — Hardware and building-supplies POS with counter billing and inventory.
• Bakery POS Web App — Bakery-focused POS with product cards, picking, and shift reconciliation.

📖 Click here to read the Detailed Blog Post<

Watch the step-by-step video Demo:

Watch the step-by-step video Demo:

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

📅 Last updated: July 2026