Export Tally data

Export data from Tally ERP 9

Here's a list of Tally supported XML tags to export data from Tally ERP 9.

CAUTION

This page contains technical information which is useful for developers / programmers and NOT for end-users.
End-users who wish to import data from Excel to Tally are requested to download and use udiMagic.

Menu Option : Gateway of Tally

Option	Download	Remarks
Balance Sheet	XML	Export Balance-sheet data from Tally ERP 9
Profit and Loss	XML	Export Profit and Loss data from Tally ERP 9
Stock Summary	XML	Export Stock Summary from Tally
Stock Summary -> F5 (Item-wise) -> Alt+F1 (Detailed)	XML	Export Stock Summary (Ledger-wise in detailed format) from Tally
Stock Summary	XML	Export Stock Summary (with Opening balance, goods inwards, outwards, closing balance etc
Ratio Analysis	XML	Export Ratio Analysis from Tally

Menu Option: Gateway of Tally • Display

Option	Download	Remarks
Trial Balance	XML	Export Trial balance data from Tally. Displays Group-wise Trial Balance
Trial Balance -> Alt+F1	XML	Export Trial balance data. Displays Group-wise Trial Balance with Ledger details
Trial Balance -> F2	XML	Export from Tally ERP 9 - Trial balance for a specific period
Trial Balance -> F5 [Ledger-wise]	XML	Export ledger-wise Trial Balance details from Tally
Trial Balance -> F12	XML	Export Trial Balance with options<br>"Show Opening balance=Yes"<br>"Show transactions=Yes"
Daybook	XML	Export Daybook from Tally ERP 9
Daybook -> F4 (@Sales)	XML	Export Tally Sales Vouchers only from Daybook
Daybook -> Alt+F12 (Filter for vouchers containing a <specific-Ledger>)	XML	Export vouchers for a specific Ledger from Tally
Daybook -> Alt+F12 (Filter for vouchers containing a <specific-group>)	XML	Export vouchers for a specific Group from Tally

Menu Option: Gateway of Tally • Display • Exception Reports

Option	Download	Remarks
Negative Stock	XML	Export from Tally - Stock Items with Negative Stock
Negative Ledgers	XML	Export from Tally - Ledgers with Negative balance

Menu Option: Gateway of Tally • Display • Account Book

Option	Download	Remarks
Cash/Bank Books	XML	Export Cash/Bank summary from Tally ERP 9
Ledger	XML	Export from Tally - Ledger Vouchers for a specific Ledger
Ledger -> Alt+B	XML	Export from Tally - Bill-wise Ledger details for a specific Ledger
Ledger -> F12 -> Show billwise details is set to Yes	XML	Export Bill-wise Ledger details for a specific Ledger from Tally
Ledger -> Alt+E [Show Voucher Numbers also]	XML	Export Ledger vouchers with the Voucher Number from Tally
Ledger Vouchers for specific period	XML	The Ledger Vouchers report returns data for incorrect period (corrected using TDL)
Group Summary	XML	Export details for a specific Group from Tally. Displays ledgers under that Group
Group Summary [F12]	XML	Export from Tally - Group summary along with Opening balance and transactions
Group Vouchers	XML	Export Group Vouchers for a specific Group from Tally
Sales Register -> SelectAnyMonth -> F12 @ Show Narrations = Yes @ Show Bill-wise details = Yes @ Show Cost centre details = Yes @ Show Invetory details = Yes	XML	Export Sales Register with Bill-wise; Cost Centre-wise; details with Inventory items and Narration.
Sales Register -> SelectAnyMonth -> F5	XML	Export Columnar Sales Register from Tally
Sales Register	XML	Export all Sales Vouchers created directly or indirectly under the SALES voucher-type
Purchase Register	XML	Export Purchase Register details
Journal Register	XML	Export Journal Register details
Debit Note Register	XML	Export Debit Note Register details
Credit Note Register	XML	Export Credit Note Register details

Menu Option: Gateway of Tally • Display • Statement of Accounts -> Outstandings

Option	Download	Remarks
Receivables	XML	Export Bills Receivables details.
Receivables -> F12 -> Show Opening balances	XML	Export Bills Receivables details with Opening balances.
Payables	XML	Export Bills Payables details.
Ledger	XML	Export Ledger outstanding details.
Group	XML	Export Group outstanding details.
Group >> F7 [BillWise] -> F12 [with All Bills]	XML	Export Group outstanding details [Billwise with All Bills]

Menu Option: Gateway of Tally • Display • Statement of Accounts

Option	Download	Remarks
Statistics	XML	Display Master and Voucher statistics.

Menu Option: Gateway of Tally • Display • Statement of Accounts -> Cost Centres

Option	Download	Remarks
Category Summary	XML	Export Cost Category-wise details from Tally.
Cost Centre Break-up	XML	Export Cost Centre-wise details from Tally.
Ledger Breakup	XML	Export Ledger-wise Cost Centre details from Tally.
Group Greakup	XML	Export Group-wise Cost Centre details from Tally.

Menu Option: Gateway of Tally • Display • Statement of Inventory

Option	Download	Remarks
Godowns	XML	Displays Godown-wise stock details. Tags provided to Export data in detailed as well-as "Expand All Levels" in detailed format.

Menu Option: Gateway of Tally • Display • Inventory Books

Option	Download	Remarks
Stock Item	XML	Export Monthly figures for a Stock Item from Tally. Displays INWARDS; OUTWARDS and CLOSING BALANCE figures month-wise.
Stock Item (Select Any Month and Press Enter)	XML	Export individual "Vouchers" details for a Stock Item from Tally Company.
Group Summary	XML	Export Stock-Item summary for a specific Group

Others

Option	Download	Remarks
Multiple Price levels	XML	Export the Multiple Price Levels defined in Tally Company. Equivalent to manually using this Tally Option:- 'Gateway of Tally -> F11 -> Inventory Features'. Next, set the 'Use Multiple Price Levels' to Yes.