Purchase Solution

Bank Reconciliation and Adjusting Entries

Not what you're looking for?

Ask Custom Question

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)