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?
Ans.
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.
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:
Company info |
Select company |
Create company |
Quit |
This menu is used for selecting company or for creating a new company.
6. To create a new company, select create company options by clicking this option or by pressing C.
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)?
Ans. 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)?
Ans. To configure company, click on F12 button from the button panel. It shows the following screen in gateway of tally:
Configuration |
General |
Numeric symbol |
Accts/inv. Info |
Voucher entry |
Invoice/order entry |
Printing |
Quit |
1. Configuration changes may affect all the active companies.
2. Configuration has different options like general, numeric symbols, accts/inv. Info, voucher entry, invoice, order entry, printing, etc.
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.
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 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.
7. Invoice/order entry sets the features of the invoices and purchase, sales order entry.
8. Printing options is used for printing Vouchers, Invoices, Financial Statements, etc.
9. Quit option is used to quit from the configuration menu and go to the previous menu.
V. What is group in Tally?
Ans.
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
Ans.
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.
Ans. 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 news paper 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 | Quantity | Godown |
ECONOMICS | MARSHAL | V.1 | 300 | 60 | DHARAVI |
| | V.2 | 325 | 80 | |
| GLOBAL | C.1 | 450 | 120 | |
| | C.2 | 500 | 160 | |
MANAGEMENT | HENRY | BASIC | 125 | 300 | SION |
| | INTERMEDIATE | 225 | 325 | |
| | 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 | INTERMEDIATE | SION | 15 |
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 store | V.2 | DHARAVI | 15 | 650 |
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 | INTERMEDIATE | SION | 20 | 625 |
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 |
2nd MAY | Reliance store | CASH | --------------------- | 70000 |
2nd MAY | TATA store | CASH | --------------------- | 25000 |
2nd MAY | Omtex store | CHEQUE | 0229892 | 42000 |
2nd MAY | Vishwas store | CHEQUE | C/B 654258 | 18000 |
2nd MAY | Philips store | CHEQUE | S/B 7139852 | 120000 |
2nd MAY | IPL store | CASH | --------------------- | 15500 |
When amount paid to parties use payment voucher (F6) | ||||
Date | Party name | MODE OF PAYMENT | CHEQUE NUMBER | AMOUNT |
2nd MAY | BABAJI STORE | CASH | --------------------- | 30000 |
2nd MAY | AMUL STORE | CASH | --------------------- | 20000 |
2nd MAY | ANAND STORE | CHEQUE | 8459625 | 18000 |
2nd MAY | ABINAYA STORE | CHEQUE | 6548721 | 6000 |
2nd MAY | AZIM’S STORE | CHEQUE | 9685721 | 22000 |
2nd MAY | SARASWATI STORE | CASH | --------------------- | 3000 |
Purchase and Sales Return
On 1st June, goods purchased from Babaji store has been returned. Details are
Stock item | Godown | Quantity | Bill no. |
V.2 | 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 | Intermediate |
On 1st October, goods purchased from Anand 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 (Rs.) | Mode of payment |
Discount Allowed A/c Commission Allowed A/c | Indirect expenses Indirect expenses | 1800 300 | Cash 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 Electricity charges Miscellaneous expenses Advertisement Office expenses Interest Delivery van expenses Conveyance Expenses Refreshment Expenses Administrative expenses Discount received A/c Commission received A/c | Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect income Indirect income | 600 1200 820 960 1020 350 125 650 250 450 900 4500 | Cheque Cash cash Cheque Cheque Cheque Cheque Cheque Cheque Cheque Cheque 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 DEPRECIATION | PROVISION | 450000 | |
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 Commission Allowed A/c | Indirect expenses Indirect expenses | 1800 300 | Cash 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 Electricity charges Miscellaneous expenses Advertisement Office expenses Interest on loan Delivery van expenses Conveyance Expenses Refreshment Expenses Administrative expenses Discount received A/c Commission received A/c | Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect expenses Indirect income Indirect income | 600 1200 820 960 1020 350 125 650 250 450 900 4500 | Cheque Cash cash Cheque Cheque Cheque Cheque Cheque Cheque Cheque Cheque Cheque |
To maintain Stock Statement
Group | Categories | Stock item | Purchase price | Quantity | Godown |
SCHOOL | ENGLISH | BALBARATHI | 80 | 1500 | DHARAVI |
| | YUVAK BARATHI | 75 | 1000 | |
| MATHS | ALGEBRA | 65 | 1300 | |
| | GEOMETRY | 55 | 1200 | |
COLLEGE | ACCOUNTS | BASIC | 85 | 1100 | SION |
| | 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 |
1ST MAY | OM 001 | BABAJI STORE | BALBARATHI | DHARAVI | 450 |
1ST MAY | OM 002 | AMUL STORE | YUVAKBARATHI | DHARAVI | 500 |
1ST MAY | OM 003 | ANAND STORE | ALGEBRA | DHARAVI | 600 |
1ST MAY | OM 004 | ABINAYA STORE | GEOMETRY | DHARAVI | 310 |
1ST MAY | OM 005 | AZIM’S STORE | BASIC | SION | 900 |
1ST MAY | OM 006 | SARASWATI STORE | FINAL | SION | 150 |
1ST MAY | OM 006 | ANAND STORE | ARITHMATIC | SION | 450 |
1ST MAY | 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 |
1ST JUNE | OM P001 | Reliance store | BALBARATHI | DHARAVI | 150 | 100 |
1ST JUNE | OM P002 | TATA store | YUVAKBARATHI | SION | 400 | 110 |
1ST JUNE | OM P003 | Omtex store | ALGEBRA | SION | 530 | 120 |
1ST JUNE | OM P004 | Vishwas store | GEOMETRY | DHARAVI | 310 | 130 |
1ST JUNE | OM P005 | Philips store | BASIC | DHARAVI | 1000 | 145 |
1ST JUNE | OM P006 | Omtex store | FINAL | SION | 200 | 125 |
1ST JUNE | OM P006 | IPL store | ARITHMATIC | SION | 360 | 165 |
1ST JUNE | OM P007 | Reliance | STATISTICS | DHARAVI | 900 | 175 |
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 To view detailed report To explode a line into its details To select Inventory vouchers to alter | At all menu screens At almost all report screens At almost all screens in TALLY 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 To create/alter/shut a Company | At Gateway of Tally screen |
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 To view monthly and quarterly report | At Accounting / Inventory Voucher creation and alteration screens At almost all report screens in TALLY |
ALT + F6 | To select the Rejection Out Voucher Type To change the Sales Order Voucher Type | At Accounting / Inventory Voucher creation and alteration screens |
ALT + F7 | To select the Stock Journal Voucher Type To accept all the Audit lists | At Accounting / Inventory Voucher creation and alteration screens At Tally Audit Listing screen |
ALT + F8 | To select the Delivery Note Voucher Type To view the Columnar report | At Accounting / Inventory Voucher creation and 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 value | At almost all report screens |
Ctrl + F1 | To select payroll vouchers for alteration | At the Accounting/Inventory Voucher creation or alteration screen |
CTRL + ALT + F12 | Advanced Configuration | At Gateway of Tally |
Key Combination Used for Navigation
Windows | Functionality | Availability |
PgUp | Display previous voucher during voucher entry/alter | At voucher entry and alteration screens |
PgDn | Display next voucher during voucher entry/alter | At voucher entry and alteration screens |
ENTER | To accept anything you type into a field. To accept a voucher or master To get a report with further details of an item in a report | You have to use this key at most areas in TALLY At the receivables report - press Enter at a pending bill to get transactions relating to this bill (e.g., original sale bill, receipts and payments against this bill, etc) |
ESC | To remove what you typed into a field To come out of a screen To indicate you do not want to accept a voucher or master | At almost all screens in TALLY |
SHIFT + ENTER | Collapse next level details | At Voucher Register screen and Trial Balance report |
SHIFT + ENTER | To explode a line into its details | In almost all Reports: 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 + ENTER | To alter a master while making an entry or viewing a report | At voucher entry and alteration screens 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 (ALT+F1) | To select the Inventory To view the detailed or condensed report | At the Inventory/Payroll Voucher creation and alteration screen In almost all the Reports |
F2 | To change the current date To select company inventory features | At almost all screens in TALLY At the F11: Features screen |
F2 | To change the current date To select company inventory features | At almost all screens in TALLY 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 (CTRL+F8) | To select the Credit Note voucher | At Accounting / Inventory Voucher creation and alteration screen |
F9 | To select the Purchase voucher | At Accounting / Inventory Voucher creation and alteration screen |
F9 (CTRL+F9) | To select the Debit Note voucher | At Accounting / Inventory Voucher creation and alteration screen |
F10 | To select the Reversing Journal voucher | At Accounting / Inventory Voucher creation and alteration screen |
F10 (Ctrl + F10) | To select the Memorandum voucher | At Accounting / Inventory / Payroll Voucher creation and alteration screen |
F11 | To select the Functions and Features screen | At almost all screens in TALLY |
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 To Alter the column in columnar report | At List of Vouchers – adds a voucher after the one where you positioned the cursor and used this key combination. Alters the column in all the reports which can be viewed in columnar format |
ALT + C | To create a master at a voucher screen (if it has not been already assigned a different function, as in reports like Balance Sheet, where it adds a new column to the report) To access Auto Value Calculator in the amount field during voucher entry | At voucher entry and alteration screens, at a field where you have to select a master from a list. If the necessary account has not been created already, use this key combination to create the master without quitting from the voucher screen. At all voucher entry screens in the Amount field |
ALT + D | To delete a voucher To delete a master To delete a column in any columnar report (if it has not been already assigned a different function, as explained above) | At Voucher and Master (Single) alteration screens. Masters can be deleted subject to conditions, as explained in the manual. All the reports screen which can be viewed in columnar format |
ALT + E | To export the report in ASCII, Excel, HTML OR XML format | At all reports screens in TALLY |
ALT + I | To insert a voucher To toggle between Item and Accounting invoice | At List of Vouchers – inserts a voucher before the one where you positioned the cursor and used this key combination. At creation of sales and purchase invoice |
ALT + L | To select the Language Configuration | At almost all screens in TALLY |
ALT + K | To select the Keyboard Configuration | At almost all screens in TALLY |
ALT + O | To upload the report at your website | At all reports screens in TALLY |
ALT + G | To select language for Tally Interface | At almost all screens of TALLY |
ALT + M | To Email the report | At all reports screens in TALLY |
ALT + N | To view the report in automatic columns | At all the reports where columns can be added |
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 using ALT + R | At all reports screens in TALLY |
ALT + U | To retrieve the last line which is deleted using Alt + R | At all reports screens in Tally |
ALT+ V | From Invoice screen to bring Stock Journal screen | At Invoice screen > Quantity Field > Press Alt + V to select the Stock Journal. |
ALT + X | To cancel a voucher in Day Book/List of Vouchers | At all voucher screens in TALLY |
ALT + R | To Register Tally | At almost all screens in TALLY. |
CTRL + A | To accept a form – wherever you use this key combination, that screen or report gets accepted as it is | At almost all screens in TALLY, except where a specific detail has to be given before accepting |
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 details | At all the menu screens |
CTRL + C | To select the Cost Centre To select the Cost Category | At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher 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 User | At Almost all screens in Tally |
CTRL + L | To select the Ledger To mark a Voucher as Optional | At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher 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 you use this key combination, it quits that screen without making any changes to it. | At almost all screens in TALLY. |
CTRL + R | To repeat narration in the same voucher type | At creation/alteration of voucher screen |
CTRL + Alt + R | Rewrite data for a Company | From Gateway of Tally screen |
CTRL + S | Allows you to alter Stock Item master | At Stock Voucher Report and Godown Voucher Report |
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 To toggle between Invoice and Voucher | At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen At creation of Sales/Purchase Voucher screen |