Prepare a bank reconciliation

Assignment Help Accounting Basics
Reference no: EM132879865

Question - Emily's Sweet Shop's August 31 bank balance was $11,135. The company's cash balance at August 31 was $10,805. Other information follows:

-Outstanding cheques were #421 for $165, #485 for $265, #492 for $175, and #494 for $1,165. Cheque #421 was also outstanding on July?31 and was included on July's bank reconciliation.

-Included with the statement were EFT deposits totalling $1,735 during August in payment of accounts receivable. These deposits have not been recorded by the company.

-Cheque #490 was correctly written and paid by the bank for $206. The cheque had been issued to pay accounts payable and the company had recorded it as $266.

-The bank statement showed a cheque #4832 for $795, which did not appear on the company's books. Investigation revealed that the cheque was actually issued by Wally's Water Works and was charged to Emily's Sweet Shop's account in error.

-The bank returned an NSF cheque from a customer for $385.

-The bank statement showed two debit memoranda for service charges: one for $25 related to the NSF cheque (see item [5] above) and one for $45 for cheque printing charges. The company's policy is to pass on all NSF processing fees to the customer.

-The company's records showed the August 15 deposit as $4,690. On the bank statement, it was correctly recorded as $4,990. The deposit was for cash sales.

-The company has a pre-authorized EFT payment for its monthly utilities for $245 scheduled for the last day of each month. As August 31 was a Sunday this year, the bank posted it on September 1. The company recorded it in August.

-The $1,355 July?31 bank deposit was recorded on August 1 on the bank statement. The August 31 bank deposit of $2,530 was not included on the August bank statement. Instructions

Required -

a. Prepare a bank reconciliation. It is a formal statement and must be formatted as such. See the samples in the textbook and Module.

b.?Prepare any necessary adjusting journal entries. (journal)

c.?What amount should be reported as cash on the August 31 balance sheet?

Taking It Further: Why is it important that the person who prepares the bank reconciliation shouldn't also be able to write and sign cheques? In what ways would that increase the opportunity for employee fraud?

Reference no: EM132879865

Questions Cloud

Why is managing human resources important : You are to assume that you work for an organization that does not have a human resource department.
What does unionization look like in health care : What does unionization look like in health care? What are the benefits and drawbacks of having a union?
What the contribution margin earned by Richardson : The company produced 2,450 units and sold 2,375 units, both as budgeted. What the contribution margin earned by Richardson
Create a draft agenda for such a meeting : What types of matters might you discuss at a team discussion for someone with dementia create a draft agenda for such a meeting
Prepare a bank reconciliation : Prepare a bank reconciliation. It is a formal statement and must be formatted as such. See the samples in the textbook and Module
What type of computer-based system would they be considered : According to the text, what type of computer-based system would they be considered? Explain your answer. List at least 2 pro's and 2 con's for each system.
How will the scholarship help in your career aspirations : How will the scholarship help in your career aspirations and make a difference for you personally as you live the mission of the University in your everyday lif
Determine the manufacturer finished goods inventory value : A total of 175,000 units were manufactured during June, 2,500 of which remain in ending inventory. Determine the manufacturer finished goods inventory value
What do you think is the primary reason that ksa spends : What do you think is the primary reason that KSA spends more on healthcare than the UK?

Reviews

Write a Review

Accounting Basics Questions & Answers

  Discuss bonds are issued to yield the market interest rate

How can i solve the fallowing question without using the pv function in excel

  Calculate the applicable self-employment tax

Alexander Ryan earns net self-employment income of $116,900. Calculate the applicable self-employment tax

  What would be the projected current ratio of the company

If all current assets and current liability accounts increase proportionately with sales, what would be the projected current ratio of the company

  Determine yield to maturity on the bonds given current price

Determine the yield to maturity (YTM) on the bonds given the current price. Based on each bond's ratings and your determination of its yield to maturity, explain how you rank each bond for risk and return.

  Slick corporation is a small producer of synthetic motor

slick corporation is a small producer of synthetic motor oil. during may the company produced 5000 cases of lubricant.

  An election to have the net capital gain taxed

1. On January 1 of the current year, Scott borrows $80,000, pledging the assets of his business as collateral. He immediately deposits the money in an interest-bearing checking account.

  Economics question on rate of return

Swagelok Enterprises is manufacturer of miniature fittings and valves. Over a 5-year period, the costs associated with one product line were given below:

  Calculate the value of closing inventory

Calculate the value of closing inventory as at 31 December 2015 and gross profit for the year ended 31st December 2015

  How the information is reported on a statement of cash flows

From the postings in the accounts, indicate how the information is reported on a statement of cash flows using the indirect method.

  What is the length of the cash cycle

Wislon, Inc. has inventory turnover rate of 15, accounts payable period of 54 days and an accounts receivable period of 37 days. What is length of cash cycle

  Components of management report on internal control

Section 404 of SOX requires a public company's annual report to include an internal control report. What are the two required components of management's report on internal control

  In the month of june angelas beauty salon gave 3500

in the month of june angelas beauty salon gave 3500 haircuts shampoos and permanents at an average price of 30. during

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd