TALL ERP 9 NOTES AND PRACTICE BOOK

1.       Write down features of Tally? OR what are features of Tally?

Ans. Tally is accounting software that is used to record day to day transactions, preparing balance sheet etc. it is user friendly business software, which makes business
account easy and faster. Managing single and multiple groups is very important feature of tally. Tally is an application software. It down not require writing any special
program for calculating. Tally stores all information about each account in detail. It is very secured against data tempering. It reduces the work. In manual process, after
entering daily transaction user has to create trading account, trial balance, profit & loss account, ledger, balance sheet. But in Tally, user just enters daily entry and get
balance sheet.
2.       List and explain basic types of accounts
Account is divided in following three types:
1.       Personal account
2.       Real account
3.       Nominal account
1.       Personal account: Any individual person or any firms or any company or a bank is considered in a personal account.
2.       Real account: Account of any physical things. The cash account or goods account are examples of real account.
3.       Nominal account:  Account of any invisible things that means that things are in terms of cash. For example: insurance account, rent account etc.
3.  Explain the opening screen of the tally.
Ans. When tally is opened in Windows environment, it shows different menus.
1.       The top bar contains the product message and version, system date and time.
2.       Then Tally opening screen is displays main three parts as follows.
i. Gateway of tally
ii. Functions buttons
iii. Calculator (Command area)
I. Gateway of Tally:
To the left hand side of the screen this part shows different options. All these options are used to create ledger, group or to see trial balance or for balance sheet. To
the right hand side of the screen, this part shows the list of all companies and at the top it shows name of selected company. Ctrl + M are the shortcut keys to activate
gateway of Tally.
Function Button:
This part of the screen shows the list of all function keys with its uses.
By selecting the buttons, user can activate that particular function like backup, change, etc.
Calculator (Command area) :
 This part of the screen is actual command area
In this area user can type command and execute them.
Ctrl + N are the shortcut keys to activate this area.
II. How to create a new company in Tally?
1.       In tally, company means an organization whose accounts are to be maintained on computer.
2.       For that, user have to declare list of all accounts used in that company and then start to enter daily transactions.
3.       Creating company means enter detail information about the company.
Company info
4.       By default, tally software shows opening green with gateway of Tally, functions button and calculator.
5.       Then click on the function button F3 (Alt + F3) on the button panel to display company info menu. This show following menu: Select company

This menu is used for selecting company or for creating a new company. Create company
6.       To create a new company, select create company options by clicking this option or by pressing C.
Quit
7.       Then the screen display various fields to fill up information like name of company with its alias, address, currency, financial year, income tax
number and sales tax number etc.
8.       At the end, it asks whether accept the data or not. If user selects Yes option then that company is created and it can be loaded from company info menu.
III. Explain uses of the feature options (F11)?
Features is used to change the options related to the selected company only.
1.       For this F11 button in button panel is a short cut.
2.       Using this menu, feature of the company are changed that means enables or disables.
3.       Various features are available like whether company wants invoicing or not, whether company required multiple currencies or cheque printing or not, etc.
IV. Explain the use of configuration of company (F12)?
To configure company, click on F12 button from the button panel. It shows the following screen in gateway of tally:
1.       Configuration changes may affect all the active companies. Configuration
2.       Configuration has different options like general, numeric symbols, accts/inv. Info, voucher entry, invoice, order entry, printing, etc.
General
3.       General options are used to change information like country detail, date format or graphs in monthly report, etc.
4.       Numeric symbol option is used to change format of the numbers. Numeric symbol
5.       Accts/inv info option is used to check the default settings. In this option, if user sets allow alias for the name then only it asks the alias
Accts/inv.  Info
otherwise it doesn’t ask any alias for the name.
6.       Voucher entry set the features of the vouchers, such as cost vouchers details, bill wise details, ledger current balance, etc. Voucher entry
7.       Invoice/order entry sets the features of the invoices and purchase, sales order entry.
Invoice/order entry
8.       Printing options is used for printing Vouchers, Invoices, Financial Statements, etc.
Printing

Quit
9.       Quit option is used to quit from the configuration menu and go to the previous menu.
V. What is group in Tally?
1. In tally, all accounts entries can be grouped or sub grouped according to the need of users.
2. Group means the type of the account. Functions of each group are fixed.
3. Tally provides facility to user to create own group. Also it provides 28 predefined groups.
4. Out of these 28 groups, 15 are primary groups and 13 are sub groups.
Following is the list of groups that affects the Balance sheet.
1. Capital account: Handle investments or owner’s account. It has a subgroup.
 (A) Reserves and surplus: All reserves accounts like general reserves, capital reserves etc.
