Tally Integration

 

Exporting Zenoti Transactions to Tally

Zenoti supports integration with accounting software, Tally, ERP 9. As appointments are booked in the Appointment Book and payments are processed, transactions related to various items such as services, products, etc and payment methods such as cash, credit card, and so on are recorded. These transactions can then be exported to Tally. Multiple tax accounts is supported in Tally, for example, if multiple tax types are configured in Zenoti for services, these tax values will be mapped to their respective accounts in Tally.

Tally exports can be achieved in two ways:

  • Daily auto generation of Tally exports
  • Scheduled Tally exports

Enabling Tally Exports for the Organization

To enable Tally exports for your organization, perform the following steps:

  • Click the Organizations link in the Admin mode.

Organizations_link.png

  • Click the Tally tab and enter details for the following fields. Note that all account names should be same in both Tally and Zenoti (case sensitive)
    • Enable Tally Exports: Check this setting to enable Tally integration with Zenoti. If you wish to use the Tally integration feature for your organization, this option must be selected.
    • Disable Auto Generate: Check this setting to enable manual exports to Tally. If this option is selected, you need to manually schedule Tally exports for specific period of time. This is helpful if you have made any edits to accounting and revenue transactions (through backdating) and wish to export this data to Tally only once the edits are done. Manual scheduling of Tally Exports is done through the Tally Exports link under Reports in Admin mode. If this setting is off, Tally Exports will be auto generated along with daily reports email at the end of each day (at midnight).
    • Membership Account Name:  Enter a Tally account name to which membership transactions will be exported.
    • Service Account Name: Enter a Tally account name to which service transactions will be exported.
    • Product Account Name: Enter a Tally account name to which product transactions will be exported.
    • Package Account Name: Enter a Tally account name to which package transactions will be exported.
    • Gift Card Account Name: Enter a Tally account name to which gift card transactions will be exported.
    • Cash Account Name: Enter a Tally account name to which all cash receipts of the day will be exported.
    • Credit Card Account Name: Enter a Tally account name to which all credit card transactions of the day will be exported.
    • Check Account Name: Enter a Tally account name to which all check transactions will be exported. This will be shown as ‘Bank Account’.
    • Adjustment Account Name: Enter a Tally account name to which all adjustments (register closure) will be exported.
    • Gift Card Redemption Account: Enter a Tally account name to which gift card redemption transactions for the day will be exported.
    • Custom Account: Enter a Tally account name to which custom transactions for the day will be exported.
    • Membership Redemption Account: Enter a Tally account name to which membership redemption transactions for the day will be exported.
    • Service Tax Account Name: Enter a Tally account name to which service tax transactions will be exported.
    • Sales Tax Account Name: Enter a Tally account name to which sales tax transactions will be exported.
    • Luxury Tax Account Name: Enter a Tally account name to which luxury tax transactions will be exported.
    • VAT 1 Tax Account Name: Enter a Tally account name to which VAT 1 tax transactions will be exported.
    • VAT 2 Tax Account Name: Enter a Tally account name to which VAT 2 transactions will be exported.
    • VAT 3 Tax Account Name: Enter a Tally account name to which VAT 3 transactions will be exported.
    • CST 1 Tax Account Name: Enter a Tally account name to which CST 1 transactions will be exported.
    • CST 2 Tax Account Name: Enter a Tally account name to which CST 2 transactions will be exported.
    • CST 3 Tax Account Name: Enter a Tally account name to which CST 3 transactions will be exported.

Tally_tab.png

  • Click Save.

Defining Center Settings for Tally

Cost center name for service transactions need to be defined for each center. If your organization sells products and services under different organization names, you can define cost center for services and products separately. In order to do this, perform the following steps:

  • Click the Centers link in the Admin mode.

Centers_link.png

  • Click on the center name for which you wish to define the cost center name.
  • Click the Settings tab.
  • Enter the services cost center name in the Tally Center Name field. Cost center should also be created in Tally.
  • Enter the product cost center name in the Tally Product Center field, if required. Leave this blank if services and products are sold under the same organization name. Cost center should also be created in Tally.

Center_settings_Tally.png

  • Click Save.

Daily Auto Generation of Tally Exports

Once Tally settings are configured at the Organization and center level, as the front office books appointments in the Appointment Book and processes payments, Tally exports file will be created based on your settings (auto generate or manual) which can be downloaded and imported to Tally.

