You are given the following information below:
Post closing trial balance for April 30, 2008
Transactions for the month of May 2008
Adjustments for May 31,2008
Insurance was purchased for a one-year period, starting on March 1, 2008.
Rent was prepaid on January 1, 2008, for a one-year period, starting on January 1.
Office equipment has a 5 year life, with a $2,500 salvage value.
A supplies inventory count shows an ending balance of $1350.
Assume that the receptionist works 5 days a week and earns an even amount per day. The May
28th payroll pays her up to May 28th (Wednesday).
Kelly Consulting Transactions for May 2008
May 3 Received cash from clients as an advance payment for services to be provided and recorded it as unearned fees, $1,550.
May 5
Received cash from clients on account, $1,750.
May 9
Paid cash for a newspaper advertisement, $100
May 13
Paid Office Station Co. for part of the debt incurred on April 5, $400
May 15
Recorded services provided on account for the period May 1-15, $5,100.
May 16
Paid part-time receptionist for two weeks' salary including the amount owed on April 13, $750.
May 17
Recorded cash from cash clients for fees earned during the period May 1-16,
$7,380
May 20
Purchased supplies on account, $500.
May 21
Recorded Fees Earned services provided on account for the period May 16-20, $2900
May 25
Recorded cash from cash clients for fees earned for the period May 17-23,
$4,200.
May 27
Received cash from clients on account, $6,600.
May 28
Paid part-time receptionist for two weeks' salary, $750.
May 30
Paid telephone bill for May, $150.
May 31
Paid electricity bill for May, $225.
May 31
Recorded cash from cash clients for fees earned for the period May 25-31,
$2,875.
May 31
(a) Recorded services provided on account for the remainder of May, $2,200.
May 31
(b) Kelly withdrew $7,500 for personal use.
May 31
(c) Supplies on hand total $1,000.
May 31
(d) Prepaid rent of $1,200 has expired.
May 31
(e) Prepaid insurance of $1,000 has expired
May 31
(f) Record depreciation for office equipment $500.
May 31
(g) Unearned fees totaling $2,500 have been earned.
Instructions are as follows:
1. Record the ending balances from the April 30 post closing trial balance into the ledger sheets or alternatively, you may create T-accounts on an Excel spreadsheet.
2. Record journal entries for the May transactions on the journal sheets given or create a
spreadsheet configured as a journal sheet.
3. Post the journal entries to the ledger sheets or if you created T-accounts post the entries to your
T-accounts.
4. Enter the ending balances from the ledger or T-accounts on to the worksheet trial balance columns.
5. Enter the adjustments directly on to the worksheet.
6. Extend to the adjusted trial balance columns.
7. Extend to the financial statement columns.
8. Prepare the financial statements.
9. Enter the closing entries on to the worksheet.
10. Prepare the post closing trial balance for May.
Make sure you include the following in your final Excel Workbook:
1. The completed Worksheet on the given downloadable spreadsheet.
2. Formal income statement, statement of owner's equity, and balance sheet. These may be prepared on separate tabs on the Excel Workbook where the "Worksheet" is the first tab.
3. Post Closing Trial Balance for May 31.
4. T- Accounts
Hi, experienced Auditor/Accountant here with High Honors in MBA. I've done very similar accounting projects like you have for other students in other sites aside from here. Ready to start. High quality and accurate results you can expect. Kindly check your inbox. Sincerely, Ruby (Phil. CPA, US MBA High Honors)
Hi there,
I'm a qualified CPA accountant from Australia. Am very confident with your project after reading through the job and the attachements.
I'm new to the site, but experienced with the work. I'd love to start with your project. I endeavour to complete the job with in the next day.
Please feel free to contact me if you have any questions.
Kind regards,
Christine Ling
Principle
LYNK Business Services
Hi,
Please check the private message for the sample work.
I have completed the Journal entries and posted the opening balances in the ledger accounts.
If we agree to the project arrangements, I will move Ahead.
Kind Regards,
Rizwan
I'm an accountant by profession with 12 years of experience working in the field.
Your posted project appears to be for the purpose of a school assignment.
Nevertheless, it will more than a pleasure to help you with this.
Please consider me for this project and I'll start working with it immediately upon hire.
Thank you.
Hi. I am a chartered certified accountant with Big 4 audit firm experience. I can complete the work in less than 12 hours with good quality. Kindly contact me for a quick and value for money service. Looking forward for a positive response.
Thanks and Regards,
Ali
Good day! I'm very much willing to do the job. I'm an Accountancy graduate and currently working as a consultant for an accounting software company. I'm looking forward to hear a feedback from you. Thank you.
I will give final results in 2-3 days only. I already developed accounts software and I knows Accounts very well
I have 16+ years experience in Software and Accounts Maintenance through Software
Hi,
I am a qualified member of ACCA, and an experienced business consultant by profession.
I have huge experience of accounting and book-keeping. Please consider me for this job.
Regards,
Abdul Wahab
Hi Thompsoz i am student of Bachelor in Business Administration.I already done a number of assignments like this therefore i am here to take your project and i will complete this in 1 day....