Installment / EMI module in Tally

We developed this Tally add-on product for a customer in Indore who is into financing business. This module is useful for construction companies, financing businesses, and other businesses where monthly EMIs or installments need to be received from the customer.

The module facilitates capturing of individual EMI due dates. It takes user input for total amount, no. of installments, per EMI amount, first due date and second due date. Accordingly, bill-wise references are automatically created for each EMI due date. The first and second due dates are as per user input. Subsequent due dates increase monthly based on the second due date.

The bill-wise references use the Voucher no. as the basic bill-wise reference and sequentially add /1, /2 for each EMI. If the no. of installments is high, this module is a big time saver.

This module can be further customized to generate specific MIS reports.

Company News: New customers added in Indore.

Please send your feedback to rajesh_khater@yahoo.com or rajesh@tallyguru.co.in. Dealership enquiries solicited.

Subscribe to this blog to remain informed about TDL possibilities.

Tally.ERP 9 - First Impressions

The new financial year has started and Tally has launched its ERP offering just in time. The new product launch was reason enough for increased customer interest and hence there were no special offers this March for product promotion.

My first impression of Tally.ERP has been positive. Users and administrators are going to like the Control Center and Support Center features. The flagship feature of Tally's ERP is the remote access feature, and businesses will realise the benefit of this feature down the line.

There are a few bottlenecks, though. Like the user getting the Unlock Key in mail after a long delay. With ERP, Tally has introduced a lot of new terminology, especially a lot of 'ID's, e.g your .NET ID, Site ID, Account ID and Account Admin ID. It will take some getting used to for normal users.

Quite a few existing Tally customizations have stopped working in ERP, and even after TCP conversion using the TallyAdmin tool, the TCP either gives load-time error or functional error.

We have migrated our existing TCPs to the ERP platform free of cost for most customers. TDL programmers will have a hectic schedule ahead, with fresh orders as well as migration of existing TDLs to the new platform. Moreover, they also have to get used to the powerful syntax and features of the enhanced TDL language.

A common concern among users interested in Tally customization is what will happen to the customized features when Tally brings a new release or version.

My answer is that in 90% of the new releases or versions, TDLs will run without needing any changes. In case of a major version release, there are chances that TDLs may not work correctly, as in the case of 7.2 to 9 conversion and 9.2 to 9.ERP conversion. However for all other releases in between, TDLs have continued to work smoothly.

Even when customized files do not work in the new version, it requires mostly a few adjustments as per the new language features / capabilities. For this, the user should not worry too much as the charges will be extremely nominal. And so far, we have done the TCP conversion free of cost for our users.

The road ahead for Tally.ERP is extremely bright and you can keep high expectations from the product in the coming months and years.

Company News: New customers added in Ahmedabad & Mathura. We have also started Tally product sales in Delhi (on-site installation service available, support through remote access).

Please send your feedback to rajesh_khater@yahoo.com or rajesh@tallyguru.co.in

Subscribe to this blog to stay updated.

Sales Data Analysis in Tally

The analysis of Sales figures is important for any business for a number of benefits:

1. It helps to identify the trends.
2. It pinpoints the most revenue generating products.
3. It highlights the top customers and their purchasing trends.
4. It helps the business in preparing for seasonal variations.

By customizing Tally, it is possible to generate a product-customer sales matrix report which can be exported to Excel for further analysis.

We recently developed a Sales Matrix report for one of our dealers in Nigeria. The report can be further customized as per the specific needs of individual business. We believe this report will be a valuable input for any MIS decision making.

We invite suggestions from readers for any other useful reports / features they can think of in Tally.

A few interesting enquiries came in the last week:

1. Removing all inventory details from a Tally company and converting it into an accounts-only company.

2. Removing all vouchers (accounts as well as inventory) from a Tally company and just maintaining a single day's account in Tally. The solution requires to maintain stock items in Tally and updating their stock on a daily basis. That is, there should be a tool that will read the Closing Stock for every stock item for the day, delete all the transactions data from Tally and make the Closing Balance as the Opening Balance for the next day.

