i need assistance

Johnson Corporation received a bank statement showing a balance of $14,400 as of October 31,201. The firm's records showed a book balance of $14,016 on October 31. The difference between the two balances was caused by the following items: 1. A debit memorandum for an NSF check from Mike Hart for $418, 2. Three outstanding checks: Check 7017 for $118. Check 7098 for $49, and Check 7107 for $1,500 3. A bank service charge of $14 4. A deposit in transit of $851. The deposit was made on October 31 using the bank's ATM machine after the bank had closed Prepare the adjusted bank balance section and the adjusted book balance section of the bank reconcillation statement. Also prepare the necessary journal entry for the year 20x. Complete this question by entering your answers in the tabs below. Prepare the adjusted bank balance section and the adjusted book balance section of the bank reconciliation statement. Note: Enter debits before credits. Record the outstanding checks. Note: Enter debits before credits. Record the bank service charge. Note: Enter debits before credits. \begin{tabular}{|c|c|c|c|} \hline Date & General Journal & Debit & Credit \\ \hline Oct 31,201 & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular} Record the deposit in transit. Note: Enter debits before credits