I need help preparing the bank reconciliation. Please complete it in the same formatting as seen in the SECOND screenshot below. Also, fill out ALL the boxes seen in the second screenshot.

On August 31, 2024, Crane Company had a cash balance per its books of $25,080. The bank statement on that date showed a balance of $17,480. A comparison of the bank statement with the Cash account revealed the following. 1. The August 31 deposit of $15,030 was not included on the August bank statement. 2. The bank statement shows that Crane received EFT deposits from customers on account totalling $2,080 in August. Crane has not recorded any of these amounts. 3. Cheque \#673 for $1,030 was outstanding on July 31. It did not clear the bank account in August. All of the cheques written in August have cleared the bank by August 31, except for cheque #710 for $2,280, and #712 for $2,390. 4. The bank statement showed on August 29 an NSF charge of $269 for a cheque issued by R. Johnson, a customer, in payment of their account. This amount included an $12 service charge by Crane's bank. The company's policy is to pass on all NSF service charges to the customer. 5. Bank service charges of $45 were included on the August statement. 6. The bank recorded cheque #705 for $48 as $84. The cheque had been issued to pay for a building repair. Crane had correctly recorded the cheque. Prapare a bank reconciliation at August 31 . (List items that increase balance as per bonk \& books first.) CRANE COMPANY Bank Reconciliation 5 $ $ $ 5