2. Current assets: These assets are divided in 6 sub-groups as follows
(A) Bank accounts: Holds bank transactions that means current accounts, savings accounts, etc.
(B) Cash in hand: All cash track in ledger.
(C) Deposits (assets): Fixed deposits, security deposits made by company.
(D) Loan and Advances (assets): If the company gives any loan or advanced to other.
(E) Stock in hand: Keep records of opening or closing stock of the material.
(F) Sundry debtors: This maintains the list of all companies or persons to whom company gives material on credit.
3. Current Liabilities: It keeps track of outstanding liabilities or statutory liabilities.
(A) Duties and Taxes: All taxes and duties that are paid by company like Trade duties, Excise, Local Sales Tax etc., are recorded under duties and taxes.
(B) Provisions: It maintains records of all financial arrangement for possible future requirements.
(C) Sundry Creditors: Company purchase material or any other things on credit. Then the list of all companies or persons is under sundry creditors to whom company
purchased material.
4. Fixed Assets: Handle accounts of all assets like machinery, buildings, etc.
5. Investments: It keep records of overall investment like shares, Govt. securities, Deposits etc.
6. Loans (liability): It keeps an account of the loans taken by company and has following three subgroup:
(A) Bank OD accounts: Keep all overdraft accounts.
(B) Secured loans: Keep track of loans taken by the company securities against the fixed assets.
(C) Unsecured Loans: Unconditional loan obtained from Partners/ Directors or other parties.
7. Suspense Account: This account is used to enter the transactions whose detai9ls are ye to tbe finalized.
8. Branch / Divisions: All the names of branches, divisions and subsidiaries of the company.
9. Miscellaneous Expenses: Under this group all expenses are entered.
Following group affect Manufacturing, Trading and Profit and loss accounts:
10.   Purchase account: It is used to maintain records of all purchase account.
11.   Sales account: It keeps record of all sales.
12.   Direct income: This group is used for entering all direct incomes like sales of goods.
13.   Indirect income: This group maintains the all incomes other than sales. That means it keeps record of all incomes like rent received, interest received etc.
14.   Direct expenses: This group is used for recording all direct expenses means the purchase of raw material, or wages of workers.
15.   Indirect expenses: This group is used to maintain the records of all expenses other than direct expense. All salary paid, rent paid, advertisement charges are under
indirect expenses.
VI. To create single and multiple groups
1. Group is the type of account. Group decides how transactions take place in accounting.
2. Tally provides 28 predefined group. But if user wants to create any other group then use create group option.
3. These new group is a sub group of existing group.
4. If user wants to create a new subgroup under different groups then follow the following steps:
i. From Gateway of Tally, select Account info.
ii. Then select Group option, as user wants to create group.
iii. If user wants to create single group at a time then select create option from single group.
iv. Now tally shows data entry screen for group as follows.

Group creation

Name
(alias)
Under:
Group behaves like a sub – ledger? No.

Name: Enter the name of a group that user want to create.

Under: Select the existing primary group name.
V.If user wants to create subgroups under more than one parent group or under one parent group then user must select create option from Multiple groups.
Vi.Then multiple group creation screen will appear.
a. To create subgroup under one parent group, select that group in the option under group.
b. To create subgroups under more than one parent group, select all items in the option under group.
VII. Creating, Displaying and Altering Ledgers.
Ledger is a book that is used to store detail of each account. It is actual account heads to which transaction is identified.
1. When user creates a company, at that time very first user creates different ledgers.
2. When user wants to create single ledger account of different group then user must select single ledger option.
3. But if user wants to create different accounts of same group then user must select multiple ledger options.
For creating ledger user follows following steps.
i. From Gateway of Tally, select Account info.
ii.Then select Ledger option, as user wants to create ledger.
iii. If user wants to create single ledger means each account of different groups then select create option of single ledger.
iv. No Tally shows data entry screen for ledger. Now enter name of Ledger account to be created and alias of account, opening balance and group of that account.
v. If user wants to create different accounts of the same group then user must select create option of multiple ledgers.
vi. In this option, first Tally ask to enter name of the group. Then enter the list of all accounts of that group with the opening balance. For example stationery a/c, salary a/c,
travelling a/c all falls under the group ‘Indirect Expenses’.
vii. If user want to create various ledger accounts under various groups then select all item in the under group field.
1. State groups for ledgers and create the ledgers.
1. Ashok starts business with Rs. 100000/-
2.       Purchase machinery for Rs. 50000/ and furniture for Rs. 10000
3.       Paid amount for rent Rs. 1000/
4.       Deposits Rs,. 10000/- in Bank
5.       Purchase of goods for Rs. 20000/ from Mr. Ram on credit.
6.       Sold goods to Mr. Rakesh for Rs. 10000/
7.       Rs. 5000/ withdraws from bank for personal use.
8.       Withdraws Rs. 1000/ for office use.
9.       Received cash from Mr. Rakesh.
10.   Paid to Mr. Ram.
By default, cash a/c and P&L a/c are available in Tally.

