MarCat

Moving to new billing software without retyping your stock

Switching your supermarket's billing software? What data to take out, what to clean before you move, when to switch, and what to check in week one.

By Swarbhanu Gupta, who has run Banjara supermarket in Ahmedabad since January 2025 (billing on MarCat since April 2026) · 10 November 2026

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:

  1. 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.
  2. 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.
  3. Close the day in the old software. Note the final cash, the last bill number, and take a full backup.
  4. Import and check in the new software. Items, opening stock, supplier balances, khata balances.
  5. 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.

Questions

What data should I bring when I change billing software?
Your item list with barcodes, MRP, selling price, purchase rate, unit, HSN and GST rate, plus current stock, supplier list with outstanding balances, and customer khata balances.
When is the best time to switch billing software?
Right after a stock count, on a quiet day, ideally near the start of a month. That gives you a clean opening stock and a clean line for your accountant.
Can I delete my old software's data after moving?
Not until you have a full backup or export. 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. Keep a full backup or export of the old data.
Will I have to type my items into MarCat again?
No. 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.