In: Accounting
Comprehensive Problem 1
Part 1:
The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts.
Kelly Pitney began her consulting business, Kelly Consulting, on April 1, 20Y8. The chart of accounts for Kelly Consulting is shown below:
11 | Cash | 32 | Retained Earnings |
12 | Accounts Receivable | 33 | Dividends |
14 | Supplies | 41 | Fees Earned |
15 | Prepaid Rent | 51 | Salary Expense |
16 | Prepaid Insurance | 52 | Rent Expense |
18 | Office Equipment | 53 | Supplies Expense |
19 | Accumulated Depreciation | 54 | Depreciation Expense |
21 | Accounts Payable | 55 | Insurance Expense |
22 | Salaries Payable | 59 | Miscellaneous Expense |
23 | Unearned Fees | ||
31 | Common Stock |
The post-closing trial balance as of April 30, 20Y8, is shown below:
Kelly Consulting Post-Closing Trial Balance April 30, 20Y8 |
|||
---|---|---|---|
Account No. | Debit | Credit | |
Cash | 11 | 22,100 | |
Accounts Receivable | 12 | 3,400 | |
Supplies | 14 | 1,350 | |
Prepaid Rent | 15 | 3,200 | |
Prepaid Insurance | 16 | 1,500 | |
Office Equipment | 18 | 14,500 | |
Accumulated Depreciation | 19 | 330 | |
Accounts Payable | 21 | 800 | |
Salaries Payable | 22 | 120 | |
Unearned Fees | 23 | 2,500 | |
Common Stock | 31 | 30,000 | |
Retained Earnings | 32 | 12,300 | |
46,050 | 46,050 |
May 3: Received cash from clients as an advance payment for services to be provided and recorded it as unearned fees, $4,500.
May 5: Received cash from clients on account, $2,450.
May 9: Paid cash for a newspaper advertisement, $225.
May 13: Paid Office Station Co. for part of the debt incurred on April 5, $640.
May 15: Recorded services provided on account for the period May 1–15, $9,180.
May 16: Paid part-time receptionist for two weeks' salary including the amount owed on April 30, $750.
May 17: Recorded cash from cash clients for fees earned during the period May 1–16, $8,360.
May 20: Purchased supplies on account, $735.
May 21: Recorded services provided on account for the period May 16–20, $4,820.
May 25: Recorded cash from cash clients for fees earned for the period May 17–23, $7,900.
May 27: Received cash from clients on account, $9,520.
May 28: Paid part-time receptionist for two weeks' salary, $750.
May 30: Paid telephone bill for May, $260.
May 31: Paid electricity bill for May, $810.
May 31: Recorded cash from cash clients for fees earned for the period May 26–31, $3,300.
May 31: Recorded services provided on account for the remainder of May, $2,650.
May 31: Paid dividends, $10,500.
Part 2: Using the attached spreadsheet, post the journal entries from part 1 to a ledger of four-column accounts.
Part 3: Prepare an unadjusted trial balance. If an amount box does not require an entry, leave it blank.
Kelly Consulting Unadjusted Trial Balance May 31, 20Y8 |
||
---|---|---|
Account Title | Debit Balances | Credit Balances |
Journal Entries | |||
Date | Particulars | Dr | Cr |
May-03 | Cash | 4500 | |
To Unearned Fees | 4500 | ||
May-05 | Cash | 2450 | |
To Account Receivable | 2450 | ||
May-09 | Advertising Expense | 225 | |
To Cash | 225 | ||
May-13 | Accounts Payable | 640 | |
To Cash | 640 | ||
May-15 | Accounts Receivable | 9180 | |
To Fees for services | 9180 | ||
May-16 | Salaries payable | 120 | |
Salaries | 630 | ||
To Cash | 750 | ||
May-17 | Cash | 8360 | |
To Accounts Receivable | 8360 | ||
May-20 | Supplies | 735 | |
To Accounts Payable | 735 | ||
May-21 | Accounts Receivable | 4820 | |
To Fees for services | 4820 | ||
Ledger Accounts affected by Journal Entries and entries posted in Ledger Accounts:
Cash | |||||
Date | Particulars | Amount | Date | Particulars | Amount |
Apr-30 | Balance b/d | 22100 | May-09 | By Advertisement | 225 |
May-03 | To Unearned Revenue | 4500 | May-13 | By Accounts Payable | 640 |
May-05 | To Account Receivable | 2450 | May-16 | By Salaries Payable | 120 |
May-17 | By Cash | 8360 | By Salaries | 630 | |
Balance c/d | 35795 | ||||
Total | 37410 | Total | 37410 | ||
Accounts Receivable | |||||
Date | Particulars | Amount | Date | Particulars | Amount |
Apr-30 | Balance B/d | 3400 | May-05 | By Cash | 2450 |
May-15 | To fees for services | 9180 | May-17 | By Cash | 8360 |
May-21 | To fees for services | 8420 | |||
Balance c/d | 10190 | ||||
Total | 21000 | Total | 21000 | ||
Advertisement | |||||
Date | Particulars | Amount | Date | Particulars | Amount |
May-09 | To Cash | 225 | |||
Balance c/d | 225 | ||||
Total | 225 | Total | 225 | ||
Salary | |||||
Date | Particulars | Amount | Date | Particulars | Amount |
Apr-30 | Balance B/d | ||||
To Cash | 630 | May-31 | Balance c/d | 630 | |
Total | 630 | Total | 630 | ||
Supplies | |||||
Date | Particulars | Amount | Date | Particulars | Amount |
Apr-30 | Balance B/d | 1350 | |||
May-20 | To Accounts payable | 735 | |||
May-31 | Balance c/d | 2085 | |||
Total | 2085 | Total | 2085 | ||
Unearned Fees | |||||
Date | Particulars | Amount | Date | Particulars | Amount |
Apr-30 | By Balance B/d | 2500 | |||
By Cash | 4500 | ||||
May-31 | To Balance c/d | 7000 | |||
Total | 7000 | Total | 7000 | ||
Accounts Payable | |||||
Date | Particulars | Amount | Date | Particulars | Amount |
May-13 | To Cash | 640 | Apr-30 | By Balance c/d | 800 |
By Supplies | 735 | ||||
May-31 | To Balance c/d | 895 | |||
Total | 1535 | Total | 1535 | ||
Salary Payable | |||||
Date | Particulars | Amount | Date | Particulars | Amount |
May-13 | To Cash | 120 | Apr-30 | By Balance c/d | 120 |
May-31 | To Balance c/d | 0 | |||
Total | 120 | Total | 120 | ||
Fees For Services | |||||
Date | Particulars | Amount | Date | Particulars | Amount |
May-15 | By Accounts Receivable | 9180 | |||
May-21 | By Accounts Receivable | 8420 | |||
May-31 | To Balance c/d | 17600 | |||
Total | 17600 | Total | 17600 |
ADJUSTED TRIAL BALANCE | ||
May 31,2018 | ||
Account Title | Debit balances | Credit Balances |
Cash in Hand | 35795 | |
Accounts Receivable | 10190 | |
Supplies | 2085 | |
Prepaid Rent | 3200 | |
Prepaid Insurance | 1500 | |
Office Equipment | 14500 | |
Advertisement | 225 | |
Salary | 630 | |
Accumulated Depreciation | 330 | |
Accounts Payable | 895 | |
Unearned Fees | 7000 | |
Fees for Services | 17600 | |
Common Stock | 30000 | |
Retained Earnings | 12300 | |
Totals | 68125 | 68125 |
Hope this answers your question.
Kindly give a thumbs up if it helped.
Good Luck!