Bank Reconciliation On July 31, Arthur Company's Cash in Bank account had a balance of $8,112.62. On that date, the bank statement indicated a balance of $10,170.62. A comparison of returned checks and bank advices revealed the following: 1. Deposits in transit July 31 amounted to $3,316.12. 2. Outstanding checks July 31 totaled $1,251.12. 3. The bank erroneously charged a $215.00 check of Solomon Company against the Arthur bank account. 4. A $15 bank service charge has not yet been recorded by Arthur Company. 5. Arthur neglected to record $4,000.00 borrowed from the bank on a ten percent six-month note. The bank statement shows the $4,000.00 as a deposit. 6. Included with the returned checks is a memo indicating that J. Martin's check for $610.00 had been returned NSF. Martin, a customer, had sent the check to pay an account of $660.00 less a $50 discount. 7. Arthur Company recorded a $107.00 payment for repairs as $1,070.00. Required a. Prepare a bank reconciliation for Arthur Company at July 31. b. Prepare the journal entry (or entries) necessary to bring the Cash in Bank account into agreement with the reconciled cash balance on the bank reconciliation. Note: Do not round answers enter using two decimal places, when needed. Bank reconciliation Journal entries ARTHUR COMPANY Bank Reconciliation July 31 Ending balance from bank statement $ 10,170.62 Balance from general ledger Add: Deposits not credited by bank 3,316.12 Add: Proceeds of note Add: Bank errar Solomon Company check Check 1,070 x charged against Arthur Company's account 215 recort 107 * 13,701.7 * Less: Cutstanding checks 1,251.12 Less: Service charge Less: NSF Check Reconciled cash balance $ 12,150.62 Reconciled cash balance $ 8.112.62 4,000 963 3,000 x 15 610 $ 12.150.62