Most supermarket owners who want to change billing software put it off for one reason: the thought of typing thousands of items in again. That fear is fair. But a move does not have to mean retyping. It means getting your data out cleanly, fixing it once, and switching on a day you choose.
If you are still comparing options, see what supermarket billing software built for a busy counter looks like.
This guide is a checklist for moving off billing software you have used for years without losing your items, your stock or your khata. It does not go into the menus of any particular software. For how to export from your current software, ask whoever supports it for your installation.
Step 1: Decide what you are taking with you
Not everything in your old software needs to move. Some of it is history that only needs to be kept safe. Split it in two.
Bring into the new software:
| Data | Why it matters |
|---|---|
| Item list: name, barcode, unit | Without it the counter cannot scan |
| MRP, selling price, purchase rate | So the first bill rings up right |
| HSN code and GST rate | So bills and GST reports are right from day one |
| Current stock per item | Your opening stock |
| Supplier list with outstanding balances | So you know what you owe |
| Customer list with khata balances | So you know who owes you |
Keep safe, but do not move:
- Old bills, old purchase entries and old reports.
- Old GST returns and whatever your accountant has filed from.
Keep the second group as a full backup and an export in Excel or PDF. Under the CGST Act, a GST-registered business must keep its books and records for 72 months from the due date of the annual return for that year. So do not delete or uninstall the old software's data just because you have stopped billing in it. Keep the backup on two separate drives, or one drive and one cloud copy.
Step 2: Ask for an Excel export
Ask your current software's support person or dealer for an export of your item list, stock, suppliers and customers, in Excel or CSV. Ask for one file per type of data. Open each file before you go further and check:
- Does every row have a name?
- Are barcodes showing as full numbers, not as 8.9E+12? (Excel does this to long numbers. Format the column as text.)
- Are the MRP and selling price in separate columns?
If something looks wrong in the export, it is easier to fix now than after the move.
Step 3: Clean before you move
Years of billing leave mess in any item list. Moving is the one time you can fix it all at once.
- Delete what you no longer sell. Discontinued items, one-time items, test items.
- Merge duplicates. The same product entered twice under slightly different names, often with stock split between them.
- Make units the same. "PCS", "Pcs", "piece" and "nos" should become one.
- Fill in missing GST and HSN. Ask your accountant to check the GST column before you import, not after.
- Check loose items. Items sold by weight should be marked as loose, separate from sealed packs.
Do the clean-up in the Excel file, with a copy of the original kept aside. Do not try to clean inside the old software and the new software at the same time.
Step 4: Count, then switch
Your opening stock in the new software is only as good as the count behind it. The cleanest switch looks like this:
- Pick the day. A quiet weekday, close to the start of a month if you can. Your accountant gets a clean line between the old and the new.
- Count the night before. At least the fast movers and anything high-value. For the rest, the old software's stock is your best guess, and you correct it as you go.
- Close the day in the old software. Note the final cash, the last bill number, and take a full backup.
- Import and check in the new software. Items, opening stock, supplier balances, khata balances.
- Start billing in the new software the next morning. Do not bill in both. Two systems running at once means two stocks that never agree.
Step 5: What to check in week one
The first week tells you whether the move worked. Every evening, check:
- Price check on fast movers. Scan 20 of your best sellers and check the MRP and selling price on screen against the pack.
- Unscanned items. Keep a paper list at each counter of anything that did not scan. Add those items the same evening.
- Day totals. Cash, UPI and card in the drawer and the bank should match the day-end report.
- Khata. Ask two or three regular credit customers to confirm their balance when they next come in.
- Supplier balances. When the first supplier bills arrive, check the outstanding shown against the supplier's own statement.
- Accountant. Send the first week's sales and purchase reports to your accountant early, so any format problem is caught before the month ends.
Expect small problems in the first week: a missing barcode, a wrong unit, a price that was never updated in the old software. That is normal. Fix each one the same day so the list does not grow.
Train the counter before the switch
Give each cashier at least one practice session in the new software before day one. Cover the basics: scanning, loose items, returns, a customer on khata, closing the shift. A cashier who is unsure at 7 pm with a queue will go back to doing things by hand.
How MarCat handles it
We have run Banjara, our own supermarket in Ahmedabad, since January 2025. It ran on other software for about 15 months and has billed on MarCat since April 2026, so we have made this move ourselves.
- Items come with you. Items can be brought into MarCat from the software you use today or from Excel. We help you move, so you do not have to type your stock in again.
- Suppliers and khata in the same place. Vendor records with outstanding balances, and customer credit, stay in the same system you bill from.
- Reports for your accountant. GST-ready reports to download and hand over.
- Your data stays yours. You own your data and can export it whenever you want.
If you are thinking about moving your store and want to talk it through, message us on WhatsApp at +91 96787 65518.
