This question continues on from question 1 above. It is two months later.

The bank reconciliation for GrimesTimes for April 2023 is shown below:

Bank reconciliation as at 30 April 2023:

Bank reconciliation as at 30 April 2023: Cash balance as per bank statement 30 April 2023

Bank reconciliation as at 30 April 2023: Add: outstanding deposits

Bank reconciliation as at 30 April 2023:

Bank reconciliation as at 30 April 2023: Less: Unpresented cheques

Bank reconciliation as at 30 April 2023: - Chq 36

Bank reconciliation as at 30 April 2023: - Chq 40

Bank reconciliation as at 30 April 2023: - Chq 41

Bank reconciliation as at 30 April 2023: Cash balance as per ledger

The May 2023 bank statement appeared as follows:

Date:
Description:
Deposit:
Withdrawal:
Balance:

Date: 1/05/2022
Description: Opening balance
Deposit:
Withdrawal:
Balance: $52,876.00

Date: 1/05/2022
Description: Deposit
Deposit: $150
Withdrawal:
Balance: $53,026.00

Date: 2/05/2022
Description: Deposit
Deposit: $400
Withdrawal:
Balance: $53,426.00

Date: 2/05/2022
Description: Cheque 36
Deposit:
Withdrawal: $108
Balance: $53,318.00

Date: 2/05/2022
Description: Cheque 41
Deposit:
Withdrawal: $700
Balance: $52,618.00

Date: 3/05/2022
Description: Deposit
Deposit: $3,250.00
Withdrawal:
Balance: $55,868.00

Date: 3/05/2022
Description: Cheque 43
Deposit:
Withdrawal: $540
Balance: $55,328.00

Date: 6/05/2022
Description: Cheque 44
Deposit:
Withdrawal: $3,800.00
Balance: $51,528.00

Date: 9/05/2022
Description: Deposit
Deposit: $6,500.00
Withdrawal:
Balance: $58,028.00

Date: 9/05/2022
Description: Cheque 46
Deposit:
Withdrawal: $760
Balance: $57,268.00

Date: 12/05/2022
Description: Deposit
Deposit: $2,455.00
Withdrawal:
Balance: $59,723.00

Date: 14/05/2022
Description: Deposit
Deposit: $3,236.00
Withdrawal:
Balance: $62,959.00

Date: 14/05/2022
Description: Cheque 47
Deposit:
Withdrawal: $500
Balance: $62,459.00

Date: 16/05/2022
Description: Deposit
Deposit: $4,250.00
Withdrawal:
Balance: $66,709.00

Date: 19/05/2022
Description: Deposit
Deposit: $750
Withdrawal:
Balance: $67,459.00

Date:
Description:
Deposit:
Withdrawal:
Balance: $67,459.00

Date: 25/05/2022
Description: Deposit
Deposit: $4,250.00
Withdrawal:
Balance: $71,709.00

Date: 25/05/2022
Description: Cheque 49
Deposit:
Withdrawal: $2,650.00
Balance: $69,059.00

Date: 28/05/2022
Description: Deposit
Deposit: $2,076.00
Withdrawal:
Balance: $71,135.00

Date: 29/05/2022
Description: Cheque 50
Deposit:
Withdrawal: $200
Balance: $70,935.00

Date: 30/05/2022
Description: Deposit
Deposit: $2,100.00
Withdrawal:
Balance: $73,035.00

Date: 31/05/2022
Description: Bank fees
Deposit:
Withdrawal: $30
Balance: $73,005.00

Date: 31/05/2022
Description: Interest
Deposit: $17.23
Withdrawal:
Balance: $73,022.23

Date: 31/05/2022
Description: Closing balance
Deposit:
Withdrawal:
Balance: $73,022.23

GrimesTimess accounting records for May 2023 showed the following:

Cash payments journal:: Date
Cash receipts journal:: Chq number

Cash payments journal:: 1/05/2022
Cash receipts journal:: 42

Cash payments journal:: 2/05/2022
Cash receipts journal:: 43

Cash payments journal::
Cash receipts journal::

Cash payments journal:: 2/05/2022
Cash receipts journal:: 44

Cash payments journal:: 4/05/2022
Cash receipts journal:: 45

Cash payments journal:: 8/05/2022
Cash receipts journal:: 46

Cash payments journal:: 10/05/2022
Cash receipts journal:: 47

Cash payments journal:: 17/05/2022
Cash receipts journal:: 48

Cash payments journal:: 22/05/2022
Cash receipts journal:: 49

Cash payments journal:: 24/05/2022
Cash receipts journal:: 51

Cash payments journal:: 31/05/2022
Cash receipts journal:: 52

Cash payments journal::
Cash receipts journal::

The current balance in the bank ledger account (after the above receipts and payments have been entered) on 30 September 2022 is: $51,918 + $26,198 - $16,494.50 withdrawals = $61,621.50.

Dylan Grimes has come to you for help, as he is having trouble reconciling the bank account as at 31 May 2023

The bank did not make any errors.

an Excel worksheet, prepare the bank ledger account (using the T-Account format) for May 2023, to determine the balance in the account after the above journal entries have been recorded and posted. (2 marks)