Question: i just need 3. ( 20 points) The June 30 bank statement shows a checking account balance of $18,411.00. Our book balance on June 30

i just need

3. ( 20 points) The June 30 bank statement shows a checking account balance of $18,411.00. Our book balance on June 30 was \$16,615.52. Our employee who reconciles the bank statement noted the following reconciling items: a. After the bank closed on June 30, we deposited the day's cash sales, 51,588.14. b. The bank collected a Note Receivable on our behalf on June 30 . We had not been notified of the collection before receiving the bank statement. The amount is $950. c. Check \#5259 in the amount of \$1,352.71 was properly prepared for the purchase of Merchandise Inventory. The bank processed it correctly. Unfortunately, we did not record the check in our Cash Disbursements Journal. d. Outstanding checks on March 31 totaled \$3,811.33. e. The bank deducted a service charge of $25, which we have not yet recorded. Required: a. Use the "P 3n tab in the spreadsheet to prepare a bank reconciliation for June 30 . b. Prepare the joumal entry to update the Cash account based on the reconciliation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Besserbrau AG is a German beer producer headquartered in Ergersheim, Bavaria. The company, which was founded in 1842 by brothers Hans and Franz Besser, is publicly traded, with shares listed on the...

3. (20 points) The June 30 bank statement shows a checking account balance of $16,311.00. Our book balance on June 30 was $14,515.52. Our employee who reconciles the bank statement noted the...

1. (10 points) Ecks Company records purchases of inventory at invoice cost at the time of purchase. When they take advantage of discount terms, they credit Inventory at the time of payment. Using the...

3. (20 points) The June 30 bank statement shows a checking account balance of $16,311.00. Our book balance on June 30 was $14,515.52. Our employee who reconciles the bank statement noted the...

fill in the blanks for the required 4 pls Chrome File Edit View History Bookmarks Profiles Tab Window Help 4 0 US U.S. L 0 7 Q 8 Fri Oct 6 9:41 AM e e Dashboard X M Question 5 - Chapter 6 Home X...

3. 1000 ponts Exercise 8-9 Bank reconciliation LO P3 Del Gato Clinic deposits all cash receipts on the day when they are received and it makes all cash balance. by check. At the close of business on...

(i) At the end of January, the unadjusted trial balance of Ali Baba, Inc. included the following accounts: Debit Credit 500,000 $ Sales (80% represent credit sales) Accounts Receivable Allowance for...

The bank statement for the checking account of ESI showed a balance of $14432.12 on September 30. Outstanding checks were $1,320.25 The September 30, cash receipts of $575 were not deposited in the...

Horngren's Accounting, The Financial Chapters CHAPTER 5 9) Office Supplies, Inc. uses a perpetual inventory system. Journalize the following sales transactions for this company assuming an adjusting...

FILL IN RESPONSES. INCLUDE GIVEN DATES. Horngren's Accounting, The Financial Chapters CHAPTER 5 9) Office Supplies, Inc. uses a perpetual inventory system. Journalize the following sales transactions...

Explain how cost of goods sold is converted from an accrual basis to a cash basis.

Smith's Hotel has determined the following items on a per room basis. Direct Materials $10.66 Direct Labour 22.12 Variable Overhead 12.45 Fixed Overhead 32.69 What should be the selling price of a...

Brief Exercise 15-27 Preparing Income Statements by Using Net Sales as the Base: Vertical Analysis Refer to the information for Azita Company above. Required: Prepare common-size income statements by...

Project Management: What would an outline of a HR data analytics project plan look like (which items should it contain)? Cite course materials in developing your answer. Continue with proactive...

7-17 How do social search, semantic search, and mobile search differ from searching for information on the Web using conventional search engines?

7-16 Compare Web 2.0 and Web 3.0.

4. What solutions have been proposed for this problem? Do you think they will be effective? Why or why not? In July 2010, reports surfaced about a Stuxnet worm that had been targeting Irans nuclear...