Export data to Tally from AccountingGuru

A New feature that enables you to download the data from AccountingGuru and upload it into Tally!!!

Why Export To Tally?

AccountingGuru combined with Tally is a powerful combination that enhances the productivity of accounting professionals.

1. Through AccountingGuru, accounting professional can enter the data anywhere and anytime
2. Customers can view the data offline using Tally.
3. Till date, Accounting Professionals are more familiar with Tally than any other software. Hence, they can view/modify the data and suggest changes to the client.

AccountingGuru made it so simple!!!

Open your company in AccountingGuru,

• Click on Settings -> Tally Export -> Next

When you do the above, you will be directed to the ledgers page.  You will be able to see all your ledgers.  Now, perform the mapping for AccountingGuru Ledger to Tally Groups and Sub-groups. This exercise is done only for the 1st time when you export your data to Tally.

Please assign the Tally Group and the Sub-group for the AccountingGuru ledgers using the drop-down menu under the tab "Tally Group" and click on "Export"

When you clicked on "Export", the "Masters" & "Transactions" files will be sent to your E-mail.  These files are ".csv" files.  These files need to be converted into a normal "Excel" files.

To convert the files just follow the below steps.

• Download the files from your E-mail and save it into your system
• Open the file and click on File -> Save As...

When you click on "Save As..." a pop-up window opens.  Leave the File name as it is.  

Click on Save As type drop down menu and select "Microsoft Excel" and click on "Save"

You have successfully converted the ".csv" to "Excel" file.

Convert both the files as "Excel" and save into your system.

Now, the Ist part is done and your AccountingGuru data is ready to be put into TALLY.

For detailed instructions on how to get the data from AccountingGuru, please view our user guide.

The IInd part is uploading the data to Tally.

Before doing it, send your TALLY License Number to AccountingGuru and get the TCP file.

Now follow the instructions.

1. Open Tally.ERP 9 and Load the Company.
2. Load the Integration.tcp to Tally ( One time only)
3.  Process to install TCP file

     I.  Gateway of Tally -> F12 Configurations ->  TDL Configurations -> Press F4 or Click on Local TDLs Button from the current Screen

     II.   Specify the TCP path

Setting up Transaction Types (one time)

        1.      After successful installation of Tally Extension file, do the below process to automate the default integration setup

        2.      Select Gateway of Tally -> F11 Features -> AccountsGuru Setup 

When you click on AccountsGuru Setup, it will be displayed that "All masters set up Successfully completed"

Process to import the Data

Master Data Import

    1.     Download the Master Data from AccountsGuru website and save into local folder

    2.     Select Gateway of Tally -> AccountsGuru Integration -> Masters

     3.   Now, Specify the below details.

          i) Import File Name(XLS)  : Path of the Master Data file which is saved from  

                                                             Accounts Guru website

         ii) Import Sheet Name         : Sheet name of the Master Data excel where data is 

                                                              presented

     4.   After Accepting  the above screen, on successful import of new master data, it will 

         be displayed that " Ledgers Imported Successfully"

If the version is not compatible with curent installed TCP, it will be displayed that "Incompatible Version!!!  Kindly download new version from AccountsGuru website"

     6. Once the data is imported,  Kindly configure the Tax related information in Tally.ERP 9

               Ex:

Transaction Data Import

    2.  Select Gateway of Tally -> AccountsGuru Integration -> Vouchers

and follow the above instructions.

For detailed instructions, view our userguide.