Tally 9 Mantra for the powerful outstanding report option to perform Audit and review.

By default, Tally’s Outstanding Receivable/Payable report displays all bills that are outstanding as on the date of report.

You can customize the report with various parameters to view:

  1. Only overdue bills.
  2. Outstanding list without advance payments.
  3. Pending amount with post-dated transactions included.
  4. Pending amount with opening balance.
  5. All bills’ outstanding ‘age in days‘ from bill date irrespective of due date.

Default Receivable report.

Overdue bills as on the date of report are displayed as BOLD (Inv date- 19th Feb 06 and due on the same date, 19th Feb 06, report date 20th March 06, overdue by 29 days) and pending bills are listed in the normal font.

1.To View Only Overdue receivables.

From the Bills Outstanding report, press F12: Configure and set Range of Bills to Show as Overdue Bills.

 

About us
Winjit technologies Pvt. Ltd is Tally master Distributor with branches in Nashik and Kota. Winjit has a Team of qualified professional to help you cater to your needs.  This is a series of “Tally 9 Mantras” an initiative started by Winjit in enabling our customers to use the power of tally. People who wish to receive these emails may send in their request to tally@winjit.com with the subject as “Tally 9 Mantras”. The experts at Winjit will work regularly in sharing their expertise on Tally with you.
 
Winjit has a team of more than 50 Software professional catering to customers in more than 15 countries 

Data Migration - converting Tally 4.5 data to Tally 9 Data


The migration of data from Tally 4.5 to Tally 9 is a two stage process. You will first need to migrate the data to Tally 7.2 compatible data using ‘Tally 4.5 to Tally 7.2 Data Migration’ utility. Then migrate the Tally 7.2 data to Tally 9 compatible data using ‘Tally 7.2 to Tally 9 Data Migration’ utility.

Stage 1: Migration data from Tally 4.5 to Tally 7.2

1.

Download the Tally 4.5 data converter:

  

• Click the Download Now button below

  

  

Or

  

• Right click the following link and click ‘Save Target As’ from the right click option

  

http://www.tally.co.in/Convert45to72.exe

  

  

2.

Run the Convert45to72.exe and extract the files to a folder

3.

Copy the extracted files to the directory where Tally 4.5 is installed

  

a.

WCVTALLY.EXE

b.

TW45250.DLL

c.

CNVTALLY.DAT

4.

