An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank Reconciliation July 31, 20Y4 Cash balance according to company's records $5,400 Adjustments: Outstanding checks $2,590 Error by Chesner Co. in recording Check No. 1056 as $710 instead of $170 540 Note for $8,500 collected by bank, including interest 8,840 Deposit in transit on July 31 (5,500) Bank service charges (70) Total adjustments 6,400 Cash balance according to bank statement $11,800 a. From the data in this bank reconciliation, prepare a new bank reconciliation for Chesner Co., use the format shown in the Lets Review section