Bank Reconciliation and Adjusting Entries
Not what you're looking for?
I need help with this problem. Please put in excel. Thank you.
--------------------------
Kipling Company deposits all receipts and makes all payments by check. The following information is available from the cash records.
June 30 Bank Reconciliation
Balance per bank $7,000
Add: Deposits in transit 1,540
Deduct: Outstanding checks (2,000)
Balance per books $6540
Month of July Results
Balance July 31 Per Bank - $8650 Per Books - 9250
July Deposits Per Bank - 4500 Per Books - 5810
July checks Per Bank - 4000 Per Books - 3100
July note collected (not included in July deposits) Per Bank - 1500 Per Books - (--)
July Bank service charge Per Bank - 15 Per Books - (--)
July NSF check from a customer, return by the bank Per Bank - 335 Per Books - (--)
(recorded by bank as a charge)
Instructions
a. Prepare a bank reconciliation going from balance per bank and balance per book to correct cash balance.
b. Prepare the general journal entry or entries to correct the Cash account
Purchase this Solution
Solution Summary
The solution explains how to prepare the bank reconciliation and the related journal entries
Purchase this Solution
Free BrainMass Quizzes
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)