Conditional Formatting A. 3. %. Format as Table Font Alignment Number Calls Editing Cell Styles CH Update To keep up-to-date with security updates, fixou, and Improvements, choose Che... 4x fx 8 C D E G H Pala Medical Co. Bank Reconciliation June 30 2041 Cash balance according to bank statement Add: Total additions Deduct: Adjusted balance Cash balance according to company's records Add: Deduct Total deductions Adjusted balance June 30 30 Amount to be reported on June 30, 20Y1, balance sheet PETA WON Preview File Edit View Go Tool Window Help PR.7-3A data.png @ @ 0 Search PR 7-3A Bank Reconciliation and Entries 13 12 15 16 17 16 19 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, 2011. 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 21 23 23 26 28 30 31 32 33 34 1. Prepare a bank reconciliation 30 37 be 30 40 40 42 43 Check Figure: Adjusted balance: $189,281 2. Journalize the necessary entries. of a balance sheet were prepared for Pala Medical Co. on June 30, 2011, what amount should be reported as cash? 45 40 47 49 UUTUU VIEU WITOV S CULTURE the Esc button (top left) on your keyboard. To fast forward or