Question: 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?

How do I do the bank reconciliation for this problem? PublicBank P.O.

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.00

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!