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: accounts accounting kelly consulting, kelly consulting excel worksheet, kelly consulting final worksheet, worksheet accounting, trial balances accounting, trial balance entries, trial balance accounting, total finance, office receptionist, accounts accounting, sure payroll, spreadsheet consulting, spreadsheet accounting, salvage value accounting, record journal, receptionist office, receptionist accounting, payroll statement, payroll accounts, part time receptionist, one accounting, office supplies inventory, kelly services, january month, inventory office supplies

About the Employer:
( 0 reviews ) colombo, Sri Lanka

Project ID: #2510792

31 freelancers are bidding on average $40 for this job

javed1705

dear sir please check pm

$30 USD in 1 day
(58 Reviews)
5.4
ruby22

Accountant here and have done similar projects like these before. You can rely on my high quality-timely work. Let's start. Sincerely, Ruby (Accountant, MBA)

$30 USD in 2 days
(19 Reviews)
4.4
malimerchant

Greetings!! Financial Accounting Expert here. Have a look at you inbox for details and COST PLAN. Thanks

$30 USD in 3 days
(42 Reviews)
4.3
zip2012

Choose a professional like me and you will not regret!

$100 USD in 2 days
(0 Reviews)
0.0
alizafarcma

Established in January 2009, Ali Zafar & Co. (AZCO) is a firm of Management Consultants, Auditors deals in Financial Management, Audit & Assurance, Tax Compliance, Corporate Compliance, Management Consultancy & Quality More

$30 USD in 1 day
(0 Reviews)
0.0
tarunhshah

we understand the project to be prepared GL wise and final profit and loss account along with balancesheet to be submitted . we can submit project on day 1 and upon your review or any specific need on day 2 upon rec More

$30 USD in 2 days
(0 Reviews)
0.0
mubeenqureshi

Iam a Professional Accountant recently graduated with fresh knowledge and professional experience as well

$30 USD in 1 day
(0 Reviews)
0.0
ateeq199

I am ACCA qualified and have expertise in accounting,fiance,auditing and taxation.I will do maximum effort to provide the best services.

$30 USD in 2 days
(0 Reviews)
0.0
fomi07

If you would like high quality work with a fast turnaround for a fair price. Contact me. You won't be disappointed.

$30 USD in 2 days
(0 Reviews)
0.0
essmaeel

I am an ACCA Affiliate and CA (ICAEW) Finalist. I am currently working with world's largest accountancy firm PwC. Kindly consider me for the project. Thanks.

$30 USD in 2 days
(0 Reviews)
0.0
StDominic

Hi There, St. Dominic Business Solutions provide what your job requirements are asking, we are Accountants by profession that provide services to clients from local,Australia,Europe and US for 5 solid years, what yo More

$30 USD in 2 days
(0 Reviews)
0.0
jaff86mm

i doing same type of work

$60 USD in 2 days
(0 Reviews)
0.0
Aisha456

hi I m ready to do this project. i have accountant job's experienced

$40 USD in 8 days
(0 Reviews)
0.0
Kamranmustafa

I am an ACCA Member and have qualified ACCA in 2006 in London, UK and have a work experience of 8 years in Finance and Audit.

$30 USD in 1 day
(0 Reviews)
0.0
Ajay1964

More than 20 years of experience as chartered Accountant ,excellent in all type of accounting work.

$30 USD in 1 day
(0 Reviews)
0.0
Shehlasohail

Hi, I can do [url removed, login to view] see PM. Shehla

$45 USD in 1 day
(0 Reviews)
0.0
ErikaKing

Chartered accountant with excessive experience in accounting and finance ready to help. Check PM please.

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

I have been studying accounting and finance for last 8 years. I did my bachelors and now masters in Finance. I am well familiar with the accounting concepts and believe will be able to accomplish task most effectively More

$30 USD in 1 day
(0 Reviews)
0.0
mrwahab70

Hi, I can easily do this.

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

CA and Finance specialist here. Can do this in two hours. Thanks, Rand

$30 USD in 0 days
(0 Reviews)
0.0