Prepare a bank reconciliation statement for Dr.Plunkett using the following information. Date the statement April 1, 20__. Cash account $2140 and March 31 bank statement $2012. Deposit entered in books on March 30 was not taken to the bank until March 31(amount $530). The bank sent a credit memo for $215 for interest earned on Canada Savings Bonds. The amount is shown on the account. However the memo has not yet been received, Bank service charges $6. A patients cheque for $50.00, included in the Marc h 27 deposit has been charged back to the bank on the statement as NSF. The patient is J.Wren Cheque no.502 was made to cash for $35 to reimburse the petty cash; this cheque is recorded in the cash payment journal as $53. The following cheques were returned by the bank with March statement: no.521 to R. Smith for $10:no.523 to J. Jones Ltd. For $50; no.524 to Metric Limited for $100 (certified on March 27); no.525 to P. Brown for $75; and no.526 to J. Smith and Company for $90.

Example (the picture below):

J.E. PLUNKETT M.D. Bank Reconciliation Statement January 13,20 Balance as per bank statement, January 13 Add: Deposit of January 11 not recorded by bank $2,769.20 543.21 $3,312.41 $ 732.60 1,072.91 427.50 2,233.01 $1,079.40 Deduct Outstanding Cheques: #236 S.O.S. #239 Jones Medical Services #244 Receiver General of Canada Adjusted Bank Balance Balance as per Chequebook, January 13 Add: Interest on term deposit Deduct: Debit memo for safety deposit box rental Bank interest on demand loan Monthly service charge NSF Cheque of Thomas Bell Adjusted Chequebook balance $1,326.50 127.50 $1,454.00 5.70 200.00 3.50 165.40 374.60 $1.079.40