Help me please with detailed and clear explanation

Problem 2-10 (IAA) benchA AVENA Advent Company kept all cash in a checking account. An examination of the accounting records and bank statement for the month of June revealed the following information: * The cash balance per book on June 30 is P8,500,000. * The cash balance per bank statement on June 30 is P8,200,000. A deposit of P1,000,000 that was placed in the bank's night depository on June 30 does not appear on the bank statement.had ga hamanweb nonveg neel The bank statement showed on June 30, the bank collected note for Advent Company and credited the proceeds of P950,000 net of collection change of P50,000 to the entity's account. * Checks outstanding on June 30 amounted to P300,000 including certified check of P100,000. * Advent Company discovered that a check written in June for P200,000 in payment of an account payable had been recorded as P20,000. * Included with the June bank statement was NSF check for P250,000 that Advent Company had received from a customer on June 26. * The bank statement showed a P20,000 service charge for June. Required: 1. Prepare a bank reconciliation on June 30 using the adjusted balance method. 2. Prepare the adjusting entries on June 30 to correct the accounts of Advent Company