Tally Tips and Tricks

Friends,

If you are using Tally then here are some tips. With the help help of these Tips you will be able to work fast in Tally. These are very simple commands. You have just to remind these Tips and enjoy working.

If you want to repeat last narration of last voucher, then go to narration of the voucher and Press Ctrl +R  it will place the last narration and will save your time to write to write narration again and again

You are entering vouchers and suppose you made a mistake in entry however the voucher was saved now you want to alter it, then you will need to follow a big long procedure.

But I will explain you here by which you will be able to modify the voucher without going to related ledger account and without leaving voucher entry screen.

Hit the page up button from your voucher screen and you will find the last entered voucher there. now you can modify it easily alter the voucher.

Similarly you can edit any voucher by this way by selecting a date and pressing page up button again and again and you will find voucher entries one by one for that particular date.

Sometimes Ago, I already explained how to create a new ledger account when you are in the middle of a voucher just press ctrl+c and you will find the ledger creation screen.

and if you want to alter name or group of any ledger you can also do the same without leaving the voucher entry screen. Just recall that voucher select the ledger you wanted to alter press enter one time you and go the amount field now hit back button and come back to the same ledger account and press Ctrl+Enter here you can modify name ,group or any details you want to modify.

You are entering amount and suppose you want to do calculation and you need the result of these calculation to be entered in the amount field. Here is a short cut for this too. Go to amount field and Press Ctrl+C and you will be redirected to calculation pane at the bottom of your tally screen.Make your calculation and after that Press ENTER the amount will be automatically field in the amount column.

Wanted to send a screen shot of your tally voucher entry of tally screen or even a ledger ?

Okay go the screen for what you wanted to take a screen shot and press PrtScr button of your key board (top right side of your keyboard) now go word press or excel and just press Ctrl+V and you will find the screen shot of your tally screen. you may send this through email to any body you wish so.

If you want me to send more Tips and Tricks of Tally to you then simply write down your email address on the TOP of this site.

Wanted to delete a voucher ? okay go to that particular voucher and Press Alt +D

More tips and tricks next time.

TALLY.ERP 9 TEN TIPS -MAKE EASIER TO USE TALLY ERP 9

Friends,

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
1	Ledger	Stock Item,
2	Group,	Stock Group,
3	Voucher Type	Godown,
4	Budgets	Voucher Type
5	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

 

Recovery of Data in Tally

Friends,

Tally is very useful software for accounting purpose. While using Tally there could be sometime we loss data while working. It creates a major problem. Data of Tally is very vital for every user or company. More serious the user is more vital data becomes. In other words we can say more and more dependence on tally needs more and more care of its data. Although tally has provided many ways to protect you data but one way or other due to some human error or system failure we loose our data. Particularly in case of tally it cripples our day today business.

We have to first see why data has got corrupted the ways to recover depends on reason it got corrupted. Here are some tips and tricks which can save you the day. First of all lets see different reasons which can cause data corruption.

Why data gets corrupted ?

The reason could be anyone of following :-

   1. While working on tally power goes off and UPS is unable to give you backup. Next time you would open tally the company in which you were working would get corrupted.

   2. The computer on which you are working is not operative and OS is not working properly. Somebody formatted it !!

   3. You have taken so many backups by copying the tally folder in so many placed that you forgot which was to original one.

   4. You have taken a backup and when you try to restore it your data is washed out.

Solutions:-

Solutions to these problems needs common sense rather than tally expertise. Lets understand some feature and working of tally. Tally provides a backup and restore utility which collects all files of tally company into one file named tbk500.001. This way of tally backup is easier to restore as this one file can be kept save and easily can be restored instead of all files in that folder. If any of the file gets missing or gets corrupted tally data wouldn't work.

In first case when data gets corrupted while working on tally and we are unable to open the company then data can simply rewritten. Come to Company selection menu. Press "Ctrl + Alt + R". Now select the company for re writing. 90% chance is that you problem would be get solved.

In second case when OS system is not working then to recover data you need computer skills and some common sense solutions can get you out of this problem

If windows is not loading then you can try to boot the system in DOS mode. Copy all tally folders and data folders into D drive. If DOS mode is also not working then take out the HDD and connect it with other computer with os system and try to open it. If the disk is ok and without bad sectors then you would be able to open the tally folder. If still it not working then before formatting give it a try with some recovery software or ask your computer hardware expert to recover data folders from drive.

