with the given information i need help creating a Bank Reconcilliation and a journal entry worksheet. Thank you!

Required: 1. Prepare a bank reconciliation for Hawk'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 Hawk'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.) The cash records and bank statement for the month of July for Hawk Incorporated are shown below. 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 numiber 530 , which 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 Hawk's checking account on July 31, 2024. 2. Record the necessary cash adjustments. Complete this question by entering your answers in the tabs below. Record the necessary cash adjustments. (If no entry is required for a transoctionvevent, select "No Journal Entry Required" in the fint account field.) Journal entry worksheet Record the entries that increase cash. Note: Inter decits tefore credits