Migrate from Tally ERP to Lekhya

Bring your ledgers, parties, opening balances and vouchers from Tally ERP 9 or Tally Prime into Lekhya. You see what will be imported, and what will be left out, before anything is posted.

What you need

Step 1. Export from Tally

Tally Prime

  1. Open your company in Tally Prime
  2. Go to Import & Export → Export (Alt+E)
  3. Select Masters → All Masters, Format: XML (Data Interchange)
  4. Repeat for Vouchers (Day Book) for the period you want
  5. Save the XML files. Tally may write them in UTF-16: that is fine

Tally ERP 9

  1. Gateway of Tally → Data
  2. Select Export, then Masters (All Masters) and Vouchers
  3. Format: XML (Data Interchange)
  4. Choose the same period for both
  5. Export and save the .xml files

Step 2. Upload to Lekhya

  1. Log in to Lekhya → Tally Migration
  2. Choose your Tally XML file (one file with both, or the Masters first and then the Vouchers) and click Upload & Parse
  3. Lekhya reads the whole file and shows a review: ledgers and parties, vouchers by kind, the opening balances and their date, what will be left out, and anything to look at
  4. Click Run Import and stay on the page. A big file is imported a little at a time; the bar shows how far it has got. If the connection drops, press the button again: what is posted stays posted and nothing is posted twice

Step 3. Verify in Lekhya

  1. Go to Reports → Trial Balance
  2. Compare with Tally's Trial Balance (same period)
  3. Closing balances should match to the last rupee, ledger by ledger
  4. Check Chart of Accounts: your Tally ledgers are there, bank and cash ledgers as bank and cash, capital as capital
  5. Check Vendors & Customers: your Sundry Debtors and Sundry Creditors, with their GSTIN, state and country where Tally had them

If totals don't match: look at the review and the import summary. A voucher that does not balance, or has a single line, is not posted and is listed with the reason. Vouchers dated before the opening balances are skipped (export Masters and Vouchers for the same period). Opening balances that do not net to zero in Tally are kept in an account called Opening Balance Difference.

What comes across, and what does not

Imported

  • Ledgers as accounts, placed by their Tally group, including groups you made yourself (a ledger in Debtors - South is a debtor, one in Admin Expenses is an expense)
  • Parties from Sundry Debtors and Sundry Creditors, with GSTIN (only if its check digit is right), PAN, state, country, address, phone and email. A party abroad is set up as an overseas party
  • Opening balances, as one journal on the first day of the books
  • Open bills: what each customer owes you and each supplier is owed when the file ends, as bills to collect and pay. If your Tally ledgers keep bills (bill-by-bill), the opening bills come across with their own names, dates and credit periods; otherwise a balance is one bill. Receipts, payments and credit notes in your vouchers settle the oldest bills first, and each sale or purchase still unpaid is a bill of its own, named and dated as in Tally. Record receipts and payments against them in Lekhya as usual, and the party's balance follows
  • Vouchers (sales, purchase, receipt, payment, contra, journal, credit and debit notes, and your own voucher types that are based on them) as journal entries, in the fiscal year that holds their date. Missing years are created

Left out

  • Cancelled and optional vouchers, and documents that post nothing: sales and purchase orders, delivery and receipt notes, stock journals, memorandums
  • Stock items and quantities, GST and TDS details on a voucher, cost centres, payroll
  • Which bill each receipt or payment in Tally settled: Lekhya settles the oldest first, so check an old bill against Tally's Outstandings report before you chase it
  • A voucher you edit in Tally after importing it is not updated when you import again

Imported vouchers are journal entries. They are in your ledger and in every report built from it, but they are not invoices, so they are not in your GST returns. The open bills are not either: they are balances brought forward, not supplies, and were reported by the books they came from. File GST for the months before the switch from Tally.

Need help with migration?

If you have a complex Tally setup (multiple companies, payroll, custom voucher types), contact us. We offer a free migration assistance call for Lekhya Practice and Firm plan users.

Get Migration Help →