Question about Tally T2245 Matrix Printer

2 Answers

How to export Ledgers/vouchers from Tally-9.0 to excel

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

Hi my name is shradha,
im using tally erp 9,
i want to know how to export my all ledger (party) contact details, kind of name address contact no or etc....
my help me as soon as possible

Posted on May 15, 2013

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

How to export pdf individual ledger's vouchers from tally.

Kindly help me as soon as possible

Posted on Mar 21, 2014

6 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

  • 1 Answer

SOURCE: Export tally data to excel format

Select ASCII. Give output file name Eg:d:/exp Open the file using EXcel.Select Delimite  nexxt comma finish.Export is completed

Posted on Sep 28, 2008

  • 1 Answer

SOURCE: export ledger tally to excell

my name is saurabh yadav

i want to know that how export my sales book ledger export to excell form tally 7.2

Posted on Apr 20, 2009

  • 1 Answer

SOURCE: export tally data to excel

tally data to excel converting . i have some data export to excel but no excel formating you have some tally data to excel spred sheet software

Posted on Sep 04, 2009

  • 1 Answer

SOURCE: my tally version is Tally 9 Release 1.0, my

whenever you are going to export any tally report into excel then press alt+e then press backspace and the will blink on the status of ascii,html,and xml options popup then choose ascii then choose condensed or deatailed then press enter.then close tally.after closing tally open excel, click file then open then choose c drive where the tally folder is installed then choose all files you see that a notepad is being created then click on it then choose colon semicolon with next and next procedure then it will automatically arrange in excel sheet.

Posted on Feb 27, 2010

  • 1 Answer

SOURCE: In tally 7.2 when we enter the voucher the Cr or Dr is not seen

how do we entry in tally of dr. and cr. ..when we receiv rent of building.

Posted on Jun 25, 2010

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to export tally 9 to excel sheet


Hi,
Great question and there are two way export date. Please follow step by step instruction.
  1. In the Balance sheet screen click E : Export or press Alt+E.
  2. Select the required language from the list of Languages displayed.
  3. Select a format from the list of Formats displayed.
  4. By default, the exported file will be stored in C:\Program Files\Tally.ERP 9 for Windows 7 and C:\Tally.ERP 9 for Windows XP operating systems
  5. Press Enter to accept the default Output Filename or type the filename of your choice in order to save the file with a different name.
  6. Press Enter to accept the default Output Sheet Name.
  7. To update the existing file select Yes in Update Existing File.
  8. To format the contents of the file select Yes in Excel (Spreadsheet) formatting.
  9. Select Yes for the Field with Colour, to retain the background colour in the exported file.
And Second:
selecting the ASCII (Comma Delimited) format, the user can export all the reports or data from Tally.ERP 9. The data exported is converted to plain text separated with commas and stored in a file with the extension .txt. This file format is widely used for emailing and used for importing data into another company using Tally.ERP 9

More information please visit this link.
http://www.tallysolutions.com/website/CHM/TallyERP9/Data_Management/Export_Formats.htm

Thanks,

Jun 10, 2014 | HP Office Equipment & Supplies

1 Answer

How to connect tally with excel file? sir/madam i want to connect my tally erp 9 with my stock (excel file) i maintain the inventory in tally, when i make a bill on tally on that time it automatically...


hi

deepu

in tally 9 ERP has a oprtion to export any date from tally to excel just open that page which u want to open in excel

then see on the top in tally page there is option for export file just folwothat u will able to export dot in to excel

Jun 26, 2010 | Peachtree Software Peachtree Complete...

3 Answers

Export the data from excel to tally


  1. make a sale entry in tally
  2. Export the voucher from tally in xml format (this is to give u how the xml looks)
  3. Open the excel file where all the data is ther.
  4. open a word file, so that we can prepare the xml for mutiple vouchers. For this we will use Mail Merge facility
  5. in the XML which we did in step two, copy the data from "<TALLYMESSAGE xmlns:UDF="TallyUDF">" till the </TALLYMESSAGE>
  6. Now open the word file, go to mail merger, select the fields which needs to be changed, that is the Debtors and the amount (for normal sale entries) which should change for every sale voucher.
  7. create the mail merge.
  8. copy the data what you got in word file to a note pad and name it as sample.
  9. open again the step 2 - copy data from " <ENVELOPE> to <REQUESTDATA>" and paste in the begining of the notepad sample
  10. go the end of the notepad sample and copy the data from first file -"step 2" from " </REQUESTDATA> to </ENVELOPE>" and save the file
  11. Open tally
  12. go to import vocuhers
  13. specify the path of the notepad sample and yes ur data got imported.

