please do all parts

Description DEP Customer deposit INT Interest earned SF Service fees NOTE Note collected CHK Customer check NSF Nonsufficient funds EFT Electronic funds transfer DC Debit card Additional information: a. The difference in the beginning balances in the company's records and the bank statement relates to check number 530 , which is outstanding as of June 30,2024 . b. The debit card transaction for the purchase of equipment on 7/19 is correctly processed by the bank. c. The EFT on July 26 in the bank statement relates to the purchase of office supplies. Required: 1. Prepare a bank reconciliation for Ravine's checking account on July 31,2024. 2. Record the necessary cash adjustments. Complete this question by entering your answers in the tabs below. Prepare a bank reconciliation for Ravine's checking account on July 31, 2024. (Amounts to be deducted should be indicated with a minus sign. Total entries to the same account together when entering in the bank reconcillation.) Complete this question by entering your answers in the tabs below. Prepare a bank reconcillation for Ravine's checking account on July 31, 2024. (Amounts to be deducted should be indicated with a minus sign. Total entries to the same account together when entering in the bank reconciliation.) Complete this question by entering your answers in the tabs below. Record the necessary cash adjustments. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) Problem 4-38 (Aigo) Prepare the bank reconciliation and record cash adjustments (LO4-5) The cash records and bank statement for the month of July for Ravine incorporated are shown below