B.
COM SEMESTER -1 - TALLY PRACTICAL EXAM (SET -1)
Academic Session: 2023 — 2024
Time: 03 hours
NAME OF STUDENT…………………………
ROLL NUMBER………………………………
Company Details: The Company is based in Delhi.
Company name: Student name followed by your examination Roll Number.
Address: 123, first floor, malviya nagar, new delhi-110047
Phone Number : 9999999999
Email Id: aurobindoe@gmail.com
Website: www.sace.du.ac.in
GSTIN: 07AHKPR6590D1ZZ
Rate of tax : 18 %
NOTE: 1) All purchase and sales transactions of goods, Payments to creditors, and receipts from debtors
are made through the State Bank of India.
2) Any other payments and receipts are made through Punjab National Bank.
Balance Sheet as at 31-3-2023
Liabilities Amount Assets Amount
Capital 20,00,000
20,00,000 Land and Building 15,00,000
General Reserve 10,00,000
10,00,000 Plant and Machinery 18,00,000
Profit and Loss account 8,00,000
8,00,000 Furniture 1,70,000
Secured loan 2,00,000
2,00,000 Investments 80,000
(Book Value 1,00,000)
Debentures (unsecured) 2,50,000
2,50,000 Cash in hand 30,000
Creditors 2,50,000
2,50,000 Punjab National Bank 2,25,000
Bills Payable 75,000 75,000 State Bank of India 1,75,000
Provision for Tax 33,000 33,000 Prepaid Expenses 5,000
Salaries Outstanding 25,000 Stock 3,95,000
Rent Outstanding 37,000 37,000 Bills Receivable 85,000
Debtors 2,05,000
1
Total 46,70,000 Total 46,70,000
The company deals in the following goods:
Items Group Quantity Price (Rs.) Amount (Rs)
Lamp Philips 50 500 25,000
Bulbs Philips 500 120 60,000
Tube light Philips 400 200 80,000
Juicer Kenstar 80 1000 80,000
Mixer Kenstar 45 2000 90,000
Kettle Kenstar 100 600 60,000
The list of the company’s debtors and creditors is as follows:
Debtors Amount Creditors Amount
Seema 30,000 Amit 85,000
Pooja 45,000 Sumit 95,000
Rahul 50,000 Naveen 70,000
Preeti 80,000
2,05,000 2,50,000
Record the following transactions from 1st April 2022 to 31st March 2023.
S.No. Transaction Item Quantity Rate per unit
excluding GST
1 Purchased from Amit. Amit is a Lamps 300 400
registered supplier from Delhi.
2 Sale to Rahul at a trade discount of 10%. Bulbs 350 300
He is a registered supplier from Delhi. (before discount)
3 Paid Rs. 1,15,000 to Amit in full settlement for the transaction at Sr. no. 1
4 Received from Rahul Rs. 93,000 for the full settlement of transaction at sr. no. 2
5 Paid to Sumit on account 25,000
2
6 Rohit, whose account was written off last year as bad debts, paid Rs.10,000 in cash.
7 Purchased a Building(GST exempted) from Bhushan Ltd for Rs. 7,00,000.
8 Money withdrawn from PNB for office use ……Rs,10,000
.9 Sold total investments at profit of Rs 50,000 at face value
10 Drawings by owner …………………Rs.5000
11 Received from Preeti on account ……… Rs. 12000
12 Salaries Paid (including the outstanding salaries)……….Rs.50,000
13 Outstanding Rent paid
14 Paid
1. Electricity Bill(GST exempted) 10,000
2. Telephone Bill . 5,000
3. Tax Paid 30000
15. Charge Depreciation on fixed assets @10% p.a
You are required to create a folder on your system on desktop by the your name followed by
Examination Roll Number and record the above transactions and prepare and save the following
in the above folder:
(A) Day Book for the financial year 2023 — 2024.
(B) Profit & Loss A/c for the financial year 2023 -2024.
(C) Balance Sheet as of 31/03/2024.