The third case happens when people are running so many versions of tally and all versions work on different directories. More over they take backup by copying folders of data directory instead of taking backup from tally itself. In that case you too can get confused which one is latest and which folder is needed to be restored. In this case just remember the No. of your company in tally. For example if your company No. is 006 then go to search utility of windows and enter 006 in search box and begin search. You would see the list of folders. Now in see the locations of each folder and see the date of last modified or accessed. Choose the latest one and copy that folder in tally's current data directory. You would probably find the right one. One more method can be that you look for folder which has largest amount of data. Just go to each folder right click on the name and select properties. Here you would find the total file size of that folder. The biggest folder would be the current folder.

The fourth case happens you have created somany companies and when you restore the data that current company is not in your older data. This can also happen when data backup you have taken is already corrupted. In this case there is no solutions except you find some other backup which you have taken fortunately and which is good as well. To do some once again you can use search utility and look out for files names as tbk500.001 or what you can do is just type tbk*.*. It would get you all the files on your computer.

Some healthy tips can also save you the day.

    * Take backup on regular basis make it a habit to take backup when ever you have done enough work. The frequency of backup always depends on how much work you do one daily basis or how much work you can afford to do again!!

    * Take backup on the basis of name of days or name of month. If data is high then the backup destination can be like this d:\tallybackup\Monday or d:\tallybackup\Tuesday and so on. In this way you would get seven backups and all backups cannot be corrupted. If data volume is low then backup can be taken as d:\tallybackup\June if you can afford to do one months task in a single streach.

    * Try to make minimum companies. It would save you lots of hassles.

    * There should be only one Tally version and one Tally folder. Too many versions and folders multiplies your work. If you are two versions then try to sum up work in latest version as soon as possible.

    * There must be proper power backup while working on tally. In network environment is a must on all nodes where tally is working.

Don't Download any thing before free Registration on the TOP of this site and check your Inbox for clicking on activation link of Feed Burner.

Mobile Tchnology - Know about 2G and 3G Mobile Services

2G refers to second generation wireless telecommunication technology developed mainly for voice services and slow data services with data rates upto 9.6Kbps whereas, the 3G (3rd generation) mobile telecommunications is the generic name for the next generation of mobile networks that combines wireless mobile technology with high data rate transmission capabilities. The 3G network is capable of providing higher data rates upto 2 Mbps and supporting a variety of services such as high-resolution video and multi media services in addition to voice, fax and conventional data services.

ICC Cricket World Cup 2011 - Point Table 


Recently conducted auction of 3G spectrum has fetched Rs.3350.116 Crores per MHz, whereas there is no upfront cost of 2G spectrum as per the existing license conditions.
As on record no information is available where the price of 2G spectrum has been equated with 3G in any country of the world.

This reply was given by Shri Sachin Pilot, the Minister of State in the Ministry of Communications and Information Technology in response to a question in Parliament.

Don't Download any thing before free Registration on the TOP of this site and check your Inbox for clicking on activation link of Feed Burner.

Interest Rate on EPF approved.

The finance ministry today approved higher interest rate of 9.5 per cent to over 4.7 crore depositors with the Employees Provident Fund Organisation (EPFO) for 2010-11.


The EPFO had been paying 8.5 per cent interest on PF deposits since 2005-06. In September last year, it had recommended an increase in interest rate to 9.5 per cent for 2010-11 after discovering Rs 1,731 crore surplus in their books of accounts.


"The finance ministry has ratified 9.5 per cent rate of return on PF deposits for 2010-11. We have received a notification in this regard," Central Provident Fund Commissioner Samirendra Chatterjee said.


ICC Cricket World Cup 2011 - Point Table 


Chatterjee further added that "our calculations regarding Rs 1,731 crore surplus in the interest suspense account were found correct by the finance ministry and so they approved this higher rate of return".


The finance ministry's approval is subject to the condition that any shortfall on account of payment of 9.5 per cent rate of return would be met by making adjustments in the interest rate in 2011-12.


Chatterjee, however, said that there would be no need for making any adjustment in the next fiscal as "EPFO calculations are correct regarding the discovery of a surplus of Rs 1,731 crore in the interest suspense account."


The finance ministry has also asked the EPFO to update its subscriber accounts within the next six months.


EPFO's apex decision making body--the Central Board of Trustees (CBT)-- in September last year had decided to provide 9.5 rate of return on retirement savings in 2010-11 after it found a surplus of Rs 1,731 crore.


Refusing to ratify the said rate of return, the finance ministry had earlier argued that the surplus shown by the ministry was not real after CAG report has called the EPFO's so called surplus unverifiable.


According to sources, the finance ministry approved 9.5 per cent interest after the intervention by Finance Minister Pranab Mukherjee.

