case study on tally erp 9

• TutorialKart
• SAP Tutorials
• Salesforce Admin
• Salesforce Developer
• Visualforce
• Informatica
• Kafka Tutorial
• Spark Tutorial
• Tomcat Tutorial
• Python Tkinter

Programming

• Bash Script
• Julia Tutorial
• CouchDB Tutorial
• MongoDB Tutorial
• PostgreSQL Tutorial
• Android Compose
• Flutter Tutorial
• Kotlin Android

Web & Server

• Selenium Java
• Learn Tally
• Tally Tutorial
• What is Tally
• Tally Basics
• Tally - Download & Install Tally.ERP 9
• Tally - How to Start Tally.ERP 9
• ADVERTISEMENT
• Tally - Screen Components
• Tally - F12: Configurations
• Tally - Accounting Features
• Tally - Inventory Features
• Tally - Statutory & Taxation
• Creating Accounting Masters
• Tally - Create Company
• Tally - Alter/ Delete / Shut Company
• Tally - Groups
• Tally - Create Groups
• Tally - Create Single Ledger
• Tally - Create Multiple Ledger
• Tally - Create Single Cost Center
• Creating Inventory Masters
• Tally - What is Stock group
• Tally - Create single stock group
• Tally - Create multiple stock groups
• Tally - Stock Categories
• Tally - Create Godowns /Locations
• Tally - Create Unit of Measures
• Tally - Create Stock items
• GST In Tally
• Tally - Enable GST in Tally.ERP 9
• Payroll in Tally
• Tally - Payroll Configurations
• Tally - Enable Payroll
• Tally - Enable Payroll Statutory
• Tally - Define employee category
• Tally - Define employee Groups
• Tally - Create Employees Master Data
• Tally - Create Simple Payroll Units
• Tally - Create Compound Payroll Units
• ❯ Tally Tutorial

Tally Tutorial | Learn Tally ERP 9

Tally tutorial – learn tally erp 9.

Tutorial Kart is now offering free training tutorials of Tally ERP 9. Learn Tally step by step with real time project scenarios from basic concepts to advanced concepts.

This Tally tutorials are especially designed for beginners, so that beginning learners can easily learn Tally.ERP 9 with zero knowledge.

Prerequisites  to Learn Tally ERP 9

• This Tally Tutorial is designed for beginners and professional learners, so every beginning learner can easily learn Tally through this tutorials without any experience or background knowledge.
• Basics knowledge on Accounting may add advantage to understand concepts of Tally.
• Tally software on your system for practice.

What do you learn through this Tally Tutorials

• Basic concepts of accounts that required for Tally
• How to use tally for educational purpose
• Real time Tally.ERP 9 project scenarios with examples
• Important interview questions and answers by topic wise
• Job placement guidance

Tally ERP 9 Training Syllabus

Refer below Tally Training Tutorial syllabus by concept wise for easy understanding and learning.

Tally Syllabus

• How to download and Install Tally.ERP 9
• How to start Tally on computer
• Tally Screen Components
• Create Company in Tally
• Alter/ Delete / Shut Company in Tally
• Accounting Features in Tally
• Company Features in Tally
• Inventory Features in Tally
• Statutory & Taxation in Tally
• Configurations in Tally
• What are groups in Tally
• How to create groups in Tally
• Create single ledger in Tally
• Create multiple ledgers in Tally
• Voucher types in Tally
• Create single voucher in Tally
• Create multiple vouchers in Tally
• Create single cost centre in Tally
• Create multiple cost centres in Tally

Popular Courses by TutorialKart

App developement, web development, online tools.

Tally ERP 9 Easy Learning Notes

Studycafe | May 25, 2020 |

To Start Tally ERP 9:-

Start >Programs >Tally ERP 9 >Tally ERP-9 Click

Double click on the Tally ERP 9 icon on your Desktop

Above Screen Components

Title Bar, Harizontal Button bar, Close button,Gateway of Tally,Buttons toolbar, CalculatorArea, Info panel.

While Working with TallyERP 9, use the following conventions: Mouse /Keyboard Conventions

Switching between Screen Areas:

When Tally.ERP 9 first loads, the Gateway of Tally screen displays. To toggle between this screen and the Calculator/ ODBC server area at the bottom of the screen, press Ctrl+N or Ctrl+M as indicated on the screen. A green bar highlights the active area of the screen.

Quitting Tally.ERP 9 :-

You can exit the program from any Tally.ERP 9 screen, but Tally.ERP 9 requires all screens to be closed before it shuts down

Following ways to quit working on Tally.ERP 9

1. Press Esc until you see the message Quit? Yes or No ? Press Enter or Y, or click Yes to quit Tally.ERP 9. 2. Alternatively, to exit without confirmation, press Ctrl+Q from Gateway of Tally. 3. You can also press Enter while the option Quit is selected from Gateway of Tally.

1). Creation of a Company:-

Go to Gateway of Tally > Company Info. > Create Company Or from the buttons bar select by using mouse Company Info. Or Alt +F3 to bring up the Company Info Menu

To Select a Company:-

Go to the Gateway of Tally > Alt + F3 > Company Info. > Select Company OR Press F1.

To Alter Company Details :-

Go to the Gateway of Tally > Alt + F3 > Company Info. >Alter

To Shut a Company :-

Go to the Gateway of Tally > Alt + F3 > Company Info. > Shut Company Or Alt +F1

2). F11: Features:-

Features are divided in to Four Major Categories –

• Accounting Features
• Inventory Features
• Statutory & Taxation
• Tally. NET Features

Gateway of Tally > Press F11 OR To Select F11:Features from button bar

Note: If you want change some features at any screen of Tally.ERP9 Press F11 (Functional Key).

Accounting Features :-

Go to Gateway of Tally > F11: Features > Accounting Features or click on F1: Accounts

