B com hons tally I sem exam PDF

Preview

Summary

Question...

Description

B.COM. (H) I Semester – PRACTICAL EXAM: 2019 Paper-1.2 Part C: Computerized Accounts Max. Marks: 20 University Roll No: ___________________________. Marks Obtained: Name of the Student: ___________________________ The company details are as follows; Signature i. Name- ExamAXXXX 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 ➢ 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 or cash Balance Sheet as at 31-3-2019 Liabilities Amount Assets Amount Capital 3000000 Land and Buildings 1000000 Reserves 1000000 Plant and Machinery 1000000 Profit and Loss Account 600000 Furniture 600000 Secured loan 1000000 Investment 160000 Debentures 1000000 Stock 3459600 Loan from Promoters 1000000 Debtors 524000 Provision for tax 500000 Bills Receivables 100000 Bills Payable 200000 Punjab National Bank 1600000 Sundry Creditors 449200 State Bank of India 440000 Salaries outstanding 70000 Cash in Hand 40000 Rent outstanding 120000 Prepaid insurance 15600 8939200 8939200 ➢ The company deals in the following stocks: Name of the Items Group Quantity Rate (Rs) Opening Stock Value Cotton Shirts 100 pcs. 1300 130000 Woollen Shirts 125 pcs. 2000 250000 Teri cot Shirts 108 pcs. 1200 129600 Denim Trousers 400 pcs. 3150 1260000 Woollen Trousers 100 pcs. 4400 440000 Cotton Trousers 500 pcs. 2500 1250000 Total 3459600 ➢ The list of company debtors and creditors is as follows: Debtors Pooja Prerna Pawan Pankaj Prakash Total

Balance Due Creditors 90000 Shalu 178000 Sangeeta 104000 Sapna 60000 Sandeep 92000 Siddharth 524000 Total

Balance payable 50000 61000 135000 85200 118000 449200

Record the following transactions that took place during the April to March 2020

S.No. 1 2 3 4

10

Transaction Purchase from Shalu Sale to Prerna Sale to Pankaj Paid money to Shalu in full settlement for the transaction at sr. no. 1 above Received from Prerna and Pankaj Rs 1070000 each in full settlement for their current transaction at sr. no. 2 & 3 above Paid to Sapna Purchase from Sangeeta Purchase from Sapna Sale to Pooja (Trade discount 10% on list price) Purchased furniture

11

Paid insurance Premium

5

6 7 8 9

12

13

Item Cotton Shirts Woollen Shirts Denim trousers

Woollen Shirts Cotton Shirts Teri cot shirt

Quantity 200 125 100

Amount 140000 1080000 1100000 136000

20000 150 320000 180 400000 100 shirts. List Price Rs. 5000/- each 50000 31200

Purchased Land and Building from XY Ltd for Rs. 20,00,000. to pay this the company borrowed from bank a loan of Rs. 8,00,000 and issued fully paid debenture of Rs. 12,00,000 to XY Ltd. Sold all the investment 10,00,000

14

Paid 1. Outstanding Salaries 2. Electricity 3. Telephone 4. Current Salaries 5. Rent (including outstanding) 6. Tax of last year 15 Outstanding 1. Total Salaries 2. Total Provision for Tax 3. Total rent outstanding 1. Charge Depreciation for the period 1/4/2018 to 31/3/2019 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 as on 31/3/20202 b. Profit and Loss Account as on 31/3/2020 c. Balance Sheet as on 31/3/2020 d. Cash Book e. Ratio Analysis

40000 20000 10000 100000 140000 460000 100000 480000 180000...