PR7SD Dank reconciation anu entries Obj. 5 The cash account for Stone Systems at July 31, 2045, indicated a balance of $17,750. The bank statement indicated a balance of $33,650 on July 31, 2015. Comparing the bank statement and the accompanying canceled checks and memos with the records reveals the following reconciling items: EXCEL TEMPLATE A. Checks outstanding totaled 517,865. B. A deposit of $9,150, representing receipts of July 31, had been made too late to appear on the bank statement CHEAL LINE C. The bank had collected $6,095 on a note left for collection. The face of the note was $5.750 D. A check for $390 returned with the statement had been incorrectly recorded by Stone Systems as 5930. The check was for the payment of an obligation to Holland Co. for the purchase of office supplies on account. E. A check drawn for $1.810 had been incorrectly charged by the bank as 51,180. E Bank service charges for July amounted to $80. Instructions Alignment Number Clipboard Font N36 EL F G K D B Bank Reconciliation July 31, 2015 Cash balance according to bank statement Adjustments Total adjustments Adjusted balance AA 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 352 36 37 Cash balance according to company's records Adjustments Total adjustments Adjusted balance July 31 Pr. 7-38 Read 1 e e hp July 31 35 2. 36 37 38 39 40 41 42 43 44 45 3. 46 31 Amount to be reported on July 31 2015, balance sheet 48