Prepare four-column reconciliation for 12/31 adjusted balance format of bank and book with proof of receipts and disbursements

Data for Amiable Company are shown below: 12/31/2018 11/30/2018 Bank account balance P 689,085 P 535,410 Cash account balance 201,425 82,350 Bank collection from company customers 404,500 359,075 NSF checks returned by bank 41,250 Outstanding checks 150,560 138,590 Bank service charges 3,000 3,600 Deposits in transit 64,400 41,005 Additional information: NSF checks were redeposited in the same month. No entries made to take up the return and redeposit The bank statement and the company's cash records show the following totals: Total book receipts in December P 1,182.260 Total bank debits in December 1,091,865 Required: Prepare a four-column reconciliation adjusted balance format with proof of receipts and disbursements