On July 31, 2025, Needs Company had a cash balance per books of $6,140.00. The statement from Dakota State Bank on that date showed a balance of $7,690.80. A comparison of the bank statement with the Cash account revealed the following facts. 1.

2.

3.

4.

5.

6.

The bank service charge for July was $25.00.

The bank collected $1,520.00 from a customer for Keeds Company through electronic funds transfer.

The July 31 receipts of $1,193.30 were not included in the bank deposits 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.00 that cleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $348.00.

Checks outstanding on July 31 totaled $1,860.10.

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

Prepare the bank reconciliation as of July 31st listing items that increase balance as per bank and books first.