To enable daily auto generation of Tally Exports, perform the following steps:

  • Select the Enable Tally Exports field in the Tally tab of Organizations page.
  • Ensure that the Disable Auto Generate option is cleared (not selected). Tally Exports will be auto generated along with daily reports email at the end of each day (at midnight).
  • Enter all account names for Tally and click Save.

Disable_auto_generate.png

  • Click the Tally Exports link under Reports in the Admin mode.

Tally_Exports.png

  • A Tally export file will be created for each day. If you have set up different organizations to sell products and services in Zenoti, two different export files will be created – one for services sale and one for product sale. If products and services are sold from the same organization, only one single Tally export file will be created for services and product transactions.

Tally_Exports_page.png

  • Right-click on the Download link and select the Save Link As option.
  • Save the file as a XML document on your local machine. An .XML file will be created consisting of Accounting transactions from Zenoti.

The following account entries will get generated based on the Organization setting for Tally:

Voucher No.1

Cash Account                          Dr       

Credit Card Collection Account Dr

Variance Account                    Dr                   

Bank Account                          Dr       

Custom Account                      Dr       

GC Redemptions Account       Dr

                   To VAT Account

                  To   Product Sales Account

                  To   Variance Account

 

Voucher No.2             

Cash Account                                      Dr       

Credit Card Collection Account          Dr                   

Bank Account                                      Dr       

Custom Account                                  Dr       

GC Redemption Account                     Dr

Membership Redemption Account     Dr

Variance Account                                Dr

                   To Service Tax Account

                  To   Service Sales Account

                  To   Membership Sales Account

                  To   Package Sales Account

                  To   Gift Card Sales Account

                  To   Variance Account

 

  • The ‘Variance Account’ is used to account any variance in amount of other accounts to balance the debit and credit transactions.
  • The VAT account is used to account VAT transactions for the day.
  • The Product Sales Account is used to account product sales (before tax and after discount) for the day.
  • The Membership Sales Account is used to account membership sales (before tax and after discount) for the day.
  • The Package Sales Account is used to account package sales (before tax and after discount) for the day.
  • The Gift Card Sales Account is used to account gift card\prepaid card sales (before tax and after discount) for the day.

You can also reconcile this data with the Daily Collections reports from Daily Reports in the Admin mode.

Daily_collections_reports_Tally.png

Manual Generation of Tally Exports

Tally Exports file can also be generated on request, that is, manually. This is helpful for situations when you need to make edits to register closures through backdating feature and would like to export to Tally only once the edits are done and the figures are accurate.

To enable manual generation of Tally Exports, perform the following steps:

  • Select the Enable Tally Exports field in the Tally tab of Organizations page.
  • Ensure that the Disable Auto Generate option is selected.

Disable_auto_generate_selected.png

  • Enter all account names for Tally and click Save.
  • Click Tally Exports under Reports section in the Admin mode.
  • Define the date range to schedule Tally exports and click Schedule Export button.
  • Tally Export files will be created on demand for the date range defined instead of each day.
  • Once the files are created and are available for download, right click on the Download link and select the Save File As option to save the .XML file on your local machine.

Scheduled_exports_Tally.png

Exclusions from Tally Exports

Note the following items from Zenoti that are not included in Tally Exports

  • Tally considers only closed tickets. Partial closed and open tickets are not considered in the Tally Export accounting entry.
  • If any past open/partial payment appointment is closed on current day, it will be reflected in the current day transactions in Tally.
  • Reopen of an appointment is considered on current day’s transactions.
  • Multiple payment modes in one invoice are proportionately allocated to Product Sales and other Sales Voucher.
  • Discounts and Series packages redemption are not considered for Tally Export entries.

Importing XML File to Tally

Tally export files saved as XML documents on your local machine can be imported to Tally. Perform the following steps to do this:

  • Copy the file in a directory.
  • Open Tally and select the company.

Tally_import_step_1.png

  • Go to Utilities and select Import of Data.

Tally_import_step_2.png

  • Select the Vouchers option.

Tally_import_step_3.png

  • Specify the file path and press Enter.

Tally_import_step_4.png

  • After the import, you can see the voucher. From the Display menu, access the Account Books.

Tally_import_step_5.png

  • Select the Ledger option to see the voucher.

Tally_import_step_6.png

  • Voucher No. 1 will be displayed, as below:

Voucher_1.png

  • Voucher No. 2 will be displayed, as below:

voucher_2.png



 

 

Have more questions? Submit a request

Comments

Powered by Zendesk