Switching billing apps? Do it in one evening.
By TejBill team · Updated · 5 min read
Quick answerTL;DR
- Move three things: items (with HSN and prices), parties (with GSTIN and balances), and opening stock.
- Don't switch on a random day. Switch on the 1st of a month, and run both apps for a week or two until staff are ready.
- TejBill imports .xlsx and .csv exports from Vyapar, myBillBook, Tally or Excel, shows a preview, and skips rows it already has.
Data migration is moving your records from one billing app to another: your item list, your customers and suppliers, what they owe, and the stock on your shelves. Done right, the new app opens with the same numbers the old one closed with.
Most shop owners stay on an app they don't like because they fear losing data. You won't, if you move the right things in the right order. This guide is a plan for one evening plus two weeks of overlap.
What data should I move when switching billing software?
Move your item list (name, HSN, GST rate, prices, barcode), your parties (name, phone, GSTIN, state, opening balance), and your current stock. Do not move old bills into the new app. Keep the old app's export or PDFs for records and start a fresh invoice series from your switch date.
| What to move | From old app | Into TejBill |
|---|---|---|
| Items | Item list → Excel | Import Data → Items |
| Parties | Party list with GSTIN → Excel | Import Data → Parties |
| Party balances | Outstanding / balance column | Opening balance column in the party file |
| Stock | Stock column in item list, or stock summary | Stock column in the item file, or Opening Stock |
| Old bills | Keep the export / PDF | Start fresh series from switch date |
Before you start: a checklist
- 1Pick the switch date. The 1st of a month, ideally the 1st of a quarter. GST returns stay clean: old app for before, new app for after.
- 2File or freeze the last return from the old app, so nobody edits old bills after you export.
- 3Export items and parties to Excel from the old app on the evening before the switch date.
- 4Take a stock count of fast movers, or use the old app's closing stock if you trust it.
- 5Note the last invoice number in the old app for your records.
How do I export data from Vyapar, myBillBook or Tally?
Every major app can export its item and party lists to Excel. Look for an Export or Download option on the items and parties screens, or in reports. In Tally, export the stock item list and ledger list to Excel from the display screens. Save the files as .xlsx or .csv; old .xls files need to be re-saved as .xlsx first.
Menus change between versions, so if you can't find export, ask the old app's support for an item list and party list in Excel. You only need the columns, not their exact layout. TejBill reads common column names like Item Name, HSN, GST %, Sale Price, MRP, Barcode, Party Name, GSTIN, State and Opening Balance.
How do I import into TejBill?
- 1
Open Import Data
Menu → Import Data. Only the owner or a manager can import.
- 2
Items first
Pick your .xlsx or .csv item file. TejBill shows a preview with how many rows are ready and which have errors.
- 3
Fix and re-pick
Fix error rows in Excel (often a missing name or bad GST rate) and pick the file again.
- 4
Import
Tap import. Items with an SKU you already have are skipped, so running the file twice is safe.
- 5
Then parties
Same steps with the party file. Balances become opening balances on each party's khata.
- 6
Check stock
Open the Stock screen and spot-check ten items against the shelf.
Tip
Can't find a template? The Import Data screen has a download button for a sample items file and parties file. Copy your columns into it if your export looks messy.
Heads up
Plan limits apply to imports. Free and Starter allow 500 items and 20 suppliers. Free allows 50 customers in total, and on Starter imported customers count toward the 50 new customers a month. A bigger list needs Professional. TejBill tells you before writing anything if the file is too big for your plan.
Should I run both apps at the same time?
Yes, for a short time. Bill in the new app from the switch date, but keep the old one open for lookups, old bills and returns against old invoices. After one or two weeks, when staff bill comfortably and the stock looks right, stop using the old app. Keep its backup and exports for at least the period your CA advises.
Seedhi baat
Dukaan band karke switch mat karo. Do hafte dono app chalao, phir purana band. Purane bill ka PDF sambhal ke rakho.
Common migration mistakes
“Switching mid-month”
Your GSTR-1 for that month then lives in two apps. Switch on the 1st.
“Forgetting party balances”
Include the balance column in the party export so udhaar carries over.
“Items without HSN”
Fill HSN in Excel before import. Fixing 300 items one by one later is painful.
“Importing old bills”
Don't. Keep old bills in the old app's export. Start clean.
Comparing where to go? Read our honest takes on a Vyapar alternative, a myBillBook alternative and a Tally alternative. Moving because of sync problems? See billing on mobile and computer without sync issues.
Frequently asked questions
Will I lose my old bills?
No, if you keep your old app's export or PDFs. Start a new invoice series in TejBill from your switch date, and keep old bills in the old app's records.
Can I import an .xlsx file directly?
Yes. TejBill reads .xlsx and .csv files directly. Old .xls files must be saved as .xlsx first.
Can I import old invoices into TejBill?
No. TejBill imports items (with opening stock) and parties (with opening balances), not past invoices.
What if I import the same file twice?
Items with an SKU you already have, and parties with a name you already have, are skipped. Nothing is doubled.