Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please complete this bank reconciliation for me? Public Bank P.O. Box 5551212, Miami, Florida 33999 Ph # (305) 555-1212 Byte of Accounting 123

Can someone please complete this bank reconciliation for me?

image text in transcribed

image text in transcribed

Public Bank P.O. Box 5551212, Miami, Florida 33999 Ph # (305) 555-1212 Byte of Accounting 123 Speed Lane Miami, Florida 33999 Previous Balance Account Number Statement Date 33999999 6/30/200x Deposits/Credits Checks/Debits 216,965.00 77,750.00 139,215.00 139,215.00 Ending Balance Activity in date order Date Jun 01 Jun 07 Jun 15 Jun 16 Jun 21 Jun 22 Jun 22 Jun 22 Jun 23 Jun 24 Jun 26 Jun 26 Jun 27 Jun 27 Jun 27 Jun 29 Description Deposit Paid check # 5002 Paid check #5003 Deposit Paid check # 5005 NSF NSF service charge Paid check # 5006 Deposit Paid check # 306 Paid check # 5007 Paid check # 5008 Paid check # 5009 Elec Remit AT&T Telephone Paid check # 5010 Service Charge-Checks Ending Balance Amount 207,100.00 -32,000.00 -24,500.00 6,350.00 -9,500.00 -3,050.00 -25.00 -4,800.00 3,515.00 -1,000.00 -400.00 -800.00 -1,010.00 -240.00 -400.00 -25.00 Balance 207,100.00 175,100.00 150,600.00 156,950.00 147,450.00 144,400.00 144,375.00 139,575.00 143,090.00 142,090.00 141,690.00 140,890.00 139,880.00 139,640.00 139,240.00 139,215.00 139,215.00 Check #306 is not our check Our policy is to charge the customer for any charges related to NSF checks The Deposit on Jun 16 was incorrectly recorded by the bank. The Deposit on Jun 23 was correctly recorded by the bank. We do not modify the original journal entry. Company's Books Ending Balance per books Bank Statement Ending balance per bank 140,094.22 139,215.00 Additions Additions 1. Add to Books 2. Add to Bank Total _ Deductions Deductions 3. Deduct from Books 4. Deduct from bank Ending Correct cash balance Ending Correct cash balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

IRS Audit Protection And Survival Guide Bed And Breakfasts

Authors: Gerald F. Bernard, Daniel J. Baran

1st Edition

0471166340, 978-0471166344

More Books

Students also viewed these Accounting questions

Question

List the six basic steps of the estate planning process.

Answered: 1 week ago

Question

What are the stages of project management? Write it in items.

Answered: 1 week ago