Run the file WCVTALLLY.EXE (the icon will be identical to Tally Icon). (You can also execute this file from command prompt

  

  

  

Click Start > Run > Type ‘C:\<Tally 4.5 directory name>\WCVTally.EXE C:\<Data path>

  

  

5.

Company Info screen appears, select the company you want to migrate. You will be asked to confirm conversion, and the Data is converted.

6.

Run Tally 7.2, and select ‘Backup‘ from Company Info screen.

7.

Specify the location of data you just migrated in the ‘Source‘ field, select the company and backup the data

8.

Now select ‘Restore‘ from the Company Info screen of Tally 7.2

9.

Specify the location where the company backup is stored in the ‘Source‘ field and restore the company

10.

From the Company Info screen of Tally 7.2, select the Company for which data has been converted. The system will prompt for aRewrite. Select ‘Yes’ and proceed.

11.

The data is now ready to be viewed in Tally 7.2.

  

  
Note:

  

a.

The Conversion utility will run in Black & White only (even if you have a Color Monitor)

b.

If you do not have Tally 7.2, you can download Tally 7.2 installer for free from the Tally Solutions website. Install and use it in Educational mode
Stage 2: Now proceed to migrate data from Tally 7.2 to Tally 9, as mentioned below:

12.

Install Tally 9

13.

Now run ‘TallyMigrateData‘ utility from Start > Programs > Tally 9 > TallymigrateData

  

Note: You can also run the migration utility by double clicking tally72migrate.exe file located in the folder where Tally 9 is installed.

14.

The utility will launch Tally Data Migration Tool and Tally 9

15.

Select ‘Migrate Data‘ in the Migration Company screen

16.

Specify the directory where Tally 7.2 data is located in the ‘Directory‘ field

17.

Select the company from the List of Companies

18.

Data Migration utility loads the data of selected company and asks for confirmation

19.

Select ‘Yes‘ and start the migration of selected company

20.

The status of migration from Tally 7.2 to Tally9 is shown in the Migration Messages Pane

21.

When the migration is complete, it displays an information pop-up, ”Migration Completed, Check Statistics (press any key)”

22.

On pressing any key ‘Congratulation‘ message appears confirming the completion of the migration of the data
Note: If any error occurs during migration, the error details are written to ‘migration.err‘ file, which is automatically generated and saved in the folder where Tally 9 is installed.

23.

The migrated company is by default saved in the Tally 7.2 data folder. The migrated data is prefixed with a ‘0′ and appears as a 5 digit number. For example, if the company folder number, before migration was ‘0099′, after migration it would be ‘00099′.

24.

Now your migrated data is ready for use in Tally 9

Tally 9 Mantra for auto calculation of amounts for ledgers / groups not under taxes / duties.

Calculation of discounts and/or taxes, even for ledgers not grouped under Duties and Taxes, is possible in Tally. To enable this, set option Used for Calculation (eg., Taxes, Discounts) to Yes in “Group Master Screen“(creation or alteration) for the Group where the ledger created needs to be used for calculation.

For example, Ledgers created under any other Group can be used in Sales and Purchase invoice entry for auto calculation.

 Ledger Creation with calculation:

 

 The following Voucher entry screen appears.

Tally 9 Mantra to delete a voucher.

Tally does not allow you to delete multiple transactions at once.  You must delete one transaction at a time.  Select the desired voucher and press enter to display the voucher in “Voucher Alteration (Secondary) and press ‘Alt + D’ and press ‘Y’ or enter to delete the voucher. 

    

 
 

 
 

Alternative you can highlight the transaction and press “Alt + D” to delete the voucher.

Note: Once the voucher is deleted, it is gone forever, you do not have undelete or recycle bin concept.

  

Tally 9 Mantra for Printing Cheques on in standard cheque books

Tally offers cheque printing facility, where the cheque details are printed on your cheque leaf when a payment voucher is made.

To enable cheque printing,

1. In F11: Features set Modify Other Company Features to Yes.

2. In the Advanced Company Operations screen, set Enable Cheque Printing to Yes.

 
 

Company Name on Cheque: If the cheque book does not have the name of the company pre-printed, then type the name of the company. 

Name of Banks: The list of all created bank accounts under the group Bank or Bank OD A/c /OCC A/c displays. Select the required bank and specify the dimensions of the cheque in the Cheque Printing Configuration screen.

Cheque Printing Configuration screen: Dimensions are specified as per the bank’s cheque leaf.

An Expense Account can be debited directly and payment can be made in the name of the supplier as displayed in the following screen.

 
 

Print preview of the printed cheque displays.

 
 

About us
Winjit technologies Pvt. Ltd is Tally master Distributor with branches in Nashik and Kota. Winjit has a Team of qualified professional to help you cater to your needs.  This is a series of “Tally 9 Mantras” an initiative started by Winjit in enabling our customers to use the power of tally. People who wish to receive these emails may send in their request to tally@winjit.com with the subject as “Tally 9 Mantras”. The experts at Winjit will work regularly in sharing their expertise on Tally with you.
 
Winjit has a team of more than 50 Software professional catering to customers in more than 15 countries 

Mantra for Easier Navigation in Tally 9 during Inventory reports

In display reports of Accounting and Inventory, ie 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 next or previous item within the report by using (+) and (-) respectively.

  

Tally 9 Mantra on How to Set up Security in Tally 9?

If you wish to subscribe to Tally 9 mantras by email click on the button on the right hand side to subscribe to this free email list and receive the mantras to success by email.

 

Tally has a very customisable security system. You can set up Security Levels and users who are placed at these levels. The authority levels or Types of Security decides the rights of the users while using Tally.

 
 

I attach herewith some basic steps on implementing a security system. The system is very roles based and hence more customizable on roles rather than on vouchers. 
 
To create Security Levels

Go to Gateway of Tally, select F3: Cmp Info. > Create/Alter Company   

In the Company Creation screen set Use Security Control to Yes.

Enter the Name of the Administrator.

Enter your Password and reenter the password for verification. The password is not displayed for security reasons.

Accept Yes to save the changes made.

Types of Security (security or authority levels)

Tally has two default Security Levels. One is Owner and the other Data Entry. Owner has full access and rights to all features of Tally, except Tally Audit & Company Alteration screen, which are reserved for the Administrator alone. Data Entry has restricted rights. You are allowed to create other security levels based on these pre-defined types and allow or restrict rights as required.

Create a New Security Level
You can create New Security Levels and define task wise access rights. To create New Security Level:


Go to Gateway of Tally, select F3: Cmp Info. > Security Control> Types of Security

The Security Levels screen is displayed as shown below:


 
 

The Level Definition Screen


 A brief description on all the fields in the Level Definition screen follows:

Name of security level
This defaults to the name you have created.

Use Basic Facilities of

The default is Owner. You can select the other option Data Entry from the Security List. If the

company has other user defined Security Levels, these are also displayed in the Security List. The new level created will be available in the Security List the next time you create a Security Level.

Days allowed for Backdated vouchers
This is the number of days the users of this Level are allowed to create backdated vouchers. Specifying 0 will indicate that back-dated vouchers are not allowed, and 7 will allow the user at this level to insert vouchers going back 7 days.

Cut-off date for Backdated vouchers.
Specify the date before which users of this Security Level may not create or alter vouchers. This is additional control over and above the previous Days allowed for Backdated vouchers. This is useful in cases where you have completed your Tax Assessment for a period and no changes are desired in the data for that period.

Disallow the following facilities/Allow the following facilities
The screen is now divided into two broad columns each having two sub-columns. The left side of the screen is to disallow access to the various options of Tally. The right side allows the Security Level access for the different options.

When the cursor is on an access rights filed, the Type of Access list is displayed. Select an option from the list. The options sought to be controlled like Accounts Masters, Balance Sheet etc. are on the right (the second column from the left)


To disallow access to different options, first select the type of access from the Type of Access list. Then select the reports for which the access rights are restricted from the List of Reports. Repeat the procedure till you have set access rights for different reports. When you select a type of access, this type of access would be restricted for the corresponding report selected. For E.g if you select Full Access for Balance Sheet, the user will not have any access to Balance Sheet by this security level.

Conversely, under Allow the following facilities, if you select Full Access for Balance Sheet, the user will have full access.

Select [End of List] at the Type of Access field to complete the process.

You are taken back to the screen Security Levels for Company at a blank field following the one you just created. To create the next level, type the name and follow the same procedure. Otherwise press Enter key at the blank field and Accept, Yes to save

Copy and Paste in Tally 9

Did you know that you could do a copy paste similar to you do in Excel or Microsoft Word. The only difference is you can copy and paste and entire field in Tally.

For Copying Data from tally use ” CTRL + ALT + C” ,

for Pasting data in Tally use “CTRL + ALT + V”

 

Eg :     

Select the Text which has to be pasted from Tally 9. Press Ctrl + C. This will copy the text in the Clipboard.

Assuming I have to paste the contents in the narration field. I go to Narration Filed and Press “Ctrl + Alt + V”

 

About us

Winjit technologies Pvt. Ltd is Tally master Distributor with branches in Nashik and Kota. Winjit has a Team of qualified professional to help you cater to your needs. This is a series of “Tally 9 Mantras” an initiative started by Winjit in enabling our customers to use the power of tally. People who wish to receive these emails may send in their request to tally@winjit.com with the subject as “Tally 9 Mantras”. The experts at Winjit will work regularly in sharing their expertise on Tally with you.

 

These would help your people enhance the use of basic Tally. You may forward the emails to your friends anc colleages


Customized Modules on Tally 9

I have been lately very excited on the developments happening on the tally front. To create more excitement I am pleased to upload few of the regularly required customized modules by customers. You can download the module and use it as per the below instructions. Over the next few days II will post new files.

These files a free for use for 90 days from today and you can buy them at a very nominal price of Rs 900/- plus tax. Please send an email at tally@winjit.com for further inquiries.

 

Module 1 : CONTACT ADDRESS BOOK.

This module will help you maintain your contact details of your debtors and creditors in tally. The download link is http://www.tally9.info/AddressBook.tcp

 

Steps 1:
Configure Tally.ini file. :-

 

  • Store / Copy the TDL file in the Tally 9.0 folder.
  • Open Tally.ini (i.e. configuration file) file from tally folder.



Change the following setting into ini file.

User TDL = Yes

; Tdl = <tdlfile.1>

Remove the semicolon (;;) and specify the TCP file name

For E.g.

Tdl = TDL1.tcp

Save Tally.ini file and close it.

Steps 2:
Configuration for activating Address Book Module. :-

  • Go to Gateway of Tally à Accounting features à Other Features.
  • Set “Yes” to “Maintain Contact List’ option as shown in the image below.


  • Now you will find a new Menu on Gateway of Tally à Contacts
  • Address book report shown as follows.

Tally Launches Tally Auditor along with BAP program a Part of Tally 9 release 3

Tally has just changed the rules of the Audit game for chartered accountants and just come up with something what chartered accountants have been waiting for Years.

As I had mentioned earlier that in coming days I will be posting more details on the revolutionary Tally 9 Release 3.

Tally has included teh entire Tax compliance audit requirements in Tally 9 Rel 3. The Beta version is available for download at http://www.tally9.info or at http;//www.tallysolutions.com.

 

Details about what is there in the auditors pack would be available soon !!!! Keep watching this space and if you have more information do not mind sharing it with me.

Designed by Posicionamiento Web | Sponsored by India