Ledger Group

Mr. Ashok a/c Capital a/c

Furniture a/c Fixed asset

 Machinery a/c Fixed asset

Rent a/c Indirect expenses

Bank a/c Bank a/c

Purchase a/c Purchase a/c

Sales a/c Sales a/c

Mr. Ram a/c Sundry creditor

Mr. Rakesh a/c Sundry debtor

Drawing a/c Capital a/c

2. State groups for ledgers & create the ledgers.

1.       Mr. Ram starts business with Rs. 200000/- and deposited into bank Rs. 40,000.
2.       Paid for office building Rs. 50000/ and furniture for Rs. 10000/-
3.       Purchase raw material of Rs. 10000 on credit from Mr. Avinash.
4.       Paid Wages Rs. 2000
5.       Paid salary Rs. 10000
6.       Return money to Mr. Avinash in settlement of Rs. 9500.
7.       Sold goods to Mr. Shekar Rs. 15000/-
8.       Received interest on bank amount Rs. 500.
9.       Received from Mr. Shekar after discount of Rs. 500.
10.   Sold old newspaper Rs. 450/-
11.   Sold old furniture Rs. 4000/-

Ledger Group

Mr. Ram a/c Capital a/c

 Bank a/c Bank a/c

Furniture a/c Fixed assets

Building a/c Fixed assets

Purchase a/c Purchase a/c

Mr. Avinash a/c Sundry creditor

Wages a/c Direct expenses

Salary a/c Indirect expenses

Discount a/c  Indirect expenses

Sales a/c Sales a/c

Mr. Shekar Sundry debtor

Interest a/c Indirect expenses

Old newspapers Indirect income

MAGNET COMPUTER CLASSES

I. Record the following transactions in the books of “M/s Albert & Brothers”.
1.      Albert starts business with Rs. 50,000.
2.      He opens a SBI saving bank account and deposits Rs. 20,000.
3.      Bought furniture for Rs. 5,000, machinery for Rs. 10,000.
4.      Purchased goods for Rs. 14,000.
5.      Sold goods for Rs.8, 000.
6.      Purchased goods from Malhotra & Company for Rs. 11,000.
7.      Paid telephone rent for the year by Cheque Rs. 500
8.      Bought one typewriter for Rs. 2,100 from ‘Universal Typewriter Co’. on credit.
9.      Sold goods to Keshav Ram for Rs. 12,000.
10.  Sold goods to Rajesh Kumar for Rs. 2000 cash.
11.  Amount withdrawn from bank for personal use Rs. 1,500.
12.  Received cash from Keshav Ram Rs. 11,900 and discount allowed Rs. 100.
13.  Paid into bank Rs. 5,800.
14.  Bought 50 shares in X Y & Co. Ltd. At Rs.60 per share, brokerage paid Rs. 20.
15.  Goods worth Rs. 1,000 found defective were returned to Malhotra & Co. and balance of the amount due to them settled by issuing a cheque in their favour.
16.  Sold 20 shares of X Y & Co. Ltd. at Rs. 65 per share, brokerage paid Rs. 20.
17.  Bought goods worth Rs. 2,100 from Ramesh and supplied them to Suresh at Rs. 3,000.
18.  Suresh returned goods worth Rs. 100, which in turn were sent to Ramesh.
19.  Issued a cheque for Rs. 1,000 in favour of landlord for rent for April.
20.  Paid salaries to staff Rs. 1,500.
21.  Received from travelling salesman Rs. 2000 for goods sold by him, travelling expenses Rs. 100.
Journal entries

1.      Cash a/c ……… Dr. To Capital a/c

