ACG 3131 COMPREHENSIVE PROBLEM #4 Kelly Pitney began her consulting business, Kelly Consulting, on April 1, 2019. During May, Kelly Consulting entered into the following transactions: 3. Received cash from clients as an advance payment for services to be provided and recorded it as uneared 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. Provided services 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. Received cash from cash clients for fees earned during the period May 1-16, 58,360 20. Purchased supplies on account, $735 21. Provided services on account for the period May 16-20, 54,820 25. Received cash from cash clients for fees earned for the period May 17-23, 57.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. Received cash from cash clients for fees earned for the period May 26-31, $3,300. 31. Provided services on account for the remainder of May, $2,650. 31. Kelly withdrew $10,500 for personal use. Instructions: 1. Journalize each of the May transactions in a two-column journal starting on Page 5 of the journal and using Kelly Consulting's ledger 2. Post the journal to a ledger of four-column accounts. Opening balances are already entered 3. Prepare an unadjusted trial balance. Enter a zero (0) in all empty cells. 4. At the end of May. the following adjustment data were assembled. Analyze and use these data to complete parts (5) and (6) Insurance expired during May is $275 Supplies on hand on May 31 are $715. Depreciation of office equipment for May is $330. Accrued receptionist salary on May 31 is $325. Rent expired during May is $1.600. Unearned fees on May 31 are $3,210. 5. Enter the unadjusted trial balance on an end-of-period spreadsheet and complete the spreadsheet. 3. Journalize and post the adjusting entries. Record the adjusting entries on Page 7 of the journal. 7. Prepare an adjusted trial balance. 3. Prepare an income statement, a statement of owner's equity, and a balance sheet. NOTE: The cash account title will not populate in the balance sheet. Maximum grade will still show 100% 2. Journalize and post the closing entries with just two entries. Record the closing entries on Page 8 of the journal. Indicate closed accounts by inserting a line in both Balance columns opposite the closing entry. 10. Prepare a post-closing trial balance. Enter a zero (0) in all empty cells. Submit your completed Excel using the appropriate dropbox