222

$show=home

Welcome to Accounting Education

The Accounting University with 3400+ Accounting contents as study material which can watch, read and learn anyone, anywhere.

Start your studies

$show=home

Journal Entries $type=three$count=6$author=hide$comment=hide$label=hide$date=hide$show=home$s=0

Balance Sheet $type=three$count=6$author=hide$comment=hide$label=hide$date=hide$show=home$s=0

other useful functions of tally

The Collaborative Tally
Import of Data
Export of Data
TallyODBC

Import of Data
Gateway of Tally -> Import of Data
Importing Master data
Gateway of Tally -> Import of Data->Masters
A file containing the masters exported from another Tally company data should exist so that it can be imported and merged with the data of the current company.
On selection of All Masters, you will be required to give the source file name and format in which it is to be imported. Give the full path of the source file. Data may be imported in Tally in either Tally 5.4 Format, or Tally (XML) Format or plain Tally 6.3 Format. The support for Tally 5.4 format has been included keeping in mind the thousands of programs running all over the world. Select the format required and the data will be effortlessly imported.
Tally 6.3 Formats are inherently richer in content. Lists of Accounts (Masters), and Vouchers (e.g. Daybook), exported out from Tally ees 6.3 are in this format, and may be imported into another company or location. A typical use of this facility is to export the daily vouchers from a Branch, and send it to the Head Office for importing into the main Accounts.
The structure of the import files are sufficiently complex not to merit discussion in a user level manual. For the normal user, it is adequate to know, that the files exported out of Tally 6.3, may be imported back using the Tally 6.3 Format.
Tally's design permits it to import any kind of data. It is capable of being programmed to use data from other systems much more easily. This permits you to continue using other systems and use some of their data in Tally as if they were parts of one integrated system. For example, a customer contact management program may contain various details like status of an order and last contact made. Bring in that data into Tally to merge into a report containing outstanding balances. Any changes in the other data will be immediately reflected in Tally.
For those who wish to connect to other programs and use external data in Tally contact Tally Solutions at 'enterprise@tallysolutions.com', or write in to us for the structure of import files.
Tally creates a log of the import activity in a file TALLY.IMP which is located in the same directory as the Executable Program. Please do refer to this file to check whether all records were successfully imported.


Export of Data

Export of data is provided mainly for summaries and statement reports like Trial Balance, Stock Summary, etc. The main use would be to export data to, say, a spreadsheet, and reorganise it for statutory presentation. Or export it to another company using Tally that will import it directly.
Export of all reports and statements is possible. A separate button is provided in the button bar and press it to export the current report. All the four formats are available for export. For more details on the formats, please see the E-mail section under E-capabilities.
The exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Export Master Data

Gateway of Tally->Display->List of Accounts
Click on Print
Click on Export
File Name
The file name is required and can be anything.
Format
Four formats are available for selection – ASCII, SDF, HTML, XML. Select HTML only if you want to publish or display it. If the export is required to import the file into another system, select any of the others.


XML

To export transactions, select Day Book to export. If you wish to import those transactions in another system, XML format is recommended. An XML output will have an XML envelope and is formatted with XML tags to enable import into other systems. The destination system would need a little re-formatting of XSLT (XML Style Sheets) based on the Tally Styles and can then import the data. However, another Tally system can import the XML data directly using the import menu option and without any re-formatting.
Merge data: The imported data can be merged with existing data in this way. Please refer to the Import of Data section.


TallyODBC

Tally uses ODBC to connect to other programs and exchange data dynamically.


