Tally XML vs ODBC: Which Method to Use?
TallyPrime offers two ways for other software to reach its data. ODBC is built for reading reports, while XML can also post data back into Tally. Here is how to choose between them.
Sumit Singh
Founder & Lead Automation Architect
1. The two interfaces at a glance
TallyPrime exposes its data through two interfaces. Both are useful, but they do different jobs.
ODBC lets reporting tools such as Excel or Power BI read Tally data as a database. Tally's own documentation describes the ODBC interface as read-only.
The XML interface works over HTTP. It can read masters and vouchers, and it can also send new data into Tally, which makes it the option for two-way work.
| Question | ODBC | XML over HTTP |
|---|---|---|
| Read reports and ledgers | Yes | Yes |
| Write vouchers into Tally | No | Yes |
| Typical use | Dashboards and BI tools | Imports, exports and two-way sync |
| Setup | Enable ODBC in TallyPrime | Enable the HTTP server and send XML requests |
2. When ODBC is the right choice
Choose ODBC when the goal is reporting. Trial balance, stock summary, sales register and receivables can all be read by a tool that connects over ODBC.
Because it is read-only, ODBC is a safer default when you only need Tally data in a spreadsheet or dashboard. Nothing can change your books through it.
- Management dashboards that refresh from Tally
- Read-only reports shared with partners or staff
- Connecting Tally to Excel or Power BI
3. When XML is the right choice
Choose XML when data must go into Tally, not just come out. Creating vouchers from another system is only possible through the XML interface.
XML also suits any system that can send HTTP requests, which makes it the usual choice for custom integrations.
Writing data into Tally changes your accounts. Test every import on a copy of the company before running it on live books.
4. How to enable ODBC
In TallyPrime, open Exchange and then Data Synchronization (older Tally ERP 9 versions use Gateway of Tally, then F12, then Advanced Configuration). Set Enable ODBC to Yes and keep the default port 9000, or choose another free port in the 9000 to 9999 range.
Restart TallyPrime after changing the setting. To confirm the server is running, open Help, then About, then Client/Server and ODBC Services, which shows the active port.
TallyPrime > Exchange > Data Synchronization
Enable ODBC : Yes
Port : 9000
TallyPrime acts as : Server (or Both)If port 9000 is already in use, Tally cannot start the ODBC service. Pick another port in the 9000 to 9999 range.
5. Quick decision guide
Start with ODBC if you only need to read data. Move to XML only when you have a clear need to write data back into Tally, and test it on a copy of the company first.
If you want Tally data in Google Sheets without building either integration yourself, see the TallyPrime to Google Sheets guide on the TallySync page.
Sources
Tally Solutions, pre-requisites for integrations: https://help.tallysolutions.com/pre-requisites-for-integrations/
Tally Solutions, XML integration: https://help.tallysolutions.com/xml-integration/
Tally Solutions developer documentation, data exchange: https://developer.tallysolutions.com/build/dataexchange
Frequently asked questions
Can ODBC change data in TallyPrime? No. Tally documents the ODBC interface as read-only. Use XML over HTTP if your process must write vouchers back into Tally.
Which port does ODBC use? The default is 9000. If another application already uses it, pick a free port in the 9000 to 9999 range and restart TallyPrime.
Do I need XML to build a dashboard? No. A dashboard only reads data, so ODBC is usually enough.
Related Insights & Guides
How to Consolidate Multiple Tally Prime Companies into a Single Google Sheet
Managing multiple GSTINs, branches, or sister companies in Tally? Discover how to automatically consolidate cross-company ledgers, sales registers, and cash positions into a centralized Google Sheets workbook without manual VLOOKUP nightmares.
How to Automatically Sync Tally Prime to Google Sheets on a Schedule (Zero-Middleware Guide)
Technical guide to integrating Tally Prime with Google Sheets via an independent third-party TDL connector and Google Apps Script. Learn how automated interval scheduling works, eliminate manual Excel exports, avoid costly per-user SaaS licenses, and protect 100% data privacy with zero third-party middleware.
Ready to Eliminate Repetitive Manual Work?
Schedule a 30-minute operational discovery call. We'll audit your spreadsheets, CRM, and communication channels to build an automated architecture.

