I need the solution to this problem.

The cash records and bank statement for the month of July for Glover Incorporated are shown below. GLOVER INCORPORATED Cash Account Records July 1, 2021, to July 31, 2021 Cash Balance July 31, 2021 $5,810 Cash Balance July 1, Cash 2021 + Receipts $7,430 $8,660 Cash Receipts Date Desc 7/9 Sales 7/21 - Sales 7/31 Sales Amount $ 2,640 3,220 2,800 Date 7/7 7/12 7/19 7/22 7/30 Cash Disbursements $10,280 Cash Disbursements Check Desc. 531 Rent 532 Salaries 533 Equipment 534 Utilities 535 Advertising Amount $ 1,580 2,040 4,300 980 1,380 $10,280 $8,660 Member FDIC 2252790471 P.O. Box 123878 FTOELITY UNION Gotebo, OK 73041 You Can Bank On US (500) 07-08IE Account Holders Glover Incorporated Account Number: 519 Main Street Gotebo, OK 73041 Statement Date: Beginning Balance Deposits and Credits Withdrawals and Debits July 1, 2021 NO. Total NO. Total $8,100 3 $5,918 7 $ 10,208 Deposits and Credits withdrawals and Debits Date Amount Desc. Date No. Amount Desc. 7/10 $2,640 DEP 7/2 530 $ 670 CHK 7/22 3,220 DEP 7/10 531 1,580 CHK 7/31 58 INT 7/14 532 2,040 CHK 7/18 480 NSF 7/22 533 4,888 CHK 7/26 580 EFT 7/30 58 SF July 31, 2021 Ending Balance July 31, 2021 $ 3,810 Daily Balance Date Amount 7/2 $ 7,430 7/10 8,490 7/14 6,450 7/18 5,970 7/22 4,390 7/26 3,810 7/30 3,752 7/31 $3,810 $5,918 $10,208 Additional information a. The difference in the beginning balances in the company's records and the bank statement relates to check #530, which is outstanding as of June 30, 2021. b. Check #533 is correctly processed by the bank. c. The EFT on July 26 relates to the purchase of office supplies. Required: 1. Prepare a bank reconciliation for Glover's checking account on July 31, 2021. (Amounts to be deducted should be indicated with minus sign. Total entries to the same account together when entering in the bank reconciliation.) GLOVER INCORPORATED Bank Reconciliation July 31, 2021 Bank's Cash Balance Company's Cash Balance Per bank statement Per general ledger Bank balance per reconciliation Company balance per reconciliation