Prepare the bakk feconciliation for Widerness Ruociates at October 31, 2018. (Nwayase cell references and formulas where appropriate to receive full credit. If you copylpaste from the lnstructionstab you will be marked wione fnter 2 all amounts as poshtive values. Do not usea minus sin or parentheres for any valuesto be subtracted.) Journalize the entries based on the bank reconcitiation. (Aways use cell references and formulas where appropriate to recelve full credic, If you copy/paste from the instructions tab or if you type the numbers in, you will be marked wrong. For dollar amounts, use cell references on the bank reconciliation. Enter all amounts as positive values. Enter debits first, then credits.) \begin{tabular}{|l|l|l|l|} \hline Date & \multicolumn{1}{|c|}{ Account/Explanation } & Debit & \multicolumn{1}{|c|}{ Credit } \\ \hline & & & \\ \hline & & & \\ \hline & To record note recelvable collected by the bank. & & \\ \hline & & & \\ \hline & To record interest corned an the note receivable. & & \\ \hline & & & \\ \hline & To record bank service fee. & & \\ \hline & & & \\ \hline & & & \\ \hline & Torecord NSF check returned by bank. & & \\ \hline & & & \\ \hline & Torecord poyment of utilities by EFT. & & \\ \hline \end{tabular} 1. For all dates, enter the date in mm/dd/hm format. HINTS 2. For cell references, begin the formula with an equals sign ( 0 ), click on the balance in the INTERANSWES1 tab, and press the enter key. 3. When entering tabels or accounts, click the arrow on the right side of the cell to select the appropriate label or account. Internal Control and Cayh Unis facel for a Bank heconciliation Lorl Anders ef Wilderness Assodates is getting ready to prepare the Oatober bank reconoliation. The qush balance on the books of Wilderness Assodintes on Oeteber 31 is $3,546. Leri reviewt the bank statemert, and notes the cash balance at October 31 of $2,445. The bank statement also reveals that the bank cellected a note receivable on behalf of Widerness Associates - the prindpal was $1,500 and the interest was 515 . One customer's dheck for $29 was returned by the bank for insuffient Ands. Two addional items on the bank statement were the monthy 6 F for the utilitia, \$250, and the bank service fee of $12. Lori notes that the cash depout made on October 31 of $3,390 does not appear on the statecent, and that three cheds totaling $975 had not deared the bank accounk when the bank statement was prepared. Eequirements 1 Frepare the bank remencliation for Wiberness Assodates at Odober 31, 2018. Ponslble Poines a. Format appropriate ofllis with doliar signs, underlinet, and bouble undertinet. 11 b. Use Excel formulas to caloulate wibtotals and totals. c. Inter all amounts as posative valuet. Do not ise a minut sirn or parencheses for any values to be nubtracted. 2 Journalive the entries based on the bank reconaliation 2. For dollar amounts, wse call references on bark recondiliation. b. Enter all amounts as positive values. De net ise a minsis sign or parentheses for any values to be subtracted. c. Ener debits frit, then creds. tract skits 1 Une ixnl's data validation to enter deso igetions into the bank reconolation, and accouncs into the pournal entries. 2 Format cells uine borders and number formuttine 3 Uie formulas to caladate mbtotals and totais. Sivine s submittiry Solution 1 Save tle to decitep. a Create folder on destos and label compurrio ixcil haircts 2 Uplosd and nomit your file to be grosed c. Cla Uyload buten valer step? 4. Clak Sibmer bisten under steps Vireles Bemels 1 Clid on Ranitu tab in Mrlab Aanonting 7 Clid on the Aulerment you were working on
