P Q R S T M Question No 2 XYZ LLC has a factory in Sohar....

Transcribed Image Text:

P Q R S T M Question No 2 XYZ LLC has a factory in Sohar. The company in the business of buying and selling of Building materials. The company has a huge work force and so there are huge cash and bank transaction during each month. In the month of December,2020 the company has observed that some of the entries made in the cash book and bank book are not proper. You have been recently appointed in the company as a senior account officer. Based on your understanding, about the Topic discussed above, you are required to write the cash/bank book for the month of December 2020. The transaction for the month of December 2020 is given below. 1 Dec 2 Dec 3 Dec 4 Dec 5 Dec 6 Dec 7 Dec 11 Dec 13 Dec 14 Dec 15 Dec 16 Dec 18 Dec 25 Dec 30 Dec 31 Dec Required: Opening Balance of Bank is OMR50,000 and Cash is OMR 20,000 Withdraw cash from Bank OMR 20,000 Purchased goods from Khan LLC OMR 40,000 and issued cheque after deducting 5% discount Sold goods to Salman for OMR 4,000 on 20 days credit Paid Water Charges for the month of November OMR 4,750. Purchased Air conditioner from Daikin Aircon for OMR 30,000 and paid the bill by cheque Purchased goods on cash from Khalid LLC for OMR 9,000 Sales of goods on cash OMR 6,000 Interest credited by the bank in our account OMR 650 Received cash from old customers OMR 6,000 for sale made in the last month. Ali Enterprise purchased goods from us for OMR 8,000 less cash discount 5%. Cash deposit into Bank OMR 10,000 Purchased furniture for office from M/S Teejan OMR 18,000 for which OMR 4,000 was on cash the balance amount was to be paid in 10 equal monthly instalments from the end of this month. Purchased Land Cruiser car for Director from Toyota for OMR 24,000 by paying 25% of the value Deposit in Bank OMR 26,000 Paid Salary to Staff for the month of December OMR 5,000 by direct debit in the staff bank account. Prepare three columns cash book for the month using MS Excel. (10 Marks) Formatting guidelines: Headings font: Type=Arial; Size 12, Bold. Merge and center cells: Main Heading, Column width: Auto fit, All the cells for amounts = category-Number. Decimal places-00 and Use 1,000 separator. Calculation: -Apply formula and/ or cell referencing wherever required P Q R S T M Question No 2 XYZ LLC has a factory in Sohar. The company in the business of buying and selling of Building materials. The company has a huge work force and so there are huge cash and bank transaction during each month. In the month of December,2020 the company has observed that some of the entries made in the cash book and bank book are not proper. You have been recently appointed in the company as a senior account officer. Based on your understanding, about the Topic discussed above, you are required to write the cash/bank book for the month of December 2020. The transaction for the month of December 2020 is given below. 1 Dec 2 Dec 3 Dec 4 Dec 5 Dec 6 Dec 7 Dec 11 Dec 13 Dec 14 Dec 15 Dec 16 Dec 18 Dec 25 Dec 30 Dec 31 Dec Required: Opening Balance of Bank is OMR50,000 and Cash is OMR 20,000 Withdraw cash from Bank OMR 20,000 Purchased goods from Khan LLC OMR 40,000 and issued cheque after deducting 5% discount Sold goods to Salman for OMR 4,000 on 20 days credit Paid Water Charges for the month of November OMR 4,750. Purchased Air conditioner from Daikin Aircon for OMR 30,000 and paid the bill by cheque Purchased goods on cash from Khalid LLC for OMR 9,000 Sales of goods on cash OMR 6,000 Interest credited by the bank in our account OMR 650 Received cash from old customers OMR 6,000 for sale made in the last month. Ali Enterprise purchased goods from us for OMR 8,000 less cash discount 5%. Cash deposit into Bank OMR 10,000 Purchased furniture for office from M/S Teejan OMR 18,000 for which OMR 4,000 was on cash the balance amount was to be paid in 10 equal monthly instalments from the end of this month. Purchased Land Cruiser car for Director from Toyota for OMR 24,000 by paying 25% of the value Deposit in Bank OMR 26,000 Paid Salary to Staff for the month of December OMR 5,000 by direct debit in the staff bank account. Prepare three columns cash book for the month using MS Excel. (10 Marks) Formatting guidelines: Headings font: Type=Arial; Size 12, Bold. Merge and center cells: Main Heading, Column width: Auto fit, All the cells for amounts = category-Number. Decimal places-00 and Use 1,000 separator. Calculation: -Apply formula and/ or cell referencing wherever required