this is the problem

this is the way I need it solved please

stige Worldwide Bank Reconciliation G/L Balance 12/31/21 50,200 Bank Balance 12/31/21 101,025 Outstanding Checks @ 11/30/21 51,525 Deposits in Transit 11/30/21 5,700 Deposits in Transit 12/31/21 2,900 December Bank Service Charge 125 Checks issued by Presitge in December 78,000 Checks Cleared bank in December 77,525 NSF check returned by bank in the amount 850 Ck # 1234 Cleared the bank for $4,500 incorrectly entered into books for $5,400 Ck # 1275 in the amount of $7,500 incorrectly charged by the bank for $5,700 1. Please prepare a Bank Reconciliation in the space provided below using the format reviewed in class 2. Please prepare the required journal entries for Prestige for December of 2021 1 Cash Balance of Collegiate Co. $81,145 (+) Total cash deposited during November $293,150 (-) Total Check withdrawn during November $307,360 Beginning balance of Collegiate Sports Co. on November 2016 $66,935 Beginning Balance Less: Outstanding Checks Incorrect charged by bank NSF Check Service Charges Check Error ($7,600-$760) Subtotal Direct Collection by bank Less: Deposit in Transit Books Bank 566,935 $112.675 ($41.840) ($4,500) ($2,500) ($125) 6,840 71,150 $66,335 S7,385 ($12.2001 $ $ Reconciled Balance 66.335 $66.335 2 Date Accounts Debit Credit 30-Nov Cash $6,480 Account Payable $6,480 (Recording the incorect recording by Co.) 30-Nov Cash $7,385 Note recivable $7,000 Intrest Income $385 (Recording direct collection from bank) $2,500 30-Nov Account Recivable Cash (Recording NSF) $2,500 $125 30-Nov Service Charge Cash $125 Captsone Medical 2 Books 89,620 Bank 128,660 (32,700) 26,750 (1,350) Begin Bal Less: Outstanding Checks Loan collected ABC Supply check error Check-Bank error Service Charges Subtotal Less: Deposit in transit Reconciled Balance 450 96,410 (60) 114,960 (18,550) 96,410 96,410