A. Use the spreadsheet to post the May transactions from the journal to a ledger of four-column accounts. B. Add the appropriate posting reference to the journal. 3. Prepare an unadjusted trial balance. Accounts with zero balances can be left blank. 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. (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. Find a blank end-of-period work sheet in the Excel spreadsheet you previously downloaded. 6. A. Journalize the adjusting entries on Page 7 of the journal. Refer to the chart of accounts for the exact wording of the account titles. CNOW journals do not use lines for journal explanations. Every line on a journal page is used for debit or credit entries. CNOWjournals will automatically indent a credit entry when a credit amount is entered. B. Post the adjusting entries to the ledger, inserting balances in the accounts affected. C. Add the appropriate posting reference to the adjusting entries in the journal in CengageNOW. 7. Prepare an adjusted trial balance. Accounts with zero balances can be left blank. Kelly Consulting POST-CLOSING TRIAL BALANCE April 30, 20 Y5 ACCOUNT TITLE 1 Cash 2 \begin{tabular}{|r|r|} \hline DEBIT & \multicolumn{1}{|c|}{ CREDIT } \\ \hline 22,100.00 & \\ \hline 3,400.00 & \\ \hline 1,350.00 & \\ \hline 3,200.00 & \\ \hline 1,500.00 & \\ \hline 14,500.00 & \\ \hline & 330.00 \\ \hline & 800.00 \\ \hline & 120.00 \\ \hline 46,050.00 & 4,500.00 \\ \hline \end{tabular} Kelly Pitney began her consulting business, Kelly Consulting, on April 1,20Y5. 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 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 116,$8,360. Record the following transactions on Page 6 of the journal: May 20 Purchased supplies on account, $735. 21 Provided services on account for the period May 1620,$4,820. 25 Received 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. 3. Prepare an unadjusted trial balance. Accounts with zero balances can be left blank. 7. Prepare an adjusted trial balance. Accounts with zero balances can be left blank
