prepare bank reconciliation at july 31 please

The following information pertains to Bonita Video Company. Cash balance per bank, July 31, $8,203. July bank service charge not recorded by the depositor $37. Cash balance per books, July 31, $8,224. Deposits in transit, July 31, $1,970. Bank collected $1,370 note for Bonita in July, plus interest $45. less fee $29. The collection has not been recorded by Bonita, and no interest has been accrued. Outstanding checks, July 31, $600