Advertisement

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?

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
1STMAY
OM 001
BABAJI STORE
BALBARATHI
DHARAVI
450
1STMAY
OM 002
AMUL STORE
YUVAKBARATHI
DHARAVI
500
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 P001
Reliance store
BALBARATHI
DHARAVI
150
100
1STJUNE
OM P002
TATA store
YUVAKBARATHI
SION
400
110
1STJUNE
OM P003
Omtex store
ALGEBRA
SION
530
120
1STJUNE
OM P004
Vishwas store
GEOMETRY
DHARAVI
310
130
1STJUNE
OM P005
Philips store
BASIC
DHARAVI
1000
145
1STJUNE
OM P006
Omtex store
FINAL
SION
200
125
1STJUNE
OM P006
IPL store
ARITHMATIC
SION
360
165
1STJUNE
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



Worksheets

UKG Worksheets 

English 

Handwriting practice sheets

Cursive Writing – Small Letters

Alphabet Tracing

Tracing

Trace the Path

Positions

Sizes

​​Classroom Alphabets

Center Signs

Mother's Day

Father's Day

Circle The Shape

A TO Z WORKSHEET

A TO Z SMALL LETTERS

CVC Words Building

Write the First Letter of Given Picture

Circle the Correct Letter Worksheets

Circle the Cursive Letter Worksheets

Match the Letter with Correct Picture

Match the Picture with Cursive Letter

Circle two pictures that begin with same letter sound

Circle two pictures that begin with same letter sound (Cursive)

CVC Worksheets Letter ‘a’

CVC Worksheets Letter ‘e’

CVC Worksheets Letter ‘i’

CVC Worksheets Letter ‘o’

CVC Worksheets Letter ‘u’

Look and write with vowels a, e, i, o, u

Opposite Words

2 Letter words - sight words

Science.

Science

Geography.

Geography

Weather

Calendar

Mathematics.

Trace Numbers 1 to 10

Measuring Things

Additional Worksheet.

Additional Worksheet.

Additional Worksheet

Subtraction Worksheets

Same, Less, More

Count and Write Worksheets

Count and Match Worksheets

Count and Circle Worksheets

Fill in the Missing Number Worksheets

What Comes After & Between

Write Missing Numbers

Shape worksheets

Backward counting

Trace the numbers 1-10

Multiplication Sheet practice for Children

Counting practice from 1 to 100 Worksheet

Miscellaneous in Maths

Hindi

Hindi Alphabets. (Swar)

Hindi Alphabets. (Vanjan)

Colours name in Hindi | रंगों के नाम

Fruits name in Hindi | फलों के नाम

Vegetables name in Hindi | सब्जियों के नाम

Days in Hindi

Parts of Body

Hindi Swar Tracing Worksheets

Hindi Vyanjan Tracing Worksheets

Write the First Letter of picture - Hindi Swar Worksheets

Look and Match - Hindi Swar Worksheets

Circle the correct letter - Hindi Swar Worksheets

Write the first letter - Hindi Vyanjan Worksheets

Circle the Correct Letter - Vyanjan Worksheets

Choose the Right Image - Vyanjan Worksheets

Miscellaneous Hindi Worksheets

2 Letter Words Hindi Worksheets

3 Letter Words Hindi Worksheets

4 Letter Words Hindi Worksheets

AA (ा) – AA ki Matra | आ (ा) की मात्रा

i ( ि) - i ki Matra | इ ( ि) की मात्रा

EE ( ी) – EE ki Matra | ई ( ी) की मात्रा

U (ु) - U ki Matra | उ (ु) की मात्रा

O (ू ) – OO ki Matra | ऊ (ू) की मात्रा

E ( े) - E ki Matra | ए ( े ) की मात्रा

AI (ै) - AI ki Matra | ऐ (ै)की मात्रा

o ( ो) - o ki Matra | ओ (ो) की मात्रा

ou ( ौ) - ou ki Matra | औ ( ौ) की मात्रा

General Knowledge.

GK Worksheets

Preschool Assessment

Nursery GK Worksheet

Creative Worksheets

Social Skills

Feelings

People at Work

Finger Puppets

Shapes

Good Or Bad

Things That Go Together

Things That Do Not Belong

Match the following.

Match the fruit to its shadow. [5 Pages]

Match Letters [35 Pages]

Matching Worksheets

Sorting Worksheet

Shadow Matching

Match the uppercase letter to its lowercase [6 Pages]

Circle 2 Matching Pictures

Games.

Cut and Paste

Matching Cards

Puzzles and Mazes

Spot the Differences

Freak - Out !!!

Freak - Out !!! 

Sudoku

Cut and Glue

This Week

Literature.

Nursery Rhymes

Cursive Alphabet Trace and Write

Letters A to G Upper and Lower Case Tracing Worksheet

Beginning Sounds. Kindergarten Worksheet

Cursive Writing Small Letters.

Capital Letters.

Small Letters.

Alphabet Trace.

Alphabet Trace and Write.

Alphabet Worksheet 

Consonant Vowel Consonant (CVC) Flashcards

Story PDF.

White Magic Story

Sunshine and Reeva in China

Two Cats and Clever Monkey

The Lion and the Rabbit

The Lion and the Mouse

Reading Passages.

Reading Passages for Kids 

Coloring.

Coloring for Fun

100 Bracelets

Dot to Dot

Color Cute Dinosaurs

Color Cute Animals

Alphabet Coloring.

Coloring Images

Colors

Drawing

Circle the Color

English Alphabet Color it. 

English Alphabet Color it and Match it with Pictures

Alphabet Color it. [26 Pages]

Alphabet Color it 2. [7 Pages]

English Alphabet Color it. 2 

Numbers PDF.

Numbers 1 to 10 Color it. [2 Pages]

1 to 10 Numbers Coloring. [4 Pages]

Flash Cards PDF.

Tell the Time Flash Cards [6 Pages]

​​Reward Cards

Posters

Animal Flashcards

Name Cards

Happy Birthday

Flashcards English vocabulary [12 Pages]

Alphabet Letters with Pictures [5 Pages]

Numbers Flash Cards. [5 Pages]

Shapes FlashCards. [4 Pages]

Colors FlashCards. [3 Pages]

English Alphabet Learning Flash Cards. [26 Pages]

Alphabet Flashcards. [26 Pages]

Alphabet Identification Flash Cards. [26 Pages]

….

11,000+ Printable Activity Worksheets Bundle

FREE With Lifetime Access: 

https://www.omtexclasses.com/p/printable-pdf-worksheets-for-kids.html

11000+ Preschool + Kindergarten Printable Activity Worksheets

These are printable pdf files. We do not sell hard copies. 

Inside 11,000+ Bundle You Will Get :

Countless coloring page

Alphabet tracing sheets

Math worksheets

Shape recognition exercises

Animal-themed activities

Scissor cutting practice

Flash Cards

Seasonal and holiday printable

And so much more!

Is it a digital product or Physical Product ?

11000+ Printable Activity Worksheets PDF is a digital product which you can instantly access for free of cost, and print whenever you wish.

We are always happy to see our products helping you to accomplish your goals. 

.