Bank Reconciliation

Hi sir..

I am not getting my head around the answer key provided by Kaplan 2023-24 kit for the following question:

SEC B – Qn 3 CLER CO

Task 2

You are now dealing with the bank reconciliation as at 31 December 20X7 and a colleague
has provided you with the following information:

Cheques not yet presented 2,400
Cheque returned unpaid by customer’s bank 1,000
Lodgments not yet cleared 3,400
Debit balance per bank statement 1,500

Debit balance per bank statement 1,500
Cheques not yet presented
–––––––
Sub-total
Lodgments not yet cleared
–––––––
Balance per cash book Credit / Debit*
Cheque returned unpaid by customer’s bank
–––––––
Updated balance per bank general ledger Credit / Debit*

What I have done is as follows:

Debit balance per bank statement 1,500 (Debit – Overdrawn)
Cheques not yet presented 2400
Lodgments not yet cleared (3400)

Updated balance per bank general ledger 500 (Credit – Overdrawn)

Cheque returned unpaid by customer’s bank (1000)

Balance per cash book (500) (Debit – Positive bal)

In the provided answer they printed:

Balance per cash book 500 Credit
Updated balance per bank general ledger 1500 Credit

Did I do it correctly ..? If not could you kindly explain where I went wrong..

Thanks in advance..