I NEED IT URGENT PLEASE! Thank You

The following information applies to the questions displayed below The following information is avaiiable to reconcile Branch Companys book belance of cash with its bank statement cash balence es of July 31 2013 a On July 31, the company's Cash account hes o $25,756 debit balance, but its July bank statement shows b. Check No.3031 for $1,800 and Check No. 3040 for $892 were outstanding on the June 30 bank a $28784 cash balance. reconcierton Check No 3040 s isted witn the Aty canceled checks, but Ceck No 3031 Is not Aiso, Check No 3055 for $676 and Check No. 3069 for $2.568, both written in July, are not among the canceled checks on the July 31 statement c In comparing the canceled checks on the bank statement with the entries in the accounting records, it is found thet Check No. 3056 for July rent was correcly wrttten and drewn for $1,270 but wes erroneousy entered in the accounting records as $1.260 d. A credit memorandum enclosed with the July bank stetement indicates the bank colfected $7.500 cash on a non-anterest-bearing note for Branch, deducted&$38 collection fee and credited the remainder to its eccount Branch hed not recorded this event before receving the statement e. A debit memorandum for $805 lists a $795 NSF check plus a $10 NSF charge. The check hed been t Enciosed with the July statement is a S11 debit memorandum for bank services It has not yet been g Branch's July 31 daily cash receipts of $8652 were placed in the bank's night depository on that dete, but recerved from e customer, Evan Shew. Branch has not yet recorded this check as NSF recorded because no previous notificapion hed been received do not appear on the July 31 bank stanement Required: 1. Prepare the bank reconcilation for this company as of July 31, 2013 Bank Reconciliation July 31, 2013 Bank statement balance Book balance Add Add Deduct Deduct Adjusted bank balance Adjusted book balance