Spreadsheet PR 7-3A Fill In The Blanks

AutoSave Off H D - File Home Insert Draw Page Layout Formulas Data Review View Help Search Share Comments N44 X fic A B C E F G H I J K L M N O P Q R S T U V W X Y Z AA AB L A Key Code: [Koy codohore] 8 Instructions 9 Answers are entered in the cells with gray backgrounds. 10 Cells with non-gray backgrounds are protected and cannot be edited. 11 An asterisk (*) will appear to the left of an incorrect entry. Pala Medical Co. Bank Reconciliation June 30, 2011 Cash balance according to bank statement Add: Deposit in transit on June 30 Bank error in charging check as $915 instead of $195 Total additions Deduct: Outstanding checks Adjusted balance Cash balance according to company's records Add: Note collected by bank, including $1.500 interest Deduct: Error in recording check Bank service charges Total deductions Adjusted balance June 30 Cash Notes Receivable Interest Revenue 30 Accounts Payable - Skyline Supply Co. Miscellaneous Expense Cash 44 3. Amount to be reported on June 30, 20Y1, balance sheet Pr. 7-3A + Ready 0 - -_ _ + 70% 1 @ @ @ @ hp x o p S w 9 9 - ENG 10:05.2016 Windows Photo Viewer File Print E-mail Burn Open Bank Reconciliation and Entries Obj. 5 The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $166,436. The bank statement indicated a balance of $195,688 on June 30, 20Y1. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: a. Checks outstanding totaled $19,427. b. A deposit of $12,300, representing receipts of June 30, had been made too late to appear on the bank statement. c. The bank collected $26,500 on a $25,000 note, including interest of $1,500. d. A check for $4,000 returned with the statement had been incorrectly recorded by Pala Medical Co. as $400. The check was for the payment of an obligation to Skyline Supply Co. for a purchase on account. e. A check drawn for $195 had been erroneously charged by the bank as $915. f. Bank service charges for June amounted to $55. Instructions 1. Prepare a bank reconciliation. Answer + Check Figure: Adjusted balance: $189,281 2. Journalize the necessary entries. 3. If a balance sheet were prepared for Pala Medical Co. on June 30, 2011, what amount should be reported as cash? 1 @ @ @ @ hp I 5 CX S W 9 x n o p 9 - ENG 11:09 AM I 11:09 AM 10/11/2019