Both the above requirements are possible by developing add-on tools for Tally. Let us see if these enquiries convert into orders for me :) !!

Company News: In the last few weeks, we have added new customers in Jalna (Maharashtra) and Kanpur, along with a lot of new customers in cities where we already have customer base: Hyderabad, Mumbai and Bangalore. With this, our customer/dealer base has grown to 15 cities in India and 23 cities worldwide.

Wishing all the Tally users and readers of this blog a very Happy New Year in advance !

Contact me at: rajesh_khater@yahoo.com or call at +919986057953.

We encourage more readers to subscribe to this blog to get latest posts in their inbox. Just send a mail for subscription or click here.

Multiple level of compound units in Tally

I will like to post the solution for a question I received from one of my blog readers Mr. Kishan in Kolkata.

Mr. Kishan is into a business where he needs to maintain the stock in gross, dozens and pcs. While purchasing / selling, he wanted the facility to enter the quantity as no. of gross, no. of dozens and no. of pcs.

He approached us for Tally customization. We suggested a solution that takes care of this requirement in default Tally itself without any customization.

The solution uses multiple level of compound units in Tally. You can create 3 simple units, one each for pcs, dozen and gross in Tally. Then create the 1st compound unit: "dozen of 12 pcs". Now you can create another compound unit using the first compound unit as the base. Create a compound unit called "gross of dozen of 12 pcs".

Using this approach, you can enter the quantity as follows:

1. 2-10-5 which means 2 gross, 10 dozens and 5 pieces,
2. 0-5-11 which means 0 gross, 5 dozens and 11 pieces,
3. 0-0-9 which means 0 gross, 0 dozen and 9 pieces.

This solution uses one little known feature of Tally: chaining of compound units.

Hope other readers also find this solution useful.

Mail us your customization enquiries at rajesh_khater@yahoo.com

Happy Tally-ing !

Auditing Tools for Tally

Tally has launched the Auditors Edition of Tally, which will give easy access to auditors/chartered accountants to the data to be audited in Tally.

We also present our very own Auditing Tools for Tally. Its not a ready module as of now but a concept.

If you ever felt the need to enforce certain standards of data entry in Tally and wanted to identify the existing data which do not meet the requirements or the standards, the tool can help you locate such data with ease and help you correct them.

Some examples or features of Auditing Tools are:

1. Find all items in Tally data which have alternate units defined.
2. Find all items in Tally data which dont have alternate units defined.
3. Search all items which have a particular primary or alternate unit.
4. Report of all items with Batches set as "No"
5. Identify Purchase Vouchers without Purchase Order No.
6. Stock Items which dont have Part Nos.
7. Items which dont have pricelist defined for a particular date.
8. Employees who have attendance below some benchmark value.
9. Sales invoices with duplicate voucher numbers (if any), in case of manual numbering.
10. Sales invoices where the bill no. in billwise details is not the same as the Sales voucher no.
11. Filter only deleted/cancelled vouchers in the Tally Audit List.
12. Any invoices which have items with different rates of VAT or Excise Duty.
13. Any invoices in which credit was given for more than 15 days.
14. All invoices/vouchers saved or not saved with a Voucher Class.
15. Any invoices in which discount was given more than certain allowed value.


Any number of other useful auditing points can be incorporated in the tool.

The tool is useful for chartered accountants, auditors, companies wanting to enforce accounting standards in Tally. The tool is also useful for any kind of data correction / rectification exercise.

We welcome the suggestions of chartered accountants and auditors on how the auditing tool can be made more comprehensive.

You can mail me at mailto:rajesh_khater@yahoo.com?subject=Auditing

Tally Integration with other softwares

One of our areas of expertise is in linking Tally with your favourite application. The user can have the best of both worlds. He can continue working in his favourite application and yet avoid the need to duplicate data entry in Tally for accounts. Tally integration with other softwares has several possibilities, and can build a highly collaborative system.

Some possibilities:

