Skip to Content
Skip to content
Odoo Technical

Moving From Tally to Odoo: Ledgers, GST and Opening Balances Done Right

A practical migration plan for Indian businesses: mapping Tally ledgers, open items, stock and GST, and proving the numbers match.

  • Published
  • 4 minReading time
  • 8Sections
Moving From Tally to Odoo: Ledgers, GST and Opening Balances Done Right

Most Indian SMEs I work with run their books in Tally before moving to Odoo. The motivation is almost always the same: accounting is in Tally, but sales, purchase and stock live in spreadsheets, so nothing ties together. Moving to Odoo fixes that, but only if the accounting data comes across cleanly. Here is the plan I follow.

Pick the cut-off date first

Choose a clean boundary, ideally the start of a financial year (1 April) or at least the start of a GST return period. Everything before it stays in Tally for reference. Odoo starts with opening balances on the cut-off date. Migrating years of historical vouchers rarely pays off and doubles the reconciliation work.

Map ledger groups to Odoo accounts

Tally organises ledgers in groups. Odoo uses account types. A mapping sheet agreed with the client's accountant is the backbone of the project:

Tally groupOdoo
Sundry DebtorsCustomers (contacts) + Receivable account
Sundry CreditorsVendors (contacts) + Payable account
Bank Accounts / Cash-in-HandBank and cash journals
Duties & TaxesGST tax accounts (CGST, SGST, IGST, TDS)
Stock-in-HandStock valuation account, fed by inventory
Sales / Purchase AccountsIncome and expense accounts

Customers and vendors become contacts with their GSTIN, state and PAN, not accounts. This is the single biggest conceptual change for Tally users.

Bring open items, not just balances

Importing a single opening balance per customer is quick, but it breaks ageing reports, follow-ups and payment matching. Import each unpaid invoice and bill as an open item on the cut-off date, with its original number, date and due date. Then customer payments received after go-live reconcile against the right invoice from day one.

Stock and valuation

Stock items become products with their HSN code, unit of measure and taxes. Godowns become warehouses or locations. Load opening stock with an inventory adjustment at the agreed cost, choose the costing method (AVCO or FIFO) up front, and check that Odoo's valuation equals Tally's stock-in-hand on the cut-off date.

GST in Odoo

Install the Indian localisation. It provides the chart of accounts, CGST/SGST/IGST taxes, fiscal positions for inter-state supplies and GST-ready invoice layouts. Depending on your edition and needs, the GST return reports, e-invoicing and e-way bill modules sit on top. Test intra-state and inter-state invoices, reverse charge and credit notes before go-live.

Reconcile to the last rupee

  1. Compare the trial balance of Tally and Odoo on the cut-off date, group by group.
  2. Compare party balances: every customer and vendor, not only totals.
  3. Compare stock valuation per warehouse.
  4. Get the accountant's sign-off before the first live transaction.

When Tally has to stay: integrating instead

Some groups keep Tally for statutory accounting while operations move to Odoo. Tally exposes an XML interface over HTTP (port 9000 by default), so Odoo can push sales and purchase vouchers and read masters automatically:

import requests

payload = """<ENVELOPE>
  <HEADER><TALLYREQUEST>Export Data</TALLYREQUEST></HEADER>
  <BODY><EXPORTDATA><REQUESTDESC>
    <REPORTNAME>List of Accounts</REPORTNAME>
    <STATICVARIABLES><SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT></STATICVARIABLES>
  </REQUESTDESC></EXPORTDATA></BODY>
</ENVELOPE>"""
response = requests.post('http://tally-server:9000', data=payload.encode(), timeout=60)

The same rules apply as for any integration: a mapping table, idempotent pushes (store the Tally voucher number), and a log of what failed and why.

Summary

A Tally to Odoo move succeeds on preparation: a clean cut-off, an agreed ledger mapping, open items instead of balances, and a reconciliation signed off by the accountant. Planning the switch? Let's plan your cut-over, or read the data migration playbook in my implementation guide.

You've reached the endFound it useful? Share it with your team.
Topics #Accounting#GST#Migration#Tally
Share
Gautam Kundaria
Written by

Gautam Kundaria

Odoo Techno-Functional Consultant with 5+ years of implementing, migrating and customising Odoo for businesses worldwide.

Planning to do this in your Odoo?

I implement, customise and support Odoo for growing businesses. Tell me what you need and I will reply within 24 hours.

Chat on WhatsApp