The following information relates to the bank account of Doug's Sky Diving Supply Store on June 30. Balance per bank statement Balance per books as of June 30 Outstanding checks: #1007#1008#1009 Deposits in transit Bank service charges NSF check Credit memo for interest earned $5,3279,265 $241 67 597 229 4,111 98 412 16 Error: Check written and recorded by bank as $454 was subtracted from the checkbook as $445. The check was used to pay the telephone bill. Required: Prepare a bank reconciliation as of June 30 . Doug's Sky Diving Supply Store Bank Reconciliation June 30, 20-- Bank statement balance Adjusted bank balance Book balance Adjusted book balance