EVALUATION SHEET
Date of Exam:
Name of the College:
Student’s Name: Exam Roll No:
Machine No.
External Examiner’s Name: Code:
Internal Examiner’s Name: Code:
Sr. No. Basis of Evaluation Max. Marks
Marks obtained
1 Machine Handling 1 Mark
2 Company Creation 3 Marks
(Accounts with Inventory, GST Enabled, use of security control
and features & configurations)
3 Creation of Groups and Ledgers (Using Single & Multiple Options) 4 Marks
4 Voucher Entry (15 entries including compound entries, GST, Cash 9 Marks
Discount, Trade Discount etc.)
5 Generation of Report (i.e., Day Book, GST Report, Profit & Loss 3 Marks
and Balance Sheet)
Total 20
Marks
B.A. Prog II Semester – PRACTICAL EXAM: 2024
Computerized Accounts
Duration: 1 hour Max. Marks: 20
University Roll No: ___________________________.
Name of the Student: ___________________________ Marks Obtained:
The company details are as follows; Signature
i. Name- Your Name and College Roll No.
ii. Address: Your Address, Your Phone & Mobile No.
iii. Email Id: admin@[Link]
iv. Currency Symbol: Rs.
Enter the following transactions of the Company in Tally and show various reports
All purchase and sales transactions of goods, Payment to creditors, and receipt from debtors
are done through State Bank of India
Any other payment and receipt is done through Punjab National Bank
Balance Sheet as at 31-3-2024
Liabilities Amount Assets Amount
Capital 1500000 Land and Buildings 500000
Reserves 500000 Plant and Machinery 500000
Profit and Loss Account 300000 Furniture 300000
Secured loan 500000 Investment 80000
Debentures 500000 Stock 1729800
Loan from Promoters 500000 Debtors 262000
Provision for tax 250000 Bills Receivables 50000
Bills Payable 100000 Punjab National Bank 800000
Sundry Creditors 224600 State Bank of India 220000
Salaries outstanding 35000 Cash in Hand 20000
Rent outstanding 60000 Prepaid insurance 7800
4469600 4469600
The company deals in the following stocks:
Name of the Items Group Quantity Rate (Rs) Opening Stock Value
Cotton Shirts 100 pcs. 650 65000
Woollen Shirts 125 pcs. 1000 125000
Teri cot Shirts 108 pcs. 600 64800
Denim Trousers 400 pcs. 1575 630000
Woollen Trousers 100 pcs. 2200 220000
Cotton Trousers 500 pcs. 1250 625000
Total 1729800
The list of company debtors and creditors is as follows:
Debtors Balance Due Creditors Balance payable
Priya 45000 Tanu 25000
Prerna 89000 Sangeeta 30500
Pawan 52000 Srishti 67500
Pankaj 30000 Sandeep 42600
Prakash 46000 Siddharth 59000
Total 262000 Total 224600
Record the following transactions that took place during the April to September 2024.
[Link]. Transaction Item Quantity Amount
1 Purchase from Tanu Cotton Shirts 200 70000
2 Sale to Prerna Woollen Shirts 125 540000
3 Sale to Pankaj Denim trousers 100 550000
4 Paid money to Tanu in full settlement for the 68000
transaction at sr. no. 1 above
5 Received from Prerna and Pankaj Rs 535000
each in full settlement for their current
transaction at sr. no. 2 & 3 above
6 Paid to Srishti 10000
7 Purchase from Sangeeta Woollen Shirts 150 160000
8 Purchase from Srishti Cotton Shirts 180 200000
9 Sale to Priya (Trade discount 10% on list Teri cot shirt 100 shirts. List Price
price) Rs. 2500/- each
10 Purchased furniture 25000
11 Paid insurance Premium 15600
12 Purchased Land and Building from XY Ltd for Rs. 10,00,000. to pay this the company
borrowed from bank a loan of Rs. 4,00,000 and issued fully paid debenture of Rs. 6,00,000
to XY Ltd.
13 Sold all the investment 5,00,000
14 Paid
1. Outstanding Salaries 20000
2. Electricity 10000
3. Telephone 5000
4. Current Salaries 50000
5. Rent (including outstanding) 70000
6. Tax of last year 230000
15 Outstanding
1. Total Salaries 50000
2. Total Provision for Tax 240000
3. Total rent outstanding 90000
1. Charge Depreciation for the period 1/4/2024 to 30/9/2024 on furniture @20% p.a. and
Machinery @ 10% p.a.
You are required to:-
1. Create a company as per details given above
2. Create appropriate groups and Ledger Accounts.
3. Enter the transactions as given selecting appropriate voucher type.
4. Display the following statements
a. Trial Balance
b. Profit and Loss Account
c. Balance Sheet
d. Cash Book
e. Ratio Analysis