Prepare a bank reconciliation using the template provided.

2. The cash account for Valley Bike Co. at October 1,2019 , indicated a balance of $5,140. During October, the total cash deposited was $39,175, and checks written totaled $40,520. The bank statement indicated a balance of $8,980 on October 31,2019 . Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: a. Outstanding checks made as payments to creditors totaled $5,560. b. A deposit of $1,050 representing receipts of October 31 had been made too late to appear on the bank statement. c. The bank had collected for Valley Bike C0.$2,120 on a note left for collection. The face of the note was $2,000. d. A check for $370 returned with the statement had been incorrectly charged by the bank as $730. e. A check for $310 returned with the statement had been recorded by Valley Bike C0. as $130. The check was for the payment of an obligation to Sports Pro CO, on account. f. Bank service charges for October amounted to $25. g. A check for $880 from Overwatch Condos was returned by the bank due to insulficient funds. 1. Prepare a bank reconciliation as of October 31,2019. \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|c|}{ Bank Reconciliation } \\ \hline \multicolumn{2}{|c|}{ [Statement Datel } & \\ \hline Cash balance according to the bank statement & & \\ \hline Adjustments & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline Total Adjustments & & \\ \hline Adjusted balance & & \\ \hline & & \\ \hline Cash balance according to company records & & \\ \hline & & \\ \hline Total Adjustments & & \\ \hline \end{tabular}