Please complete the tables below and please be organized

Its just one question

Hathaway Company's general ledger shows a cash account balance of $23,230 on July 31, 2024. Cash sales of $1,785 for the last three days of the month have not yet been deposited. The bank statement dated July 31 shows bank service fees of $45 and an NSF check from a customer of $260. The bank processes all checks written by the company by July 31 and lists them on the bank statement, except for one check totaling $1,360. The bank statement shows a balance of $22,500 on July 31. Required: 1. Prepare a bank reconciliation to calculate the correct balance of cash on July 31, 2024. 2. Record the necessary entry(ies) to adjust the balance for cash. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a bank reconciliation to calculate the correct balance of cash on July 31, 2024. (Amounts to be deducted should be indicated with a minus sign.) HATHAWAY COMPANY Bank Reconciliation July 31, 2024 Bank's Cash Balance Company's Cash Balance Per bank statement Per general ledger Bank balance per reconciliation Company balance per reconciliationHathaway Company's general ledger shows a cash account balance of $23,230 on July 31, 2024. Cash sales of $1,785 for the last three days of the month have not yet been deposited. The bank statement dated July 31 shows bank service fees of $45 and an NSF check from a customer of $260. The bank processes all checks written by the company by July 31 and lists them on the bank statement, except for one check totaling $1,360. The bank statement shows a balance of $22,500 on July 31. Required: 1. Prepare a bank reconciliation to calculate the correct balance of cash on July 31, 2024. 2. Record the necessary entry(ies) to adjust the balance for cash. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Record the necessary entry(ies) to adjust the balance for cash. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) View transaction list nces Journal entry worksheet 2 Record the amounts that increase cash. Note: Enter debits before credits. Date General Journal Debit Credit July 31, 2024Journal entry worksheet V 2 Record the amounts that increase cash. Note: Enter debits before credits. Date General Journal Debit Credit July 31, 2024 No Journal Entry Required Accounts Payable Accounts Receivable Record entry Advertising Expense View general journalView transaction list Journal entry worksheet 2 Record the amounts that decrease cash. Note: Enter debits before credits. es Date General Journal Debit Credit July 31, 2024 No Journal Entry Required Accounts Payable Accounts Receivable Record entry Advertising Expense View general journal