Accounting Worksheet

Previous Lesson: Post Closing Trial Balance

Next Course: Financial Accounting




Accounting worksheet often refers to a loose piece of paper used by accountant for showing informal accounting statements. A worksheet is not a permanent accounting record. A valuable tool useful to help summarize and move data from the trial balance to the informal financial statements is a work sheet.

Example # 1:

COMSATS’ Consulting Services (CCS) was establishing in 1999. The company adjusts and closes its accounts at the end of the current accounting period. At December 31st, 2016 the balances in the ledger accounts prior to making adjusting entries. You are required to pass adjusting, closing entries and worksheet.

 

accounting worksheet

 

Other Data

  1. In December 1st, 2016, the company signed a new rental agreement and paid three months’ rent in advance at a rate of Rs. 1,100 per month. This advance payment was debited to the Prepaid Rent account.
  2. The useful life of the equipment has been estimated at 10 years from date of acquisition. N0 depreciation expense has been recorded for the current year.
  3. Dues and Subscriptions expired during the period in total amount of Rs. 710.
  4. Consulting Services valued at Rs. 32,550 were rendered during the account year for clients who had made payment in advance.
  5. Salaries earned by employees but not yet paid amounted to Rs. 2,200 at December.
  6. An estimate of supplies on hand was made at December 31. The estimated cost of the unused supplies was Rs. 450.
  7. Accrued interest on Note Payable amounted to Rs. 100 at year-end (Set up accounts for Interest Expense and for Interest Payable).

 

>>> Read Closing and Worksheet Problems.




Solution:

14 column worksheet

 

>>> Practice Closing and Worksheet Quiz 1 and Quiz 2.

References

Mukharji, A., & Hanif, M. (2003). Financial Accounting (Vol. 1). New Delhi: Tata McGraw-Hill Publishing Co.

Narayanswami, R. (2008). Financial Accounting: A Managerial Perspective. (3rd, Ed.) New Delhi: Prentice Hall of India.

Ramchandran, N., & Kakani, R. K. (2007). Financial Accounting for Management. (2nd, Ed.) New Delhi: Tata McGraw Hill.

5 Comments

  1. Great work .

    Reply
  2. I couldn’t refrain from commenting. Very well written!

    Reply
  3. The info you have provided is really practical. I wish that I had found your website months earlier. It would certainly have saved me a great deal of wasted time looking up other blog sites. I just wanted to give you many thanks for helping me to learn better.

    Reply
  4. Thanks for offering so much information on this. I found it really informing. I know a few other people who will certainly additionally find it intriguing as well as strategy to share it with them. I additionally prepare to revisit your blog in the future to see what extra you need to say on this subject.

    Reply
  5. I recommend this page for understanding Accounting Worksheet.

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *