Sunday, December 28, 2008

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.

Tuesday, December 9, 2008

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 !