Lesson 2 Fundamentals of Tally - Erp 9
Lesson 2 Fundamentals of Tally - Erp 9
Lesson 2 Fundamentals of Tally - Erp 9
co
.in
ec
Lesson Objectives
Salient Features of Tally.ERP 9
nf
ot
ev
is
ta
i
2.1 Introduction
.c
od
Tally.ERP 9 is the world's fastest and most powerful concurrent Multi-lingual business Accounting
and Inventory Management software. Tally.ERP 9, designed exclusively to meet the needs of
small and medium businesses, is a fully integrated, affordable and highly reliable software.
Tally.ERP 9 is easy to buy, quick to install, and easy to learn and use. Tally.ERP 9 is designed to
automate and integrate all your business operations, such as sales, finance, purchasing, inventory, and manufacturing. With Tally.ERP 9, accurate, up-todate business information is literally at
your fingertips anywhere. The powerful new features and blazing speed and power of Tally.ERP 9
combined with enhanced MIS, Multi-lingual, Data Synchronization and Remote capabilities help
you simplify all your business processes easily and cost-effectively.
11
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
.in
Integrated/ Non-integrated accounting and inventory: With Tally.ERP 9, the user is able
to choose between accounting and accounting with inventory. If accounting with inventory
is opted for, the user can choose whether it should be integrated or not.
co
Flexible and easy to use: Tally.ERP 9 is very flexible. It mimics the human thought process, which means that Tally.ERP 9 can adapt to any business need. Tally.ERP 9 users
need not change the way their business is run to adapt to the package.
ec
h.
Speed : Tally.ERP 9 provides the capability to generate instant and accurate reports, which
assists the management to take timely and correct decisions for the overall productivity and
growth of the company.
ot
Power : Tally.ERP 9 allows the user to maintain multiple companies and with unlimited levels of classification & grouping capabilities. It also allows drill downfacility from report level
to transaction level.
nf
Flexibility : Tally.ERP 9 provides flexiblity to generate instant reports for any given period
(month/year) or at any point of time besides providing the facility to toggle between
Accounting & Inventory reports of the same company or between companies.
ev
is
ta
i
od
Versatility: Tally.ERP 9 is suitable for a range of organisations, from small grocery stores
to large corporations with international locations and operations.
.c
Multi-platform availability: Tally.ERP 9 is available on Windows 95, 98, ME, 2000 and NT.
It runs on a single PC or on a network. On a network, it supports access via any
combination of platforms.
Online Help : The Tally.ERP 9 Online Help (Alt+H) provides instant assistance on basic
and advanced features or any other relevant topics of Tally.ERP 9.
12
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
Auditor's Edition : Tally.ERP 9 offers a special Auditors' Edition of Tally.ERP 9, which provides auditing and compliance capabilities exclusively for Chartered Accountants.
.in
BASIC ACCOUNTING
Stock categories
General ledgers
Multiple godowns
Panoramic view
h.
ec
ot
nf
Drill-down display
ev
is
ta
i
Database reporting
co
Complete book-keeping
Columnar reports
od
Bank reconciliation
ADVANCED ACCOUNTING
ADVANCED INVENTORY
Stock items classified as raw materials,
work-in-process, finished goods
Multi-currency
.c
Multiple companies
Memo vouchers
CENVAT support
Post-dated vouchers
Reorder levels
13
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
Percentage-based reporting
Ratio analysis
.in
co
h.
ot
ec
Payroll
ev
is
ta
i
nf
Simple and rapid installation: Tally.ERP 9 has a simple, menu-driven installation procedure. The user can install the program files on any drive if the hard disk has partitions. The
user can also specify the name and directory location of the program files. Tally.ERP 9
uses minimum hard disk space in the local drive. Its installation on the local disk takes just
a few seconds.
Unlimited multi-user support: A multi-user version of Tally.ERP 9 can be installed on a
network, having any number of computers with different operating systems such as Win 95,
98, NT, 2000, XP and Linux.
od
Internal backup/ restore: Tally.ERP 9 has an in-built, user-friendly backup and restore
option. It helps the user to take a backup of one or more companies or all companies, in a
single directory, in the local hard disk, or in any external media.
.c
Data reliability: Tally.ERP 9 offers reliable data. It uses a flexi-field, flexi-length, selfindexed, weighted file structure for an extremely compact and fast database. Tally.ERP 9 is
robust and even if there is a power failure or the computer is incorrectly shut down, data is
not lost. Tally.ERP 9 uses signalling quality data integrity checks, at regular levels, to
ensure the complete reliability of data.
User-defined security levels: Tally.ERP 9 offers high levels of security. Users can define
multiple levels of security according to their requirements. Every authorised user in the
company can have an individual password, with rights to use specific features only. The
user with the administrator level password will have full access and can set controls for
other users.
Data security: Tally.ERP 9s data integrity checks ensure that there are no external
changes to the data. Tally.ERP 9 also uses a binary encoding format of storage to prevent
devious grouping of information.
Tally audit: The Tally.ERP 9 audit feature provides the user with administrator rights and
the capability to check the entries made by the authorised users and alter these entries, if
necessary. Once the entries are audited, Tally.ERP 9 displays the altered entries, if any,
14
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
along with the name of the user, who has altered the entry, and the date and time of the
alteration.
TallyVault: Tally.ERP 9 offers a data encryption option called TallyVault. Without the valid
TallyVault password, the data cannot be accessed. Tally.ERP 9 follows the DES (Data
Encryption Standard) encryption method to safeguard the data.
h.
co
.in
Removal of data into a separate company: Tally.ERP 9 allows users to maintain a company for any number of financial years. Once the books of accounts have been completed
for the earlier financial years, the user can split the company data into multiple companies
as per financial periods required. Tally.ERP 9 also has a feature to split company data. The
user can specify the date from which the company has to be split and Tally.ERP 9 will split
the company to form two companies as per periods specified. Once the data has been
split, the closing balance of the first period (first company) becomes the opening balance
for the next period (second company).
ot
ec
Multi-directory for company management: The user can create multiple directories to
store data. The data stored in these directories can be accessed directly in Tally.ERP 9, by
specifying the path.
ev
is
ta
i
nf
Import/ Export of data: Any transaction can be exported and imported to other software
after suitably altering the current structures to accept the Tally.ERP 9 data structure. Data
can also be imported to Tally.ERP 9 by writing a TDL program. The data which is to be
exported from Tally.ERP 9 can be in XML, HTML or ASCII format.
Tally.ERP 9 Synchronization: Synchronization is the process of exchanging Tally.ERP 9
data between two or more locations. This process enables a branch office to send its data
to the head office, over the Internet or a private network.
od
Graphical analysis of data: Tally.ERP 9 provides graphical analysis of data which helps
the user to perform deeper analysis. The user can generate graphical analysis reports such
as Sales register, Purchase register, Ledgers, Funds flow, Cash flow, Stock Item registers
and so on. This helps the management to quickly judge performance and be better prepared for difficult times.
.c
ODBC (Open Database Connectivity) compliance: It allows other programs to use data
from Tally.ERP 9, directly. Thus, any program such as MS-Excel or Oracle, which is ODBC
compliant, can use data from Tally.ERP 9. Data connectivity is dynamic, which means that
any update in Tally.ERP 9 is reflected in real time in other ODBC compliant software. The
user can also extract data from Tally.ERP 9 and design his/ her own report formats in other
ODBC compliant software.
Protocol support: Tally.ERP 9 provides protocol support for HTTP, HTTPS, FTP, SMTP,
ODBC and raw sockets with data interchange formats such as XML, HTML with XML
islands, SOAP and related formats. Protocol refers to a mechanism by which information
(data) can be put into or taken from Tally.ERP 9. Formats refer to the standard for information to be generated from Tally.ERP 9 or from other applications which can exchange data
with Tally.ERP 9.
Direct web browser access: While working on Tally.ERP 9, the user can directly log on to
the Tally website, provided he/ she has access to the Internet. The website lists details of
all the facilities offered by Tally.ERP 9. The user can also download the latest release of
15
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
Tally.ERP 9 as and when it is available. The Tally website also offers Tally Chat, by which a
user can communicate with a Tally representative and get required information.
Ability to preview and publish reports and documents on the Internet: Companies
which want to publish reports and price lists on their website can do so directly from
Tally.ERP 9.
.in
E-mail Facility: Tally.ERP 9 facilitates the mailing of any Tally.ERP 9 report or document.
ec
h.
co
Multilingual capability: Tally is the world's first accounting and inventory software with
multilingual capability. Currently, Tally.ERP 9s multilingual capability extends to 12 languages which include nine Indian languages (Hindi, Gujarati, Punjabi, Tamil, Telugu, Marathi, Kannada, Malayalam and Bengali), Bahasa Melayu and Bahasa Indonesia. Tally.ERP
9 enables you to enter data in one language and have it transliterated into different languages. You can generate invoices, purchase orders or delivery notes in the language of
your choice after entering data for the same in any of the nine specified languages. Also,
the phonetic keyboard allows you to spell the term phonetically based on how it sounds
and Tally.ERP 9 displays the data in the language selected after transliteration.
ev
is
ta
i
nf
ot
Point of Sale (POS) : POS is an acronym for Point of sale. Point of Sale can be a retail outlet, a check out counter ina shop, or any other location where a sales transaction takes
place. It is a computorised cash register which adds up the sales totals, calcutates the balance to be returned to buyer and automatically adjusts the inventory level to reflect the
quantity sold. The equipment required for POS to work effectively are cash registers, card
readers, bar-code scanners and so on.
2.1.4 Payroll
.c
od
Tally.ERP 9 Payroll is integrated with Accounting and benefits the user by simplifying Payroll
processing and accounting. Tally.ERP 9 Payroll enables users to set up and implement salary
structures, ranging from simple to complex, as per the organisations requirements. The user can
also align and automate payroll processes and directly integrate them with main stream accounting applications. Tally.ERP 9 Payroll also supports configurable formats for payslip printing;
flexible salary/wage, attendance, leave and overtime registers; gratuity and expat reports.
Tally.ERP 9 has the ideal solution for those who have their data in Tally 7.2 and now want to use
Tally.ERP 9. Tally.ERP 9 provides a migration tool which helps the user to migrate the data easily
to the latest version and continue with day-to-day transactions. Tally 6.3 users can also use the
migration tool which will rewrite the version to Tally 7.2 and then migrate the data to Tally.ERP 9.
Tally 8.1 users and Tally 9 Release 2.14 users can rewrite the version of their data to Tally.ERP 9.
16
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
.in
co
TCS enabled with e-TCS capability, with facility for printing certificates/ challans
Quarterly Return Form II, in the case of Excise Dealer
nf
ot
ec
h.
ev
is
ta
i
Click on Start > Programs > Tally.ERP 9 > Tally.ERP 9 or double click on the Tally.ERP 9
icon on your desktop
The welcome screen Tally.ERP 9 Power of Simplicity appears while the software loads. You
will be ready to explore Tally.ERP 9, the moment the Tally.ERP 9 start up screen appears.
.c
od
17
www.codevistainotech.co.in
.c
od
ev
is
ta
i
nf
ot
ec
h.
co
.in
Fundamentals of Tally.ERP 9
18
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
Gateway of Tally: Displays menus, screens, reports and accepts the choices and options
which you select to view data as required.
Buttons toolbar: Displays buttons which provide quick interaction with Tally.ERP 9. Only
buttons relevant to the current task are visible.
Calculator Area: Used for Calculator functions.
h.
co
.in
Particulars
ec
Action
Double-click
Choose
Select
Position the mouse pointer on the item and doubleclick the left mouse button.
ev
is
ta
i
nf
ot
Click
Press
Fn
Fn
od
Fn
.c
When Tally.ERP 9 first loads, the Gateway of Tally screen displays. To toggle between this
screen and the Calculator/ ODBC server area at the bottom of the screen, press Ctrl+N or Ctrl+M
as indicated on the screen. A green bar highlights the active area of the screen.
19
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
.in
co
.c
od
ev
is
ta
i
nf
ot
ec
h.
Each field in the Company Creation screen is explained below. To navigate between the fields,
use the enter key or the tab key or arrow keys or the mouse.
Fields
Directory
Description
Tally.ERP 9 assumes that the company is to be created in the data
path given in the Tally.INI file, which is displayed by default. This
field is skipped by default. However, you can change this path, if you
want to, by using the backspace key, so that Tally.ERP 9 saves the
data to a different directory specified by you.
20
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
Mailing Name
Address
The address of the company (The mailing name and address details
are picked from here for any report such as balance sheet and
statement of accounts).
Statutory Compliance
for
State
Pin Code
Telephone No.
E- Mail
Mobile No.
Currency Symbol
Maintain
ev
is
ta
i
nf
ot
ec
h.
co
.in
Name
This refers to the currency symbol Tally.ERP 9 will use for monetary
values. By default, Tally.ERP 9 displays Rs.
od
.c
Books Beginning
From
TallyVault Password
21
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
.in
Tally.ERP 9 will automatically adjust the spacing between the characters and lines entered to ensure that the details fit the space available.
co
ec
h.
ot
Tally.ERP 9 needs to know the default currency for the company and how the amounts should be
shown on the screen and in the reports.
nf
Formal name
ev
is
ta
i
Description
od
Enter the decimal portion for the currency mentioned. Enter Paise.
.c
22
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
.in
Base Currency Information is set to the default values as given in the Table.
However, if the Multi-currency feature of Tally.ERP 9 is activated - then
Tally.ERP 9 allows the user to alter the Base Currency Information as
required.
h.
co
Let us create a company in Tally.ERP 9 taking the example of National Traders who purchases
computer equipments, components and softwares and sells it to other companies and to the direct
customers. Create a Company as per information provided below :
Data to be entered
ot
Field
ec
National Traders
nf
Name
National Traders
ev
is
ta
i
Mailing Name
Address
No 24, Phase 1,
India
State
Karnataka
Pin Code
od
.c
Telephone No
Mobile No.
Currency Symbol
560089
080 - 41237890
9845293752
[email protected]
Rs.
Maintain
1 April 2009
1 April 2009
No
Formal name
Indian Rupees
23
www.codevistainotech.co.in
No
No
Yes
.in
Fundamentals of Tally.ERP 9
od
ev
is
ta
i
nf
ot
ec
h.
co
.c
24
www.codevistainotech.co.in
ev
is
ta
i
nf
ot
ec
h.
co
.in
Fundamentals of Tally.ERP 9
.c
od
For a group of companies, you can maintain the details of each company separately. You can
select the company to work with and close the company when it is not required. However, you can
also open many companies at the same time and switch between companies without closing the
application.
Before looking at how to view and amend company details, let us create another company to
experiment with. Name your company as Indus Enterprises, Financial Year as 1 April 2009 &
Book beginning from 1 April 2009 and you may enter the company details as you like,
To create Indus Enterprises follow this procedure:
1. From the buttons bar select Alt + F3: Create Cmp or simply press Alt + F3 to bring up the
Company Info. Menu.
2. Select Create Company from the menu to bring up the Company Creation screen.
3. Enter Indus Enterprises in the Name field and experiment with entering other data of your
choice (for example, the address details).
4. When you have finished, Press Y or Enter to accept the screen
25
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
ev
is
ta
i
nf
ot
ec
h.
co
.in
Figure 2.5 Gateway of Tally with the New Company Indus Enterprises
od
Notice that Indus Enterprises is highlighted. This indicates that it is the currently selected
company from the list of open companies.
While working with Tally.ERP 9, you can press Esc to exit from any screen
before the changes you have made take effect.
.c
You can now practice selecting, closing and altering company information.
Practice Exercise
1. Select a Company
2. Shut a Company
3. Alter a Company
26
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
To Select a Company
.in
1. Go to the Gateway of Tally > Alt + F3 > Company Info. > Select Company OR Press F1.
Tally.ERP 9 displays the List of Companies screen. All the companies created are displayed
in an alphabetical order. Select the company name from the list given.
2. In case two or more companies are loaded (like National Traders and Indus Enterprises), click
on the company which you need to work on so that the selected company will be highlighted
and will appear on top of the list.
co
To Shut a Company
ec
h.
Go to the Gateway of Tally > Alt + F3 > Company Info. > Shut Company. Select the Company
which you need to shut from the List of Companies. You can also use Alt + F1 to shut a
Company from the Gateway of Tally screen.
To Alter Company Details
ev
is
ta
i
nf
ot
Go to the Gateway of Tally > Alt + F3 > Company Info. > Alter. Select the company which you
need to alter from the List of Companies and press Enter to view the Company Alteration
screen. Alter the company details as required and accept the screen.
.c
od
You can also access these functions, by selecting the appropriate button
from the button bar.
27
www.codevistainotech.co.in
Fundamentals of Tally.ERP 9
Points to Remember
Tally.ERP 9 pioneered the no accounting codes concept.
.in
co
.c
od
ev
is
ta
i
nf
ot
ec
h.
28
www.codevistainotech.co.in