Home  >   Inventory Tools   >  Tally Integration

Tally Integration

Are you a Tally user? Read this article to know about integrating and setting up Vtiger CRM with Tally.
A
Abdul Sameer
4 Apr, 2024 - Updated 11 days ago
Table of Contents

Introduction

Vtiger CRM’s integration with Tally allows you to sync data between Vtiger and Tally. So, you can easily transfer Ledgers, Stock Items, and Sales Vouchers from Tally to Vtiger’s Organizations, Products, and Invoices, and vice versa. This way, you will avoid dual data entry on both platforms.

Feature Availability

Sales Starter

Sales Professional

Sales Enterprise

All-in-One Growth

All-in-One Professional

All-in-One Enterprise

Feature Availability

Tally Integration

-


To know more about feature limits, click here.


Installing Tally

Tally is a third-party app that you must install from Vtiger’s Extension Store. You can install extensions only if you are an Admin user in the CRM.

Follow these steps to install Tally:

  1. Log in to your CRM account.
  2. Click the Main Menu.
  3. Click the Add-ons button on the bottom left.
  4. Look for Tally and click Install.
  5. Click Yes to confirm the installation.
 

Note: Before you start syncing data, you must ensure the following:

  • The base currencies in Tally and Vtiger must be the same.
  • You must have the latest Java version installed. 


Configuring Tally 

After you have installed Tally, you must configure it to sync data.

Follow these steps to configure Tally:

  1. Log in to your CRM account.
  2. Click the Main Menu.
  3. Go to Organizations, Products, Sales Orders, or Invoices.
  4. Click Sync.
  5. Click Add.
  6. Click Configure.
  7. Enter the following information:
    • Vtiger username: Update automatically.
    • Secret key: Enter the Secret key.
    • Tally company name (case sensitive)
    • GUID: Click here to know more. 
    • Tally base currency, default sales ledger, default discount ledger, and default shipping ledger.
  8. Click Save Settings.
  9. Click the Download .vtc file button.

After you perform the steps above, you will receive a confirmation email. 

 

Next steps:

  1. Download the VtigerTallyConnector zip file from here. Unzip the file to your local computer where Tally is installed.
  2. Go to the conf folder > VtigerTallyConnector.properties file after unzipping.
  3. Set the required values for VTC_File_Path ( with Forward slashes /), Tally_Company, Tally_Server, and Tally_Port.
    • For example, if you place the vtiger.vtc file downloaded from Vtiger in your computer’s D drive, and your path will look like this - VTC_File_Path = D:/vtiger.vtc.
    • Provide your Tally company name in Tally_Company. This name is case-sensitive.
    • Provide the server details and port number. The default values are -
  4. Open Tally and load the company name that you provided in the previous step.
  5. Load the guid.tdl, VtigerCheck.tdl, VtigerDateFilter.tdl,  and VtigerImport.tdl files to the Tally installation folder (C:\Program Files\Tally.ERP9 ) from the zip file you downloaded in Step 1.
  • In Tally ERP9, perform the following steps:
  1. Press F12 under Gateway of Tally.
  2. Click on Product and Features.
  3. Click F4: Manage Local TDLs shown on the right panel.
  4. Set LoadTDLs on startup to Yes.
  5. Add VtigerDateFilter.tdl, VtigerCheck.tdl, and VtigerImport.tdl  to List of TDLs to preload on Tally startup. 
  6. Click Tab to save.
 
  • In Tally Prime, perform the following steps:
  1. Press F1:Help under Gateway of Tally.
  2. Select TDLs & Addons
  3. Click F4:Manage Local TDLs located on the right.
  4. Provide the TDL Path and add guid.tdl, VtigerDateFilter.tdl, VtigerCheck.tdl, and VtigerImport.tdl  under File Name.
  5. Set Load TDL to Yes for all four files
  6. Click Tab to save.
 

Note: Vtiger CRM users configuring Tally sync before 4th June 2021 must follow a few additional steps to use the latest enhancements. To learn more, click here.


