tally-mcp-server

sets the active company context in Tally Prime. This changes the global company context used by Tally for subsequent operations and report queries

sets the active reporting period in Tally Prime by specifying a from date and to date. This changes the global period context used by Tally for subsequent report queries

fetches stock item summary with fields stock_item_name, stock_group_name, opening_quantity, opening_value, inward_quantity, inward_value, outward_quantity, outward_value, closing_quantity, closing_value, returns output cached in pglite postgres in-memory table (specified in tableID property). synony…

fetches stock item remaining quantity balance as on date, tool returns quantity and unit of measurement

fetches GL stock item account statement with voucher level details containing fields date, voucher_type, voucher_number, party_name, quantity, amount, narration, tracking_number, voucher_category. party_name = ledger_name. quantity = inward as positive and outward as negative. amount = debit is nega…

fetches list of masters from Tally Prime collection e.g. group, ledger, vouchertype, unit, godown, stockgroup, stockitem, costcategory, costcentre, attendancetype, company, currency, gstin, gstclassification returns output in JSON string array in the property list

fetches ledger closing balance as on date, negative is debit and positive is credit, display Dr for Debit or Cr for Credit after the amount for better readability, instead of negative amount flip Debit or Credit to make it positive

fetches pending overdue outstanding bills receivable or payable as on date with fields bill_date,reference_number,outstanding_amount,party_name,overdue_days. outstanding_amount = Debit is negative and Credit is positive. party_name = ledger_name. returns output cached in pglite postgres in-memory ta…

fetches GL ledger account statement with voucher level details containing fields guid, date, voucher_type, voucher_number, alternate_ledger, party_name, amount, narration . amount = debit is negative and credit is positive. alternate_ledger = if amount is credit then ledger by which it is debited an…

returns collections metadata with collection and description

returns fields metadata for the selected tally collection containing field name, optional description and data type which can be string, number, date or boolean

returns predefined option values or drop-down values for the fields required for master and voucher creation, it returns back object array of pre-defined values

executes sql query on pglite postgres in-memory database for querying cached Tally Prime report data in table generated as output by other tools (in tableID property from tool output response). These tables are temporary and will be dropped after 15 minutes automatically. Use this tool to run comple…

queries a Tally Prime collection with selected fields and optional context like target company and reporting period. result is cached in pglite postgres in-memory table and returned as tableID. Use query-database tool to run SQL queries against that table for further analysis

fetches chart of accounts or GL hierarchy with fields ledger_name, group_name, primary_group, bs_pl, dr_cr, affects_gross_profit, sort_position. the column bs_pl will have values false = Balance Sheet / true = Profit Loss. Column dr_cr as value true = Debit / false = Credit. primary_group is the pri…

fetches trial balance with fields ledger_name, group_name (blank if Profit & Loss), opening_balance, net_debit, net_credit, closing_balance. opening_balance and closing_balance negative is debit and positive is credit. checks holds the total of each column, and on a balanced set of books the opening…

fetches profit and loss statement with fields like ledger_name, group_name, closing_balance. closing_balance negative is debit or expense and positive is credit or income. closing stock to be treated as credit, kindly fetch data from chart-of-accounts tool to pull group hierarchy before calling this…

fetches balance sheet with fields like ledger_name, group_name (blank if Profit & Loss A/c), closing_balance. closing balance negative is debit or asset and positive is credit or liability. Profit & Loss A/c carries the result of the period and is reported once, with a blank group_name. checks.closi…

creates new transactions or replaces existing ones in Tally Prime. amount = debit is negative and credit is positive, and every amount of a voucher must add up to zero. every ledger, voucher type and stock item is validated before anything is sent, so an invalid batch changes nothing in Tally. an al…

cancels or deletes existing transactions in Tally Prime. a cancelled voucher keeps its number and stays visible in the daybook with no entries, a deleted voucher is removed. every guid is looked up in the daybook first, so an unknown one changes nothing in Tally. this cannot be undone

fetches the daybook, one row per voucher entered in the period, with fields guid, date, voucher_type, voucher_number, reference, party_name, amount, narration, is_cancelled, is_optional. amount = total debit value of the voucher, always positive, and is zero for a voucher with no accounting entry su…

fetches one complete voucher by its guid, with every ledger line, bill reference and inventory line. use the daybook tool or the ledger-account tool first to obtain the guid and the date. amount = debit is negative and credit is positive, on the voucher itself and on every line. the result is return…

create or update ledger master data in Tally Prime, returns success count of created and / or altered records. a property left undefined keeps its current value in Tally, so a partial update is safe. read the result back with the query-collection tool on the ledger collection to confirm the fields T…

create or update accounting group master data in Tally Prime, returns success count of created and / or altered records

create or update stock group master data in Tally Prime, returns success count of created and / or altered records

create or update unit of measurement master data in Tally Prime, returns success count of created and / or altered records. a simple unit carries a symbol and a formal name, a compound unit is built from two existing simple units and a conversion

create or update godown or warehouse or location master data in Tally Prime, returns success count of created and / or altered records

create or update stock item or product master data in Tally Prime, returns success count of created and / or altered records. an opening balance needs the quantity together with a rate or a value

creates a new company in Tally Prime. this is not the same as the set-company tool, which only selects a company that already exists. the company is created in the data directory Tally is configured to use. Tally must accept company creation over the XML interface for this to work, so read the retur…

deletes a master object from selected collection in Tally Prime and returns success count of deleted records