2.      SBI saving bank a/c ………… Dr. To cash A/c
3.      Machinery a/c ……… Dr. Furniture a/c ……… Dr. To cash a/c
4.      Purchase a/c ……… Dr. To cash a/c
5.      Cash a/c ……… Dr. To Sales a/c
6.      Purchase a/c ……… Dr. To Malhotra & Co. a/c
7.      Telephone rent a/c ……… Dr. To SBI bank a/c
8.      Typewriter a/c ……… Dr. Universal Typewriter Co. a/c
9.      Kashav Ram ……… Dr. To Sales a/c
10.  Cash a/c ……… Dr. To sales a/c
11.  Drawings a/c ……… Dr. SBI bank a/c
12.  Cash a/c ……… Dr. Discount allowed a/c To Keshav Ram a/c
13.  SBI bank a/c ……… Dr. To cash a/c
14.  Investment in shares A/c ……… Dr. Brokerage a/c ……… Dr. To Cash a/c
15.  Malhotra’s a/c ……… Dr. Return Outward a/c ……… Dr. To Bank a/c
16.  Cash a/c ……… Dr. To Investment in shares a/c Investment in shares a/c ……… Dr. To Profit & Loss a/c [ selling share is not the core business so whatever profit
realized will be entered in profit & loss a/c] Brokerage a/c ……… Dr. To cash a/c
17.  Purchase a/c ……… Dr. To Ramesh a/c Suresh a/c ……… Dr.To Sales a/c
18.  Return Inward A/c ……… Dr. Suresh a/c Ramesh a/c ……… Dr. To Return outward a/c
19.  Rent a/c ……… Dr. To Bank a/c
20.  Salary a/c ……… Dr. Cash a/c
21.  Cash a/c ……… Dr. Travelling expenses a/c To sales a/c
Company Name               :               MAGNET COMPANY
Address:   :               No. 31, S.S.K. Chawl, Dharavi Cross Road, Dharavi, Mumbai – 17.

LEDGER NAME UNDER GROUP OPENING BALANCE

SHARE CAPITAL CAPITAL ACCOUNT 10,00,000

LOAN FROM SBI BANK SECURED LOAN 4,00,000

PROVISION FOR DEPRECIATION PROVISION 32,500

O/S RENT CURRENT LIABILITY 3,600

O/S SALARIES CURRENT LIABILITY 19,000

DEPOSIT FOR PREMISES DEPOSITS (ASSETS) 1,55,000

INVESTMENT IN SHARES INVESTMENT 18,550

FURNITURE FIXED ASSETS 15,000

COMPUTERS FIXED ASSETS 80,000

CASH IN BANK BANK ACCOUNT 1,93,000

CASH IN HAND CASH IN HAND 25,000

CLOSING STOCK STOCK IN HAND 67,000

To maintain Stock Statement

Group Categories Stock item Purchase price Quantit Godown

y

ECONOMICS MARSHAL V.1 300 60 DHARAVI

V.2 325 80

GLOBAL C.1 450 120

 C.2 500 160

MANAGEMEN HENRY BASIC 125 300 SION

T

INTERMEDIAT 225 325

E

FINAL 600 350

INDIAN SIMPLE 75 400

ADVANCE 325 600

 Goods are purchased from these parties. (VAT @12.5%)

Date Bill no. Party name Stock item Godown Qty

1ST MAY OM 001 BABAJI STORE V.2 DHARAVI 45

5TH  MAY OM 002 AMUL STORE C.1 SION 50

6TH  MAY OM 003 ANAND STORE V.2 SION 60

8TH  MAY OM 004 ABINAYA STORE BASIC DHARAVI 31

10TH  MAY OM 005 AZIM’S STORE FINAL DHARAVI 90

17TH JUNE OM 006 SARASWATI STORE INTERMEDIAT SION 15

E

19TH JULY OM 006 ANAND STORE ADVANCE SION 45

23RD JULY OM 007 ABINAYA STORE SIMPLE DHARAVI 75

29TH AUGUST OM 008 BABAJI STORE C.2 SION 52

Goods are sold to these parties. (VAT @12.5%)

Date Bill no. Party name Stock item Godown Qty Selling price

1ST MAY OM P001 Reliance V.2 DHARAVI 15 650

store

5TH  MAY OM P002 TATA store C.1 SION 40 675

6TH  MAY OM P003 Omtex store V.2 SION 53 685

8TH  MAY OM P004 Vishwas store BASIC DHARAVI 31 695

10TH  MAY OM P005 Philips store FINAL DHARAVI 100 902

 17TH JUNE OM P006 Omtex store INTERMEDIAT SION 20 625
E

19TH JULY OM P006 IPL store ADVANCE SION 36 635

23RD JULY OM P007 Reliance SIMPLE DHARAVI 90 644

29TH AUGUST OM P008 Philips store C.2 SION 42 702

When amount received from parties use Receipt voucher (F6)

Date Party name MODE OF PAYMENT CHEQUE NUMBER AMOUNT

Babaji store has been returned. Details 2nd  MAY Reliance store CASH --------------------- 70000 are

