Chapter 9 case 3 Aloha , Following the information and instructions of the book , make the required report in Excel

Adjusting Entries Chapter 9 Chapter 9 Case 3 ALOHA PROPERTIES n Chapter 8, you modified your Quic Make a copy of that file and use Event # Date kBooks Accountant file for Aloha Properties that copy to record the following transaction Business Event s: 2/29/14 Accrue interest expense of $22,555 on the $3,875,000 loan to a new corporation 3/1/14 2/29/14 account: Accrued Expenses. Prepare reversing entry of the preceding interest accrual. Accrue interest income of $210 on short-term investments. 4 2/29/14us prepaid insurance for january and Febnuary 2014 to insuranceEVIC expense. February 2014. on 2/5/14, 2/25/14, and 2/26/14, respectively, to unearned revenue 2/29/14 Record depreciation expense of $34,612 for the months of January and 6 2/29/14 Reclassify the deposits received from American Airlines, UCLA, and UCB (a new other current liability account). 7 2/29/14 Prepare a reversing entry for the unearned reclassification. 8 2/29/14 The Bank of Hawaii bank statement as of 2/29 shows an ending balance of $115,292.39. All checks cleared the bank account except Checks 998-1002. All deposits cleared the bank account except for the 2/26 deposit of $10,750. The bank statement reports interest income of $175 and bank charges of $35. Requirements: Perform a reconciliation on the checking account, and then print a sum- mary bank reconciliation as of February 29, 2014. 1 2 Print a Profit& Loss Standard report for the month of February 2014. 3 Print a Balance Sheet Standard report as of February 29, 2014. 4 Print journal entries recorded February 29 through March 1, 2014(no memo field, and make sure that you filter the transaction type for journalitems only)