The cash account for Coastal Bike Co. at Octobet 1,20Y9, indicaled a balance of $,140. During October, the total cash deposited was $39,175, and checks written totaled $40,520. The bank statement indicated a balance of $8,900 on October 31,20Y9. Companing the bank statement, the canceled checks, and the accomparying memos with the reconds fevealed the following reconciling items: a. Checks outstanding totaled $3.260. b. A deposit of $2,450 representing receipts of October 31 had been made too tate to appear on the bank statopent: c. The bank had collected for Coastal Bike Co. $5,300 on a note left for collection. The face of the note was $5,000. d. A check for $460 returned with the statement had been incorrectly charged by the bank as $640. e. A check for $430 retumed with the statement had been recorded by Coastal Bke Co. as $340. The check was for the payment of an obligation to Rack Pro Co. on accourt. 1. Bank service charges for October amounted to $50. a. Acheck for $605 from Bay View Condos was returned by the bank due to insutficient funds Aequired: 1. Prepare a bani reconcilation as of October 31,20 ro. 2 Journalize the necessary enties: 3. It a batance sheet were prepared for Coastal Bike Ca on Octaber 31,20rg, what amount should be reported as cash? Coastal Bike Co. Score: 73/118 Bank Reconciliation October 31,20Y9 \begin{tabular}{|c|c|c|c|c|} \hline 1 & Cash balance according to bank statement & & & $8,980.002 \\ \hline 2 & Add: Deposit in transit on October 31 & & $2,450.00 & \\ \hline 3 & Add: Bank error in charging check as $640 instead of $460 & & 180.00 & \\ \hline 4 & & & & 11,610.00 \\ \hline 5 & Deduct: Outstanding checks & & & 3,260.00 \\ \hline 6 & Adjusted balance & v & & $8,350.00 \\ \hline 7 & 5 & & & \\ \hline 8. & Cash balance according to company's records & & & $3,795.00 \\ \hline 9 & Add: Note collected by bank, including $300 interest & & & 5,300.00 \\ \hline 10 & Deduct: Error in recording check & & $90.00 & \\ \hline 11 & Deduct: Bank service charges & & 50.00 & \\ \hline 12 & Deduct: Check returned because of insufficient funds & & 605.00 & \\ \hline 13 & Adjusted balance & & & 8,350.00 \\ \hline 14 & & & & \\ \hline \end{tabular} General Joumal Shadod colls havo feedba \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & & & JOURALAL & & & Score: 69/87 & ACCO & UNTING EQU. & IION \\ \hline & DATE & DESCRIPTION & & POSt Rer. & DeAiT & CRcoir: & ASSETS & Leventis & Equiry: \\ \hline 1 & 0ct312c & Cash & & & 5,300002 & & +2 & & \\ \hline 2 & & Notes Receivable & & & & 5,000002 & 1 & & \\ \hline 1 & & Interest Revenue & & & & 300002 & & & \\ \hline 4 & 0a+312 & 1 & & & 50.002 & & & & \\ \hline s & & Cash & & & & 50.00 & 1 & & \\ \hline 6 & & Accounts Payable-Rack Pro Co. & & & 90002 & & & 4 & \\ \hline , & & Cash & & & & 9000 & & & \\ \hline \end{tabular}