Stock
Purchase and item Godown
Sales Return On 1st June, 2nd  MAY
goods TATAfrom
purchased store
Quantity CASH paid to parties
When amount ---------------------
Bill no.
use 25000
payment voucher (F6)
nd
Date V.2 Party name Dharavi2   MAY Omtex
MODE OF store
2
PAYMENT CHEQUE 0229892 AMOUNT 42000
OM 001
CHEQUE NUMBER

2nd  MAY BABAJI STORE 2nd  MAY

CASH Vishwas store CHEQUE
--------------------- C/B 65425830000 18000 On 1st August, goods purchased from

2nd  MAY Philips store CHEQUE S/B 7139852 120000 Saraswati store has been returned.
2nd  MAY AMUL STORE CASH --------------------- 20000
Details are
nd 2nd  MAY IPL store CASH --------------------- 15500
2   MAY ANAND STORE CHEQUE 8459625 18000
Bill no. Godown Quantity Stock item
2nd  MAY ABINAYA STORE CHEQUE 6548721 6000
Om 006 Sion 1 Intermediate
2nd  MAY AZIM’S STORE CHEQUE 9685721 22000
On 1st October, goods purchased from Anand
nd
2   MAY SARASWATI STORE CASH --------------------- 3000
store has been returned. Details are

Bill no. Godown Quantity Stock item

Om 003 Sion 5 V.2

On 1st July, goods sold to Philips Store were returned. Details are

 Bill no. Godown Quantity Stock item

Om p005 Dharavi 5 Final

On 31st December, goods sold to Reliance company were returned. Details are

Bill no. Godown Quantity Stock item

Om p007 Sion 2 Simple

On 31st January, 2011 goods sold to IPL store were returned. Details are

Bill no. Godown Quantity Stock item

Om p006 Dharavi 2 Advance

Contra Entries
1.       On 1st September, Withdraw Rs. 50000 from Abhyudaya bank for business purpose.
2.       On 30th November, With drawn Rs. 25000 from Cash in bank for business purpose.
3.       On 28th February, Deposit Rs. 25000 in Abhyudaya bank.

Charging Depreciation
On 31 – 3 – 2011 Charge depreciation @ 10% on furniture, 20% on computer, 12.5% on Machinery, 7.5% on Building

Particulars Under category Amount Mode of

(Rs.) payment

Discount Allowed A/c Indirect expenses 1800 Cash

Commission Allowed A/c Indirect expenses 300 cash

Salary A/c Indirect expenses 500 Cheque

Travelling Expenses Indirect expenses 900 Cheque

Rent A/c Indirect expenses 450 Cash

 Brokerage Account Indirect expenses 1250 Cash

Printing & Stationery Indirect expenses 600 Cheque

Electricity charges Indirect expenses 1200 Cash
Miscellaneous expenses Indirect expenses 820 cash
Advertisement Indirect expenses 960 Cheque
Office expenses Indirect expenses 1020 Cheque
Interest Indirect expenses 350 Cheque
Delivery van expenses Indirect expenses 125 Cheque
Conveyance Expenses Indirect expenses 650 Cheque
Refreshment Expenses Indirect expenses 250 Cheque
Administrative expenses Indirect expenses 450 Cheque
Discount received A/c Indirect income 900 Cheque
Commission received A/c Indirect income 4500 Cheque

COMPANY NAME: - MAGNET BOOK STORE PRIVATE LIMITED

ADDRESS:              DHARAVI, MUMBAI - 400017

LEDGER NAME UNDER GROUP OPENING

BALANCE

SHARE CAPITAL CAPITAL ACCOUNT 15,00,000

LOAN FROM SBI BANK SECURED LOAN 5,00,000

PROVISION FOR PROVISION 450000

DEPRECIATION

O/S RENT CURRENT LIABILITY 6000

O/S SALARIES CURRENT LIABILITY 8000

DEPOSIT FOR PREMISES DEPOSITS (ASSETS) 2,00,000

INVESTMENT IN SHARES INVESTMENT 60,000

FURNITURE FIXED ASSETS 28,000

COMPUTERS FIXED ASSETS 50,000

CASH IN BANK BANK ACCOUNT 1,00,000

CASH IN HAND CASH IN HAND 75,000

CLOSING STOCK STOCK IN HAND 50,000

ABHYUDAYA BANK BANK ACCOUNT 1,25,000

MACHINERY FIXED ASSET 2,00,000

BUILDING FIXED ASSET 6,00,000

Discount Allowed A/c Indirect expenses 1800 Cash

