In this exercise, you will complete a bank reconciliation as of 6/30/2016 for Planetary Corp. One of your primary goals is to ensure that the file can be easily understood by the end user. Use this information to populate the reconciliation:

• Deposits in Transit: $300 and $900
• NSF Check: $200
• Notes Receivable: $800
• Outstanding Checks: $1,400 and $100
• Bank Charges: $400
• When recording check #146 for $500, the company erroneously reduced the cash balance by $1,500.
• The bank statement reflects a 6/30/16 balance of $4,800, while the companys general ledger reflects a 6/30/16 cash balance of $3,300.

Modify the appearance of the reconciliation using Format Painter and Quick Styles. Set a conditional formatting rule that will highlight the bank balance if it exceeds $4,000. Apply a header that displays the filename and a footer that displays the current time. Ensure that all column widths, row heights, and font sizes are appropriately adjusted.

Prepare the necessary journal entries to record the adjustments required to your companys books.