P$7\mathrm{.}4($LO $3),$ AP On July $31,2027,$ Keeds Company had a cash balance per books of $$6,140.$ 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.

The bank service charge for July was $$25.$

The bank collected $$1,520$ for Keeds Company through electronic funds transfer.

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.$

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

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

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

Instructions use excel

a$.$ Prepare the bank reconciliation as of July $31,2027.$

b$.$ Prepare the necessary adjusting entries at July $31,2027.$

Prepare a bank reconciliation and adjusting entries.

a$.$ Adjusted cash bal. $$7,024\mathrm{.}00$