Question
You are an accountant for Wrigley Inc., (a company that makes baseball equipment). The CEO, Joe Madden, has asked you to prepare the November bank
You are an accountant for Wrigley Inc., (a company that makes baseball equipment). The CEO, Joe Madden, has asked you to prepare the November bank reconciliation for the companys operating cash account (Account #100).
The CEO provided you with the November 2016 bank statement. After you review the bank statement, you have noted a few items with Acct #100. There was a check to a customer (Jake Arietta) that bounced. The bank noted the NSF check was for $1,509. The bank also charged Wrigley Inc. $15.00 for processing the NSF check. The bank also charged Wrigley Inc. $25.00 to print an old cancelled check. The fee to use the bank account for the month of November was listed on the bank statement at $22.00. The bank accidentally deposited a check that was written to the Wrigley Corporate into the Wrigley Inc. account. The amount of this check was for $622. The bank moved the funds into the proper account on December 5th. The bank statement for November listed the ending account balance at $82,100.
In order to perform the bank reconciliation you obtain the companys trial balance. The company has several cash accounts and you obtain the following data for November 30th, 2016: Operating Cash Account #100 had a balance of $70,834, Payroll Cash Account 101 had a balance of $12,300., and Dividend Cash Account 102 had $5,200. You identify that the company has written $20,280 in checks (from Acct #100) that have not cleared the bank as of the end of November. On November 30, 2016, the cashier for the company deposited $10,765 from customer checks into the operating cash account. This November 30th deposit is not on the November bank statement. You identify that the company wrote an insurance check correctly for $2,500 on November 12th. The journal entry included a debit entry to the prepaid insurance account for $5,200 and a credit to the operating cash account for $5,200.
Instructions: Prepare the companys bank reconciliation for acct #100 for November 2016. Also, prepare the Nov. 30th journal entries to correct the ending cash balance.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started