Prepare Trial Balance, P & L a/c and Balance Sheet in Excel

Following is the information,  Prepare Trial Balance, P & L a/c and  Balance Sheet in Excel

1 Conveyance – Rs. 14465/-, Including Last Year Provision of Rs. 2465/-
2. Provision Opening – Rs. 18265/-
3. Boarding & Lodging – Rs. 47000/-
4. Travelling Expenses – Rs. 16000/-
5. Conveyance short totaled = Rs. 4600/-
6. Salary – Rs. 955000/-, including Provision of Rs. 11500/-, PF Co. Cont on Basic 60%, ESIC – Co. Cont on Gross
7. Authorised Capital – Rs.1000000/-
8. Subscribed Ramesh Equity – Rs.250000/-
9. Subscribed Rajesh Equity – Rs.200000/-
10. Subscribed Ranganath Equity – Rs.300000/-
11. Raw Material Purchases Vat @ 14% – Basic Rs. 789000/-, Compute VAT

12.Raw Material Purchases –Basic Rs. 520000/- @ VAT @ 5%, Compute VAT

13.Raw Material VAT %% wrongly accounted as Packing Material vAt 14%, Basic – Rs. 2800/-

14. Ramesh has closing Balance – Top Receive from Co. – Rs.22000/-
15. Import Purchase 820000/-
16. Directors Remuneration - Rs. 460000/- per Director
17. Krishna has closing Balance – To Pay Co. – Rs.73000/-
18.ECGC Premium – Rs. 14000/-, For the Period June 2010to June 2011
19. Opening Stock Packing Material – Rs. 45500/-
20. Electrical fittings – Rs. 124500/- Purchased, 01.09., Compute Depn
21. Term Loan Outstanding Rs. 640000/-
22. Computer Purchases Rs. 520000/- Out of which – Pur before 30th sept – Rs. 73000/-, compute Depn

23. Packing Material Vat @ 14% /Basic purchase – Rs. 1670000/-
24. Car Purchases – Rs. 552000/- on 30.10.. Compute Depn.
25. Consumable Purchases Basic Vat @ 14% – Rs. 280000/-
26. Export Sales short accounted – Rs. 10500/-
27. Exchange Fluctuation – rs. 1900/-
28. Bank CC A/c Cr. Bal – Rs. 1610000/-
29. Export Sales 1050000/-
30. TDS Receivable – Rs. 147000/-
31. Furniture – 780000/-, Out of Which Purchased after 30.09. Rs. 244000/-, compute Depn

32. Opening Stock Consumable – Rs. 78000/-
33. Closing Stock Raw Material Rs. 74000/-
34. P & L A/c Dr bal b/f – 195000/-
35. Vishwanatha has closing Balance – To Pay Co. – Rs.525000/-
36. Building Deposit – Rs. 1000000/-
37. Professional Charges – Rs. 73000/- including Provision, Rs. 4300/-
38. KSFC Loan – Rs. 442000/-
39. Closing Stock Packing Material – Rs. 91000/-
40. Opening Stock Raw Material – Rs. 245000/-
41. Closing Stock Consumable – Rs. 164000/-
42. Excess totalled Salary – Rs. 14500/-
43. Prepaid Insurance – Rs. 28000/-
44. Partner Vishwanath Personnel Expenses – Rs. 228000/-
45. Telephone Charges Payable– Rs. 18900/-
46. Printing & Stationery – Rs. 24000/-
47. Sales Vat @ 14% - Basic 775000/-, Compute VAT Payable
48. Sales VAT @ 5% - 1546000/- Compute VAT Payable
49. Sales CST @ 2% – Rs.1160000/-
50. Sales CST @ 14% - Rs. 82000/-
51. Salary Payable – Rs.1 46000/-
52. Telephone Deposit – Rs. 15000/-
53. Insurance – Rs. 7800/-
54. Machinery – Rs. 910000/-, Purchased on 16.09
55. Sundry Debtors – Rs. 430000/-
56. Advance from Debtors – Rs. 70000/-
57. Service Charges Received – 520000/- ( No Service Tax)
58. Staff Welfare – Rs. 245600
59. Advance to Creditors – Rs. 55000/-
60. Directors Remuneration Payable – Rs. 72000/-
61. Freight Inwards – Rs. 184500/-
62. Freight Outwards – Rs. 217000/-
63. TDS Payable – Rs. 190500/
64. Service tax Payable – Rs. 22000/-
65. Advertisement – Rs. 7000/
66. Computer Maintenance – Rs. 12000/-
67. Krisha, Partners House electrical Bill paid = Rs. 51500/-
68. Pooja expenses – Rs. 49000/-
69. Sundry Creditors – Rs. 370000/-
70. Telephone Charges – Rs. 59000/-
71. Short totaled Repairs & Maint – Rs. 4500/-
72. Subscription & Membership Fee – Rs. 12500/-
73. Professional Charges wrongly Debited to Salary – Rs. 5500/-
74. Difference Suspense A/c

Ganesh from India

Anybody who is reading this can solve Ganesh's problem by using following comment box.