I need help preparing a bank reconciliation for December 31, 2022 and posting general journal entries plz

The adjusted cash balance per bank agreed with the cash balance per books at November 30 . The December bank statement showed the following checks and deposits. The bank statement contained two memoranda: 1. A credit of $5,340.00 for the collection of a $5,200.00 note for Sheridan Company plus interest of $170.00 and less a collection fee of $30.00. Sheridan Company has not previously recorded any interest on the note. 2. A debit of $87.50 for an NSF check written by L. Rees, a customer. At December 31 , the check had not been redeposited in the bank. At December 31 , the cash balance per books was $14,280.70, and the cash balance per the bank statement was $22,640.20. The bank did not make any errors, but two errors were made by Sheridan Company. (a) Using the five steps in the reconciliation procedure, prepare a bank reconciliation at December 31. (Round answers to 2 decimal places, e.g. 52.75. List items that increase cash balance first. Reconcile cash balance per bank first.) December 31, 2022 Cash balance per bank statement No. 3471 No. 3472 No. 3474 \begin{tabular}{|r|} \hline 845.70 \\ \hline \end{tabular} \begin{tabular}{|r|r} \hline 1427.70 \\ \hline \end{tabular} The cash records per books for December showed the following. The bank portion of the bank reconciliation for Sheridan Company at November 30, 2022, was as follows. Adjusted cash balance per bank Adjusted cash balance per books