← All posts

Ecommerce-Ready Billing Software: Sell In-Store and Online From One Stock

Many shops in India manage their bills and stock in an Excel file. Over time the file gets several versions, formula errors and stock figures that do not match the shelf. Excel is free and works for a while, so this guide first shows how to use it properly, then explains when to move to billing software.


Bill book format in Excel (copy this layout)

If you're making bills in Excel, set up one row per item with these columns:

ColumnWhat goes in it
Bill No.A running number: 1001, 1002, 1003
DateBill date
Customer name & phoneSo you can call them when the new stock arrives
Item nameKeep spellings the same every time. "Shampoo 200ml" and "shampoo 200 ML" are two different items to Excel
HSN codeNeeded if you charge GST
QtyHow many
RatePrice per piece
GST %0, 5, 12, 18 or 28
Amount=Qty × Rate
GST amount=Amount × GST% / 100
Total=Amount + GST amount
Paid / DueHow much came in today, and how much is pending

Want to check the GST maths on a line? Use our free GST calculator.

Two useful tips:

  • Lock the formula columns (Review → Protect Sheet) so nobody types over them by mistake.
  • Keep one sheet per month. A single sheet with three years of bills can become slow and may freeze.

Stock management system in Excel (the simple version)

A basic inventory management xls sheet needs only six columns:

ItemOpening stockStock inStock outClosing stockReorder level
Blue packet402451=40+24-51 → 1315

Add conditional formatting so the closing stock turns red when it drops below the reorder level. Excel then shows you which items to reorder.

The limitation is that "Stock out" only works if someone updates it after every single sale. In practice, this is often missed.


Invoice quotation format

A quotation is a price offer given to a customer before the sale. Keep it simple:

  • your shop name, address, phone and GSTIN at the top
  • "Quotation" in big letters (so nobody mistakes it for a bill)
  • quotation number and date
  • customer name
  • item, qty, rate, amount, and GST if you charge it
  • "Valid till" date, because prices change
  • terms: delivery time, payment terms

When the customer says yes, the same details become the invoice. In Excel, that means copying the details and changing the heading from "Quotation" to "Invoice" by hand.


Five signs your shop has outgrown Excel

How many of these apply to your shop?

  1. You have more than one version of the same file. And the figures do not match.
  2. Stock on screen doesn't match stock on the shelf.
  3. Only one person knows how the sheet works. Work stops when they are away.
  4. Bills are made on paper first, then typed into Excel at night. So every sale is entered twice.
  5. You can't answer "what's my best-selling item this month?" without hours of work.

If two or more apply, it's time for billing software.

Excel is not bad. Your shop has grown beyond what a spreadsheet can handle.


What good billing software should do (that Excel can't)

Billing and stock in one step

When you make a bill, stock should go down on its own. No "stock out" column and no weekly stock matching.

That's how runkarobar works. You bill, and stock updates live. You can see profit, payments and best-sellers without building a single formula.

Billing software on PC and online

You want billing software for PC at the counter, because billing is faster on a full screen and keyboard when there is a queue.

But you also want billing software online, so you can check today's sales from home without going back to the shop.

runkarobar gives you both:

  • a Windows desktop app with silent one-tap printing for receipts and barcode labels, and USB barcode scanner support
  • an Android app on Google Play
  • any browser on your phone, tablet or PC

Same shop, same stock, everywhere. You do not need to email the Excel file to yourself.

Billing software with GST-ready products

If you're looking for billing software with GST in mind, start with your product list. In runkarobar, each product has GST-ready fields: HSN, company and unit. Set it once, and you stop typing HSN codes into a spreadsheet.

Billing software for retail shops

This is what runkarobar is built for. Clothing, footwear, electronics, general stores, wholesale traders.

  • fast POS billing and receipts
  • retail and wholesale billing with party khata (running balances, statements, "paying now / remaining" on every bill)
  • cost batches with exact profit on every sale
  • staff attendance with face + GPS, so you know who is at the counter
  • your own online store that sells from the same stock
  • AI Studio to turn product photos into reels and posters

One app replaces a spreadsheet, a register, an attendance book and a WhatsApp group.

Ecommerce-ready: sell in-store and online from one stock

This is where Excel has the most difficulty.

For example, a shop starts selling online. The blue packet now sells at the counter and on the shop's website, from the same shelf. With a spreadsheet, the two sales channels are hard to keep in line.

If the last packet sells at the counter at 6pm, the website keeps showing it as available. If someone orders it online at 9pm, the shop has to call the customer the next morning to cancel the order.

With runkarobar, your own online store runs on the same stock as your billing counter:

  • a bill at the counter reduces the stock online, instantly
  • an online order reduces the stock at the counter, instantly
  • no marketplace taking a cut on every sale
  • themes, categories, coupons, reviews and COD checkout
  • your own custom domain with free HTTPS

One stock, two ways to sell.


What about pharmacies and restaurants?

Many people search for billing software for pharmacy and billing software for restaurant.

A pharmacy needs batch and expiry tracking on every strip of medicine. Before you choose any software, check that it tracks expiry dates, not just stock.

A restaurant needs table orders and kitchen tickets (KOT). That's a different kind of software from shop billing.

runkarobar is built for retail shops and traders. If you run a store that sells products off a shelf, you're in the right place. If you run a kitchen, look for software made for restaurants.


So should you ditch Excel today?

Not necessarily.

If you have one counter, fifty products and time to update the sheet every day, the Excel formats above will serve you fine.

If the signs above apply to your shop, try this: run runkarobar alongside your spreadsheet for one month. It costs ₹1.

At the end of the month, compare which one gave you accurate stock figures.

Start your first month for ₹1 →


FAQ

Can I make a bill book in Excel?
Yes. Use one row per item with bill number, date, customer, item, HSN, qty, rate, GST %, amount, GST amount, total and paid/due. Lock the formula columns and start a new sheet every month.

How do I make a stock management system in Excel?
Track opening stock, stock in, stock out and closing stock for each item, with a reorder level. Use conditional formatting to highlight items below the reorder level. It only works if every sale is entered.

What should an invoice quotation format include?
Your shop details and GSTIN, the word "Quotation," a quotation number and date, customer name, items with qty, rate and amount, GST if applicable, a "valid till" date and your terms.

When should I switch from Excel to billing software?
When stock on screen stops matching the shelf, when you're entering sales twice (paper, then Excel), or when only one person understands the sheet.

Can I sell online and in my shop from the same stock?
Yes. runkarobar's online store uses the same stock as your billing counter, so a sale in either place updates both straight away.

Is runkarobar billing software available for PC and online?
Yes. There's a Windows desktop app for the counter, an Android app on Google Play, and it works in any browser. Your data is the same on every device.

How much does runkarobar cost?
Plans with billing start at ₹1,700/month, and your first month on any plan is ₹1. See all plans.

Ready to run your karobar?

Billing, stock, staff and your own online store in one app. Try your first month for ₹1.