Syncing Data

After the configuration is successful, you can choose how you want to sync data.

Follow these steps to sync data between Tally and Vtiger:

  1. Log in to your CRM account.
  2. Click the Main Menu.
  3. Go to Organizations, Products, Sales Orders, or Invoices.
  4. Click Sync.
  5. Click View available connectors.
  6. Select Tally.
  7. Enable the checkbox for the modules that you want to sync.
  8. Choose a sync direction:
    1. Tally to Vtiger
    2. Vtiger to Tally
    3. Sync Both ways
    4. Disable Sync (to stop syncing data)
  9. Specify your Tally Credentials.
  10. Click Save Settings.
  11. Open VtigerTallyConnector > bin folder and run start.bat to start the sync.
  12. Go back to the CRM and click Sync.  
  13. Click Sync Log to see the last synced report.
 

Tips:

  • If you face any difficulty while syncing, you can debug issues from VtigerTallyConnector > logs > DebugLog.txt file.
  • Syncing may take a long time for the first time, depending on the number of records. 
 

Note

  • You can transfer data in batches or chunks to ensure data does not slow down or break. 
  • You can sync data from a particular date. This is available at a module level for Sales Orders and Invoices. 
  • You must sync the organization and products to ensure invoices and sales orders are not skipped.

How does this work?

  • For the first-time sync, the sync is applied from the given date. 
  • For the next sync, the last sync time is considered.
  • If the sync from date is changed, records are synced from the changed date.

Admins can also view the sync log for each batch data transfer in the CRM. 

 

Sync Direction

You can select the sync direction at the module level for individual or all the modules you want to sync. This is possible since the following sync directions are available as drop-down options in the Enable Sync column for every module:

  • Sync from Tally to Vtiger
  • Sync from Vtiger to Tally
  • Sync Both Ways
  • Disable Sync

For example, you may want to sync Organisations, Products, and Invoices from Tally to Vtiger but sync Sales Orders from Vtiger to Tally. You can select the sync direction for all these modules simultaneously per your requirement.   

You could select the modules and set up the sync direction one way or another. If you wanted to sync other modules, you had to change the sync direction again. 

Note: Only Admin users can set up the sync direction.​​​​​​


Module-level Reset

The Reset option is available at the module level for CRM Admins. 

With this option, you can re-sync Taxes, Charges, Discounts, and Sales Accounts (if applicable). Records will be reset, and data will again be fetched from Tally to Vtiger CRM in the sync process after reset. 

Consider this example. If you make a mistake, say, adding predefined taxes before the sync from Tally, then there will be a tax mismatch between Vtiger and Tally.

At this stage, you can use the reset option to reset the values and fetch data from the modules again.

 

Disabling Sync 

You can disable Organization details on the Tally settings page. The Disable toggle button disables the link between the company or organization and Tally, so company data will not sync to Tally and vice versa. 

 

Note: Only the remove option is currently available on the Tally Settings page. 

Field Mapping

Here is information on which Tally fields are mapped to which fields in Vtiger.

Ledgers to Organizations

Tally Field Names

Vtiger Field Names

Ledger Name

Organization Name

Company Name

Tally Company 

Ledger Group

Ledger Group

Mailing Address

Billing Address

Mailing Country

Billing Country

Mailing State

Billing State

First Address of Multiple Addresses

Shipping Address

Pincode

Postal code

Phone no

Primary Phone

Fax

Fax

Mobile no

Secondary Phone

GSTIN/UIN

GSTIN - Only for Indian Instances

PAN/IT no

PAN/IT no

Specify Credit Limit

Credit Limit

Credit Period

Credit Period

Outstanding Balance of the Ledger

Tally Outstanding Balance

Email

Primary Email

Email CC

Secondary Email

Website

Website

Description

Description



 