Apr 21, 2010 | Microsoft Windows XP Professional

2 Answers

How to automatically import data from tally to excel. Want to display auto imported data in sharepoint.


Import TALLY Data / Export TALLY Data
Tally allows users to Import data from other software's as well as Export data from Tally to other software's. Tally allows users to Import and Export in ASCII, SDF and XML formats. XML is now the most widely used format of exporting data in the world. Any transactions can be exported from Tally and imported in other software after suitably altering the current structures to accept Tally data structure. The reverse is also possible by writing a small TDL program to accept the data from other software's. The data that is to be imported into Tally can be in either XML or DBF format. Easy Tally data transfer or Tally data migration from Tally 4.5 & Tally 5.4 to Tally 6.3 , Tally 7.2 , etc.
ODBC COMPLIANCE ALLOWS OTHER PROGRAMS TO USE DATA FROM TALLY DIRECTLY. E.G. : MS-EXCEL :
ODBC - OPEN DATABASE CONNECTIVITY
Tally is now ODBC compliant. Hence, any program like MS-Excel, Oracle etc that is ODBC compliant can use data from Tally. Here, data connectivity is dynamic i.e. any new updation in Tally is reflected in other ODBC Compliant Software immediately. Now, with ODBC facility the user can extract data out of Tally and design his own report formats in other ODBC compliant software's.
Procedure :
Now, Load Company -> specify period -> minimize Tally -> Open a new Excel file -> select data -> select 'Get External Data' -> select New database query -> choose Data Source
Tally connects to data source and displays Tally Wizard query screen -> select the columns you would want to include in the query.
Once all the columns are selected, the user returns to excel and excel displays all the columns selected
Graphical Analysis of Tally Data
Sometimes, pictures can say better than figures. Tally also provides graphical (Bar graph) analysis of data. The user can do a graphical analysis reports like Sales register, Purchase register, Ledgers, Funds flow, Cash flow, Item registers etc. This helps the user in deeper analysis of data. In Tally, a graphical analysis can also show month wise graphs for the year in comparison with any other period. This will help the management in quickly locating the highs and lean periods in a financial year and hence be better prepared for difficult times.
Web Enabled
Tally ees 6.3 is now Web enabled. This will help the user in reducing his paper work further. Now, report in Tally can be e-mailed directly from Tally. It is not just reports, but even invoices and purchase orders can also be e-mailed directly from Tally. Hence, the user does not have to send printed invoice or purchase orders from Tally.
Procedure :
Select any report (e.g. Balance sheet) -> select Alt+M (E-mail) -> specify all details as required by Tally
Ability to Publish Reports and Documents on the Internet
Now, Tally allows users to upload reports on the web site directly from Tally. So companies that would want to publish reports on the web site can do so directly from Tally. Many companies would also like to publish their price list on their websites along with the product they deal with.
Procedure :
Select any report (Profit and Loss A/C) -> select Upload (Alt + O) -> specify all details as required by Tally.
Direct Internet Access
Tally now offers direct Internet access. A Tally user while working on Tally can directly log on to tally website get details of all the facilities offered by Tally. The user can also download the latest releases of Tally 6.3 as and when available. Tally website also offers a facility of Tally Chat. Any user can now chat with a Tally representative and get any information regarding Tally.
Procedure :
Start Tally -> now, from any screen select Web Browser (Alt+W). Tally now takes you to the Tally Web site.
Print Preview
Any user would ideally like to view format of reports / Invoices / Vouchers before printing the same. Tally now offers a facility of print preview. Now any report can be viewed before printing or before it is mailed. Once Tally shows the preview the user can either opt to print or mail the same.

Apr 15, 2010 | Microsoft Office Excel 2007

1 Answer

Export all the ledgers with opening balance to another company in tally 9.


