Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. . . . ea5-e3 complete a bank reconciliation for po

. . . EA5-E3 Complete a Bank Reconciliation for Pond Maintenance Corp. In this exercise,...

70.2K

Verified Solution

Question

Accounting

image

. . . EA5-E3 Complete a Bank Reconciliation for Pond Maintenance Corp. In this exercise, you will complete a bank reconciliation as of 12/31/2016 for Pond Maintenance Corp. One of your primary goals is to ensure that the file can be easily under- stood by the end user. Use this information to populate the reconciliation: Deposits in Transit: $10,100 and $1,000 NSF Check: $7,150 Notes Receivable: $7,000 Outstanding Checks: $3,100 and $600 Bank Charges: $1,100 The bank erroneously deposited a $250 check written to TreeSky Industries into the bank account of Pond Maintenance Corp. The bank statement reflects a 12/31/16 balance of $94,200, while the company's general ledger reflects a 12/31/16 cash balance of $102,600. 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 $90,000. Apply a header that displays the filename and file path and a footer that displays the current time. Ensure that all column widths, row heights, and font sizes are appropriately adjusted

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students