Inventory Features:-

Go to Gateway of Tally > F11: Features > Inventory Features or click on F2 : Inventory

Statutory & Taxation:-

Go to Gateway of Tally > F11: Features > Statutory & Taxation or click on F3 : Statutory

Tally.NET Features:-

Go to Gateway of Tally > F11: Features > Tally.NET Features or click on F4 : Tally.NET

3). F12: Configurations:-

In Tally.ERP 9, the F12: Configurations are provided for Accounting, Inventory & printing options and are user-definable as per your requirements.

The F12: Configuration options vary depending upon the menu display. i.e., if you press F12: configure from Voucher entry screen, the respective F12: Configurations screen is displayed.

Go to Gateway of Tally > press F12: Configure

4). In Master Creation:-

Group and Ledger Creation

Group Creation:–

Go to the Gateway of Tally > Accounts Info. > Groups > Create Or A +G+C from Gateway of Tally

Group Alter :-

Go to the Gateway of Tally > Accounts Info. > Groups > Alter

Or A +G+A from Gateway of Tally

Group Display:-

Go to the Gateway of Tally > Accounts Info. > Groups > Display

Or A+G+D of Gateway of Tally

You can create Multiple Group:-

Go to the Gateway of Tally > Accounts Info. > Groups > CReate

Or A+G+R from Gateway of Tally

To Alter Multiple Group:-

Go to the Gateway of Tally > Accounts Info. > Groups > AlTer

Or A+G+T from Gateway of Tally

To Display Multiple Group:-

Go to the Gateway of Tally > Accounts Info. > Groups > DIsplay

How to create Ledgers:-

Ledger Creation:–

Go to the Gateway of Tally > Accounts Info. > Ledger> Create

Or A +L+C from Gateway of Tally

Ledger Alter :-

Go to the Gateway of Tally > Accounts Info. > Ledger > Alter

Or A +L+A from Gateway of Tally

Ledger Display:-

Go to the Gateway of Tally > Accounts Info. > Ledger > Display

Or A+L+D of Gateway of Tally

You can create Multiple Ledgers:-

Go to the Gateway of Tally > Accounts Info. > Ledger> CReate

Or A+L+R from Gateway of Tally

To Alter Multiple Ledger:-

Go to the Gateway of Tally > Accounts Info. > Ledger > AlTer

Or A+L+T from Gateway of Tally

To Display Multiple Ledger:-

Go to the Gateway of Tally > Accounts Info. > Ledger > DIsplay

Or A+L+I from Gateway of Tally

5). Creating Inventory Masters in Tally .ERP 9:-

Go to Gateway of Tally – Inventory Info.

Creation of Stock Group :-

Gateway of Tally > Inventory Info. > Stock Groups > Create

Or I+G+C from Gateway of Tally

Alter of Stock Group:-

Gateway of Tally > Inventory Info. > Stock Groups > Alter

Or I+G+A from Gateway of Tally

Creating Units of Measure:-

Gateway of Tally > Inventory Info. > Units of Measure > Create

Or I+U+C from Gateway of Tally

Creating Stock Item:-

Gateway of Tally > Inventory Info. > Stock Items > Create

Or I+I+C from Gateway of Tally

Creating Stock Categories:-

First change F11 Features -(F2 inventory features)-Maintain Stock Categories-set –Yes to get additional option Stock categories under InventryInfo.

Gateway of Tally > Inventory Info. > Stock Categories > Create or

I+C+C from Gateway of Tally

Creating Godowns:-

First change F11 Features -(F2 inventory features)-Maintain Multiple Godowns-set –Yes to get additional option Godown under Inventry Info.

Gateway of Tally > Inventory Info. > Godown > Create or

I+D+C from Gateway of Tally

6). Voucher Entry in Tally ERP 9 :-

Accounting Vouchers:-

Tally .ERP9 is Pre-Programmed variety of accounting Vouchers, each designed to perform a different Job. The Standard Accounting Vouchers are –

• Gateway of Tally > Accounting Vouchers> F4:Contra
• Payment Voucher (F5):- All payment entry in Payment Voucher
• Receipt Voucher (F6):- All Receipt entry maid in Receipt Voucher
• Journal Voucher(F7) :- All Journal Voucher used for other than cash/bank and Purchase of Goods & Sales of Goods
• Sales Voucher /Invoice (F8) :- The Sales Voucher used all cash bank Sales
• Credit Note Voucher (Ctrl+F8):- All Sales Return transactions here entered.
• Purchase Voucher (F9):- Cash or Credit Purchase entry made here.
• Reversing Journals (F10):-Reversing Journals are special Journals that are automatically reversed after a specified date. Gateway of Tally +F11 >F1: Accounting Feature –Use Reversing Journal & Optional Vouchers –Yes.

You can use the Memorandum Vouchers for:

• Payments towards suspense accounts – consider a company gives its employee cash for Conveyance expenses, the exact nature and cost of which are unknown. For such transactions, you can enter a voucher for the petty cash advance. A voucher to record the actual expenditure details when they are known, and another voucher to record the return of surplus cash. However, a simpler way of doing it is to enter a Memo voucher when the cash is advanced, and then turn it into a Payment voucher for the actual amount spent, when the actual details are known.
• Vouchers not verified at the time of entry – if you do not understand the details of a voucher you are entering, you can enter it as a Memo voucher and amend it later when the details are available.
• Items given on approval – Generally completed sales are entered into books. In case items are given on approval, use a Memo voucher to track and convert it into a proper Sales voucher. You can delete the memo voucher if the sale is not made.

7). Trade Discounts:-

If we want a separate column for discount in Invoices :-

• To activate Separate Discount Column in Invoice-

Gate Way of Tally-Press F11-Features-F2 for Inventory Features-

