Exercise 1-12 Based on the following information, prepare a bank reconciliation statement for ROSAL COMPANY as of Dec. 31, 2019. Use the bank to book format. 1. Balance per bank statement, Dec. 31, 2019, P85,938.46. 2. Balance per books, Dec. 31, 2019, P58,489.12. 3. Outstanding checks, Dec. 31, P31,108.42. 4. Receipts of Dec. 31, 2019 deposited Jan. 5, 2015, P5,317.20. 5. Service charges for Nov. per bank DM of Dec. 15, 2019, P203.85 6. Proceeds of bank loan, Dec. 15, 2019, omitted from the company's books, P9,875.00. 7. Deposit of Dec. 23, 2019 omitted from the bank statement, P2,892.41. 8. Check of Rome Products Co., returned by the bank for lack of countersignature. No entry was made on the books to record the return, P417.50. 9. Error on bank statement in entering deposit of Dec. 16, 2019: Correct amount P3,182.40 Entered as 3,181.40 10. Check no. 3917 of Camila Company charged by bank in error to Rosal Company, P2,690.00. 11. Proceeds of Natalia Company note, collected by bank on Dec. 10, 2019, not entered in the cashbook: Principal P2,000.00 Interest 20.00 Collection charges 5.00 12. Erroneous DM of Dec. 23, 2019 charging the company's account with the payment of a bank loan, which was actually paid by check that day, P5,000. 13. Error on bank statement in entering deposit of Dec. 4, 2019: Correct amount P4,817.10 Entered as 4,807.10 14. Deposit of Corazon Company last Dec. 6, 2019, credited in error to Rosal Company, P1,819.20. REQUIRED: 1. Prepare an informal set of bank reconciliation statement as of Dec. 31, 2019. 2. Prepare a formal bank reconciliation statement as of Dec. 31, 2019 using the bank to book format. 3. Prepare adjusting entries (individual) to update the books as of Dec. 31, 2019. Exercise 1-12 Based on the following information, prepare a bank reconciliation statement for ROSAL COMPANY as of Dec. 31, 2019. Use the bank to book format. 1. Balance per bank statement, Dec. 31, 2019, P85,938.46. 2. Balance per books, Dec. 31, 2019, P58,489.12. 3. Outstanding checks, Dec. 31, P31,108.42. 4. Receipts of Dec. 31, 2019 deposited Jan. 5, 2015, P5,317.20. 5. Service charges for Nov. per bank DM of Dec. 15, 2019, P203.85 6. Proceeds of bank loan, Dec. 15, 2019, omitted from the company's books, P9,875.00. 7. Deposit of Dec. 23, 2019 omitted from the bank statement, P2,892.41. 8. Check of Rome Products Co., returned by the bank for lack of countersignature. No entry was made on the books to record the return, P417.50. 9. Error on bank statement in entering deposit of Dec. 16, 2019: Correct amount P3,182.40 Entered as 3,181.40 10. Check no. 3917 of Camila Company charged by bank in error to Rosal Company, P2,690.00. 11. Proceeds of Natalia Company note, collected by bank on Dec. 10, 2019, not entered in the cashbook: Principal P2,000.00 Interest 20.00 Collection charges 5.00 12. Erroneous DM of Dec. 23, 2019 charging the company's account with the payment of a bank loan, which was actually paid by check that day, P5,000. 13. Error on bank statement in entering deposit of Dec. 4, 2019: Correct amount P4,817.10 Entered as 4,807.10 14. Deposit of Corazon Company last Dec. 6, 2019, credited in error to Rosal Company, P1,819.20. REQUIRED: 1. Prepare an informal set of bank reconciliation statement as of Dec. 31, 2019. 2. Prepare a formal bank reconciliation statement as of Dec. 31, 2019 using the bank to book format. 3. Prepare adjusting entries (individual) to update the books as of Dec. 31, 2019