Bank statement from LNB Bank for March $2020$

$\backslash$table$[[\backslash$table$[[$DAT$],[$E$]],$DETAILS,DEBIT,CREDIT,$\backslash$table$[[$BALANC$],[$E$]]],[1,$Balance,,,$100000],[2,$Deposit,,$1000,101000],[4,$Cheque X$30,500,,100500],[7,$Cheque X$31,2000,,98500],[7,$Deposit,,$23000,121500],[8,$Cheque X$32,14000,,107500],[10,$Cheque X$33,3000,,104500],[12,$Deposit,,$15000,119500],[14,$Cheque X$34,1000,,118500],[19,$Cheque X$35,4000,,114500],[25,$Deposit,,$80000,194500],[26,\backslash$table$[[$Teskom $($Debit$],[$order$)]],3000,,191500],[27,\backslash$table$[[$D Debtor $($Direct$],[$deposit$)]],,5000,196500],[31,$Bank charges,$500,,196000]]$

Required:

Prepare the following as part of the bank reconciliation process for March $2020.$

Q$\mathrm{.}5\mathrm{.}1$ Cash Receipts Journal. Start with the total before any amendments.

$(5)$

Only the document nr $,$ date, details and bank columns are required.

Q$\mathrm{.}5\mathrm{.}2$ Cash Payments Journal Start with the total before any amendments.

$(8)$

Only the document nr$,$ date, details and bank columns are required.

Q$\mathrm{.}5\mathrm{.}3$ Bank Account in the General Ledger.

$(7)$

Properly balance$/$close off this account.

Q$\mathrm{.}5\mathrm{.}4$ Bank Reconciliation Statement.

$(5)$