Tally data directory is located in tally program folder by default. in tally program folder there is a subfolder called “data” in this subfolder there is one or multiple folders serially numbered each folder denotes a company data. You can see multiple files are stored if you opened this serially numbered folder.
- Go to Gateway of Tally > Import of Data > Masters.
- In Import of Masters screen, enter the required filename in Import File Name (XML) field.
- Select the required Behaviour in Treatment of entries already existing field.
How to Export Tally Data in Excel or PDF
- Open Data which is to be exported (Ledger/P&L or Balance Sheet)
- Click Export ( Shortcut Alt E)
- Esc.
- Select Excel or pdf format.
- Put File Name Requied.
- Leave other details as it is.
- Enter Enter or Ctrl A.
- File Downloaded in Tally folder.
data directory: An inventory that specifies the source, location, ownership, usage, and destination of all of the data elements that are stored in a database.
Select Company in Tally. ERP 9. Select Company option allows you to load another company from the list of companies listed which you may have created earlier. Press Enter on Select Company or use the button F1: Select Cmp.
Steps
- Open Microsoft Excel.
- Click File.
- Click Open.
- Double-click the XML file.
- Click the File menu.
- Click Save As….
- Navigate to the folder where you'd like to save the file.
- Select Excel Workbook from the “Save as type” drop-down.
Press Ctrl+Alt+C for Copy the data from Tally. Press Ctrl+V for Paste the Data Out of Tally. Or you can copy data from our of tally and want to paste in Tally. Press Ctrl+Alt+V for Paste the data in Tally.
How do I restore back up of accounting Data in Tally?
- Step 1: Go to Gateway of Tally and Click on the F3: Cmp Info or Press Alt+F3.
- Step 2: Select Restore from the Gateway of Tally.
- Step 3: In the Destination field, specify the path where you want to restore the backup of Tally data.
Connecting Company to Tally.NET Server
- Go to Gateway of Tally .
- Click F4: Connect . The Connect Companies to Tally.NET Server screen is displayed.
- Select the required companies from the List of Companies .
- Press Enter to connect the selected company to Tally.NET Server.
- ♦
- ♦
How to activate Tally erp 9? After purchasing, you will get a valid serial number and activation key in your mail. Open tally software the startup screen will look like. Click on Activate your license or use shortcut key Alt+A for activation of Your license.
Location of Data Files: By default the location of the data files is set to C:UsersPublicTally. ERP9Data. Specify the path of your choice when the data files are stored in another directory/folder.
Press Alt+F3--> Select Back Up option--> Mention the Destination for Back Up File--> Select the Company for Back Up. gateway of tally>backup>enter source and destination for backup>select company to backup>press enter and you are done. To backup a company, select the source path in to the backup from company info.
In the same pop up box, press the "Select Printer" button. Locate the printer you want to print to and click on the printer in the list of available printers. Press the Ok button and printing begins. If you want to change the default printer, click on the printer in the printer list and then right click on your mouse.
Delete a company Step by step in brief.
- Load the company you want to delete.
- From the gateway of Tally Press Alt + F3 Shortcut key of click on Alt+F3 cmp info.
- In the company info menu select Alter menu, now you are in company alteration screen.
- Now press Alt+D Shortcut Key.
Open Windows Explorer and find the photo (or document) in question. Hold down the Shift key, then right-click the photo. In the context menu that appears, find and click Copy as path. This copies the file location to the clipboard.
How to Copy Tally Data in Pendrive
- F1 Select Company.
- Tally Path shown at top (Suppose Tally path is C:UsersPublicTally.ERP9Data)
- Check Company Name and Number whose Data required to be copied.
- Go Manually to Path (Go to C Drive-->Users-->Public--->Tally ERP 9-->-Data)
- Copy Data Folder of Company which is required.
- Paste in Pendrive /Send to Pendrive.
How to load Tally data from Email
- Download Zip File.
- Open Zip file.
- Right Click --> Open with Windows Explorer.
- Copy folder.
- Open Tally.
- F1 Select Company.
- Tally Path shown at top (Suppose Tally path is C:UsersPublicTally.ERP9Data)
- Go Manually to Path (Go to C Drive-->Users-->Public--->Tally ERP 9-->-Data)
Tally XML Interface (Read and Write)
XML (Extensible Markup Language) is the standard for information exchange with external systems. Tally. ERP 9 supports standardized message formats for Request/Response. Tally. ERP 9 can communicate with any environment capable of sending and receiving XML over HTTP.Create a tally graph with the column chart tools in Excel. Create a new Excel spreadsheet by clicking the "File" tab of the Ribbon, selecting the "New" button and clicking the "Blank Workbook" button. If you already have the tally data in a spreadsheet, open the document. Highlight your data range when complete.
Exporting Masters
- Go to Gateway of Tally > Display > List of Accounts .
- Click E : Export to open the Export Report .
- Press Backspace to configure the export options.
- Select the Language .
- Select the Format .
- Enter the Export Location .
- Enter the Output File Name .
- Select the Type of Masters to be exported.
- Go to Gateway of Tally > Import Data > Vouchers .
- Enter the name of the .xml file to be imported, in the Import Vouchers screen, as shown below: Note : By default, the export location is the Tally.ERP 9 installation folder, which is also the default import location.
- Press Enter to import.
Illustration
- Open Microsoft Excel on your computer.
- Click Data > Get External Data > From Other Sources > From Microsoft Query , as shown below:
- Select TallyODBC64_9000* , as ODBC is enabled on the server 9000.
- Click OK .
- Click Ledger and expand the list to select the required fields.
- Click Next .
- Click Next .
Import Data From Excel To Tally ERP 9 Easily
- Tally ERP 9 software has good integration capabilities.
- Here is how to import Data from Excel to Tally ERP 9 software…
- Make all required ledgers in Tally.
- Create a sample entry in Tally.
- Export the created sample voucher from Tally.
- Preparation of data to import in Excel file.
- Open XML file.
- Transfer Content to Word file.
Click on Export Button at the top of the screen. or use short cut key for Export Alt+E. Export Location: Type the location of the file to be exported default location is C:Program FilesTally. ERP9, You can change it something like C:UsersAyanaDesktop to get the file on desktop.
Instead of manually entering the formula, simply use the shortcut Alt + = after you have selected the first empty cell in the column (the one located at the end of the numbers). After you execute this command, press Tab and Excel shows you the result.