1. Link Excel to Tally. User can upload any masters / vouchers from Excel to Tally. Examples are stock item master upload, pricelist upload, share market contract note upload, list of ledgers, etc.

2. Oracle to Tally. Several ERPs use Oracle as their database. But Tally has its own little niche in the area of accounts and taxation, specially in Indian context. Now transfer data from ERP to Tally at the click of a button.

3. MS Access / SQL Server to Tally. Transfer data from your favourite inventory / ERP software to Tally.

4. Tally to Excel. Get customized reports the way you want in Excel. No need of rearranging rows and columns, no need of manually doing any special formatting in Excel, no need of referring to several reports/screens in Tally and compiling the data manually. If the data is there in Tally, we will give you the report in Excel !

5. Tally to other databases.

6. Tally to Tally ! Come up with a use or need of linking other applications with Tally and we should be able to give you the solution in most cases.

The options are not limited to the above. You can maintain the database of customers in a single software: Tally, and be in touch with them through SMS / email, etc. by linking Tally with your email software.

We can design ready easy-to-use single-click tools for end-users, and give DLLs to other third party software developers who want to integrate their software with Tally in real-time.


For business enquiries, you can mail me by clicking here.

Upload PriceList from Excel to Tally

PriceList updation in Tally is now made easy with this Tally Add-On Tool. If you have a large set of items and you frequently need to update the prices, this tool will save you a lot of time and headache.

This is a ready-to-use configurable tool. It will read the price list names, effective date, stock item name and their rates from designated cells in Excel and upload the entire list to Tally at the click of a button.

This is particularly useful for Distributors of FMCG products, sports goods distributors, distributors of stationery items, medicine wholesellers, etc.

Other PriceList and Billing related solutions that may be of interest to you are: Easy PriceList, Stock Group Level Price List, Price List revision tool, etc.

Dealership enquiries solicited.

You can mail me at: sales@tallyguru.co.in.

Tally for Share Market Transactions

There are lacs of share market traders who will like an easy way to upload their transactions in Tally.

Now you can upload your daily share market transactions to Tally at the click of a button.

Just send us the format of the contract note you recieve from your broker, and we will customise the tool for your specific format that will upload it to Tally.

If you are a share broker yourself, you can provide this tool as a value added service to your clients.

The only requirement is that the contract note should be in Excel format.

If you have got any other ideas of customisation for share market transactions, send us a mail for evaluation. You can click here to mail me.

Happy Tallying and Trading.

Email Subscription facility

I am now starting email subscription facility to have a better connect with readers.

You can drop me a mail at mailto:rajesh_khater@yahoo.com?subject=Subscribe%20TallyGuru with the subject "Subscribe TallyGuru".

My blog posts will reach you directly in your inbox. Also from time to time I run promotional offers and send previews of customized modules.

Subscribed users will always stay informed of the new developments in Tally customization and the promotional offers on Tally and our addons.

As an incentive to subscription, I am giving away a surprise free TCP. Your email details will be kept confidential.

Amazing Possibilities in Tally Synchronization

Synchronization in Tally is a huge convenience feature for multi-location businesses. Synchronization allows to not only view remote location data, but also make any changes to it. Synchronization will ensure up-to-date identical copies of data at any number of locations.

What does Synchronization do ?
1. It pulls all newly entered / altered transactions from the remote Tally data.
2. It pushes all newly entered / altered transactions to the remote Tally data.

Essentially, the data at both the ends will become identical after the synchronization process.

Further, through customization, you can control the synchronization process to synchronize data selectively as per your requirements.

Synchronization and a little bit of customization can open up amazing possibilities in Tally, like:
1. Uploading sales transactions from sales outlet to the HO.
2. Converting Purchase Order of 1 company to Sales Order of another company.
3. Pushing a centrally decided PriceList to all branch locations, etc.

It can help you:
1. to exercise greater control over Tally data.
2. supervise and audit / correct Tally data from a remote location.

We can now setup synchronization between any locations anywhere in India or abroad, using remote access technologies.

If you have any queries on the possibilities in Tally synchronization, do mail us at rajesh_khater@yahoo.com.