• Activate -Separate Discount Column in Invoice Set as –Yes

Use Different Actual & Billed Quantity

• When there is difference between Quantities purchase/sold and delivered,we have to specify quantities, at the time of invoicing.
• Example. We have delivered 4 T-Sharts out of which 1 T-Shirt free.then we will issue a bill for 3-T-Shirts.
• Active – Use Separate actual and billed quantity Columns as –Yes

Zero Valued Entries in Voucher:-

It is useful Free Samples -in Purchase or Sales vouchers time

Activate – Enable Zero-Valued transactions- Set –Yes

8). Cost Centres:-

Example of Cost Centre are –

• Department of an orgation-Finance,Manufacturing,Marketing,HR,Admin Etc
• Product/Service of a Company-Product X,Product Y, Product Z
• Individual such as Salesman -1,Salesman 2
• Go to Gateway of Tally > Press F11 Features- F1 for Accounting Features-
• Activate-Maintain Cost Centre-To Yes > Maintain more than one cost category to Yes and Accept the features

Creation of Cost category:-

Gateway of Tally—Accounts Info-Cost Category-Create

Creation of Cost Centre :-

Gateway of Tally—Accounts Info-Cost Centre-Create

9). Invoice No Number Creation:-

• Gateway of Tally-Accounts Info-Voucher Types- Alter- Sales-
• Method of Voucher Numbering- Select -Automatic-
• Use Advance Configuration-Set-Yes-Voucher Type Alteration Screen Display-
• Ask –Starting no, Width of Numerical Part- From date-Prefix & Suffix Details
• Example : TRP/00001/2020-21

10). Report Shortcuts Relating to Tally.ERP9.

All short cuts from Gateway of Tally-

• Purchase Register Required – D+A+P
• Sale Register ” – D+A+S
• Cash/Bank Book ” – D+A+C
• Journal Register – D+A+J
• Any Ledger Required – D+A+L
• Receivable Outstanding – D+S+O+R
• Payable Outstanding – D+S+O+P
• Outstanding Ledgers – D+S+O+L
• Cost centre Breakup Reports – D+S+C+O

Inventory Reports:-

• Physical Stock Register – D+I+P
• Stock Movement Analysis – D+I+M
• Cash Flow – D+C+C
• Funds Flow – D+C+F

Exception Reports:-

• Negative Stock – D+X+N
• Negative Ledgers D+X+L

Statutory Reports :-

• GST Reports- D+O+G
• TDS Reports – D+O+T

Written by:

A.Trinadha Rao , B.Com,MBA(B&F),PGDFT,(LLB) Tax Consultant Visakhapatnam,AP. M.NO.9505470390 W.NO. 9618673895 Mail-Id: [email protected]

StudyCafe Membership

In case of any Doubt regarding Membership you can mail us at [email protected]

Join Studycafe's WhatsApp Group or Telegram Channel for Latest Updates on Government Job, Sarkari Naukri, Private Jobs, Income Tax, GST, Companies Act, Judgements and CA, CS, ICWA, and MUCH MORE!"

• Join WhatsApp Group
• Join Telegram Group
• Follow On Google News

This Account belongs to Admistrator of Studycafe.

• View Our Courses
• Join Membership
•   About US
•   Privacy Policy
•   Terms of Use
•   Disclaimer
•   Refund Policy
•   Contact Us
•   Shop
•   Courses
•   Downloads
•   Private Jobs
•   Sarkari Naukri
•   Become An Affiliate
•   Submit Article
•   Education
•   Income Tax

you can also submit your articles by sending mail at [email protected]

• Join TDL Course Lifetime Access
• TDL Course at EMI(Ag.Credit Card)
• Tally ERP9 Course

Tour and Travels Management in Tally.ERP 9

• Practical Case Study with Examples and Images
• I LOVE TALLY

Today, we will study the case study of how to maintain Tour and Travels Management in Tally.ERP 9 along with practical examples. This is a pure  service industry and there is no inventory as such, they have specific billing requirements and have a rebate of 60% to 75% even this is changeable. We will take a case where a booking is done by a customer for traveling, food and other expense. We will charge all of that and in addition to that charge a service tax. Now there is a rebate of 60% in this department. If you have a greater rebate, you can mention that with the SL/Notification number and can avail that abatement. We have taken the customer by the name of Traveller. Now when the customer comes to us, we do the booking of this – this is a sales order for us.

We create the ledgers as :-

The items are created as follows, we show the multi Item creation mode for faster creation as I->I->R

Sales order voucher alteration as :-

The sales order numbering may be set as :-

The Sales order is created as :-

Now individually the details for each item is entered as:-

