B.COM.
(H) I Semester – Practical Exam:2023
Part C: Computerized Accounting System
Duration: 2 hour Max. Marks: 20
University Roll No: .
Marks Obtained:
Name of the Student:
The company details are as follows; Signature
i. Name- University Roll No
ii. Address: Your Address, Your Phone & Mobile No., Your Email ID
iii. Email Id:
[email protected] iv. Currency Symbol: Rs.
Enter the following transactions of the Company in Tally and show various reports
✓ The business is a registered organization for GST with an office in Delhi.
✓ GSTIN : 07DUUPK9284D7Z5
✓ All purchase and sales transactions of goods, Payment to creditors, and receipt from debtors
are done through SBI Bank
✓ Any other payment and receipt is done through PNB Bank
✓ Skip date and narration while passing voucher entries.
Balance Sheet as at 31-3-2022
Liabilities Amount Assets Amount
Capital 200000 Land 120000
Reserves 70000 Machinery 60000
Profit and Loss Account 100000 Investment 30000
Debentures (Unsecured) 200000 Stock 210000
Loan from Promoters 80000 Debtors 225000
Provision for tax 125000 Bills Receivables 50000
Bills Payable 60000 SBI Bank 200000
Sundry Creditors 150000 PNB Bank 105000
Salaries outstanding 20000 Cash in Hand 10000
Rent Outstanding 15000 Prepaid Insurance 10000
Total 1020000 Total 1020000
➢ The company deals in the following stocks:
Name of the Items Group GST Quantity Rate (Rs) Opening Stock
Rate Value
(%)
Reynold Pen 250 pcs. 150 37500
Parker Pen 12 200 pcs. 200 40000
Pilot Pen 150 pcs. 100 15000
Camel Geometry 200 pcs. 250 50000
Classmate Geometry 12 125 pcs. 200 25000
Apsara Geometry 170 pcs. 250 42500
Total 210000
➢ The list of company debtors and creditors is as follows:
Debtors Balance Due Creditors Balance Payable
Mohit 70000 Shreya 45000
Vansh 60000 Priya 35000
Anmol 55000 Ritika 40000
Raghav 40000 Isha 30000
Total 225000 Total 150000
Record the following transactions:
S.No. Transaction Item Quantity Amount
1 Purchase from Shreya. She is a registered supplier Apsara 50 10000
from Goa. GSTIN: 30GGGGG1314R6Z1 Geometry
2 Sale to Mohit. He is a registered supplier from Classmate 60 18000
Delhi. GSTIN: 07DUUPK9284D5Z1 Geometry
3 Sale to Anmol. He is a registered supplier from Parker Pen 75 30000
Delhi. GSTIN: 07DUUPK9284D5Z2
4 Paid money to Shreya in full settlement for the transaction at sr. no. 1 above 9000
5 Received from Mohit Rs 19000 in full settlement for their current transaction at sr. no.
2 above
6 Paid to Ritika in Full Settlement 35000
7 Purchase from Priya. He is a registered supplier Pilot Pen 50 7500
from Goa. GSTIN: 30GGGGG1314R6Z2
8 Purchase from Shreya. She is a registered supplier Classmate 100 15000
from Goa. GSTIN: 30GGGGG1314R6Z1 Geometry
9 Sale to Vansh (Trade discount 10% on listprice). 50 pcs. List Price
He is a registered supplier from Delhi. Reynold Pen Rs. 250/- each
GSTIN: 07DUUPK9284D5Z3
10 Purchased Machinery at the beginning of the year 40000
11 Purchased Land from ABC Ltd for Rs. 5,00,000. To pay this the company borrowed from
bank a loan of Rs. 4,00,000 and issued fully paid unsecured debenture of Rs. 1,00,000 to
ABC Ltd.
12 Sold all the investment 50000
13 Expenses Paid during the year
1. Outstanding Salaries 10000
2. Rent (Including outstanding) 20000
3. Tax of last year 45000
14 Outstanding to be maintained as on last day
1. Total Salaries 40000
2. Total Rent outstanding 20000
3. Total Provision for Tax 100000
15 Charge Depreciation on Machinery @ 20% p.a.
You are required to:-
1. Create a Folder on desktop with your Exam Roll No.
2. Create a company as per details given above
3. Create appropriate groups and Ledger Accounts.
4. Enter the transactions as given selecting appropriate voucher type.
5. Export the following statements as on 31st March 2023 in PDF format and save it in a Folder.
✓ Day Book
✓ Balance Sheet
✓ Profit and Loss Account
✓ GST Report (GSTR- 3B)
