M.
COM
TALLY LAB
PROGRAM NO.1: Creating Company, Groups, Ledgers and Using Voucher.
Getting Functional with [Link] 9:
Power of Simplicity appears while the software loads. You will be ready to explore [Link] 9, the
moment the
Tally Start-Up.
[Link] 9 can be started in any of the following ways :
Click on Start > Programs > [Link] 9 > [Link] 9 or double click on the [Link] 9 icon
on your desktop. The welcome screen [Link] 9 [Link] 9 start up screen appears.
Sections of Gateway of [Link] 9:
Tally Screen Components.
The [Link] 9 Start-up Screen appears as shown below:
Title bar: Displays the [Link] 9 version number.
Horizontal button bar: Selection of Language key, Keyboard Language and [Link] 9 Help.
Close button: Performs the standard Windows Operating Systems function (Windows 95
onwards), allowing you to minimise [Link] 9 and work on other applications. To restore
[Link] 9, click the [Link] 9 icon on the taskbar.
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 [Link] 9. Only
buttons relevant to the current task are visible.
Calculator Area: Used for Calculator functions.
Info Panel: Displays Version number, License details, Configuration details.
7.3 Mouse / Keyboard Conventions.
While working with [Link] 9, use the following conventions
MOUSE/ KEYBOARD CONVENTIONS
Action Particulars
Click Press the left mouse button.
Press and release the left mouse button twice,
Double-click
without moving the mouse pointer off the item.
Position the mouse pointer on the item and click the
Choose
left mouse button.
Position the mouse pointer on the item and double-
Select
click the left mouse button.
Use the keys on the keyboard in the combination
Press
shown.
Fn Press the function key.
Fn Press ALT + function key.
Fn Press CTRL + function key.
Switching between Screen Areas
When [Link] 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.
ou can exit the program from any [Link] 9 screen, but [Link] 9 requires all screens to be
closed before it shuts down.
To quit working on [Link] 9,
Press Esc until you see the message Quit? Yes or No ? Press Enter or Y, or click Yes to quit
[Link] 9.
Alternatively, to exit without confirmation, press Ctrl+Q from Gateway of Tally.
You can also press Enter while the option Quit is selected from Gateway of Tally.
Creation of Company in [Link] 9/Company info:
Company Creation:
Creating a Company involves providing basic information about the company whose books of
accounts are to be maintained in [Link] 9.
Go to Gateway of Tally > (Alt+F3) Company Info. > Create Company
The Company Creation screen appears as shown.
Opening (Loading ) of Tally:
On double-clicking the Tally icon, the screen is displayed as shown:
You can use the Select Company option in two ways, from the Company Info. Menu OR by using
the button F1: Select Cmp (available on the Gateway of Tally screen).
Select Company
Select Company option allows you to load another company from the list of companies listed
which you may have created earlier.
Press Enter on Select Company or use the button F1: Select Cmp. [Link] 9 displays the following
screen:
[Link] 9 displays
Company Name (All the companies created are displayed in an alphabetical order)
System-generated code for each company displayed
The Financial Year information relating to the number of years data present in the company
Note: The system-generated code for each company is displayed to assist you in identifying which
company you wish to work on in case you have multiple companies with the same name (as
displayed in the above screen).
Select the required company from the list given to go to the Gateway of Tally for that company.
In case two or more companies are loaded , 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.
Gateway of Tally Screen:
The Gateway of Tally menu of an Accounts Only company appears as shown below:
The Gateway of Tally screen is separated into 2 sections Main Area (Ctrl+M) and the Button Bar.
Main Area
The left side of the Main Area gives information on:
Current Period :which is the currently loaded company's accounting period.
Current Date : This is the date of the last Voucher Entry for the selected company.
List of Selected Companies: This displays the name of the loaded company.
The Main Area gives information on:
Creation of Accounting Masters and Importing Master information
Creation of Accounting Vouchers and Importing transaction information
Viewing and printing financial reports using the information given in Masters and
Transactions
Button Bar:
The Button Bar Contains two sections:
Top Button Bar
Right Side Button Bar
Top Button Bar Contains:
Print Alt +P Navigate to Print Menu.
Export Alt +E As it is not used from Main Screen, these buttons are disabled.
E-Mail Alt+M As it is not used from Main Screen, these buttons are disabled
Upload Alt+O As it is not used from Main Screen, these buttons are disabled
Language Alt+G To Change the Language.
Keyboard Excise To Change the Keyboard Language
Control Centre Excise Login to Control Centre.
Support Excise To Post the queries of the product.
Centre
Right side Button Bar contains:
Select F1 To select a company.
Company
Shut Company Alt+F To shut or close the Company.
1
Date F2 To change the Current date.
Period Alt+F To change the Period.
2
Company F3 To select a different Company which is already loaded.( If one company
is Loaded inGateway of Tally, this button is disabled)
Company Info Alt+f3 To access the Company info. Menu.
Features F11 To access the Company features for a company
Configurations F12 To access the configuration settings.
Meaning of a Group:
Groups are collection of Ledgers of the same nature. Account Groups are
maintained to determine the hierarchy of Ledger Accounts which is helpful in
determining and presenting meaningful and compliant reports.
[Link] 9 has the flexibility of setting user required chart of accounts. You can
group the Ledger accounts under the required Groups at the time of creating the
chart of accounts or you can alter them at any time.
The Group behavior is classified into Capital or Revenue and more specifically into
Assets, Liabilities, Income and Expenditure. The Groups ascertain whether the same
will affect Profit and Loss Account which is revenue in nature or Balance Sheet which
is capital in nature.
15 Primary Groups 13 Sub Groups
Branch/Divisions Bank Accouts.
Capital Account Bank Od A/c
Current Assets Cash-in-hand.
Current Liabilities Deposits (Assests)
Direct Expenses Duties and Taxes.
Direct Incomes Loans and advances(Asset).
Fixed Assets Provisions.
Indirect Expenses Reserves and Surplus.
Indirect Incomes Secured Loans.
Investments Stock-in-hand.
Loans(Liability) Sundry Creditors.
Misc. Expenses(Asset) Sundry Debtors.
Purchases Accounts Unsecured Loans.
Sales Accounts
Suspense A/c.
Pre-defined Sub Groups: Under
Bank Accounts Current Assets.
Bank OD a/c Loans (Liability)
Cash in hand Current Assets
Deposits(Asset) Current Assets
Duties and Taxes Current Liabilities
Loans and Advances(Asset) Current Assets
Provisions Current Liabilities
Reserves and Surplus Capital Account
Secured Loans Loans(Liability)
Stock in Hand Current Assets
Sundry Creditors Current Liabilities
Sundry Debtors Current Assets
Unsecured Loans Loans(Liability)
Creating Group:
In [Link] 9 there are two options for creating Groups:
Single Group : We can create only one Group by using Single Group creation
screen.
Multiple Groups: We can create multiple Groups by using Multiple Group
Creation screen.
Creating a Single Group:
Group is a collection of Ledgers of the same nature, [Link] 9 allows you to create
groups as per your requirements.
Go to Gateway of Tally > Accounts Info. > Groups > Create under Single Group
Meaning of a Ledger:
A Ledger is the actual account head to which you identify a transaction and must be
used in all Accounting Vouchers. Without a ledger we cannot record any
transactions.
Ex: Purchase, payments, sales, Receipts, etc, all these accounts heads are ledger
Accounts.
All Ledgers have to be classified into Groups. Classification of Ledgers to the
appropriate groups is very important. These Groups and Ledgers are classified to
Profit & Loss or Balance Sheet. The creation and usage of Groups in [Link] 9 has
been explained earlier. Now you will learn how [Link] 9 works with Ledgers.
Creating a Single Ledger.
By default, [Link] 9 contains two Ledger accounts namely, Cash (Under Cash-in- Hand) and
Profit and Loss Account (direct Primary Account). You need to create all other accounts heads.
There are no restrictions in Ledger creation except that you cannot create another Profit & Loss
A/c. Any number of Cash Accounts may be created in any other name for ex: Petty Cash.
Go to Gateway of Tally > Accounts Info > Ledgers > Create
The creation of a Ledger depends on the features you have selected under F11: Features of your
company and F12: Configure. You can create a single ledger account with the default options
enabled.
Go to Gateway of Tally > Accounts Info > Ledgers > Single Ledger > Create
Name
Enter the Name of the account. You can provide the full name of the account. [Link] 9 fits it all
in. Press Enter to move to the next field. [Link] 9 does not allow the entry of duplicate names.
The uniqueness check is made here itself.
Note that the punctuation and other non-relevant information are ignored by [Link] 9 in its
recognition of a name. Thus, CST, C.S.T. and C. S. T. are all considered as same.
[Link] 9 converts the first letter of all relevant words to upper case, which helps you; speed up
data entry.
Alias
Enter an alias name if required. You can access the Ledgers using the original name or the alias
name.
Under
All accounts must be classified under their appropriate Groups. Select the Group under which the
Ledger is created from the List of Groups. (To create a new Group from this field press [ALT + C]). A
wrong classification would affect the treatment of the Ledger account in final statements and
during voucher entry.
You can, alter a Ledger account to change its group classification at any time. Refer Importance of
Grouping and Accounting Classifications: for more details in Grouping
Opening Balance
If yours is an existing company whose books you are entering into [Link] 9, Opening Balance
would be applicable in circumstances where the Ledger is an asset or a liability and if it has a
balance in the account as on the date of beginning of books in [Link] 9.
[Link] 9 recognizes normal accounting principles of debit balances for Assets and credit
balances for Liabilities. It accepts the reverse for obverse balances. Revenue accounts normally do
not have balances. [Link] 9, however, permits you to give balances even for such accounts - You
may be transferring your books on to [Link] 9 in the middle of the year and may not have
closed them in your earlier system. Hence, you may specify whether the balance is Debit or Credit.
Simply D or C would suffice.
Types of Vouchers:
Pre-defined Vouchers in [Link] 9:
Tally comprises of the following predefined Vouchers, to suit different business
requirements for recording various transactions. Tally also allows you to create user-defined
Vouchers (Voucher Types) as per your requirements.
Contra Voucher.
Payment Voucher.
Receipt Voucher.
Journal voucher.
Sales Voucher / Invoice.
Debit Note Voucher.
Credit Note Voucher.
Purchase Voucher / Invoice.
Memorandum
Reversing Journal
PROGRAM NO.2: Creating Stock Groups, Categories, Units, Godowns and Stock
Item.
Stock Groups:
Creating a Single Stock Group:
Stock Groups in Inventory are similar to Groups in Accounting Masters. They are helpful in the
classification of Stock Items.
You can group Stock Items under different Stock Groups to reflect their classification based on
some common features such as brand name, product type, quality, etc.
Grouping enables you to locate Stock Items easily and report their details in statements.
Go to Gateway of Tally > Inventory Info. > Stock Groups
Stock Items are classified into stock groups to reflect their classification based on some
community.
To create a Stock Group,
Go to Gateway of Tally > Inventory Info. > Stock Groups > Create (under Single Stock Group)
A brief description on each of the fields in the Stock Group Creation screen follows:
Name
Enter the name of the Stock Group to be created. For example, Grade One.
Alias
Enter additional name apart from primary name [if required]. You can create any number of
additional names.
Under
Specify whether it is a primary group or a sub-group of another group, by selecting from the list.
Press Alt+C to create a parent group, if you do not have it in the list.
Can quantities of items be ADDED?
This field pertains to information on measuring the units of the Stock Items that you would
categorise under the Stock Group.
The Stock Items categorised under the group should have similar units for them to be added up.
You cannot add quantities in Kgs to quantities in Pcs.
Stock Categories:
Stock Category offers a parallel classification of stock items. Like stock Groups, classification is
done based on similarity in behaviour.
The advantage of Categorizing items is that you can classify the stock items (based on
functionality) together across different stock groups which enables you to obtain reports on
alternatives or substitutes for a stock item.
For enabling Stock Category option in the Inventory Info menu, press F11 > Inventory Features >
Set Yes for Maintain Stock Categories.
Go to Gateway of Tally > Inventory Info. > Stock Category
Creating a Single Stock Category:
This option allows parallel classification of stock items. Like Stock Groups, Stock Categories are also
classified based on some similar behavior.
This enables you to obtain reports for alternatives or substitutes of a stock item.
To create a Stock Categories,
Go to Gateway of Tally > Inventory Info. > Stock Categories > Create (under Single Stock Category)
The Stock Category Creation screen is displayed as shown.
A brief description of each field in the Stock Category Creation screen is given below:
Name
Enter the name of the Stock Category.
Under
Specify whether it is a primary category or a sub-category of another category. Select Primary from
the list, if you do not have a parent group. Use ALT + C to create a parent if you do not have the
required category in the list.
Units:
Stock Items are mainly purchased and sold on the basis of quantity. The quantity in turn is
measured by units. In such cases, it is necessary to create the Unit of Measure. The Units of
Measure can either be simple or compound. Examples of simple units are: nos., metres, kilograms,
pieces etc.
To create Simple Units of Measure,
Go to Gateway of Tally > Inventory Info > Units of Measure > Create
The Unit Creation screen is displayed as shown.
A brief explanation of each field in the Unit Creation screen is given below:
Type
This field will show the Type of Units.
Simple
Compound.
Simple units are nos, pcs, etc. Compound unit is a combination of two simple units.
By default [Link] 9 will show the Simple unit for creating the unit of measure.
You can select the Compound Units by clicking on that field or by using SHIFT+TAB [cursor will go
to the previous field].
Creation of Compound Units.
A Compound Unit is a relation between two Simple Units. Hence, before you create a Compound
Unit, ensure that you have already created two Simple Units.
Example:
To Create Compound unit Doz (Dozen) of 12 Nos (Numbers), you have to create two simple units,
Doz (Dozen) and Nos (Numbers) and set the conversion factor as 12.
Go to Gateway of Tally > Inventory Info > Units of Measure > Create
The Unit Creation screen is displayed as shown. Now Click on Type field or Press SHIFT + TAB or
Press Backspace Key.
Select Compound from the Types of Units and press Enter. The Conversion field will be displayed
for creating Compound unit.
Field Information:
First unit: Select the First unit from the Units List. In the above example, Dozen will be the First
Unit.
Conversion: Specify the conversion Factor. In the above example, Conversion factor will be 12.
Second Unit: Specify the Second Unit from the Units List. In the above example, Number will be
the Second Unit. This unit is also called Tail Unit.
Creating of Godowns:
To create a Location/Godown,
Go to Gateway of Tally > Inventory Info. > Locations/Godowns > Create (under Single Godown)
The Location/Godown Creation screen is displayed as shown:
A brief explanation of each field in the Location/Godown Creation screen is given below:
Name
Specify the name of the Location/Godown.
Alias
Enter an alias name for the Location/Godown name, if required.
Under
Specify the Location/Godown under which the Location/Godown is to be categorised. Use Alt + C
to create the parent Location/Godown if it is not in the list. Select Primary, if it is not a sub
Location/Godown of any Location/Godown.
Use for
This section is provided in [Link] 9 Release 3.0 where users can create the godowns to store:
The stock of the company lying with third party like Consignment Agent, Bonded Ware house, Job
worker, etc.
Creation of Single Stock Item.
To create a Stock Item, Go to Gateway of Tally > Inventory Info > Stock Item > Single Create (under
Single Stock Item)Stock Item creation is displayed as shown:
A brief description of each field in the Stock Item Creation screen follows:
Name
Specify the name of the Stock Item.
Alias
Specify the Alias name of Stock Item (if required).
Under
This field will show the List of Groups. Here you can select the Stock Group to which the Stock Item
belongs. By default, Primary Stock Group appears in this field.
Note: You can create a new stock Group by pressing ALT+C at this field.
Units
This field will show the Unit List. Here you can select the Unit of measurement applicable for the
stock item. By default, Not Applicable appears in this field.
Note: You can create a new Unit by pressing ALT+C at this field.
Rate of duty
Specify the Rate of Duty applicable for the stock item. This field is used for the calculation of excise
duty or if duty is based on item rate. During Invoicing, whenever you select a Stock Item, the Rate
of duty entered here is displayed in the Invoice creation screen.
PROGRAM No.3: Calculation of SGST,CGST and IGST using Tally
CGST - Centre Goods and Service Tax SGST
– State Goods and Service Tax IGST –
Integrated Goods and Service Tax GST
Rates :
1. Nil
2. 5%
3. 12%
4. 18%
5. 28%
Create New Company :
ACTIVATE GST
Taxation
Enable Goods and Service Tax (GST): Yes
GST Details
State : KARNATAKA
Reg Type : Regular
GSTIN : 29AABCU9603R1ZL
Periodicity : Monthly
Accept GST details and Accept Statutory and Taxation
CREATE LEDGERS FOR GST:
Gateway of Tally > Create > Ledgers
CGST
Name : CGST
Under : Duties and Taxes
Type of Tax : GST
Tax Type : Central Tax
SGST
Name :SGST
Under : Duties and Taxes
Type of Tax : GST
Tax Type : State Tax
IGST
Name :IGST
Under : Duties and Taxes
Type of Tax : GST
Tax Type : Integrated Tax
Purchase
Under : Purchase Account
GST Details : Applicable
Type of Supply : Goods
Sales
Under :Sales Account
GST Details : Applicable
Type of Supply : Goods
SBI Bank
Under : Bank Account
LEDGER FOR PURCHASE PARTY
Super Computer Store
Under : Sundry Creditors
State : Karnataka
Reg Type : Regular
GSTIN : 29AABCD1203R1ZL
Set Alt GST details : No
Delhi Computer Traders
Under : Sundry Creditors
State : Delhi
Reg Type : Regular
GSTIN : 09AABCD1203R1ZL
Set Alt GST details : No
LEDGER FOR SALES PARTY
Sudhir Saini
Under : Sundry Debtors
Set Alt GST details : No
State : Karnataka
Sanju Rawat
Under : Sundry Debtors
Set Alt GST details : No
State : Karnataka
STOCK GROUP CREATION
Gateway of Tally> Create > Stock Group
Computer Parts
Under : Primary
Set / Alt GST : No
Note: If all the items of a group have same GST rate, than GST rates can be set for groups. But for
training purpose, we will set GST rate for each individual items.
CREATE UNIT
Symbol : Pcs
Name : Pieces
No. of Decimal Places: 2
CREATE STOCK ITEMS WITH GST
Keyboard –Dell
Under : Computer Parts
Unit : Pcs
GST : Applicable
Set/Alter GST : Yes
Calculation Type : On Value
Taxability : Taxable
Tax Type : Integrated : 18%
Type of Supply : Goods
Keyboard – HP
Under : Computer Parts
Unit : Pcs
GST : Applicable
Set/Alter GST : Yes
Calculation Type : On Value
Taxability : Taxable
Tax Type : Integrated : 18%
Type of Supply : Goods
Mouse (Normal)
Under : Computer Parts
Unit : Pcs
GST : Applicable
Set/Alter GST : Yes
Calculation Type : On Value
Taxability : Taxable
Tax Type : Integrated : 18%
Type of Supply : Goods
Mouse (Cordless)
Under : Computer Parts
Unit : Pcs
GST : Applicable
Set/Alter GST : Yes
Calculation Type : On Value
Taxability : Taxable
Tax Type : Integrated : 18%
Type of Supply : Goods
PURCHASE THE ITEMS
Purchase with in State:
Our company is Registered in Uttar Pradesh and supplier Super Computer Store is also from Uttar
Pradesh (Same State). Therefore, CGST and SGST are applicable.
Gateway of Tally > Voucher> F9 (Purchase)
Party Account : Super Computer Store
Keyboard – Dell 2 Pcs 220 440
Keyboard – HP 1 Pcs 450 450
Mouse – Normal 2 Pcs 150 300
Mouse – Cordless 1 Pcs 250 250
Total 1440
CGST 129.60
SGST 129.60
Enter and Accept
Check GST :Our company and Purchase Party Super Computer Ltd is registered in same state
(Karnataka). Therefore, CGST and SGST are shown in the voucher.
Purchase from Other State : IGST Applicable Gateway of Tally > Voucher> F9
(Purchase) Party Account: Delhi Computer Traders
Keyboard – HP 50 Pcs 400
Mouse – Normal 50 Pcs 140
Mouse – Cordless 50 Pcs 250
Total 39500
IGST 7110
150 Pcs 46610.00
Enter and Accept
Sales the Items: With in State : CGST and SGST Applicable
GOT > Account Voucher > F8
(Sales) Party Account : Sudhir Saini
Sales Ledger : Sales
Keyboard – Dell 2 Pcs 300 600
Keyboard – HP 1 Pcs 500 500
Mouse – Normal 1 Pcs 300 300
Mouse – Wireless 1 Pcs 500 500
Total 1900
CGST 171
SGST 171
SALES THE ITEMS: OTHER STATE : CGST AND SGST APPLICABLE
GOT > Account Voucher > F8 (Sales)
Party Account :Sanju Rawat
Sales Ledger : Sale
Keyboard – HP 50 Pcs 500 25000
Mouse – Normal 51 Pcs 300 15300
Mouse – Wireless 49 Pcs 500 24500
Total 64800
IGST 11664
Total 76464
Check Reports
Display More Report > Statement of Accounts > Outstanding > Receivable/ Payables Balance Sheet
Balance Sheet > Current Liabilities Duties and Taxes : 4636.80
CGST : 41.40
IGST : 4554.00
SGST : 41.40
Check Balance Sheet > Current Liabilities > Duties and Taxes
MAKE PAYMENT TO SUPPLIER
Gateway of Tally > Voucher > F5 (Payment)
Dr Super Computer Store 1699.20
Cr Cash 1699.20
Accept
Dr Delhi Computer Traders 46610
Cr Cash 46610
Accept
Pay GST and Update in Tally
Gateway of Tally >Vouchers >Payment (F5)
Account -SBI Bank
Dr CGST : 41.40
Dr SGST : 41.40
Dr IGST : 4554.00
4636.80
Mode of Payment : Net banking Name of Bank : SBI
PROGRAM No. 4: Preparation of Invoice, Payroll and displaying various Financial and Inventory
Reports.
CREATE A NEW COMPANY :
F3 : Company > Create
F11: Company Features > Payroll
Maintain Payroll : Yes
ADD CAPITAL IN COMPANY
F6 (Receipt ) Add Capital of 10,0000 Dr
Cr Capital (under Capital Account)
Dr Cash
CREATE EMPLOYEES GROUP
Gateway of Tally > Create > Payroll Masters > Employees Group
Group Under Define Salary Details
Marketing Primary No
Sales Primary No
Account Primary No
HR Primary No
CREATE UNITS (WORK)
Gateway of Tally > Create > Payroll Masters > Units (works)
Unit Type Symbol Name
Simple Hrs Hours
Simple Days Number of Days
Compound First Unit : Days, Conversion -8, Second unit : Hrs
CREATE ATTENDANCE / PRODUCTION TYPE
Gateway of Tally > Create > Payroll Masters > Attendance/ Production Type
Name Under Attendance Type Unit
Present Primary Attendance / Leave with pay Period Type : Days
Overtime Primary Production Days of 8 hrs
CREATE PAY HEADS
Gateway of Tally > Create > Payroll Masters > Pay Heads
NAME : BASIC PAY
Pay Head Type: Earning for Employees
Income Type : Fixed
Under : Indirect Expenses
Affect Net Salary : Yes
Use for Calculation of Gratuity : Yes
Calculation Type : On attendance
Attendance with Pay : Present
Calculation Period : Months
Basis of calculation : As per calendar period
Rounding Method : Normal rounding
NAME : HRA
Pay Head Type: Earning for Employees
Income Type : Fixed
Under : Indirect Expenses
Affect Net Salary : Yes
Use for Calculation of Gratuity : No
Calculation Type : As computed value
Rounding Method : Normal rounding
Computation Info
Compute : On specific Formula
Add Pay Head : Basic Pay
Slab Type : Percentage
Value : 20 %
NAME : DA
Pay Head Type: Earning for Employees
Income Type : Fixed
Under : Indirect Expenses
Affect Net Salary : Yes
Use for Calculation of Gratuity : No
Calculation Type : As computed value
Rounding Method: Normal rounding
Computation Info
Compute : On specific Formula Add
Pay Head : Basic Pay
Slab Rate : Percentage
Value : 40 %
NAME :TRANSPORT ALLOWANCE (TA)
Pay Head Type: Earning for Employees
Income Type : Fixed
Under : Indirect Expenses
Affect Net Salary : Yes
Use for Calculation of Gratuity : No
Calculation Type : As computed value
Rounding Method: Normal rounding
Computation Info
Compute : On specific Formula Add
Pay Head : Basic Pay
Slab Rate : Percentage
Value : 10 %
NAME : BONUS
Pay Head Type: Earning for Employees
Income Type : Fixed
Under : Indirect Expenses
Affect Net Salary : Yes
Use for Calculation of Gratuity : No
Calculation Type : Flat Rate
Calculation Period: Monthly
NAME :PROVIDENT FUNS (PF)
Pay Head Type: Deduction from Employees
Under : Current Liability
Affect Net Salary : Yes
Calculation Type : As computed value
Rounding Method : Normal rounding
Computation Info
Compute : On specific Formula Add
Pay Head : Basic Pay
Slab Rate : Percentage
Value : 12%
NAME : ESIC
Pay Head Type: Deduction from Employees
Under : Current Liability
Affect Net Salary : Yes
Calculation Type : As computed value
Rounding Method : Normal rounding
Computation Info
Compute : On specific Formula
Add Pay Head : Basic Pay
Add Pay Head : DA Slab
Rate : Percentage Value
: 3%
NAME : OVER TIME
Pay Head Type: Earning for Employees
Income Type : Fixed
Under : Indirect Expenses
Affect Net Salary : Yes
Use for Calculation of Gratuity : No
Calculation Type : On production
Production type : Over time
CREATE EMPLOYEES
Gateway of Tally > Create > Payroll Masters > Employee
Employee Creation Window
Name : Rajesh Saxena
Under : Marketing
DOJ : 1st April 2021
Define Salary Details : Yes
Salary Detail Window Pay Head
Basic Pay :20000
DA:
HRA:
Transport Allowance (TA) :
Bonus : 1000
Provident Fund (PF) ESIC
Employee Number : M111
Designation : Manager
Function : Marketing Management
Location : Delhi
Gender : Male
DOB : 01-April-1990
Blood Group : A Positive
Father Name : Rohit Saxena
Spouse Name : Reena
Address : Muzaffarnagar
Phone Number :
9876543433 e-mail :
xyz@[Link] Provide
Bank Detail – Yes Bank
Details window appear
Account Number : 123456767788
IFSC code: ABCD0123456
Bank Name : Specify Bank Name
Bank Name : State Bank of India
Transaction Type : e-fund transfer
PAN Number : ASDFG1234C
Aadhar number :1234567891234567 PF
Account number : ABCD11334 PRAN :
576778788
ESI NUMBER : 5654433 ESI
DISPENSARY : DELHI
Gateway of Tally > Display more Reports> Payroll Reports>Employee Profile
Gateway of Tally > Create > Payroll Masters > Employee
Name Under Basic Pay Bonus Overtime Emp Number Designation
Rate
Rajesh Saxena Marketing 20000 1000 50 M111 Manger
Sunil Saini Account 20000 1500 100 A001 Manager
Irfan Account 22000 1000 50 A002 Clerk
Ajay Gulia HR 25000 1000 80 H001 Head
Ravi Raj HR 15000 1000 70 H002 Executive
Sameer Marketing 9000 1000 45 M001 Manager
Jyoti Tyagi Marketing 11000 000 30 M002 Executive
Payal Marketing 12000 1000 40 M003 Clerk
Rajesh Sales 25000 2000 50 S001 GM
Sunita Sales 15000 1000 45 S002 Manager
Sumit Sinha Sales 10000 1000 60 S003 Clerk
Sabu Sales 8000 1000 50 S004 Salesman
Shivam Sales 8500 1000 50 S005 Salesman
Raveena Sales 8000 1000 50 S006 Salesman
Ankur Jha Sales 9000 500 50 S007 Salesman
Anup Kumar Sales 9200 1000 50 S008 Salesman
PAYROLL VOUCHERS
ATTENDANCE VOUCHER CREATION
Gateway of Tally > Voucher > F10: Other Vouchers > Payroll vouchers > Attendance
Change Voucher Date 31 -05-
2021
Alt + A ( Auto fill)
Attendance Auto Fill Window
Voucher Date : 31-05-2021
Employees Group : All Group
Attendance Type : Present
Default value : 0
Sort by : Employees Name
Fill the value : Number of Present days for each individual
Month May (1-5-2021 to 31-5-2021)
Name Under Present Overtime
(hrs)
Rajesh Saxena Marketing 25 10
Sunil Saini Account 28 20
Irfan Account 31 0
Ajay Gulia HR 25 25
Ravi Raj HR 15 0
Sameer Marketing 30 10
Jyoti Tyagi Marketing 31 5
Payal Marketing 31 0
Rajesh Sales 31 0
Sunita Sales 20 0
Sumit Sinha Sales 31 12
Sabu Sales 31 15
Shivam Sales 31 12
Raveena Sales 27 20
Ankur Jha Sales 31 30
Anup Kumar Sales 28 40
PAYROLL VOUCHER CREATION
Gateway of Tally > Voucher > F10: Other Vouchers > Payroll vouchers > Payroll
Alt+ A (Auto fill)
Payroll Auto fill window
Process for : Salary
From : 01-05-2021 To: 31-05-2021
Employees Group : All Items
Sort by : Employees Name
Payroll Ledger : Cash Accept
DISPLAY THE SALARY INFORMATION
Gateway of Tally> Display more report >Payroll reports > Payslip
Pay Sheet
Attendance
Sheet Payroll
Register
Attendance
Register
Employee
Profile
Employee Head count
PROGRAM 5 : Creating E-mail Account.
PROGRAM 6: Practical Aspects on how E-Payment System Works in Real Business world-
Analyzing cases.
****************