Just in case you ( you want to know how a service ledger is created:-

Now we go to accounting vouchers and then Press F8:-

The sales order- is tagged with the sales voucher :- The breakup of this voucher is shown as :-

The allocation for Hotel charges

As of now the service tax payable is shown as D–>O–>Service Tax Computation :-

Now a partial receipt is made as:-

The second receipt is made after 2 days :

Now the service tax payment is made to the Govt. using the autofill feature:-

Alternatively You may use the simpler method to make the payment as :-

Now we view the service tax computation after the payment is made and it shows:-

Here notice that Balance service tax payable is nil now 🙂 Now let us analyze the balance sheet as on 4th of the month where the payment was not made to the Govt. The amount  Rs. 17165 was pending to be received from the debtor, however, the Profit would remain the same.

After the receipt of the pending due and making the tax payment, finally, the balance sheet as on 30th April gives us the report as:-

PS* Please note all articles on the site are based on imaginary scenarios & are for educational purpose only.The author holds no responsibility in any form whatsoever.

Hi Just like you, I am one of the souls on EARTH who has a desire to be able to maintain my accounts accurately and be most efficient in using the powerful features of Tally. Currently I work as an accountant at a firm in Durgapur. I am a Tally lover and would be happy to solve your queries related to Tally, however I may not be able to reply to all the queries instantly but will surely try to solve them and give u a solution( provided I get free time from my daily work 🙂 )

11 thoughts on “ Tour and Travels Management in Tally.ERP 9 ”

it is very good for new learner i request you kindly sent Export sale entry and import purchase entry in tally erp9 and forex loss/gain how to adjust in tally and forgin curency conversion to indin currency in tally these are very important handling import and export procedure and also concept of bill of entry and shipping bill in tally erp9 therse are using custom duty.other wise you suggest tally book above portion should include i would like purchase.

Regards puttaswamy gowda

good evening sir, I am pavithra working in a travel agency as an accountant. Now we are using excel for accounts.I have worked as a tally teacher in tally academy for 3 years so I knew tally and I love tally. Now where I am working that is travelling agency here we have attached vehicles.The billing is different from the normal company, We have so many types of vehicles and different rates also, we should calculate hours and kilometer also. So I would like to know that can we use Tally for this agency.Please guide me in this matter.

Yes, you can use Tally.ERP 9 but you may need some customization to meet your requirements if you want the desired reports directly generated within the Software

Hello….. I am a travel agent, And I want to maintain passenger’s travel details like, PNR, Travel date, Number of passengers ect. With accounting option. Is this possible in Tally?

Yes its possible for tally, if interested contact me

Car Rental Hyderabad Telangana India, If required any car rental service from hyderabad please contact us hyderabad Car Rental

Thanks Alot Sir. This had help me to sort a starting entry of Travel & Tour Agency… I am also a tally lover and loved to used tally…since 10 years till now…

Akoade-Make Free Ready Made Web&App Good Information Cheap Web Hosting Start at Rs.39/Month

Hi, we are a start up travel agent based in mumbai. we are looking for tally based invoice for all the service, like hotel booking, cab service , visa , packages and etc. kindly help us with the tdl and platform for the same.

Hello Kunal, It doesn’t work that way. you will have to share the format of the invoices you want only then people can help you.

Comments are closed.

Invalid username or password.

  Developer Reference Topics

• Release 6.6.1
• Release 6.4.1
• Release 6.3
• Release 6.2
• Tally Definition Language - An Introduction
• TDL Components
• Symbols and Prefixes
• Dimensions and Formatting
• Variables, Buttons and Keys
• Objects and Collections
• Actions in TDL
• Functions in TDL
• User Defined Fields
• Reports Printing and Validation
• Voucher and Invoice Customisation
• Writing Remote Compliant TDL Reports
• General and Collection Enhancements
• Display Customised Reports in Browsers
• Release 5.5.2
• Release 5.4.9
• Release 5.4.8
• Release 5.3.8
• Release 5.3
• Release 5.2
• Release 5.0
• Release 4.8
• Release 4.7
• Release 4.61
• Release 4.6
• Release 4.5
• Release 3.62
• Release 3.61
• Release 3.6
• Release 3.0
• Release 2.0
• Release 1.8
• Release 1.61
• Release 1.6
• Release 1.52
• Release 1.5
• XML Message Formats
• Components of Request or Response
• Significance of Tags
• Case Study I – Using XML Request and Response Format
• Case Study II – Creation and Alteration of Vouchers through VB
• Case Study III – Exporting Ledger Masters from Tally.ERP 9 to External Application
• Tally.ERP 9 as a Server – Using External application as Front End
• Tally.ERP 9 as a Client – Tally as a Frontend for Web Services
• Case Study – Using XML Interface
• Integration using ODBC Interface
• Integration Using JSON
• Installing Tally.Developer 9
• Activating Your Tally.Developer 9 License
• Activating Your Tally.Developer 9 License as a Multi-Site Account
• Surrendering Your Tally.Developer 9 License
• Reactivating Your Tally.Developer 9 License
• Updating Your Tally.Developer 9 License
• Configuring Your Tally.Developer 9 License
• Upgrading to the Latest Tally.Developer 9 Release
• Uninstalling Tally.Developer 9
• Proxy Configuration
• Tally.ERP 9 SDK
• Working with File Tabs
• Auto Completion Behaviour
• Basic TDL Report Template
• Comments within the Code
• Definition Types and Names
• Attributes and Keywords
• Actions and Functions
• Syntax Errors in Code
• Navigating Definitions
• Navigating Project Files
• Hyperlink Navigation
• Attribute Reference Navigation
• Definition Reference Navigation
• Bookmarks Navigation
• Find in Files
• Replace in Files
• Incremental Search
• Search Options
• Navigating Search Results
• Writing Regular Expressions
• Using Project Browser
• Using Definition Browser
• Using Function Browser
• Using Action Browser
• Using Schema Browser
• Navigating Between Windows
• Reference Tab
• Command Tab
• TDL Project File
• Tally Compliant Product - TCP File
• Version Compatibility Check
• Adding and Removing Program Files
• The Various Compiler Options
• Generating TCP for Target Serials
• Opening Projects
• Saving Projects
• Closing Projects
• Compiling Projects
• Build a Project
• Executing Projects
• Loading the TCP file in Tally
• Troubleshooting
• Tally Connector
• Dictionary Manager
• Auth Library SDK
• Manage Customer Serials
• Preferences
• TD9 Command Line Parameters
• Quick Reference
• Installation and Licensing
• Creating Base Dictionary
• Creating Working Dictionary
• Automating Dictionary Creation
• Distributing and Assigning Strings
• Flagging Strings
• Setting Dictionary Preferences
• Using on Screen Keyboard in Dictionary Manager
• Working on Reference Dictionary
• Generating the .dct file
• Securing Dictionary
• Working of Tally Authentication Library
• Authenticating the User
• Setting up the Environment
• iOS Platform
• Android Platform
• Windows 8.1/Windows Phone 8.1 Platform
• Blackberry 7 Platform
• Blackberry 10 Platform
• Get List of Companies
• Get Company Name Corresponding to the Connect Name

Case Study I -  XML Request and Response Formats

Let us consider different scenarios to understand the Request and Response XML structure.

o Request to Export Data and Corresponding response

o Request to Export different TDL components and the corresponding response

o Request to Import Data and the corresponding response Execute

o Request to Execute Action and Corresponding response

Request to Export Data and Corresponding Response

Tags used for sending a request to export data from Tally.ERP 9 <HEADER> contains the following:

● Tag < TALLYREQUEST > must contain value Export

● Tag < TYPE > must contain value Data and

● Tag < ID > should contain the Name of the TDL Report

< BODY > contains the following:

● Tag < DESC > can contain report settings like Company Name, Format, etc. as desired which should be enclosed within < STATICVARIABLES > tag.

● If the Report Name specified in the <ID> tag does not exist within Tally running at the spec-ified port, the TDL defining the Report & other supporting definition needs to be described and enclosed within tag <TDL>.

Request for a detailed Trial Balance in XML Format from Tally

● Where Report exists in Tally

<ENVELOPE>

<HEADER>

<VERSION>1</VERSION>

<TALLYREQUEST>Export</TALLYREQUEST>

<TYPE>Data</TYPE>

<ID>Trial Balance</ID>

</HEADER>

<BODY>

<DESC>

<STATICVARIABLES>

<EXPLODEFLAG>Yes</EXPLODEFLAG>

<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>

</STATICVARIABLES>

</DESC>

</BODY>

</ENVELOPE>

In the above XML request, < HEADER > describes the expected result.

● The value of the Tag < TALLYREQUEST > is Export which indicates that some information needs to be exported from Tally.

● The value of the Tag < TYPE > is Data which indicates that the data needs to be exported from Tally.

● The value of the Tag < ID > must be a TDL Report Name, if the previous Tag <TYPE> contains Data and Tag < TALLYREQUEST > contains Export. Any Report which needs to be exported from Tally can be specified within this Tag.

< BODY > tag contains parameters, if any. Additional settings for the report like format required, company from which data is required, etc. can be passed within < STATICVARIABLES > Tag enclosed within < DESC > Tag. All variables are considered as Tag Names and their value are enclosed within these tags. For example , in the above XML, variables SVEXPORTFORMAT and EXPLODEFLAG are considered as Tags and their respective values $$SysName:XML and Yes are enclosed within. TDL Internal Function SysName is evaluated at Tally end and the response is being sent accordingly.

XML Response received is as shown:

<DSPACCNAME>

<DSPDISPNAME>Capital Account</DSPDISPNAME>

</DSPACCNAME>

<DSPACCINFO>

<DSPCLDRAMT>

<DSPCLDRAMTA></DSPCLDRAMTA>

</DSPCLDRAMT>

<DSPCLCRAMT>

<DSPCLCRAMTA>100000.00</DSPCLCRAMTA>

</DSPCLCRAMT>

</DSPACCINFO>

<DSPCLDRAMTA>-100000.00</DSPCLDRAMTA>

<DSPCLCRAMTA></DSPCLCRAMTA>

Note: Apart from XML,< SVEXPORTFORMAT >Tag can contain the values $$SysName:HTML, $$SysName:ASCII, $$SysName:SDF and BinaryXML.

● Where Report do not exist in Tally

<ID>Simple Trial balance</ID>

<EXPLODEFLAG>Yes</EXPLODEFLAG> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>

<TDL>

<TDLMESSAGE>

<REPORT NAME="Simple Trial balance"> <FORMS>Simple Trial balance</FORMS> <TITLE>"Trial Balance"</TITLE></REPORT>

<FORM NAME="Simple Trial balance"> <TOPPARTS>Simple TB Part</TOPPARTS> <HEIGHT>100% Page</HEIGHT> <WIDTH>100% Page</WIDTH></FORM>

<PART NAME="Simple TB Part"><TOPLINES>Simple TB Title,Simple TB Details</TOPLINES> <REPEAT>

Simple TB Details : Simple TB Ledgers </REPEAT>

<SCROLLED>Vertical</SCROLLED> <COMMONBORDERS>Yes</COMMONBORDERS></PART>

<LINE NAME="Simple TB Title"> <USE>Simple TB Details</USE> <LOCAL>Field : Default : Type : String </LOCAL>

<LOCAL>Field : Default : Align : Centre </LOCAL>

<LOCAL>Field : Simple TB Name Field : Set as: "Particulars" </LOCAL>

<LOCAL>Field : Simple TB Amount Field: Set as: "Amount" </LOCAL>

<BORDER>Flush Totals</BORDER> </LINE>

<LINE NAME="Simple TB Details"><LEFTFIELDS>Simple TB Name Field</LEFTFIELDS>

<RIGHTFIELDS>Simple TB Amount Field</RIGHTFIELDS></LINE>

<FIELD NAME="Simple TB Name Field"><USE>Name Field</USE> <SET>$Name</SET></FIELD>

<FIELD NAME="Simple TB Amount Field"><USE>Amount Field</USE> <SET>$ClosingBalance</SET> <BORDER>Thin Left</BORDER></FIELD>

<COLLECTION NAME="Simple TB Ledgers"><TYPE>Ledger</TYPE><FILTERS>NoProfitsimple</FILTERS></COLLECTION>

<SYSTEM TYPE="Formulae" NAME="NoProfitSimple"> NOT $$IsLedgerProfit</SYSTEM>

</TDLMESSAGE>

</TDL>

<OBJECT NAME="Ledger" ISINITIALIZE="Yes">

<LOCALFORMULA> TNetBalance: $$AsPositive: $$AmountSubtract:$ClosingBalance: $OpeningBalance </LOCALFORMULA>

</OBJECT>

The above XML Request is similar to the previous Trial Balance Report request. The difference is the Report Name contained within the <ID> Tag is not defined in Tally.

In the <BODY> Tag within < DESC > Tag, an additional tag < TDL > must be specified with the TDL describing the Report and its components enclosed within Tag < TDLMESSAGE >.

<SIMPLETBNAMEFIELD>Bank of India</SIMPLETBNAMEFIELD>

<SIMPLETBAMOUNTFIELD>351265.00</SIMPLETBAMOUNTFIELD>

<SIMPLETBNAMEFIELD>Cash</SIMPLETBNAMEFIELD>

<SIMPLETBAMOUNTFIELD>-147600.00</SIMPLETBAMOUNTFIELD>

<SIMPLETBNAMEFIELD>Conveyance</SIMPLETBNAMEFIELD>

<SIMPLETBAMOUNTFIELD>-157665.00</SIMPLETBAMOUNTFIELD>

In the above XML request, <HEADER> describes the expected result.

● The value of the Tag < TYPE > is Object which indicates that information pertaining to some Object needs to be exported from Tally.

● The value of the Tag < SUBTYPE > is Ledger which indicates that Ledger Object info needs to be exported from Tally.

● The value of the Tag < ID > must contain the Ledger Identifier which is the name of the ledger.

● The < BODY > Tag contains description within <DESC> Tag which requires all info pertaining to the Object required.

<STATUS>1</STATUS>

<DATA>

<TALLYMESSAGE>

<LEDGER NAME="ABC India Pvt. Ltd." RESERVEDNAME="">

<NAME.LIST TYPE="String"><NAME TYPE="String">ABC India Pvt. Ltd.</NAME><NAME/></NAME.LIST>

<RESERVEDNAME TYPE="String"></RESERVEDNAME>

<LEDGERPHONE TYPE="String">9940421583</LEDGERPHONE>

<TNETBALANCE TYPE="Amount">-13240.00</TNETBALANCE>

</LEDGER>

</TALLYMESSAGE>

</DATA>

Request to Export different TDL components & Corresponding Response

The different TDL components used for exporting are:

● Collection

Request to Export Object & Corresponding Response

For sending a request to export an Object Info from Tally,<HEADER> contains the following

● Tag <TALLYREQUEST> must contain value Export

● Tag <TYPE> must contain value Object

● Tag <SUBTYPE> must contain the Type of Object and

● Tag <ID> should contain the Object Identifier

<BODY> contains the following within <DESC> Tag

● Settings like Company Name, Format to be exported, etc. as desired enclosed within <STATICVARIABLES> Tag.

● Methods that need to be retrieved within the <FETCHLIST> Tag under each <FETCH> Tag.

● External Methods, if any, must be specified within <LOCAL FORMULA> Tag enclosed within <OBJECT> Tag.

● Above Local Formula, if dependent on any Local or Global Formula needs to be specified

Request for an Object info in XML Format from Tally.ERP 9

<TALLYREQUEST>EXPORT</TALLYREQUEST>

<TYPE>OBJECT</TYPE> <SUBTYPE>Ledger</SUBTYPE> <ID TYPE="Name">ABC India Pvt. Ltd. </ID>

<STATICVARIABLES><SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT></STATICVARIABLES>

<FETCHLIST>

<FETCH>Name</FETCH>

<FETCH>TNetBalance</FETCH>

<FETCH>LedgerPhone</FETCH>

</FETCHLIST>

<LOCALFORMULA>

TNetBalance: $$AsPositive: $$AmountSubtract: $ClosingBalance: $OpeningBalance

</LOCALFORMULA>

The above response has been received based on the XML request specified. The required detail of the Ledger "ABC India Pvt Ltd" i.e., Phone No, Contact, Opening, Closing has been sent from Tally.

Request to Export Collection & Corresponding Response

For sending a request to export Collection data from Tally, <HEADER> contains the following

● Tag < TYPE > must contain value Collection

● Tag < ID > should contain the Collection Name which is being described within the <DESC> Tag

● Tag < DESC > can contain settings like Company Name, Format, etc. as desired which should be enclosed within < STATICVARIABLES > tag.

● Collection declared within the < HEADER > tag < TYPE > must be defined within < TDLMESSAGE > tag under < TDL > tag.

● All the TDL Collection Attributes must be specified as tags and their respective values within the relevant tag.

Where Collection exists in Tally

Request for Collection Data in XML Format from Tally.ERP 9.

<TYPE>COLLECTION</TYPE>

<ID>Remote Ledger Coll</ID>

<COLLECTION NAME="Remote Ledger Coll"

ISINITIALIZE="Yes">

<TYPE>Ledger</TYPE>

<NATIVEMETHOD>Name</NATIVEMETHOD>

<NATIVEMETHOD>OpeningBalance

</NATIVEMETHOD>

</COLLECTION>

● The value of the Tag < TYPE > is Collection which indicates that information pertaining to Collection needs to be exported from Tally.

● The value of the Tag < ID > must contain the Collection Name which is defined available Tally.

Response in XML - Collection data in XML Format

<STOCKITEM NAME="Item" RESERVEDNAME="">

<LANGUAGENAME.LIST>

<NAME.LIST TYPE="String">

<NAME>Item</NAME>

</NAME.LIST>

<LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>

</LANGUAGENAME.LIST>

</STOCKITEM>

Where Collection does not exist in Tally

In such case, Collection Tag must be defined along with their attributes as sub tags inside the Body Tag enclosed within TDL Message Tag. Request for Collection Data in XML Format from Tally.ERP 9

<COLLECTION NAME="Remote Ledger Coll" ISINITIALIZE="Yes">

<NATIVEMETHOD>OpeningBalance</NATIVEMETHOD>

● The value of the Tag <TALLYREQUEST> is Export which indicates that some information needs to be exported from Tally.

● The value of the Tag <TYPE> is Collection which indicates that information pertaining to Collection needs to be exported from Tally.

● The value of the Tag <ID> must contain the Collection Name which is defined below in <TDLMESSAGE> Tag within <DESC> Tag under the Tag <BODY>.

Response XML Fragment for the above :

<COLLECTION>

<OPENINGBALANCE TYPE="Amount"> 5000.00 </OPENINGBALANCE>

<NAME>ABC India Pvt. Ltd.</NAME>

<LEDGER NAME="XYZ Loan A/c" RESERVEDNAME="">

<OPENINGBALANCE TYPE="Amount"> 0.00

</OPENINGBALANCE>

<NAME>XYZ Loan A/c</NAME>

<LEDGER NAME="Accum. Dep. on Airconditioner" RESERVEDNAME="">

<OPENINGBALANCE TYPE="Amount">0.00</OPENINGBALANCE>

<NAME>Accum. Dep. on Airconditioner</NAME>

The above response has been received based on the XML request specified. All the Ledgers with the required Methods i.e., Name and Opening Balance are sent from Tally.

Request To Export Function & Corresponding Response

For sending a request to evaluate the result of Function from Tally.ERP 9 < HEADER > contains the following

● Tag < TYPE > must contain value Function

● Tag < ID > should contain the Function which is being described within the <DESC> Tag within the Tag < BODY >

● < BODY > contains the following:

● Tag < DESC > can contain settings like Company Name, Format, etc. as desired which should be enclosed within < STATICVARIABLES > Tag.

Request for evaluating function in Tally without parameter

<TYPE>FUNCTION</TYPE>

<ID>$$NumStockItems</ID>

● The value of the Tag < TYPE > is Function which indicates that some Function needs to be evaluated within Tally and some value is returned as a response in XML.

● The value of the Tag < ID > must contain the Function Name prefixed with $$ since Function in TDL is activated by $$.

Response XML Fragment for the above would be

<RESULT TYPE="Number">33</RESULT>

Request for evaluating function with Parameters in Tally

<ID>$$Round</ID>

<FUNCPARAMLIST>

<PARAM>@@FirstParameter</PARAM>

<PARAM TYPE="Number">0.10</PARAM>

</FUNCPARAMLIST>

<SYSTEM TYPE="Formulae" NAME="FirstParameter"> 1242849 / 1000 </SYSTEM>

The above XML request is similar to the previous request except for this Function evaluation request needs Parameters to be specified.

● All the Parameters must be specified within the Tag <FUNCPARAMLIST> in the <DESC> Tag under <BODY> Tag.

● Each parameter must be enclosed within <PARAM> Tag.

● Parameters must follow exactly in the order required by the Function which is specified in the <ID> Tag.

● Dependency, if any i.e., Global/System Formula must be defined with <TDLMESSAGE> Tag under Tag <TDL>.

Response XML Fragment for the above would be:

<RESULT TYPE="Number">1242.80</RESULT>

The above response has been generated from Tally based on the request specified. <DATA> Tag contains the <RESULT> Tag which holds the result after function evaluation.

Request to Import Data and Corresponding Response

Tally can import data objects either in the form of a Master or Voucher. <HEADER> contains the following:

● Tag < TALLYREQUEST > must contain value Import

● Tag < ID > should contain the Import TDL Report i.e., either All Masters or Vouchers.

<BODY> contains the following

● Tag <DESC> can contain report settings like Company Name, behavior of Import in case of duplicates found; as desired which should be enclosed within <STATICVARIABLES> Tag.

● Tag <DATA> must contain the XML Data Fragment within Tag <TALLYMESSAGE> that needs to be imported

Request for importing Master data in Tally

<TALLYREQUEST>Import</TALLYREQUEST>

<ID>All Masters</ID

<IMPORTDUPS>@@DUPCOMBINE</IMPORTDUPS>

<LEDGER NAME="ICICI" Action = "Create">

<NAME>ICICI</NAME>

<PARENT>Bank Accounts</PARENT>

<OPENINGBALANCE>-12500</OPENINGBALANCE>

<GROUP NAME=" Bangalore Debtors" Action = "Create">

<NAME>Bangalore Debtors</NAME>

<PARENT>Sundry Debtors</PARENT>

</GROUP>

<LEDGER NAME="RK Builders Pvt Ltd" Action = "Create">

<NAME>RK Builders Pvt Ltd</NAME>

<PARENT>Bangalore Debtors</PARENT>

<OPENINGBALANCE>-1000</OPENINGBALANCE>

In the above XML Request, Create action is used. Any of the following system formulae can be used to choose the required behaviour in case the system encounters a ledger with the same name. The behavior is for the treatment of the Opening Balance which is being imported. DupModify specifies that the current Opening Balance should be modified with the new one that is being imported.

DupIgnoreCombine specifies that the ledger if exists need to be ignored. DupCombine specifies the system to combine both the Opening Balances. Ideally, this option is used when Data pertaining to Group Companies are merged together into a single company. On processing the above request for importing ledgers, the requested ledgers are created in Tally and the following response is received:

<RESPONSE>

<CREATED>2</CREATED>

<ALTERED>0</ALTERED>

<LASTVCHID>0</LASTVCHID>

<LASTMID>0</LASTMID>

<COMBINED>0</COMBINED>

<IGNORED>0</IGNORED>

<ERRORS>0</ERRORS>

</RESPONSE>

The above XML Response is a log of masters created, altered, combined, ignored or not imported due to some errors. It also contains information pertaining to the last Master ID imported. For Alteration and Deletion of Masters, the Object action needs to be Alter or Delete respectively.

For instance, in the above example,

<LEDGER NAME="ICICI" Action = "Alter">

<NAME>HDFC</NAME>

Name of an existing ledger ICICI will get altered to HDFC. In case of Deletion, following line suffices

<LEDGER NAME="ICICI" Action = "Delete">

Request for importing Voucher in Tally (Voucher Creation)

<ID>Vouchers</ID>

<VOUCHER>

<DATE>20080402</DATE>

<NARRATION>Ch. No. Tested</NARRATION>

<VOUCHERTYPENAME>Payment</VOUCHERTYPENAME>

<VOUCHERNUMBER>1</VOUCHERNUMBER>

<ALLLEDGERENTRIES.LIST>

<LEDGERNAME>Conveyance</LEDGERNAME>

<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>

<AMOUNT>-12000.00</AMOUNT>

</ALLLEDGERENTRIES.LIST>

<LEDGERNAME>Bank of India</LEDGERNAME>

<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>

<AMOUNT>12000.00</AMOUNT>

</VOUCHER>

<NARRATION>Ch. No. : Tested</NARRATION>

<VOUCHERNUMBER>2</VOUCHERNUMBER>

<AMOUNT>-5000.00</AMOUNT>

<AMOUNT>5000.00</AMOUNT>

On processing the above request for importing vouchers, the requested vouchers are created in Tally and the following response is received:

<IMPORTRESULT>

<LASTVCHID>119</LASTVCHID>

</IMPORTRESULT>

The above XML Response is a log of vouchers created, altered, combined, ignored or not imported due to some errors. It also contains information pertaining to last Voucher ID imported.

Request for importing Voucher in Tally (Voucher Alteration)

In case of Voucher Alteration, Cancellation or Deletion, vital information required is the voucher identifier. Identification of Voucher can be direct Methods within Voucher Object. For example, Master ID, Voucher Number, Reference, Narration, etc. Specifying Voucher Date is mandatory.

<VOUCHER DATE="02-Apr-2008" TAGNAME = "Voucher Number" TAGVALUE="3" Action="Alter" VCHTYPE = "Sales">

<NARRATION>Being Goods sold</NARRATION>

Request for importing Voucher in Tally (Voucher Cancellation)

Voucher cancellation is similar to above Voucher Alteration. For Voucher Cancellation, Action must be set to "Cancel".

<VOUCHER DATE="02-Apr-2008" TAGNAME = "Voucher Number" TAGVALUE="3" VCHTYPE = "Sales" ACTION="Cancel">

<NARRATION>

Being cancelled due to XYZ Reasons

</NARRATION>

Request for importing Voucher in Tally (Voucher Deletion)

Voucher Deletion is similar to above Voucher Alteration or Cancellation. For Voucher Deletion, Action must be set to "Delete".

<VOUCHER DATE="02-Apr-2008" TAGNAME = "Voucher Number" TAGVALUE="3" VCHTYPE = "Sales" ACTION="Delete">

Request to Execute Action & Corresponding Response

Tags used for sending a request to Execute an action from Tally.ERP 9 <HEADER> contains the following:

● Tag <TALLYREQUEST> must contain value Execute

● Tag <TYPE> must contain value TDLAction and

● Tag <ID> should contain the Name of the TDL Action

As of now only Sync action is introduced. For sync no parameters are required.

<TALLYREQUEST>Execute</TALLYREQUEST>

<TYPE>TDLAction</TYPE>

<ID>Sync</ID>

● The value of the Tag <TALLYREQUEST> is Execute which indicates that some action needs to be executed in Tally.

● The value of the Tag <TYPE> is TDLAction which indicates that some TDLAction has to be executed in Tally.

● The value of the Tag <ID> must be a TDL Action Name. Any action which needs to be executed in Tally can be specified within this Tag.

Ensure the following while executing the sync action:

♦ All synchronization setup has to be done at server end as well as client end

♦ Set the Option Enable ODBC server in Advanced configuration to Yes

♦ Pass the Request from the client end only

E-mail this Topic

'Case Study 1 - XML Request and Response Formats' has been shared with

Share your Feedback

• +011 4734 4723
• [email protected]

• Hello, Sign in My Account
• 0 item(s) - $0.00
• Why Vskills?
• How it Works
• Exam Calendar
• Exam-Retake
• Practice Test
• Certified Candidates
• Online Testing
• Value of Vskills Certification
• Third Party Assessments
• Tagging at Shine
• Sample Certificate
• Vskills Certificate Re-issuance
• Become an Instructor
• Accounting, Banking & Finance
• Cloud Computing
• Data Science
• Digital Media
• Engineering Skills
• Foreign Trade
• Hardware and Networking
• Health, Nutrition and Well-being
• Hospitality
• Human Resources
• Life Skills
• Logistics & Supply Chain Management
• Media and Communications
• Mobile Application Development
• Office Skills
• Product Design
• Programming Languages
• Project Management
• Real Estate
• Sales & Marketing
• Web Development
• Exam Retake
• Certificate Verification
• Post Jobs Free
• Search Certified Candidates
• Write Resume
• Interview Questions
• Job Assessment Test NEW
• Certified Tally ERP 9 Professional Sample Questions

Sample Questions  

1. Cash ledger is grouped under

b) Duplicate

c) User defined

d) Pre-defined

2. The user cab step back to higher level by pressing

3. The short cut key for purchase voucher

d) Alt + shift

4. The short cut key for sales voucher

d) Ctrl + Shift

5. Which short cut key is used to display journal entry?

d) Ctrl + Alt

Answers. 1. (d), 2. (d), 3. (a) 4. (c), 5. (a)

More Practice Test at:

Apply for Certification

https://www.vskills.in/certification/Certified-Tally-9.0-Professional