Kirana Shop Stock Register Excel Format Free Download (किराना स्टॉक रजिस्टर)
Track grocery product names, barcode/SKU numbers, categories, purchase costs, MRP selling prices, and opening stock counts for FMCG and retail counters.
| Item Name | Barcode / SKU | Category | Unit | Cost Price (₹) | Selling MRP (₹) | Stock Qty |
|---|---|---|---|---|---|---|
| Basmati Rice Premium 1kg | 890123450001 | Grains & Pulses | kg | 95.00 | 120.00 | 50 |
| Fortune Mustard Oil 1L | 890123450002 | Edible Oil | L | 142.00 | 165.00 | 24 |
| Tata Salt Vacuum Evaporated 1kg | 890123450003 | Spices & Salt | packet | 23.50 | 28.00 | 80 |
| Aashirvaad Shudh Chakki Atta 5kg | 890123450004 | Flour & Atta | bag | 220.00 | 260.00 | 30 |
| Maggi 2-Minute Noodles 70g | 890123450005 | Snacks & Instant | packet | 11.80 | 14.00 | 120 |
| Parle-G Glucose Biscuit 80g | 890123450006 | Biscuits & Bakery | packet | 8.20 | 10.00 | 150 |
| Surf Excel Easy Wash Detergent 1kg | 890123450007 | Cleaning & Laundry | packet | 125.00 | 145.00 | 40 |
| Colgate Strong Teeth Toothpaste 100g | 890123450008 | Personal Care | piece | 52.00 | 65.00 | 45 |
| Sugar M-30 Refinery 1kg | 890123450009 | Sugar & Sweetener | kg | 38.00 | 44.00 | 100 |
| Red Label Tea 250g | 890123450010 | Beverages | packet | 115.00 | 135.00 | 35 |
Why Indian Retailers Outgrow Excel Spreadsheets
Spreadsheets are designed for monthly accounting at a desk, not for serving 15 walk-in customers during evening rush hours.
Stock counts in Excel do not automatically reduce when you sell an item at the counter.
Takes hours every week to manually update quantities after counting physical shelves.
No low-stock alerts or re-order notifications when items fall below 5 units.
Cannot scan EAN-13 barcodes printed on grocery packages directly into a cell without lag.
Karobari reduces stock in real time on every bill. Scan any product with your phone camera, get automatic low-stock alerts, and import your existing Excel sheets in 5 seconds.
Frequently Asked Questions (अक्सर पूछे जाने वाले सवाल)
किराना दुकान में स्टॉक रजिस्टर (Stock Register) बनाए रखना क्यों ज़रूरी है?
किराना दुकान में 500 से 2,000 अलग-अलग सामान होते हैं। स्टॉक रजिस्टर रखने से यह पता रहता है कि कौन सा सामान ख़त्म होने वाला है, किसमें सबसे ज़्यादा मुनाफ़ा है, और गोदाम में माल की कोई चोरी या बर्बादी तो नहीं हो रही।
क्या इस एक्सेल रजिस्टर को सीधे Karobari ऐप में अपलोड किया जा सकता है?
हाँ! यह टेम्पलेट Karobari के कैटलॉग स्कीमा से 100% मेल खाता है। अपने पीसी या फोन में Karobari खोलकर 'इन्वेंट्री' → 'Import CSV' चुनें। आपके सभी सामान, बारकोड, खरीद रेट और एमआरपी केवल 5 सेकंड में लोड हो जाते हैं।
बिना बारकोड वाले खुले सामान (जैसे खुली दाल, चीनी) का स्टॉक कैसे दर्ज करें?
Karobari में आप खुले सामान के लिए अपनी पसंद का शॉर्टकोड बना सकते हैं (उदा. SUGAR1 या DAL2) या ऐप में उपलब्ध 'क्विक सेल' ग्रिड पर 1-टैप करके वजन अनुसार बिल बना सकते हैं।
Other Free Excel Billing & Stock Registers
Kaccha Bill Format in Excel and Word
Simple cash memo and rough estimate slip format for non-GST retailers, kirana stores, and contractors. Record ...
GST Tax Invoice Format in Excel with Formulas
Full GST Rule 46 compliant tax invoice format in Excel. Includes columns for HSN/SAC codes, taxable amounts, C...
Chemist Medicine Expiry and Batch Tracker Excel Format
Track pharmaceutical medicines, manufacturer batch numbers, expiry dates, rack locations, and purchase costs t...
Customer Udhaar Khata and Credit Ledger Excel Format
Manage customer credit, payment reminders, given amounts, received amounts, and running balance totals with ze...
Delivery Challan Format in Excel (GST Rule 55)
Compliant transport dispatch slip for goods movement between godowns, job work, and goods on approval without ...
Retail Cash Memo Format in Excel and Word
Simple cash memo format for non-GST retailers, kirana shops, and traders. Record serial numbers, customer deta...
Retail Barcode and Price Label Register
Master register for generating Code 128 and EAN-13 retail barcode stickers with item prices, size variations, ...
Hardware & Sanitary Quotation Format in Excel
Contractor and builder price estimate format with square feet, running feet, bags, and pieces. Ideal for hardw...