Question
I need help with the 10-column worksheet. When I do the balance sheet the difference of my balance numbers do not equal my net income
I need help with the 10-column worksheet. When I do the balance sheet the difference of my balance numbers do not equal my net income when it should. My net income is correct since the books states it is the right income but I just need this last step to complete it and I am completely stuck. now. What am I doing wrong? Thank you. This is what I got and below it is the instructions.
This is my 10 column sheet and as you can see the difference of my balance numbers do not equal my net income.
Kelly Consulting | ||||||||||
Worksheet | ||||||||||
For the Month Ended May 31, 2016 | ||||||||||
Trial Balance | Adjustments | Adjusted T/B | Income Statement | Balance Sheet | ||||||
Account Titles | Dr. | Cr. | Dr. | Cr. | Dr. | Cr. | Dr. | Cr. | Dr. | Cr. |
Cash | 44,195 | 44,195 | 44,195 | |||||||
Accounts Rec. | 8,080 | 8,080 | 8,080 | |||||||
Supplies | 2,085 | b) 1370 | 715 | 715 | ||||||
Prepaid Rent | 3,200 | e) 1600 | 1,600 | 1,600 | ||||||
Prepaid Insurance | 1,500 | a) 275 | 1,225 | 1,225 | ||||||
Office Equipment | 14,500 | 14,500 | 14,500 | |||||||
Accumulated Depreciation | 330 | c) 330 | 660 | 660 | ||||||
Accounts Pay. | 895 | 895 | 895 | |||||||
Salaries Pay. | - | d) 325 | 325 | 325 | ||||||
Unearned Fees | 7,000 | f) 3790 | 3,210 | 3,210 | ||||||
Common Stock | 30,000 | 30,000 | 30,000 | |||||||
Retained Earnings | 12,300 | 12,300 | ||||||||
Dividends | 10,500 | 10,500 | ||||||||
Fees Earned | 36,210 | f) 3790 | 40,000 | 40,000 | ||||||
Salary Exp. | 1,380 | d) 325 | 1,705 | 1,705 | ||||||
Rent Exp. | e) 1600 | 1,600 | 1,600 | |||||||
Supplies Exp. | b) 1370 | 1,370 | 1,370 | |||||||
Depr. Exp. | c) 330 | 330 | 330 | |||||||
Insurance Exp. | a) 275 | 275 | 275 | |||||||
Misc. Exp. | 1,295 | 1,295 | 1,295 | |||||||
86,735 | 86,735 | 7,690 | 7,690 | 87,390 | 87,390 | 6,575 | 40,000 | 70,315 | 35,090 | |
Net Income | 33,425 | 35,225 | ||||||||
40,000 | 40,000 | |||||||||
This is the problem and the instructions for the assignment |
Kelly Pitney began her consulting business, Kelly Consulting, on April 1, 2016. The accounting cycle for Kelly Consulting for April, including financial statements, was illustrated in this chapter. During May, Kelly Consulting entered into the following transactions:
May | 3 | Received cash from clients as an advance payment for services to be provided and recorded it as unearned fees, $4,500. |
5 | Received cash from clients on account, $2,450. | |
9 | Paid cash for a newspaper advertisement, $225. | |
13 | Paid Office Station Co. for part of the debt incurred on April 5, $640. | |
15 | Recorded services provided on account for the period May 1–15, $9,180. | |
16 | Paid part-time receptionist for two weeks’ salary including the amount owed on April 30, $750. | |
17 | Recorded cash from cash clients for fees earned during the period May 1–16, $8,360. |
Record the following transactions on Page 6 of the journal:
May | 20 | Purchased supplies on account, $735. |
21 | Recorded services provided on account for the period May 16–20, $4,820. | |
25 | Recorded cash from cash clients for fees earned for the period May 17–23, $7,900. | |
27 | Received cash from clients on account, $9,520. | |
28 | Paid part-time receptionist for two weeks’ salary, $750. | |
30 | Paid telephone bill for May, $260. | |
31 | Paid electricity bill for May, $810. | |
31 | Recorded cash from cash clients for fees earned for the period May 26–31, $3,300. | |
31 | Recorded services provided on account for the remainder of May, $2,650. | |
31 | Paid dividends, $10,500. |
Required: | |||||||||||||
1. | The chart of accounts is shown in a separate panel and the post-closing trial balance as of April 30, 2016, is shown below.
| ||||||||||||
2. | Post the journal entries on pages 5 and 6 of the journal to the ledger of four-column accounts. | ||||||||||||
3. | Prepare an unadjusted trial balance. | ||||||||||||
4. | At the end of May, the following adjustment data were assembled. Analyze and use these data to complete parts (5) and (6).
| ||||||||||||
5. | (Optional) On your own paper or spreadsheet, enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet. | ||||||||||||
6. |
| ||||||||||||
7. | Prepare an adjusted trial balance. | ||||||||||||
8. | Prepare an income statement, a retained earnings statement, and a balance sheet.* | ||||||||||||
9. |
| ||||||||||||
10. | Prepare a post-closing trial balance.
|
Kelly Consulting
POST-CLOSING TRIAL BALANCE
April 30, 2016
ACCOUNT TITLE | DEBIT | CREDIT | |
---|---|---|---|
1 | Cash | 22,100.00 | |
2 | Accounts Receivable | 3,400.00 | |
3 | Supplies | 1,350.00 | |
4 | Prepaid Rent | 3,200.00 | |
5 | Prepaid Insurance | 1,500.00 | |
6 | Office Equipment | 14,500.00 | |
7 | Accumulated Depreciation | 330.00 | |
8 | Accounts Payable | 800.00 | |
9 | Salaries Payable | 120.00 | |
10 | Unearned Fees | 2,500.00 | |
11 | Common Stock | 30,000.00 | |
12 | Retained Earnings | 12,300.00 | |
13 | Totals | 46,050.00 | 46,050.00 |
.
Step by Step Solution
3.41 Rating (167 Votes )
There are 3 Steps involved in it
Step: 1
Question Trial Balance Adjustments Adjusted TB Income Statement Balance Sheet Account Titles Dr Cr D...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started