Free Excel POS & Inventory Management System — Run Your Shop Without Expensive Software
Meta description (for SEO): A complete Excel-based Point of Sale and Inventory Management System with GST billing, auto stock deduction, dashboard, reports, and printable invoices. Built with formulas + VBA. Beginner-friendly.
Tags: Excel POS, Inventory Management Excel, GST Billing Software, Free POS Excel, Excel VBA Project, Stock Management Spreadsheet, Small Business Tools

Download POS : https://xlgenai.com/upload/document/pos_010526133726.xlsm Tired of Paying ₹15,000+ Every Year for Billing Software?
If you run a shop, a wholesale counter, a pharmacy, a stationery store, or any small business — you've probably tried 3 or 4 different POS apps. They're either too expensive, too complicated, or they lock your data behind a monthly subscription.
There's a simpler way: a fully automated POS and Inventory Management System built entirely in Microsoft Excel.
No subscription. No internet required. No vendor lock-in. Your data stays on your computer. What's Inside the Workbook
This is not a basic template — it's a complete working system with 9 connected sheets:

Sheet	What it does
Dashboard	Live KPIs — Total Sales, Total Purchases, Profit, Low-Stock count, plus charts
Sales (POS)	The billing screen — pick product, enter qty, totals + GST auto-calculate
Product Master	Your full catalog with prices, GST %, opening stock, reorder levels
Customer Master	Customer database — feeds the POS dropdown
Supplier Master	Supplier list for purchase entries
Purchase Entry	Record stock-in — inventory auto-increases
Stock Register	Live ledger: Opening + Purchased − Sold = Current
Reports	Date-filtered Sales, Purchases, GST, Profit
Invoice Print	Clean A4 tax-invoice template, ready to print or save as PDF

A separate User Manual tab inside the file walks any new user through setup and daily operations. The Features That Replace Paid Software
Real POS Billing Screen

• Dropdown to pick any product from your catalog
• Auto-fetches Selling Price, GST %, and Available Stock
• Type quantity → Taxable Value, GST, and Total compute instantly
• Up to 10 line items per invoice
• Customer dropdown + Payment Mode (Cash / UPI / Card / Credit)
• Auto-incrementing invoice number (INV-0001, INV-0002, …)

Smart Inventory Control

• Auto stock deduction after every sale
• Auto stock increase after every purchase entry
• Block sale if stock unavailable — the cell turns red and the macro refuses to save
• Low stock alerts — popup after every sale lists items at/under reorder level
• Live Stock Register with color-coded status: Green (OK), Yellow (Low), Red (Out of Stock)

GST-Ready

• Per-product GST % (5%, 12%, 18%, 28% — whatever you set)
• Taxable Value, GST Amount, and Grand Total on every invoice
• GST collected and paid summarized in the Reports sheet
• Tax Invoice format compliant with GST display requirements

Dashboard with Charts

• KPI tiles for Sales, Purchases, Profit, and Low Stock count
• Top-Selling Products bar chart
• Sales / Purchase / Profit pie chart
• Updates the moment you save a sale

Date-Filtered Reports

• Change two dates and the entire Reports sheet recalculates
• Total invoices, taxable sales, GST collected, profit
• Total purchases and purchase GST
• Out-of-stock and low-stock counts

Printable Tax Invoice

• A4-formatted invoice with shop header, customer, GSTIN, line items, GST split, grand total
• One click → print preview, or save as PDF
• Customizable shop name and logo area

Barcode Scanner Support

• Any USB barcode scanner works out of the box
• It types the Product ID into the active cell — no extra setup
• Use the barcode value as your Product ID for instant scanning