Oh Yum!!! provided the following data concerning the cash records for the months of September and October: September 30 October 31 Book balance 1,900,000 Total cash receipts per book 1,400,000 Total cash disbursements per book 2,400,000 ? 2,100,000 Bank Balance Total charges in bank statement Total credits in bank statement ? 2,500,000 1,200,000 60,000 30,000 40,000 50,000 NSF Check Collections of accounts receivable not recorded by entity and corrected in subsequent month Overstatement of check in payment of salaries corrected in the subsequent month Deposit in transit Outstanding checks 90,000 120,0000 130,000 270,000 260,000 30,000 Required: a. Prepare a four-column reconciliation showing adjusted balances b. Prepare adjusting entries on October 31 2020