Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I do the bank reconciliation for this problem? PublicBank P.O. Box 5551212, Miami, Florida 33999 Ph # (305) 555-1212 Previous Balance Deposits/Credits Checks/Debits
How do I do the bank reconciliation for this problem?
PublicBank P.O. Box 5551212, Miami, Florida 33999 Ph # (305) 555-1212 Previous Balance Deposits/Credits Checks/Debits Ending Balance 190,625.00 73,045.00 117,580.00 117,580.00 Activity in date order Date Jun 01 Jun 07 4 Jun 15 7 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 10 11 Description Deposit Paid check # 5002 Paid check # 5003 Deposit Paid check # 5005 NSF NSF service charge 12 20 15 16 17 19 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 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 jou Company's Books Ending Balance per books Additions 1. Add to Books 2. Add to Bank Total Deductions 3. Deduct from Books 4. Deduct from bank Ending Correct cash balance 118,320.32 Byte of Accounting 123 Speed Lane Miami, Florida 33999 Account Number 33999999 Statement Date 6/30/200x Amount Balance 179,760.00 -29,000.00 -22,250.00 6,520.00 -10,100.00 -3,300.00 -25.00 -3,400.00 4,345.00 -1,900.00 -850.00 -560.00 -400.00 -255.00 -960.00 -45.00 179,760.00 150,760.00 128,510.00 135,030.00 124,930.00 121,630.00 121,605.00 118,205.00 122,550.00 120,650.00 119,800.00 119,240.00 118,840.00 118,585.00 117,625.00 117,580.00 117,580.00 0 0 0 0 0 0 0 0 6250 6200 6000 200 50 6520 -3300 -25 500 -1900 0 255 0 45 ed to NSF checks k. We do not modify the original journal entry. Bank Statement Ending balance per bank Additions Total Deductions Ending Correct cash balance 117,580.00Step 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