Please answer these are all the given data. Thank you I will give an upvote P112000 ending balance** not beginning balance

1) Presented below is the bank statement of Gold Bank for the month of March. GOLD BANK Quezon city Supra Grocers 888 Congressional Avenue, QC. Account No. 00789 March 31. 2017 DATE DEBIT CREDIT BALANCE 28 Feb P60,000 4 Mar 20,000 80,000 6 Mar Chk No. 301 P10,000 70,000 11 Mar Chk No.302 30,000 40.000 60,000 100,000 12 Mar Chk No. 304 2,000 98,000 18 Mar 80,000 178,000 19 Mar Chk No. 305 40,000 138,000 25 Mar Chk No. 307 6.000 132,000 40,000 172,000 26 Mar 2,000 NSF 170,000 26 Mar Chk No. 299 10,000 160,000 27 Mar Chk No. 306 112,000 48,000 28 Mar 100,000 148.000 31 Mar 400 DM 147,000 LEGEND: DM-Debit Memo CM-Credit Memo NSF - No Sufficient Fund. Note: The P400 DM represents bank service charge. The P100, 000 CM represents the proceeds of the bank loan. Required: 1. Prepare the bank reconciliation for the month of March. 2. Prepare the necessary adjusting journal entries on the books. 2. The following are taken from the books of Supra Grocers: Cash Receipt Cash Payments Mar 02 P20,000 Chk No.301 10,000 Mar 09 40,000 302 30,000 Mar 10 20,000 303 4,000 Mar 16 80,000 304 2,000 Mar 23 40,000 305 40,000 Mar 30 70,000 306 112,000 270,000 307 6,000 308 4,000 P208,000 Beginning balance of cash per general ledger is P112, 000