Question $2-$ Bank Reconciliation $(25$ marks$)$

The following information was available for Rachel Consulting Ltd$.$ for the month ended April $30,2023.$

$($a$)$ On April $30,2023,$ the Cash account of Rachel Consulting Ltd$.$ had a balance of $$8,281.$

$($b$)$ On April $30,2023,$ the bank statement indicated a balance of $$18,390.$

$($c$)$ The bank reported the collection $($credit memo$)$ of an accounts receivable for Rachel Consulting Ltd$.$ from XYZ Company in the amount of $$11,400.$ The bank deducted a service fee of $$75$ on this transaction. This transaction had not been recorded in the company's accounting records.

$($d$)$ Cheque # $3215$ for $$559\mathrm{.}50$ and Cheque # $3201$ for $$1253\mathrm{.}50,$ both written and recorded in the accounting records for April were not among the cancelled cheques returned by the bank. In addition, of the two cheques $-$ Cheque #$3107$ for $$7,992\mathrm{.}50$ and Cheque #$3121$ for $$836$ that were outstanding on March $31$ st when the last bank reconciliation was completed, only Cheques #$3107$ was returned with the April cancelled cheques. Cheque #$3121$ was not returned.

$($e$)$ When April's cheques were compared with entries in the accounting records it was found that Cheque #$3199$ had been correctly written for $$2,040$ to pay for merchandise inventory but was erroneously entered in the accounting records as $$2,400.$

he bank statement did not include a deposit of $$2,146\mathrm{.}50$ made by achel Consulting Ltd$.$ on April $30$ that was deposited in the night oository.

$1.$ Prepare the bank reconciliation for April $30,2023.$

$2.$ Prepare the journal entries