Please see attachment need help on creating a Bank Reconciliation and a adjusting entries based on the reconciliation

The December bank statement showed the following checks and deposits. Bank Statement Date 12-1 12-2 12-7 12-4 12-8 12-10 12-15 12-27 12-30 Checks Number 3451 3471 3472 3475 3476 3477 3479 3480 3482 Amount $2,260.40 844.50 1,426.80 1,640.70 1,300.00 2,130.00 3,080.00 600.00 475.50 12-29 3483 1,140.00 12-31 3485 Date 12-1 12-4 12-8 12-16 12-21 12-26 12-29 12-30 Total Deposits Amount $ 2,530.20 1,211.60 2,365.10 2,672.70 2,945.00 2,567.30 2,836.00 1,025.00 18,152.90 530.80 Total $15,428.70 The cash records per books for December showed the following. Cash Payments Journal Amount Date Number $1,640.70 12-20 3482 1,300.00 12-22 3483 2,130.00 12-23 3484 621.30 12-24 3485 3,080.00 12-30 3486 Date 12-1 12-2 12-2 12-4 12-8 Number 3475 3476 3477 3478 3479 12-10 3480 600.00 12-17 3481 807.40 Total Amount $475.50 1,140.00 796.97 350.80 1,889.50 Cash Receipts Journal Date Amount 12-3 $ 1,211.60 12-7 2,365.10 12-15 2,672.70 12-20 2,954.00 12-25 2,567.30 $14,832.17 12-28 2,836.00 12-30 1,025.00 12-31 Total 1,190.40 $16,822.10 The bank statement contained two memoranda: 1. A credit of $3,785.15 for the collection of a $3,640.15 note for Rintala Company plus interest of $160.00 and less a collection fee of $15.00. Rintala Company has not accrued any interest on the note. A debit of $573.83 for an NSF check written by D. Chagnon, a customer. At December 31, the check 2. had not been redeposited in the bank. At December 31, the cash balance per books was $12,916.94, and the cash balance per the bank statement was $20,635.16. The bank did not make any errors, but two errors were made by Rintala Company. (a) Using the four steps in the reconciliation procedure, prepare a bank reconciliation at December 31. (Reconcile the bank balance first and then the book balance.) RINTALA COMPANY Bank Reconciliation December 31, 2014 $ Add: Less: $ $ $ Add: Less: $ $ (b) Prepare the adjusting entries based on the reconciliation. (Hint: The correction of any errors pertaining to recording checks should be made to Accounts Payable. The correction of any errors relating to recording cash receipts should be made to Accounts Receivable.) (Credit account titles are automatically indented when amount is entered. Do not indent manually.) Date. Account Titles and Explanation Dec 31. (To record collection of note receivable by bank) (To record NSF Check) (To correct error in recording check) (To correct error in deposit) Debit Credit