NEED DONE ASAP THANK YOU!

Prepare the bank reconciliation as of July 31. (List items that increase balance as per bank books first. Round answers to 2 decimal places, e.g. 2,525.25.) Prepare the necessary adjusting entries at July 31. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. List all debit entries before credit entries. Round answers to 2 decimal places, e.s. 2,525.25.) Question 5 of 5 ./1 eTextbook and Media List of Accounts Question 5 of 5 /1 $ $ $ On July 31, 2025, Ivanhoe Company had a cash balance per books of $6,310,00. The statement from Dakota State Bank on that date showed a balance of $7.860.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $18.00. 2. The bank collected $1,69000 from a customer for Ivanhoe Company through electronic funds transfer. 3. The July 31 receipts of $1,370,30 were not included in the bank deposits for July. Thene recelpts were deposited by the company in a night deposit vault on July 31. 4. Company check No. 2480 issued to L. Trylor, a creditor, for $354.00 that eleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $345.00. 5. Checks outstanding on July 31 totaled $2,003,10 6. On July 31, the bank statement showed an NSF charge of $745.00 for a check received by the company from W. Krueger, a customer, on account. Prepare the bank reconclitation as of July 31. (List items that increase balance as per bank \& books first. Round answers to 2 decimal places, e.g. 2,525.25.) Question 5 of 5 (To record NSF check) July 31 (To correct error in recording check) July 31 (To record bank service charge) eTextbook and Media List of Accounts