Friday, December 28, 2012

How to install Tally.ERP 9 Release 3.2 (Release 3.0 onwards) Multi User on Client Machine?

How to install Tally.ERP 9 Release 3.2 (Release 3.0 onwards) Multi User on Client Machine?


1. Double click the INSTALL.EXE icon available on the CD or click START from Windows, select RUN and TYPE <CD drive>:\INSTALL and then press ENTER.

 Follow the instructions displayed on your screen to proceed with the Installation of Tally.ERP 9.
The Tally.ERP 9 Setup Wizard is displayed as shown:

2. Click Next to continue with Installation.
The Tally.ERP 9 Setup screen is displayed as shown:


3. Select Multi User and then select Client Machine.
4. Click Next.
The Tally.ERP 9 Setup screen is displayed as shown.
  


5. In Tally.ERP 9 Configuration section accept the default Application, Data, Configuration Language directories and enter the server¡¦s Name/IP address and Port number.
  • Application Directory: Tally.ERP 9 program files reside in this directory.
  • Data Directory: Enter the Name/IP Address of the computer and the name of the shared data folder noted earlier.
  • Configuration Directory: Tally.ERP 9 configuration file reside in this directory.
  • Language Directory: Tally.ERP 9 Language files (.dct) reside in this directory.
  • Enter the Name/IP address of the computer where License Server is installed in Name / IP field and enter the port number, you had noted earlier, in the Port field.
6. Click Next


The Country/Language Selection screen is displayed as shown:

7.   Check Install Operating System Language Support to install Tally.ERP 9 with multi-lingual support.
8.   In Country Selection choose India/SAARC when you are residing in India or SAARC countries else choose Others.
 To use Tally.ERP 9 in English onlyuncheck Install Operating Systems Language Support ƒàƒn In Country Selection choose India/SAARC, if you are residing in India or SAARC countries, else choose Others
9. Click Install
10. The Tally.ERP 9 Installed Successfully screen appears as shown:


11. Click Finish

How to Install Tally.ERP 9 Release 3.2 (Release 3.0 onwards) Multi User on Server machine or License Server?

How to Install Tally.ERP 9 Release 3.2 (Release 3.0 onwards) Multi User on Server machine or License Server?

Installing Tally.ERP 9 Multi-User/Gold is broadly classified into the following:
  • Installing Tally.ERP 9 on Server: Installs the License Service and Tally.ERP 9 on the computer designated as License Server.
  • Installing Tally.ERP 9 on Client: Installs Tally.ERP 9 only on a computer in the LAN. The user needs to provide the license server’s Name or IP Address and Port Number.
We will first look at installing components License Server and Tally.ERP 9 on the server.
To install Tally.ERP 9 on a computer with Windows XXXX operating system, it is essential that the user has administrator rights (create, write, update, modify & delete) for Application, Data, Configuration, License and Language Directories
Installing Tally.ERP 9 on Server
Method 1:
  • Double click the INSTALL.EXE icon available on the CD
Method 2 You can install both Tally.ERP 9 and License Server by using any one of the following methods:
  • Double click the INSTALL.EXE icon available on the CD Or
  • Click START from Windows
  • Select RUN
  • TYPE <CD drive>:\INSTALL
  • Press ENTER
Follow the instructions displayed on your screen to proceed with the Installation of Tally.ERP 9. The Tally.ERP 9 Setup Wizard is displayed as shown.

1. Click Next to continue with Installation.

The Tally.ERP 9 Setup screen is displayed as shown:



2. Select Multi User

3. Select Server Machine

The Tally.ERP 9 Setup screen is displayed as shown:

To install License Server only uncheck the option Tally.ERP 9.
The procedure to install Tally.ERP 9 is similar to Client installation
4. Click Next
The Tally.ERP 9 Setup screen is displayed as shown:

5. In the Tally License Server Configuration section accepts the default License Server DirectoryPort number and License Directory or specify the License Server DirectoryPort and License Directory of your choice.
6. Click Install
7.    On detecting earlier version(s) of License Server installed on your computer. The installer displays LicenseServers Installed.

8. Check the required version(s) of license server that needs to be uninstalled.
9. Click Install The Tally.ERP 9 Setup screen is displayed as shown:

