Free Excel Billing Formats & Retail Stock Registers
Download clean, ready-to-use spreadsheet formats for kirana inventory, daily kaccha bill tallies, pharmacy expiry tracking, and customer udhaar bahi khata. Open in Excel, Google Sheets, or 1-tap import directly into Karobari.
Kirana & Retail Stock Register
Track 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 shopkeepers move from spreadsheets to Karobari
Spreadsheets are great for back-office records, but a bottleneck during counter rush.
Barcode Scanning vs Manual Typing
Typing product names and prices into Excel takes 30 to 45 seconds per customer. With Karobari, point a USB barcode scanner gun or phone camera at the packet and the bill is ready in 2 seconds.
Instant Thermal Prints & WhatsApp
Printing from Excel requires formatting page layouts every time. Karobari prints compact 58mm and 80mm thermal receipts automatically, or shares formatted bills on WhatsApp in a single tap.
Free Bulk CSV Import
You don't have to re-enter your stock! Fill out our free Kirana Stock Register template, open the Karobari Web Till, and upload your CSV. Your whole store is migrated in seconds.
Questions about retail Excel formats & POS import
How do I open these templates in Microsoft Excel or Google Sheets?
Click 'Download Excel / CSV' on any template above. If using Microsoft Excel on PC, double-click the downloaded .csv file to open it directly. If using Google Sheets, open a new sheet, go to File → Import → Upload, and choose the file. All columns, prices, and sample rows will display in neat tabular format.
Can I import these stock and billing sheets directly into Karobari?
Yes! The Kirana Stock Register and Customer Udhaar templates are formatted to match Karobari's catalog import schema. Open the Karobari Web Till on your PC (app.karobariapp.in), navigate to Stock → Import CSV, and upload your saved sheet. All items, MRPs, and stock quantities load in 5 seconds.
Why do retail shops outgrow Excel spreadsheets for counter billing?
Excel works fine for end-of-month accounting, but fails on a live retail counter: (1) typing item names takes 45 seconds per customer vs 1 second with a barcode scanner gun, (2) cell formulas frequently get overwritten or corrupted during rush hours, (3) Excel cannot print to 58mm or 80mm thermal receipt rolls over USB or Bluetooth, and (4) Excel cannot display dynamic UPI QR codes for instant PhonePe/GPay payments.
Are these billing formats completely free to download and modify?
Yes, 100% free with no email gates, no paywalls, and no locked cells. You can customise columns, insert your own shop header, add GST rates, and modify them for your specific trade.