Just need help with part B

On July 31. 2022; Marin Company had a conh balacee per books of 56,360. The statement from Dakota State Bank on that if 2 . showed a balance ot $7,91080 A comparian of the bank statement with the Cash acoount revealed bhe following 9 cts 1. The ban' service charse for fuly was $17. 2. The bank collected $1.635.00 for Marin Company through electronic funds transfen. 3. The July 31 receipts of 51.316.30 were not inchaded in the bank deposits for July. Thefe rectighs were dtipasited ty the company in a pight depotit vault on duly 31 4. Compary check. No, 24t60 issued to L. Tayfor, a creditor, for $384 that cleared the bank in zuly was ingoxerectiventered in the cavh payments record on July 10 for 5348 5. Checksoutstanding on Joly 31 totaled $1,975,10. 6. On July 31. the bank statement showed an NSF charge of 509000 tor a check recelved by the company from W. Krueiger, a customer, on account. Prepare the bank reconcilation as of July 31 (Uit therns thot increase balance as per bunk \& books first) Ashereuce h balance per bcois Aeded v if Fectrooichonds tramder itceived ten flank mryion tharg" NGriben. Firoc in reonefires oheck No: 2 and Attemptst 1 of 1 used Question Part Score Prepsre a tabolar arialyis for the necessary asfustments at July. 31. Include marikin enplanations tior the charyees itreevenues and of the omiount enterdd for the particular Asset, (labilly or Equity item that was reducwi)