10.  The Tally.ERP 9 Setup screen appears. In Tally.ERP 9 Configuration section accept the default directories or click on the buttons provided to change the path of Application DirectoryData DirectoryConfiguration DirectoryLanguage Directory or License Directory respectively.
  • Application DirectoryTally.ERP 9 program files reside in this directory.
  • Data DirectoryTally.ERP 9 data resides in this directory.
  • Configuration DirectoryTally.ERP 9 configuration file reside in this directory.
  • Language DirectoryTally.ERP 9 language files (.dct) reside in this directory.
  • License Directory: Tally.ERP 9 license file (.lic) resides in this directory.
10. Click Next.



11. In the Country/Language Selection screen, check Install Operating System Language Support to install Tally.ERP 9 with multi-lingual support.
12. In Country Selection choose India/SAARC when you are residing in India or SAARC countries else choose Others.
To use Tally.ERP 9 in English onlyuncheck Install Operating Systems Language Support
13. Click Install.
The Setup Status screen is displayed as shown:




When language support files are not available, installer prompts for language support files in the Files Needed screen. Insert operating systems CD in the drive or click Browse and select the i386 folder where the required language support files reside on your computer.
Click OK to install Language SupportClick Cancel when you do not have the operating system CD.
On detecting an active Windows firewall on the license server, the installer displays the following message.


14. Click Yes to allow the Tally License Server accept connections from its clients
15. On successful installation of Tally.ERP 9, the Tally.ERP 9 Installed Successfully screen will be displayed as shown:


How are Live Updates implemented in Tally.ERP 9 Multi User?

How are Live Updates implemented in Tally.ERP 9 Multi User ?

From Tally.ERP 9 Release 3.6, users are allowed to install and manage the product and stat updates, account TDLs, local TDLs, Tally Extensions, Add-ons, etc., all from a single place – Tally Live Updates.
Auto Update procedure in Release 3.6 & 3.61 (for Multi User)
  • When auto update is triggered using Install Now or Scheduler option all the clients in the LAN will upgrade or downgrade to the specified Release/Stat, if multiple releases among users is not chosen.
Auto Update procedure in Release 3.62 onwards (for Multi User)
  • When auto update was triggered using Install Now or Scheduler option all the clients in the LAN will upgrade or downgrade to the specified Release/Stat.
  • After update, user can manually install Release/Stat of his choice on any of the Client machine till the next update (done using auto update).
Note: If release/Stat is manually deployed in the Server, it will not affect the Client machines.

Sunday, December 23, 2012

How do I surrender Tally.ERP 9 license online from Tally.ERP 9?

How do I surrender Tally.ERP 9 license online from Tally.ERP 9?

From the Company Info Menu or Gateway of Tally, go to F12: Configure > Licensing > Surrender License 
The Administrator Login screen appears
  • Enter the required E-Mail ID in Your E-Mail ID
  • Enter the Tally.NET Password
On successfully surrendering the license, Tally.ERP 9 displays the message License Surrendered Successfully.

Detailed

You need to surrender the Tally.ERP 9 license in one of the following scenarios:

  1. Format hard disk
  2. Reinstall operating system
  3. Add new hardware or drivers
  4. Reactivate the same license on another computer 
To surrender the single site license, execute the following steps:  

  • From the Company Info menu or Gateway of Tally, press F12: Configure > Licensing
  • Select Surrender License
  

Tally.ERP 9 prompts you with a message as shown below:

  

  • Press Y or click on Yes
  • The Administrator Login screen appears, enter your E-Mail ID in the Your E-Mail ID field
  • Enter your Tally.NET password in the Your Tally.NET Password field
  

  • Press Y or click on Yes to surrender license
Tally.ERP 9 displays a message License Surrendered Successfully.

Note: In Tally.ERP 9 the License Surrender request can be made from the server or the client machine based on the requirement.

How to extract Tally.ERP 9 to Microsoft Excel 2007 using ODBC?

How to extract Tally.ERP 9 to Microsoft Excel 2007 using ODBC?


Tally ODBC helps you to extract the Data from Tally.ERP 9 and design the reports in MS Excel 2007. This can be done by following the steps listed below:

