Tally Prime MCP Server

Tally Prime MCP (Model Context Protocol) Server implementation to feed Tally Prime ERP data to popular LLM like Claude, ChatGPT supporting MCP client. This MCP Server helps expose functionalities of Tally to LLM directly.

Prerequisites

• Tally Prime (Silver / Gold)
• Node JS

Ensure below things are pre-installed and setup:

• Ensure to download & install Node JS from official website
• XML Port of Tally Prime must be enabled (F1 > Settings > Connectivity > Client/Server configuration) with below settings

TallyPrime acts as = Server
Port = 9000

Note: Kindly avoid using Educational version of Tally Prime, which has limitations of date range. It will result in invalid / partial data being fed to LLM, leading to highly degraded & incorrect responses.

Download

Avoid cloning repository directly. Utility is available for download (with required dependencies) on below link https://excelkida.com/resource/tally-mcp-server-v6.zip

Supported Platform

Implementation was tested on below AI platform

Setup (Local)

This mode of setup is to be used when MCP Client (like Claude Desktop, Perplexity etc.) and Tally Prime both exists in local PC. MCP Client software itself runs the MCP Server internally in such scenario.

Simply download & extract zip file somewhere on the disk. Assuming that we downloaded & extracted zip file on below path (folder)

D:\Software\Tally MCP Server

A sample setup for few popular tools is demonstrated.

Claude Desktop

Desktop version of Claude AI supports loading of local MCP server. Ensure you have Pro / Team / Max / Enterprise subscription of Claude, which supports higher limit compared to Free. MCP makes multiple calls to Tally for validation and inference, which might exhaust free limits quickly. Download Claude Desktop from following link claude.ai/download

Go to menu > File > Settings > Developer

This will open My Computer window. Right click and edit claude_desktop_config.json file (via Notepad) with as below JSON

{
  "mcpServers": {
	  "Tally Prime": {
		  "command": "node",
		  "args": ["D:\\Software\\Tally MCP Server\\dist\\index.mjs"]
	  }
  }
}

Note: single slash in folder path needs to be substituted with double slash

Save the file. Close Claude Desktop (menu > File > Exit) and again re-launch it.

Verify by clicking on Tools button and check if Tally Prime appears in the list (screenshot below)

Perplexity Desktop

Perplexity Desktop version for MacOS supports connecting to local MCP server. Configuration file (JSON format) is same as demonstrated for Claude Desktop. In absense of MacBook, documentation with screenshot could not be written. Kindly refer to below blog on perplexity website, which explains the steps.

Perplexity Desktop MCP Connectivity

Setup (Cloud)

This mode of setup is to be used, when using browser-based MCP client like ChatGPT, Claude AI, Copilot, OR mobile-based app for these LLM which cannot access Tally Prime running inside local PC. In this scenario, MCP Server needs to run as web-server, internally connected to Tally securely. Setup is quite complicated, and is covered in detail in docs folder of this project.

• Linux-based Server
• Windows Server (exploration in-progress)

Available Tools

list-master

Extracts list of specific master for auto-completion and validation if master exists, during inference by LLM

Input

Output List (or array) of queries master

Collections that can be queried:

1. Group
2. Ledger
3. VoucherType
4. Unit
5. Godown
6. StockGroup
7. StockItem
8. CostCentre
9. CostCategory
10. AttendanceType
11. Company
12. Currency
13. GSTIN
14. GSTClassification

chart-of-accounts

Extracts Chart of Accounts (or Group hierarchy) useful for preparing Balance Sheet, Profit and Loss, Trial Balance

Input

Output Tabular output with columns as below

trial-balance

Extracts Trial Balance for the specified period

Input

Output Tabular output with columns as below

balance-sheet

Extracts Balance Sheet as on date

Input

Output Tabular output with columns as below

profit-loss

Extracts Profit & Loss for the period

Input

Output Tabular output with columns as below

ledger-balance

Returns closing balance of ledger as on specified date

Input

Output Closing Balance of ledger (if exists)

Note: If specified ledger does not exists, LLM might invoke list-master tool to fetch list of ledgers. It will attempt to find closest possible ledger name for this list and re-run this action. This might produce un-predictable response.

ledger-account

Extracts ledger account for the specified ledger for the given period

Input

Output Tabular output with columns as below

stock-item-balance

Returns available quantity of stock item as on specified date

Input

Output Available Quantity of stock item (if exists)

Note: If specified stock item does not exists, LLM might invoke list-master tool to fetch list of stock items. It will attempt to find closest possible stock item name for this list and re-run this action. This might produce un-predictable response.

stock-item-account

Extracts account statement for stock item vouchers for the specified item for the given period

Input

Output Tabular output with columns as below

bills-outstanding

Extracts bill-wise outstanding Receivables / Payables report

Input

Output Tabular output with columns as below

Contact

Project developed & maintained by: Dhananjay Gokhale

Email: info@excelkida.com Whatsapp: (+91) 90284-63366