Don't Download any thing before free Registration on the TOP of this site and check your Inbox for clicking on activation link of Feed Burner. 

Tally Shortcut Keys : Special Function Key Combination

Friends,

Special Function Key Combination

Windows	Functionality	Availability
ALT + F1	To close a company To view detailed report To explode a line into its details	At all the menu screen At almost all report screen At almost all screens in TALLY
ALT+ F2	To change the system period	At almost all screens in TALLY
ALT + F3	To select the company info menu To create/alter/shut a Company	At Gateway of Tally screen
ALT + F4	To select the Purchase Order Voucher Type	At Accounting / Inventory Voucher creation and alteration screen
ALT + F5	To select the Sales Order Voucher Type To view monthly and quarterly report	At Accounting / Inventory Voucher creation and alteration screen At almost all report screens in TALLY
ALT + F6	To select the Rejection Out Voucher Type To change the Sales Order Voucher Type	At Accounting / Inventory Voucher creation and alteration screen
ALT + F7	To select the Stock Journal Voucher Type To accept all the Audit lists	At Accounting / Inventory Voucher creation and alteration screen At TallyAudit Listing screen
ALT+ F8	To select the Delivery Note Voucher Type To view the Columnar report	At Accounting / Inventory Voucher creation and alteration screen At Ledger Voucher screen
ALT + F9	To select the Receipt Note Voucher Type	At Accounting / Inventory Voucher creation and alteration screen
ALT + F10	To select the Physical Stock Voucher Type	At Accounting / Inventory Voucher creation and alteration screen
ALT + F12	To filter the information based on monetary value	At almost all report screens
CTRL + ALT + F12	Advanced Config	At Gateway of Tally

 

Key Combination used for navigation

 

Windows	Functionality	Availability
PgUp	Display previous voucher during voucher entry/alter	At voucher entry and alteration screens
PgDn	Display next voucher during voucher entry/alter	At voucher entry and alteration screens
ENTER	To accept anything you type into a field. To accept a voucher or master To get a report with further details of an item in a report.	You have to use this key at most areas in TALLY At the receivables report – press Enter at a pending bill to get transactions relating to this bill (e.g., original sale bill, receipts and payments against this bill, etc)
ESC	To remove what you typed into a field To come out of a screen To indicate you do not want to accept a voucher or master.	At almost all screens in TALLY.
SHIFT + ENTER	Collapse next level details	At Voucher Register screen and Trial Balance report
SHIFT + ENTER	To explode a line into its details	In almost all Reports: At a Group/Stock Group/Cost Category/Godown/Stock Category – displays Sub Groups and Ledgers/Stock Items/Cost Centres/Secondary Godowns/Secondary Stock Categories At a Voucher – displays its entries and narration At a Stock Item- displays its godowns and batch details At Voucher Register screen – displays the next level details At Trial Balance report - displays the next level details
CTRL + ENTER	To alter a master while making an entry or viewing a report	At voucher entry and alteration screens At all reports

How to use Tally Data Backup Option in TALLY

 Friends,

Its very important to take backup of your data. Generally no one takes backup. But when there is some problem and we are in need of old data we can't get it. Now to solve this problem and  protect your data a BACKUP Utility is  designed here .  As we open tally, on Gateway of Tally, on pressing Alt+F3  Backup option is available as shown in below picture.  Backup can be selected either from mouse or from typing "B".

.

In backup option, following screen will be displayed.  You have to give the Source path from where data to be copied and Destination path where data will be stored. Source is your actual data where your tally data is available and Destination is a place where you want to copy the data.  The can be store on  floppy, pen drive or any other computer device.. 

Backup file is stored like as TBK900.001 in D:\backup\Dec3108.  With the help of backup , everyone can save his books for further use. 

In the other way we can take backup of tally to save folder c:\tally\data at another place.  A batch file can also be created  for taking backup which detail is given as under:

How to Create Batch File

First of all Open Notepad through below path

Start>All Programmes> Accessories >Notepad

and write down the  below command in notepad

                                     xcopy  C:\Tally\data\*.*  d:\backup\tally\*.* /S /y

                                     c:\tally\tally72.exe

Now, save the file using Save As option under File Menu of Notepad as shown in below picture 

Backup.bat file can be stored in any where either at you desktop or any computer drive etc.  Before running tally in a day and running well tally data,  it should be pressed on daily basis.   You can also alter Path in batch file as per your convenience. 

If you feel inconvenience to do all the process as explained above to create BACKUP.ZIP file then download this file form  Here.

Extract the file and use backup.bat file.