I assume that you have got basic knowledge of tally. open the old company(eg ramakrishnan 05-06) from where ypu want to export. Also open the new company(eg ramakrishnan 06-07). In the tally gateway click on the old company. go to accounts information>groups>multiple groups.alter>all items. press f3. your new company will become active. press ctrl+A to save. The groups have been imported. Now for importing ledgers.
Go to Account Information>Ledgers>multiple ledgers>alter>all items. press f3 to make the new company active. press zero opening balances or Alt+Z. press Ctrl+a to save.

Now to export the closing balances of the old company into new company.
Go to display>list of accounts. press the export tab on the right. select ledgers and export. open the new company. import the file you have just now exported.
You have now achieved a job very easily. This job is done by many tally users manually taking many a days after committing many mistakes.

hope everybody got this right. Thanks for using fixya...

Sep 15, 2009 | Computers & Internet

3 Answers

In tally 7.2 when we enter the voucher the Cr or Dr is not seen


hello user of tally,

you are getting ur voucher in single entry mode so when u entered in to a payment/receipt/contra press F12 and say NO to the following option

"Use Single Entry mode for Payment/Rcpt/Contra" :- No

Jul 01, 2009 | Tally T6218 Matrix Printer

3 Answers

How to find tally 9 short-cut keys


Tally 9 short-cut keys appear on the right-side of the tally screen. see the button names in the button bar.

few short-cuts:
Keys
Functions
Alt + 2
To Duplicate a voucher
Alt + A
To Add a voucher
To Alter the column in columnar report
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)
To access Auto Value Calculator in the amount field during voucher entry
Alt + D
To delete a voucher
To delete a master
To delete a column in any columnar report
Alt + E
To export the report in ASCII, HTML OR XML format
Alt + I
To insert a voucher
To toggle between Item and Accounting invoice
Alt + N
To view the report in automatic columns
Alt + P
To print the report
Alt + R
To remove a line in a report
Alt + S
To bring back a line you removed using ALT + R
Alt + U
To retrieve the last line which is deleted using Alt + R
Alt + W
To view the Tally Web browser.
Alt + X
To cancel a voucher in Day Book/List of Vouchers
Alt + Y
To Register Tally
Ctrl + A
To accept a form – wherever you use this key combination, that screen or report gets accepted as it is.
Ctrl + Alt + B
To check the Company Statutory details
Ctrl + G
To select the Group
Ctrl + Alt + I
To import statutory masters
Ctrl + Q
To abandon a form – wherever you use this key combination, it quits that screen without making any changes to it.
Ctrl + R
To repeat narration in the same voucher type
Ctrl + Alt + R
Rewrite data for a Company

May 30, 2009 | Computers & Internet

3 Answers

Export ledger tally to excell


my name is saurabh yadav

i want to know that how export my sales book ledger export to excell form tally 7.2

Mar 10, 2009 | Tally T2245 Matrix Printer

4 Answers

How can i export tally data to excel format?


Export to Excel With new release now you would get one more options while exporting data. One added format option is Excel format. excelexport.jpgIf you export in this format then file would be saved in xls format. More over if you put Excel formating option to Yes then tally would automatically format the data in presentable format. Tally would automatically bold the headlines and main fields for you and format data in a good way. Take a look at excel snapshot of balance sheet exported from Tally.

excelexport2.jpgThe special thing here is that you can do the calculation on any amount figure or any row or column, which was earlier not possible. The only drawback which i could find was that amount figures are not right aligned which is must for numbers for easy calculation, although you can do it by selecting the amount figures and putting them right aligned.

Feb 27, 2008 | Computers & Internet

15 Answers

Export tally data to excel format


Select ASCII. Give output file name Eg:d:/exp Open the file using EXcel.Select Delimite  nexxt comma finish.Export is completed

Jan 02, 2008 | Tally T2245 Matrix Printer

Not finding what you are looking for?
Tally T2245 Matrix Printer Logo

Related Topics:

2,224 people viewed this question

Ask a Question

Usually answered in minutes!

Top Tally Office Equipment & Supplies Experts

mukhtar21 shaikh
mukhtar21 shaikh

Level 3 Expert

2017 Answers

Tony

Level 3 Expert

2600 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

Are you a Tally Office Equipment and Supply Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...