Commission Allowed A/c Indirect expenses 300 cash

Salary A/c Indirect expenses 500 Cheque

Travelling Expenses Indirect expenses 900 Cheque

Rent paid A/c Indirect expenses 450 Cash

Brokerage Account Indirect expenses 1250 Cash

Printing & Stationery Indirect expenses 600 Cheque

Electricity charges Indirect expenses 1200 Cash
Miscellaneous expenses Indirect expenses 820 cash
Advertisement Indirect expenses 960 Cheque
Office expenses Indirect expenses 1020 Cheque
Interest on loan Indirect expenses 350 Cheque
Delivery van expenses Indirect expenses 125 Cheque
Conveyance Expenses Indirect expenses 650 Cheque
Refreshment Expenses Indirect expenses 250 Cheque
Administrative expenses Indirect expenses 450 Cheque
 Discount received A/c Indirect income 900 Cheque
Commission received A/c Indirect income 4500 Cheque

To maintain Stock Statement

Group Categories Stock item Purchase Quantity Godown

price

SCHOOL ENGLISH BALBARATHI 80 1500 DHARAVI

YUVAK BARATHI 75 1000

MATHS ALGEBRA 65 1300

GEOMETRY 55 1200

COLLEG ACCOUNTS BASIC 85 1100 SION

E

FINAL 90 1000

MATHS ARITHMATIC 45 1400

STATISTICS 35 1350

Goods are purchased from these parties. (VAT @12.5%)

Date Bill no. Party name Stock item Godown Qty

1STMAY OM 001 BABAJI STORE BALBARATHI DHARAVI 450

1STMAY OM 002 AMUL STORE YUVAKBARATH DHARAVI 500

I

1STMAY OM 003 ANAND STORE ALGEBRA DHARAVI 600

1STMAY OM 004 ABINAYA STORE GEOMETRY DHARAVI 310

1STMAY OM 005 AZIM’S STORE BASIC SION 900

 1STMAY OM 006 SARASWATI STORE FINAL SION 150

1STMAY OM 006 ANAND STORE ARITHMATIC SION 450

1STMAY OM 007 ABINAYA STORE STATISTICS SION 750

Goods are sold to these parties. (VAT @12.5%)

Date Bill no. Party name Stock item Godown Qty Selling price

1STJUNE OM Reliance store BALBARATHI DHARAVI 150 100

P001

1STJUNE OM TATA store YUVAKBARATH SION 400 110

P002 I

1STJUNE OM Omtex store ALGEBRA SION 530 120

P003

1STJUNE OM Vishwas store GEOMETRY DHARAVI 310 130

P004

1STJUNE OM Philips store BASIC DHARAVI 1000 145

P005

1STJUNE OM Omtex store FINAL SION 200 125

P006

1STJUNE OM IPL store ARITHMATIC SION 360 165

P006

1STJUNE OM Reliance STATISTICS DHARAVI 900 175

P007

Purchase and Sales Return

On 1st June, goods purchased from Babaji store has been returned. Details are
 Stock item Godown Quantity Bill no.

BALBARATHI Dharavi 2 OM 001

On 1st August, goods purchased from Saraswati store has been returned. Details are

Bill no. Godown Quantity Stock item

Om 006 Sion 1 FINAL

On 1st October, goods purchased from Anand store has been returned. Details are

Bill no. Godown Quantity Stock item

Om 003 Sion 5 ARITHMATIC

On 1st July, goods sold to Philips Store were returned. Details are

Bill no. Godown Quantity Stock item

Om p005 Dharavi 5 BASIC

On 31st December, goods sold to Reliance company were returned. Details are

Bill no. Godown Quantity Stock item

Om p007 Sion 2 BALBARATHI

On 31st January, 2011 goods sold to IPL store were returned. Details are

Bill no. Godown Quantity Stock item

Om p006 Dharavi 2 ARITHMATIC

Contra Entries
4.       On 1st September, Withdraw Rs. 50000 from Abhyudaya bank for business purpose.
5.       On 30th November, With drawn Rs. 25000 from Cash in bank for business purpose.
6.       On 28th February, Deposit Rs. 25000 in Abhyudaya bank.
Charging Depreciation
On 31 – 3 – 2011 Charge depreciation @ 10% on furniture, 20% on computer, 12.5% on Machinery, 7.5% on Building

Windows Functionality Availability

ALT + F1 To close a company At all menu screens

To view detailed report At almost all report screens
To explode a line into its details At almost all screens in TALLY
To select Inventory vouchers to alter At the Inventory/ Payroll voucher creation or
alteration screen.

