Question

EA5-A2 Create a Bank Reconciliation for Tasters Club Corp. In this exercise, you will create a bank reconciliation for Tasters Club Corp. for the month ended December 31, 2016. The reconciliation should be partly based on these figures: Bank Statement Balance (12/31/2016) equals $16,200; Notes Receivable equals $395; NSF Check equals $4,000; Bank Charges equals $550. During the month, the bank erroneously deposited a $505 check written to Pepper Products into the bank account of Tasters Club Corp. 1. Open a Blank Workbook and save the file in your Chapter 05 folder as: EA5-A2-BankRec-[YourName] 2. Enter the bank reconciliation headers in the range A1:A3; apply bold formatting. 3. Apply the Merge & Center command (from columns A-G) to each row in this range 4. Using examples from the chapter, enter descriptions for the initial bank and book balances in appropriate locations. Type the Add: and Deduct: labels in the proper cells in rows 6 and 9. 5. Set the width of columns A and Eto 24 and the width of column D to 1. 6. Enter the bank statement balance in the appropriate location. 7. Open EA5-A2-QBReport from your Chapter 05 folder and arrange the window next to the bank reconciliation window. 8. Type Outstanding Checks in an appropriate location in the bank reconciliation.