FACULTY OF COMMERCE, OSMANIA UNIVERSITY
B.Com (CBCS) V – Semester (For All Streams)
--- Content provided by FirstRanker.com ---
Computer Lab - Practical Question Bank
COMPUTERIZED ACCOUNTING
Time: 60 Minutes Record : 10
Skill Test : 15
Total Marks: 25
--- Content provided by FirstRanker.com ---
Q 1. Create a company with Imaginary details.
Q.2 Create a Company in Tally with following details:-
| Name | Rahul Enterprises |
| Mailing Name | Rahul Enterprises |
| Address | 12-1-975/A Sultan Bazar, KingKothi, Hyderabad |
| Country | India |
| State | Telangana |
| PIN Code | 500001 |
| Mobile No. | 9988776655 |
| E-mail ID | firstranker.com |
| Country | India |
| Maintain | Accounts with Inventory |
| Financial Year From | 1-4-2018 |
| Books Beginning from | 1-4-2018 |
| Tally Vault | No |
| Security Control | No |
Q.3 Create a Company with imaginary details by selecting country As United States and giving Tally Password and activating Security Control by set Yes.
Q4. Create the following Ledgers under relevant groups in Tally giving their Opening Balances and display the following for Suresh & Co.:
a) Trial Balance - Total Rs.3,43,200/-
--- Content provided by FirstRanker.com ---
b) Profit and Loss Account - Gross Profit Rs.36,500/- Net Profit Rs.24,800/-
c) Balance Sheet - Total Rs. 1,01,000/-
| Debit Balances | Rs. | Credit Balances | Rs. |
| Stock (1-4-2017) | 96000 | Capital | 50000 |
| Wages | 28000 | Loan | 9000 |
| Salaries | 4000 | Sales | 250000 |
| Carriage Inward | 5000 | Reserve for Bad Debts | 5000 |
| Purchases | 120000 | Discount on Purchases | 4000 |
| Interest on Loan | 200 | Creditors | 23000 |
| Cash at Bank | 1800 | Purchases Returns | 1500 |
| Buildings | 11000 | Outstanding Expenses | 700 |
| Sales Returns | 1000 | ||
| Debtors | 35000 | ||
| Office Expenses | 5500 | ||
| Drawings | 6500 | ||
| Depreciation | 2000 | ||
| Rent | 2400 | ||
| Plant | 18000 | ||
| Travel Expenses | 5000 | ||
| Advertisement | 1600 | ||
| Cash in Hand | 200 | ||
| 343200 | 343200 |
Closing Stock (31-3-2018) Rs. 35000/-
Q.5 Create the following ledgers in Multiple Ledger Creation Mode:-
--- Content provided by FirstRanker.com ---
| SI No. | Ledger Name |
| 1. | Machinery A/c |
| 2. | Furniture A/c |
| 3. | Land & Building A/c |
| 4. | Loose Tools A/c |
| 5. | Fixtures A/c |
| 6. | Discount Paid A/c |
| 7. | Discount Received A/c |
| 8. | Interest Paid A/c |
| 9. | Interest Received A/c |
| 10. | Commission Paid A/c |
| 11. | Printing Stationery A/c |
| 12. | Postage A/c |
| 13. | Wages A/c |
| 14. | Loan Taken from HDFC Bank A/c |
| 15. | Suspense A/c |
| 16. | Motive Power A/c |
| 17. | Purchases A/c |
| 18 | Sales A/c |
| 19 | Capital A/c |
| 20. | Bank A/c |
Q.6 Create the following ledgers in Single Ledger Creation Mode:-
| SI No. | Ledger Name |
| 1. | Land & Building A/c |
| 2. | Furniture & Fixture A/c |
| 3. | Trade Marks A/c |
| 4. | Patents A/c |
| 5. | Debtors A/c |
| 6. | Discount Paid A/c |
| 7. | Discount Received A/c |
| 8. | Commission Paid A/c |
| 9. | Printing & Stationery A/c |
| 10. | Creditors A/c |
| 11. | Wages A/c |
| 12. | Purchases A/c |
| 13. | Sales A/c |
| 14. | Capital A/c |
| 15. | Bank A/c |
Q. 7 Create following Godowns for “Dinesh Kirana Store “:
Kothi, Sultan Bazar, Begum Bazar.
Q8. Create a company named “Dinesh Kirana Store “ and create following stock Groups ad stock items according to the given information:
--- Content provided by FirstRanker.com ---
| Stock Item | Company / Brand (Stock Group) | Unit of Measurement | Quantity | Price |
| Rice | Daawat | Kg. | 500 | 100 |
| Oil | Gold Drop | Ltr | 1000 | 105 |
| Mustard Oil | Fortune | Ltr | 250 | 120 |
| Biscuits | Sunfeast | No. | 500 | 10 |
| Chilli Powder | Everest | Pkt | 100 | 50 |
| Black Pepper | Everest | Pkt | 100 | 40 |
Q 9 Enter following business transactions for National Traders.
Business Transactions for the months of May and June 2009 are as follows:
National Traders Business Transactions
| Date | Transaction Details |
| 10-5-09 | Bank Advice received for bank interest of Rs.500 credited to the deposit account. |
| 11-5-09 | Electricity bill (Office costs) for Rs.400 received from Horizon Enterprises. |
| 13-5-09 | Sold 1 HP LaserJet 1010 Series for Rs 9,500 to a cash customer, retaining the money as Petty Cash. |
| 19-5-09 | Salaries of Rs 2,500. Amount paid through Bank Account. |
| 24-5-09 | Sold 1 HCL Pentium IV for Rs. 21,500 to Supreme Computers. |
| 30-5-09 | Purchased 5 USB Pen Drives 64MB @ Rs. 1,250 each from Challenger Systems on credit. |
| 01-6-09 | Paid freight charges of Rs 200 from petty Cash |
| 01-6-09 | Paid Challenger Systems Rs. 11,500 by cheque |
| 09-6-09 | Transferred Rs 6,000 from Bank Account to Deposit Account. |
| 15-6-09 | Cheque for Rs 15,000 received from Spectrum Computers |
| 22-6-09 | Purchased 4 IBM Pentium IVs for Rs. 17,100 each from a new supplier and paid by cheque |
| 22-6-09 | Sold 2 IBM Pentium IVs for Rs. 24,785 to a customer who paid by cheque |
Q 10. Enter the following transaction:
--- Content provided by FirstRanker.com ---
1. Started business with Cash Rs.2, 00,000
2. Purchased Goods from Amit Suppliers on credit of Rs.1, 50,000.
3. Deposit Cash in to Bank Rs. 25,000
4. Sold goods to Dynamic Traders Pvt. Ltd. of Rs. 1, 30,000
5. Received a cheque of Rs. 1, 27,000 from Dynamic Traders Pvt. Ltd.
--- Content provided by FirstRanker.com ---
6. Issued a cheque of Rs. 1, 00,000 as a partial payment to Amit Suppliers.
7. Purchase Goods for Rs. 45000 by Cash
8. Purchase Goods for Rs.8500 by SBI Bank.
9. Purchase Goods from "Krishna Mohan " for Rs. 67500 for Credit.
10. Purchase Goods from "Siva Mohan Agency" for Rs. 7200 and paid by SBI Bank Cheque.
--- Content provided by FirstRanker.com ---
11. Purchase Goods from "Mehatha G/s" for Rs. 15000 and Cash Discount received @ 2%.
12. Cash Purchase Goods from "Krishna G/s" for Rs. 12000.
13. Goods given to proprietor daughter Rs. 1800.
14. Purchased furniture for proprietor's residence by cash.
15. Cash Withdrawn from Bank.
--- Content provided by FirstRanker.com ---
Q 11.Pass following Journal entries:
1. Rs.6000 was stolen from the safe of the firm.
2. Received an order from Kapil for the supply of goods worth Rs. 240000. In this connection we received Rs. 120000 as Advance.
3. Goods sold for cash Rs. 60000. Also received 7% sales tax.
4. Given as Charity: Cash Rs. 6000, Goods Rs. 18000 & Sofa-set worth Rs. 24000.
--- Content provided by FirstRanker.com ---
5. Goods worth Rs. 4200 stolen by an employee.
6. Purchase two House worth Rs. 110000 for the business.
7. Goods given to proprietor daughter Rs. 1800.
8. Goods worth Rs. 6000 Destroyed by fire.
9. Goods worth Rs. 12000 distributed as sample.
--- Content provided by FirstRanker.com ---
10. Bricks worth Rs. 600000 purchased for the construction of building.
Q 12.Journal the following transaction in the books of Mr. X for the month of January 2017.
Jan-1 X having no capital of his own started business with Rs. 10000 borrows from his friend Mr. R @12% p.a
Jan-2 Purchased goods worth Rs. 6000 less 20% trade discount and 5% cash discount. Mr. M & Co. For cash and supplied then to Mr. R at least price less 10%.
--- Content provided by FirstRanker.com ---
Jan-3 Goods worth Rs. 200 was damaged in transit a claim was made on the railway authority for the same.
Jan-4 Under instruction from Mr. M & Co, X supplied goods listed at Rs. 1000 to Mr. S. Received the invoice at 20% trade discount from Mr. M & co.
Jan-5 Received cash from Railway in the full settlement of claim for damages in transit.
Jan-6 Received from travelling sales man Rs. 1400 for goods sold by him after deducting his travelling expenses Rs. 50.
Jan-7 Mr. S declared his insolvent and dividend of 50 Paise in the Rupees is received from him in the full settlement of his account.
--- Content provided by FirstRanker.com ---
Jan-8 Bought a horse for Rs. 600 as a carriage for Rs. 1200 for delivering goods to the customers.
Jan-9 Bought goods worth Rs. 700 from Mr. D and supplied them to Mr. K at Rs. 1000.
Jan-10 Mr. K returned goods worth Rs. 50 which in turn was sent to Mr. D.
Jan-11 one month interest to Mr. R on capital supplied by him due but could not be paid.
Jan-12 The horse bought on 8th January died on his body was sold for Rs. 30.
--- Content provided by FirstRanker.com ---
Q 13.Journalise the following transaction in the books of Ram. Post them in the ledger and balanced the various accounts opened in the ledger.
April-2 Ram started his business with Cash Rs. 70000.
April-3 Deposited in to Bank Rs. 50000.
April-4 Purchased goods for cash from Mr. X Rs. 5000.
April-5 Bought goods on credit from Mr. Y Rs. 6000.
--- Content provided by FirstRanker.com ---
April-6 Returned goods to Mr. Y Rs. 1000.
April 10 Sold goods for cash to Mr. A Rs. 6000.
April-15 Sold goods to Mr. B Rs. 6000.
April-16 Mr. B returns goods Rs. 1000.
April-17 Drew from Bank for personal use Rs. 5000.
--- Content provided by FirstRanker.com ---
April-25 Paid to Mr. Y in full Settlement by Cheque Rs. 4800.
Q 14.Enter the following Transactions maintain billwise details:-
Mohan started business with cash Rs 10,000
Purchase following stock item items from Ravi on 1 Oct 2015.
--- Content provided by FirstRanker.com ---
| Bill no | Item | Purchase price /unit | Unit purchase |
| No/001 | Dove soap 100 gm | Rs.50 | 100 |
| No/001 | Dove soap 200 gm | Rs 100 | 50 |
| No/001 | Lux soap 100 gm | Rs 22 | 100 |
| No/001 | Lifebouy 100 gm | Rs 20 | 200 |
Purchase following stock item from Sudha trader on 2 oct 2015
| Bill no | Item | Purchase price /unit | Unit purchase |
| No/002 | Maggi 100 gm | Rs.8 | 100 |
| No/002 | Maggi 400 gm | Rs 35 | 50 |
| No/002 | Top remen 100 gm | Rs 12 | 100 |
| No/002 | Top remen 400 gm | Rs 40 | 200 |
Q 15.Create a Company and Enter the followings and Find as per maintain Bill-wise Details
a) Goods sold to Ravi Rs 15000/- (1-Apr-2014)
b) Cash received from Ravi Rs. 10000/- (1-Apr-2014)
c) Goods sold to Ravi Rs. 10000/- (1-May-2014)
--- Content provided by FirstRanker.com ---
d) Cash received from Ravi Rs. 20000/- (1-May-2014)
e) Goods sold to Ravi Rs. 25000/- (1-Jun-2014)
f) Interest charged to Ravi Rs. 500/- (1-Jun-2014)
Q.16. Show the balance sheet of Royal Star Company, with the following accounts, under relevant groups with imaginary figures:
i) Fixed assets: a) Land b) Building c) Machinery d) Furniture e) Goodwill
--- Content provided by FirstRanker.com ---
ii) Current assets: a) Trade Debtors b) Stock c) Bills Receivable d) Bank e) Cash
iii) Loan accounts: a) Loan from Andhra Bank b) Loan from Ramu
iv) Capital account
Q.17 Enter the following transactions by creating relevant accounts and groups.
--- Content provided by FirstRanker.com ---
i) Purchased goods from Ram Rs.10000
ii) Purchased goods from Roshan Rs.5000
iii)Purchased goods from Mohan Rs.20000
iv)Sold goods to Leela Rs.25000
v) Sold goods to Praveena Rs.30000
--- Content provided by FirstRanker.com ---
vi)Sold goods to Praveen Rs.20000.
Q.18 From the information given below prepare P & L account & B/S.
| Salaries | 70,000 | Capital | 6,00,000 |
| Rent | 30,000 | Commission received | 10,000 |
| Stationary | 5,000 | Sales | 1,65,000 |
| Cash | 45,000 | ||
| Furniture | 4,60,000 | ||
| Purchases | 84,000 | ||
| Machinery | 81,000 |
Adjustments: Outstanding Rent Rs.1000, Depreciation on furniture @ 5%, Machinery @ 4%.
Q.19. Mr.Rajesh started business with cash Rs.3,00,000:
i) Purchased 30 CTV's @10,000 each for cash.
--- Content provided by FirstRanker.com ---
ii)Paid carriage on purchase Rs.2000
iii) Sold 12 CTV's @12,000 each for cash
iv) Sold 10 CTV's @12,000 each to Rajnikant.
v) Paid salaries Rs.2,000 and Rent Rs.1,000
Prepare P & L A/c.
--- Content provided by FirstRanker.com ---
Q.20 Edit the following transactions:
i. Bought goods worth Rs.5,550, alter it to Rs.7,000
ii. Sold Goods to Roja Rs.5,000 alter it to Rs.3,000
iii. Cash received from Kamesh Rs.1,000 alter it to Krishna
iv. Paid cash to Yaday Rs.1,000, alter to bank.
--- Content provided by FirstRanker.com ---
Q.21 From the following ledger balances of Ayaan Ltd., prepare Trading and P & L a/c for the year ending 31-3-2018 and a balance sheet as at that date.
| Particulars | Rs | Rs | |
| Cash in hand | 15,000 | P & L a/c on 1-4-2009 | 80,000 |
| Cash at bank | 6,100 | share capital 20,000 equity shares @ 10/- | 2,00,000 |
| Rent | 3,600 | ||
| Wages | 10,000 | sundry creditors | 20,500 |
| Bad debts | 500 | Bills payable | 10,000 |
| Plant and machinery | 68,000 | Sales | 2,70,000 |
| Opening stock | 21,000 |
| Salaries | 6,000 | ||
| Land and buildings | 1,80,000 | ||
| Furniture | 18,000 |
Q.22 Prepare funds flow from the given information below:
| Name Of The Account | Dr. RS. | Cr. RS. |
| Furniture | 20000 | - |
| Machinery | 100000 | - |
| Buildings | 200000 | - |
| Capital | 300000 | |
| Cash | 10000 | - |
| Bills payable | 60000 | |
| Trade debtors | 160000 | - |
| Trade creditors | - | 130000 |
Q.23. Prepare a cash flow statement for the following cash transactions.
a. Anil brought in cash towards Capital Rs.75000
--- Content provided by FirstRanker.com ---
b. Deposited into bank Rs.60000
c. Purchased goods Rs.9000
d. Sale of goods worth Rs.21000
e. Paid to Ganesh (a supplier) Rs.15000
f. Received from Hari (a customer) Rs.18000
--- Content provided by FirstRanker.com ---
Q.24 Prepare ratios from the following information:
| Opening balance: | Rs. |
| Capital | 150000 |
| Machinery | 50000 |
| Cash | 75000 |
| Land | 50000 |
| Plant | 50000 |
| Bank | 25000 |
| Transactions: | |
| Purchased goods from Sita (cash) | 4500 |
| Sold goods for cash | 11500 |
| Sold goods to Geeta | 17000 |
| Paid salaries | 3000 |
| Selling expenses | 1500 |
| Distribution expenses | 500 |
Q.25 Pass Following Transactions and Display Financial Statements
1. Ashok starts business with Rs. 100000/-
2. Purchase machinery for Rs. 50000/ and furniture for Rs. 10000
--- Content provided by FirstRanker.com ---
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.
--- Content provided by FirstRanker.com ---
8. Withdraws Rs. 1000/ for office use.
9. Received cash from Mr. Rakesh.
10. Paid to Mr. Ram.
Q.26 Pass Following Transactions and Display Profit and Loss Account.
1. Mr. Ram starts business with Rs. 200000/- and deposited into bank Rs. 40,000.
--- Content provided by FirstRanker.com ---
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. Avin
--- Content provided by FirstRanker.com ---
This download link is referred from the post: DUET Last 10 Years 2011-2021 Question Papers With Answer Key || Delhi University Entrance Test conducted by the NTA