ALT + F2 To change the period At almost all screens in TALLY

ALT + F3 To select the company info menu At Gateway of Tally screen

To create/alter/shut a Company

ALT + F4 To select the Purchase Order Voucher Type At Accounting / Inventory Voucher creation and
alteration screens

ALT + F5 To select the Sales Order Voucher Type At Accounting / Inventory Voucher creation and
To view monthly and quarterly report alteration screens
At almost all report screens in TALLY

ALT + F6 To select the Rejection Out Voucher Type At Accounting / Inventory Voucher creation and
To change the Sales Order Voucher Type alteration screens

ALT + F7 To select the Stock Journal Voucher Type At Accounting / Inventory Voucher creation and
To accept all the Audit lists alteration screens
At Tally Audit Listing screen
 ALT + F8 To select the Delivery Note Voucher Type At Accounting / Inventory Voucher creation and
To view the Columnar report alteration screens
At Ledger Voucher screen

ALT + F9 To select the Receipt Note Voucher Type At Accounting / Inventory Voucher creation and
alteration screens

ALT + F10 To select the Physical Stock Voucher Type At Accounting / Inventory Voucher creation and
alteration screens

ALT + F12 To filter the information based on monetary At almost all report screens
value

Ctrl + F1 To select payroll vouchers for alteration At the Accounting/Inventory Voucher creation or
alteration screen

CTRL + Advanced Configuration At Gateway of Tally

ALT + F12

Key Combination Used for Navigation

Window Functionality Availability

s

PgUp Display previous voucher during At voucher entry and alteration screens
voucher entry/alter

PgDn Display next voucher during voucher At voucher entry and alteration screens
entry/alter

ENTER To accept anything you type into a field. You have to use this key at most areas in TALLY
To accept a voucher or master At the receivables report - press Enter at a pending bill to get transactions relating to this bill (e.g., original sale bill,
To get a report with further details of an receipts and payments against this bill, etc)
item in a report

ESC To remove what you typed into a field At almost all screens in TALLY
 To come out of a screen
To indicate you do not want to accept a
voucher or master

SHIFT + Collapse next level details At Voucher Register screen and Trial Balance report
ENTER

SHIFT + To explode a line into its details In almost all Reports:

ENTER At a Group/Stock Group/Cost Category/Godowns /Stock Category - displays Sub Groups and Ledgers/Stock
Items/Cost Centres/Secondary Godowns/Secondary Stock Categories
At a Voucher - displays its entries and narration
At a Stock Item- displays its godowns and batch details
At Voucher Register screen - displays the next level details
At Trial Balance report - displays the next level details

CTRL + To alter a master while making an entry At voucher entry and alteration screens
ENTER or viewing a report At all reports

Windows Functionality Availability

F1 To select a company At all masters menu screen

F1 To select the Accounts Button At the Accounting Voucher creation and alteration screen

F1  To select the Inventory At the Inventory/Payroll Voucher creation and alteration screen
(ALT+F1) To view the detailed or condensed In almost all the Reports
report

F2 To change the current date At almost all screens in TALLY

To select company inventory features At the F11: Features screen

F2 To change the current date At almost all screens in TALLY

To select company inventory features At the F11: Features screen
 F4 To select the Contra voucher At Accounting / Inventory Voucher creation and alteration screen

F5 To select the Payment voucher At Accounting / Inventory Voucher creation and alteration screen

F6 To select the Receipt voucher At Accounting / Inventory Voucher creation and alteration screen

F7 To select the Journal voucher At Accounting / Inventory Voucher creation and alteration screen

F8 To select the Sales voucher At Accounting / Inventory Voucher creation and alteration screen

F8 To select the Credit Note voucher At Accounting / Inventory Voucher creation and alteration screen
(CTRL+F8)

F9 To select the Purchase voucher At Accounting / Inventory Voucher creation and alteration screen

F9 To select the Debit Note voucher At Accounting / Inventory Voucher creation and alteration screen
(CTRL+F9)

F10 To select the Reversing Journal At Accounting / Inventory Voucher creation and alteration screen
voucher

F10 To select the Memorandum voucher At Accounting / Inventory / Payroll Voucher creation and alteration screen
(Ctrl + F10)

F11 To select the Functions and Features At almost all screens in TALLY
screen

F12 To select the Configure screen At almost all screens in TALLY

Special Key Combination

Windows FFunctionality Availability

ALT + 2 To Duplicate a voucher At List of Vouchers – creates a voucher similar to the one where
you positioned the cursor and used this key combination

