Blogger templates

Tuesday, September 20, 2011



I have collected some useful tips to run the tally easily and more efficient way .Today,I am publishing 10 tally tips only and publishing other twenty after your response.This tips are for tally.ERP 9 but few tips are also working in earlier version also .All tally Tips are shown with relevant pictures so that it is easy to understand the tips and you can learn it step by step.Due to many picture shown in the post ,this post may load slow in your computer.

Tally Tips - Your Weekly Refresher...!

1. User defined Primary Group

Did you know that you can create your own primary groups in Tally.ERP 9? 

You can create your own Primary (Main) Group under Assets, Liabilities, Income and Expenses. 

To create Main Group, go to Gateway of Tally > Accounts Info > Groups > Create

The newly created Group in the Report appears as shown.

2. Sub-Ledger concept of Group

Did you know that a group can behave as a sub-ledger in Tally.ERP 9?

Opting to set Group Behaves like a Sub-Ledger to Yes for a particular Group will not explode the sub-groups and ledgers for that group in any report, either
1.        When viewing the report in a detailed format, or  
2.        When viewing the report with the option Expand all levels in Detailed Format.
For example, set Group behaves like a Sub-Ledger for Sundry Debtors and Sundry Creditors groups to Yes. (This is set to ‘Yes’ by default, you may set this option for any other default group or user defined group)
The normal view of a Trial Balance is as given

Press Alt + F1 for a detailed view.

Press F12: Configure to set Expand all levels in Detail Format to Yes

The Trial Balance displays as shown 

3. Report Navigation with + & -

Did you know that you can navigate using the + and – keys in a report? 

In display reports of Accounting and Inventory, i.e. Group Summary, Ledger and Stock Item reports, you can
·        Move to different Group/Ledger of your choice by using F4 (Group/Ledger/ Item)
·        Move to the next or previous item within the report by using (+) and (-) respectively

4. Net Debit & Credit Balance

Did you know you can display net balances for a report?

When a Group contains Ledger balances that have Debit as well as Credit balances, you can configure a report to display the Net Balances only in all reports.

Report view with both Debit and Credit balances

To configure for Net Balance Reporting, enable Nett Debit/Credit Balances for Reporting toYes in the Group Creation/Alteration screen.

Report view after configuring for Net Balance Reporting:

5. Master Creation Shortcut Navigation Key 

Did you know that you can use shortcut navigation key while creating masters?

While creating the following Accounting Master and in the Inventory Master, you can use the short cut navigation key to move between the respective Master Creation screen
Sl No
Accounting Masters
Inventory Masters
Stock Item,
Stock Group,
Voucher Type
Voucher Type
Currencies etc.,
Unit of Measure, etc.,

For example, after creating a ledger master, press Ctrl + G to move to Group Creation screen directly. Press Ctrl + V to move to Voucher Type Creation master and so on for other masters.

6. Voucher Cancellation

Did you know that you can cancel vouchers in Tally.ERP 9? 

Apart from deleting any voucher, vouchers can also be Cancelled. While using Automatic Voucher Numbering, you can opt to cancel a voucher using Alt + X, to keep the sequence of subsequent voucher numbers intact and information of the common narration.  The cancelled vouchers will not retain Accounting or Inventory Transactions (Useful in Sales Vouchers).  Vouchers with manual numbering or where no voucher numbering is used can also be cancelled. 

Cancela voucher, go to Ledger Voucher screen (Eg. Day Book), select Single or Multiple Vouchers and press Alt + X 

Display of cancelled vouchers 
A cancelled voucher with the narration and information that the narration being retained is displayed as shown:

7. Add & Insert Voucher

Did you know that you can add or insert a voucher in the Day Book or Voucher Register?

Another useful feature that is available in Tally.ERP 9 is that it enables the user to insert or add a voucher. 

For example, in the Sales voucher Register Report which is displayed below there are two vouchers numbered 3 and 4 for May 04, 2009.

To create a new voucher or insert a new voucher with sale bill number 4 and change the bill number of the existing voucher to 5.

Select the existing voucher (number 4) and press Alt + I to insert a new voucher.

Press Alt + A to simply add a new voucher after bill number 4

8. Voucher Duplication

Did you know that you can duplicate an existing voucher in Tally.ERP 9?

This is useful when a constant amount is entered across the year or month with the same ledgers being used. To duplicate an existing voucher:
1.        Select the required voucher and press Alt +2.
2.        Make necessary changes to the voucher and save.

9. Setting Credit Limit

Did you know…?

You can set credit limit for Sundry Debtors and Sundry Creditors in Tally.ERP 9. When the outstanding amount exceeds the credit limit, Tally.ERP 9 will not allow any invoice beyond that limit unless modified.

Example: You can set a credit limit of Rs.50000/- for the customer’s ledger and raise one invoice amounting to Rs.30000/-, subsequently you can also try to raise another invoice amounting to Rs. 30000/-

To enable credit limit, set Maintain Budgets and Controls to Yes in F11 > Accounting Features

To set credit limit for the customer:

Go to Gateway of Tally > Accounts Info > Ledgers > Credit Limits > Select the Group inUnder Group (all the ledgers in that group will be listed) > Select Customer and set the Credit Limit

After the first invoice is raised for Rs.30000, try to raise the second invoice for Rs.30000. Here, Tally.ERP 9 will restrict from saving this voucher, as shown:

10. Accounting, Inventory & Related reports

Did you know that you can navigate to any Accounting or Inventory report without navigating the routine menus ….?

You can navigate to any Accounting or Inventory Reports from any report without going through the routine menu navigation.
1.        In Balance Sheet Report press F9: Inventory Report or F10: Accounting Report to access any of the reports listed from the drop-down list.
2.        There is no restriction on the number of instances one can access these reports. 
3.        Press Esc to return back in the order you progressed to different reports.
F9:  Inventory Reports

F10: Accounting Reports

Use F8: Related reports to view related reports for any individual group/ledger analysis.
F8: Related Reports 

Blogger news