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..