Home

TALLY TUTORIAL

You will learn about Tally's export and import capabilities, which enable Tally to talk to the outside world.  Export of statements and data is sometimes required by companies to carry Tally's data into other systems like spreadsheets and databases.  Import of data will cover only import of Tally data and not data from other systems.  Import from other systems requires writing of import routines using Tally's Definition Language TDL and is outside the scope of this training.

Export information

Export of information is related to the Print operation.  In many reports, the print option toggles to Export, for example, the Trial Balance.  You give the output file name and the extent of information required for the export.

You might need to export information for different purposes, viz,

• To re-import into another company run on Tally.
• To export out for use by other programs.

To export data for re-import into Tally, you would export masters and then data.

Export Masters

1. Select the following path from the Gateway of Tally:
   • Display ->List of Accounts
2. Click on Print.  Notice that it toggles to Export.
3. Click on Export.
4. Master.Exp is the default file name.  The default destination path is the current Tally directory.
5. Type of Masters - You will notice that you can select any of the mentioned master types and export.  Select All Masters.
6. Export Closing Balances as Opening - Retain No. This option is useful when creating a separate company for the new financial year.  In that case change to Yes.

Export Data for re-import into another company

1. Select the following path from the Gateway of Tally: 
   • Multi Account Printing -> Daybook
2. Click on Export.
3. Daybook.Exp is the default filename and the current Tally directory the default destination directory.
4. Choose the period whose data you want to export.  This takes time and memory space.  Hence, limit the period at one time.
5. Accept to export.

Data exported from the company can be imported into another company.

Import of Data

Import Masters

1. Return to Gateway of Tally.

2. Select and load My Company (if you had not created it, create it now.  Ensure that it has the same financial year as the current company JC Computer Supplies).

3. Ensure that you are in My Company.  It will be the company in bold letters in the left section of Gateway of Tally screen.

4. Display Statistics to check number of entries.  Note the details down or print them out after consulting your trainer.

5. Select Import of Data.

6. Select All Masters.

7. Type in the file name Master.Exp. The name and path of the source file should match.  Here it is the current directory, hence you do not need to give the path.

8. The opening balance can be modified with the figures in the exported source file.  Select Combine Opening Balances to add to existing balances.  Hence if  the current company data does not have any masters, after import it will have the balances imported. if your source file did not have any balances, this option will simply add 0 to existing balance leaving them intact.  Select this option carefully.

9. Format - select Tally (5.4) Format.  Notice that you can import data from the previous version too.

10. After import, check the statistics to verify that import is completed successfully. if you get any errors in import, check the TALLY.IMP file in the current directory for error messages.  Take the help of your trainer in case of errors.

Import Vouchers

1. Return to Gateway of Tally.

2. Select import of Data -> Vouchers.

3. Give the filename 'Daybook-Exp'.

4. Format - Tally (5.4) Format.

5. Check the Statistics after import.

Export reports

To export statements like the Trial Balance,

1. Display Trial Balance

2. Click on Print. It toggles to export.