Outward Connectivity
Pick up data from Tally directly into other programs like Microsoft Excel or Word without any programming! Print labels for greeting cards from the ledger addresses stored in Tally! Even create templates for the likes of Audit Reports and Schedule VI forms and plug in data from Tally. Tally's database is now open for use in most popular programs to give you the unlimited flexibility of creating your own reports using up-to-date data from Tally.
How to use ODBC
A brief exercise will explain the process.
We wish to send greeting cards to all our customers. The customer database in Tally already exists. You want to use the names and addresses that you stored there to print out labels for the Greeting Cards. For this job, we will use Tally data in MS Word.
Start Tally. It should keep running.
Ensure that the words ODBC Server is visible in the Gateway of Tally screen
Start MS Word -> Select Tools ->Select Mail Merge
Main Document ->Create-> Mailing Labels
Now press the Data Source button
Get Data->Create Data Source
Click on MS Query (at the bottom of the dialog box beside File Name)
Select TallyODBC. (You could use a saved Query by clicking the Tab Queries. Do that after you have saved this query that we are creating)
Let the Use the Query Wizard remain ticked.
The Query Wizard brings the Tally fields that may be selected. You can also give filter conditions to limit the data brought in to only those that match your criteria.
Hence,
Select Ledger and move by click the > button to the right the following fields:
$Name, $Parent, $Address (move all the other address fields as well.
Then in the next Query Wizard Screen – Filter data to limit all ledger accounts belong to the Group that contains the name 'Customer'. (In our Sundry Debtors Group we have created sub-groups called Trade Customers below which we have different Customer Groups as well) We want to print labels for customers only.
You can save the Query for future use.
Then the process of Mail Merge is intuitive and is the domain of MS-Word. You can set up the main document and bring in the Create Labels dialog box,
Insert Merge Fields from Tally. The labels will be created.

Inward Connectivity

On the other hand, Tally ees 6.3 is capable of being programmed by TallyExperts to use data from other systems much more easily. This permits you to continue using other systems and use some of their data in Tally as if they were parts of one integrated system. For example, a customer contact management program may contain various details like status of an order and last contact made. Bring in that data into Tally to merge into a report containing outstanding balances. Any changes in the other data will be immediately reflected in Tally.


E-capabilities

E-capabilities
Special Key Combinations

E-capabilities
Tally has extensive internet capabilities. E-mail, Web-publishing and data interchange over the Internet are all easily achieved from within Tally.
Pre-requisites to using E-capabilities of Tally:
You should have an internet connection accessible from your computer. This could be through a direct dial-up modem or through the network.
For E-mail - an E-mail account.
For Web Publishing - you should know the sites' URL (address) and have authority to upload files on the sites.
More:

Special Key Combinations

Key Combination
Function
Where available
ENTER
To accept anything you type into a field.
To accept a voucher or master
To get a report with further details of an item in a report.
You have to use this key at most areas in TALLY.
At the receivables report – press Enter at a pending bill to get transactions relating to this bill (e.g., original sale bill, receipts and payments against this bill, etc)
ESC
To remove what you typed into a field
To come out of a screen
To indicate you do not want to accept a voucher or master.
-------------------do---------------
CTRL + A
To accept a form – wherever you use this key combination, that screen or report gets accepted as it is
At almost all screens in TALLY, except where a specific detail has to be given before accepting.
CTRL + Q
To abandon a form – wherever you use this key combination, it quits that screen without making any changes to it.
At almost all screens in TALLY.
ALT + C
To create a master at a voucher screen (if it has not been already assigned a different function, as in reports like Balance Sheet, where it adds a new column to the report)
At voucher entry and alteration screens, at a field where you have to select a master from a list. If the necessary account has not been created already, use this key combination to create the master without quitting from the voucher screen.
ALT + D
To delete a voucher
To delete a master
(if it has not been already assigned a different function, as explained above)
At Voucher and Master (Single) alteration screens. Masters can be deleted subject to conditions, as explained in the manual.
ALT + I
To insert a voucher
At List of Vouchers – inserts a voucher before the one where you positioned the cursor and used this key combination.
ALT + A
To Add a voucher
At List of Vouchers – adds a voucher after the one where you positioned the cursor and used this key combination.
ALT + 2
To Duplicate a voucher
At List of Vouchers – creates a voucher similar to the one where you positioned the cursor and used this key combination
SHIFT + ENTER
To explode a line into its details
In almost all Reports:
At a Group/Stock Group/Cost Category/Godown/Stock Category – displays Sub Groups and Ledgers/Stock Items/Cost Centres/Secondary Godowns/Secondary Stock Categories
At a Stock Item –
At a Voucher – displays its entries and narration
At a Stock Item- displays its godowns and batch details
CTRL + ENTER
To alter a master while making an entry or viewing a report
At voucher entry and alteration screens
At all reports
ALT + R
To remove a line in a report
At all reports
ALT + S
To bring back a line you removed using ALT + R
At all reports

Comments

: 2
  1. the key details were very useful....i also need to know how an existing tally company's last year head of acct can be imported for the next year..

    thanks

    ReplyDelete
  2. Now Tally Optimization is essential part of work for tally users ~ recently I saw a best blog ~ Tally Programming

    ReplyDelete
In comment, you can give your feedback, reviews, ideas for improving content or ask question relating to written content.

 


Name

access,2,account,86,accountant,95,Accounting,683,accounting definitions,99,accounting ebook,3,Accounting education,85,Accounting Education Ads Help,1,accounting procedure,2,accounting process outsourcing,2,Accounting Software,52,advance,3,advertising,6,africa,7,Amalgamation,6,amendments,16,Amortization,1,announcements,62,Annuity,2,assets,53,audit,47,auditing,41,Australia,2,B.Com.,22,balance sheet,87,bank,111,Bank reconciliation,12,banking,33,basic accounting,110,BBA,1,benefits,13,best,50,bill,12,black money,3,blog,12,bloggers,7,book keeping,4,bookkeeping,3,Branch Accounting - full tutorial,8,budget,35,Budget variance,13,business,65,businessman,9,CA,30,calculator,4,canada,3,capital,72,capital budgeting,27,career,21,cash,40,cash book,8,cash flow statement,11,Chiense,1,children,13,china,6,class,3,coaching,2,coins,2,college,6,commerce,10,commerce students,7,company,36,computer,9,computer accounting,1,conference,4,Contact vinod kumar,1,Control Your Spending,27,corporate accounting,69,cost,160,cost accounting,195,cost center,8,cost centre,1,CPA,2,credit,18,credit card,11,cs,10,currency,35,data,11,Debit and credit,17,debit cards,1,debt,62,debtor,21,degree,6,depletion,2,depreciation,38,Diwali Messages,12,documents,4,dollar,5,domain,3,Downloads,3,Dubai,1,e-accounting,17,earning,17,education,246,Education Loans,6,email,15,employee,4,EPF,2,ERP,7,euromoney,1,examination,7,excel,17,excise duty,6,expenses,65,facebook,7,factor of loan,1,fans,2,feature,32,fifo,5,FII,4,fiji,1,finacle,1,finance,823,Finance Journal Entries,6,Financial,134,financial accounting,147,Financial Statements,4,fire insurance,3,flickr,2,flow,4,forensic,4,forex,21,formula,8,france,1,fraud,6,free,2,fun,34,function,1,fund,48,GAAP,36,GDP,1,gdr,5,germany,1,gold,7,goodwill,4,goodwill accounting,3,google,34,google apps,3,google apps,1,google base,1,google buzz,1,google calendar,1,Google docs,38,google finance,3,google fusion tables,1,google talk,5,govt.,5,GST,33,guide,85,health,6,Hindi,2,Hindi Language,3,history,3,holding company,3,How to treat FBT in Tally 9,1,HRA,3,ICAI,11,ICAWI,3,ICICI Bank,1,IFRS,11,income,17,income statement,19,Income Tax,7,India,57,indian railway,1,Indonesia,1,inflation,4,inflation accounting,3,infographics,8,information,7,inspiration,176,insurance,14,insurance accounting,2,Intangible,3,interest,26,international,7,Internet,40,Introduction of Tally 9,1,inventory,41,investment,135,investment in Shares,6,invoice,3,IT,1,Japan,1,Job costing,4,journal entries,143,Journal Entries eBook Help,4,Kalculate,1,keyboard,3,kuwait,2,laptop,2,law,4,LBT,1,learning,36,lease,5,lecture,11,ledger,17,leducation,1,Leverage Analysis,7,liabilities,16,lifo,3,linkedin,1,loan,74,logical point,1,loss,5,loss of profit,1,M.Com.,5,m.phil,2,malaysia,3,management accounting,129,manual accounting,4,manufacturing account,1,market,11,marketing,3,mastercard,2,material,13,MBA,14,MCA,1,media,4,migration,2,mobile,9,money,61,ms word,3,ms. excel,14,multi currency in tally 9,1,Multicurrency Accounting,3,mutual fund,30,national security,1,new and sacrifice ratio,1,new york times,1,new zealand,1,news,1,NGO,5,nonprofit-accounting,6,North Georgia Mountains,1,Notification,1,NPV,17,NSE,1,odbc,2,office,10,oman,1,online application,2,online accounting,11,Online Accounting Course,5,otcei,1,pakistan,3,parents,3,Partnership,1,pay pal,3,pdf,4,Personal Finance,6,pie chart,1,pie chart of income,2,pnb,5,podcast,1,ppf,1,presentation,10,price,7,privacy policy,2,prof. vinod kumar,13,profit,24,profit and loss account,12,project management,11,provision,14,purchase,9,puzzles,2,quickbooks,2,Quote,22,quotes,42,quotes of svtuition,1,rating agency,2,ratio analysis,34,RBI,7,readers,13,real estate,13,rectification of errors,11,remote control,2,reports,10,reserves,8,responsibility accounting,4,retirement,2,revenue,3,Revenue reserves,2,review,7,risk,11,rupees,9,salary,5,sale,12,SAP,3,saudi arabia,1,saving,19,sbi,9,scholarship,2,school,1,SEBI,13,security,30,service tax,23,share,20,share trading,15,Shares,16,shri lanka,3,singapore,2,sms,6,social accounting,7,society,5,solution,219,South Africa,1,stock,24,stock exchange,22,structure,6,student,39,students,70,study,21,subsidiary company,2,svtuition,14,swiss bank,2,tally,100,tally 9,8,Tally 7.2,8,Tally 9,42,Tally.ERP 9,59,TallyPrime,1,tanzania,2,tax,94,Tax Accounting,30,TDS,15,teacher,62,teaching,112,technology,33,test,40,testimonial,15,testimonials,15,thailand,1,tips,60,trading,5,trading on equity,2,transaction,7,trend,12,trial balance,14,truthfulness,1,tuition,3,twitter,10,UAE,5,UGC - NET Commerce,13,UK,11,United Arab Emirates,1,university,9,usa,25,valuation,9,VAT,22,Video,36,Voucher and vouching,4,Wealth,8,wikipedia,25,working capital,29,youtube,14,
ltr
item
Accounting Education: other useful functions of tally
other useful functions of tally
Accounting Education
https://www.svtuition.org/2008/04/other-useful-functions-of-tally.html
https://www.svtuition.org/
https://www.svtuition.org/
https://www.svtuition.org/2008/04/other-useful-functions-of-tally.html
true
2410664366776677676
UTF-8
Loaded All Posts Not found any posts VIEW ALL Reply Cancel reply Delete By Home PAGES Contents View All RELATED CONTENTS FOR YOUR LEARNING Topic ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy