Prepare bank reconciliation and adjusting entries

The following information pertains to Lance Company.

$1$ Cash balance per bank, July $31,$$$8,428.$

$2$ July bank service charge not recorded by the depositor $$56.$

$3$ Cash balance per books, July $31,$$$8,344.$

$4$ Deposits in transit, July $31,$$$3,650.$

$5$$$3,274$ collected for Lance Company in July by the bank through electronic funds transfer.

The collection has not been recorded by Lance Company.

$6$ Outstanding checks, July $31,$$$526.$

Instructions

$($a$)$ Download the excel answer sheet below then answer $($a$)$ & $($b$)$ on it$,$ and upload your answers

$($b$)$ Prepare a bank reconciliation at July $31,2017.$

$($c$)$ Journalize the adjusting entries at July $31$ on the books of Lance Company.

NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a $"?".$