Answered step by step
Verified Expert Solution
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?
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started