Step 1: Enable ODBC

  • Start Tally.ERP 9. It should be open till the process is complete.
  • Ensure that the ODBC Server is running. You can confirm this when the message Running as ODBC Server is displayed in the Configuration block of InformationPanel (at the bottom) of Tally.ERP 9 screen, as shown:
  

§         In case, the ODBC Server is not running, you can enable the ODBC Server by following the steps shown:
    • From Gateway of Tally or Company Info menu, press F12 Configure > Advanced Configuration
    • In the Client/Server Configuration screen, set Yes to Enable ODBC Server.
Step 2:
  • Start Microsoft Office 2007
  • Click Data
The sub options of Data menu appears as shown:

  

  • Click From Other sources
  • Select From Microsoft Query
Choose Data Source dialog box appears
  • Select TallyODBC
  

Tally.ERP 9 connects to data source and displays Query Wizard – Choose Columns dialog box.
  • Select the columns you would want to include in the query. Select Ledger and Click " >" button to the right of the following fields: (E.g. $Parent)
  

§         Click Next

The Query Wizard - Filter Data dialog box appears

  

§         Set the filter conditions in the Filter Data dialog box to limit the data to those that match your criteria.

  

§         Click Next

The Query Wizard - Sort Order dialog box appears

  

§         Sort the data in ascending or descending order as per the requirement
§         Click Next

The Query Wizard - Finish dialog box appears.

  

§         The option Return Data to Microsoft Office Excel will be selected, by default
§         Click Finish 

Once the Query Wizard process is complete, the dialogue box entitled Import Data appears.

  

§         Click OK 

The excel sheet will display the report as shown below:
  


Thursday, December 20, 2012

FAQs on FBT - Tally.ERP 9

FAQs on FBT - Tally.ERP 9  


Query
Does section 115WB create two classes of Fringe Benefits under sub-section (1) and (2), i.e., Fringe benefits and Deemed Fringe Benefits?


Answer
Section 115WB defines 'fringe benefits'. Sub-section (1) refers to the specific fringe benefits provided by the employer to employees directly, i.e:

1. Any privilege, service, facility or amenity, which is directly or indirectly made whether by way of reimbursement or otherwise provided by an employer to the employees (including former employee or employees).
2. Any free or concessional ticket provided by the employer for private journeys to employees or their family members.
3. Any contribution by the employer towards an approved superannuation fund for employees.
4. Any specified security or sweat equity shares allotted or transferred, directly or indirectly, by the employer free of cost or at concessional rate to his employees (including former employee or employees)
Sub -section (2) provides that fringe benefits shall be deemed to have been provided by the employer to his employees if the employer incurs any expense on or makes any payment for the purposes enumerated in clauses (A) to (P)

A. Entertainment
B. Hospitality
C. Conference
D. Sales promotion including publicity
E. Employees’ welfare
F. Conveyance
G. Hotel, boarding, lodging Repair, running and maintenance of cars and the amount of Depreciation thereon
H. Repair, running and maintenance of aircraft and amount of Depreciation thereon
I. Use of the telephone
J. Maintenance of any accommodation in the nature of guest house
K. Festival celebrations
L. Health Club/Any other club
M. Gifts
N. Scholarship to employees’ children
O. Tour and travel (including foreign travel)


Query

Does reimbursement of expenditure to an employee, which is purely of a business nature, be liable to FBT? (For example, the payment of sales tax or stamp duty paid on behalf of the employer and reimbursed later ).

Answer
The Reimbursement of expenditure to an employee is a Fringe Benefit provided within the framework of the clause (a) of sub-section (1) of section 115WB. However, the FBT is payable only with regard to reimbursements listed in clauses (A) to (P) of sub-section (2) of section 115WB and for which the computation is provided in section 115WC.

If the computation is not provided for the Fringe Benefit provided or deemed to have been provided, a benefit of that sort is not liable to FBT.


Query
Does section 115WB create two classes of Fringe Benefits under sub-section (1) and (2), i.e., Fringe benefits and Deemed Fringe Benefits?


Answer
Section 115WB defines 'fringe benefits'. Sub-section (1) refers to the specific fringe benefits provided by the employer to employees directly, i.e:

