How to Export Tally Data in Excel or PDF 2022? Screenshots

How to Export Prime Tally Data to Excel or PDF 2022? Tally Prime has a fantastic feature that helps you to not only maintain your business data but also to export tally data whenever in need. A user can export masters and transactions entry data from anywhere, even without exiting their working screen. In this article, we will discuss further how to export files from tally prime 2022 to excel sheet or into pdf format. How to Pass a contra entry in tally prime?

Why do you need to Export your Tally data?

You can export your data from one place to another due to the following reasons:

• Export Masters– One can export the existing masters to another new company with duplicate data.
• Export Transactions– To use the already existing masters in a new company setup and share the same old data with your customers. For example, you can save paper and not share soft copies by exporting the transactions and communicating with customers or concerned persons.
• Export Reports– It can be used for reporting, as per your business needs.
• Configure Export– You can use the same customised configure settings for masters/transactions/reports and maintain export across the product.

However, while you are exporting data of your company in TallyPrime into another company, ensure the following points:

• The Company features of the exporting and importing company must have the same settings preferably.
• The company should be Using the XML format, export the masters first, and then export the transactions.

Export Tally Data Masters and Transactions

A user can export tally data masters and transactions created in one company to another in different formats.

To do so, follow the steps mentioned below:

• First, PressCtrl+E(Export) andgt; Go toMasters/Transactions.
• PressC(Configure), and after opening configures screen, choose the options as needed.

To exportMasters, set the options.

• Now, as you want to export tally data masters, Select theType of Masters you wish toexport.
  • Either select a specific type of master (for example, ledger) or all the accounting/inventory masters. However, you can also choose ALL Masters, If you want to export all the data available in the masters.
  • To include the linked masters, go toType of Mastersandgt;select exportandgt; set the option “Include dependent masters”toYes.
  • To turn the closing balances of ledgers to opening balances, set “Export closing balance as opening balance”toYes.

To export the transactions from one place to another, do the requirements in the options.

• Select theType of Voucher entries you wantfor export.
• Either select accounting vouchers or all the vouchers.
• To include all the masters, link to a particular masterandgt; go to “Type of Voucher entries”andgt;select export, set the option “Include dependent masters”toYes.
• To export the order vouchers with the selected voucher, set “Exclude order vouchers”toNo.
• Select the period of exporting the vouchers.

Specify theExport Settingsfor masters and transactions.

• Now you need to select theFile Format you want to export to:
  • SelectXML formatif you’re going to import this data into another company or any other software.
  • SelectASCII formatif you want to export it as a comma-separated text file while sending data through e-mail.
  • Select theFolder Path. TheFileNameappears automatically. Or change it if needed.
  • PressEscto return to theExportscreen.
  • PressE(Send) to export.

The exported file will be saved in theFolder Pathselected while exporting the data.

Export Tally Data Vouchers in PDF format

Now you can also export Tally data by selecting the file format as PDF.

1. PressAlt+G(Go To) andgt; selectDay Bookandgt; and pressEnter. Or you can open Gateway of Tallyandgt; selectDay Bookandgt; pressEnter.
2. Select the period.
3. Now you need to select the transactions you want to export.
   1. If you want To export all the transactions, pressCtrl+Ewithout setting any transactions.
   2. However, if you want To export only the required trades, select the transaction usingSpacebarandgt; pressCtrl+E.
4. PressC(Configure) andgt; and select theFile FormatasPDF(Read-only document).
5. Select theFolder Path. Set the other options as needed andgt; and pressEscto return to theDay Book Exportscreen.
6. PressE(Send) to export the report as a PDF.

Export Tally Data from TallyPrime Server into Excel

Users can now easily export Tally data from the Tally Prime Server Monitor into MS Excel sheet format in raw data. They can even use this data to create reports using the Pivot Table tool feature in MS Excel.

• PressAlt+E(Export)andgt; Choose Reports andgt; Open Data for Analysis.
• Then, PressC(Configure), and if you want, you can change the export settings.
  • Select Folder Path: You now can Enter the location where you want to export your Excel file.
• File Name: Enter the name that you want to provide to the exported Excel file. By default, the name will be andlt;Server Nameandgt;_andlt; Dateandgt;_andlt;Timeandgt;. You can change according to your requirements.

Note:The Date and time are provided in the DD-MMM-YY and HH-MM-SS 24-hour formats, respectively. So be careful while entering the data.

• If you want to overwrite the previously exported file, click onUpdate the existing filetoYes.
• However,if you’re going to open the file as soon as it is exported, click onOpen the file after ExporttoYes,
• After doing all the necessary changes, PressCtrl+Ato accept the changes.
• PressE(Send) to export the data.

Recommended Articles

• How to create Group in Tally
• CA Final Result
• CA Intermediate Result
• CA Foundation Result
• Alter Ledgers in Tally
• Opening Balance in Tally