Please add working notes

Your bank manager has requested an explanation regarding your bank account. He has advised you are overdraft by $120,000 as of today - January 31, 2022 and wants the negative balance covered immediately. You respond that your general ledger shows a cash balance of $420,000. Knowing that the only way to solve the problem is to prepare a bank account reconciliation as at January 31, 2022 you have your staff find and present the following information for analysis:

Loan payment processed by bank January 27 - $483,000

Customer lockbox cash received by bank January 30 not in company records - $88,000

Cheques processed by bank and company during month - $437,000

Cheques issued by company not yet cleared bank - $298,000

January 31 EFT supplier payments not processed by bank until February 1 - $56,000

Bank loan interest processed January 28 by bank not in company records - $19,000

Company cash transfer January 30 processed by bank on February 1 - $215,000

Company cash deposit made on last day after banking hours - $265,000

Deposits processed by company and bank - $444,000

Prepare the detailed bank reconciliation to advise the bank as to what the "actual"

balance is.