Please help!

Required informetion [The following information apples to the questions displayed below] The following information is avalloble to reconcile Branch Company's book balance of cash with its bank statement cash balance as of July 31 . a. On July 3t, the company's Cash account has a $24,771 debit batance, but its July bank statement shows a $26,560 cash balance b. Check Number 3031 for $1,280, Check Number 3065 for $416, and Check Number 3069 for $2,048 are outstanching checks as of July 31 c. Check Number 3056 for July rent expense was correcty witten and drawn for $1,270 but was erroneously entered in the accounting records as $1,260 d. The July bank statement shows the bank collected \$5,000 cash on a note for Branch. Branch hod not recorded this event before recelving the statement. e. The bank statement shows an $805 NSF check. The check had been recelved from a customer, Evan Shaw. Branch has not yetrecorded this check as NSF. t. The July statement shows a $8 bank service charge. it has not yet been recorded in miscellaneous expenses because no prevous notication had been recerved g. Branch's July 31 dally cash receipts of $6,132 were placed in the bank's night depository on that date but do not appear on the July 31 bank statement Requlred: 1. Prepare the bank reconcillation for this company as of July 31