Purchase Solution

Bank Reconciliation for XYZ Company

Not what you're looking for?

Ask Custom Question

Prepare a bank reconciliation for XYZ Company at September 30 using the following information:

Balance per XYZ Company bank statement at September 30. $ 7,351.10
Outstanding checks 5,645.45
NSF checks from customers 444.22
Deposits in transit 7,135.46
Interest Revenue 100.00
Service charge 230.30
Cash balance per XYZ's records at September 30 9,415.63

Purchase this Solution
Solution Summary

This solution explains how to prepare a bank reconciliation for a company using given financial information.

Solution Preview

Please see attached Word document.
A company's cash balance according to their bank statement and their cash balance according to their accounting records usually do not match. This is normally due to the fact that, at any particular date, checks may be outstanding, deposits may be in transit to the bank, errors may have occurred etc. Therefore companies have to carry out bank reconciliation process that prepares a statement accounting for the difference between the cash balance in company's cash account and the cash balance according to its bank statement.
The ...

Solution provided by:
Rachel Kozicki, PhD (IP)
Education
  • BA, Ashford University
  • MBA, Ashford University
  • Post-Master's Certificate, Northcentral University
  • PhD (IP), Northcentral University
Recent Feedback
  • "thank you so much that was very helpful!"
  • "Thank You. I have a good understanding of the topic. I will also read the information that was provided."
  • "Great thanks"
  • "Thank u again!!!!!!!!!!!!!!!!!!"
  • "Thank u!!!!!!!!!!!!!!"
Purchase this Solution
Free BrainMass Quizzes
Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Introduction to Finance

This quiz test introductory finance topics.

Operations Management

This quiz tests a student's knowledge about Operations Management

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

View More Free Quizzes
Related BrainMass Solutions

  • Bank reconciliation purpose

    Bank will deduct service charges for the processing of checks and which is not deducted in the cash balance of the company as the company will come to know only after the receipt of bank statement at the end of the month.

  • Internals Control System

    378444 Internals Control System and Procedures for XYZ Company You are an accountant at a local CPA firm that is auditing the accounting records of XYZ Company.

  • Jones Company and Santos Company

    on Jones Company's July bank reconciliation and the adjusted cash balance per books on August 31 for Santos Company.

  • Answer to "Bank Reconciliation" question

    A check drawn on the account of Johns Company for $200 was mistakenly charged against Jones' account by the bank. Instructions: Prepare the November 30 (a) bank reconciliation (omit heading) and (b) related journal entries.

  • Accounting: Bank reconciliation

    Please prepare bank reconciliation for the following scenario: Prepare a July 31 bank reconciliation statement and the resulting journal entries for the Simmons Company.

  • Preparing a Bank reconciliation

    On May 31 the bank statement showed an NSF charge of $340 for a check issued by K. Uzong, a customer, to Galenti Company on account. (a) Prepare the bank reconciliation as of May 31, 2007.

  • How to Prepare a Bank Reconciliation and Record Adjustment for Clark Company

    Assume that the July 31, 2005, bank reconciliation for this company is prepared and some items are treated incorrectly.

  • Binford Company Bank Reconciliation

    The bank collected an $1,800 note for Bindford Company. The company was not aware of the collection until receiving the bank statement. Prepare a bank reconciliation for May 31, 2009. Check the attached sheet.

  • Imagine you are the accountant for Floral Design Company and

    395314 Imagine you are the accountant for Floral Design Company and are assigned to prepare the monthly bank reconciliation. Complete this task, by using the data below: 1. Complete the bank reconciliation for the month of June. 2.

View More Related Solutions