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.
.

Subscribe svtuition by Email

Share above Content to Your Friends



Name

accounting Accounting Concepts Accounting Course Accounting Education accounting equation Accounting Solutions Algebra Answer the Questions and Become Master Balance Sheet bank Bodybuilding Education Business Business Education Business Environment Business Solutions CA Calculus cameras car Car Driving Course Career Solutions carpentry Class 10 Maths Class 9 Maths Computer Computer Basics Computer Hardware Computer Networking Computer Software Computer Solutions cooking education Corporate Accounting Corporate Law cost cost accounting CSE Dailymotion depreciation determinant drawing Driving Education e-accounting earn money Economics Education Education Education Solutions Electronics Email Events Examination Finance Education Finance Solutions financial Financial Accounting FIR Football Gambling Gambling Addiction Goldsmith Google Adsense GST Guest Writers Health Education Help History Home Building Home Maintenance amp; Repair Index Number India Indian Language Inspiration insurance internal audit Internet Internet Forum Jobs amp; Careers Journal journal entries journal entry Kenya Laptop Basics Law Education Law Solutions Learning Lecture Legal Education Linear algebra Linear Programming Malaysia Management Accounting Management Education Management Solutions Marketing Education Mathematics Education matrices Medical and Surgery Education Mobile motivation MS Excel Nepal Nigeria organisation Other Pakistan Personal Finance Philippines Photography Photoshop Software Picture Plumbing Education Probability Profiles provision real estate rectification Relationships amp; Family Religious Studies Result Sahas Saudi Arabia Science Education Self-Learning Skating Slideshow Solution Spiritual Education Sports Statistics Statistics Education stock Story svtuition Tablet Education Tally Tally Solutions Tally.ERP 9 tax Tax Solutions teaching Teaching Education Tech Simplify Test Testimonials Travel Trigonometry tuition TV Shows UK USA variance analysis VAT vector Video Video on Demand videos Vocational Education Web design website Wife Window Movie Maker Wordpress working capital Youth youtube
false
ltr
item
Svtuition: Prepare Trial Balance, P & L a/c and Balance Sheet in Excel
Prepare Trial Balance, P & L a/c and Balance Sheet in Excel
http://2.bp.blogspot.com/-ow7jP5hBJMs/VeVPuN4RGsI/AAAAAAAASow/-b3zkFVkJis/s1600/excel.png
http://2.bp.blogspot.com/-ow7jP5hBJMs/VeVPuN4RGsI/AAAAAAAASow/-b3zkFVkJis/s72-c/excel.png
Svtuition
http://www.svtuition.com/2012/06/prepare-trial-balance-p-l-ac-and.html
http://www.svtuition.com/
http://www.svtuition.com/
http://www.svtuition.com/2012/06/prepare-trial-balance-p-l-ac-and.html
true
3065238051582539150
UTF-8
Not found any lecture VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES Lectures View All RECOMMENDED FOR YOU Category ARCHIVE SEARCH ALL Lectures Not found any lecture match with your request, please help to write it and send it to our email at vinod@svtuition.org for making this website free accounting and finance encyclopedia. Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock