1. Prepare a bank reconciliation using a company's bank statement and cash account. 1. Prepare a bank reconciliation using a company's bank statement and cash account. 37 Required: 38 Prepare a bank reconciliation for June using the bank statement and T-account above and the information below. 39 Additional information: 40 There were no deposits in transit or outstanding checks at May 31. 41 Note: Columns C and F must be entered as positive values. In columns B \& E, use cell references 42 to the appropriate items from the list below. List "Deductions" in chronological order (earliest item first). \begin{tabular}{|l|l|l|} \hline 43 & Bank Error & NSF Check \\ \hline 44 & Deposits in Transit & Outstanding Checks \\ \hline 45 & EFT from Customer & Recording Error \\ \hline 46 & Interest Earned & Service Charge \\ \hline 47 & & \\ \hline \end{tabular}