The Following Information Relates to the Bank Account of Doug's

The following information relates to the bank account of Doug's Sky Diving Supply Store on June 30. $\begin{array}{llr} \text { Balance per bank statement } &&\$5,327\\ \text {Balance per books as of June 30 } &&9,265\\ \text {Outstanding checks: } &\\ \# 1007 & \$ 241 \\\# 1008 & 67 \\\# 1009 & 597\\\text { Deposits in transit } & 229 \\& 4,111 \\\text { Bank service charges } & 98 \\\text { NSF check } & 412 \\\text { Credit memo for interest earned } & 16 \end{array}$

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.