Please show me how to do this Bank Reconciliation with this information.

Thank you!

Public Bank Byte of Accounting 123 Speed Lane P.0. Box 5551212, Miami, Florida 33999 Ph (305) 555-1212 Miami, Florida 33999 Previous Balanc Account Number Deposits/Credits 249,355.00 Statement Date Checks/Debits 87,565.00 Ending Balanc 161,790.00 161,790.00 Activity in date order Date Descri Amount tion Jun 01 Deposit 238,080.00 Jun 07 Paid check# 5002 -33,000.00 Jun 15 Paid check# 5003 25.250.00 Jun 16 Deposit 7,570.00 Jun 21 Paid check# 5005 14.900.00 Jun 22 NSF -3,300.00 Jun 22 NSF service charge -25.00 Jun 22 Paid check# 5006 7.200.00 Jun 23 Deposit 3,705.00 Jun 24 Paid check 306 1.400.00 -320.00 Jun 26 Paid check# 5007 Jun 26 Paid check# 5008 725.00 -860.00 Jun 27 Paid check# 5009 Jun 27 Elec Remit AT&T Telephone 165.00 Jun 27 Paid check# 5010 -375.00 Jun 29 Service Charge-Checks -45.00 Ending Balance 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. Balance 238,080.00 205.080.00 179.830.00 187,400.00 172.500.00 169.200.00 169.175.00 161,975.00 165,680.00 164,280.00 163,960.00 163.235.00 162,375.00 162,210.00 161,835.00 161,790.00 161,790.00 Public Bank Byte of Accounting 123 Speed Lane P.0. Box 5551212, Miami, Florida 33999 Ph (305) 555-1212 Miami, Florida 33999 Previous Balanc Account Number Deposits/Credits 249,355.00 Statement Date Checks/Debits 87,565.00 Ending Balanc 161,790.00 161,790.00 Activity in date order Date Descri Amount tion Jun 01 Deposit 238,080.00 Jun 07 Paid check# 5002 -33,000.00 Jun 15 Paid check# 5003 25.250.00 Jun 16 Deposit 7,570.00 Jun 21 Paid check# 5005 14.900.00 Jun 22 NSF -3,300.00 Jun 22 NSF service charge -25.00 Jun 22 Paid check# 5006 7.200.00 Jun 23 Deposit 3,705.00 Jun 24 Paid check 306 1.400.00 -320.00 Jun 26 Paid check# 5007 Jun 26 Paid check# 5008 725.00 -860.00 Jun 27 Paid check# 5009 Jun 27 Elec Remit AT&T Telephone 165.00 Jun 27 Paid check# 5010 -375.00 Jun 29 Service Charge-Checks -45.00 Ending Balance 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. Balance 238,080.00 205.080.00 179.830.00 187,400.00 172.500.00 169.200.00 169.175.00 161,975.00 165,680.00 164,280.00 163,960.00 163.235.00 162,375.00 162,210.00 161,835.00 161,790.00 161,790.00