Note

  • Ledger groups can be synced in two ways now. That is, Ledgers get synced from Tally to Vtiger and Vice Versa.
  • If the ledger values in invoices and sales orders are incorrect, the Default Sales Ledger, Default Discount Ledger and Default Shipping Leder values are considered.
  • Subgroups or custom groups created under Sundry Debtors or Sundry Creditors group in Tally are now synced with the CRM’s organizations. A new field called Ledger Group is added to the Organizations module. For example, if you create a ledger in Tally under Sundry Debtors > Subgroup 1, then the Ledger Group field in the related organization record shows Subgroup 1. 
 

Stock Items to Products

 

Tally Field Name

Vtiger Field Name

Item Name

Product Name

Company Name

Tally Company

Usage Unit

Usage Units

Closing stock

Qty in stock

Rate/Value

Unit Price

Part No.

Part Number

Taxes

Taxes

CGST In-State
IGST SGST/Out-of-State

Description

Description

Stock Category

Product Category

Stock Sub-Groups

Tally Stock Group

HSN Code

HSN Code

 
Note
  • Taxes are synced only one way, i.e., from tally to Vtiger. The direction of sync you choose does not affect tax sync.
  • Voucher taxes in Tally are mapped to the taxes synced from Tally to Vtiger.
  • The Closing stock under the stock summary report is synced to qty. In stock field in the product. (This will only happen when productquantity.batch file under VtigerTallyConnected>bin is run.)
 

Note

  • Tally Stock Item GST taxes are copied to Instate and Out-of-state fields in Products.
  • Tally differentiates between instate and Out-of-state based on the company and Ledger (Org) locations.
    • If the ledger is present in the same state as the Company, then Instate taxes are applicable. (On selecting IGST, tax will not apply to vouchers and invoices.) 
    • If the ledger is present in a different state other than the location of the company, the Out-of-state taxes are applicable. (Upon selecting CGST, SGST tax will not apply to vouchers and invoices).
    • The Instate and Out-of-State numbers would not be automatically updated for a product in Vtiger sales orders or invoices. 
  • The CGST field in Tally is mapped to the In-state field in Vtiger CRM. The IGST field is mapped to the SGST and Out-of-state fields in Vtiger CRM. 
  • Tally integration ensures that when you copy stock items from Tally to Vtiger:
    • The In-state field value in Vtiger is updated from the CGST field in Tally.
    • The SGST and Out-of-state field values in Vtiger are updated from the IGST field in Tally.
 


Sales Vouchers to Invoices

Tally Field Name

Vtiger Field Name

Reference No

Subject

Voucher No

Tally Invoice No

Company Name

Tally Company

Voucher Date & Effective Date

Invoice Date

Voucher Type

Sub Voucher Type

Part’s A/C Name

Organization Name

Buyer’s Address

Billing Address

Country

Billing Country

State

Billing State

Consignee’s Address

Shipping Address

Stock Items

Products

Billed Quantity

Quantity

Rate

Selling Price

Voucher Sales Ledger

Tally Sales Ledger

Tax

Tax

Charge Ledger

Charges

Other Expenses

Adjustment Add/Deduct

Discount

Overall Discount

Item Level Discount

Item Level Discount

Narration

Description

Discount Names

Tally Discount Ledger

Sales Account Leder

Sales Account

 

Note

  • Sales vouchers are synced along with sales voucher types.
  • The Sub-Voucher field for Invoices and Sales Orders is available as a Picklist field. The CRM fetches Sub-Voucher type values from your Tally account and displays them as Sub-Voucher picklist values.
  • All discount ledgers created under indirect expense will be synced to the Vtiger Tally Discount ledger picklist field.
  • Ledgers created under direct income are synced to shipping charred in Vtiger and Ledgers created under indirect expense are synced to Discounts under Vtiger.

Sales Orders

 

Tally Field Name

Vtiger Field Name

Order No

Subject

Tally Voucher No

Tally SalesOrder No

Company Name 

Tally Company

Voucher Date

Due Date

Voucher Type

Sub Voucher Type

Part’s A/C Name

