There is new Excel to Tally Utility. The name of utility is Excel2Tally. It is simple to use. No TDLs, No more generating csv or xml files, No more multiple steps.
The cost of the Utility without support from us is Just Rs. 999/-
You may download the free to use sample Excel2Tally utility for your testing purpose from the following link
https://www.tally-help.com/excel2tally-sample/
To get the full version check the following link :
https://www.tally-help.com/excel2tally-full-version/
Give it a try. It would definitely save lots of your time in data entry in Tally.
Many users are facing issue downloading Tally utilities. Please find below our new website
To download narration shortcut utility click on the following URL
| Auto Cheque Configuration |
| Copy the readily available Cheque dimensions for selected banks on just one click and select. |
| Steps to Install Step 1 : Download following ppt file by clicking the link mentioned below Step 2 : Clink on the icon on slide 12. And Unzip the file and save the extracted files in your Tally Folder Step 3 : In Tally Goto : Gateway of Tally–>Press F12–>TDL configuration–>Press F4 Step 4 : Set the value Load TDL on startup=Yes Step 5 : Set the value List of TDL preload=UTIL025_Ver1_00_Auto Cheque Config.tdl |
| Download file |
We have found some more interesting Addons on one of the sites. It has following AddOn utilities for Tally.
- Tally Calendar : Using this you can set Tasks and Holidays and any important events to remember Share the stored events with other User in Multi User Environment Very useful for the all types of Tally Users.
- Tally Colors : This utility has changed some of the Default colors of Tally.ERP to make it more beautiful.
- Recycle Bin : A very well-known utility. If you delete the voucher, it will first go to recycle bin, so that you can recover it in future, if required.
- Address Book : This utility generates a Report which shows the address of all the ledgers.
- Grid Lines : This will add Grid lines to all the Default reports in Tally. This would be very useful specially for printing the reports.
To download all the above utilities click the link below.
http://www.tallyworld.org/free.php
All these utilities are free. You will also find the demo Videos. But the source code is not open. Anyways, enjoy Tallying!!!
One of the major advantages of the Tally is its Keyboard based user interface. This interface has minimal or no mouse interference. It helps users to make data entry very fast. Hence, it is always required to know some short cut key combinations which would make your tally experience much easier and faster.
As a general rule, you must know that the short cut keys appear in the buttons on the right side of the tally screen (also on the top of screen for Tally ERP). You can either click the button or click the key combination mentioned on the button. But do you know the logic for the same? Here it is…
The buttons have Key in Bold Red Colour with single underlined or double underlined or without underline.
-
If button has single underline that means the key must be pressed with the combination of ALT. E.g. F2: Period –
which means you, need to press ALT + F2 to invoke period option. -
If button has double underlined that means the key must be pressed with the combination of CTRL. E.g. “Vch
Types” – which means you, need to press CTRL + V to invoice voucher types option. -
If button has no underlined character that means key must be pressed without any combination. E.g. “F1: Select Cmp” – which means you need to press only F1 to invoke select company screen.
Shortcut keys available in Tally are listed below.
Function Key Combination
|
Key(s) |
Functionality |
Availability |
|
F1 |
To select a company |
At all masters menu screen |
|
F1 |
To select the Accounts Button |
At the Accounting Voucher creation and |
|
F1 (ALT+F1) |
To select the Inventory To view the detailed or condensed |
At the Inventory/Payroll Voucher |
|
F1 (CTRL + F1) |
To select Payroll Vouchers to alter |
At the Accounting/Inventory voucher |
|
F2 |
To change the current date To select company inventory features |
At almost all screens in TALLY.ERP 9 At the F11: Features screen |
|
F3 |
To select the company To select Company Statutory & |
At almost all screens in TALLY.ERP 9 At F11: Features screen |
|
F4 |
To select the Contra voucher |
At Accounting / Inventory Voucher |
|
F5 |
To select the Payment voucher |
At Accounting / Inventory Voucher |
|
F6 |
To select the Receipt voucher |
At Accounting / Inventory Voucher |
|
F7 |
To select the Journal voucher |
At Accounting / Inventory Voucher |
|
F8 |
To select the Sales voucher |
At Accounting / Inventory Voucher |
|
F8 (CTRL+F8) |
To select the Credit Note voucher |
At Accounting / Inventory Voucher |
|
F9 |
To select the Purchase voucher |
At Accounting / Inventory Voucher |
|
F9 (CTRL+F9) |
To select the Debit Note voucher |
At Accounting / Inventory Voucher |
|
F10 |
To select the Reversing Journal |
At Accounting / Inventory Voucher |
|
F10 (Ctrl + F10) |
To select the Memorandum voucher |
At Accounting / Inventory / Payroll |
|
F11 |
To select the Functions and Features |
At almost all screens in TALLY.ERP 9 |
|
F12 |
To select the Configure screen |
At almost all screens in TALLY.ERP 9 |
Special Key Combination
|
Key(s) |
Functionality |
Availability |
|
ALT + 2 |
To Duplicate a voucher |
At List of Vouchers – creates a |
|
ALT + A |
To Add a voucher
To Alter the column in columnar report |
At List of Vouchers – adds a voucher Alters the column in all the reports |
|
ALT + C |
To create a master at a voucher screen
To access Auto Value Calculator in the |
At voucher entry and alteration
At all voucher entry screens in the |
|
ALT + D |
To delete a voucher To delete a master To delete a column in any columnar (if it has not been already assigned a |
At Voucher and Master (Single) All the reports screen which can be |
|
ALT + E |
To export the report in ASCII, Excel, |
At all reports screens in TALLY.ERP 9 |
|
ALT + I |
To insert a voucher
To toggle between Item and Accounting |
At List of Vouchers – inserts a At creation of sales and purchase |
|
ALT + G |
To select the Language Configuration |
At almost all screens in TALLY.ERP 9 |
|
ALT + K |
To select the Keyboard Configuration |
At almost all screens in TALLY.ERP 9 |
|
ALT + O |
To upload the report at your website |
At all reports screens in TALLY.ERP 9 |
|
ALT + G |
To select language for TALLY.ERP 9 |
At almost all screens of TALLY.ERP 9 |
|
ALT + M |
To Email the report |
At all reports screens in TALLY.ERP 9 |
|
ALT + N |
To view the report in automatic |
At all the reports where columns can |
|
ALT + P |
To print the report |
At all reports screens in TALLY.ERP 9 |
|
ALT + R |
To repeat the narration in different |
At all Vouchers in TALLY.ERP 9 |
|
ALT + S |
To bring back a line you removed using |
At all reports screens in TALLY.ERP 9 |
|
ALT + U |
To retrieve the last line which is |
At all reports screens in TALLY.ERP 9 |
|
ALT+ V |
From Invoice screen to bring Stock |
At Invoice screen > Quantity Field |
|
ALT + X |
To cancel a voucher in Day Book/List |
At all voucher screens in TALLY.ERP 9 |
|
ALT + R |
To repeat the narration in different |
At almost all screens in TALLY.ERP 9. |
|
CTRL + A |
To accept a form – wherever you use |
At almost all screens in TALLY.ERP 9, |
|
CTRL + B |
To select the Budget |
At Groups/Ledgers/Cost Centres/ |
|
CTRL + ALT + B |
To check the Company Statutory details |
At all the menu screens |
|
CTRL + C |
To select the Cost Centre
To select the Cost Category |
At Groups/Ledgers/Cost Centres/ At Stock Groups/ Stock Categories/ |
|
CTRL+ E |
To select the Currencies |
At Groups/Ledgers/Cost Centres/ |
|
CTRL + G |
To select the Group |
At Groups/Ledgers/Cost Centres/ |
|
CTRL + H |
To view the Support Centre |
At Almost all screens in TALLY.ERP 9 |
|
CTRL + I |
To select the Stock Items |
At Stock Group/ Stock Categories/ |
|
Ctrl + Alt + I |
To import statutory masters |
At all menu screens |
|
CTRL + K |
To Login as Remote Tally.NET User |
At Almost all screens in TALLY.ERP 9 |
|
CTRL + L |
To select the Ledger
To mark a Voucher as Optional |
At Groups/Ledgers/Cost Centres/ At the creation and alteration of |
|
CTRL + O |
To select the Godowns |
At Stock Group/ Stock Categories/ |
|
CTRL + Q |
To abandon a form – wherever you use |
At almost all screens in TALLY.ERP 9. |
|
CTRL + R |
To repeat narration in the same |
At creation/alteration of voucher |
|
CTRL + Alt + R |
Rewrite data for a Company |
From Gateway of Tally screen |
|
CTRL + S |
Allows you to alter Stock Item master |
At Stock Voucher Report and Godown |
|
CTRL + U |
To select the Units |
At Stock Groups/ Stock Categories/ |
|
CTRL + V |
To select the Voucher Types
To toggle between Invoice and Voucher |
At Groups/Ledgers/Cost Centres/ At creation of Sales/Purchase Voucher |
|
CTRL + K |
To login to Control Centre |
At almost all screens of TALLY.ERP 9 |
|
CTRL + H |
To access Support Centre. Wherein you |
At almost all screens of TALLY.ERP 9
|
|
Alt + Enter |
To view the Voucher display |
At Day Book and almost all Voucher |
|
Alt + S |
To view Stock Query report |
At all Voucher Creation and Alteration |
Special Function Key Combination
|
Key(s) |
Functionality |
Availability |
|
ALT + F1 |
To close a company To view detailed report To explode a line into its details To select Inventory vouchers to alter |
At all menu screens At almost all report screens At almost all screens in TALLY.ERP 9 At the Inventory/ Payroll voucher |
|
ALT + F2 |
To change the period |
At almost all screens in TALLY.ERP 9 |
|
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 |
At Accounting / Inventory Voucher creation |
|
ALT + F5 |
To select the Sales Order Voucher Type To view monthly and quarterly report |
At Accounting / Inventory Voucher At almost all report screens in |
|
ALT + F6 |
To select the Rejection Out Voucher To change the Sales Order Voucher Type |
At Accounting / Inventory Voucher |
|
ALT + F7 |
To select the Stock Journal Voucher To accept all the Audit lists |
At Accounting / Inventory Voucher At Tally Audit Listing screen |
|
ALT + F8 |
To select the Delivery Note Voucher To view the Columnar report |
At Accounting / Inventory Voucher At Ledger Voucher screen |
|
ALT + F9 |
To select the Receipt Note Voucher |
At Accounting / Inventory Voucher |
|
ALT + F10 |
To select the Physical Stock Voucher |
At Accounting / Inventory Voucher |
|
ALT + F12 |
To filter the information based on |
At almost all report screens |
|
Ctrl + F1 |
To select payroll vouchers for |
At the Accounting/Inventory Voucher |
|
CTRL + ALT + F12 |
Advanced Configuration |
At Gateway of Tally |
Key Combination Used for Navigation
|
Key(s) |
Functionality |
Availability |
|
PgUp |
Display previous voucher during |
At voucher entry and alteration |
|
PgDn |
Display next voucher during voucher |
At voucher entry and alteration |
|
ENTER |
To accept anything you type into a To accept a voucher or master To get a report with further details |
You have to use this key at most areas At the receivables report – press |
|
ESC |
To remove what you typed into a field To come out of a screen To indicate you do not want to accept |
At almost all screens in TALLY.ERP 9 |
|
SHIFT + ENTER |
Collapse next level details |
At Voucher Register screen and Trial |
|
SHIFT + ENTER |
To explode a line into its details |
In almost all Reports: At a Group/Stock Group/Cost At a Voucher – displays its entries At a Stock Item- displays its godowns At Voucher Register screen – displays At Trial Balance report – displays the |
|
CTRL + ENTER |
To alter a master while making an |
At voucher entry and alteration At all reports |
Some more Key Combinations
|
Key(s) |
Functionality |
Availability |
|
ALT + CTRL + C |
Copy the contents of current field. |
On any field while editing. |
|
ALT + CTRL + V |
Paste the copied contents on current |
On any field while editing. |
|
CTRL + ENTER |
For Entering multiple Lines. E.g in |
On any field while editing. |
|
CTRL + R |
To Repeat the previous narration |
On narration field while editing |
Please note that the source of this document is the Tally’s official Website. Please do let us know your comments / suggestions.
| Merge Ledgers |
| Tally does not provide any option for merging two ledgers. So here is the utility which will allow you to merge two ledgers. |
| Steps to Install Step 1 : Download the TDL file by clicking the link mentioned below Step 2 : Unzip the file and save it in your Tally Folder Step 3 : In Tally Goto : Gateway of Tally–>Press F12–>TDL configuration–>Press F4 Step 4 : Set the value Load TDL on startup=Yes Step 5 : Set the value List of TDL preload=UTIL006_Ver1_00_Merge Ledgers.tdl |
| Download Utility |
| Monthly Columnar Register |
| Tally does not provide Columnar Register in Monthly summary Format. This utility will provide the monthly summary of Sales/Purchase/Debit Note/Credit Note Registers. |
| Steps to Install Step 1 : Download the TDL file by clicking the link mentioned below Step 2 : Unzip the file and save it in your Tally Folder Step 3 : In Tally Goto : Gateway of Tally–>Press F12–>TDL configuration–>Press F4 Step 4 : Set the value Load TDL on startup=Yes Step 5 : Set the value List of TDL preload=UTIL019_Ver1_00_Columnar Monthly summery.tdl |
| Download TDL file |
What are the benefits of subscribing to this blog?
1) You don’t need to check this site again and again to check if anything new is added to this site. You will receive an automatic email notification for each of the newly added content to this blog.
2) You will get free support for any bug you find in the Free Tally Addon TDLs provided by us.
3) You will get 5% discount on any of the customization that you will do with us. (Discount is applicable, even if you are not the end user and want to sell that solution to other person.)
4) You will get 10% discount on Tally Addon solutions developed by us. (Discount is applicable, even if you are not the end user and want to sell that solution to other person.)
What are the potential risks involved in subscribing to this blog and what is the solution?
1) If you are not interested in the contents of this blog, still you will receive an email for any updates on this site.
Solution : In such case you can unsubscribe to the blog by clicking a link on the mail that you are receiving through this blog. You will not receive any mails after that.
2) Your e-mail id will be with us which can be used for sending you advertising mail etc.
Confirmation : In such case, we assure you that your mail ids will be kept as confidential and we will not send you any mail other than the updates on this blog (web site).
How to subscribe?
On the Right side panel, you will see subscribe to this blog. And there is one text box. Please enter your email id and click on the “Sign me Up!” button.
If you compare the benefits with the risks, we are very sure that you will subscribe to this blog (web site). And believe me, there are many more free Tally Addon TDLs are to be provided by us very soon. So, please go ahead and subscribe!!!
Hello,
There was a mejour bug in the Free TDL Add-On : 001. I have rectified the bug and updated the link for downloading the TDL file. You can download the new TDL file and it’s help by opening the post “Free TDL Add-On : 001” and then clicking on the link “Download TDL”. Or just click here to Download TDL file.
Sorry for the Bug. But I expect the bug reporting from you people. Your response is the price for my efforts.
Sankalp Infotech 