3 Using Excel for a Bank Reconciliation 5 Billy Ray of Wilderness Adventures is getting ready to prepare the August bank reconciliation. 7 The cash balance on the books of Wilderness Adventures on August 31 is $7,092 Billy reviews the bank statement, and notes the cash balance at August 31 of $4,890. The bank statement also reveals that the bank collected a note receivable on behalf of Wilderness Adventures- the principal was $3,000 and the interest was $30. One customer's check for $58 was returned by the bank for insufficient funds. Two additional items on the bank statement were the monthly EFT for the utilities, $500, and the bank service fee of $24. Billy notes that the cash deposit 9 made on Aueust 31 of $6.600 does not appear on the statement. and that three checks totaline $1.950 had not cleared the 10 11 Requirements Prepare the bank reconciliation for Wilderness Adventures at August 31, 2019. Format appropriate cells with dollar signs, underlines, and double underlines. Use Excel formulas to calculate Journalize the entries based on the bank reconciliation. For dollar amounts, use cell references on bank reconciliation. 1. 12 2. 13 15 Excel Skills 16 17 18 19 1. Use Excel's data validation to enter descriptions into the bank reconciliation, and accounts into the journal 2. Format cells using borders and number formatting. 3. Use formulas to calculate subtotals and totals