Closed

Financial Accounting / Book Keeping

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

Skills: Accounting, Finance

See more: rent prepaid january 2008 year period starting january, worksheet in accounting, trial balances in accounting, trial balance in accounting, trial balance entries, trial balance accounting, total finance, the office receptionist, the month of january, t&c financial services, t accounts in accounting, t accounts accounting, sure payroll, spreadsheet consulting, spreadsheet accounting, salvage value in accounting, record journal, receptionist office, receptionist accounting, payroll statement, payroll of accounting, payroll in accounting, payroll as in accounting, payroll accounts, payroll accounting services

About the Employer:
( 0 reviews ) United States

Project ID: #2510415

24 freelancers are bidding on average $74 for this job

uhostings

Highly interested and fully capable to deliver quality output , please check inbox for details !

$100 USD in 2 days
(40 Reviews)
5.6
javed1705

dear sir please check pm

$55 USD in 2 days
(58 Reviews)
5.4
imranamin

Kindly Check PM - Lets Start to Finish

$60 USD in 2 days
(21 Reviews)
5.4
xazoo

Consider it done, thanks

$100 USD in 2 days
(46 Reviews)
5.4
waqar21081974

We have required resources and expertise to complete the desired task. Check your inbox for further details.

$50 USD in 2 days
(27 Reviews)
5.0
rohitpithisaria

Hi... I would like to apply for the job.

$60 USD in 4 days
(13 Reviews)
4.7
ruby22

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 r More

$55 USD in 2 days
(19 Reviews)
4.4
LUretsky

I am a career accountant with 30 years of experience.

$200 USD in 0 days
(6 Reviews)
4.0
waqar42

Hello thompsoz, I got the solution to your assignment ACT300 ready. Please check your messages. Thank You

$69.99 USD in 0 days
(4 Reviews)
3.7
LYNK123

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 star More

$60 USD in 1 day
(1 Review)
3.4
rizwansaeed2003

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 More

$99 USD in 1 day
(3 Reviews)
2.9
coltejer

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 More

$115 USD in 5 days
(1 Review)
2.4
Genuinewrtrs

Being a professional accountant with over 8 years of industry experience in handling accounts up to finalization, I can handle this perfectly.

$150 USD in 2 days
(0 Reviews)
0.0
rashidat

Hello, I am a Chartered accountant and a US Tax Practitioner. I have good accounting and tax knowledge. Will provide you the best of service.

$75 USD in 1 day
(0 Reviews)
0.0
sanjay1236

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

$100 USD in 4 days
(0 Reviews)
0.0
weronconsultant1

I am US Certified Public Accountant ( Qualified from Colarado,USA) with experience in Accounts & Finance. I can solve your assignment. Thanks,

$50 USD in 2 days
(0 Reviews)
0.0
mrwahab70

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

$50 USD in 1 day
(0 Reviews)
0.0
aikawafs22

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.

$150 USD in 5 days
(0 Reviews)
0.0
chitor

I have the necessary experience in tests and the workplace to get this done. Kindly consider. You won't regret.

$50 USD in 1 day
(0 Reviews)
0.0
mirzawaqar4

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

$30 USD in 1 day
(0 Reviews)
0.0