Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Superior Printing, Incorporated has provided you with its bank statement and Cash T-Account for the month of June. The Controller has asked you to prepare
Superior Printing, Incorporated has provided you with its bank statement and Cash T-Account for the month of June. The Controller has asked you to prepare the Bank Reconciliation for the month of June. File Home Insert Draw Formulas Data Review View Help A1 \begin{tabular}{|c|c|c|c|c|} \hline & A & & C & D \\ \hline 20 & \multicolumn{4}{|c|}{ Cash } \\ \hline 21 & June 1 Balance & 18,500 & & \\ \hline 22 & June 13 deposit & 10,000 & 440 & Check \#100 \\ \hline 23 & June 22 deposit & 35,000 & 1,200 & Check \#101 \\ \hline 24 & June 29 deposit & 17,000 & 500 & Check \#102 \\ \hline 25 & June 30 deposit & 28,000 & 1,200 & Check \#103 \\ \hline 26 & & & 250 & Check \#104 \\ \hline 27 & & & 80 & Check \#105 \\ \hline 28 & & & 9,800 & Check \#106 \\ \hline 29 & & & 350 & Check \#107 \\ \hline 30 & & & 4,600 & Check \#108 \\ \hline 31 & & & 770 & Check \#109 \\ \hline 32 & & & 4,900 & Check \#110 \\ \hline 33 & & & 700 & Check \#111 \\ \hline 34 & & & 920 & Check \#112 \\ \hline 35 & & & 600 & Check \#113 \\ \hline 36 & June 30 Balance & 82,190 & & \\ \hline 37 & & & & \\ \hline 38 & Required: & & & \\ \hline \end{tabular} 39 Prepare a bank reconciliation for June using the bank statement and T-account above and the information below. 42 Additional information: 43 There were no deposits in transit or outstanding checks at May 31. 44 Here are some tips for using Excel: Cell Reference: Allows vou to refer to data from another cell in the worksheet. If vou entered "=B5" into a blank cell
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started