1. Any privilege, service, facility or amenity, which is directly or indirectly made whether by way of reimbursement or otherwise provided by an employer to the employees (including former employee or employees).

2. Any free or concessional ticket provided by the employer for private journeys to employees or their family members.
3. Any contribution by the employer towards an approved superannuation fund for employees.
4. Any specified security or sweat equity shares allotted or transferred, directly or indirectly, by the employer free of cost or at concessional rate to his employees (including former employee or employees)
Sub -section (2) provides that fringe benefits shall be deemed to have been provided by the employer to his employees if the employer incurs any expense on or makes any payment for the purposes enumerated in clauses (A) to (P)

A. Entertainment
B. Hospitality
C. Conference
D. Sales promotion including publicity
E. Employees’ welfare
F. Conveyance
G. Hotel, boarding, lodging Repair, running and maintenance of cars and the amount of Depreciation thereon
H. Repair, running and maintenance of aircraft and amount of Depreciation thereon
I. Use of the telephone
J. Maintenance of any accommodation in the nature of guest house
K. Festival celebrations
L. Health Club/Any other club
M. Gifts
N. Scholarship to employees’ children
O. Tour and travel (including foreign travel)

Query
Are expenses segregated into those incurred for official purposes and those for personal purposes?

Answer
Fringe benefit is deemed to have been provided if the employer has incurred expenses for any purpose referred to in sub-section (2) of section 115WB. A proportion (20% or 50% or 5% as the case may be) of all the expenses falling under the relevant head in sub-section (2) of section 115WB will be taken as the taxable value of the fringe benefits.

There is no requirement to segregate the various expenses referred to in section 115WB, in terms of expenses incurred for official purposes and those incurred for personal purposes.

Query
Is FBT payble on advances paid for expenses?

Answer
The FBT is liable to be paid only for the expenditure incurred and therefore is not applicable on advances.


Query
Is the gross or net expense considered for the purposes of FBT? For example, part of the expenses on various items like travel, may be recovered from the employees. Therefore, should FBT be levied on the 'gross' travel expenditure or on the 'net' travel expenditure'?


Answer
In cases where the employer recovers any amount of expenditure incurred by its employees against the purposes listed in clauses (A) to (P) of sub-section (2) of section 115WB, the value of the fringe benefits can be determined with reference to the net expenditure and not the gross expenditure.

For example, if an employer incurs a total expenditure of Rs 10 lakh on the repair, running and maintenance of motor-cars, and recovers Rs 1 lakh from its employees, the value of the fringe benefit with regard to the repair, running and maintenance of motor-cars will be calculated on the basis of the net expenditure of Rs 9 lakh (i.e., Rs 10 lakh minus Rs. 1 lakh).

Query
Would the contributions made to an approved gratuity or provident fund attract FBT?
Answer

Section 115WB read with section 115WC does not specifically contain any provision for contributions made to an approved gratuity or provident fund that could attract FBT. Therefore, any contribution made to either of these funds would not attract FBT.

Query
Are medical reimbursements upto Rs. 15,000 (exempt in the hands of the employees) and medical reimbursement over Rs. 15,000 (taxed as perquisite in the hands of the employee) liable to FBT?

Answer
At present, if any sum is paid by the employer for an expenditure actually incurred by the employee for medical treatment in an unapproved hospital and it exceeds Rs 15,000 during the year, such sum is considered as a 'salary' defined in clause (1) of section 17 of the Income-tax Act, and is therefore liable to income-tax in the hands of the employee.

There is no change in this position. Since such a sum is taxable in the hands of the employee, the same is not liable to FBT.

However, if a sum is paid by the employer for an expenditure that was actually incurred by the employee for medical treatment in an unapproved hospital and it does not exceed Rs 15,000 during the year, that sum does not fall within the meaning of 'salary as defined in clause (1) of section 17 of the Income-tax Act and is therefore not liable to income-tax in the hands of the employee.

There is no change in this position. Since such a sum is not taxable in the hands of the employee, the same is liable to FBT.

Query
Can the advance tax paid in excess for the preceding quarter be adjusted against the advance tax for the subsequent quarter(s)?

Answer
Yes, any advance tax paid in excess for the preceding quarter can be adjusted against the advance tax for the subsequent quarter(s).