Organization Name

Buyer’s Address

Billing Address

Country

Billing Country

State

Billing State

Consignee’s Address

Shipping Address

Stock Items

Products

Billed Quantity

Quantity

Rate

Selling Price

Voucher Sales Ledger

Tally Sales Ledger

Tax

Tax

Charge Ledger

Charges

Other Expenses

Adjustment Add/Deduct

Discount

Overall Discount

Discount Names

Tally Discount Ledger

Narration

Description

 

Note:

  • Vtiger Invoices will display a Sales Order (SO) tab. You can:
    • Select and link an SO to an invoice, provided the SO is not linked to another invoice (previously). 
    • Link only one SO to an invoice at any given time. 
    • Link an SO to an invoice for the Contact or Organization mentioned in the invoice.
  • Sales orders vouchers and its sub-vouchers are synced along with sales order in Vtiger CRM.
  • Ledgers created under direct income are synced to shipping charred in Vtiger and Ledgers created under indirect expense are synced to Discounts under Vtiger.
 

Key Enhancements

  • Multiple shipping charges and discount ledgers are synced from Tally to vtiger CRM and vice versa.
  • Tax on charges is synced from Tally to Vtiger CRM and vice versa.
  • All taxes are synced to the taxes column under charges. 
  • Grouping: When a product is synced to Tally, it goes under the name of the primary or default group if multiple groups are available.
  • Charts of Accounts Add-on must be installed to sync sales account ledgers from tally to Vtiger.
  • All the sales account ledgers are fetched from Tally and reflected in the CRM in the Chart of Accounts.
  • Taxes are also fetched along with the sales account ledgers.
  • Multiple companies’ data can be synced from Tally to CRM.
  • Any levels of groupings of ledgers and vouchers can be synced to the CRM.
  • Multiple Companies can now be added from the Vtier settings page.
  • If multiple addresses of an organization are present in the tally, they will be synced to the multiple address module. ( For this to work, the user must first install the Multiple Addresses Add-on).
  • Outstanding Invoices are now synced from Tally to Vtiger and are displayed in one view in the organization record.
  • Taxes on Charges are now allowed to be synced in both ways.
  • Sales accounts synced from the tally are marked as Sales Account type in Charts of Accounts.
  • Account code starts with T-100 for sales accounts synced from the tally.
  • On Installing the COA add-on, Item account taxes and Record account taxes under Tax mode are added Item details block in the  Invoices and Sales orders.
  • If the Tax mode is set as Record account taxes and an account is selected from the Record  Sales Account picklist, then the taxes under this account will apply to all the line items in the invoice.
  • If Tax mode is set as Item account taxes, users can select different sales accounts for each line item. 
  • Taxes are applied to the line items depending on the taxes configured under the selected account from the COA. 


Limitations

  • Product taxes will not be overwritten from Vtiger to Tally if the product updated in Vtiger is synced from Tally earlier.
  • Taxes can be synced only one way, that is, from Tally to Vtiger. Even if the Sync Direction is Vtiger to Tally, Taxes get synced only from Tally to Vtiger.
  • The default Sales Order Number in Vtiger gets synced to the Voucher Number in Tally. Tally’s Sales Order No is a redundant field when syncing from Vtiger to Tally.
  • If the default tax mode is Group, and Charges on taxes are present in Vtiger, then records get skipped.


Behaviour

  • If the Ledger Group field is empty in the Organizations module and synced to Tally, then Sundry Debtors are taken as default in Tally.
  • GSTIN will sync to Tally only if the Vtiger organization records’ billing country is India.
  • Usage Units and Category must be present in Tally before syncing products to Tally. Otherwise, products will get skipped.
  • Except for Discount ledgers and Shipping Charge ledgers, any other charges present get synced to Adjustments from Tally to Vtiger.

 
Was this article helpful?
0  out of  0  found this helpful.
Comments 0
Be the first to comment
© Copyright 2023 Vtiger. All rights reserved.