Question: How do you prepare a bank reconciliation statement based off this info? Use the following bank statement and T-account to prepare the May 31 bank

How do you prepare a bank reconciliation statement based off this info?

Use the following bank statement and T-account to prepare the May 31 bank reconciliation. Checks BANK STATEMENT Deposits Other Balance $260 Date May 1 4 12 $ 65 300 NSF check $65 28 #2 #4 #5 #6 #8 $ 25 115 35 30 70 120 85 315 225 260 30 May 31 Service charge 20 May 1 May 3 Cash (A) 260 65 25 85 115 35 30 260 40 180 70 May 3 #2 May 4 #3 May 8 #4 May 11 #5 May 21 #6 May 29 #7 May 30 #8 May 29 May 30 May 31 365 Bank Statement Ending Balance per Bank Statement Additions: Deposit in Transit Bank Reconciliation May 31 Company's Books Ending Balance per Cash Account Additions: 365 365 Deductions: 0 Deductions: 0 O Up-to-Date Cash Balance $ 365 Up-to-Date Cash Balance $ 0

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!

That's 1 question Question 2 QUESTION 11 Baltic Supplies presented the following unadjusted Trial Balance as a Deoember 31, 2016. AC Name Trial Balance DR CR 620,000 410,000 330,000 144,800 156,000...

Grossfeld Company of Omaha, Nebraska, provides liquid fertilizer and herbicides to regional farmers. On July 31, 2012, the company's Cash account per its general ledger showed a balance of $5,876.70....

Par 5 QUESTION 12 The following information is available for Andersen Company for the month ending June 30, 2013 Balance per the bank statement is $10.241.43. - Balance per books is $9,745.06. ....

Q.2.1 Calculate the correct bank balance at 30 June 2019. (15) (Hint - Start by calculating the bank balance at 31 May 2019). Q.2.2 Prepare the bank reconciliation statement at 30 June 2019. (5) The...

Prepare a bank reconciliation statement for October 31 ,31. 2016 The following information is for Future Company: (1) After all posting was completed on October 31, the company's Cash account had a...

Cash Accounts Receivable Supplies Prepaid Rent Merchandise Inventory (24 $265; 1 @ $260) Land Accounts Payable Unearned Revenue Salaries Payable Common Stock Retained Earnings $74,210 13,500 200...

SECTION II - Short Answers Noble is a private company and has a fiscal year end of 3 1 December 2 0 1 1 . During the year 2 0 1 1 Noble has paid sponsorship fee of AED. 2 0 0 , 0 0 0 for the period...

Use Excel formulas to compute the following Superior Printing, Inc. has provided you with its bank statement and Cash T-Account for the month of June. The Controller has asked you to prepare the Bank...

ONLY ANSWERS NEEDED ARE THE LAST TWO. BOTH ARE $81,330 BUT I NEEDTHE EXCEL'S FORMULAS FOR BOTH. Superior Printing, Inc. has provided you with its bank statement and Cash T-Account for the month of...

7 Superior Printing, Inc. has provided you with its bank statement and Cash T-Account for the month of June. The Controller has asked you to prepare the Bank Reconciliation for the month of June. Use...

Aron, Brown and Claire formed a partnership business. Their capital balances are: Aron $100,000, Brown $60,000 and Claire $40,000, and the P/L ratios are: Aron 20%, Brown 50% and Claire 30%. Daniel...

Sweet Acacia Limited has the following information available regarding its share capital at December 31, 2020: Preferred shares, $3.50 cumulative, 18,300 shares issued $915,000 Preferred shares,...

you want to buy a house in your dream city 3 0 years from today. $ 1 0 0 , 0 0 0 annually

Identify someone you think is an excellent public speaker. List at least five qualities that this person possesses that make him or her an effective speaker. (Objectives 1, 2, and 3)

What advice would you give to a coworker who declines invitations to speak to professional and community groups because he or she is too scared? (Objective 6)

Teamwork. Form groups of four to five students. Have each person in the group speak for one minute on one of the following topics (no two persons in the group should speak on the same topic): a. Ways...