Accounting Question

Prepare, in good form, the July 31, 2017 Bank Reconciliation for Alpha Alpha Company had the following banking information from its bank statement dated July 31, 2017: $3,350 Bank Reconciliation Cash Balance per Bank (7/3/17) Bank Service Charges Collection of Note Receivable from Mr. 75 3,145 Yankee including the interest of $145 Customer (Mr. Welcher) returned ch 225 NSF The following additional information was determined from a review of the cash payments & receipts and the cheque register for Alpha Company: 1. The following cheques had not cleared the bank as paid: Date | Ck # 5/25/171005 Bravo Office Supply Store 7/15/171025 Zulu Electric Company 7/30/171030 Bravo Office Supply Store $250 1,900 250 2. The following information was recorded in Alpha's cash receipts ledger and have not yet been recorded in the bank statements: Date Item Amount 5/25/17Store Cash Sales 7/31/17Store Cash Sales 7/31/17 Cheques From Store Sales 7/31/17 Cash Balance per General Ledger $200 200 5,500 4,005 (7/31/17)