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 !

Tuesday, September 2, 2008

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

Saturday, July 26, 2008

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.

Friday, July 11, 2008

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.

Friday, June 6, 2008

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.

Sunday, May 4, 2008

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.

Monday, March 3, 2008

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.

Saturday, January 12, 2008

Help on Tally is just a call away

We are now starting Tally support in Bangalore in a big way.

Although tally is a very robust software with few maintenance issues, customers do occasionally get stuck and need urgent help.

Accounts being a core business activity, help needs to be prompt and effective.

Customers sometimes need support on issues like:

1. Tally password recovery
2. Splitting of large company data
3. Synchronization of head office data with branch data
4. Usage of Group company feature for consolidation of individual companies' data
5. Internal error problem in Tally
6. License becoming educational after hard disk format/crash.
7. License expiry in Tally and Tally asking for license updation periodically.
8. Usage of specific Tally features like price inclusive of VAT; having fixed, pre-defined expense heads in Sales invoices; Security features of Tally; Excise for dealers; etc.

Now support is just a call away. Any time you need help on Tally, all you need to do is just pick the phone and call us. Expert help will reach you immediately.

Customers in other parts of India can also avail our services by making advance payment. We will solve your problem remotely.

You can get our contact info / phone nos. by sending a mail to rajesh_khater@yahoo.com