ALT + A To Add a voucher At List of Vouchers – adds a voucher after the one where you
To Alter the column in columnar positioned the cursor and used this key combination.
 report Alters the column in all the reports which can be viewed in
columnar format

ALT + C To create a master at a voucher At voucher entry and alteration screens, at a field where you have
screen (if it has not been already to select a master from a list. If the necessary account has not
assigned a different function, as been created already, use this key combination to create the
in reports like Balance Sheet, master without quitting from the voucher screen.
where it adds a new column to At all voucher entry screens in the Amount field
the report)
To access Auto Value Calculator
in the amount field during
voucher entry

ALT + D To delete a voucher At Voucher and Master (Single) alteration screens. Masters can be
To delete a master deleted subject to conditions, as explained in the manual.
To delete a column in any All the reports screen which can be viewed in columnar format
columnar report
(if it has not been already
assigned a different function, as
explained above)

ALT + E To export the report in ASCII, At all reports screens in TALLY

Excel, HTML OR XML format

ALT + I To insert a voucher At List of Vouchers – inserts a voucher before the one where you
To toggle between Item and positioned the cursor and used this key combination.
Accounting invoice At creation of sales and purchase invoice

ALT + L To select the Language At almost all screens in TALLY

Configuration

ALT + K To select the Keyboard At almost all screens in TALLY

Configuration
ALT + O To upload the report at your At all reports screens in TALLY
website

ALT + G To select language for Tally At almost all screens of TALLY

Interface

ALT + M To Email the report At all reports screens in TALLY

ALT + N To view the report in automatic At all the reports where columns can be added
columns

ALT + P To print the report At all reports screens in TALLY

ALT + R To remove a line in a report At all reports screens in TALLY

ALT + S To bring back a line you removed At all reports screens in TALLY
using ALT + R

ALT + U To retrieve the last line which is At all reports screens in Tally
deleted using Alt + R

ALT+ V From Invoice screen to bring At Invoice screen > Quantity Field > Press Alt + V to select the
Stock Journal screen Stock Journal.

ALT + X To cancel a voucher in Day At all voucher screens in TALLY

Book/List of Vouchers

ALT + R To Register Tally At almost all screens in TALLY.

CTRL + A To accept a form – wherever you At almost all screens in TALLY, except where a specific detail has
use this key combination, that to be given before accepting
screen or report gets accepted
as it is

CTRL + B To select the Budget At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher

Types/ Currencies (Accounts Info) creation and alteration screen

CTRL + ALT + B To check the Company Statutory At all the menu screens
 details

CTRL + C To select the Cost Centre At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher

To select the Cost Category Types/ Currencies (Accounts Info) creation and alteration screen
At Stock Groups/ Stock Categories/ Stock Items/ Reorder Levels/
Godowns/ Voucher Types / Units of Measure ( Inventory Info)
creation/alteration screen

CTRL+ E To select the Currencies At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher

Types/ Currencies (Accounts Info) creation and alteration screen

CTRL + G To select the Group At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher

Types/ Currencies (Accounts Info) creation and alteration screen

CTRL + H To view the Support Centre At Almost all screens in Tally

CTRL + I To select the Stock Items At Stock Group/ Stock Categories/ Stock Items/ Reorder Levels/
Godowns/ Voucher Types / Units of Measure ( Inventory Info)
creation/alteration screen

Ctrl + Alt + I To import statutory masters At all menu screens

CTRL + K To Login as Remote Tally.NET At Almost all screens in Tally

User

CTRL + L To select the Ledger At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher

To mark a Voucher as Optional Types/ Currencies (Accounts Info) creation and alteration screen
At the creation and alteration of Vouchers

CTRL + O To select the Godowns At Stock Group/ Stock Categories/ Stock Items/ Reorder Levels/
Godowns/ Voucher Types / Units of Measure ( Inventory Info)
creation/alteration screen

CTRL + Q To abandon a form – wherever At almost all screens in TALLY.

you use this key combination, it
quits that screen without making
 any changes to it.

CTRL + R To repeat narration in the same At creation/alteration of voucher screen

voucher type

CTRL + Alt + R Rewrite data for a Company From Gateway of Tally screen

CTRL + S Allows you to alter Stock Item At Stock Voucher Report and Godown Voucher Report
master

CTRL + U To select the Units At Stock Groups/ Stock Categories/ Stock Items/ Reorder Levels/
Godowns/ Voucher Types / Units of Measure ( Inventory Info)
creation/alteration screen

CTRL + V To select the Voucher Types At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher

To toggle between Invoice and Types/ Currencies (Accounts Info) creation and alteration screen
Voucher At creation of Sales/Purchase Voucher screen