On July $31,2022.$ Keeds Company had a cash balance per books of $$6,140\mathrm{.}00.$ The statement from Dakota State Bank on that date showed a balance of $$7,690\mathrm{.}80.$ A comparison of the bank statement with the Cash account revealed the following facts.

$1$ The bank service charge for July was $$25\mathrm{.}00.$

$2.$ The bank collected $$1,520\mathrm{.}00$ for Keeds Company through electronic funds transfer.

$3.$ The July $31$ cash receipts of $$1,193\mathrm{.}30$ were not included in the bank statement for July. These receipts were deposited by the company in a night deposit vault on July $31$

$4.$ Company check No$.2480$ issued to L Taylor, a creditor, for $$384\mathrm{.}00$ that cleared the bank in July was incorrectly recorded as a cash payment on July $10$ for $$348\mathrm{.}00.$

$5.$ Checks outstanding on July $31$ totaled $$1,860\mathrm{.}10.$

$6.$ On July $31,$ the bank statement showed an NSF charge of $$575\mathrm{.}00$ for a check received by the company from W$.$ Krueger, a customer, on account.

$($a$)$

Prepare the bank reconciliation as of July $31.($Ust items that increase balance as per bank & books first. Round answers to $2$ decimal places, eg$.52\mathrm{.}75.)$